Installing the MySQL system log under Windows max_open_files:2048 max_connections:510 table_cache:764 Similar error is due to max_connections maximum number of connections and Max_ Open_files and Table_cache do not match. Reduce max_connections or adjust the other two values appropriately
Workaround Enter Mysql-nt--table_cache=764 in MySQL bin >
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
Report:
The above is due to your my.ini or my.cfg and so on inside of the max_connections and Table_cache settings are not caused. The system automatically adjusts for you to a relatively close numerical value.
Max_connections,table_cache not bigger is better. Please refer to the following formula for matching:
Because the max_open_files is fixed, it can only be 2048 in Windows.
2048= max_connections+table_cache*2
In principle, as long as the set up half of the error will not be, preferably after setting to a little less than 2048, do not equal.