Search Results
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
The first time MySQL needs the subquery result, it materializes that result into a temporary table. The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
Generally, partitioning of tables into multiple tablespace files is recommended for tables larger than 1TB in size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
The default algorithm takes stalled threads into account and may temporarily permit more active threads. Queue assignment can be affected by enabling the thread_pool_high_priority_connection system variable, which causes all queued statements for a ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
For example: mysqld_safe --user=mysql --datadir=/path/to/8.4-datadir & Reset the root password: $> mysql -u root -p Enter password: **** <- enter temporary root password mysql> ALTER USER USER() IDENTIFIED BY 'your new password'; Load the previously ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
mysql schema tables fall into two broad categories: Data dictionary tables, which store database object metadata. In both cases, the actual version applicable to the existing MySQL installation is stored in the data dictionary, and the current ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
If --ssl_cert is given, then the server validates the server certificate, taking into consideration --ssl_crl, if specified. If --admin_ssl_cert is given, then the server validates the server certificate, taking into consideration --admin_ssl_crl, ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
An administrative or management application that communicates with the servers and organizes them into high-availability groups. (Version Tokens uses the locking service routines built into the server, not the locking service function interface, so ... Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
For TEMPTABLE, the results from the view are retrieved into a temporary table, which then is used to execute the statement. As mentioned earlier, MERGE is handled by merging corresponding parts of a view definition into the statement that refers to ... The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-crashing.html
This can normally be checked by pressing the Caps Lock key. If the Caps Lock light does not change, you have to replace your keyboard. (Before doing this, you should try to restart your computer and check all cables to the keyboard.) The mouse ...
https://dev.mysql.com/doc/refman/8.4/en/windows-choosing-package.html
The noinstall ZIP archives are split into two separate compressed files. If this occurs, you can move the contents of the subfolder into the chosen installation location. For MySQL 8.4, there are multiple installation package formats to choose from ...