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.