Search Results
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 ...
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 ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-mysql-server.html
Bulk Ingest Data Type Support LOAD DATA with ALGORITHM=BULK supports tables with at least one column with the VECTOR data type. If you attempt to load a table without at least one column with the VECTOR data type, an error occurs. is-dryrun: Set to ... MySQL includes a bulk load extension to the LOAD DATA ...