Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID. It is not possible to restrict the effects of these two variables to a single table; these variables control the behavior of all ...
https://dev.mysql.com/doc/refman/8.4/en/reset-replica.html
The statement does not change the values of gtid_executed or gtid_purged, or the mysql.gtid_executed table. RESET REPLICA does not change any replication connection parameters, which include the source's host name and port, the replication user ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
The preceding query can also be written like this, using TABLE: SELECT (TABLE t2) FROM t1; A scalar subquery can be part of an expression, but remember the parentheses, even if the subquery is an operand that provides an argument for a function. For ... In its simplest form, a subquery is a scalar subquery that returns a single ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
Running mysqld as a Unix user other than root does not mean that you need to change the root user name in the user table. This includes the server's data directory containing the files that implement the privilege tables. INTO OUTFILE do not ...
https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. By ...It ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
This makes PERSIST_ONLY suitable for configuring read-only system variables that can be set only at server startup. The Performance Schema variables_info table contains information showing when and by which user each system variable was most ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
This account must have the EXECUTE privilege for p1 as well as the UPDATE privilege for the table t1 referenced within the object body. p2 fails if the invoker lacks the EXECUTE privilege for p2 or the UPDATE privilege for the table t1. The server ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-installation.html
The thread pool monitoring tables are Performance Schema tables that are loaded and unloaded along with the thread pool plugin. To do this, put these lines in the server my.cnf file, adjusting the .so suffix for your platform as necessary: [mysqld] ... This section describes how to install MySQL Enterprise Thread ...