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/query-cache.html
The query cache can be useful in an environment where you have tables that do not change very often and for which the server receives many identical queries. When tables are modified, any relevant entries in the query cache are flushed. Note The ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. To update table index statistics for best estimates, use ANALYZE TABLE. If the specified limit is about ...The following sections describe conditions under which the optimizer uses range ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
(Row-based replication, however, simply replicates the value returned by the function or stored program, so its effect on table rows and data is the same on both the source and replica.) See Section 16.4.1.16, “Replication of Invoked Features”, ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
In MySQL 5.7 you can instead use an InnoDB table named mysql.slave_relay_log_info to store the applier metadata repository. As a table, updates to the applier metadata repository are committed together with the transactions, meaning that the ... In ...
https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html
The statement does not change the values of gtid_executed or gtid_purged, or the mysql.gtid_executed table. From MySQL 5.7.24, when master_info_repository=TABLE is set on the server, replication connection parameters are preserved in the crash-safe ... RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE makes the replica forget its replication position in the source's binary ...
https://dev.mysql.com/doc/refman/5.7/en/server-side-help-support.html
This information is stored in several tables in the mysql database (see Section 5.3, “The mysql System Database”). Proper operation of the HELP statement requires that these help tables be initialized. For a new installation of MySQL using a ...
https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. By ...It ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. This means that the same XA transaction can appear in the events_transactions_current ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
To encrypt data in an InnoDB file-per-table tablespace, run ALTER TABLE tbl_name ENCRYPTION = 'Y'. To encrypt a general tablespace or the mysql tablespace, run ALTER TABLESPACE tablespace_name ENCRYPTION = 'Y'. Does the transportable tablespaces ...