Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-joins.html
The plan evaluation limit prevents too much time being spent evaluating plans in cases where MySQL generates numerous plans that use the DUPSWEEDOUT semijoin strategy. NOT EXISTS (...) IS NOT TRUE Depending on transformations and optimizations ...
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER ...The ...
https://dev.mysql.com/doc/refman/8.4/en/audit-api-message-emit.html
For concreteness, examples use the audit_log plugin described in Section 8.4.5, “MySQL Enterprise Audit”. Installing or Uninstalling the Audit Message Component Audit Message Function Installing or Uninstalling the Audit Message Component To be ... The audit_api_message_emit component enables applications to add their own message events to the audit log, using the audit_api_message_emit_udf() ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8.html
utf8mb3 remains supported for the lifetimes of the MySQL 8.0.x and MySQL 8.4.x LTS release series. utf8 has been used by MySQL in the past as an alias for the utf8mb3 character set, but this usage is now deprecated; in MySQL 8.4, SHOW statements ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade.html
While you are in the process of upgrading an online group, in order to maximize availability, you might need to have members with different MySQL Server versions running at the same time. The basic process of upgrading members of a group is the same ... This section explains how to upgrade a Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
When a given index value yields a large number of rows, the index is less useful and MySQL is less likely to use it. This affects ref accesses for comparisons of the form tbl_name.key = expr: MySQL does not access the table if the current value of ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-optimizer-statistics.html
You can query optimizer statistics data in the mysql.innodb_table_stats and mysql.innodb_index_stats tables. You can view the last_update column of the mysql.innodb_table_stats and mysql.innodb_index_stats tables to see when statistics were last ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-server-clients.html
On Unix, set the MYSQL_UNIX_PORT and MYSQL_TCP_PORT environment variables to point to the Unix socket file and TCP/IP port number before you start your clients. If you normally use a specific socket file or port number, you can place commands to set ...Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared ...
https://dev.mysql.com/doc/refman/8.4/en/nested-join-optimization.html
As a result, the execution time for the query may improve immensely. The following discussion refers to the join syntax described in Section 15.2.13.2, “JOIN Clause”. The syntax of table_factor is extended in comparison with the SQL Standard.
https://dev.mysql.com/doc/refman/8.4/en/programs-development.html
This section describes some utilities that you may find useful when developing MySQL programs. This works well for programs that use the last instance of an option that is specified multiple times. Check the source code of any of the standard MySQL ...In shell scripts, you can use the my_print_defaults program to parse option files and see what options would be used by a given ...