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

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.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
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