Search Results
https://dev.mysql.com/doc/refman/8.4/en/temporary-table-problems.html
Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You ...
https://dev.mysql.com/doc/refman/8.4/en/thread-information.html
To ascertain what your MySQL server is doing, it can be helpful to examine the process list, which indicates the operations currently being performed by the set of threads executing within the server. row *************************** Id: 5 User: ...
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/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. plugin_name must be the name of ...
https://dev.mysql.com/doc/refman/8.4/en/union.html
query_expression_body UNION [ALL | DISTINCT] query_block [UNION [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” UNION combines the result from multiple ...
https://dev.mysql.com/doc/refman/8.4/en/update-optimization.html
An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data being updated and the number of indexes that are updated. Another way to get fast updates is to delay ...
https://dev.mysql.com/doc/refman/8.4/en/updating-apt-repo.html
On Debian and Ubuntu platforms, to perform an in-place upgrade of MySQL and its components, use the MySQL APT repository.
https://dev.mysql.com/doc/refman/8.4/en/updating-sles-repo.html
On the SUSE Linux Enterprise Server (SLES) platform, to perform an in-place upgrade of MySQL and its components, use the MySQL SLES repository.
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.4 to fail. To address this issue, dump and restore affected tables before attempting the upgrade again. If ...