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
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
