Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark 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 `INNODB_BUFFER_PAGE` ORDER BY `PAGE_STATE` ASC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
POOL_ID BLOCK_ID SPACE PAGE_NUMBER PAGE_TYPE FLUSH_TYPE FIX_COUNT IS_HASHED NEWEST_MODIFICATION OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE PAGE_STATE Ascending Descending 1 IO_FIX IS_OLD FREE_PAGE_CLOCK
0 0 0 138783 IBUF_INDEX 1 0 NO 4797196738929 0 1805222139 NULL NULL 177 13670 0 FILE_PAGE IO_NONE YES 0
0 1 142 106627 INDEX 0 0 NO 0 0 1805221264 `sms_dashboard`.`sms_records` PRIMARY 5 11159 0 FILE_PAGE IO_NONE YES 0
0 2 142 111807 INDEX 0 0 NO 0 0 1805222157 `sms_dashboard`.`sms_records` PRIMARY 7 15493 0 FILE_PAGE IO_NONE YES 0
0 3 142 75422 INDEX 0 0 NO 0 0 1805220771 `sms_dashboard`.`sms_records` PRIMARY 6 14043 0 FILE_PAGE IO_NONE YES 0
0 4 82 918420 INDEX 0 0 YES 0 0 1803695452 `pg_dashboard`.`pg_tracking` PRIMARY 49 9368 0 FILE_PAGE IO_NONE NO 263528310
0 5 82 598419 INDEX 1 0 NO 4797195105179 0 1804550563 `pg_dashboard`.`pg_tracking` idx_data_currency_reference 82 2624 0 FILE_PAGE IO_NONE NO 263520415
0 6 82 45466 INDEX 0 0 NO 0 0 1804994641 `pg_dashboard`.`pg_tracking` PRIMARY 51 9460 0 FILE_PAGE IO_NONE NO 263523946
0 7 82 918432 INDEX 0 0 YES 0 0 1803700156 `pg_dashboard`.`pg_tracking` PRIMARY 49 9259 0 FILE_PAGE IO_NONE NO 263526687
0 8 82 919999 INDEX 0 0 NO 0 0 1804995993 `pg_dashboard`.`pg_tracking` PRIMARY 50 9509 0 FILE_PAGE IO_NONE NO 263524681
0 9 82 594367 INDEX 0 0 NO 0 0 1804995588 `pg_dashboard`.`pg_tracking` PRIMARY 46 8739 0 FILE_PAGE IO_NONE NO 263524527
0 10 82 164270 INDEX 1 0 NO 4797196419131 0 1803605914 `pg_dashboard`.`pg_tracking` idx_data_currency_pg_chart 164 7204 0 FILE_PAGE IO_NONE NO 263527287
0 11 82 658312 INDEX 1 0 NO 4797196809098 0 1804860793 `pg_dashboard`.`pg_tracking` idx_data_currency_payment_chart 20 1026 0 FILE_PAGE IO_NONE NO 263535593
0 12 138 318889 INDEX 0 0 YES 0 0 1805185769 `agent_dashboard`.`agent_sheet_rows` PRIMARY 81 15021 0 FILE_PAGE IO_NONE NO 263515350
0 13 138 185246 INDEX 1 0 NO 4797183969059 0 1805178135 `agent_dashboard`.`agent_sheet_rows` uniq_provider_sheet_row 680 13600 0 FILE_PAGE IO_NONE NO 263513848
0 14 138 89015 INDEX 0 0 YES 0 0 1805178279 `agent_dashboard`.`agent_sheet_rows` PRIMARY 79 15072 0 FILE_PAGE IO_NONE NO 263513848
0 15 82 832434 INDEX 0 0 NO 0 0 1804995946 `pg_dashboard`.`pg_tracking` PRIMARY 48 9314 0 FILE_PAGE IO_NONE NO 263524673
0 16 142 103552 INDEX 0 0 NO 0 0 1805221082 `sms_dashboard`.`sms_records` PRIMARY 6 14733 0 FILE_PAGE IO_NONE YES 0
0 17 82 624553 INDEX 0 0 NO 0 0 1804995319 `pg_dashboard`.`pg_tracking` PRIMARY 46 8856 0 FILE_PAGE IO_NONE NO 263524527
0 18 0 174605 UNDO_LOG 1 0 NO 4797195966322 0 1805194655 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 263523262
0 19 142 52908 INDEX 0 0 NO 0 0 1805219969 `sms_dashboard`.`sms_records` PRIMARY 3 7435 0 FILE_PAGE IO_NONE YES 0
0 20 82 860037 INDEX 0 0 NO 0 0 1802375057 `pg_dashboard`.`pg_tracking` idx_data_currency_reference 531 15930 0 FILE_PAGE IO_NONE NO 263532289
0 21 138 360352 INDEX 0 0 YES 0 0 1805185128 `agent_dashboard`.`agent_sheet_rows` PRIMARY 107 15067 0 FILE_PAGE IO_NONE NO 263515350
0 22 142 99977 INDEX 0 0 NO 0 0 1805222641 `sms_dashboard`.`sms_records` PRIMARY 2 5013 0 FILE_PAGE IO_NONE YES 0
0 23 142 128148 INDEX 0 0 NO 0 0 1805223100 `sms_dashboard`.`sms_records` PRIMARY 6 13842 0 FILE_PAGE IO_NONE YES 0
0 24 138 133552 INDEX 0 0 NO 0 0 1802694861 `agent_dashboard`.`agent_sheet_rows` PRIMARY 833 15827 0 FILE_PAGE IO_NONE NO 263516959
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query