# Time: 120809 9:37:25
# Query_time: 125.364284 Lock_time: 0.000150 Rows_sent: 18 Rows_examined: 27017
SELECT al.id, u.username, u.firstname, u.lastname, al.tbl_user_id, al.ip, al.api_name, al.createtime, al.process_time, IFNULL( concat( firstname, ' ', lastname ) , firstname ) AS fullname
FROM `tbl_api_log` al
LEFT JOIN tbl_user u ON al.tbl_user_id = u.id
where 1=1 AND createtime>'2012-08-09 00:00:00' AND createtime<'2012-08-09 23:59:59' order by process_time desc limit 0,18;1 根据slow log记录,这条语句的查询时间长达 125.364284 秒
2 但是之后单独去myphpadmin中运行这条语句时,确只需要0.1秒左右请问高手,这是咋回事呢?
万谢
# Query_time: 125.364284 Lock_time: 0.000150 Rows_sent: 18 Rows_examined: 27017
SELECT al.id, u.username, u.firstname, u.lastname, al.tbl_user_id, al.ip, al.api_name, al.createtime, al.process_time, IFNULL( concat( firstname, ' ', lastname ) , firstname ) AS fullname
FROM `tbl_api_log` al
LEFT JOIN tbl_user u ON al.tbl_user_id = u.id
where 1=1 AND createtime>'2012-08-09 00:00:00' AND createtime<'2012-08-09 23:59:59' order by process_time desc limit 0,18;1 根据slow log记录,这条语句的查询时间长达 125.364284 秒
2 但是之后单独去myphpadmin中运行这条语句时,确只需要0.1秒左右请问高手,这是咋回事呢?
万谢
2 机器负载过高 导致这条sql执行过慢 机器负载过高未必是数据库造成的
3 当时这条sql走了错的执行计划
SHOW PROCESSLIST只发现了一个进程,应该是属于正常情况所以,如果可能不是锁的问题