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/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL Upgrade Process ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
innodb_tmpdir: Directory location for temporary table files created during online ALTER TABLE operations. innodb_api_enable_mdl: Locks table used by InnoDB memcached plugin, so that it cannot be dropped or altered by DDL through SQL interface.
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
You can use a number of extensions to ALTER TABLE for performing operations of this type on one or more partitions directly, as described in the following list: Rebuilding partitions. If you have deleted a large number of rows from a partition or if ... A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for such ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB instance. It does not provide information about internal InnoDB temporary tables used by the optimizer. The ...The number ...
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. These properties make this compression technique unsuitable for use in an update-intensive database system. When compression is working well for a data ...The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of ...
https://dev.mysql.com/doc/refman/8.0/en/cost-model.html
These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. The intent of these tables is to make it possible to easily adjust the cost estimates that the optimizer uses when it ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
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/partitioning-overview.html
However, if no columns are listed in the PARTITION BY KEY or PARTITION BY LINEAR KEY clause of the CREATE TABLE or ALTER TABLE statement used to create or modify a user-partitioned NDB table, then the table is not required to have an explicit ...The ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. If you run CHECKSUM TABLE against a view, the Checksum value is always NULL, and a warning is returned. For a nonexistent table, CHECKSUM TABLE returns NULL and ...You ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-close.html
Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed properly. If you get the following warning from CHECK TABLE or myisamchk, it means that this counter has gone out of sync: ...