PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
This section describes the intended migration path away from the INFORMATION_SCHEMA system and status variable tables to the corresponding Performance Schema tables. Application developers should use this information as guidance regarding the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
The message lists the following statistics for the relevant replication channel, or the default replication channel (which is not named): Seconds elapsed The difference in seconds between the current time and the last time this information was ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
This occurs when the spinlock did not work (the mutex was not locked during the spinlock and it was necessary to yield to the operating system and wait). In MySQL 5.7 timing is disabled and this value is always 0. This statement is intended to help ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html
This can differ from the machine name as configured in the operating system. Statement output includes this column only if the source server is started with the --show-slave-auth-info option. Statement output includes this column only if the source ... SHOW SLAVE HOSTS Displays a list of replicas currently registered with the ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. This optimzation is performed by default whenever the optimizer determines that using it would allow for faster execution of the query. Because the algorithm that makes this ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
This might result in quicker lock release than the MERGE algorithm so that other clients that use the view are not blocked as long. In this case, MySQL generates a warning and sets the algorithm to UNDEFINED. The optional ALGORITHM clause for ...
https://dev.mysql.com/doc/refman/5.7/en/xa.html
This document is published by The Open Group and available at http://www.opengroup.org/public/pubs/catalog/c193.htm. In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
(In older versions of MySQL, manual intervention was required whenever relocating the binary log or relay log files.) (Bug #11745230, Bug #12133) Setting this option causes the log_bin system variable to be set to ON (or 1), and not to the base name. Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
This section describes how to initialize the data directory manually for MySQL installation methods for which data directory initialization is not automatic. For example, you might see an error like this: bin/mysqld: error while loading shared ...
https://dev.mysql.com/doc/refman/5.7/en/charset-we-sets.html
DIN-1 is called the “dictionary collation” and DIN-2 is called the “phone book collation.” For an example of the effect this has in comparisons or when doing searches, see Section 10.8.6, “Examples of the Effect of Collation”. This means ... Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and ...