mysql5.5_2013 Lost connection to Mysql server during query
在用客戶端navicat操作在杭州的mysql 5.5時,查詢表yisile_courseware_vote報如題錯誤:
處理方法:
在my.ini裡設定
[mysqld]
max_allow_packet=100M
設定大點就不會出錯了。
[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
[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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Mysql mysql lost connection to server during query 問題解決方法MySqlServer
- mysqldump: Error 2013: Lost connection to MySQL server during query when dumpingMySqlErrorServer
- MySQL報錯ERROR 2013 (HY000): Lost connection to MySQL server during queryMySqlErrorServer
- MySQL:Lost connection to MySQL server at 'readingMySqlServer
- Lost connection to MySQL server at 'reading authorization packet'MySqlServer
- MongoDB mongoimport 報錯:lost connection to serverMongoDBImportServer
- Mysql連線錯誤:Lost connection to Mysql server at 'waiting for initial communication packet'MySqlServerAI
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization paErrorMySqlServer
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0 mysql遠端連線問題MySqlServerError
- Network Connection Lost When Windows 8 Goes To SleepWindowsGo
- Connection/Session/Server ProcessesSessionServer
- MySQL異常刨析:ata source rejected establishment of connection, message from server: “Too many connectionMySqlServer
- 解決Redis/Codis Connection with master lost(複製超時)問題RedisAST
- ORA-03135: connection lost contact的解決方法
- MySQL Query CacheMySql
- mysql connection refusedMySql
- Mysql general query logMySql
- mysql 配置 General Query Log和# Slow Query LogMySql
- Best Practices for failover during server failures [ID 1323472.1]AIServer
- MySQL Rewriter Query Rewrite PluginMySqlPlugin
- OMS Startup Fails during Repository Connection Attempt due to_310772.1AI
- Xlib: connection to ":0.0" refused by server(openSUSE)Server
- mysqldump匯出報錯"mysqldump: Error 2013 ... during query when dumping tableMySqlError
- Check connection related issue of mysqlMySql
- 【Mysql】MySql Host is blocked because of many connection errors;MySqlBloCError
- MySQL8.0:The General Query LogMySql
- Xlib: connection to ":0.0" refused by server 問題Server
- Zabbix 2.2安裝MySQL MPM外掛報錯'Connection to zabbix server failed (rc=1305)'MySqlServerAI
- 錯誤Error during artifact deployment. See server log for details.ErrorServerAI
- Dr.Elephant mysql connection errorMySqlError
- [network][easy case]troubleshoting the connection to a remote serverREMServer
- 關於mysql的query_cacheMySql
- proxysql mysql_query_rules 翻譯MySql
- MySQL :Ignoring query to other databaseMySqlDatabase
- ntpdate會導致mysql slow query log出現很大的query timeMySql
- Dr.Elephant mysql connection error薦MySqlError
- 【MySQL】Host is blocked because of many connection errorsMySqlBloCError
- 【故障處理】ORA-28547: connection to server failed, probableServerAI