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 660000 583874611056 0 0 0 0 0 0 7 163840 892570800 0 0 0 5 18652128 65536 25036 40500 4 0 0 1003
sakila film 616304 325426620816 0 0 0 0 0 0 15 294912 2015784672 0 0 0 5 23290080 196608 147213 49395 12 11 6 1011
sakila film_actor 660800 119696508624 0 0 0 0 0 0 15 294912 1677164016 0 0 0 5 21156960 196608 142155 54453 12 10 0 5473
sakila category 20540 12211168464 0 0 0 0 0 0 4 114688 1837952160 0 0 0 5 22466928 16384 487 15897 1 1 1 16
sakila city 51 2806424016 0 0 0 0 0 0 7 163840 1981296240 0 0 0 5 40828656 65536 26640 38896 4 0 1 601
sakila country 25 2800064784 0 0 0 0 0 0 4 114688 1879990992 0 0 0 5 654447024 16384 3739 12645 1 0 1 110
sakila address 26 2299757856 0 0 0 0 0 0 9 196608 2628084096 0 0 0 5 66968352 98304 51858 46446 6 0 2 605
sakila actor 800 2141726400 0 0 0 0 0 0 4 114688 1768010112 0 0 0 5 38812752 16384 7507 8877 1 0 0 200
sys sys_config 1 1103912304 0 0 0 0 0 0 4 114688 1309361328 0 0 0 5 78542112 16384 338 16046 1 0 1 6
mysql default_roles 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 0 0
mysql columns_priv 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 0 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 engine_cost 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 112 16272 1 0 0 2
test19 cours 0 0 0 0 0 0 0 0 4 114688 2497543488 0 0 0 5 336856080 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
mysql index_stats 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 8088 8296 1 0 0 121
mysql time_zone_leap_second 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 0 0
mysql role_edges 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 1 0
mysql gtid_executed 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 0 0
mysql dd_properties 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 47 16337 1 0 1 1
mysql time_zone 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 0 0
mysql password_history 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 0 0
mysql servers 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 16384 0 16384 1 0 0 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 0 0
Query results operations