728x90
반응형
Mysql log 확인 및 lock 걸리는 부분 확인하기
<로그 확인 결과>
1. peugeot_crm_2010 테이블에 대하여 table crash 상태인 것으로 보이며
2. Sort aborted -> 메모리가 부족한 것으로 판단됩니다.
<에러 로그>
# vi /var/log/mysqld.log
140711 15:08:30 [ERROR] /usr/libexec/mysqld: Table './peugeot_crm_2010/LOGIN_LOG' is marked as crashed and should be repaired
140711 15:08:30 [ERROR] /usr/libexec/mysqld: Table './peugeot_crm_2010/LOGIN_LOG' is marked as crashed and should be repaired
140711 15:08:30 [ERROR] /usr/libexec/mysqld: Table './peugeot_crm_2010/LOGIN_LOG' is marked as crashed and should be repaired
140711 15:08:30 [ERROR] /usr/libexec/mysqld: Table './peugeot_crm_2010/LOGIN_LOG' is marked as crashed and should be repaired
140711 15:08:30 [ERROR] /usr/libexec/mysqld: Table './peugeot_crm_2010/LOGIN_LOG' is marked as crashed and should be repaired
140712 13:02:30 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:03:07 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:03:30 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:04:00 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:04:47 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:05:23 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:05:57 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:06:26 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:07:21 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:07:48 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:08:33 [ERROR] /usr/libexec/mysqld: Sort aborted
140712 13:08:57 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 9:45:51 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 9:46:18 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 9:53:18 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 9:53:31 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 10:10:26 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 10:11:50 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 10:12:00 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 10:12:12 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 10:12:18 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 10:12:22 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 10:12:33 [ERROR] /usr/libexec/mysqld: Sort aborted
140714 10:14:00 [ERROR] /usr/libexec/mysqld: Sort aborted
<메모리 사용량>
Mem: 2034868k total, 1811448k used, 223420k free, 40500k buffers
Swap: 4192924k total, 399556k used, 3793368k free, 1154876k cached
<테이블 체크>
mysql> check table peugeot_crm_2010;
+------------------------+-------+----------+----------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------------+-------+----------+----------------------------------------------+
| mysql.peugeot_crm_2010 | check | Error | Table 'mysql.peugeot_crm_2010' doesn't exist |
| mysql.peugeot_crm_2010 | check | error | Corrupt |
+------------------------+-------+----------+----------------------------------------------+
2 rows in set (0.00 sec)
해당 테이블에 대하여 확인 필요, 메모리 부족에 대해서는 메모리 증설함으로써 해결할 수 있을 것으로 판단됨.
반응형
'OS' 카테고리의 다른 글
| mysql master-slave 설정 ( mysql replication ) (0) | 2014.09.15 |
|---|---|
| php에서 https로의 소켓 접속 ( fsockopen, fsocket이라고도 함 ) (0) | 2014.09.15 |
| scan ssh (0) | 2014.09.14 |
| Windows 세션 및 PID 확인 -> netstat (0) | 2014.09.14 |
| history 조회 시 날짜,시간 표시 (0) | 2014.09.14 |