Search Results
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
MySQL can also apply subquery materialization to a single-table UPDATE or DELETE statement that uses a [NOT] IN or [NOT] EXISTS subquery predicate, provided that the statement does not use ORDER BY or LIMIT, and that subquery materialization is ...
https://dev.mysql.com/doc/refman/8.4/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. By convention, routines that call sys_get_config() first check ...If ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
The thread pool consists of a number of thread groups, each of which manages a set of client connections. As connections are established, the thread pool assigns them to thread groups in round-robin fashion. The thread pool exposes system variables ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
It is important to understand the impact of each of these to existing applications. Connect to the existing MySQL server and select the MySQL Server version you plan to upgrade to for the utility to report issues to address prior to an upgrade.
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
To use a localized systemd configuration file, create the /etc/systemd/system/mysqld.service.d directory if it does not exist. Specify the values in the /etc/sysconfig/mysql file (create the file if it does not exist). To suppress this automatic ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
version_tokens_delete() deletes the tokens named in its argument, if they exist. (It is not an error to delete nonexisting tokens.) To clear the token list entirely without knowing which tokens are in the list, pass NULL or a string containing no ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
Many theoretically updatable views can be updated now, but limitations still exist. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a ...
https://dev.mysql.com/doc/refman/8.4/en/windows-postinstallation.html
GUI tools exist that perform most of the tasks described in this section, including: MySQL Configurator: Used to configure the MySQL server. Use mysqlshow to see what databases exist: C:\> bin\mysqlshow +--------------------+ | Databases | ...If ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
However, before creating the symbolic link, make sure that the D:\data\mydb directory exists by creating it if necessary. If the database does not already exist, issue CREATE DATABASE mydb in the mysql client to create it. On Windows, symbolic ...
https://dev.mysql.com/doc/refman/8.4/en/windows-upgrading.html
The approach you select depends on how the existing installation was performed. You may either overwrite your existing MySQL installation (usually located at C:\mysql), or install it into a different directory, such as C:\mysql8. To upgrade MySQL ...