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 afected (0.00 sec)
That's okay. What does this query return: mysql> select @@global.max_allowed_packet; +-----------------------------+ | @@global.max_allowed_packet | +-----------------------------+ | 2097152 | +-----------------------------+ 1 row in set (0.06 sec) > > Can you suggest me how set this value to higher one. By default it is 1 MB. > > Thank you > > VIKRAM A -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
