Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-features-connection-sharing.html
MySQL Router enables server connections to be pooled and shared. If a client disconnects, the server connection is moved to the connection pool, where it is available for reuse. If the client connection is idle for more than a specified time, the ...If a connection is shared, the reconnected session is in the state the client left ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...If ...The keyring functions are contained in a plugin library file, which also contains a keyring_udf plugin that must be enabled prior to function ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 ...To change the number of messages the server can store, change the value of ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html
Open an SQL Editor that is associated with your MySQL server instance and then query the northwind database. As for the destination MySQL server, you can have it in the same local machine or elsewhere in your network. Setting Up Target Parameters ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. If the AUTO_INCREMENT column is part of multiple indexes, MySQL generates sequence values using the index that begins ...For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-legacy-filtering.html
If you also set either of those variables to a value other than their default of ALL, the server writes a message to the error log to indicate that their values are being overridden. Legacy Event Filtering by Account Legacy Event Filtering by Status ... Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed without the accompanying audit tables and functions needed for rule-based ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html
mysql Information: 1 : 1: Connection Opened: connection string = 'server=localhost;User Id=root;database=world;port=3306 ;password=******;logging=True' mysql Information: 3 : 1: Query Opened: SHOW VARIABLES mysql Information: 4 : 1: Resultset ...The ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
MySQL Enterprise Audit enables standard, policy-based monitoring and logging of connection and query activity, providing an auditing and compliance solution for applications that are governed by both internal and external regulatory guidelines. To ...The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-binary.html
Set the necessary permissions for the MySQL server and data directories: $> chown -R root . (For the most recent 64-bit NDB 8.4 release, this is mysql-cluster-gpl-8.4.6-linux-glibc2.12-x86_64.tar.gz.) We assume that you have placed this file in each ... This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-4.html
MySQL NDB Cluster 8.4.4 is a new LTS release of NDB 8.4, based on MySQL Server 8.4 and including features in version 8.4 of the NDB storage engine, as well as fixing recently discovered bugs in previous NDB Cluster releases. The replica then uses ...NDB Cluster 8.4 source code and binaries can be obtained from ...Compilation Notes Bugs Fixed Compilation Notes macOS: A uint64_t ...