mysql5.5_2013 Lost connection to Mysql server during query

wisdomone1發表於2010-08-02
  在用客戶端navicat操作在杭州的mysql 5.5時,查詢表yisile_courseware_vote報如題錯誤:
 
 
處理方法:
 
在my.ini裡設定
[mysqld]
max_allow_packet=100M
設定大點就不會出錯了。
 
 
 
 
 
# The MySQL server
[mysqld]
port            = 3306
socket          = /webapps/mysql/mysql.sock
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
default-character-set=gb2312

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-669978/,如需轉載,請註明出處,否則將追究法律責任。

相關文章