Re: [Bacula-users] MariaDB or Oracle's MySQL.
2013-07-08 15:52:56
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
|
|
|