MySQL Forums
Forum List  »  General

MySQL query state
Posted by: Joakim Ryden
Date: December 02, 2004 12:18AM

Hey everyone -

I just migrated a database from one server to another (4.0.18 official RPM on RH ES 3) and now on the new server I'm running into a problem where queries hang in state "statistics" as shown by 'mysqladmin processlist'. I tried to see if there was something wrong with the queries themselves and went and grabbed one of them from "show full processlist" and tried to run it with 'explain' and that hung too. Tried the same thing on the old server and everything seems perfectly fine. Running out of ideas. :( Does anyone have any tips at all??

--Jo

Options: ReplyQuote


Subject
Written By
Posted
MySQL query state
December 02, 2004 12:18AM
February 28, 2005 11:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.