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.html
If data_dir/auto.cnf is not found, generate a new UUID and save it to this file, creating the file if necessary. The following sections contain information about mysqld options and server variables that are used in replication and for controlling ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
In the event of source failure, all transactions committed on the source have been replicated to the replica (saved to its relay log). In addition to the built-in asynchronous replication, MySQL 5.7 supports an interface to semisynchronous ...
https://dev.mysql.com/doc/refman/5.7/en/replication-setup-replicas.html
If master_info_repository=TABLE instead, this information is saved in the master_slave_info table in the mysql database. Before you proceed, ensure that you have: Configured the source with the necessary configuration properties. Obtained the ...
https://dev.mysql.com/doc/refman/5.7/en/show-binlog-events.html
As an alternative to SHOW BINLOG EVENTS, use the mysqlbinlog utility to save the binary log to a text file for later examination and analysis. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
Using optimizer_trace_offset and optimizer_trace_limit, which are restrictions at the trace producer level, provide better (greater) speed and (less) memory usage than setting offsets or limits at the trace consumer (SQL) level with SELECT * FROM ...
https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html
The output can be saved in a file and reloaded later using mysql to recreate the dumped objects. This section describes how to use mysqldump to produce dump files, and how to reload dump files. A dump file can be used in several ways: As a backup ...
https://dev.mysql.com/doc/refman/5.7/en/windows-and-ssh.html
Save everything; otherwise you must to redo it the next time. This section describes how to get an encrypted connection to a remote MySQL server with SSH. This userid value might not be the same as the user name of your MySQL account. Either do a ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
The query cache probes are best combined with a probe on the main query so that you can determine the differences in times between using or not using the query cache for specified queries. A high number of keycache reads across a range of queries ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
select_type Value JSON Name Meaning SIMPLE None Simple SELECT (not using UNION or subqueries) PRIMARY None Outermost SELECT UNION None Second or later SELECT statement in a UNION DEPENDENT UNION dependent (true) Second or later SELECT statement in a ... The EXPLAIN statement provides information about how MySQL executes ...