Re: set max_allowed_packet

2010-02-20 Thread Jesper Wisborg Krogh
Jesper Wisborg Krogh Team Leader • Certified MySQL 5.0 Developer & DBA Noggin IT • Level 8, 28 Foveaux St, Surry Hills NSW Australia 2010 T: +61 2 9219 8800 • F: +61 2 9280 4669 • E: jes...@noggin.com.au http://www.noggin.com.au On 21/02/2010, at 4:46 AM, Paul DuBois wrote: On Feb 20, 2010, a

Re: set max_allowed_packet

2010-02-20 Thread Paul DuBois
On Feb 20, 2010, at 11:22 AM, Vikram A wrote: > Hi experts, > > When I try to set the packet size to some other value, it is not getting > updated. > show variables; > > set max_allowed_packet = 2097152; > set global max_allowed_packet = 2097152; > > it resulting, > Query is ok, 0 rows afecte