1

Topic: Connections , but the process list empty - why?

OS Linux.
The demon works stablly. Files.sock and.pid on a place with the correct rights.
The last 4 weeks did not do updates.
If to be connected with  lines to  - all APPRX.
If to be connected through  - all APPRX. All the data are visible, requests transit and the answer is displayed.
All happens on  the server. Loading now average - happened and in 5 times more.
Confuses one:
After normal restarting of service connections  with each second to the maximum value in flow of several hours And thus the process list  GENERALLY the empty!
What for  this such?
a help!

2

Re: Connections , but the process list empty - why?

In the help:
mysql> SHOW STATUS WHERE variable_name LIKE "Threads _ %" OR variable_name = "Connections";
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Connections | 50497 |
| Threads_cached | 8 |
| Threads_connected | 2 |
| Threads_created | 36 |
| Threads_running | 1 |
+-------------------+-------+
5 rows in set (0.00 sec)
mysql> show processlist;
+-------+-------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-------+-----------+------+---------+------+-------+------------------+
| 26334 | admin | localhost | NULL | Sleep | 2356 | | NULL |
| 29259 | admin | localhost | NULL | Query | 0 | NULL | show processlist |
+-------+-------+-----------+------+---------+------+-------+------------------+
2 rows in set (0.00 sec)
mysql>

3

Re: Connections , but the process list empty - why?

Still yesterday all worked and suddenly the such...

4

Re: Connections , but the process list empty - why?

Connections is an amount of ATTEMPTS to incorporate. Not very well, successful or not. Time of processes a little - means, something tries to be connected, but it is impossible.
your server, more shortly...  attempts at level of OS also look. And it is even better - simply enter at level of OS or in a firewall restriction to addresses from which connection is authorized, and all remaining is rough .

5

Re: Connections , but the process list empty - why?

Akina;

wrote:

Brutforsjat your server, more shortly...  attempts at level of OS also look.

Not  - I  such variant.

wrote:

And it is even better - simply enter at level of OS or in a firewall restriction to addresses from which connection is authorized, and all remaining is rough .

under control though users from every corner of the globe connect. Therefore  here not , and I am assured, what not in it .

6

Re: Connections , but the process list empty - why?

And it is possible to see somehow from what files of attempt to be connected? And what exactly is sent for connection?
Than it is possible to see it?

7

Re: Connections , but the process list empty - why?

user00001 wrote:

Not  - I  such variant.

And it is possible to be curious, how?

user00001 wrote:

to see from what files of attempt to be connected?

??? What files in a stub? To be connected from a file is as the newspaper at a door knocked...

user00001 wrote:

And what exactly is sent for connection?

Yes a sniffer in hands... Only to analyze you will be worn out.

8

Re: Connections , but the process list empty - why?

Akina;

wrote:

And it is possible to be curious, how?

lsof + tcpdump

9

Re: Connections , but the process list empty - why?

Akina;

wrote:

??? What files in a stub?

To basis local connections are resolved, of course, only. Normal people in a network do not expose basis.
CGI on the server is not present.
All  connections only through  application, but it big and whence go requests - not clearly.
And since process list anything now does not show, also now it is not clear, what exactly for requests go.

10

Re: Connections , but the process list empty - why?

user00001;
httpd access.log looked?