Zitat von Rodrigo Abrantes Antunes <rodrigoantu...@pelotas.ifsul.edu.br>:
> Hi, when restoring, listing files, backing up, purging or pruning mysql > process uses 100% CPU and the machine is unusable, and such operations last > to long. Doing some research I found that this can be related to database > indexes, but I didn't understanf well what I need to do .Here is the output > of "show index from File" : > > +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | > Cardinality | Sub_part | Packed | Null | Index_type | Comment | > > +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > | File | 0 | PRIMARY | 1 | > FileId | A | 7924758 | NULL | > NULL | | BTREE | | > | File | 1 | JobId | 1 | > JobId | A | 915 | NULL > | NULL | | BTREE | | > | File | 1 | JobId_2 | 1 | > JobId | A | 915 | NULL > | NULL | | BTREE | | > | File | 1 | JobId_2 | 2 | > PathId | A | 102918 | NULL | > NULL | | BTREE | | > | File | 1 | JobId_2 | 3 | > FilenameId | A | 7924758 | NULL | > NULL | | BTREE | | > > +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > > Is this right? If not what do I need to do to make it right? My server has > 2 dual-core CPUs with 16gb ram and is dedicated to bacula. RAM usage is > normal. > > Thanks. Hello Bacula uses the database for meta-data operation which can lead to high insert rates and scanning large tables. Databases are sensitive to I/O performance so you should check if your I/O is up to the task and if MySQL is tuned for this kind of usage. Regards Andreas ------------------------------------------------------------------------------ Got visibility? Most devs has no idea what their production app looks like. Find out how fast your code is with AppDynamics Lite. http://ad.doubleclick.net/clk;262219671;13503038;y? http://info.appdynamics.com/FreeJavaPerformanceDownload.html _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
