Search Results
https://dev.mysql.com/doc/refman/8.4/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 server and want to replicate different databases to different replicas. For ...
https://dev.mysql.com/doc/refman/8.4/en/reset.html
The following list describes the permitted RESET statement reset_option values: RESET BINARY LOGS AND GTIDS 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.
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/semijoins-antijoins.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/8.4/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/8.4/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 | ...
https://dev.mysql.com/doc/refman/8.4/en/show-tables.html
The optional EXTENDED modifier causes SHOW TABLES to list hidden tables created by failed ALTER TABLE statements. SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation-pkg.html
To enable MySQL to startup and shutdown automatically, you should create a link between this file and the init script directories. You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary ...