MariaDB 10.6パケットの最大容量(max_allowed_packet)を変更する
環境
Windows 10 64bit
MariaDB 10.6.4
使用例
1.パケットの最大容量は max_allowed_packetを確認します
MariaDB [(none)]> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+----------+
| Variable_name | Value |
+--------------------+----------+
| max_allowed_packet | 16777216 |
+--------------------+----------+
1 row in set (0.530 sec)
MariaDB [(none)]> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+----------+
| Variable_name | Value |
+--------------------+----------+
| max_allowed_packet | 16777216 |
+--------------------+----------+
1 row in set (0.530 sec)
MariaDB [(none)]> SHOW VARIABLES LIKE 'max_allowed_packet'; +--------------------+----------+ | Variable_name | Value | +--------------------+----------+ | max_allowed_packet | 16777216 | +--------------------+----------+ 1 row in set (0.530 sec)
2.パケットの最大容量を変更します
MariaDB [(none)]> SET GLOBAL max_allowed_packet=2048;
Query OK, 0 rows affected, 1 warning (0.000 sec)
MariaDB [(none)]> SET GLOBAL max_allowed_packet=2048;
Query OK, 0 rows affected, 1 warning (0.000 sec)
MariaDB [(none)]> SET GLOBAL max_allowed_packet=2048; Query OK, 0 rows affected, 1 warning (0.000 sec)
一度ログアウトします
MariaDB [(none)]> exit;
Bye
3.変更後確認
再rグインして設定を確認します
MariaDB [(none)]> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_allowed_packet | 2048 |
+--------------------+-------+
1 row in set (0.001 sec)
MariaDB [(none)]> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_allowed_packet | 2048 |
+--------------------+-------+
1 row in set (0.001 sec)
MariaDB [(none)]> SHOW VARIABLES LIKE 'max_allowed_packet'; +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | max_allowed_packet | 2048 | +--------------------+-------+ 1 row in set (0.001 sec)