Hello, Mysql has hung (hanged ?) on me when query data (INSERT) was too big to fit in a field. I had this happening when someone was backing up something that went recursively for about 20 dirs downwards (dir1/dir2/dir3/dir1/dir2dir3/dir1 etc). I never discovered what caused this recursion but after I removed this particular path from the backups mysql stopped hanging.
try "mysqladmin processlist" and "mysqladmin version" to see what is going on realtime and release a mysql query (mysqladmin kill). Cheers, Michael Bill Moran wrote: > In response to Damian Lubosch <[EMAIL PROTECTED]>: > >> Hello! >> >> I am using Bacula 2.0.3 with Mysql5 on Debian Etch with a 2.8GHz >> Celeron, 1.5GB RAM, LTO2 drive, 2x 500G (Backup) + 1x80 Disks (System/DB). >> >> I have a machine to backup with about 1-2 million small files (~1kb). >> When I run a migration job for about 4 GB of such data the performance >> is going down. The tape rewinds very often and the overall performance >> is about 3MB/sec. I found out (with top) that the mysql is taking all >> the processing power (together with bacula-sd) when migrating many files. >> On the other hand, when migrating only few large files -backups is >> running fine with 20-30MB/sec. >> >> How can I improve the performance? Are there any tricks I oversaw? > > This sounds like a database optimization problem to me. > > When Bacula is dealing with a lot of small files, performance generally > bottlenecks at the datbase's ability to write new records, and everything > else is held up waiting for the database (thus your tape drive runs out > of data to write and has to shoe-shine). > > I'm not a MySQL expert, so I can't give any DB-specific advice, but you > should look at what can be done to improve MySQL's performance. Is > MySQL actually blocking waiting for free CPU, or is it waiting on disk > IO, for example. > > I'm making a lot of guesses here, but what kind of HDD subsystem do you have? > You may have to invest in faster (i.e. SCSI or SAS) drives to get enough > IO throughput. > > But isolate the problem first. If MySQL is slow, it's slow doing _something_. > Find out what that something is and you'll have a good hint as to what you > need to do. > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
