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/mysql-cluster-logging-management-commands.html
The following table describes the default setting (for all data nodes) of the cluster log category threshold. For example, a STARTUP event with a priority of 3 is not logged unless the threshold for STARTUP is set to 3 or higher. Note Events are ...
https://dev.mysql.com/doc/refman/5.7/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. For example, DO id FROM t1 is invalid because it references a table. DO is useful primarily with ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-doublewrite-buffer.html
Because the doublewrite buffer setting is global, doublewrite buffering is also disabled for data files residing on non-Fusion-io hardware. The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before ...If ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering-names.html
To check which instrument or consumer names a pattern matches, perform a simple test: SELECT NAME FROM performance_schema.setup_instruments WHERE NAME LIKE 'pattern'; SELECT NAME FROM performance_schema.setup_consumers WHERE NAME LIKE 'pattern'; For ... Names given for filtering operations can be as specific or general as ...WHERE NAME LIKE 'wait/io/file/%'; The pattern '%/file/%' ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
For a server where binary logging is enabled (log_bin is ON), RESET MASTER deletes all existing binary log files and resets the binary log index file, resetting the server to its state before binary logging was started. For a server where GTIDs are ... RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html
Figure 16.3 Using an Additional Replication Source to Improve Performance For this to work, you must configure the MySQL instances as follows: Source 1 is the primary source where all changes and updates are written to the database. The above ...If ... As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client connection to the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log.html
The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they access. To select the file format, set the audit_log_format system variable at server startup. To ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-plugin-architecture.html
Figure 17.9 Group Replication Plugin Block Diagram The MySQL Group Replication plugin includes a set of APIs for capture, apply, and lifecycle, which control how the plugin interacts with MySQL Server. The applier component is responsible for ...It ... MySQL Group Replication is a MySQL plugin and it builds on the existing MySQL replication infrastructure, taking advantage of features such as the binary log, row-based logging, and global transaction ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html
The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient memory for the buffer pool without sacrificing transactional features or reliability. Hash indexes ...The adaptive hash index is enabled by the innodb_adaptive_hash_index variable, or turned off at server startup by ...
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...