MySQL 8.0.29でパケットの最大容量(max_allowed_packet)を変更する
環境
Ubuntu 22.04 LTS
MySQL 8.0.29
構文
SHOW VARIABLES LIKE 'max_allowed_packet’;
パケットの最大容量は max_allowed_packet で確認できます
操作方法
1.パケットの最大容量を確認します
mysql> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+----------+
| Variable_name | Value |
+--------------------+----------+
| max_allowed_packet | 67108864 |
+--------------------+----------+
1 row in set (0.01 sec)
mysql> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+----------+
| Variable_name | Value |
+--------------------+----------+
| max_allowed_packet | 67108864 |
+--------------------+----------+
1 row in set (0.01 sec)
mysql> SHOW VARIABLES LIKE 'max_allowed_packet'; +--------------------+----------+ | Variable_name | Value | +--------------------+----------+ | max_allowed_packet | 67108864 | +--------------------+----------+ 1 row in set (0.01 sec)
2.パケットの最大容量を変更します
mysql> SET GLOBAL max_allowed_packet=2048;
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> SET GLOBAL max_allowed_packet=2048;
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> SET GLOBAL max_allowed_packet=2048; Query OK, 0 rows affected, 1 warning (0.01 sec)
MySQLから一度ログアウトします
mysql> exit;
Bye
mysql> exit;
Bye
mysql> exit; Bye
3.MySQL設定を確認します
mysql> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_allowed_packet | 2048 |
+--------------------+-------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_allowed_packet | 2048 |
+--------------------+-------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'max_allowed_packet'; +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | max_allowed_packet | 2048 | +--------------------+-------+ 1 row in set (0.00 sec)