Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: information_schema »View: INNODB_METRICS
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0012 seconds.)
SELECT * FROM `INNODB_METRICS`
NAMESUBSYSTEMCOUNTMAX_COUNTMIN_COUNTAVG_COUNTCOUNT_RESETMAX_COUNT_RESETMIN_COUNT_RESETAVG_COUNT_RESETTIME_ENABLEDTIME_DISABLEDTIME_ELAPSEDTIME_RESETSTATUSTYPECOMMENT
metadata_table_handles_opened metadata 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of table handles opened
metadata_table_handles_closed metadata 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of table handles closed
metadata_table_reference_count metadata 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Table reference counter
metadata_mem_pool_size metadata 2097152 2097152 2097152 NULL 2097152 2097152 2097152 NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled value Size of a memory pool InnoDB uses to store data di...
lock_deadlocks lock 0 NULL NULL 0 0 NULL NULL NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled counter Number of deadlocks
lock_timeouts lock 0 NULL NULL 0 0 NULL NULL NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled counter Number of lock timeouts
lock_rec_lock_waits lock 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of times enqueued into record lock wait que...
lock_table_lock_waits lock 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of times enqueued into table lock wait queu...
lock_rec_lock_requests lock 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of record locks requested
lock_rec_lock_created lock 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of record locks created
lock_rec_lock_removed lock 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of record locks removed from the lock queue
lock_rec_locks lock 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Current number of record locks on tables
lock_table_lock_created lock 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of table locks created
lock_table_lock_removed lock 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Number of table locks removed from the lock queue
lock_table_locks lock 0 NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL disabled counter Current number of table locks on tables
lock_row_lock_current_waits lock 0 0 NULL 0 0 0 NULL NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled status_counter Number of row locks currently being waited for (in...
lock_row_lock_time lock 153 153 NULL 0.00005806189397898159 153 153 NULL NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled status_counter Time spent in acquiring row locks, in milliseconds...
lock_row_lock_time_max lock 24 24 0 NULL 24 24 0 NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled value The maximum time to acquire a row lock, in millise...
lock_row_lock_waits lock 75 75 NULL 0.0000284617127347949 75 75 NULL NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled status_counter Number of times a row lock had to be waited for (i...
lock_row_lock_time_avg lock 2 2 0 NULL 2 2 0 NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled value The average time to acquire a row lock, in millise...
buffer_pool_size server 16777216 16777216 16777216 NULL 16777216 16777216 16777216 NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled value Server buffer pool size (all buffer pools) in byte...
buffer_pool_reads buffer 40643 40643 NULL 0.01542359187573692 40643 40643 NULL NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled status_counter Number of reads directly from disk (innodb_buffer_...
buffer_pool_read_requests buffer 2202722 2202722 NULL 0.8359098773148386 2202722 2202722 NULL NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled status_counter Number of logical read requests (innodb_buffer_poo...
buffer_pool_write_requests buffer 156176 156176 NULL 0.05926715264092437 156176 156176 NULL NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled status_counter Number of write requests (innodb_buffer_pool_write...
buffer_pool_wait_free buffer 0 0 NULL 0 0 0 NULL NULL 2019-05-20 14:52:55 NULL 2635119 NULL enabled status_counter Number of times waited for free buffer (innodb_buf...