PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common resource. The work performed while holding a mutex is said to be in a “critical section,” and multiple queries ... The mutex_instances table lists all the mutexes seen by the Performance Schema while the server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-status-table.html
LAST_ERROR_TIMESTAMP A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the most recent I/O error took place. LAST_HEARTBEAT_TIMESTAMP A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the most recent ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
The following Performance Schema replication tables continue to be populated when the Performance Schema is disabled: replication_connection_configuration replication_connection_status replication_asynchronous_connection_failover ...This is similar ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
SET_TIME The time at which the variable was most recently set. The default is the time at which the server initialized global system variables during startup. If a variable with a VARIABLE_SOURCE value other than DYNAMIC is set at runtime, ... The ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
If authentication_ldap_sasl_max_pool_size=0 to disable pooling, each LDAP connection opened by the plugin uses the values the system variables have at that time. If authentication_ldap_simple_max_pool_size=0 to disable pooling, each LDAP connection ...If FIDO authentication is attempted and this value is not the one expected by the FIDO device, the device assumes that it is not talking to the correct server and an error ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html
To minimize the potential for incompatibilities, regularly upgrade the server, clients, and connectors on a timely basis. The only time the client loads the plugin specified by the server is for a change-plugin request, but in that case it can be ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
Consider the following stored procedure, which adds .0001 to a variable 1,000 times. This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.24.3, ...
https://dev.mysql.com/doc/refman/8.0/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. Both set the size of the server's key buffer to 512MB: [mysqld] key_buffer_size=512M [mysqld] key-buffer-size=512M Suffixes for specifying a value ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
To control the maximum number of steps performed by the engine (and thus indirectly the execution time), set the regexp_time_limit system variable. Because this limit is expressed as number of steps, it affects execution time only indirectly. ICU ...