SQL-Browser

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

   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_POOL_STATS`
Table properties of `INNODB_BUFFER_POOL_STATS` (32 Fields)Name
Engine
Row Format
Charset
Collation
Comment
 

 

Fields of table `INNODB_BUFFER_POOL_STATS`
insert new field

 FieldTypeSizeNULLKeyAttributeDefaultExtraCollationComment
edit field  delete field  1.POOL_IDbigint21nounsigned0
edit field  delete field  2.POOL_SIZEbigint21nounsigned0
edit field  delete field  3.FREE_BUFFERSbigint21nounsigned0
edit field  delete field  4.DATABASE_PAGESbigint21nounsigned0
edit field  delete field  5.OLD_DATABASE_PAGESbigint21nounsigned0
edit field  delete field  6.MODIFIED_DATABASE_PAGESbigint21nounsigned0
edit field  delete field  7.PENDING_DECOMPRESSbigint21nounsigned0
edit field  delete field  8.PENDING_READSbigint21nounsigned0
edit field  delete field  9.PENDING_FLUSH_LRUbigint21nounsigned0
edit field  delete field  10.PENDING_FLUSH_LISTbigint21nounsigned0
edit field  delete field  11.PAGES_MADE_YOUNGbigint21nounsigned0
edit field  delete field  12.PAGES_NOT_MADE_YOUNGbigint21nounsigned0
edit field  delete field  13.PAGES_MADE_YOUNG_RATEdoubleno0
edit field  delete field  14.PAGES_MADE_NOT_YOUNG_RATEdoubleno0
edit field  delete field  15.NUMBER_PAGES_READbigint21nounsigned0
edit field  delete field  16.NUMBER_PAGES_CREATEDbigint21nounsigned0
edit field  delete field  17.NUMBER_PAGES_WRITTENbigint21nounsigned0
edit field  delete field  18.PAGES_READ_RATEdoubleno0
edit field  delete field  19.PAGES_CREATE_RATEdoubleno0
edit field  delete field  20.PAGES_WRITTEN_RATEdoubleno0
edit field  delete field  21.NUMBER_PAGES_GETbigint21nounsigned0
edit field  delete field  22.HIT_RATEbigint21nounsigned0
edit field  delete field  23.YOUNG_MAKE_PER_THOUSAND_GETSbigint21nounsigned0
edit field  delete field  24.NOT_YOUNG_MAKE_PER_THOUSAND_GETSbigint21nounsigned0
edit field  delete field  25.NUMBER_PAGES_READ_AHEADbigint21nounsigned0
edit field  delete field  26.NUMBER_READ_AHEAD_EVICTEDbigint21nounsigned0
edit field  delete field  27.READ_AHEAD_RATEdoubleno0
edit field  delete field  28.READ_AHEAD_EVICTED_RATEdoubleno0
edit field  delete field  29.LRU_IO_TOTALbigint21nounsigned0
edit field  delete field  30.LRU_IO_CURRENTbigint21nounsigned0
edit field  delete field  31.UNCOMPRESS_TOTALbigint21nounsigned0
edit field  delete field  32.UNCOMPRESS_CURRENTbigint21nounsigned0

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