Solve the problem of a large number of unauthenticated users in MySQL, unauthenticated
Recently, OJ and related open site operations have been exceptionally slow, causing a crash and no reason has been found!
Enter the database server, enter mysql, and useShow processlistCommand to view, found that there are a lot of unauthenticated user
Google,
This is a M
MySQL Tutorial: Philosophical Thoughts on unauthenticated users
Symptom 1
In the production environment, we occasionally encounter connections such as "unauthenticated user", with load at the database server level, high sys cpu, or thread running exceptions.
+ ----- + ---------------------- + ------------------ + ------ + --------- + ------ + ------- + -------------------- +
| Id | User | Host | db | Com
Recently, I found that two MySQL servers suddenly went viral at noon (suddenly) and kept failing. Restarting mysql also fails. You can only see information similar to the following:
Forcing close of thread 12232 user: 'root'
Use mysqladmin to easily monitor mysql:
Mysqladmin-uroot-p ******** status-I 1
It is found that Queries per second avg is only about 200, which can be said to be very low, but Threads is indeed very unstable, and it will actually upgrade more than 200 instantly. In general,
Mysql solved a large number of unauthenticated users a few days ago, the company server made adjustments, and then mysql could not connect .... time out was speechless, and I thought about all the methods I could think of. I didn't quite understand mysql either. At that time, I just guessed that mysql had come out. The problem was unknown, then lead the team to get it done .... www.2cto.com: The Problem description and solution are as follows: Execute
A unibilling machine suddenly had a heavy load in the first few days. The CPU is found to be heavily occupied in top. The AGI program runs very slowly, and a zombie process occurs. In fact, there were only about 50 concurrent calls. Far from the normal level. Restarting the machine problem is not resolved. Very strange.Given that the most resources are seen in top mysqld, go to the MySQL console and run the show processlist command to discover that the information for a process is special:
Today testers reflect that a test environment MySQL server query is very slow, sometimes login not on, in top found the CPU is heavily occupied, system memory, Jave program runs very slow, log on to the server,Show full processlist brush screen A lot of processes, there are a lot of unauthenticated user stateThe connection is as follows:| 6465371 | Unauthenticated user | Connecting Host | NULL | Connect | N
Cisco Firepower 9000 Series unauthenticated web Vulnerability (CVE-2015-4287)Cisco Firepower 9000 Series unauthenticated web Vulnerability (CVE-2015-4287)
Release date:Updated on:Affected Systems:
Cisco Firepower
Description:
CVE (CAN) ID: CVE-2015-4287Cisco Firepower is a series of advanced firewall products.On a Firepower 9000 device, Cisco Firepower Extensible Operating System 1.1 (1.86) has a secu
MySQL document: http://dev.mysql.com/doc/refman/5.0/en/dns.html
MySQL verifies the legality of a user by performing the following steps during user connection processing:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->1 When a new client connects to mysqld, mysqld spawns a new thread to handle the request. This thread first checks whether the host name is in the host name cache. If not, the thread attempts to resolve the host name: 2 3 The th
. Most of the programming interfaces that access Web applications encapsulate SSL, making it as easy as accessing HTTPS and accessing HTTP. However, the certificates used by many medium and small application systems or applications based on LAN and campus network are not issued by authoritative certification bodies or verified by them, and can not be accessed directly using these programming interfaces.
This article, based on a brief introduction to Jsse, describes in detail how to use Jsse to
Recently OJ and related open station abnormal slow, simply collapsed, has not found the reason!Go to the database server, go to MySQL, check it with show processlist command, find a lot of unauthenticated userGoogle a bit,Found that this is a MySQL bug, regardless of whether the connection is through the hosts or IP, MySQL will do DNS counter-check, IP to DNS, due to the inverse of the slow speed(Whether it is a DNS server provided by the ISP or other
A unibilling machine suddenly loads heavier a few days ago. The CPU is found to be heavily occupied in top. The AGI program runs slowly, and a zombie process occurs. In fact, there were only about 50 concurrent calls. Far from the normal level. The problem of restarting the machine has not been solved. Very strange.
Taking into account that the mysqld occupies most of the resources in top, go into the MySQL console, run the show processlist command, and find that the information of a process is
An unibilling machine suddenly experienced heavy loads a few days ago. it is found that cpu usage is high in top. the agi program runs slowly and a zombie process occurs. in fact, there were only about 50 concurrent calls at that time. far below normal standards. the problem of restarting the machine was not solved. very strange.Considering that mysqld occupies the most resources in top, you can log on to the mysql console and run the show processlist command to find that the information of a pr
Execute the Show Processlist statement in MySQL and you can see that a large number of unauthenticated user processes are stuck. I heard this is a MySQL bug. The following article will introduce the solution to a large number of unauthenticated users in MySQL, if you have encountered such problems, refer.
Problem status
Restarting mysql also fails. You can only see information similar to the following:
Forc
Problem status
Restarting mysql also fails. You can only see information similar to the following:
Forcing close of thread 12232 user: 'root'
Use mysqladmin to easily monitor mysql:
Mysqladmin-uroot-p ******** status-I 1
It is found that Queries per second avg is only about 200, which can be said to be very low, but Threads is indeed very unstable, and it will actually upgrade more than 200 instantly. In general, this thread value will not be higher than 5 single digits!
Mysqladmin-uroot-p *****
Problem status
Restart MySQL is also a failure, look at the errorlog of MySQL, you can only see the following information similar to:
Forcing close of thread 12232 User: ' Root '
With mysqladmin simple monitoring of the next MySQL situation:
mysqladmin-uroot-p******** Status-i 1
found that queries per second AVG Only about 200, can be said to be very low, but threads is very unstable, incredibly will upgrade more than 200, in general, this thread of this value is not higher than 5 of the Si
Problem status
Restart MySQL is also a failure, look at the errorlog of MySQL, you can only see the following information similar to:
Forcing close of thread 12232 User: ' Root '
With mysqladmin simple monitoring of the next MySQL situation:
mysqladmin-uroot-p******** Status-i 1
found that queries per second AVG Only about 200, can be said to be very low, but threads is very unstable, incredibly will upgrade more than 200, in general, this thread of this value is not higher than 5 of the Si
Today's corporate database has stalled and blocked problems, check the database when found, show processlist; you can see a lot of:
.... : 3436942 : unauthenticated user : 192.168.0.4:49607 : : Connect : : login : : 3436943 : unauthenticated user : 192.168.0.4:49608 : : Connect : : login : .....
Constantly have unauthenticated users try to login but did not
By default, mysql will automatically reverse parse. If we cannot handle the problem, we will find a large number of unauthenticated user prompts when viewing show processlist, the following describes how to solve unauthenticated user.
Example
The Code is as follows:
Copy code
Mysql> show processlist;| 20681949 | unauthenticated user | A. B
Cases
The code is as follows
Copy Code
Mysql>show processlist;| 20681949 | Unauthenticated user | a.b.c.d:52497 | NULL | Connect | | Reading from net | NULL || 20681948 | Unauthenticated user | w.x.y.z:52495 | NULL | Connect | | Reading from net | NULL |
Found that there are a lot of unauthenticated users trying to do login
Connect with HTTP, the client code is relatively simple, directly using the URL class to connect and get the input stream. HTTPS does not require a client certificate, and the server-side certificate is already trusted and is as easy as HTTP. When verifying a certificate for a fee of thousands of yuan a year, in order to save money, this is mainly to say Java access to unauthenticated certificates of HTTPS access.There are usually two scenarios: 1
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.