Search Results
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/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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
Note MySQL 8.4 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows platforms. All of the files are located within this parent directory using the structure shown in the following table. Table 2.4 Default MySQL ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-osb.html
Each time an online backup is made to a tape using the SBT API , besides recording the backup in the mysql.backup_history and the mysql.backup_progress tables, an entry is also made to the mysql.backup_sbt_history table on the backed up MySQL ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-performance-space-overview.html
When connected to a running MySQL server, MySQL Enterprise Backup performs hot backup for InnoDB tables. This type of backups blocks any write operations to the tables during the backup process, but still allow tables to be read. When connected to a ... When it comes to formulating your backup strategy, performance and storage space are the key ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.html
During backup operations, mysqlbackup backs up: All InnoDB tables and indexes, including: The InnoDB system tablespace, which, by default contains all the InnoDB tables. Other files underneath the MySQL data directory, such as the .sdi files that ...