SQL-Browser

[Tools]  Database: `information_schema`  Table: `INNODB_BUFFER_PAGE`

   show less  show more             Upload SQL file   Search   MySQl Documentation
The execution of SQL Statements can manipulate data. TAKE CARE! The Authors don't accept any liability for damaged or lost data.

Tables of Database `information_schema` edit
create table:
copy table:
select table:     

 

Table `INNODB_BUFFER_PAGE`
Table properties of `INNODB_BUFFER_PAGE` (20 Fields)Name
Engine
Row Format
Charset
Collation
Comment
 

 

Fields of table `INNODB_BUFFER_PAGE`
insert new field

 FieldTypeSizeNULLKeyAttributeDefaultExtraCollationComment
edit field  delete field  1.POOL_IDbigint21nounsigned0
edit field  delete field  2.BLOCK_IDbigint21nounsigned0
edit field  delete field  3.SPACEbigint21nounsigned0
edit field  delete field  4.PAGE_NUMBERbigint21nounsigned0
edit field  delete field  5.PAGE_TYPEvarchar64yesutf8_general_ci
edit field  delete field  6.FLUSH_TYPEbigint21nounsigned0
edit field  delete field  7.FIX_COUNTbigint21nounsigned0
edit field  delete field  8.IS_HASHEDvarchar3yesutf8_general_ci
edit field  delete field  9.NEWEST_MODIFICATIONbigint21nounsigned0
edit field  delete field  10.OLDEST_MODIFICATIONbigint21nounsigned0
edit field  delete field  11.ACCESS_TIMEbigint21nounsigned0
edit field  delete field  12.TABLE_NAMEvarchar1024yesutf8_general_ci
edit field  delete field  13.INDEX_NAMEvarchar1024yesutf8_general_ci
edit field  delete field  14.NUMBER_RECORDSbigint21nounsigned0
edit field  delete field  15.DATA_SIZEbigint21nounsigned0
edit field  delete field  16.COMPRESSED_SIZEbigint21nounsigned0
edit field  delete field  17.PAGE_STATEvarchar64yesutf8_general_ci
edit field  delete field  18.IO_FIXvarchar64yesutf8_general_ci
edit field  delete field  19.IS_OLDvarchar3yesutf8_general_ci
edit field  delete field  20.FREE_PAGE_CLOCKbigint21nounsigned0

Indexes of table `INNODB_BUFFER_PAGE`
  Name Columns Size Type Duplicates allowed Cardinality Comment
No Indexes in Table