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/rebuilding-tables.html
If you need to rebuild an InnoDB table because a CHECK TABLE operation indicates that a table upgrade is required, use mysqldump to create a dump file and mysql to reload the file. For example, if t1 is an InnoDB table, use this statement: ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE). In some extreme cases, you can create the indexes even faster by turning them off with ALTER TABLE ... DISABLE KEYS before ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
If no row has the digest value for the statement that just completed, and the table is not full, a new row is created for the statement. If no row has the statement digest value for the statement that just completed, and the table is full, the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
If you wish to make such information hidden from queries that select from these tables, you can do so by setting the value of the show_gipk_in_create_table_and_information_schema server system variable to OFF. INFORMATION_SCHEMA provides access to ...Other terms that are sometimes used for this information are data dictionary and system ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table t1. Online DDL improves several aspects of MySQL operation: ...Reduced ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
(myisampack creates an intermediate file named tbl_name.TMD in the database directory while it compresses the table. When the table is used later, the server reads into memory the information needed to decompress columns. MySQL uses mmap() when ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
For more information about permitted partitioning column types and partitioning functions, see Section 26.2, “Partitioning Types”, as well as Section 15.1.20, “CREATE TABLE Statement”, which provides partitioning syntax descriptions and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
Creating a New Table and Column Mapping This example shows how to setup your own InnoDB table with the daemon_memcached plugin. mysql> CREATE TABLE city ( city_id VARCHAR(32), name VARCHAR(1024), state VARCHAR(1024), country VARCHAR(1024), flags ...