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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
These locks are saved in a hash table in the server and implemented with pthread_mutex_lock() and pthread_mutex_unlock() for high speed. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-advantages.html
If you know exactly what you are looking for, you can search in just one of the underlying tables for some queries and use a MERGE table for others. This is much faster and saves a lot of disk space. MERGE tables can help you solve the following ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.