On 06/08/11 12:16, Gavin McCullagh wrote:
> For simplicity of operation and patching, we're using the Ubuntu archive
> packages which are MySQL 5.1.41. I realise that's quite old now. There
> are one or two restores in particular which take a long time (like 30
> minutes) to build the restore tree. I'm guessing the reason is these
> tables:
>
> -rw-rw---- 1 mysql mysql 7.4G 2011-06-08 13:24 File.MYD
> -rw-rw---- 1 mysql mysql 5.1G 2011-06-08 13:24 File.MYI
> -rw-rw---- 1 mysql mysql 233M 2011-06-08 13:24 Filename.MYI
> -rw-rw---- 1 mysql mysql 161M 2011-06-08 13:24 Filename.MYD
> -rw-rw---- 1 mysql mysql 153M 2011-06-08 13:24 Path.MYI
> -rw-rw---- 1 mysql mysql 99M 2011-06-08 13:24 Path.MYD
>
> Addressing this with a move to PostgreSQL has been on my list but I might
> try a move to InnoDB first as it's likely much simpler.
>
> Assuming that version of MySQL, do you know if the case for InnoDB vs
> MyISAM is still as cut and dry? Would we likely see substantial
> performance improvements?
The performance difference is not going to be *as* large on 5.1, but
particularly in a write-heavy workload such as Bacula, you should still
expect to see a very significant performance improvement. As Jérôme
observed, if you're tied to 5.1, you should use the plugin InnoDB engine
rather than the built-in InnoDB engine if at all possible.
--
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.
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
