Re: [Bacula-users] Database performance issues
2011-06-08 12:59:04
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
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.
------------------------------------------------------------------------------
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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|