Not the answer you need?
Register and ask your own question!

Too many connections (wait_timeout)

marciomarcio ContributorCurrent User Role Contributor
Hi !

I have a question: in my config file, I have setup wait_timeout = 300. The show processlist command show me a lot of processes with time more than 300 seconds. (by example: starting from process id 563125).

The wait_timeout does not have any effect when state = connect/login ?

Or how to avoid processes that do not login in within this time frame ?

Thank you.

+
+
+
+
+
+
+
+
+
+
+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+
+
+
+
+
+
+
+
+
+
+
| 1 | system user | | NULL | Sleep | 537729 | wsrep: aborter | NULL | 0 | 0 |
| 2 | system user | | NULL | Sleep | 745 | wsrep: committed write set (108314813) | NULL | 0 | 0 |
| 3 | system user | | NULL | Sleep | 743 | wsrep: committing write set (108314833)| NULL | 0 | 0 |
| 4 | system user | | NULL | Sleep | 743 | wsrep: committing write set (108314830)| NULL | 0 | 0 |
| 5 | system user | | NULL | Sleep | 743 | Waiting for table metadata lock | NULL | 0 | 0 |
| 6 | system user | | NULL | Sleep | 744 | Waiting for table metadata lock | NULL | 0 | 0 |
| 7 | system user | | NULL | Sleep | 744 | wsrep: committed write set (108314822) | NULL | 0 | 0 |
| 8 | system user | | NULL | Sleep | 744 | wsrep: committed write set (108314819) | NULL | 0 | 0 |
| 9 | system user | | NULL | Sleep | 743 | wsrep: committing write set (108314829)| NULL | 0 | 0 |
| 10 | system user | | NULL | Sleep | 743 | wsrep: committing write set (108314832)| NULL | 0 | 0 |
| 11 | system user | | NULL | Sleep | 746 | wsrep: committed write set (108314809) | NULL | 0 | 0 |
| 12 | system user | | NULL | Sleep | 744 | wsrep: committed write set (108314821) | NULL | 0 | 0 |
| 13 | system user | | NULL | Sleep | 744 | wsrep: committed write set (108314820) | NULL | 0 | 0 |
| 15 | system user | | NULL | Sleep | 743 | Waiting for table metadata lock | NULL | 0 | 0 |
| 16 | system user | | NULL | Sleep | 743 | wsrep: committing write set (108314835)| NULL | 0 | 0 |
| 17 | system user | | NULL | Sleep | 744 | Waiting for table metadata lock | NULL | 0 | 0 |
| 18 | system user | | NULL | Sleep | 744 | wsrep: committed write set (108314817) | NULL | 0 | 0 |
| 563125 | unauthenticated user | connecting host | NULL | Connect | 653 | login | NULL | 0 | 0 |
| 563133 | unauthenticated user | connecting host | NULL | Connect | 646 | login | NULL | 0 | 0 |
| 563141 | unauthenticated user | connecting host | NULL | Connect | 640 | login | NULL | 0 | 0 |
| 563149 | unauthenticated user | connecting host | NULL | Connect | 633 | login | NULL | 0 | 0 |
| 563157 | unauthenticated user | connecting host | NULL | Connect | 618 | login | NULL | 0 | 0 |
| 563164 | unauthenticated user | connecting host | NULL | Connect | 611 | login | NULL | 0 | 0 |
| 563165 | unauthenticated user | connecting host | NULL | Connect | 610 | login | NULL | 0 | 0 |
| 563167 | unauthenticated user | connecting host | NULL | Connect | 609 | login | NULL | 0 | 0 |
| 563168 | unauthenticated user | connecting host | NULL | Connect | 606 | login | NULL | 0 | 0 |
+
+
+
+
+
+
+
+
+
+
+
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.