MySQL Forums
Forum List  »  PHP

MySQL Keeps Generating New Connections
Posted by: Pasai Sea
Date: April 13, 2016 02:23AM

Hello, I've been dealing with too many MySQL connections problem. My Webmin MySQL Server Active Database Connections have been reporting active connections from MySQL user vmail and vmailadmin

sql> show processlist; shows:

+------+------------+-----------------+-------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------------+-----------------+-------+---------+------+-------+------------------+
| 6045 | vmail | localhost:45028 | vmail | Sleep | 6 | | NULL |
| 6078 | vmail | localhost:45156 | vmail | Sleep | 6 | | NULL |
| 7143 | vmail | localhost:49002 | vmail | Sleep | 1309 | | NULL |
| 7280 | vmailadmin | localhost:49462 | vmail | Sleep | 25 | | NULL |
| 7320 | vmail | localhost:49554 | vmail | Sleep | 704 | | NULL |
| 7345 | vmail | localhost:49604 | vmail | Sleep | 703 | | NULL |
| 7393 | vmail | localhost:49850 | vmail | Sleep | 514 | | NULL |
| 7400 | vmail | localhost:49866 | vmail | Sleep | 512 | | NULL |
| 7402 | vmail | localhost:49868 | vmail | Sleep | 511 | | NULL |
| 7416 | vmail | localhost:49898 | vmail | Sleep | 510 | | NULL |
| 7419 | vmail | localhost:49904 | vmail | Sleep | 509 | | NULL |
| 7422 | vmail | localhost:49910 | vmail | Sleep | 509 | | NULL |
| 7446 | vmailadmin | localhost:50034 | vmail | Sleep | 13 | | NULL |
| 7474 | vmail | localhost:50122 | vmail | Sleep | 57 | | NULL |
| 7477 | vmail | localhost:50134 | vmail | Sleep | 25 | | NULL |
| 7478 | vmail | localhost:50136 | vmail | Sleep | 26 | | NULL |
| 7479 | vmail | localhost:50138 | vmail | Sleep | 25 | | NULL |
| 7480 | vmail | localhost:50140 | vmail | Sleep | 25 | | NULL |
| 7481 | vmail | localhost:50142 | vmail | Sleep | 26 | | NULL |
| 7482 | vmail | localhost:50144 | vmail | Sleep | 26 | | NULL |
| 7483 | vmail | localhost:50146 | vmail | Sleep | 26 | | NULL |
| 7484 | vmail | localhost:50148 | vmail | Sleep | 26 | | NULL |
| 7485 | vmail | localhost:50150 | vmail | Sleep | 26 | | NULL |
| 7486 | vmail | localhost:50152 | vmail | Sleep | 26 | | NULL |
| 7487 | vmail | localhost:50154 | vmail | Sleep | 26 | | NULL |
| 7488 | vmail | localhost:50156 | vmail | Sleep | 26 | | NULL |
| 7494 | root | localhost | NULL | Query | 0 | init | show processlist |
+------+------------+-----------------+-------+---------+------+-------+------------------+
27 rows in set (0,00 sec)


I don't understand I'm still new, this is my first time running webmail server before. So, do you think this is normal?

What are your opinion about the Database Connections ID's? It keeps generating and won't stop. Example: 4000, 4001, 4002, 4003, ... this morning it was still about 4000s and now about 7400s. How to stop this?

A source on the internet says I need to figure out which web application is used by spammer/hacker to generate so many sql connections. But I don't have any lead on how to do this. Please I need any guidance.

Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
MySQL Keeps Generating New Connections
April 13, 2016 02:23AM


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.