# 查看DataEase宿主机配置
ulimit -n
输出:1014

# 临时修改大
ulimit -n 10000

#永久修改
vi /etc/security/limits.conf
在最底部加上
* soft nofile 65535
* hard nofile 65535

# 查看mysql的配置信息
vi /opt/dataease2.0/conf/my.cnf


# 以下是修改后的内容
[mysqld]
datadir=/var/lib/mysql

default-storage-engine=INNODB
character_set_server=utf8
#lower_case_table_names=1
table_open_cache=128
max_connections=2000
max_connect_errors=6000
innodb_file_per_table=1
#innodb_buffer_pool_size=1G
max_allowed_packet=64M
transaction_isolation=READ-COMMITTED
innodb_flush_method=O_DIRECT
innodb_lock_wait_timeout=1800
innodb_flush_log_at_trx_commit=0
sync_binlog=0

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

skip-name-resolve

#下面是黄海增加的优化配置信息
innodb_buffer_pool_size = 8192MB
innodb_buffer_pool_instances = 8
max_allowed_packet = 8M
back_log = 1000


[mysql]
default-character-set=utf8

[mysql.server]
default-character-set=utf8

# 重新启动下Mysql
docker restart 349ec45f2c98

# 在线升级dataease
dectl upgrade