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-partitions-table.html
PARTITION_EXPRESSION The expression for the partitioning function used in the CREATE TABLE or ALTER TABLE statement that created the table's current partitioning scheme. Each row in this table corresponds to an individual partition or subpartition ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
See Chapter 17, The InnoDB Storage Engine, and Chapter 18, Alternative Storage Engines. When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-attributes-table.html
Attributes are shown exactly as set using CREATE USER and ALTER USER statements with ATTRIBUTE or COMMENT options. The USER_ATTRIBUTES table (available as of MySQL 8.0.21) provides information about user comments and user attributes. The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benchmarking.html
If you did not make a deliberate decision about the storage engine, and you want to preview how certain tables work when created using InnoDB, issue the command ALTER TABLE table_name ENGINE=InnoDB; for each table. Alternatively, to run test queries ... If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with default-storage-engine=innodb defined in the [mysqld] section of the MySQL server option ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of compression. Compression ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
Consistent read does not work over ALTER TABLE operations that make a temporary copy of the original table and delete the original table when the temporary copy is built. A consistent read means that InnoDB uses multi-versioning to present to a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
A table-copying ALTER TABLE operation on a table that resides in a shared tablespace can increase the amount of disk space occupied by the tablespace. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
The innodb_api_enable_mdl option can be used to lock the table at the MySQL level, so that the mapped table cannot be dropped or altered by DDL through the SQL interface. The InnoDB memcached plugin implements memcached as a MySQL plugin daemon ...