Re: Shudden Slow down of MySQL Queries
Please follow these steps:
Step 1) Add the following to /etc/my.cnf
[mysqld]
skip-host-cache
skip-name-resolve
Step 2) service mysql restart
Step 3) Stop using mysql users that have DNS names. Run thus query:
SELECT user,host FROM mysql.user;
Any user that has a DNS name, simply replace it with IP Address or a netblock.
Subject
Views
Written By
Posted
1889
October 24, 2014 04:50AM
Re: Shudden Slow down of MySQL Queries
1318
October 25, 2014 12:52AM
1143
October 25, 2014 01:14AM
1318
October 26, 2014 11:53AM
1233
October 27, 2014 04:59AM
1192
October 27, 2014 11:43AM
1164
October 27, 2014 11:12PM
1234
October 28, 2014 02:24PM
1148
October 29, 2014 01:54AM
1111
October 29, 2014 02:12AM
979
October 29, 2014 08:18AM
1240
November 03, 2014 04:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.