묻고답하기
슬로우 쿼리 보실줄 아시는분 계신가요?
2015.03.19 14:51
# Query_time: 3.006232 Lock_time: 0.000022 Rows_sent: 131430 Rows_examined: 131430
SET timestamp=1417374685;
SELECT * FROM ``.`xe_counter_log`;
# Time: 150318 9:53:01
# User@Host: [] @ localhost []
# Query_time: 4.047393 Lock_time: 0.000805 Rows_sent: 1 Rows_examined: 10058
use ;
SET timestamp=1426639981;
SELECT * FROM `xe_ncart` as `ncart` WHERE `non_key` = '20150318095250019751267077' and `order_status` = 0 ORDER BY `regdate` desc;
# Time: 150318 12:03:55
# User@Host: [] @ localhost []
# Query_time: 3.902974 Lock_time: 0.000090 Rows_sent: 3 Rows_examined: 10064
SET timestamp=1426647835;
SELECT * FROM `xe_ncart` as `ncart` WHERE `non_key` = '20150318114226048645661499' and `order_status` = 0 ORDER BY `regdate` desc;
이쪽에서 슬로우 쿼리가 발생한다구 하는데
어떻게 해주어야 할까요?ㅠㅠ