Re: [Bacula-users] Performance Issues

Zitat von Rodrigo Abrantes Antunes <rodrigoantunes AT pelotas.ifsul.edu DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users