Re: Can't increase max_allowed_packet
Posted by: Duy Dang
Date: November 24, 2016 03:47AM

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

Options: ReplyQuote


Subject
Written By
Posted
November 23, 2016 03:21PM
Re: Can't increase max_allowed_packet
November 24, 2016 03:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.