Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
The following output from the INFORMATION_SCHEMA INNODB_TRX table and Performance Schema data_locks and data_lock_waits tables is taken from a somewhat loaded system. The following table shows the contents of the PROCESSLIST table for a system ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-object-shapes.html
Functions in this section detect arguments in either Cartesian or geographic spatial reference systems (SRSs), and return results appropriate to the SRS. If any geometry argument is a syntactically well-formed geometry in an undefined spatial ...
https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html
The enabled error log levels can be configured using an environment variable, by using a command-line parameter, or by specifying the log level as a preference option (see Other Preferences). The environment variable, command-line variant, and ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Valid simple_value_specification designators can be specified using stored procedure or function parameters, stored program local variables declared with DECLARE, user-defined variables, system variables, or literals. MySQL ignores the value of the ...For information about how the server chooses handlers when a condition occurs, see Section 15.6.7.6, “Scope Rules for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-spin_lock_polling.html
Modifying the variables at runtime requires privileges sufficient to set global system variables. On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it ... InnoDB mutexes and rw-locks are typically reserved for short ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-firewall.html
$> cd /usr/local/mysql $> bin/mysql -u root -p mysql < /usr/local/mysql/share/linux_install_firewall.sql Enter password: (enter root password here) To enable the firewall, enable the mysql_firewall_mode system variable. By default, this variable is ... MySQL Enterprise Firewall is an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
Normally, character values in result sets are converted to the character set indicated by the character_set_results system variable. If you use mysql_use_result(), the value of this variable is zero. In this case, charsetnr corresponds to the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-monitoring.html
For information about system variables affecting Group Replication, see Section 20.9.1, “Group Replication System Variables”. See Section 20.9.2, “Group Replication Status Variables”, for status variables providing information about Group ...
https://dev.mysql.com/doc/refman/8.4/en/option-modifiers.html
The --maximum prefix is available for mysqld only and permits a limit to be placed on how large client programs can set session system variables. The --maximum prefix is intended for use with system variables that have a session value. If applied to ...To do this, use a --maximum prefix with the variable ... Some options are ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-elements.html
The thread_handling system variable has a value of loaded-dynamically when the server successfully loads the thread pool plugin. The other related system variables are implemented by the thread pool plugin and are not available unless it is enabled.