Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 39. Optimizing the Server > Accessing Server Status Variables
39.1.2. Accessing Server Status Variables
The server tracks many aspects of its own operation using a set of status variables. It makes the current values of these variables available through the SHOW STATUS statement, which you use much like SHOW VARIABLES:
mysql> SHOW STATUS;
+--------------------------------+-----------+
| Variable_name | Value |
+--------------------------------+-----------+
| Aborted_clients | 244 |
| Aborted_connects | 1 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 1 |
| Bytes_received | 319102331 |
| Bytes_sent | 178928432 |
| Com_admin_commands | 0 |
...
