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/replication-options-source.html
Both variables have global and session values, and each can assume an integer value between 1 and 65,535 inclusive. These changes are only made and reverted if auto_increment_increment and auto_increment_offset each have their default value of 1. If ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
For example, these lines in the server my.cnf file disable encrypted connections: [mysqld] admin_tls_version='' --allow-suspicious-udfs Command-Line Format --allow-suspicious-udfs[={OFF|ON}] Type Boolean Default Value OFF This option controls ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
SHOW ENGINE INNODB MUTEX also does not list any mutexes or rw-locks that have never been waited on (os_waits=0). Thus, SHOW ENGINE INNODB MUTEX only displays information about mutexes and rw-locks outside of the buffer pool that have caused at least ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
Only disable threads when building without any instrumentation, because other instrumentations have a dependency on threads. Clients that make no explicit arrangements therefore have LOCAL capability disabled or enabled according to the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
Alternatively, if you have a MySQL source distribution, you can test your setup using the demonstration certificate and key files in its mysql-test/std_data directory. (The files need not have been generated automatically; what matters is that they ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
Setting the default roles for yourself requires no special privileges, as long as the roles you want as the default have been granted to you. These constraints do not apply if you have the AUTHENTICATION_POLICY_ADMIN privilege. To modify an account ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html
It is a case-insensitive collation, so the uppercase and lowercase versions of a character have the same weights and they compare as equal. (For example, the single-byte characters 'a' and 'A' both have a weight of 0x41.) For multibyte characters, ... MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before converting. Handling Too-Long Or Too-Short Transactions Because MyISAM tables do not support ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
If MySQL finds a matching row in t2, it knows that t2.id can never be NULL, and does not scan through the rest of the rows in t2 that have the same id value. If execution plan output comprises multiple lines, any or all of them could have this Extra ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Of what issues should I be aware when working with Korean character sets in MySQL? In theory, while there have been several versions of the euckr (Extended Unix Code Korea) character set, only one problem has been noted. With multibyte character ...