Re: [Bacula-users] Bacula MySQL Tuning
2014-11-21 06:55:07
Many thanks! But tried to recreate a new database and catalog since I stuck there for some times. Now, the backup job was running and doing volume 3 data backup. Hope it will be accomplished in this weekend.
BTW, any advise/references of tuning "DB dir inserting" faster? Thanks in advance!
Mr. Keith: some MySQL specific hints provided by Kern when doing his presentation here in Brazil:
1. MySQL configuration: sort_buffer_size = 2MB 2. MySQL configuration: innodb_buffer_pool = 128MB 3. Use mysqltuner
Regards, ============================================================================== Heitor Medrado de Faria - LPIC-III | ITIL-F ===============================================================================
De: "Keith T" <keithbacu AT yahoo DOT com> Para: heitor AT bacula.com DOT br Cc: "Bacula-users at lists.sourceforge.net" <bacula-users AT lists.sourceforge DOT net> Enviadas: Sexta-feira, 21 de novembro de 2014 6:35:21 Assunto: Re: [Bacula-users] Failed on backup volume 2 suddenly
Hi Heitor,
Many thanks! But tried to recreate a new database and catalog since I stuck there for some times. Now, the backup job was running and doing volume 3 data backup. Hope it will be accomplished in this weekend.
BTW, any advise/references of tuning "DB dir inserting" faster? Thanks in advance!
On Wednesday, November 12, 2014 8:35 PM, "heitor AT bacula.com DOT br" <heitor AT bacula.com DOT br> wrote: Keith,
Did you check this? It's for MySQL, but for PgSQL I think would be the same logic. Fixing table 'bacula.batch' doesn't existNewer versions of Bacula create a temporary working table in order to do batch inserts, which can greatly speed up inserting attributes into the catalog. Unfortunately, if the MySQL connection gets dropped for any reason (such as a timeout) the temporary table goes away. If you're seeing these problems, there are two workarounds. The simplest one is to turn off batch inserts. This will revert to the older, somewhat slower behavior, but it should avoid this particular glitch. The other option is to alter the MySQL timeouts to a sufficiently long value that the connection never gets yanked out from under Bacula. For example, adding these two lines to your my.cnf file in the [mysqld] block will set the relevant timeouts to 8 days. wait_timeout=691200
interactive_timeout=691200 Future versions of MySQL will automatically set the timeout values, which should prevent the problem without requiring changing the global MySQL timeout values.
What I mean: it's not a database integrity problem, it should be fine, and perhaps the error you should observe is the abrupt backup connection termination. ========================================================================= Heitor Medrado de Faria Faltam poucos dias - Treinamento Telepresencial Bacula: http://www.bacula.com.br/?p=2174 61 2021-8260 | 8268-4220 Site: www.bacula.com.br | Facebook: heitor.faria | Gtalk: heitorfaria AT gmail DOT com ==========================================================================
------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users AT lists.sourceforge DOT net https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|