Shulou(Shulou.com)05/31 Report--

The main content of this article is "how to solve the problem of MySQL database denial of service". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "the solution to MySQL database denial of service" bar!

The method of processing is described in detail in the following article:

1. With Mysql version 4.0 or 4.1, if you don't use some of the new features of Mysql 5, such as stored procedure triggers.

two。 Restart the Mysql server or Ser regularly (since this problem may also affect other server programs that need Mysql support, it is better to restart the Mysql server, but it is difficult to determine when the Mysql server needs to be detected to be unused)

3. Set my.cnf and add parameters in the mysqld field:

[mysqld] port = 3306socket = / tmp/mysql.sockwait_timeout= 500000interactive_timeout = 500000 (500000 seconds for a timeout of about five or six days. You can choose a slightly larger value for the longest time that may be idle according to your actual needs. ) you can restart the Mysqld application, or add the-o wait_timeout=500000 parameter when executing d to achieve the same effect.

When you show variable on the MySQL client, you should see the last entry change from the default wait_time=28000 to 500000.

Note: if rebooting Mysqld does not work, you can restart the machine.

At this point, I believe you have a deeper understanding of the "solution to MySQL database denial of service". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.