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 payment 160440 255966782016 0 0 0 0 0 0 65 1114112 10101222912 0 0 0 5 54142176 1015808 835288 180520 62 60 0 16079
sakila rental 206252 74430665760 0 0 0 0 0 0 70 1196032 19104340464 0 0 0 5 43645536 1097728 897591 200137 67 16 50 11221
sakila staff 24 22756140528 0 0 0 0 0 0 5 131072 1468790928 0 0 0 5 44362032 32768 267 32501 2 0 1 2
sakila inventory 45830 10748743632 0 0 0 0 0 0 21 393216 6303632544 0 0 0 5 42895248 294912 178869 116043 18 0 11 4589
sakila city 124 4297037184 0 0 0 0 0 0 7 163840 3220028592 0 0 0 5 637193040 65536 26640 38896 4 0 0 601
Stefano vulcano 1 4028961552 0 0 0 0 0 0 4 114688 4230554592 0 0 0 5 35669040 16384 344 16040 1 0 1 4
world CountryLanguage 38 2654533728 0 0 0 0 0 0 27 1382 2220570000 0 0 0 11 118123632 NULL NULL NULL NULL NULL NULL NULL
vedettfak megye 33 2395542864 0 0 0 0 0 0 4 114688 1422312672 0 0 0 5 1102571712 16384 655 15729 1 0 0 19
sakila film 52 2185005504 0 0 0 0 0 0 16 311296 2791250880 0 0 0 5 768728400 212992 155213 57779 13 0 10 1006
sakila store 33 1880280864 0 0 0 0 0 0 5 131072 785473920 0 0 0 5 1008026448 32768 66 32702 2 0 1 2
sakila address 72 1453074480 0 0 0 0 0 0 8 180224 1775842464 0 0 0 5 36392400 81920 46431 35489 5 0 3 607
sakila language 54 1309624272 0 0 0 0 0 0 4 114688 982972848 0 0 0 5 71854992 16384 264 16120 1 0 0 6
vedettfak fa 2 1308625296 0 0 0 0 0 0 5 131072 1466409120 0 0 0 5 52547616 32768 8744 24024 2 0 2 624
sakila country 174 1290089856 0 0 0 0 0 0 4 114688 630065040 0 0 0 5 45776544 16384 3739 12645 1 0 0 110
sys sys_config 12 1233888480 0 0 0 0 0 0 4 114688 759940368 0 0 0 5 548301072 16384 338 16046 1 0 0 6
sakila customer 52 1038637248 0 0 0 0 0 0 9 196608 1488707088 0 0 0 5 36430944 98304 53205 45099 6 0 3 601
sku Attore 10 908708592 0 0 0 0 0 0 4 114688 924352704 0 0 0 5 36672240 16384 91 16293 1 0 0 1
Table_insertion ecurie 83 563009040 0 0 0 0 0 0 4 114688 1628083776 0 0 0 5 43154496 16384 171 16213 1 0 0 4
Table_insertion voiture 25 418541904 0 0 0 0 0 0 5 131072 932662896 0 0 0 5 34239216 32768 842 31926 2 0 0 14
TlapaleriaMalfoy Registro 26 367445760 0 0 0 0 0 0 4 114688 4198435824 0 0 0 5 40279536 16384 126 16258 1 0 0 2
Table_insertion pilote 27 356074752 0 0 0 0 0 0 4 114688 1183593840 0 0 0 5 22508112 16384 1119 15265 1 0 0 30
sakila actor 105 227997264 0 0 0 0 0 0 5 131072 5403780624 0 0 0 5 45695760 32768 10353 22415 2 0 0 200
sakila category 4 84957312 0 0 0 0 0 0 4 114688 789874800 0 0 0 5 75511392 16384 487 15897 1 0 0 16
world Country 2 26650800 0 0 0 0 0 0 2 462 339713088 0 0 0 5 30594960 NULL NULL NULL NULL NULL NULL NULL
mysql columns 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 1605632 1172274 433358 98 70 14 4232
Query results operations