Re: Can't increase max_allowed_packet

[Duy Dang]

Hi Peter , I do restart mysql service . Here is my mysql config file , please take a look .

[client]
default-character-set=utf8
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
default-character-set=utf8
character-set-server=utf8
max_allowed_packet=1500M
max_connections = 5000
max_user_connections = 5000
slow_query_log =0
slow_query_log_file=/var/log/mysql/slow-query.log
long_query_time=20
log_queries_not_using_indexes=1
default-storage-engine = innodb
#innodb_force_recovery = 1
#innodb_fast_shutdown=0
#innodb_thread_concurrency=0
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-bin=off
server-id=101
binlog_format=row
collation-server=utf8_unicode_ci
max_sp_recursion_depth=20
thread_stack = 512K
optimizer-search-depth = 0
log_bin=off
local_infile=ON

[mysqld_safe]
ulimit -d 256000
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-character-set=utf8
character-set-server=utf8
binlog_format=row
max_connections = 5000
max_user_connections = 5000
slow_query_log =0
slow_query_log_file=/var/log/mysql/slow-query.log
long_query_time=20
log_queries_not_using_indexes=1
default-storage-engine = innodb
collation-server=utf8_unicode_ci
max_sp_recursion_depth=20
thread_stack = 512K
optimizer-search-depth = 0
[mysqldump]

max_allowed_packet = 4000M