Bacula-users

Re: [Bacula-users] MariaDB or Oracle's MySQL.

2013-07-08 15:52:56
Subject: Re: [Bacula-users] MariaDB or Oracle's MySQL.
From: "Erik P. Olsen" <epodata AT gmail DOT com>
To: bacula-users AT lists.sourceforge DOT net
Date: Mon, 08 Jul 2013 21:49:55 +0200
On 08/07/13 19:48, Phil Stracchino wrote:
> On 07/08/13 12:15, Erik P. Olsen wrote:
>> I have been using Oracle's mysql several years and one of the worst
>> problem with it has been restore times, especially the time it takes to
>> generate the file selection tree. When fedora 19 became available and
>> with the information that they supported MariaDB I decided to give it a
>> try. And much to my surprise I found that the time to file selection was
>> improved considerably. It used to be measured in hours  with MariaDB it
>> is down to few seconds. A pleasant surprise.
>
> I would be interested to see a comparison of the configuration and
> versions for both DB installations.  I find it implausible that a switch
> from community-edition MySQL to a comparable-version MariaDB, *with no
> other changes*, could yield a three-orders-of-magnitude performance gain
> for the same query.
>
>
There were no other changes.

-- 
Erik

Concordia parvæ res crescunt discordia maximæ dilabuntur

------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>