Jump to Navigation

059 - Show Status

SHOW statement display status information and variables from the server. You can reduce the number
of variables shown with the LIKE clause, based on a naming pattern for the variable name.
Similarly, the WHERE clause may be used to refine the results set. The following is an example
of how you can use this statement with the LIKE clause.

mysql> SHOW STATUS
-> WHERE Variable_name LIKE '%log%'
-> AND Variable_name NOT LIKE '%Innodb%';

+-----------------------------+-------+
| Variable_name                | Value |
+-----------------------------+-------+
| Binlog_cache_disk_use     | 0       |
| Binlog_cache_use            | 0       |
| Com_show_binlog_events | 0       |
| Com_show_binlogs          | 0       |
| Com_show_logs              | 0       |
| Tc_log_max_pages_used  | 0       |
| Tc_log_page_size            | 0       |
| Tc_log_page_waits           | 0       |
+-----------------------------+-------+
8 rows in set (0.00 sec)

 

MySQL:


Main menu 2

Story | by Dr. Radut