Search Results
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-26.html
It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. Deprecation and Removal Notes Functionality Added or Changed Bugs Fixed Deprecation and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
The ENABLED column indicates whether matching objects are monitored, and TIMED indicates whether to collect timing information. The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
If you get the error message Can't connect to MySQL server on some_host, you can try the following things to find out what the problem is: Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key ...You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the ... A MySQL client on Unix can connect to the mysqld server in two ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
If the timeout is 0, there is no waiting and the function produces an error if locks cannot be acquired immediately. One set of functions permits the server's list of version tokens to be manipulated and inspected. Another set of functions permits ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-sign-keys.html
--CA-days Command-Line Format --CA-days=# Introduced 8.4.1 Type Integer Default Value 1461 Minimum Value -1 Maximum Value 2147483647 Set the lifetime of the certificate to this many days. --connect-retries Command-Line Format --connect-retries=# ...
https://dev.mysql.com/doc/refman/8.4/en/automatic-start.html
systemd, the mysqld_safe and mysql.server scripts, Solaris SMF, and the macOS Startup Item (or MySQL Preference Pane) can be used to start the server manually, or automatically at system startup time. To be current, you should update your option ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption.html
MySQL binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of the operating ...You enable this encryption on a MySQL server by setting the binlog_encryption system variable to ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. Use of a column with RAND() values in an ORDER BY or GROUP BY clause may yield ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
Many system variables are dynamic and can be changed at runtime using the SET statement to affect operation of the current server instance. Modifying system variables with SET GLOBAL is a runtime capability that can be done from clients run locally ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
Suitable values are SOURCE_RETRY_COUNT=3 and SOURCE_CONNECT_RETRY=10, which make the replica retry the connection 3 times with 10-second intervals between. This feature ensures that the replica stays connected to the most suitable source server at ...Important When the existing connection to a source fails, the replica first retries the same connection the number of times specified by the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE ...