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/events-metadata.html
To obtain metadata about events: Query the event table of the mysql database. Event Scheduler Time Representation Each session in MySQL has a session time zone (STZ). This is the session time_zone value that is initialized from the server's global ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. How the Clustered Index Speeds Up Queries Accessing ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
A large data file can also result from long running queries that use temporary tables. The default 16KB page size is appropriate for a wide range of workloads, particularly for queries involving table scans and DML operations involving bulk updates.
https://dev.mysql.com/doc/refman/5.7/en/key-cache-restructuring.html
If the cache contains any dirty blocks, the server saves them to disk before destroying and re-creating the cache. However, restructuring does not block queries that need to use indexes assigned to the cache. File system caching is not as efficient ... A key cache can be restructured at any time by updating its parameter ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
The resulting fast database operations are then available to be reused by other queries, applications, and even code written in different programming languages. In this case, you must provide code in your application to pack and unpack information, ... This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
By contrast, using the Performance Schema tables, information about replica status can be searched using general SELECT queries, including complex WHERE conditions, joins, and so forth. Query results can be saved in tables for further analysis, or ...This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
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 point-in-time-recovery. As an example, suppose that around 13:00:00 on May 27, 2020, an SQL statement was ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based ...
https://dev.mysql.com/doc/refman/5.7/en/reproducible-test-case.html
The binary log is saved in the MySQL database directory with the name hostname-bin.NNNNNN. For information about steps to take when encountering InnoDB table corruption, see Section 1.5, “How to Report Bugs or Problems”. If you encounter ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
ONLY_FULL_GROUP_BY Reject queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on (uniquely determined by) GROUP BY columns.