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), [EMAIL PROTECTED] 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