Good moring, thank you for your answer.
ok just a word before, I had an installation (bacula 2.4.4 and 3.0.3) before which worked with the mysql configuration. I upgraded to 5.0 and it still worked out. Than I changed my complete environment and thought that a fresh installation of bacula is a good idea. Indeed it seems to be the case it was not :D ..... I adjusted and played yesterday evening with these key configurations: key_buffer = 256M max_allowed_packet = 128M table_cache = 256 sort_buffer_size = 128M read_buffer_size = 128M read_rnd_buffer_size = 128M myisam_sort_buffer_size = 128M thread_cache_size = 8 query_cache_size= 128M My System: RAM: 1246MB CPU: 3,0 GHz Athlon XP Debian 5.0 lenny R4 Mysql: 5.0.51a-24+lenny3 Bacula: 5.0.0 Database Size: 54 MB Database Typ: MyISAM (default with the make _database Script of bacula ?!) Htop shows me that mysql takes 7,9 % of total memory when doing a query. I watched with mysqladmin and I saw that the mysql process is executing the query command. This takes years. I change the above configuration number not just once and increase them also significantly (nearly to 1 GB) but the mysql process still remains with ~8% Mem usage. Thank for your help Regards Torsten Am Montag 15 Februar 2010 20:05:42 schrieb Arno Lehmann: > Hi, > > 15.02.2010 15:32, Torsten Maus wrote: > > Hey guys, > > > > I have a problem, I installed bacula 5.0 on da fresh machine (fresh Mysql > > Server) > > > > My Systems looks like: > > > > - debian lenny > > - Mysql 5.0 > > - Bacula 5.0 > > > > When I start a backup, the bacula service automated label volumes in the > > appropriate size (so everything works). > > > > When I now run a restore it happens the following: > > > > 1. when I want to run restore I do the following: > > > > * restore > > > > * 5 > > > > Now the bacula server begin to query and build the tree, the CPU usage > > auf my mysql process launches to 100% and that is it, no change, the > > file tree is not build. > > So I would check what MySQL is doing - start with 'mysqladmin -v > processlist' to see if it's the database still querying, or if the > database already sends data to Bacula. > > In the first case, you should probably start by tuning your MySQL > installation (which in turns means you first find which resources are > limiting performance), in the latter case you need to look at what > Bacula does. > > My impression is that MySQL is getting slow because it's lacking > memory. You may be able to verify that using top, vmstat, sar, or > other such tools. Those might even quickly point you to the things you > should change in your system. > > > 2. If I run a restore with a "small" job (1 or 2 files) like the backup > > catalog the tree is builded whin a second. > > > > But I can not restore "big" job oder even normal backups. > > > > What has happend ? and why, Backup without restore is somehow not > > suffient :) > > What has happened? - Well, you told us yourself: You just installed > and didn't do any performance tuning :-) > The reasons for that are hopefully known to you ;-) > > By the way - to get more directed help, or even confirmation from > others that, what you find slow can be faster, you should also tell us > about > RAM in computer > CPU(s) > exact MySQL version > database engines used > database sizes (numbers of rows in the critical tables) > memory in use by MySQL and bacula during the tree building process > the relevant MySQL configuration > > Cheers, > > Arno > > > Regards > > > > Torsten -- Torsten Maus torsten.m...@dass-it.de dass IT GmbH Phone: +49.221.3565666-98 http://www.dass-IT.de Fax: +49.221.3565666-10 Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRB52500 Geschäftsführer: S. Dühr, M. Außendorf, J. Steffens, Philipp Storz ------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
