Search Results
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
If semijoin and materialization are both on, semijoins also use materialization where applicable. If semijoin and materialization are both on, semijoins also use materialization where applicable. Its value is a set of flags, each of which has a ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-tables.html
Note The path used with either or both of the DATA DIRECTORY and INDEX DIRECTORY options may not include the MySQL data directory. Note When you drop a table that is using symlinks, both the symlink and the file to which the symlink points are ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
For limiting which table columns are returned, filtering rows beyond what can be accomplished using ORDER BY and LIMIT, or both, use SELECT. TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
For instructions for both methods, see Populating the Time Zone Tables. The desired result is that both queries return the same result (the input time, converted to the equivalent value in the 'US/Central' time zone). This section describes the ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
If the session time zone is UTC, there is effectively no time zone conversion.) Due to conventions for local time zone changes such as Daylight Saving Time (DST), conversions between UTC and non-UTC time zones are not one-to-one in both directions.
https://dev.mysql.com/doc/refman/8.4/en/update.html
For partitioned tables, both the single-single and multiple-table forms of this statement support the use of a PARTITION clause as part of a table reference. This option takes a list of one or more partitions or subpartitions (or both). UPDATE is a ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
Run Both MySQL Versions in Parallel To minimize risk, it is best keep the current system running while running the upgraded system in parallel. MySQL supports upgrading between minor versions (within an LTS series) and to the next major version ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
In both cases, the actual version applicable to the existing MySQL installation is stored in the data dictionary, and the current expected version is compiled into the new version of MySQL. If both versions indicate an upgrade is needed, the data ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
There are no status variables to expose the administrative interface TLS context, but the Performance Schema tls_channel_status table exposes TLS properties for both the main and administrative interfaces. The server informs DBAs by providing valid ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...