Search

Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb


Search Results
MySQL 8.0 Reference Manual
Displaying 961 to 970 of 978 total results
30.4.5.19 The sys_get_config() Function
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
Example mysql> SELECT VERSION(), sys.version_major(); +--------------+---------------------+ | VERSION() | sys.version_major() | +--------------+---------------------+ | 8.0.26-debug | 8 | +--------------+---------------------+ . This function ...
30.4.5.21 The version_minor() Function
https://dev.mysql.com/doc/refman/8.0/en/sys-version-minor.html
Example mysql> SELECT VERSION(), sys.version_minor(); +--------------+---------------------+ | VERSION() | sys.version_minor() | +--------------+---------------------+ | 8.0.26-debug | 0 | +--------------+---------------------+ . This function ...
30.4.5.22 The version_patch() Function
https://dev.mysql.com/doc/refman/8.0/en/sys-version-patch.html
Example mysql> SELECT VERSION(), sys.version_patch(); +--------------+---------------------+ | VERSION() | sys.version_patch() | +--------------+---------------------+ | 8.0.26-debug | 26 | +--------------+---------------------+ . This function ...
10.2.1.23 Avoiding Full Table Scans
https://dev.mysql.com/doc/refman/8.0/en/table-scan-avoidance.html
Use FORCE INDEX for the scanned table to tell MySQL that table scans are very expensive compared to using the given index: SELECT * FROM t1, t2 FORCE INDEX (index_for_column) WHERE t1.col_name=t2.col_name; See Section 10.9.4, “Index Hints”. The ...
B.3.3.5 Where MySQL Stores Temporary Files
https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html
Some SELECT queries creates temporary SQL tables to hold intermediate results. 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 ...
8.4.1.12 Test Pluggable Authentication
https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%test_plugin%'; +--------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +--------------------+---------------+ | ... MySQL ...
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
Assuming that the tp_thread_group_stats table is enabled, you can use the following query to determine the fraction of executed statements that stalled: SELECT SUM(STALLED_QUERIES_EXECUTED) / SUM(QUERIES_EXECUTED) FROM ... This section provides ...
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