On Fri, Apr 23, 2010 at 10:52:41AM +0200, Eric Bollengier wrote: > Le vendredi 23 avril 2010 10:52:49, Graham Keeling a écrit : > > On Fri, Apr 23, 2010 at 10:31:49AM +0200, Eric Bollengier wrote: > > > For normal Accurate backup, it uses dedicated connection since the > > > beginning, so it's shouldn't block commands too. > > > > I do not think this works because for me, the 'status director' command > > blocks until the accurate query is complete. > > Very strange, maybe a MySQL limitation with table locking, but it's hard to > believe (Accurate stuff does only SELECTs). > > Can you did into it with something like mysqladmin processlist to check what > happen ? > > Are you using MyISAM or Innodb ?
Sorry, I was mistaken. I no longer think that 'status director' locks up when doing an accurate query. We are using MyISAM. Thank you, and Craig, for the debug suggestions which will probably come in handy in the future. I think that the point still stands for virtual and restores though. Perhaps it will be worth trying the multiple connections option, as suggested. ------------------------------------------------------------------------------ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
