|
[Bacula-users] Database performance issues
2011-06-08 10:30:40
Hi All,
We have a setup with bacula-dir/MySQL and bacula-sd (2 servers) and a SAN connected via fiber. We are running bacula with about 250 jobs a day. The table File is about 500M records with a size of about 100G. We use batch insert. All tables are MyISAM. Currently we are experiencing performance problems with the database.
For all jobs we do a disk-to-disk backup. The next day we use a copyjob to put the data on tape. During daytime we run the copy jobs and during the evening/night we run the disk-to-disk jobs. There is some overlap. When the the disk-to-disk jobs start, we see number of queries on the database drop to virtually 0.
There are a few options to solve this
- use innodb for the tables in MySQL
- migrate to PostgreSQL
Can anyone advise me what to do, to increase the performance of our platform?
Kind regards,
Enrico van Goor
------------------------------------------------------------------------------
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
|
| <Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Bacula-users] Database performance issues,
Enrico van Goor <=
|
|
|
