From: Dan Nelson
Date: May 18 2006 3:01am
Subject: Re: max_allowed_packet via SQL Statement
List-Archive: http://lists.mysql.com/mysql/198045
Message-Id: <20060518030132.GE96480@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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