Search Results
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/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/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-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 ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-backup-cluster.html
backup cluster takes a backup of the cluster's NDB tables only; tables using other MySQL storage engines (such as InnoDB or MyISAM) are ignored. On Unix-like platforms, the file should only be readable and writable by the file owner; on Windows ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-fewer-data-nodes.html
Before the NDB table data can be transferred, the metadata for the NDB tables must first be restored to the new cluster. The backup cluster command also creates a logical backup for the metadata of the NDB tables (see Logical Backup for NDB Table ...