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/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/backup-methods.html
This method works for any kind of data file, but saves only table data, not the table structure. Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
Also, using column prefixes for indexes can make the index file much smaller, which could save a lot of disk space and might also speed up INSERT operations. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
To use MySQL 5.7 as a document store, the X Plugin needs to be installed. Then you can use X Protocol to communicate with the server. Without the X Plugin running, X Protocol clients cannot connect to the server. The X Plugin is supplied with MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
Changes to the innodb_memcache.containers table take effect the next time the innodb_memcache.containers table is queried. Debug messages occur because new and updated values are sent directly to the InnoDB table without being saved in the memory ...