[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-bugs
Subject:    [Bacula-bugs] [Bacula Bug Reports 0002034]: Slow Update Catalog using temporary batch table when usi
From:       Mantis Bug Tracker <nobody () bugs ! bacula ! org>
Date:       2014-07-05 16:15:41
Message-ID: 42c649e42762339610f81f1783dad5bd () bugs ! bacula ! org
[Download RAW message or body]


The following issue has been CLOSED 
====================================================================== 
http://bugs.bacula.org/view.php?id=2034 
====================================================================== 
Reported By:                jordiclariana
Assigned To:                
====================================================================== 
Project:                    Bacula Bug Reports
Issue ID:                   2034
Category:                   Director
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             2014-03-11 12:15 GMT
Last Modified:              2014-07-05 17:15 BST
====================================================================== 
Summary:                    Slow Update Catalog using temporary batch table when
usin InnoDB
Description: 
I am using Bacula connected to a MySQL server and we have very slow backups. I
traced the problem to the batch insert into temporary table in MySQL.
We have Mysql configured to always create table with InnoDB engine setting this
in our /etc/mysql/my.cnf:
default_storage_engine = InnoDB

This leads to temporary tables created with InnoDB engine as well. But it seems
that batch process is way too slow using InnoDB table. With InnoDB as default
engine, I have as much as 10 queries per second. Just changing default engine to
MyISAM I get at least 150 queries per second.

The "CREATE TEMPORARY TABLE" statement, which is embedded in the Bacula code, do
not specify the Engine, and it should to prevent this.
Besides, MySQL>=5.5 default engine is InnoDB, so this is not a trivial problem.



Steps to Reproduce: 
Configure Bacula to use MySQL.
Set in my.cnf config: default_storage_engine = InnoDB
Run a regular backup.


Additional Information: 
An easy solution could be adding "ENGINE MyISAM" at the end of the "CREATE
TEMPORARY TABLE" statement.
====================================================================== 

---------------------------------------------------------------------- 
 (0006946) kern (administrator) - 2014-07-05 17:15
 http://bugs.bacula.org/view.php?id=2034#c6946 
---------------------------------------------------------------------- 
I am not convinced that it is a good idea for Bacula to force any particular
type of database engine.  This is the user's responsibility.

What would seem to me appropriate would be to document the problem you found and
propose a solution that the user can implement.

Please submit a patch for the documentation, and I will apply it. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2014-03-11 12:15 jordiclariana  New Issue                                    
2014-07-05 17:15 kern           Note Added: 0006946                          
2014-07-05 17:15 kern           Status                   new => closed       
2014-07-05 17:15 kern           Resolution               open => no change
required
======================================================================



------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Bacula-bugs mailing list
Bacula-bugs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-bugs
[prev in list] [next in list] [prev in thread] [next in thread]