Hi,
I made a base job, on a server which have above 200.000 files. After, I made a full backup for trying deduplication. The backup works well and create a full backup with a big deduplication (above 90%).
But, at the end of the backup, normally bacula show a status message, but the console is frozen and mysql is at 100% on CPU.
On mysql I've got :
mysql> show processlist; +----+------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 88 | root | localhost | bacula | Query | 2395 | Copying to tmp table | INSERT INTO BaseFiles (BaseJobId, JobId, FileId, FileIndex) SELECT B.JobId AS BaseJobId, 39 AS JobId | | 90 | root | localhost | bacula | Sleep | 2395 | | NULL | | 91 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----+------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ 3 rows in set (0.00 sec)
Is it normal that the request is very long or is it a bug ? Server is with Xeon 2Ghz CPU.
Thanks,
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|