Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. SQL_Remaining_Delay: When Replica_SQL_Running_State is Waiting until SOURCE_DELAY seconds ...In MySQL 8.4, the method of delaying replication depends on two timestamps, immediate_commit_timestamp and original_commit_timestamp (see Replication Delay Timestamps); delayed replication is measured using these ...
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/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/relnotes/connector-net/en/news-8-0-11.html
If the server does not support document ID generation, the document-add operation returns an error indicating that document IDs were missing. (Bug #26954812, Bug #88058) The data table returned by the MySqlDataReader.GetSchemaTable method had an ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-dns-srv.html
X DevAPI supports the use of DNS SRV records for connecting to MySQL servers. A client that receives a DNS SRV lookup result attempts to connect to the MySQL server on each of the listed hosts in order of preference, based on the priority and ...A ...This section focuses on use of DNS SRV within X DevAPI ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-ping.html
A nonzero return does not indicate whether the MySQL server itself is down; the connection might be broken for other reasons such as network problems. int mysql_ping(MYSQL *mysql) Description Checks whether the connection to the server is working.
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/mysql-em-plugin/en/myoem-metric-threads-activity-category.html
Too Many Concurrent Queries Running Too many active queries indicates there is a severe load on the server, and may be a sign of lock contention or unoptimized SQL queries. Connection Limit Usage (Rate) Once the maximum connection limit for the ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.0 (2018-04-19)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-0.html
Important MySQL Enterprise Service Manager 8.0's bundled repository is MySQL Server 5.7.22. Important Due to password plugin changes in the server, only MEM 8.0 and later support monitoring MySQL 8.0.11, or higher. For more information on the ...