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-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/show-profile.html
For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 2 ORDER BY SEQ; . Note The SHOW PROFILE and SHOW PROFILES statements are ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 17.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html
To exclude results from any host except one in particular, use the --host option: $> ./ndb_config --host=198.51.100.176 -f : -r '\n' -q id,type 3:ndbd 5:ndb_mgmd In this example, we also used the short form -q to determine the attributes to be ...