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/create-table.html
The innodb_file_per_table variable must be enabled to use the DATA DIRECTORY clause. You must have the FILE privilege to use the DATA DIRECTORY or INDEX DIRECTORY table option. If a MyISAM table is created with a DATA DIRECTORY or INDEX DIRECTORY ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
To store DYNAMIC tables in the system tablespace, either disable innodb_file_per_table and use a regular CREATE TABLE or ALTER TABLE statement, or use the TABLESPACE [=] innodb_system table option with CREATE TABLE or ALTER TABLE. The ...Importing a ...The pages that make up each table are arranged in a tree data structure called a B-tree ... The row format of a table determines how its rows ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...ERROR ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
Cannot Open Datafile With innodb_file_per_table enabled (the default), the following messages may appear at startup if a file-per-table tablespace file (.ibd file) is missing: [ERROR] InnoDB: Operating system error number 2 in a file operation. If ...See Section 17.6.1.4, “Moving or Copying InnoDB Tables” for information about creating clean ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-internal-data.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. The data exposed by the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-secretsfile-reader.html
Usage ndb_secretsfile_reader options file The options must include one of --filesystem-password or --filesystem-password-from-stdin, and the encryption password must be supplied, as shown here: > ndb_secretsfile_reader --filesystem-password=54kl14 ... ndb_secretsfile_reader gets the encryption key from an NDB encryption secrets file, given the ...--defaults-file Command-Line ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
To ensure that all InnoDB mutex instances are instrumented and enabled, add the following performance-schema-instrument rule to your MySQL configuration file: performance-schema-instrument='wait/synch/mutex/innodb/%=ON' If you do not require wait ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-understanding-innodb-locking.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. (The INFORMATION_SCHEMA ...A ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
To minimize space even further by storing table data in compressed form, specify ROW_FORMAT=COMPRESSED when creating InnoDB tables, or run the myisampack command on an existing MyISAM table. This can result in huge improvements by reducing the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
All InnoDB data and indexes are stored in B-trees, and their fill factor may vary from 50% to 100%. If the insertions into an index are always ascending and records are deleted only from the end, the InnoDB filespace management algorithm guarantees ...To speed up index scans, you can periodically perform a “null” ALTER TABLE operation, which causes MySQL to rebuild the table: ALTER TABLE tbl_name ENGINE=INNODB You can also use ALTER TABLE tbl_name FORCE to perform a “null” alter operation that rebuilds the ...