Am 3.3.2010 01:55, schrieb Mike Ruskai: > On 3/2/2010 6:39 PM, Richard Hartmann wrote: > >> Hi all, >> >> how many backups can I start at once without causing errors? >> Even with "only" 15 backups starting at once, I get one of the two >> failures below: >> >> Fatal error: sql_create.c:784 Lock Path table Query failed: LOCK >> TABLES Path write, batch write, Path as p write: ERR=Can't find file: >> './bacula/Path.frm' (errno: 13) >> Fatal error: sql_create.c:801 Lock Filename table Query failed: LOCK >> TABLES Filename write, batch write, Filename as f write: ERR=Can't >> find file: './bacula/Filename.frm' (errno: 13) >> >> >> > That's MySQL complaining about not finding table files. Check its > configuration for the value of "open_files_limit". Increase the value > if it's small. If it looks large enough, check your system > configuration for restrictions on the number of open files. > Just as a side note: I had good results finding bottlenecks in my MySQL setup using the tuning-primer shell-script. It can be found using Google or maybe here: http://forge.mysql.com/projects/project.php?id=44 If open_files_limit is too low it will most likely tell you.
Hope this helps! M. Müller ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
