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/replication-solutions.html
For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 16.3.1, “Using Replication for Backups”. For performance or data distribution reasons, you may want ... Replication can be used in many different environments for a range of ...Using replication as a scale-out solution requires ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--database=name, -d name Command-Line Format --database=name Type String Default Value [none] Minimum Value Maximum Value The name of the database that contains the table being queried. --ndb-connectstring Command-Line Format ... ndb_index_stat ...
https://dev.mysql.com/doc/refman/5.7/en/history.html
The name of the MySQL Dolphin (our logo) is “Sakila,” which was chosen from a huge list of names suggested by users in our “Name the Dolphin” contest. We started out with the intention of using the mSQL database system to connect to our ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a ...If you run CHECKSUM TABLE against a view, the Checksum value is always NULL, and a warning is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-understanding-innodb-locking.html
When a transaction updates a row in a table, or locks it with SELECT FOR UPDATE, InnoDB establishes a list or queue of locks on that row. Similarly, InnoDB maintains a list of locks on a table for table-level locks. If a second transaction wants to ...At any given time, a transaction may request a lock that is held by another transaction, in which case it is blocked by that other ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-summary-tables.html
Except for events_statements_summary_by_digest, tt resets the summary columns to zero rather than removing rows. These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate ...When a connection terminates, the row in socket_summary_by_instance corresponding to it is ...
https://dev.mysql.com/doc/refman/5.7/en/show-status.html
SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described here. For details, see the ...A ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-latency.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. total_latency The total wait time of timed statements for the host. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-type.html
These views summarize informaion about statements executed, grouped by host and statement type. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host ...By default, rows are sorted by host and descending total ...
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. The ability to configure the ...This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ... To be ...