I noticed that when doing a backup mysql seems to be using most of
the time doing SELECTs:
yangtse ~ % /usr/local/mysql/bin/mysqladmin -u root processlist
+------+------+-----------+--------+---------+------+--------------
+-----------------------------------------------------------------------
----------+
| Id | User | Host | db | Command | Time | State |
Info
|
+------+------+-----------+--------+---------+------+--------------
+-----------------------------------------------------------------------
----------+
| 7224 | root | localhost | bacula | Query | 0 | Sending data |
SELECT FilenameId FROM Filename WHERE
Name='trainNeckarArray.sh.o1087190.27859' |
| 7347 | root | localhost | | Query | 0 | |
show
processlist
|
+------+------+-----------+--------+---------+------+--------------
+-----------------------------------------------------------------------
----------+
When I show the processlist several times in a row it is nearly
always SELECTing some filename in the Filename table. Mysql is using
~100% CPU so this seems to be the bottleneck in this case. An index
in the Name column does exist. The Filename table is not extremely
big, roughly at ~500MB with ~1 million rows.
I'm getting backup rates at ~15M/s but I would expect ~30M/s (dir, sd
and fd on same machine backing up to LTO-2 drive). This is bacula
version 1.38.5.
Does someone have an idea how to speed things up?
-Sebastian
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
