MySQL: Problem: [Err] 1153 - Got a packet bigger than 'max_allowed_packet' bytes [Err] /*

Problem

MySQL: [Err] 1153 - Got a packet bigger than ‘max_allowed_packet’ bytes [Err] /*

---

Solution

mysql> show VARIABLES like '%max_allowed_packet%';
+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| max_allowed_packet       | 1048576    |
| slave_max_allowed_packet | 1073741824 |
+--------------------------+------------+
2 rows in set (0.00 sec)

mysql> set global max_allowed_packet = 4194304;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
mysql> show VARIABLES like '%max_allowed_packet%';
+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| max_allowed_packet       | 4194304    |
| slave_max_allowed_packet | 1073741824 |
+--------------------------+------------+
2 rows in set (0.00 sec)