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-statements-replica.html
In addition to the statements described here, SHOW REPLICA STATUS and SHOW RELAYLOG EVENTS are also used with replicas. For information about these statements, see Section 15.7.7.35, “SHOW REPLICA STATUS Statement”, and Section 15.7.7.32, ...
https://dev.mysql.com/doc/refman/8.0/en/reset-slave.html
From MySQL 8.0.22, RESET SLAVE is deprecated and the alias RESET REPLICA should be used instead. The statement works in the same way as before, only the terminology used for the statement and its output has changed. Both versions of the statement ...
https://dev.mysql.com/doc/refman/8.0/en/reset.html
The following list describes the permitted RESET statement reset_option values: RESET MASTER Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. Also resets the relay log ...reset_option: { MASTER | REPLICA | SLAVE } The RESET statement is used to clear the state of various server ...
https://dev.mysql.com/doc/refman/8.0/en/resource-group-statements.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. This section describes the SQL ...
https://dev.mysql.com/doc/refman/8.0/en/searching-on-two-keys.html
An OR using a single key is well optimized, as is the handling of AND. Each SELECT searches only one key and can be optimized: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' UNION SELECT field1_index, field2_index FROM ...The one tricky case is that of searching on two different keys combined with OR: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' OR field2_index = '1' This case is ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/server-status-variable-reference.html
Please see the corresponding item descriptions for details on setting and using the variables. The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variable-reference.html
The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with an indication of where each option or variable is ... The following table lists all system variables applicable within ...
https://dev.mysql.com/doc/refman/8.0/en/show-open-tables.html
SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. The FROM clause, if present, restricts the tables shown to those present in the db_name ...
https://dev.mysql.com/doc/refman/8.0/en/show-privileges.html
The privileges displayed include all static privileges, and all currently registered dynamic privileges. row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables ... SHOW ...