Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
The following prerequisites are checked when the CLONE INSTANCE statement is executed: The donor and recipient must be the same MySQL server series, such as 8.4.0 and 8.4.11. You can identify active plugins by issuing a SHOW PLUGINS statement or by ... The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ... For example: In a statement to be run only by a MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/concurrent-inserts.html
If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements. In addition, for those statements a read lock is placed on the selected-from table such that inserts into that table are ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
Once you know how to enter SQL statements, you are ready to access a database. Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp | ...Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-thread-pool.html
The default thread-handling model in MySQL Server executes statements using one thread per client connection. As more clients connect to the server and execute statements, overall performance degrades. The Thread Pool plugin increases server ...What ...
https://dev.mysql.com/doc/refman/8.4/en/firewall.html
MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against lists of accepted statement patterns. Each MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
The certification process does not take into account table locks (see Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”) or named locks (see GET_LOCK()). Concurrent data definition statements and data manipulation statements executing ... Limit on Group Size Limits on Transaction Size The following known limitations exist for Group ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-profiling-table.html
Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.32, “SHOW PROFILE Statement”). The PROFILING table has these columns: QUERY_ID A numeric statement identifier. DURATION How ...The table is empty unless the profiling session variable is set to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-starting.html
Statement-based binary logging is not supported for NDB Cluster Replication (see Section 25.7.2, “General Requirements for NDB Cluster Replication”). Note Unless you want replication to begin immediately, delay the start of the replication ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
At some point in the future—when the number of stores has increased to 25, 30, or more—you can use an ALTER TABLE statement to add new partitions for stores 21-25, 26-30, and so on (see Section 26.3, “Partition Management”, for details of ...