Serious MySQL loading problem
Posted: Mon Jun 14, 2004 3:43 pm
We moved to a new server last week and since then we're having some serious problems. The database has been slowing to a halt, giving "too many connection" errors (for which we simply increased the max_connections and that's solved that). One thing I have noticed is that mysqladmin status is showing LOTS of open tables. And it keeps growing. Apparently these tables are never being closed. The underlying code has not really changed. I have added some pages that require MORE queries but watching mytop, these queries don't appear to be the problem at all. I've disabled one particularly nasty query that was causing lots of trouble (running updates on potentially hundreds of tables) but this has only slowed the problem, not eliminated it.
We did upgrade to 4.0.20 with the server switch. This is on Linux Redhat ES 3.0.
So I guess my first question is: why would tables be opened and then never closed?
We did upgrade to 4.0.20 with the server switch. This is on Linux Redhat ES 3.0.
So I guess my first question is: why would tables be opened and then never closed?