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-delayed.html
Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds: CHANGE MASTER TO MASTER_DELAY = N; An event received from the source is not executed until at least N seconds later than its execution on the source. MySQL 5.7 supports ...The exceptions are that there is no delay for format description events or log file rotation events, which affect only the internal state of the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/replica-sql-thread-states.html
Waiting until MASTER_DELAY seconds after master executed event The SQL thread has read an event but is waiting for the replica delay to lapse. Making temporary file (create) before replaying LOAD DATA INFILE The thread is executing a LOAD DATA ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
An implication of password rewriting is that statements that cannot be parsed (due, for example, to syntax errors) are not written to the general query log because they cannot be known to be password free. Use cases that require logging of all ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
If you have UNIQUE constraints on secondary keys, you can speed up table imports by temporarily turning off the uniqueness checks during the import session: SET unique_checks=0; ... SET unique_checks=1; For big tables, this saves a lot of disk I/O ... These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-performance-timers-table.html
The rows that do not contain NULL indicate which timers you can use in setup_timers. Note As of MySQL 5.7.21, the Performance Schema setup_timers table is deprecated and is removed in MySQL 8.0, as is the TICKS row in the performance_timers table.
https://dev.mysql.com/doc/refman/5.7/en/replication-formats.html
Replication of the source to the replica works by executing the SQL statements on the replica. When using MIXED format, the binary logging format is determined in part by the storage engine being used and the statement being executed. There are ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
The procedure also attempts to execute EXPLAIN for the longest running example of the digest during the interval. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable.
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
The validate_password plugin implements these capabilities: For SQL statements that assign a password supplied as a cleartext value, validate_password checks the password against the current password policy and rejects the password if it is weak ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-crash-recovery.html
If you can be certain that no one can access the tables through mysqld while you run myisamchk, you have only to execute mysqladmin flush-tables before you start checking the tables. If you run myisamchk to check tables that mysqld is updating at ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
The INNODB_SYS_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based, equivalent to information in the SYS_VIRTUAL table in the InnoDB data dictionary. A row appears in the ...