MySQL新建实例后需要做哪些基本优化操作
👉 本文共约141个字，系统预计阅读时间或需1分钟。
OS配置
大页
参考：https://www.xmmup.com/mysqlshujukupeizhidaye.html
安装
1 |
参数配置
修改max_connections、innodb_buffer_pool_size等
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | cat > /etc/mysql/mysql56/conf/my.cnf <<"EOF" [mysqld] skip-name-resolve server_id=563416 character_set_server=utf8mb4 max_connections=10000 innodb_buffer_pool_size=10G EOF cat > /etc/mysql/mysql57/conf/my.cnf <<"EOF" [mysqld] default-time-zone = '+8:00' log_timestamps = SYSTEM skip-name-resolve server_id=573417 character_set_server=utf8mb4 max_connections=10000 innodb_buffer_pool_size=10G EOF cat > /etc/mysql/mysql80/conf/my.cnf <<"EOF" [mysqld] default-time-zone = '+8:00' log_timestamps = SYSTEM skip-name-resolve server_id=803418 character_set_server=utf8mb4 default_authentication_plugin=mysql_native_password max_connections=10000 innodb_buffer_pool_size=10G EOF |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
