mysql查询慢

可能是连接数，或者缓存不够，可尝试添加如下参数，重启mysql

[mysqld]

max_connections=50000

interactive_timeout=604800

lock_wait_timeout=600

wait_timeout=604800

net_read_timeout=604800

log-error=/var/lib/mysql/mysqld.log

slow_query_log=ON

slow_query_log_file=/var/lib/mysql/my-slow.log

long_output=FILE

innodb_buffer_pool_size=4G

[client]

socket=/var/run/mysqld/mysqld.sock

default-character-set=utf8

[mysql]

default-character-set=utf8

[mysql.server]

default-character-set=utf8

[mysql_safe]

default-character-set=utf8