Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
For examples of suggested use and how to check whether a connection is encrypted, see Section 8.3.1, “Configuring MySQL to Use Encrypted Connections”. If neither --ssl-crl nor --ssl-crlpath is given, no CRL checks are performed, even if the CA ... This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
In MySQL 8.4, STR_TO_DATE() performs complete range checking and raises an error if the date after conversion would be invalid. To convert a year-week to a date, you should also specify the weekday: mysql> SELECT STR_TO_DATE('200442 Monday', '%X%V ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
checking permissions The thread is checking whether the server has the required privileges to execute the statement. Killed Someone has sent a KILL statement to the thread and it should abort next time it checks the kill flag. The flag is checked in ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
Conformance is checked when a table that is part of a MERGE table is opened, not when the MERGE table is created. If any table fails the conformance checks, the operation that triggered the opening of the table fails. The conformance checks applied ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-close.html
Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed properly. If you get the following warning from CHECK TABLE or myisamchk, it means that this counter has gone out of sync: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
Setting gtid_next to AUTOMATIC:TAG or UUID:TAG:NUMBER requires a new TRANSACTION_GTID_TAG privilege which is added in this release; this is true both on the originating server as well as for the PRIVILEGE_CHECKS_APPLIER for the replica applier ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
Table maintenance of partitioned tables can be accomplished using the statements CHECK TABLE, OPTIMIZE TABLE, ANALYZE TABLE, and REPAIR TABLE, which are supported for partitioned tables. Example: ALTER TABLE t1 OPTIMIZE PARTITION p0, p1; Using ... A ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-verify-pid-files.html
To check the PID file for the management node process, log in to a system shell on host 198.51.100.102, change to the management node's data directory as specified by the Datadir parameter in the cluster's configuration file, then check to see ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter.html
master-key-reader=reader.sh master-key-writer=writer.sh --strict Command-Line Format --strict Type String Enables strict mode, which for example causes the bootstrap --account user verification check to stop the bootstrap process rather than only ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-repair.html
Section 9.7, “InnoDB ClusterSet Status and Topology” explains how to check the status of an InnoDB Cluster and of the whole InnoDB ClusterSet deployment, and the situations in which a cluster might need repair. A primary cluster that is ... Use ...