On 03/02/11 04:43, Eric Bollengier wrote: > Hello Phil, > > Le mardi 01 mars 2011 14:58:04, Phil Stracchino a écrit : >> I was looking into what Bacula was doing in the DB this morning, with a >> MySQL catalog, to see why last night's backup jobs stalled. As a result >> of my investigations, I have two questions: >> >> 1. >> If dbcheck finds that either of the two indices it needs are missing, >> why does it only offer to create temporary indices, instead of offering >> to create the indices once and have done with it? > > Because these indexes slow down files and attributes insertion, and speed up > dbcheck. So, as you insert files more often than you run dbcheck, we decided > to create/delete these indexes on the fly. But, feel free to add them > permanently.
That makes perfect sense. > You have to know that until mysql 5.1.21 and with a special configuration > option that breaks the replication (if used), you can't run two batch > insertion process at the same time on innodb. > > see > http://sf.net/apps/wordpress/bacula/2009/11/12/handle-multiple-jobs-in- > parallel-with-innodb/ Just looked at that. I note that innodb_autoinc_lock_mode=2 does not *break* MySQL replication per se, but is unsafe with statement-based replication. It is entirely safe with row-based replication. I don't actually know how it interacts with replication mode MIXED, which permits both row and statement replication events at MySQL's discretion, but I will see what I can find out. InnoDB is in general designed to try to avoid locking entire tables whenever possible, and performs much better when table locks can be avoided. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. ------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
