set max_allowed_packet

[Vikram A]

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)

Can you suggest me how set this value to higher one. By default it is 1 MB.

Thank you

VIKRAM A



  The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. 
http://in.yahoo.com/

Re: set max_allowed_packet

[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 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

Re: set max_allowed_packet

[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, 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)


Also remember, when you change a global variable, the change won't  
effect existing connections, so you will need to log out and back in  
to see the change. Setting the session variable as well will solve  
that for the existing connection, but not for other long lived  
connections:


With mysql1> and mysql2> being two different connections:

mysql1> select @@session.max_allowed_packet,  
@@global.max_allowed_packet;

+--+-+
| @@session.max_allowed_packet | @@global.max_allowed_packet |
+--+-+
|  1048576 | 1048576 |
+--+-+
1 row in set (0.00 sec)

mysql2> select @@session.max_allowed_packet,  
@@global.max_allowed_packet;

+--+-+
| @@session.max_allowed_packet | @@global.max_allowed_packet |
+--+-+
|  1048576 | 1048576 |
+--+-+
1 row in set (0.00 sec)

mysql1> set global max_allowed_packet = 2097152;
Query OK, 0 rows affected (0.00 sec)

mysql1> select @@session.max_allowed_packet,  
@@global.max_allowed_packet;

+--+-+
| @@session.max_allowed_packet | @@global.max_allowed_packet |
+--+-+
|  1048576 | 2097152 |
+--+-+
1 row in set (0.00 sec)

mysql2> select @@session.max_allowed_packet,  
@@global.max_allowed_packet;

+--+-+
| @@session.max_allowed_packet | @@global.max_allowed_packet |
+--+-+
|  1048576 | 2097152 |
+--+-+
1 row in set (0.00 sec)

Jesper





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=jes...@noggin.com.au