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