MySQL
keyboard_arrow_down 295 guides
chevron_leftServer settings Cookbook
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
Checking server status information in MySQL
schedule Aug 12, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
We can check server status information in MySQL using the SHOW STATUS
statement:
SHOW STATUS;
+-------------------------------------------------------+--------+| Variable_name | Value |+-------------------------------------------------------+--------+| Aborted_clients | 0 || Aborted_connects | 0 || Acl_cache_items_count | 0 || Binlog_cache_disk_use | 0 || Binlog_cache_use | 0 |
We have only shown the first few rows of the result due to the large number of returned results. You can check the official documentation page hereopen_in_new to learn about the definitions of each variable.
You can further filter results using the LIKE
operator:
SHOW STATUS LIKE 'Connect%';
+-----------------------------------+-------+| Variable_name | Value |+-----------------------------------+-------+| Connection_errors_accept | 0 || Connection_errors_internal | 0 || Connection_errors_max_connections | 0 || Connection_errors_peer_address | 0 || Connection_errors_select | 0 || Connection_errors_tcpwrap | 0 || Connections | 8 |+-----------------------------------+-------+
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!