show processlist; 秀出來的訊息
3070874 aimodeln_data localhost aimodeln_db Query 3126 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ‘f1a2c7cf9e56d91f2
3070882 aimodeln_data localhost aimodeln_db Query 3121 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ‘ed110006d613a0279
3070891 aimodeln_data localhost aimodeln_db Query 3112 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ‘ed110006d613a0279
3070895 aimodeln_data localhost aimodeln_db Query 3109 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ‘a11eca8dd70cbef4e
3070902 aimodeln_data localhost aimodeln_db Query 3101 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ‘2fc62be40853c35ec
3070941 aimodeln_data localhost aimodeln_db Query 3063 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ’56de93e8ff3426c9f
3070945 aimodeln_data localhost aimodeln_db Query 3060 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ‘b9f24d3046dad2175
3070953 aimodeln_data localhost aimodeln_db Query 3052 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ’83b8036eec3ef5812
3070957 aimodeln_data localhost aimodeln_db Query 3049 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ‘000f9cd8d0c8cd052
3070986 aimodeln_data localhost aimodeln_db Query 3022 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ‘f1a2c7cf9e56d91f2
3070992 aimodeln_data localhost aimodeln_db Query 3015 Locked SELECT u.*, s.* FROM phpbb_users u LEFT JOIN phpbb_sessions s ON (s.session_user_id = u.us
3071032 aimodeln_data localhost aimodeln_db Query 2970 Locked INSERT INTO phpbb_sessions (session_user_id, session_start, session_last_visit, session_time, sessi
3071053 aimodeln_data localhost aimodeln_db Query 2954 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = ‘31019fef00f5bf89e
參考了
http://www.aslibra.com/blog/read.php?1043
http://ipboard.cn/index.php?showtopic=684&pid=2502&mode=threaded&start=#entry2502
http://www.lslnet.com/linux/f/docs1/i51/big5345331.htm
http://study.tnit.edu.tw/teacher/ccyen/db/index2-10.html
換成我的理解是,資料表在 select 與 update 時互相競爭了,才會造成 Locked 的狀態,且我也不知為何它沒有自動解除
我使用底下設定來看是否能改善此情況的發生
[mysqld]
low-priority-updates
留言