SHOW VARIABLES LIKE 'max_allowed_packet';
See "A.2.9 Packet too large Error" <http://www.mysql.com/doc/en/Packet_too_large.html> for directions to change this setting in the server and client.
Michael
Mark wrote:
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.
Thanks,
Mark.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
