1、

查看mysql的进程lsof -u mysql

2、

edit the file in /etc/security/limits.conf and add these two mysql lines in at the bottom#@student        -       maxlogins       4mysql   soft    nofile  4096mysql   hard    nofile  8192# End of file

3、

Once this is set you need to make some changes in the mysql file as well. Assuming yours lives in /etc/mysql/my.cnf - edit or add these valuesopen-files-limit = 2048table_cache            = 512

这样就解决了