All Queries Hanging/Freeze: Trying to perform Select 1

2004-08-24 Thread Joe Kislo
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

Re: All Queries Hanging/Freeze: Trying to perform Select 1

2004-08-24 Thread Joe Kislo
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