Mysql max_allowed_packet

v6.8
v6
mysql

(Loren Tedford (Kc9Zhv)) #1

Where can i safely update this in Mysql?

Here is the errors i am getting…

ERROR 07/16/2017 07:27:51
07:27:51[dynmap] Tile write error - Packet for query is too large (3734 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:27:52[dynmap] Tile write error - Packet for query is too large (13723 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:27:53[dynmap] Tile write error - Packet for query is too large (1597 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
INFO 07/16/2017 07:28:32
07:28:32lorentedford issued server command: /dynmapexp
ERROR 07/16/2017 07:31:22
07:31:22[dynmap] Tile write error - Packet for query is too large (4921 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:31:23[dynmap] Tile write error - Packet for query is too large (10861 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:31:24[dynmap] Tile write error - Packet for query is too large (1597 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:31:25[dynmap] Tile write error - Packet for query is too large (15667 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:31:26[dynmap] Tile write error - Packet for query is too large (13723 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:32:52[dynmap] Tile write error - Packet for query is too large (3734 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:32:53[dynmap] Tile write error - Packet for query is too large (10861 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:32:54[dynmap] Tile write error - Packet for query is too large (1597 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:38:54[dynmap] Tile write error - Packet for query is too large (9952 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:38:55[dynmap] Tile write error - Packet for query is too large (23858 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:38:56[dynmap] Tile write error - Packet for query is too large (3063 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:24[dynmap] Tile write error - Packet for query is too large (4921 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:25[dynmap] Tile write error - Packet for query is too large (13723 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:26[dynmap] Tile write error - Packet for query is too large (1597 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:27[dynmap] Tile write error - Packet for query is too large (10861 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:28[dynmap] Tile write error - Packet for query is too large (15667 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:54[dynmap] Tile write error - Packet for query is too large (17193 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:55[dynmap] Tile write error - Packet for query is too large (20969 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:56[dynmap] Tile write error - Packet for query is too large (3075 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:57[dynmap] Tile write error - Packet for query is too large (21551 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:39:58[dynmap] Tile write error - Packet for query is too large (3063 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:43:25[dynmap] Tile write error - Packet for query is too large (4921 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:43:26[dynmap] Tile write error - Packet for query is too large (13723 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:43:27[dynmap] Tile write error - Packet for query is too large (1597 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:45:25[dynmap] Tile write error - Packet for query is too large (17193 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:45:26[dynmap] Tile write error - Packet for query is too large (21017 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:45:27[dynmap] Tile write error - Packet for query is too large (3075 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:45:28[dynmap] Tile write error - Packet for query is too large (21551 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
07:45:29[dynmap] Tile write error - Packet for query is too large (3063 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.

(Marc) #2
#config getprop mysqld MaxAllowedPacket       #default is 16M
config setprop mysqld MaxAllowedPacket 500M
signal-event nethserver-mysql-update

For limits chekout the mysql documentation


(Loren Tedford (Kc9Zhv)) #3

Thanks so much!!!