lists.zerezo.com
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

***BOGO*** Why did the procedure spend so much time to analyze?

When my database machine's load is too high,the procedure spend more much
time than normal use.
Here is my mysqldumpslow 's result.
Count: 5  Time=6.60s (33s)  Lock=0.00s (0s)  Rows=1.0 (5),
web_131[web_user]@[192.168.0.228]
  SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='site' AND
ROUTINE_NAME='sp_get_comic'

Any reply is appreciated.Thanks.

-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn