On Mon, Jul 08, 2013 at 09:49:55PM +0200, Erik P. Olsen wrote:
> 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
>
this sounds like the migration to mariadb also repaired a broken index
automatically that went unnoticed for some time.
I migrated all our catalog instances (six in all, the largest used to
have a 200GB catalog database with over a billion rows in the file
table) to MariaDB over the last year and it's been smooth sailing for
the most part. While performance was better, it certainly didn't
increase by 3 orders of magnitude. What also helped was migrating from
myisam to innodb in the process.
Cheers, Uwe
--
NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA
------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
