My server event log has a lot of changed limits:max_open_files:2048 max_connections:800 table_cache:619 warnings, which are issued by MySQL, which roughly means Max_ Connections and Table_cache do not match the generated, but for a moment I do not know how to set up to match.
Baidu a bit, there is a lot of this error warning Ah, the solution is appropriate to reduce max_connections or adjust the value of Table_cache, Max_open_files, said on the Internet to:
max_connections=1024
Table_cache=64
I restarted MySQL and I hope it works.
After a while, log back on the server to view the log, my God, no matter what, warning more, and then still go to Baidu, or to say that the two values of the problem, I will change it to:
max_connections=800
table_cache=500
The error magically ceases to appear,
later on the internet also found some methods do not know whether it is available, the following is added below it
MySQL bin > Input mysql-nt--table_cache=764
Mysql-nt--innodb_open_files=2048 can!!
Table_cache and max_connections are adjustable in my.ini.
Changed limits:max_open_files:2048 max_connections:1024 table_cache:507
max_connections=1024
table_cache=500