Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-format-statement.html
This function is useful for formatting possibly lengthy statements retrieved from Performance Schema tables to a known fixed maximum length. Given a string (normally representing an SQL statement), reduces it to the length given by the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
Tables that use the fixed storage format have a larger maximum data length. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
The mysql.stats.com metrics are named for those variables, without the Com_ prefix. read_rnd Handler_read_rnd ASYNC COUNTER The number of requests to read a row based on a fixed position. The following server metrics are registered by default: ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
The thread pool separates connections and threads, so there is no fixed relationship between connections and the threads that execute statements received from those connections. The thread pool consists of a number of thread groups, each of which ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/two-digit-years.html
The fix in this case is to convert the YEAR to 4-digit year format. 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 years internally using 4 digits.
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
Review the Release Notes for information about fixes, changes, and new features. The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.4 to MySQL 8.3, ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
In this case, you should remove all redo log files, start your MySQL 8.3 server on the same data directory, and fix the cause of any errors. This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-paths.html
Monthly Rapid Updates (MRUs) and hot fixes also count as releases in this documentation. Notes Make sure you understand the MySQL release model for MySQL for MySQL long long-term support (LTS) and Innovation versions before proceeding with a ...