Dear All, I have problem with my MYSQL v5.0 today, for Command Select is very fast, but for the command UPDATE it's take time, Mysql will take 30 second (Sleep mode), after that, the query (Update) will be execute. Look like very strange. I have check the system, there is idle/no have activity, but why the mysql must wait till 30 seconds to process this query. FYI, I'm use Innodb engine.
Anybody can help me to solve this problem or you ever have problem like me. Best Regards, Suwandi [Non-text portions of this message have been removed]
