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/innodb-auto-increment-handling.html
InnoDB assigns new values for the AUTO_INCREMENT column one at a time as each row is processed. As of MySQL 8.0, interleaved lock mode (innodb_autoinc_lock_mode=2) is the default setting. Prior to MySQL 8.0, consecutive lock mode is the default ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code modifications. Do not alter the MySQL sources unless you know what you are doing. Most full-text variables ...Modifying the default behavior in most cases can actually decrease ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking.html
If you are using MySQL Enterprise Data Masking and De-Identification for the first time, consider installing the components for access to the ongoing enhancements only available with component infrastructure. Note MySQL Enterprise Data Masking and ...Generation of random data, such as email addresses and payment card ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging instructions in Section 2.1, “General Installation Guidance”, and Section 7.9, “Debugging MySQL”. Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on case-insensitive ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
MySQL 8.0.31 and later also supports setting the histogram of a single column to a user-defined JSON value. This issue is resolved in MySQL 8.0.24 (and later), where ANALYZE TABLE no longer causes subsequent operations to wait. MySQL uses the stored ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
Storage engines are MySQL components that handle the SQL operations for different table types. (The CREATE TABLE statement in MySQL 8.0 creates InnoDB tables by default.) MySQL Server uses a pluggable storage engine architecture that enables ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You can then transfer the file to the other machine and feed it as input to the mysql client. Note If ...
https://dev.mysql.com/doc/refman/8.0/en/debugging-client.html
To be able to debug a MySQL client with the integrated debug package, you should configure MySQL with -DWITH_DEBUG=1. Before running a client, you should set the MYSQL_DEBUG environment variable: $> MYSQL_DEBUG=d:t:O,/tmp/client.trace $> export ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
In releases before MySQL 8.0.30, MySQL Enterprise Encryption's functions are based on the openssl_udf shared library. For information on upgrading to the new component functions provided by the MySQL component component_enterprise_encryption, and a ...The functions continue to be available in later releases if they have been installed, but they are ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation.html
For a list of macOS versions that the MySQL server supports, see https://www.mysql.com/support/supportedplatforms/database.html. MySQL for macOS is available in a number of different forms: Native Package Installer, which uses the native macOS ...