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/performance-schema-setup-actors-table.html
This enables instrumenting and historical event logging to be applied selectively per host, user, or account (user and host combination). The setup_actors table contains information that determines whether to enable monitoring and historical event ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
Example statement event summary information: mysql> SELECT * FROM performance_schema.events_statements_summary_global_by_event_name\G *************************** 1. The Performance Schema maintains tables for collecting current and recent statement ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
This enables instrumenting and historical event logging to be applied selectively per host, user, or account (user and host combination), based on the ENABLED and HISTORY column values: When the best match is a row with ENABLED=YES, the INSTRUMENTED ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage-common-layer.html
Each set of the pluggable storage engine infrastructure components are designed to offer a selective set of benefits for a particular application. It stands to reason that understanding a particular application's set of requirements and selecting ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-binlog.html
mysqlbinlog has options for selecting sections of the binary log based on event times or position of events within the log. To apply events from the binary log, process mysqlbinlog output using the mysql client: $> mysqlbinlog binlog_files | mysql ... This section explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
(See Section 5.1.10, “Server SQL Modes”.) The following discussion mentions strict mode (selected by the STRICT_ALL_TABLES or STRICT_TRANS_TABLES mode values) and ERROR_FOR_DIVISION_BY_ZERO. With precision math, exact-value numbers are used as ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
SELECT statement is issued when row-based replication is in use (binlog_format=ROW). Before issuing RESET MASTER, ensure that you have backups of the server's binary log files and binary log index file, if any, and obtain and save the GTID set held ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
As part of the changes introduced by MySQL 5.7.6, the fields related to GTIDs have been modified so that they display the correct information regardless of the currently selected gtid_mode. To be able to safely configure the replication mode of an ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-monitoring.html
To monitor the connection status of all channels: mysql> SELECT * FROM replication_connection_status\G; *************************** 1. To monitor the connection status of a named channel, use a WHERE CHANNEL_NAME=channel clause: mysql> SELECT * FROM ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...