You can use the following commands on Linux or Unix-like systems:[donotprint]
Tutorial details | |
---|---|
Difficulty | Easy (rss) |
Root privileges | No |
Requirements | None |
Time | 1m |
a) mysqladmin status command
b) MySQL show status command
c) netstat or ss commands
mysqladmin status command example
Open the terminal App or login to the remote server using ssh:
ssh vivek@server1.cyberciti.biz
Type the following command to get a short status message from the MySQL server:
mysqladmin status ## OR ## mysqladmin status -u root -p ## OR ## mysqladmin status -h db1.cyberciti.biz -u root -p
Sample outputs:
Uptime: 691356 Threads: 5 Questions: 83237956 Slow queries: 102736 Opens: 3585 Flush tables: 1 Open tables: 1019 Queries per second avg: 120.398
MySQL show status command to see open database connections example
First, connect to the your mysql server:
mysql -u root -p
Type the following sql query to see the number of connection attempts to the MySQL server includes both failed and successful connection attempts:
mysql> show status like 'Conn%';
Sample outputs:
mysql> show status like '%onn%'; +--------------------------+---------+ | Variable_name | Value | +--------------------------+---------+ | Aborted_connects | 7 | | Connections | 6304067 | | Max_used_connections | 85 | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_finished_connects | 0 | | Threads_connected | 7 |Use show processlist sql command to see the number of open connections
Type the following sql command at mysql> prompt to see the number of currently open connections:
mysql> show processlist; +---------+------------+-------------------+------------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+------------+-------------------+------------+---------+------+-------+------------------+ | 6297128 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 6308321 | faqwpblogu | 10.10.29.66:42945 | lesaibkfaq | Sleep | 1 | | NULL | | 6308323 | faqwpblogu | 10.10.29.74:46993 | lesaibkfaq | Sleep | 0 | | NULL | | 6308325 | faqwpblogu | 10.10.29.74:46995 | lesaibkfaq | Sleep | 1 | | NULL | | 6308326 | faqwpblogu | 10.10.29.74:46996 | lesaibkfaq | Sleep | 0 | | NULL | +---------+------------+-------------------+------------+---------+------+-------+------------------+ 5 rows in set (0.00 sec)
The above output indicates four currently open connection for user called 'faqwpblogu' from app server located at 10.10.29.66 and 10.10.29.74.
MySQL show status sql command summary
I suggest that you read the following pages for more info:
Use netstat or ss (Linux only) command to list open database connections
The syntax is as follows for netstat command or ss command:
netstat -nat | grep 10.10.29.68:3306This will just give you an overview. I suggest that you use above sql commands only.
Category | List of Unix and Linux commands |
---|---|
File Management | cat |
Firewall | Alpine Awall • CentOS 8 • OpenSUSE • RHEL 8 • Ubuntu 16.04 • Ubuntu 18.04 • Ubuntu 20.04 |
Network Utilities | dig • host • ip • nmap |
OpenVPN | CentOS 7 • CentOS 8 • Debian 10 • Debian 8/9 • Ubuntu 18.04 • Ubuntu 20.04 |
Package Manager | apk • apt |
Processes Management | bg • chroot • cron • disown • fg • jobs • killall • kill • pidof • pstree • pwdx • time |
Searching | grep • whereis • which |
User Information | groups • id • lastcomm • last • lid/libuser-lid • logname • members • users • whoami • who • w |
WireGuard VPN | Alpine • CentOS 8 • Debian 10 • Firewall • Ubuntu 20.04 |
Nice, it really helped to me. Congrats
Hi,
1.Could you explain me this :
Uptime: 5067843 Threads: 9 Questions: 381272925 Slow queries: 5072 Opens: 3443635 Flush tables: 1 Open tables: 400 Queries per second avg: 75.233
2. When i run this command the server asks me a password:
mysql -u root -p
hope to help
Abdi
Very helpful, thanks a lot :)