Re: Maximum query size

2003-12-09 Thread Chuck Gadd
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. the max size would be limited by the variable max_a

Re: Maximum query size

2003-12-09 Thread Michael Stassen
The default maximum packet size is 1 meg. You can check your current server setting with: SHOW VARIABLES LIKE 'max_allowed_packet'; See "A.2.9 Packet too large Error" for directions to change this setting in the server and client. Michael