Mysql has a problem that Aborted_connects is always greater than 0.

Source: Internet
Author: User
Tags what parameter


Mysql has a problem that Aborted_connects is always greater than 0. In my database, I check the parameter Aborted_connects every day, which is greater than 0, sometimes dozens or even hundreds, in fact, I restart the mysql database once a day. If I do not restart the database twice a day, the value of Aborted_connects is greater than 0, so I would like to ask you, what parameter should I modify to control this value and make it normal? My max_conntions has 1000. Www.2cto.com solution: I encountered the same problem a few days ago. You can restart it using the method below. I will solve it using the method below, and I hope it will also apply to you. When show processlist is used; The following information is displayed, unauthenticated user | 192.168.0.3: 1112 | NULL | Connect | NULL | login | NULL 1. The parameter -- skip-name-resolve 2 is included at startup. The IP address is used to authorize the accessed host, it is best to write the IP address and Host Name of the host to the/etc/hosts file.

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.