Search Results
https://dev.mysql.com/doc/refman/8.4/en/scheduler-component.html
The component service calls each application-provided callback (function pointer) into the same scheduler thread, one at a time and in ascending order, based on the time each requires to run. Developers who wish to incorporate scheduler-queueing ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
Installing SHA-256 Pluggable Authentication The sha256_password (deprecated) plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading it. The ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-prerequisites.html
You can resolve these problems by installing into a directory that does not contain a space (for example C:\GnuWin32). If you run into problems and need to file a bug report, please use the instructions in Section 1.6, “How to Report Bugs or ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
To calculate the number of bytes used to store a particular CHAR, VARCHAR, or TEXT column value, you must take into account the character set used for that column and whether the value contains multibyte characters. InnoDB Table Storage ...
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 ...