On 14.02.2006, at 19:12, Arno Lehmann wrote:
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?
How about adding an index? I've got one on the Filename column.
There is no Filename column.
mysql> DESCRIBE Filename;
+------------+------------------+------+-----+---------
+----------------+
| Field | Type | Null | Key | Default |
Extra |
+------------+------------------+------+-----+---------
+----------------+
| FilenameId | int(10) unsigned | | PRI | NULL |
auto_increment |
| Name | blob | | MUL |
| |
+------------+------------------+------+-----+---------
+----------------+
mysql> SHOW INDEX FROM Filename;
+----------+------------+----------+--------------+-------------
+-----------+-------------+----------+--------+------+------------
+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type |
Comment |
+----------+------------+----------+--------------+-------------
+-----------+-------------+----------+--------+------+------------
+---------+
| Filename | 0 | PRIMARY | 1 | FilenameId |
A | 9665081 | NULL | NULL | | BTREE
| |
| Filename | 1 | Name | 1 | Name |
A | 9665081 | 30 | NULL | | BTREE
| |
+----------+------------+----------+--------------+-------------
+-----------+-------------+----------+--------+------+------------
+---------+
-------------------------------------------------------
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
