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.


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

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