Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
For example, if you receive the error MySQL Error 1197 (HY000): Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage when importing a file, set this number to a value no greater than the server instance’s ...This ...
https://dev.mysql.com/doc/connector-j/en/connector-j-named-pipe.html
As a workaround, the MySQL Server that Connector/J wants to connect to must be started with the system variable named_pipe_full_access_group, which specifies a Windows local group containing the user by which the client application JVM (and thus ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html
Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or source-source replication deployments. In-process transactions are not lost, and no application exceptions are ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
MySQL incorporates the concept of user account categories, based on the SYSTEM_USER privilege. (However, to fully protect system accounts against regular accounts, you must also withhold modification privileges for the mysql system schema from ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE option. To examine the source for the ARCHIVE engine, look in the storage/archive directory of a MySQL source distribution. The ... The ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
Figure 2.1 Kleopatra: Lookup on Server Wizard: Finding a Certificate Select the "MySQL Release Engineering" certificate. Table 2.2 MySQL Package and Signature Files for MySQL Server MSI for Microsoft Windows File Type File Name Distribution file ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a generated invisible primary key (GIPK) to any such table. To make the generated invisible primary key on auto_1 visible, execute ... MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary ...
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
Note An easier alternative to generating the files required for SSL than the procedure described here is to let the server autogenerate them; see Section 8.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. To create the RSA ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...As of MySQL 8.4, enabling innodb_read_only prevents these operations for all storage ...The same ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary.html
MySQL Server incorporates a transactional data dictionary that stores information about database objects. In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data ...This ...