MySQL Forums
Forum List  »  Chinese

max_allowed_packet be reset to 1024 automatically
Posted by: SUN ADOLF
Date: March 17, 2016 08:05PM

在my.ini文件中设置的max——allowed——packet =16M,如下:
[wampmysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 16M

[mysqldump]
quick
max_allowed_packet = 16M

项目初始运行OK,运行一段时间后报错:packet for query too large,此时查看SHOW GLOBAL VARIABLES LIKE,结果为1024,但配置文件仍未16M,期间未重启,查看general log也未发现有设置改值的语句被执行

请各位高手指点

Options: ReplyQuote


Subject
Views
Written By
Posted
max_allowed_packet be reset to 1024 automatically
2669
March 17, 2016 08:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.