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
Customise 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 `NEWEST_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 Descending Ascending 1 OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE PAGE_STATE IO_FIX IS_OLD FREE_PAGE_CLOCK
0 158 9 3 INDEX 0 0 YES 176003134615 176003027850 2891153157 `phpmyadmin`.`pma__recent` PRIMARY 1 475 0 FILE_PAGE IO_NONE NO 61771
0 200 0 226 SYSTEM 0 0 NO 176003134595 176003133203 2891151871 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61732
0 317 0 1815 UNDO_LOG 0 0 NO 176003134595 176003133203 2891158264 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61842
0 348 0 1839 INODE 0 0 NO 176003134004 176003087437 2891155702 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61815
0 285 0 0 FILE_SPACE_HEADER 0 0 NO 176003134004 176002997085 2891152474 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61754
0 82 0 225 SYSTEM 0 0 NO 176003133183 176003131768 2891151871 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61732
0 212 0 1814 UNDO_LOG 0 0 NO 176003133183 176003057508 2891154495 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61785
0 115 0 224 SYSTEM 0 0 NO 176003131748 176003130322 2891151871 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61732
0 303 0 1806 UNDO_LOG 0 0 NO 176003131748 176003039270 2891154493 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61785
0 107 0 223 SYSTEM 0 0 NO 176003130302 176003128756 2891151871 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61732
0 134 0 1324 UNDO_LOG 0 0 NO 176003130302 176002975226 2891152471 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61754
0 316 0 1291 UNDO_LOG 0 0 NO 176003128736 176003096565 2891156500 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61829
0 360 0 222 SYSTEM 0 0 NO 176003128736 176003127341 2891148228 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61705
0 289 0 1314 UNDO_LOG 0 0 NO 176003127321 176003126099 2891157616 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61840
0 318 0 221 SYSTEM 0 0 NO 176003127321 176003127229 2891148228 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61705
0 131 0 1303 UNDO_LOG 0 0 NO 176003126079 176003124871 2891157517 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61840
0 116 0 220 SYSTEM 0 0 NO 176003126079 176003126003 2891148227 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61705
0 126 0 1298 UNDO_LOG 0 0 NO 176003124851 176003123603 2891157045 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61829
0 100 0 219 SYSTEM 0 0 NO 176003124851 176003124775 2891148227 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61705
0 25 0 1297 UNDO_LOG 0 0 NO 176003123603 176003121740 2891156949 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61829
0 232 0 218 SYSTEM 0 0 NO 176003123603 176003122900 2891148227 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61705
0 61 0 1296 UNDO_LOG 0 0 NO 176003123559 176003120468 2891156856 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61829
0 1 0 217 SYSTEM 1 0 NO 176003123559 176003121628 2890994589 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61815
0 93 0 1813 UNDO_LOG 0 0 NO 176003123515 176003119212 2891156665 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61829
0 104 0 216 SYSTEM 1 0 NO 176003123515 176003120372 2890994589 NULL NULL 0 0 0 FILE_PAGE IO_NONE NO 61815
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