Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjs-metadata.html
Additional information relating to the MLE component which provides JavaScript stored program functionality can be obtained by checking the values of server system and status variables which this component makes available. You can obtain metadata ...
https://dev.mysql.com/doc/refman/9.7/en/string-literals.html
Escape processing is done according to the character set indicated by the character_set_connection system variable. When writing application programs, any string that might contain any of these special characters must be properly escaped before the ... A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") ...
https://dev.mysql.com/doc/refman/9.7/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a ...
https://dev.mysql.com/doc/refman/9.7/en/tracing-memory-usage.html
The optimizer_trace_max_mem_size server system variable sets a limit on the total amount of memory used by all traces currently being stored. Each stored trace is a string, which is extended (using realloc()) as optimization progresses by appending ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/configuring-election-process.html
Setting the value of memberWeight configures the group_replication_member_weight system variable on the instance. When a primary election takes place, if multiple instances have the same memberWeight value, the instances are then prioritized based ... You can optionally configure how a single-primary cluster elects a new primary, for example to prefer one instance as the new primary to fail over ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/replicaset-status.html
ReplicaSet.status({extended:1}): Setting extended to 1 includes Metadata Version, server UUID, replication information such as lag and worker threads, the raw information used to derive the status of the instance, size of the applier queue, value of ...The ReplicaSet.status() operation supports the extended option to get different levels of ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-commit.html
The action of this function is subject to the value of the completion_type system variable. In particular, if the value of completion_type is RELEASE (or 2), the server performs a release after terminating a transaction and closes the client ...Call ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-rollback.html
The action of this function is subject to the value of the completion_type system variable. In particular, if the value of completion_type is RELEASE (or 2), the server performs a release after terminating a transaction and closes the client ...Call ...
https://dev.mysql.com/doc/relnotes/mysql-router/9.7/en/news-9-0-0.html
Bugs Fixed System variable changes were not propagated when read-write splitting was enabled. It was removed due to a dependency on a version of the server which is also no longer available for download. (Bug #36674083) Current schema changes were ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.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. Generate Content To generate text-based content using MySQL HeatWave GenAI, ...