PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-engines-table.html
This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. The ENGINES table has these columns: ENGINE The name of the storage engine. SUPPORT The server's level of support for the storage ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also be obtained using InnoDB buffer pool server status variables. The idea of ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cached-indexes-table.html
SELECT tables.NAME AS table_name, indexes.NAME AS index_name, cached.N_CACHED_PAGES AS n_cached_pages FROM INFORMATION_SCHEMA.INNODB_CACHED_INDEXES AS cached, INFORMATION_SCHEMA.INNODB_INDEXES AS indexes, INFORMATION_SCHEMA.INNODB_TABLES AS tables ... The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-per-index-table.html
row *************************** database_name: employees table_name: salaries index_name: emp_no compress_ops: 0 compress_ops_ok: 0 compress_time: 0 uncompress_ops: 1597 uncompress_time: 0 Notes Use these tables to measure the effectiveness of ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-table.html
row *************************** page_size: 16384 compress_ops: 0 compress_ops_ok: 0 compress_time: 0 uncompress_ops: 0 uncompress_time: 0 Notes Use these tables to measure the effectiveness of InnoDB table compression in your database. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmpmem-table.html
row *************************** page_size: 16384 buffer_pool_instance: 0 pages_used: 0 pages_free: 0 relocation_ops: 0 relocation_time: 0 Notes Use these tables to measure the effectiveness of InnoDB table compression in your database. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
row *************************** TABLE_ID: 71 NAME: col3 POS: 2 MTYPE: 1 PRTYPE: 524303 LEN: 10 HAS_DEFAULT: 0 DEFAULT_VALUE: NULL Notes You must have the PROCESS privilege to query this table. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-fields-table.html
row *************************** INDEX_ID: 117 NAME: col1 POS: 0 Notes You must have the PROCESS privilege to query this table. The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information ...