SHOW GLOBAL STATUS;
(Redirected from SHOW GLOBAL STATUS)
Jump to navigation
Jump to search
.../... 542 rows in set (0.010 sec)
MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_%'; +---------------------------------------+--------------------------------------------------+ | Variable_name | Value | +---------------------------------------+--------------------------------------------------+ | Innodb_buffer_pool_dump_status | | | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 250801 5:24:06 | | Innodb_buffer_pool_resize_status | | | Innodb_buffer_pool_load_incomplete | OFF | | Innodb_buffer_pool_pages_data | 6853 | | Innodb_buffer_pool_bytes_data | 112279552 | | Innodb_buffer_pool_pages_dirty | 0 | | Innodb_buffer_pool_bytes_dirty | 0 | | Innodb_buffer_pool_pages_flushed | 4215 | | Innodb_buffer_pool_pages_free | 837 | | Innodb_buffer_pool_pages_misc | 337 | | Innodb_buffer_pool_pages_total | 8027 | | Innodb_buffer_pool_read_ahead_rnd | 0 | | Innodb_buffer_pool_read_ahead | 94 | | Innodb_buffer_pool_read_ahead_evicted | 0 | | Innodb_buffer_pool_read_requests | 7660036 | | Innodb_buffer_pool_reads | 45925 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 16768 | +---------------------------------------+--------------------------------------------------+ 19 rows in set (0.001 sec)
Related[edit]
SHOW GLOBAL VARIABLES; SHOW GLOBAL STATUS WHERE Variable_name = 'Innodb_buffer_pool_pages_free';
See also[edit]
Advertising:
