Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
MySQL system tables still exist in MySQL 8.4 and can be viewed by issuing a SHOW TABLES statement on the mysql system database. Generally, the difference between MySQL data dictionary tables and system tables is that data dictionary tables contain ... Data dictionary tables are protected and may only be accessed in debug builds of ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-metrics.html
dbSystemId Detailed mysql.stats.aborted_connects Count The number of failed attempts to connect to the MySQL server. dbSystemId Detailed mysql.stats.created.tmp_disk_tables Count The number of internal on-disk temporary tables created by the server ... CloudWatch Monitoring Metrics 17.1.1 CloudWatch Monitoring Metrics CloudWatch metrics can be used to monitor resources, diagnose issues, and troubleshoot your DB systems and their MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-in-isolated-environment.html
For this reason, you should not run ML_TRAIN on a production MySQL HeatWave DB System that is also used for analytics queries. The recommended architecture is to run ML_TRAIN on a dedicated interim MySQL HeatWave DB System provisioned exclusively ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-ldap-kerberos.html
MySQL Enterprise Edition supports authentication methods that enable MySQL Server to use LDAP (Lightweight Directory Access Protocol), LDAP with Kerberos, or native Kerberos to authenticate MySQL users. Note The server-side LDAP and Kerberos ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
Choose one of the following methods of upgrading a Group Replication group: Rolling In-Group Upgrade This method is supported provided that servers running a newer version are not generating workload to the group while there are still servers with ...When the group is operating in single-primary mode, if you require the primary to remain the same throughout (except when it is being upgraded itself), it should be the last member to be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-multiple-nodes.html
The following are issues relating to the use of multiple MySQL servers as NDB Cluster SQL nodes, and are specific to the NDBCLUSTER storage engine: Stored programs not distributed. Stored procedures, stored functions, triggers, and scheduled events ...A LOCK TABLES statement or GET_LOCK() call works only for the SQL node on which the lock is issued; no other SQL node in the cluster “sees” this ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
To prepare the statement on the server, call mysql_stmt_prepare() and pass it a string containing the SQL statement. If there are large text or binary data values to be sent, you can send them in chunks to the server using ... To prepare and execute ...
https://dev.mysql.com/doc/refman/8.4/en/compatibility.html
Selecting SQL Modes The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. MySQL Server was originally designed to work with ...MySQL ... This section describes how MySQL relates to the ANSI/ISO SQL ...
https://dev.mysql.com/doc/refman/8.4/en/unix-signal-response.html
On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. This section describes how the MySQL server and client programs respond to signals. Server ...Some command interpreters associate certain key sequences with signals, such as Control+C to send a SIGINT ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
When the general query log is enabled, the server writes output to any destinations specified by the log_output system variable. To specify the log destination, use the log_output system variable (as described in Section 7.4.1, “Selecting General ...The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from ...