[prev in list] [next in list] [prev in thread] [next in thread]
List: bacula-users
Subject: [Bacula-users] Performance Issues
From: Rodrigo Abrantes Antunes <rodrigoantunes () pelotas ! ifsul ! edu ! br>
Date: 2012-09-24 20:54:53
Message-ID: 20120924175453.Horde.RkzZYkv4Cn9QYMid4-0hWAA () webmail ! pelotas ! ifsul ! edu ! br
[Download RAW message or body]
This message is in MIME format.
[Attachment #2 (multipart/alternative)]
This message is in MIME format.
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.
[Attachment #5 (text/html)]
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body style="font-family:Arial;font-size:14px">
<p>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" :<br> \
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+<br>
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | \
Cardinality | Sub_part | Packed | Null | Index_type | Comment |<br> \
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+<br>
| File | 0 | \
PRIMARY | 1 | \
FileId | \
A | 7924758 \
| NULL | NULL | | \
BTREE | \
|<br> | File | 1 | \
JobId \
| 1 | \
JobId | \
A \
| 915 | NULL \
| NULL | | \
BTREE | \
|<br> | File | 1 | \
JobId_2 | 1 | \
JobId | \
A \
| 915 | NULL \
| NULL | | \
BTREE | \
|<br> | File | 1 | \
JobId_2 | 2 | \
PathId | \
A | \
102918 | NULL | NULL \
| | BTREE \
| |<br> | File \
| 1 | JobId_2 \
| 3 | \
FilenameId | A \
| 7924758 | NULL | NULL \
| | BTREE \
| |<br> \
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+<br>
<br>
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.<br> \
<br> Thanks.</p>
</body>
</html>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic