Bacula-users

[Bacula-users] Perfomance improvement moving from mysql 5.0 to 5.1 or 5.5?

2011-08-28 09:24:50
Subject: [Bacula-users] Perfomance improvement moving from mysql 5.0 to 5.1 or 5.5?
From: "Maria Arrea" <maria_arrea AT gmx DOT com>
To: Bacula Users bacula-users <bacula-users AT lists.sourceforge DOT net>
Date: Sun, 28 Aug 2011 15:22:01 +0200
Hello

We are using bacula 5.0.3 with mysql 5.0.77 on RHEL 5.7 x64. We are backing tens millons of file and we are staring to see performance problems with mysql. Our server has 6 GB of ram and 1 quad core Intel Xeon E5520 @2.27 Ghz.

We have converted from MyISAM to InnoDB in our mysql, and we have seen some performance improvements. Doe anybody know if migrating mysql 5.0 to 5.1 or 5.5 will improve performance with innodb? We have tried to migrate from mysql to postgresql with no luck (
http://mtu.net/~jpschewe/blog/2010/06/migrating-bacula-from-mysql-to-postgresql/) though.

Maybe more ram would increase also performance? We are using my-innodb-heavy-4G.cnf as mysql config file.

Regards

Maria

------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management 
Up to 160% more powerful than alternatives and 25% more efficient. 
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>