|
1. mysql log 파일을 보니 Current locks 라고 뜨는 부분이 발견되어 업체 현업쪽에서 문제를 삼는데요
그 부분이 정말 lock 이 걸려서 그런건지.. 아니면 mysql 서버 재기동시 나오는 메시지인지 알고 싶습니다.
아래는 서버 로그입니다.
==================================================================
130710 09:42:46 mysqld started
130710 9:42:47 InnoDB: Started; log sequence number 0 26482273
130710 9:42:47 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.51a-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
Status information:
Current dir: /usr/local/var/
Running threads: 8 Stack size: 196608
Current locks:
lock: 0x91ecee0:
lock: 0x920105c:
lock: 0x9252b40:
lock: 0x92746e0:
lock: 0x920c7d0:
lock: 0x91fbbb0:
lock: 0x8980c278:
lock: 0x89802290:
lock: 0x91f10d8:
lock: 0x91b7028:
lock: 0x91b6078:
lock: 0x91abc08:
lock: 0x91a8408:
lock: 0x919c9c8:
lock: 0x91957d0:
lock: 0x9198cd0:
lock: 0x917f010:
lock: 0x9130c88:
lock: 0x9117360:
lock: 0x9160514:
lock: 0x898034b8:
lock: 0x910bb38:
lock: 0x910b110:
lock: 0x9114bd8:
lock: 0x910fba0:
lock: 0x910f9b0:
lock: 0x910f7c0:
lock: 0x90ea020:
lock: 0x90f48b4:
lock: 0x90ef554:
lock: 0x90eb0f4:
lock: 0x90de1b4:
lock: 0x90daab4:
lock: 0x90d5d74:
Key caches:
default
Buffer_size: 671088640
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 4
not flushed: 0
w_requests: 0
writes: 0
r_requests: 64
reads: 4
handler status:
read_key: 201492
read_next: 85124
read_rnd 33100
read_first: 9390
write: 396405
delete 0
update: 0
Table status:
Opened tables: 43
Open tables: 37
Open files: 17
Open streams: 0
Alarm status:
Active alarms: 8
Max used alarms: 17
Next alarm time: 27731
130710 19:45:51 mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130710 19:45:51 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Last MySQL binlog file position 0 142170490, file name /usr/local/var/server1-bin.000007
130710 19:45:52 InnoDB: Started; log sequence number 0 26678124
130710 19:45:52 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.51a-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
130710 19:54:23 [Note] /usr/local/libexec/mysqld: Normal shutdown
130710 19:54:26 InnoDB: Starting shutdown...
130710 19:54:28 InnoDB: Shutdown completed; log sequence number 0 26678407
130710 19:54:28 [Note] /usr/local/libexec/mysqld: Shutdown complete
130710 19:54:28 mysqld ended
130710 19:54:34 mysqld started
130710 19:54:34 InnoDB: Started; log sequence number 0 26678407
130710 19:54:34 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.51a-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
==================================================================================
2. lock을 확인 하기 위하여 show full processlist 를 실행시키니 아래와 같은 결과가 나왔습니다.
아래의 프로세스들이 모두 lock인건지 state에 아무 정보도 없어서 난감합니다.
+-----+------+-----------------------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------------------+------+---------+------+-------+-----------------------+
| 676 | user | | user | Sleep | 57 | | NULL |
| 677 | user | | user | Sleep | 57 | | NULL |
| 678 | user | | user | Sleep | 87 | | NULL |
| 679 | user | | user | Sleep | 95 | | NULL |
| 680 | user | | user | Sleep | 27 | | NULL |
| 979 | user | | user | Sleep | 2349 | | NULL |
| 981 | user | | user | Sleep | 2346 | | NULL |
| 983 | user | | user | Sleep | 2334 | | NULL |
| 991 | user | localhost | user | Query | 0 | NULL | show full processlist |
+-----+------+-----------------------+------+---------+------+-------+-----------------------+
HOST 정보는 삭제하였습니다.
위 관련 문제로 몇일동안 헤메고 있습니다.
답변주시면 정말 많은 도움이 될듯합니다.
|
