«
dbrowse
Extended Server Status
This node is informative, descriptive, functional and terminating.
[definitions]
Query Path
Interactive Path
Synopsis
This is the extended server status report for the current database.
Description of Results
This page represents the same information you would receive if you ran the mysql> show status
command from the MySQL client program. It is very similar to the the results you get from the
Brief Server Status view. However, because I feel the large number of variables displayed here
does not warrant an attempt on my part to try and document them, I suggest you consult the MySQL
Reference Manual. This situation is similar to the Server Variables view, and they are
both presented here for your convience and reference.
For detailed documentation regarding the information displayed on this page, visit the MySQL Reference Manual section on Server Status Variables.
Node/View
| mysql> show status; | |
|---|---|
| Server Variable | Value |
| 132 rows in set (0.0027 seconds) | |
| Aborted Clients | 2,796 |
| Aborted Connects | 5,090 |
| Bytes Received | 377,675k |
| Bytes Sent | 979M |
| Com Admin Commands | 1,585,710 |
| Com Alter Table | 8 |
| Com Analyze | 0 |
| Com Backup Table | 0 |
| Com Begin | 0 |
| Com Change DB | 1,680,750 |
| Com Change Master | 0 |
| Com Check | 2 |
| Com Commit | 0 |
| Com Create DB | 3 |
| Com Create Function | 0 |
| Com Create Index | 0 |
| Com Create Table | 13 |
| Com Delete | 253 |
| Com Delete Multi | 0 |
| Com Drop DB | 1 |
| Com Drop Function | 0 |
| Com Drop Index | 0 |
| Com Drop Table | 7 |
| Com Flush | 2 |
| Com Grant | 0 |
| Com Ha Close | 0 |
| Com Ha Open | 0 |
| Com Ha Read | 0 |
| Com Insert | 6,723 |
| Com Insert Select | 0 |
| Com Kill | 0 |
| Com Load | 0 |
| Com Load Master Data | 0 |
| Com Load Master Table | 0 |
| Com Lock Tables | 0 |
| Com Optimize | 0 |
| Com Purge | 0 |
| Com Rename Table | 0 |
| Com Repair | 0 |
| Com Replace | 86 |
| Com Replace Select | 0 |
| Com Reset | 0 |
| Com Restore Table | 0 |
| Com Revoke | 0 |
| Com Rollback | 0 |
| Com Savepoint | 0 |
| Com Select | 5,963,633 |
| Com Set Option | 7,199 |
| Com Show Binlog Events | 0 |
| Com Show Binlogs | 0 |
| Com Show Create | 9,334 |
| Com Show Databases | 43 |
| Com Show Fields | 14,799 |
| Com Show Grants | 0 |
| Com Show Keys | 2,929 |
| Com Show Logs | 0 |
| Com Show Master Status | 0 |
| Com Show New Master | 0 |
| Com Show Open Tables | 0 |
| Com Show Processlist | 105 |
| Com Show Slave Hosts | 0 |
| Com Show Slave Status | 0 |
| Com Show Status | 365 |
| Com Show Innodb Status | 0 |
| Com Show Tables | 11,381 |
| Com Show Variables | 322 |
| Com Slave Start | 0 |
| Com Slave Stop | 0 |
| Com Truncate | 7 |
| Com Unlock Tables | 0 |
| Com Update | 1,800 |
| Connections | 100,977 |
| Created Tmp Disk Tables | 184,413 |
| Created Tmp Tables | 990,750 |
| Created Tmp Files | 0 |
| Delayed Insert Threads | 0 |
| Delayed Writes | 0 |
| Delayed Errors | 0 |
| Flush Commands | 2 |
| Handler Commit | 0 |
| Handler Delete | 2,289 |
| Handler Read First | 2,561,656 |
| Handler Read Key | 217,816,928 |
| Handler Read Next | 1,311,098,514 |
| Handler Read Prev | 15,789 |
| Handler Read Rnd | 150,802,592 |
| Handler Read Rnd Next | 280,056,390 |
| Handler Rollback | 0 |
| Handler Update | 1,726,485 |
| Handler Write | 30,959,612 |
| Key Blocks Used | 15,586 |
| Key Read Requests | 500,657,012 |
| Key Reads | 468 |
| Key Write Requests | 5,630,615 |
| Key Writes | 12,355 |
| Max Used Connections | 130 |
| Not Flushed Key Blocks | 0 |
| Not Flushed Delayed Rows | 0 |
| Open Tables | 363 |
| Open Files | 531 |
| Open Streams | 0 |
| Opened Tables | 424 |
| Total Queries | 197,550,995 |
| Qcache Queries In Cache | 7,860 |
| Qcache Inserts | 5,944,610 |
| Qcache Hits | 189,525,922 |
| Qcache Lowmem Prunes | 5,936,574 |
| Qcache Not Cached | 19,021 |
| Qcache Free Memory | 7,682,952 |
| Qcache Free Blocks | 2,234 |
| Qcache Total Blocks | 18,109 |
| Replication Status | NULL |
| Select Full Join | 83,906 |
| Select Full Range Join | 0 |
| Select Range | 394,766 |
| Select Range Check | 0 |
| Select Scan | 712,600 |
| Slave Open Temp Tables | 0 |
| Slave Running | Off |
| Slow Launch Threads | 0 |
| Slow Queries | 0 |
| Sort Merge Passes | 0 |
| Sort Range | 264,218 |
| Sort Rows | 150,846,322 |
| Sort Scan | 1,197,007 |
| Table Locks Immediate | 10,441,235 |
| Table Locks Waited | 0 |
| Threads Cached | 43 |
| Threads Created | 2,072 |
| Threads Connected | 47 |
| Threads Running | 1 |
| Uptime | 108 days 15 hours 7 min 44 sec |
