Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
Before You Begin Ensure that the enable_secondary_engine_statistics system variables is set to ON. If the enable_secondary_engine_statistics system variable is set to ON, the secondary engine builds an ACE statistics model for a table when the ...
https://dev.mysql.com/doc/relnotes/mysql-cluster-manager/8.4/en/news-8-4-0.html
(Bug #34968330) Client: The value of the mysqld system variable secure_file_priv could not be set to an empty string. MySQL Cluster Manager 8.4.0 is recommended for use on production systems. To enable the function, use the --auto-rehash variable to ... MySQL Cluster Manager 8.4.0 marks the start of a new series of LTS (Long Term Support) ...
https://dev.mysql.com/doc/refman/9.7/en/channels-naming-conventions.html
The relay log files and index files for each channel are named relay_log_basename-channel.xxxxxx, where relay_log_basename is a base name specified using the relay_log system variable, and channel is the name of the channel logged to this file. If ... This section describes how naming conventions are impacted by replication ...
https://dev.mysql.com/doc/refman/9.7/en/charset-collation-coercibility.html
The collation of a column or a stored routine parameter or local variable has a coercibility of 2. A “system constant” (the string returned by functions such as USER() or VERSION()) has a coercibility of 3. In the great majority of statements, ...
https://dev.mysql.com/doc/refman/9.7/en/charset-introducer.html
If _charset_name is not specified but COLLATE collation_name is specified: For a character string literal, the connection default character set given by the character_set_connection system variable and collation collation_name are used. Otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/error-log-filtering.html
For error log filtering, MySQL offers a choice of components: log_filter_internal: This filter component provides error log filtering based on log event priority and error code, in combination with the log_error_verbosity and ... Error log ...
https://dev.mysql.com/doc/refman/9.7/en/index-merge-optimization.html
Influencing Index Merge Optimization Use of Index Merge is subject to the value of the index_merge, index_merge_intersection, index_merge_union, and index_merge_sort_union flags of the optimizer_switch system variable. In addition to using the ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-deadlock-detection.html
Resolve these situations by setting the value of the innodb_lock_wait_timeout system variable. Disabling Deadlock Detection On high concurrency systems, deadlock detection can cause a slowdown when numerous threads wait for the same lock. When ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-midpoint_insertion.html
Changing the value at runtime requires privileges sufficient to set global system variables. Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed ...
https://dev.mysql.com/doc/refman/9.7/en/resignal.html
The maximum number of condition areas in a diagnostics area is determined by the value of the max_error_count system variable. RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of ...