MySQL hints max_open_files:2048 max_connections:800 table_cache:619

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.