포럼
디버깅 메시지를 보니 xe_counter 관련 오류가 종종 보이네요.
2012.11.23 00:26
_debug_db_query.php에는
Array
(
[query] => INSERT INTO `xe_counter_status`
(`regdate`, `unique_visitor`, `pageview`)
VALUES (0, 0, 0)
[elapsed_time] => 0.000308036804199219
[connection] => Master localhost
[module] => page
[act] => IS
[query_id] => counter.insertTodayStatus
[time] => 2012-11-23 00:01:59
[result] => Failed
[errno] => 1062
[errstr] => Duplicate entry '0' for key 'PRIMARY'
)
_db_slow_query.php 에는
2012-11-23 00:14 SELECT count(*) as `count` FROM `xe_counter_log` as `counter_log` WHERE `site_srl` = 0 and `ipaddress` = '213.186.127.8' and `regdate` like '20121123%'
1.495186 sec query_id:counter.getCounterLog
이런 식으로 에러와 느린 쿼리를 계속 기록하네요.
