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/table-scan-avoidance.html
Start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than 1,000 key seeks. This usually happens under the following conditions: The table is so small ...
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/manual-info.html
This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44. Typographical and Syntax Conventions This manual uses certain typographical conventions: Text in this style is used for SQL statements; database, ...