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/innodb-compression-tuning-monitoring.html
To guard against imposing this monitoring overhead by accident, you must enable the innodb_cmp_per_index_enabled configuration option before you can query the INNODB_CMP_PER_INDEX table. Overall application performance, CPU and I/O utilization and ...To dig deeper into performance considerations for compressed tables, you can monitor compression performance at runtime using the Information Schema tables described in Example 17.1, “Using the Compression Information Schema ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb.html
InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. This section explains how to optimize database operations for InnoDB tables.
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. OPTIMIZE TABLE copies the data part of ...The reorganized tables require less disk I/O to perform full table ...When using COMPACT row format and variable-length character sets, such as utf8mb4 or sjis, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-developing.html
The data stored through the daemon_memcached plugin goes into VARCHAR, TEXT, or BLOB columns, and must be converted to do numeric operations. Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-ddl-operations.html
Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated indexes by creating the table without secondary indexes, then adding secondary indexes after the data is ... Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-ddl.html
You can access the underlying InnoDB table (which is test.demo_test by default) through standard SQL interfaces. The InnoDB table is either IS (intention shared) or IX (intention exclusive) locked for all operations in a transaction. However, there ...If this option is set to a value greater than 1, use READ UNCOMMITTED queries to find rows that were just ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-monitors.html
InnoDB monitors provide information about the InnoDB internal state. This information is useful for performance tuning. ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-compression.html
This section describes InnoDB table compression, which is supported with InnoDB tables that reside in file_per_table tablespaces or general tablespaces. Table compression is enabled using the ROW_FORMAT=COMPRESSED attribute with CREATE TABLE or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-usage.html
When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-optimizer-statistics.html
You can query optimizer statistics data in the mysql.innodb_table_stats and mysql.innodb_index_stats tables. You can manually modify the mysql.innodb_table_stats and mysql.innodb_index_stats tables to force a specific query optimization plan or to ...Persistent optimizer statistics also provide control and flexibility with these additional benefits: You can use the innodb_stats_auto_recalc configuration option to control whether statistics are updated automatically after substantial changes to a ...