PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-failover.html
GTIDs play a key role in applying changes to the database: the server automatically skips any transaction having an identifier which the server recognizes as one that it has processed before. See Section 16.1.3.4, “Setting Up Replication Using ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
Aborting a Buffer Pool Load Operation To abort a buffer pool load operation, issue the following statement: SET GLOBAL innodb_buffer_pool_load_abort=ON; Monitoring Buffer Pool Load Progress Using Performance Schema You can monitor buffer pool load ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/doc/refman/5.7/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. This is common for options that you want ...List the options in an option file that the program reads when it ...
https://dev.mysql.com/doc/refman/5.7/en/replication-formats.html
The logging format in a running MySQL server is controlled by setting the binlog_format server system variable. The rules governing when and how the new setting takes effect are the same as for other MySQL server system variables. Setting the ...The ... Replication works because events written to the binary log are read from the source and then processed on the ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data and related MySQL logs reflect the original times at which the transactions were executed. Your database has now been restored ... The last section, Section 7.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
When one user is too busy, this slows it down, which can be useful in some deployment situations. For statements that do not occur in transactional context (that is, when no transaction has been started with START TRANSACTION or SET autocommit = 0), ...With fully synchronous replication, when a source commits a transaction, all replicas must also have committed the transaction before the source returns to the session that performed the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
You may also find the MySQL User Forums to be helpful. Is there a discussion forum for INFORMATION_SCHEMA? See the MySQL User Forums. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Can I add to or otherwise modify ...Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA? ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
<in_optimizer>(query fragment) This is an internal optimizer object with no user significance. <ref_null_helper>(expr) This is an internal optimizer object with no user significance. For SELECT statements, the EXPLAIN statement produces extra ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. The name of the performance_schema database is ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-prefpane.html
You may be prompted for the username and password of a user with administrator privileges to start the MySQL server. You may be prompted for the username and password of a user with administrator privileges to stop the MySQL server. The preference ... The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup during boot of your MySQL ...