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 `OLDEST_MODIFICATION` DESC 
[ 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 Descending Ascending 1 ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE PAGE_STATE IO_FIX IS_OLD FREE_PAGE_CLOCK
0 444 0 286 SYSTEM 1 0 NO 5473542348 5473542272 4034238901 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793764
0 479 0 341 UNDO_LOG 0 0 NO 5473542348 5473541268 4034251858 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793832
0 450 0 285 SYSTEM 1 0 NO 5473541248 5473541172 4034238901 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793764
0 154 0 369 UNDO_LOG 0 0 NO 5473541248 5473540173 4034251856 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793832
0 153 0 284 SYSTEM 1 0 NO 5473540153 5473540061 4034238901 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793764
0 299 0 431 UNDO_LOG 0 0 NO 5473540153 5473539092 4034251803 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793832
0 282 0 283 SYSTEM 1 0 NO 5473539056 5473538980 4034238901 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793764
0 537 0 417 UNDO_LOG 0 0 NO 5473539056 5473537996 4034251780 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793832
0 286 0 282 SYSTEM 1 0 NO 5473537976 5473537900 4034237565 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793703
0 221 0 313 UNDO_LOG 0 0 NO 5473537976 5473536929 4034251367 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793832
0 274 0 281 SYSTEM 1 0 NO 5473536909 5473536833 4034237564 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793703
0 278 0 426 UNDO_LOG 0 0 NO 5473536909 5473535862 4034251039 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793832
0 231 0 280 SYSTEM 1 0 NO 5473535842 5473535766 4034237564 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793703
0 304 0 422 UNDO_LOG 0 0 NO 5473535842 5473534781 4034250982 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793804
0 258 0 279 SYSTEM 1 0 NO 5473534781 5473534021 4031828130 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793703
0 363 0 357 UNDO_LOG 0 0 NO 5473534781 5473533799 4034250915 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793804
0 398 0 278 SYSTEM 1 0 NO 5473534737 5473533690 4033268849 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793703
0 183 0 397 UNDO_LOG 0 0 NO 5473534737 5473533484 4034250913 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793804
0 275 0 277 SYSTEM 1 0 NO 5473534693 5473533359 4032453314 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793703
0 427 65 6 INDEX 0 0 NO 5473534110 5473533323 4034250912 `bill_tracking`.`it_asset_monitoring` idx_it_asset_monitoring_check 5 65 0 FILE_PAGE IO_NONE NO 17793804
0 170 65 3 INDEX 0 0 YES 5473534130 5473533246 4034250882 `bill_tracking`.`it_asset_monitoring` PRIMARY 5 250 0 FILE_PAGE IO_NONE NO 17793804
0 506 0 354 UNDO_LOG 0 0 NO 5473534693 5473533149 4034250911 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793804
0 225 0 276 SYSTEM 1 0 NO 5473534649 5473533053 4032453313 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793703
0 464 0 445 UNDO_LOG 0 0 NO 5473534649 5473532039 4034250851 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793804
0 210 0 275 SYSTEM 1 0 NO 5473534605 5473531943 4033832040 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 17793703
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