Is there an easy way to determine the largest sql query I can pass between a perl/C app to my MySQL database? It seems to wig out around the 1 meg range but without resorting to trial and error I'm not sure how to get an exact figure.
the max size would be limited by the variable max_allowed_packet so, if you do a
show variables like 'max_allowed_packet'
it will show you the limit. By default, it is set to 1047552 bytes.
If you want to increase that, add a line to the server's my.cnf file, in the [mysqld] section :
set-variable = max_allowed_packet=2M
and restart mysql server.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]