各位大侠，大仙，救命啊！我的mysql数据库，隔1天死一次。

stormcc

max_connections = 2048   不知道你的服务器有多强，设置的这么高。。。

xuxingyu

大多都是索引问题

乱.码

LZ很想大家帮他解决问题，大家也很热情并且是无偿的，但LZ就是不愿意贴log和processlist。

yangyt.leo

建议把下面几个参数值先改小：

sort_buffer_size = 64M
read_buffer_size = 32M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 512M

zsp226

| 2427504 | root | 10.100.100.233:47640 | AOL | Query   |  660 | Sending data | SELECT count(*) FROM c_diary WHERE EXISTS (SELECT * FROM c_diary_connect WHERE c_diary_connect.c_mem |
| 2427542 | root | 10.100.100.221:64476 | AOL | Query   |  652 | Locked       | SELECT r_datetime FROM c_diary WHERE c_member_id = 32718 ORDER BY r_datetime LIMIT 0, 1              |
| 2427544 | root | 10.100.100.221:64478 | AOL | Query   |  652 | Locked       | UPDATE c_diary SET html_url = 'www/2009/03/20/128213lq5.shtml' WHERE c_diary_id = 128213             |
| 2427638 | root | 10.100.100.233:47796 | AOL | Query   |  652 | Locked       | SELECT r_datetime FROM c_diary WHERE c_member_id = 32712 ORDER BY r_datetime LIMIT 0, 1              |
| 2427647 | root | 10.100.100.221:64577 | AOL | Query   |  651 | Locked       | SELECT COUNT(*) FROM c_diary where c_member_id = 32888 LIMIT 0, 1                                    |
| 2427657 | root | 10.100.100.221:64588 | AOL | Query   |  653 | Locked       | UPDATE c_diary SET subject = '??????????????',body = '&nbsp;<img style=\                             |
| 2427664 | root | 10.100.100.233:47823 | AOL | Query   |  651 | Locked       | SELECT COUNT(*) FROM c_diary where c_member_id = 3 LIMIT 0, 1                                        |
| 2427672 | root | 10.100.100.221:64607 | AOL | Query   |  652 | Locked       | SELECT r_datetime FROM c_diary WHERE c_member_id = 285 ORDER BY r_datetime LIMIT 0, 1                |
| 2427680 | root | 10.100.100.221:64616 | AOL | Query   |  652 | Locked       | SELECT r_datetime FROM c_diary WHERE c_member_id = 32718 ORDER BY r_datetime LIMIT 0, 1              |
| 2427695 | root | 10.100.100.233:47851 | AOL | Query   |  650 | Locked       | SELECT r_datetime FROM c_diary WHERE c_member_id = 32718 ORDER BY r_datetime LIMIT 0, 1

zsp226

不是不贴，昨天后面有点事情没有上线了等，真对不起。

yangyt.leo

把下面语句结果贴上来看下：

mysql>show full processlist;
mysql>show status;
mysql>show variables;

zsp226

SET TIMESTAMP=1237451715;
UPDATE c_session SET sess_time = 1237451689,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"2164772c7f104a2b257116b62cad32ac\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:13:\"222.76.138.19\";s:16:\"sessionuseragent\";s:70:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)\";s:15:\"challengecookie\";s:32:\"52c27cc801ae58b0297a67cff388fb28\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"xPP2Dx6Fc+DUO20dHDHIzbz2c4IaURWl\";s:9:\"timestamp\";i:1237440164;s:4:\"idle\";i:1237451689;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237449799;LOLOVALICODE|i:3079;' WHERE sess_id = 'e657fhp8f6mkc39qem56dlphe4' AND sess_name = 'PHPSESSID';
# at 28477
#090319 16:35:15 server id 1  end_log_pos 28619         Query   thread_id=1112221       exec_time=0     error_code=0
SET TIMESTAMP=1237451715;
UPDATE c_member_online SET session_date=NOW() Where c_member_id=417132;
# at 28619
#090319 16:35:15 server id 1  end_log_pos 29398         Query   thread_id=1112221       exec_time=0     error_code=0
SET TIMESTAMP=1237451715;
UPDATE c_session SET sess_time = 1237451690,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"2164772c7f104a2b257116b62cad32ac\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:13:\"222.76.138.19\";s:16:\"sessionuseragent\";s:70:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)\";s:15:\"challengecookie\";s:32:\"52c27cc801ae58b0297a67cff388fb28\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"xPP2Dx6Fc+DUO20dHDHIzbz2c4IaURWl\";s:9:\"timestamp\";i:1237440164;s:4:\"idle\";i:1237451689;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237449799;LOLOVALICODE|i:3079;' WHERE sess_id = 'e657fhp8f6mkc39qem56dlphe4' AND sess_name = 'PHPSESSID';
# at 29398
#090319 16:35:15 server id 1  end_log_pos 29540         Query   thread_id=1112225       exec_time=0     error_code=0
SET TIMESTAMP=1237451715;
UPDATE c_member_online SET session_date=NOW() Where c_member_id=417132;
# at 29540
#090319 16:35:15 server id 1  end_log_pos 29682         Query   thread_id=1112227       exec_time=0     error_code=0
SET TIMESTAMP=1237451715;
UPDATE c_member_online SET session_date=NOW() Where c_member_id=417132;
# at 29682
#090319 16:35:15 server id 1  end_log_pos 29826         Query   thread_id=1112225       exec_time=0     error_code=0
SET TIMESTAMP=1237451715;
UPDATE c_diary_reader SET c_member_list='417132,32712,0' WHERE c_diary_id=127539;
# at 29826
#090319 16:35:15 server id 1  end_log_pos 30605         Query   thread_id=1112225       exec_time=0     error_code=0
SET TIMESTAMP=1237451715;
UPDATE c_session SET sess_time = 1237451690,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"2164772c7f104a2b257116b62cad32ac\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:13:\"222.76.138.19\";s:16:\"sessionuseragent\";s:70:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)\";s:15:\"challengecookie\";s:32:\"52c27cc801ae58b0297a67cff388fb28\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"xPP2Dx6Fc+DUO20dHDHIzbz2c4IaURWl\";s:9:\"timestamp\";i:1237440164;s:4:\"idle\";i:1237451689;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237449799;LOLOVALICODE|i:3079;' WHERE sess_id = 'e657fhp8f6mkc39qem56dlphe4' AND sess_name = 'PHPSESSID';
# at 30605
#090319 16:35:15 server id 1  end_log_pos 31384         Query   thread_id=1112219       exec_time=0     error_code=0
SET TIMESTAMP=1237451715;
UPDATE c_session SET sess_time = 1237451701,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"2164772c7f104a2b257116b62cad32ac\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:13:\"222.76.138.19\";s:16:\"sessionuseragent\";s:70:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)\";s:15:\"challengecookie\";s:32:\"52c27cc801ae58b0297a67cff388fb28\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"xPP2Dx6Fc+DUO20dHDHIzbz2c4IaURWl\";s:9:\"timestamp\";i:1237440164;s:4:\"idle\";i:1237451701;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237449799;LOLOVALICODE|i:3079;' WHERE sess_id = 'e657fhp8f6mkc39qem56dlphe4' AND sess_name = 'PHPSESSID';
# at 31384
#090319 16:35:15 server id 1  end_log_pos 32163         Query   thread_id=1112227       exec_time=0     error_code=0
SET TIMESTAMP=1237451715;
UPDATE c_session SET sess_time = 1237451701,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"2164772c7f104a2b257116b62cad32ac\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:13:\"222.76.138.19\";s:16:\"sessionuseragent\";s:70:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)\";s:15:\"challengecookie\";s:32:\"52c27cc801ae58b0297a67cff388fb28\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"xPP2Dx6Fc+DUO20dHDHIzbz2c4IaURWl\";s:9:\"timestamp\";i:1237440164;s:4:\"idle\";i:1237451701;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237449799;LOLOVALICODE|i:3079;' WHERE sess_id = 'e657fhp8f6mkc39qem56dlphe4' AND sess_name = 'PHPSESSID';
# at 32163
#090319 16:35:16 server id 1  end_log_pos 32305         Query   thread_id=1112231       exec_time=0     error_code=0
SET TIMESTAMP=1237451716;
UPDATE c_member_online SET session_date=NOW() Where c_member_id=417132;
# at 32305
#090319 16:35:16 server id 1  end_log_pos 33084         Query   thread_id=1112231       exec_time=0     error_code=0
SET TIMESTAMP=1237451716;
UPDATE c_session SET sess_time = 1237451690,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"2164772c7f104a2b257116b62cad32ac\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:13:\"222.76.138.19\";s:16:\"sessionuseragent\";s:70:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)\";s:15:\"challengecookie\";s:32:\"52c27cc801ae58b0297a67cff388fb28\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"xPP2Dx6Fc+DUO20dHDHIzbz2c4IaURWl\";s:9:\"timestamp\";i:1237440164;s:4:\"idle\";i:1237451690;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237449799;LOLOVALICODE|i:3079;' WHERE sess_id = 'e657fhp8f6mkc39qem56dlphe4' AND sess_name = 'PHPSESSID';
# at 33084
#090319 16:35:16 server id 1  end_log_pos 33226         Query   thread_id=1112258       exec_time=0     error_code=0
SET TIMESTAMP=1237451716;
UPDATE c_member_online SET session_date=NOW() Where c_member_id=417132;
# at 33226
#090319 16:35:16 server id 1  end_log_pos 34005         Query   thread_id=1112258       exec_time=0     error_code=0
SET TIMESTAMP=1237451716;
UPDATE c_session SET sess_time = 1237451702,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"2164772c7f104a2b257116b62cad32ac\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:13:\"222.76.138.19\";s:16:\"sessionuseragent\";s:70:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)\";s:15:\"challengecookie\";s:32:\"52c27cc801ae58b0297a67cff388fb28\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"xPP2Dx6Fc+DUO20dHDHIzbz2c4IaURWl\";s:9:\"timestamp\";i:1237440164;s:4:\"idle\";i:1237451702;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237449799;LOLOVALICODE|i:3079;' WHERE sess_id = 'e657fhp8f6mkc39qem56dlphe4' AND sess_name = 'PHPSESSID';
# at 34005
#090319 16:35:18 server id 1  end_log_pos 34126         Query   thread_id=1112290       exec_time=0     error_code=0
SET TIMESTAMP=1237451718;
UPDATE p_photo SET view_num = 3 WHERE  p_photo_id =168920;
# at 34126
#090319 16:35:18 server id 1  end_log_pos 34306         Query   thread_id=1112290       exec_time=0     error_code=0
SET TIMESTAMP=1237451718;
UPDATE `c_member_index` SET `index_hits`=`index_hits`+1,`index_day_hits`=`index_day_hits`+1 WHERE c_member_id= 32888;
# at 34306
#090319 16:35:20 server id 1  end_log_pos 34426         Query   thread_id=1112340       exec_time=0     error_code=0
SET TIMESTAMP=1237451720;
UPDATE p_photo SET view_num = 33 WHERE  p_photo_id =5657;
# at 34426
#090319 16:35:20 server id 1  end_log_pos 34604         Query   thread_id=1112340       exec_time=0     error_code=0
SET TIMESTAMP=1237451720;
UPDATE `c_member_index` SET `index_hits`=`index_hits`+1,`index_day_hits`=`index_day_hits`+1 WHERE c_member_id= 255;
# at 34604
#090319 16:35:21 server id 1  end_log_pos 34632         Intvar
SET INSERT_ID=3285454;
# at 34632
#090319 16:35:21 server id 1  end_log_pos 34831         Query   thread_id=1112370       exec_time=0     error_code=0
SET TIMESTAMP=1237451721;
INSERT INTO c_ashiato (c_member_id_from,c_member_id_to,r_datetime,r_date) VALUES (0,160691,'2009-03-19 16:35:07','2009-03-19 16:35:07');
# at 34831
#090319 16:35:21 server id 1  end_log_pos 34953         Query   thread_id=1112381       exec_time=0     error_code=0
SET TIMESTAMP=1237451721;
UPDATE p_photo SET view_num = 205 WHERE  p_photo_id =56940;
# at 34953
#090319 16:35:21 server id 1  end_log_pos 35130         Query   thread_id=1112381       exec_time=0     error_code=0
SET TIMESTAMP=1237451721;
UPDATE `c_member_index` SET `index_hits`=`index_hits`+1,`index_day_hits`=`index_day_hits`+1 WHERE c_member_id= 35;
# at 35130
#090319 16:35:22 server id 1  end_log_pos 35272         Query   thread_id=1112386       exec_time=0     error_code=0
SET TIMESTAMP=1237451722;
UPDATE c_member_online SET session_date=NOW() Where c_member_id=422300;
# at 35272
#090319 16:35:22 server id 1  end_log_pos 36022         Query   thread_id=1112386       exec_time=0     error_code=0
SET TIMESTAMP=1237451722;
UPDATE c_session SET sess_time = 1237451708,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"356ae68dc6fe0c7ade969e5575495264\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:14:\"220.249.188.68\";s:16:\"sessionuseragent\";s:68:\"Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MAXTHON 2.0)\";s:15:\"challengecookie\";s:32:\"fdd302146082ca1104d011a7338da80d\";s:10:\"registered\";b:1;s:8:\"username\";s:24:\"OTVjWrXwVswrJB1cy0WdAQ==\";s:9:\"timestamp\";i:1237447730;s:4:\"idle\";i:1237451707;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237450143;' WHERE sess_id = '02nl87kjfgaieu79rj2knp1cp7' AND sess_name = 'PHPSESSID';
# at 36022
#090319 16:35:26 server id 1  end_log_pos 36164         Query   thread_id=1112542       exec_time=0     error_code=0
SET TIMESTAMP=1237451726;
UPDATE c_member_online SET session_date=NOW() Where c_member_id=417132;
# at 36164
#090319 16:35:26 server id 1  end_log_pos 36949         Query   thread_id=1112542       exec_time=0     error_code=0
SET TIMESTAMP=1237451726;
UPDATE c_session SET sess_time = 1237451712,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"2164772c7f104a2b257116b62cad32ac\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:13:\"222.76.138.19\";s:16:\"sessionuseragent\";s:70:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)\";s:15:\"challengecookie\";s:32:\"52c27cc801ae58b0297a67cff388fb28\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"xPP2Dx6Fc+DUO20dHDHIzbz2c4IaURWl\";s:9:\"timestamp\";i:1237440164;s:4:\"idle\";i:1237451711;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237449799;LOLOVALICODE|s:4:\"8329\";' WHERE sess_id = 'e657fhp8f6mkc39qem56dlphe4' AND sess_name = 'PHPSESSID';
# at 36949
#090319 16:35:26 server id 1  end_log_pos 37069         Query   thread_id=1112553       exec_time=0     error_code=0
SET TIMESTAMP=1237451726;
UPDATE p_photo SET view_num = 30 WHERE  p_photo_id =4470;
# at 37069
#090319 16:35:26 server id 1  end_log_pos 37247         Query   thread_id=1112553       exec_time=0     error_code=0
SET TIMESTAMP=1237451726;
UPDATE `c_member_index` SET `index_hits`=`index_hits`+1,`index_day_hits`=`index_day_hits`+1 WHERE c_member_id= 285;
# at 37247
#090319 16:35:26 server id 1  end_log_pos 37389         Query   thread_id=1112554       exec_time=0     error_code=0
SET TIMESTAMP=1237451726;
UPDATE c_member_online SET session_date=NOW() Where c_member_id=161879;
# at 37389
#090319 16:35:26 server id 1  end_log_pos 38159         Query   thread_id=1112554       exec_time=0     error_code=0
SET TIMESTAMP=1237451726;
UPDATE c_session SET sess_time = 1237451701,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"3b9ebb945a7571c359658e5d999e3a01\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:14:\"123.119.35.133\";s:16:\"sessionuseragent\";s:143:\"Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; CNCDialer; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; CIBA; MAXTHON 2.0)\";s:15:\"challengecookie\";s:32:\"69c2754b1c89ec28a734bf5693b23030\";s:10:\"registered\";b:1;s:8:\"username\";s:24:\"bz9RMFNJuEK2Ks2OpbsE3Q==\";s:9:\"timestamp\";i:1237427106;s:4:\"idle\";i:1237451701;}' WHERE sess_id = 'oei2l46ojv954vuba301cgpp82' AND sess_name = 'PHPSESSID';
# at 38159
#090319 16:35:28 server id 1  end_log_pos 38301         Query   thread_id=1112634       exec_time=0     error_code=0
SET TIMESTAMP=1237451728;
UPDATE c_member_online SET session_date=NOW() Where c_member_id=422300;
# at 38301
#090319 16:35:28 server id 1  end_log_pos 39051         Query   thread_id=1112634       exec_time=0     error_code=0
SET TIMESTAMP=1237451728;
UPDATE c_session SET sess_time = 1237451714,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"356ae68dc6fe0c7ade969e5575495264\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:14:\"220.249.188.68\";s:16:\"sessionuseragent\";s:68:\"Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MAXTHON 2.0)\";s:15:\"challengecookie\";s:32:\"fdd302146082ca1104d011a7338da80d\";s:10:\"registered\";b:1;s:8:\"username\";s:24:\"OTVjWrXwVswrJB1cy0WdAQ==\";s:9:\"timestamp\";i:1237447730;s:4:\"idle\";i:1237451714;}IS_ALLOWD_UPIMG|i:1;action_diary_add_timer|i:1237450143;' WHERE sess_id = '02nl87kjfgaieu79rj2knp1cp7' AND sess_name = 'PHPSESSID';
# at 39051
#090319 16:35:29 server id 1  end_log_pos 39203         Query   thread_id=1112662       exec_time=0     error_code=0
SET TIMESTAMP=1237451729;
UPDATE c_api_member SET token = '729229f60c42596e3e1ba0ef1bdc8d1b' WHERE c_member_id = 0;
# at 39203
#090319 16:35:30 server id 1  end_log_pos 39321         Query   thread_id=1112662       exec_time=0     error_code=0
SET TIMESTAMP=1237451730;
DELETE FROM c_member_online WHERE c_member_id = 419164;
# at 39321
#090319 16:35:30 server id 1  end_log_pos 39349         Intvar
SET INSERT_ID=98452;
# at 39349
#090319 16:35:30 server id 1  end_log_pos 39594         Query   thread_id=1112662       exec_time=0     error_code=0
SET TIMESTAMP=1237451730;
INSERT INTO c_member_online (c_member_id, login_date, session_date, amity_date, sessid,ip) VALUES (419164,NOW(),NOW(),NOW(),'a28b4b61ad8dc0050e02bb40ac9543bb','218.5.5.191');
# at 39594
#090319 16:35:30 server id 1  end_log_pos 40339         Query   thread_id=1112662       exec_time=0     error_code=0
SET TIMESTAMP=1237451730;
UPDATE c_session SET sess_time = 1237451704,sess_data = '_authsession|a:9:{s:12:\"challengekey\";s:32:\"660a104948a57204281318e42428b6df\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:11:\"218.5.5.191\";s:16:\"sessionuseragent\";s:113:\"Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) )\";s:15:\"challengecookie\";s:32:\"c7307bb393bce54df6d30735523b469a\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"9Evrzkvn0+aqVcXXyMjdrxxnuPLkdPei\";s:9:\"timestamp\";i:1237451704;s:4:\"idle\";i:1237451704;}' WHERE sess_id = 'mtj7fh2mlvgb3hk2b88kg979r4' AND sess_name = 'PHPSESSID';
# at 40339
#090319 16:35:30 server id 1  end_log_pos 40367         Intvar
SET INSERT_ID=116716;
# at 40367
#090319 16:35:30 server id 1  end_log_pos 41106         Query   thread_id=1112662       exec_time=0     error_code=0
SET TIMESTAMP=1237451730;
INSERT INTO c_session (sess_time,sess_data,sess_id,sess_name) VALUES (1237451704,'_authsession|a:9:{s:12:\"challengekey\";s:32:\"660a104948a57204281318e42428b6df\";s:4:\"data\";a:1:{s:11:\"OPENPNE_URL\";s:21:\"http://www.AOL***.com/\";}s:9:\"sessionip\";s:11:\"218.5.5.191\";s:16:\"sessionuseragent\";s:113:\"Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) )\";s:15:\"challengecookie\";s:32:\"c7307bb393bce54df6d30735523b469a\";s:10:\"registered\";b:1;s:8:\"username\";s:32:\"9Evrzkvn0+aqVcXXyMjdrxxnuPLkdPei\";s:9:\"timestamp\";i:1237451704;s:4:\"idle\";i:1237451704;}','mtj7fh2mlvgb3hk2b88kg979r4','PHPSESSID');
# at 41106
#090319 16:35:30 server id 1  end_log_pos 41317         Query   thread_id=1112696       exec_time=0     error_code=0
use ecshop;
SET TIMESTAMP=1237451730;
/*!\C binary */;
SET @@session.character_set_client=63,@@session.collation_connection=33,@@session.collation_server=8;
INSERT INTO `ecshop`.`ecs_sessions` (sesskey, expiry, ip, data) VALUES ('157393e42655dd7016607c1fdc1259f3', '1237451704', '218.5.5.191', 'a:0:{}');
# at 41317
#090319 16:35:30 server id 1  end_log_pos 41697         Query   thread_id=1112696       exec_time=0     error_code=0
SET TIMESTAMP=1237451730;
INSERT INTO `ecshop`.`ecs_stats` ( ip_address, visit_times, browser, system, language, area, referer_domain, referer_path, keywords, access_url, access_time) VALUES ('218.5.5.191', '7', 'Internet Explorer 6.0', 'Windows XP', 'zh-cn', '绂寤虹绂宸甯', 'http://www.AOL***.com', '/', '', '/user.php', '1237451704');
# at 41697
#090319 16:35:30 server id 1  end_log_pos 41909         Query   thread_id=1112696       exec_time=0     error_code=0
SET TIMESTAMP=1237451730;
UPDATE `ecshop`.`ecs_users` SET visit_count = visit_count + 1,  last_ip = '218.5.5.191', last_time = '2009-03-19 16:35:04' WHERE user_id = '169141';
# at 41909
#090319 16:35:30 server id 1  end_log_pos 41979         Query   thread_id=1112696       exec_time=0     error_code=0
SET TIMESTAMP=1237451730;
BEGIN;
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 63, event_type: 19
Could not read entry at offset 41979:Error in log format or read error
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

zsp226

今天又cut了，
上面是倒之前的日志

xuxingyu

explain 一下上面show processlist中的语句，分析一下