[Bacula-users] bacula and slow queries
2008-05-24 11:15:50
hi all, Im using bacula 1.38 for make backup of 2 servers that has almost the same setup, the only difference is the number o files. One server have +/- 400.000 files, and the second have +/- 1.200.000 files. The size of data is almost the same too: 460GB. I have add lots of indexes for mysql, i used optimize table but the second server spends +/- 4 hours to show the list of files when is want to restore something ( restore command with only one jobid ), against 5 mins for the first server. I know that the base for the second server has a lot of lines more than the first, but my question is "how can i do this job more faster??" because this twos server are good machines, and during this time ( query to mysql ) the machine has just 25% of processor used. I already try buffer_size , ram used for mysl, put the base ( mysql base ) is a single disk, in a raid5 disk, nut none o this solve my problem. Can anyone help-me?
JC
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________
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] bacula and slow queries,
junior carvalho <=
|
|
|