MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 961 to 970 of 978 total results

https://dev.mysql.com/doc/refman/8.0/en/sys-sys-get-config.html

Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. If sys_get_config() returns the default value and that value is ...

30.4.5.20 The version_major() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-version-major.html

30.4.5.21 The version_minor() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-version-minor.html

30.4.5.22 The version_patch() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-version-patch.html

This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +--------------+---------------------+ | VERSION() | sys.version_patch() | +--------------+---------------------+ | ...

10.2.1.23 Avoiding Full Table Scans

https://dev.mysql.com/doc/refman/8.0/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 ...

B.3.3.5 Where MySQL Stores Temporary Files

https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html

On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary files. If TMPDIR is not set, MySQL uses the system default, which is usually /tmp, /var/tmp, or /usr/tmp. On Windows, ...

8.4.1.12 Test Pluggable Authentication

https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html

MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. This is a loadable plugin (not built in) and must be installed prior to use. The test plugin source code is separate from the server ...

10.14.2 Thread Command Values

https://dev.mysql.com/doc/refman/8.0/en/thread-commands.html

A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Connect Used by replication receiver threads connected to the source, and by replication ...

7.6.3.4 Thread Pool Tuning

https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html

This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per second. Of chief importance is the number of thread groups in the thread pool, which can be set ...

B.3.3.7 Time Zone Problems

https://dev.mysql.com/doc/refman/8.0/en/timezone-problems.html

If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This should be done for the environment in which the server runs (for example, in mysqld_safe or ...

Displaying 961 to 970 of 978 total results