Menu
I'm using phpmyadmin built-in monitor tools to evaluate the usage of my MySQL db. This graphed has raised my attention:
I assume the blue means connections, and the orange processes.
I'm trying to get a deep understanding of what this graph actually means, and act accordingly.
If I understand correctly, it seems as if I'm creating multiple connections per script (process). What situations can cause such a behavior (in addition to simply calling mysql_connect more than once), and how much does this effect performance?
668
The MySQL Clients send connection requests to the MySQL Server. A connection request is simply a TCP-IP connect message sent to port 3306 on the server host machine. Receiver Thread. Incoming connection requests are queued and then processed by the receiver thread one by one.
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The SHOW PROCESSLIST statement is one source of process information. For a comparison of this statement with other sources, see Sources of Process Information.
Type in MYSQL to get into the mysql command line. Type show processlist; in order to see current processes on the server.
mysql> SELECT CURRENT_USER(); Here is the output that displays the name of the current user. In the above, % tells us about localhost. mysql> SELECT CONNECTION_ID();
The blue line shows recently opened connections (i.e. opened since the last sample), while the orange one shows currently opened connections (at the time of sampling). The latter are processes in MySQL (the ones that show when you issue a SHOW PROCESSLIST command to MySQL -- it really means active connections)
This means that most connections stay opened for less than your sampling period. This is a good thing.
I am unable to find official documention for this feature.
182
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
