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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
