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/archive-storage-engine.html
When you create an ARCHIVE table, the storage engine creates files with names that begin with the table name. The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
This option prevents the replication applier from taking actions such as creating temporary tables and executing LOAD DATA INFILE requests, which increases the security of the channel. OFF: The replica sets sql_require_primary_key = OFF; no ...If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
One symptom of fragmentation is that a table takes more space than it “should” take. Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
Data directory initialization creates time zone tables in the mysql schema but does not populate them. Within the data directory, the server creates the mysql system schema and its tables, including the data dictionary tables, grant tables, time ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-crash-recovery.html
If your tables become corrupted frequently, you should try to find the reason why. For an explanation of how MyISAM tables can become corrupted, see Section 18.2.4, “MyISAM Table Problems”. If you run mysqld with external locking disabled (which ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
Other Uses for Cast Operations The cast functions are useful for creating a column with a specific type in a CREATE TABLE ... SELECT statement: mysql> CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE) AS c1; mysql> SHOW CREATE TABLE ... Table ...A common use for BINARY is to force a character string comparison to be done byte by byte using numeric byte values rather than character by ...
https://dev.mysql.com/doc/refman/8.0/en/static-format.html
Creating a table having such columns with an explicit ROW_FORMAT clause does not raise an error or warning; the format specification is ignored. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Also, ...Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
An InnoDB table created with ROW_FORMAT=COMPRESSED can use a smaller page size on disk than the configured innodb_page_size value. The compressed page size is specified through the CREATE TABLE or ALTER TABLE KEY_BLOCK_SIZE parameter. Specify a ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. Benefits of BKA include improved join performance due to more efficient table scanning. Moreover, a join buffer can ...The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-monitoring.html
You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...To monitor a cloning operation on the donor MySQL server instance, use the clone stage events, as described in Monitoring Cloning Operations Using Performance Schema Stage ...