windows server 2008 64位 mysql 经常断开

Question

客户端程序的操作日志为：[2013.08.08 17:40:44.328   377行 2006]: MySQL server has gone away QMYSQL: Unable to execute query
[2013.08.08 17:40:47.546  448行 2013]: Lost connection to MySQL server during query QMYSQL3: Unable to reset statement照网上说的，将max_allow_packet值改为了96M
将net_read_timeout改为了60
  net_write_timeout改为了120最大连接数为300

Answer 1

今天早上错误日志里有如下内容：不知道什么时候写的Status information:Current dir: D:\MySQL\MySQL Server 5.6\data\
Running threads: 7  Stack size: 262144
Current locks:
lock: 0x6776bbc0:lock: 0x63e942b0:lock: 0x6776bef0:lock: 0x1a7a5cf0:lock: 0x1a7a5030:lock: 0x1a7a4f20:lock: 0x1a7a4e10:lock: 0x1a7a5580:lock: 0x63e93fb0:lock: 0x1a7a5470:lock: 0x63e93eb0:lock: 0x1a7a5360:lock: 0x63e93db0:lock: 0x1a7a5250:lock: 0x1a7a5140:lock: 0x63e93cb0:lock: 0x1a7a4d00:lock: 0x1a7a4bf0:lock: 0x1a7a4ae0:lock: 0x1a7a49d0:lock: 0x63e93bb0:lock: 0x63e93ab0:lock: 0x63e939b0:lock: 0x63e937b0:lock: 0x1a7a48c0:lock: 0x67601cf0:lock: 0x674b2340:lock: 0x67504560:lock: 0x674b5200:lock: 0x6750e9d0:lock: 0x61f0c9d0:lock: 0x61f00750:lock: 0x66852e90:lock: 0x40131410:lock: 0x401314d0:lock: 0x40131590:lock: 0x40131650:lock: 0x40131710:lock: 0x401317d0:lock: 0x40131890:lock: 0x40131950:lock: 0x40131a10:lock: 0x40131ad0:lock: 0x40131b90:lock: 0x40131c50:lock: 0x40131d10:lock: 0x40131dd0:lock: 0x40131f50:lock: 0x40131e90:lock: 0x40132010:lock: 0x401320d0:lock: 0x40132190:lock: 0x40132250:lock: 0x40132310:lock: 0x401323d0:lock: 0x40132490:lock: 0x40132610:lock: 0x40132550:lock: 0x401326d0:lock: 0x40132790:lock: 0x40132850:lock: 0x40132910:lock: 0x401329d0:lock: 0x40132a90:lock: 0x40132b50:lock: 0x40132c10:lock: 0x40132cd0:lock: 0x40132e50:lock: 0x40132fd0:lock: 0x40133090:lock: 0x40132f10:lock: 0x40133150:lock: 0x40133210:lock: 0x401332d0:lock: 0x40133390:lock: 0x40133450:lock: 0x40133510:lock: 0x401335d0:lock: 0x40133690:lock: 0x40133750:lock: 0x40133810:lock: 0x40133a50:lock: 0x401338d0:lock: 0x40133990:lock: 0x40132d90:
Key caches:
default
Buffer_size:       8388608
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:             0
not flushed:             0
w_requests:              0
writes:                  0
r_requests:              0
reads:                   0
handler status:
read_key:        35820
read_next:        2643
read_rnd         12571
read_first:         70
write:           26171
delete               0
update:          28229Table status:
Opened tables:         93
Open tables:           86
Open files:            17
Open streams:           0Alarm status:
Active alarms:   0
Max used alarms: 0
Next alarm time: 0Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data LockedEvent scheduler status:
State      : INITIALIZED
Thread id  : 0
LLA        : n/a:0
LUA        : n/a:0
WOC        : NO
Workers    : 0
Executed   : 0
Data locked: NOEvent queue status:
Element count   : 0
Data locked     : NO
Attempting lock : NO
LLA             : <unknown>:139
LUA             : <unknown>:149
WOC             : NO
Next activation : never