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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users