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 customer 107 4178560848 0 0 0 0 0 0 9 196608 4105075920 0 0 0 5 47485152 98304 53205 45099 6 0 3 601
sys sys_config 47 3186837456 0 0 0 0 0 0 4 114688 1002817200 0 0 0 5 1873400496 16384 338 16046 1 0 0 6
sakila country 686 2721576528 0 0 0 0 0 0 4 114688 1263985536 0 0 0 5 46072224 16384 3739 12645 1 0 0 110
sakila address 189 2509015872 0 0 0 0 0 0 9 196608 1701822144 0 0 0 5 40748400 98304 51858 46446 6 0 3 605
sakila language 129 2416265280 0 0 0 0 0 0 4 114688 1998933552 0 0 0 5 61619712 16384 264 16120 1 0 0 6
sakila city 164 2118178656 0 0 0 0 0 0 7 163840 687849360 0 0 0 5 126930144 65536 26640 38896 4 0 0 601
sakila film 61 1994558016 0 0 0 0 0 0 16 311296 1804061424 0 0 0 5 33123552 212992 155213 57779 13 0 10 1006
sakila staff 30 1957328208 0 0 0 0 0 0 8 180224 2371030992 0 0 0 5 69305808 32768 267 32501 2 0 2 2
test19 ecurie 56 1453137312 0 0 0 0 0 0 4 114688 846105744 0 0 0 5 52278336 16384 171 16213 1 0 0 4
sakila payment 28 1281901104 0 0 0 0 0 0 50 868352 5377905456 0 0 0 5 41954880 770048 650236 119812 47 0 47 8530
test19 voiture 66 1051088544 0 0 0 0 0 0 5 131072 1198584288 0 0 0 5 59982384 32768 842 31926 2 0 0 14
sakila actor 26 1017464448 0 0 0 0 0 0 5 131072 850292256 0 0 0 5 304517136 32768 10353 22415 2 0 2 200
sakila store 3 735956496 0 0 0 0 0 0 5 131072 954722736 0 0 0 5 37860768 32768 66 32702 2 0 2 2
mysql columns 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 1523712 1117503 406209 93 53 36 4187
sakila rental 0 0 0 0 0 0 0 0 51 884736 25344096624 0 0 0 5 46763376 786432 689635 96797 48 0 37 16091
mysql tables 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 753664 532064 221600 46 37 6 409
mysql routines 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 294912 148799 146113 18 0 4 56
mysql index_column_usage 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 278528 147412 131116 17 4 12 1579
sakila film_actor 0 0 0 0 0 0 0 0 15 294912 1612453920 0 0 0 5 46903296 196608 142155 54453 12 0 12 5473
sakila inventory 0 0 0 0 0 0 0 0 14 278528 8017042176 0 0 0 5 47308272 180224 128388 51836 11 0 11 4591
mysql indexes 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 114688 59874 54814 7 4 2 360
mysql table_partitions 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 114688 0 114688 7 0 5 0
vedettfak fa 0 0 0 0 0 0 0 0 10 212992 1022365344 0 0 0 5 43888416 114688 78301 36387 7 0 7 1264
mysql triggers 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 98304 3640 94664 6 0 4 8
mysql collations 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 81920 29916 52004 5 3 1 273
Query results operations