I just want to increase max_allowed_packet from my.cnf but i found it empty
Like that :
[mysqld]
innodb_file_per_table=1
bind-address=127.0.0.1
HELP plz!
Like that :
[mysqld]
innodb_file_per_table=1
bind-address=127.0.0.1
HELP plz!
Hi,
You can add the following line under mysqld section in /etc/my.cnf file.
max_allowed_packet=268435456 (Enter desired value)
After adding restart mysql service.
Service mysql restart
You can add the following line under mysqld section in /etc/my.cnf file.
max_allowed_packet=268435456 (Enter desired value)
After adding restart mysql service.
Service mysql restart
Hello,
Yes, as mentioned, you can add the value if it does not yet exist. Ensure you restart MySQL after making any changes.
Thank you.
Yes, as mentioned, you can add the value if it does not yet exist. Ensure you restart MySQL after making any changes.
Thank you.
| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| M | Increase file name limit | General Discussion | 5 | |
| R | Load time increases suddenly | General Discussion | 2 | |
| D | cant increase size /tmp stays stuck at 512mb | General Discussion | 2 | |
| S | Increase /tmp directory | General Discussion | 4 | |
| N | how to increase max_allowed_packet | General Discussion | 3 |