Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-full-table-scans.html
These views display normalized statements that have done full table scans. The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns: query The normalized statement string. By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-sorting.html
The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. total_latency The total wait time of timed occurrences of ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-temp-tables.html
These views list normalized statements that have used temporary tables. The statements_with_temp_tables and x$statements_with_temp_tables views have these columns: query The normalized statement string. By default, rows are sorted by descending ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary.html
The user_summary and x$user_summary views have these columns: user The client user name. unique_hosts The number of distinct hosts from which connections for the user have originated. These views summarize statement activity, file I/O, and ...
https://dev.mysql.com/doc/refman/8.4/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/refman/8.4/en/timezone-problems.html
If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This should be done for the environment in which the server runs (for example, in mysqld_safe or ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
The usual result is “0 rows affected,” which should be interpreted as “no information.” As long as the table definition is valid, the table can be re-created as an empty table with TRUNCATE TABLE, even if the data or index files have become ...Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/two-digit-years.html
To specify zero for YEAR and have it be interpreted as 2000, specify it as a string '0' or '00'. Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form because MySQL stores ...
https://dev.mysql.com/doc/refman/8.4/en/updating-yum-repo.html
The following instructions assume you have installed MySQL with the MySQL Yum repository or with an RPM package directly downloaded from MySQL Developer Zone's MySQL Download page; if that is not the case, following the instructions in Replacing a ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version using the old data files) with the MySQL Yum ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
LTS releases have 8+ years of support and are meant for production use. Enterprise Support If you're a MySQL Enterprise Edition customer, you can also contact the MySQL Support Team experts with any questions you may have. MySQL supports upgrading ...