On Thu, Jan 17, 2013 at 08:52:32AM -0500, Phil Stracchino wrote: > On 01/17/13 08:33, Uwe Schuerkamp wrote: > > Could we expect to see better db performance by moving to innodb or > > one of MariaDB's fancy new backends? I'm especially interested in > > improving volume recycle times which can be quite long with our setup > > (200GB file table). the DELETE from File where JobId in (.....) can > > take a few hours sometimes. > > InnoDB in general performs considerably better than MyISAM, especially > on current MySQL branches. Percona claims that their XtraDB engine has > a slight performance edge over InnoDB. I don't have any direct > experience with MariaDB yet. > > MyISAM can perform reasonably in an almost-all-read situation, but on > any modern-scale DB, as soon as you start throwing any significant > percentage of writes into the query mix MyISAM performance completely > tanks. I've seen all-MyISAM customer DBs at a complete standstill from > write-contention bottlenecks. >
Well, I guess I'll have to stop backups for a week then and migrate the db over to innodb... or find some clever way involving a myisam master / innodb slave setup. I'll do some reading on the web, thanks! Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnmore_122712 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users