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/optimizer-hints.html
Query block names are identifiers and follow the usual rules about what names are valid and how to quote them (see Section 9.2, “Schema Object Names”). Query block names are identifiers and follow the usual rules about what names are valid and ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
In that case, the replica's connection metadata repository is written to the slave_master_info table in the mysql system schema, and the replica's applier metadata repository is written to the slave_relay_log_info table in the mysql system schema.
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-additionalslaves.html
Use the Performance Schema replication tables or issue SHOW SLAVE STATUS to confirm that the new replica has the correct settings when compared with the existing replica. You can add another replica to an existing replication configuration without ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
When using GTIDs you can take advantage of auto-positioning and automatic fail-over, as well as use WAIT_FOR_EXECUTED_GTID_SET(), session_track_gtids, and monitor replicated transactions using Performance Schema tables. This means that fields which ... To be able to safely configure the replication mode of an online server it is important to understand some key concepts of ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET ...If ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
In this case, the Last_SQL_Error field shows exactly what the Last_Error_Message column in the Performance Schema replication_applier_status_by_coordinator table shows. SHOW SLAVE STATUS [FOR CHANNEL channel] This statement provides status ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-check-lost-instrumentation.html
This view returns information about lost Performance Schema instruments, to indicate whether the Performance Schema is unable to monitor all runtime data. The ps_check_lost_instrumentation view has these columns: variable_name The Performance ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log.html
If the audit log plugin is enabled, the Performance Schema (see Chapter 25, MySQL Performance Schema) has instrumentation for it. To identify the relevant instruments, use this query: SELECT NAME FROM performance_schema.setup_instruments WHERE NAME ... Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
It is recorded in the source metadata repository and shown in the replication_connection_configuration Performance Schema table. These values are recorded in the source metadata repository and shown in the replication_connection_configuration ...] ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
For rules covering the naming of log file groups, see Section 9.2, “Schema Object Names”. You can verify that the UNDO files were created and obtain information about them by querying the Information Schema FILES table. CREATE LOGFILE GROUP ...