List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 18 2006 3:01am
Subject:Re: max_allowed_packet via SQL Statement
View as plain text  
In the last episode (May 18), Jim said:
> Is there any way of getting the max_allowed_packet setting via a SQL
> statement?

mysql> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 10484736 | 
+--------------------+----------+
1 row in set (0.00 sec)

or:

mysql> select @@max_allowed_packet;
+----------------------+
| @@max_allowed_packet |
+----------------------+
|             10484736 |
+----------------------+
1 row in set (0.00 sec)

-- 
	Dan Nelson
	dnelson@stripped
Thread
max_allowed_packet via SQL StatementJim18 May
Re: max_allowed_packet via SQL StatementDan Nelson18 May