PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/identifier-length.html
The sizes of the identifier string columns in the grant tables are measured in characters. The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
With innodb_stats_persistent_sample_pages set to the default value of 20, and with a default page size of 16 KiB (innodb_page_size=16384), you can then estimate that 20 * 12 * 16384 bytes are read for table t, or about 4 MiB. ANALYZE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-optimization.html
InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning.
https://dev.mysql.com/doc/refman/8.0/en/innodb-disk-management.html
Organizing tables into many small files, a few larger files, or a combination of both. Balancing the size of redo log files against the I/O activity that occurs when the log files become full. As a DBA, you must manage disk I/O to keep the I/O ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 17.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-failure-conditions.html
The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary online log exceeds the value of the innodb_online_alter_log_max_size configuration option. The failure of an online DDL operation is ...
https://dev.mysql.com/doc/refman/8.0/en/key-space.html
You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. This is for the worst case when all keys are inserted in sorted order and the table doesn't have any compressed keys. If the first index part is a ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-component-plugin-comparison.html
Note component_keyring_oci (like the keyring_oci plugin) can only generate keys of type AES with a size of 16, 24, or 32 bytes. The MySQL Keyring originally implemented keystore capabilities using server plugins, but began transitioning to use the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-key-types.html
Note component_keyring_oci (like the keyring_oci plugin) can only generate keys of type AES with a size of 16, 24, or 32 bytes. MySQL Keyring supports keys of different types (encryption algorithms) and lengths: The available key types depend on ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-using-management-client.html
Before starting a backup, make sure that the cluster is properly configured for performing one. If an existing backup_id value is used, the backup fails with the error Backup failed: file already exists. If used, the backup_id must follow ...