Name
SHOW STATUS
Synopsis
SHOW [GLOBAL|LOCAL|SESSION] STATUS [LIKE 'pattern
'|WHEREexpression
]
This statement displays 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. Here is an example of
how you can use this statement with the LIKE
clause:
SHOW STATUS LIKE '%log%'; +------------------------------+-------+ | Variable_name | Value | +------------------------------+-------+ | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_engine_logs | 0 | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 0 | | Innodb_log_writes | 1 | | Innodb_os_log_fsyncs | 3 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 512 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | +------------------------------+-------+
The results show any system variable in which the variable name
has the word log in it. This is a new server
installation, so the results have small or zero values. If we wanted
to eliminate the InnoDB logs from the results, we could use the
WHERE
clause like so:
SHOW STATUS WHERE Variable_name LIKE '%log%' AND Variable_name NOT LIKE '%Innodb%'; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | Binlog_cache_disk_use ...
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.