Drop files here

SQL upload ( 0 ) x -

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:
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `x$schema_table_statistics_with_buffer`
table_schema table_name rows_fetched fetch_latency rows_inserted insert_latency rows_updated update_latency rows_deleted delete_latency io_read_requests io_read io_read_latency io_write_requests io_write io_write_latency io_misc_requests io_misc_latency innodb_buffer_allocated innodb_buffer_data innodb_buffer_free innodb_buffer_pages innodb_buffer_pages_hashed innodb_buffer_pages_old innodb_buffer_rows_cached
sakila film_category 1320000 1103532693648 0 0 0 0 0 0 7 163840 997375104 0 0 0 5 24304368 65536 25036 40500 4 0 0 1003
sakila film 1232634 577585015920 0 0 0 0 0 0 16 311296 2079644688 0 0 0 5 35066592 212992 155213 57779 13 11 7 1006
sakila film_actor 1321602 210484522512 0 0 0 0 0 0 17 327680 4073816208 0 0 0 5 26508240 229376 154150 75226 14 10 3 3402
sakila payment 32088 50649930672 0 0 0 0 0 0 65 1114112 3891696336 0 0 0 5 26930112 1015808 835288 180520 62 60 62 16079
sakila rental 41257 22679790144 0 0 0 0 0 0 70 1196032 20383839168 0 0 0 5 47466144 1097728 897591 200137 67 16 67 11221
sakila category 41080 18586885680 0 0 0 0 0 0 4 114688 1169606064 0 0 0 5 64291920 16384 487 15897 1 1 0 16
test19 ecurie 5 6768702864 0 0 0 0 0 0 4 114688 6710574816 0 0 0 5 323202528 16384 171 16213 1 0 1 4
sakila customer 330 4601790336 0 0 0 0 0 0 10 212992 4793162352 0 0 0 5 89601600 114688 58596 56092 7 0 2 600
sakila inventory 9466 3652047696 0 0 0 0 0 0 23 425984 4165195056 0 0 0 5 90586320 327680 186655 141025 20 0 20 3318
sakila staff 32 3213508320 0 0 0 0 0 0 6 147456 3009104208 0 0 0 5 113610288 49152 283 48869 3 0 2 2
sakila actor 1626 1441707168 0 0 0 0 0 0 5 131072 1350341520 0 0 0 5 26317104 32768 10353 22415 2 0 1 200
sys sys_config 3 1349620800 0 0 0 0 0 0 4 114688 702373584 0 0 0 5 866468592 16384 338 16046 1 0 0 6
sakila city 383 980175504 0 0 0 0 0 0 7 163840 1318488336 0 0 0 5 35060784 65536 26640 38896 4 0 0 601
sakila address 108 862673328 0 0 0 0 0 0 9 196608 1367693712 0 0 0 5 25723104 98304 51858 46446 6 0 0 605
sakila language 32 337502880 0 0 0 0 0 0 4 114688 809127792 0 0 0 5 27236880 16384 264 16120 1 0 0 6
sakila country 58 163150944 0 0 0 0 0 0 4 114688 837744336 0 0 0 5 27685680 16384 3739 12645 1 0 0 110
sakila store 6 14225904 0 0 0 0 0 0 4 114688 998723088 0 0 0 5 23122704 16384 52 16332 1 0 1 2
sku Cinema 0 0 0 0 0 0 0 0 4 114688 863571456 0 0 0 5 350194416 16384 0 16384 1 0 1 0
mysql time_zone_transition 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 1 0
mysql parameter_type_elements 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 1235 15149 1 0 1 32
mysql password_history 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 1 0
StdMdDB user 0 0 0 0 0 0 0 0 4 114688 1714902816 0 0 0 5 826360656 16384 0 16384 1 0 1 0
mysql servers 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 1 0
mysql time_zone_transition_type 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 1 0
mysql time_zone_name 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 1 0
Query results operations