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/replication-options-reference.html
Com_show_slave_status: Count of SHOW REPLICA STATUS and SHOW SLAVE STATUS statements. show-slave-auth-info: Show user name and password in SHOW REPLICAS and SHOW SLAVE HOSTS on this source. Slave_last_heartbeat: Shows when latest heartbeat signal ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
For error codes, you should use the numbers provided by the error message in the replica's error log and in the output of SHOW SLAVE STATUS. The replication SQL thread continues to run, and the output from SHOW SLAVE STATUS displays Yes in both the ... This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
When I run the SHOW command in the NDB Cluster management client, I see a line of output that looks like this: A.10.8. You can determine whether your MySQL Server has NDB support using one of the statements SHOW VARIABLES LIKE 'have_%', SHOW ... In ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-server-side-help.html
This statement is used as part of the procedure described in [purge-binary-logs], that shows how to determine which logs can be purged. mysql> SHOW BINARY LOGS; +---------------+-----------+ | Log_name | File_size | +---------------+-----------+ | ... mysql> help search_string If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
The replication metadata repositories originally contained information similar to that shown in the output of the SHOW SLAVE STATUS statement, which is discussed in Section 13.4.2, “SQL Statements for Controlling Replica Servers”. Further ... A ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
Also, for SELECT statements, EXPLAIN generates extended information that can be displayed with SHOW WARNINGS following the EXPLAIN (see Section 8.8.3, “Extended EXPLAIN Output Format”). Column names are shown in the table's first column; the ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
To see information about the current data in the change buffer, issue the SHOW ENGINE INNODB STATUS command. error log A type of log showing information about MySQL startup and critical runtime errors and crash information. For example, the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
READ_ONLY and FULLY_REPLICATED, if set to 1, are shown in the Table options column. You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE TABLE: mysql> SHOW CREATE TABLE fish\G *************************** 1. The ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
These can be displayed at runtime using the SHOW VARIABLES statement. Some items displayed by the preceding mysqld command do not appear in SHOW VARIABLES output; this is because they are options only and not system variables. The following list ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
The following examples show two equivalent ways of preparing a statement that computes the hypotenuse of a triangle given the lengths of the two sides. For compliance with the SQL standard, which states that diagnostics statements are not ...Using ...