Search Results
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 ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-mcmd.html
Invoking this executable starts the MySQL Cluster Manager Agent, to which you can connect using the mcm client (see Section 4.3, “Starting the MySQL Cluster Manager Client” and Chapter 5, MySQL Cluster Manager Client Commands for more ...You can ...
https://dev.mysql.com/doc/internals/en/transformation-scalar-in.html
To rewrite a scalar IN subquery, the Item_in_subselect::single_value_transformer method is used. The scalar IN subquery will be replaced with an Item_in_optimizer item. On a value request (one of val, val_int, or val_str methods) it evaluates the ...
https://dev.mysql.com/doc/refman/8.4/en/gis-wkb-functions.html
These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier (SRID). For a description of WKB format, see Well-Known Binary (WKB) Format. Functions in this ...