PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/server-administration.html
MySQL Server (mysqld) is the main program that does most of the work in a MySQL installation.
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-errors-or-warnings.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-runtimes-in-95th-percentile.html
db The default database for the statement, or NULL if there is none. full_scan The total number of full table scans performed by occurrences of the statement. These views list statements with runtimes in the 95th percentile. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-sorting.html
db The default database for the statement, or NULL if there is none. The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. total_latency The total wait time of timed occurrences of ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-temp-tables.html
db The default database for the statement, or NULL if there is none. These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of ...
https://dev.mysql.com/doc/refman/5.7/en/alter-instance.html
The statement supports these actions: ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master encryption key used for InnoDB tablespace encryption. To perform this action, a keyring plugin must be installed and configured. If one of ... ALTER INSTANCE ROTATE INNODB MASTER KEY ALTER INSTANCE, introduced in MySQL 5.7.11, defines actions applicable to a MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/channels-commands-single-channel.html
To enable MySQL replication operations to act on individual replication channels, use the FOR CHANNEL channel clause with the following replication statements: CHANGE MASTER TO START SLAVE STOP SLAVE SHOW RELAYLOG EVENTS FLUSH RELAY LOGS SHOW SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/choosing-types.html
For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. For high precision, you can always convert to a ...Of the types that represent all the required values, this type uses the least amount of ...
https://dev.mysql.com/doc/refman/5.7/en/geometry-well-formedness-validity.html
For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-failure-detection.html
Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of service. If a member is not ...If the ...