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/replication-solutions-backups.html
Using the raw data files option also means that you can back up the binary and relay logs that enable you to re-create the replica in the event of a replica failure. To use replication as a backup solution, replicate data from the source to a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
Use mysqldump to create a separate dump file for each database and load the appropriate dump file on each replica. There may be situations where you have a single source and want to replicate different databases to different replicas. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
A new empty binary log file is created so that binary logging can be restarted. RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where binary ...
https://dev.mysql.com/doc/refman/5.7/en/reset.html
The following list describes the permitted RESET statement reset_option values: RESET MASTER Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. reset_option: { MASTER | ...
https://dev.mysql.com/doc/refman/5.7/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. For example, these two statements ...
https://dev.mysql.com/doc/refman/5.7/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns. Partitioning is not supported for tables using the CSV storage engine.
https://dev.mysql.com/doc/refman/5.7/en/selinux-file-context.html
Installing the MySQL Server RPM creates a /var/lib/mysql-files/ directory but does not set the SELinux context for it. The MySQL Server reads from and writes to many files. If the SELinux context is not set correctly for these files, access to the ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. The optimizer uses semijoin strategies to improve subquery execution, ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
MySQL supports an plugin API that enables creation of server plugins. Group Replication enables you to create a highly available distributed MySQL service across a group of MySQL server instances, with data consistency, conflict detection and ...
https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | ...