OS配置
大页
参考：https://www.dbaup.com/mysqlshujukupeizhidaye.html
安装
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
参数配置
修改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 |
15065313181 说:麦苗老师，请问，您的secureCRT的…