對于Linux系統(tǒng): /etc/mysql/my.cnf 或 /etc/my.cnf

對于Windows系統(tǒng): C:\ProgramData\MySQL\MySQL Server X.X\my.ini (X.X代表MySQL版本號)

MySQL命令行客戶端:SET GLOBAL max_connections=1000;

改文件

[mysqld]
max_connections = 500
innodb_buffer_pool_size = 800M

#將tmp_table_size 的值賦值到200M
tmp_table_size=200M

#query_cache_size 的值賦值到32M
query_cache_size =32M

#key_buffer_size 的值賦值到32M
key_buffer_size=32M

thread_cache_size = 100
read_buffer_size = 4M
sort_buffer_size = 64K