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
