Back to Basics - SHOW STATUS
(Page 10 of 10 )
In addition to all the variable information we can query, MySQL also keeps track of many useful counters and statistics. These numbers track how often various events occur. The SHOW STATUS command produces a tabular listing of all the statistics and their names.
To confuse matters a bit, MySQL refers to these counters as variables too. In a sense, they are variables, but they’re not variables you can set. They change as the server runs and handles traffic; you simply read them and reset them using the FLUSH STATUS command.
The SHOW STATUS command, though, offers a lot of insight into your server’s perfor mance. It’s covered in much greater depth in Appendix A.
Show INNODB Status
The SHOW INNODB STATUS status command provides a number of InnoDB-specific sta tistics. As we said earlier, InnoDB is one of MySQL’s storage engines; look for more on storage engines in Chapter 2.
The output of SHOW INNODB STATUS is different from that of SHOW STATUS in that it reads more as a textual report, with section headings and such. There are different sec tions of the report that provide information on semaphores, transaction statistics, buffer information, transaction logs, and so forth.
SHOW INNODB STATUS is covered in greater detail along with SHOW STATUS in Appendix A. Also, note that in a future version of MySQL, this command will be replaced with a more generic SHOW ENGINE STATUS command.
 | If you've enjoyed what you've seen here, or to get more information, click on the "Buy the book!" graphic. Pick up a copy today!
Visit the O'Reilly Network http://www.oreillynet.com for more online content. |
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
