On 9/7/06, Tim Donahue <[EMAIL PROTECTED]> wrote:
Make sure that you have your 'open-files-limit' parameter set to a sane value in your my.cnf. If you don't have anything set for that limit the default is extremely low (so low that using views tended to not work on my dev box). I have been using "open-files-limit = 8192", however YMMV.
FYI, I was suggested to use this setting to correct what looked like all the databases in mysql getting DROPed after a short time (an hour or so) of light use. I soon after noticed this in /var/mysql/$host.err the file:
060830 22:37:02 [Warning] Could not increase number of max_open_files to more than 1772 (request: 8192)
...so I bumped it down to 1024 and all has been well enough. -- -- Matthew Peltzer -- [EMAIL PROTECTED]
