Hallo On Thu, Jun 22, 2006 at 01:54:07PM -0500, Dan Buettner wrote: > Christian, I hope raising the open_files_limit helps (I think it > should). I second Brent's suggestion to enable the thread_cache. > > Please do report back and let us know how you fare.
The effect that lots of tables are in "opening tables" and "closing tables" state seems to be solved after increasing the "table_cache" and "open_files_limit" values. We still have a problem where the server sometimes seems to hang on seemingly usual queries but we try an upgrade first as there is no obvious anomaly visible here. bye, -christian- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
