Search Results
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
Basic information about the join buffer cache: The size of each join buffer is determined by the value of the join_buffer_size system variable. This buffer is used only when the join is of type ALL or index (in other words, when no possible keys ...
https://dev.mysql.com/doc/internals/en/optimizer-features-to-trace.html
Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason. They are: Greedy search: with a N-table join, this could explore factorial(N) plans Range ...
https://dev.mysql.com/doc/internals/en/optimizer-tracing.html
The interface is provided by a set of optimizer_trace_xxx system variables and the INFORMATION_SCHEMA.OPTIMIZER_TRACE table, but is subject to change. In MySQL 5.6, a new tracing capability was added to the MySQL optimizer.
https://dev.mysql.com/doc/internals/en/traceable-queries.html
They are: SELECT; INSERT or REPLACE (with VALUES or SELECT); UPDATE/DELETE and their multi-table variants; all the previous ones prefixed by EXPLAIN; SET (unless it manipulates the optimizer_trace system variable); DO; DECLARE/CASE/IF/RETURN ...If ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-start.html
In addition, you must set java.library.path variable to point to the directory containing the Cluster ndbclient library, normally found in lib/mysql (also in the MySQL installation directory). The logging.properties file is located by default in the ... In this section, we discuss how to start ClusterJ applications and the ClusterJ application ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-roles-dynamic-privileges.html
For example, a user who must be able to modify global system variables can be granted SYSTEM_VARIABLES_ADMIN rather than SUPER. Privilege management is an important aspect of managing the security of a MySQL installation. Following the principle of ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. The ML_EMBED_TABLE routine runs multiple embedding generations in a batch, in ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. The ML_GENERATE_TABLE routine runs multiple text generation or summarization ...
https://dev.mysql.com/doc/relnotes/mysql-cluster-manager/8.4/en/news-8-1-0.html
(Bug #35457886) Client: Setting the mysqld system variable audit_log_format to the value JSON using the mcm client resulted in an error and the complaint that the value was illegal. Functionality Added or Changed Bugs Fixed Functionality Added or ...
https://dev.mysql.com/doc/relnotes/mysql-cluster-manager/8.4/en/news-8-3-0.html
(Bug #36092321) The mysqld system variable admin_ssl_cipher was taken by mcmd to be of the file name data type, which was wrong. Functionality Added or Changed Bugs Fixed Functionality Added or Changed MySQL Cluster Manager now uses the third-part ...