You can easily run the following line at command prompt to retrieve the MySQL server uptime statistics along with the number of connected threads, the information regarding expensive queries, Queries per second on average, etc. In other words, it’s a quick and simple approach to determine the mysql instance’s state.
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqladmin -u root -p status
Enter password: **********
Uptime: 662530 Threads: 2 Questions: 2 Slow queries: 0 Opens: 117 Flush tables: 3 Open tables: 36 Queries per second avg: 0.000
Happy learning!!!
Big Data and SQL 