> Any thoughts? What kind of internal locks might be generated? Is there
> another command I can run to get the status of those queries that are
> hanging? It shows 'None' for the state (NULL), I've never seen a
Aha.. So I had a brainstorm while driving to lunch. Is it possible
this is
Hi,
We have recently upgraded to MySQL 4.0 (binary) from 3.23.50, and we
are seeing *all* MySQL queries freeze up every morning for about 25
seconds. I don't believe this is the standard run-of-the-mill MyISAM
locking problem people tend to run into, as queries in separate
databases hang,