Hi all, I have a serious problem with MySQL 4.1.22 on Solaris 9, SPARC. I have a database server with around 10 or so databases, each with roughly 20-50 tables. At fairly consistent intervals, MySQL gets stuck with 100s of queries in the "Opening tables" state. I have checked the value of my Open_tables and so far, it hasn't gone above my table_cache setting in my.cnf.
If I stop and restart the MySQL server, the problem goes away, likewise if I flush tables. So this doesn't seem to be purely a "load" issue, as I would expect the problem to come straight back again as soon as I restarted or flushed the tables. Any ideas what could explain this, or what I should look at further in order to diagnose the problem and find a possible soultion ? Thanks, -Mark ----------------------------------------------------------------------- This E-mail is from IPC Media Ltd, a company registered in England and Wales, whose registered office is at Kings Reach Tower, Stamford Street, London SE1 9LS, registered number 53626, VAT number 646150645. The contents and any attachments to it include information that is private and confidential and should only be read by those persons to whom they are addressed. IPC Media accepts no liability for any loss or damage suffered by any person arising from the use of this e-mail. Neither IPC Media nor the sender accepts any responsibility for viruses and it is your responsibility to check the email and attachments (if any). No contracts may be concluded on behalf of IPC Media by means of e-mail communications. If you have received this e-mail in error, please destroy and delete the message from your computer. For unbeatable savings on magazine subscriptions and great gift ideas visit www.giftmags.co.uk * IPC Media's head office moves to new headquarters from 2nd April, 2007. The new address will be The Blue Fin Building, 110 Southwark Street, London, SE1 0SU. The new telephone and fax numbers will be available during February. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
