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$io_global_by_wait_by_latency`
event_name total total_latency avg_latency max_latency read_latency write_latency misc_latency count_read total_read avg_read count_write total_written avg_written
innodb/innodb_log_file 1510 8642846596560 5723739384 112813425120 1264386288 352699566384 8288882643888 8 70656 8832.0000 912 914432 1002.6667
innodb/innodb_data_file 3744 5834683029120 1558408896 206610177840 244942396512 68998385808 5520742246800 1445 28786688 19921.5834 1610 60342272 37479.6720
innodb/innodb_temp_file 278 881285014368 3170089824 81744599376 0 162221191968 719063822400 0 0 0.0000 199 5160960 25934.4724
sql/io_cache 82 350584110624 4275415848 250812213696 550781088 1441837584 348591491952 38 2049628 53937.5789 34 2049628 60283.1765
sql/binlog 419 192462822816 459338352 17898458688 977122080 990753984 190494946752 96 980 10.2083 14 3881 277.2143
sql/ERRMSG 70 50577051360 722529192 3949904640 28325899008 0 22251152352 42 4304192 102480.7619 0 0 0.0000
sql/binlog_index 38 46279522608 1217882160 28618768992 1483775568 0 44795747040 9 288 32.0000 0 0 0.0000
csv/metadata 8 3259621728 407452584 1375563024 540197328 0 2719424400 2 70 35.0000 0 0 0.0000
myisam/kfile 8 3145148160 393143520 2396345952 3114788688 0 30359472 4 904 226.0000 0 0 0.0000
mysys/cnf 5 2312353824 462470712 2290204752 2291542176 0 20811648 3 56 18.6667 0 0 0.0000
sql/casetest 15 829782624 55318824 743861184 0 0 829782624 0 0 0.0000 0 0 0.0000
csv/data 11 387012912 35182752 200891856 61220016 0 325792896 2 0 0.0000 0 0 0.0000
mysys/charset 3 262245984 87415152 239860368 239860368 0 22385616 1 19495 19495.0000 0 0 0.0000
myisam/dfile 12 60256944 5021280 10084272 0 0 60256944 0 0 0.0000 0 0 0.0000
sql/pid 3 17251872 5750448 12990384 0 2934624 14317248 0 0 0.0000 1 4 4.0000
sql/misc 2 14479344 7239672 10614384 0 0 14479344 0 0 0.0000 0 0 0.0000
Query results operations