Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql连接中有大量的unauthenticated user进程的问题_MySQL

mysql连接中有大量的unauthenticated user进程的问题_MySQL

WBOY
Release： 2016-06-01 13:37:33
Original
1204 people have browsed it

bitsCN.com


在老东家工作的时候，有一次用户突然投诉说db很慢，我nload查看时发现网络
流量很大，按照经验可能是mysql服务器受到攻击！
当时的情况见附件：

mysql连接中有大量的unauthenticated user进程的问题_MySQL

按照正常的操作应该是
>show processlist;
找到奇怪的连接（进程），然后kill掉它！

但我在kill的时候却遇到一个奇怪的问题，提示找不到该进程！大概过了10几分钟机器就恢复正常了！
我认为这种情况大量的出现是mysql服务器遭到攻击所致！
老外的解释见下图mysql连接中有大量的unauthenticated user进程的问题_MySQL

关于--skip-name-resolve有一个博客解释的很清楚：
mysql连接中有大量的unauthenticated user进程的问题_MySQL
 

bitsCN.com
Related labels：
mysql server flow user network
source：php.cn
Previous article：MySQL各种管理工具_MySQL Next article：Mysql主从复制技术(亲测)_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
CSS styles not applied to site I'm making a website using Bootstrap5 but the index.css properties are not being applied t...
From 2024-04-06 17:12:23
0
1
336
CSS bottom border on navigation bar I have a navigation bar and I have added a red line at the bottom when any item in the lis...
From 2024-04-06 15:04:41
0
2
347
Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
From 2024-04-06 14:53:12
0
1
425
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
Should we use SSG to deploy dashboards created with Nuxt.js? We will develop a dashboard for internal use using Nuxt.js. Since this will be an internal...
From 2024-04-06 13:17:44
0
1
493
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template