MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 131 to 140 of 146 total results

https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html

SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY table. You can also get this list using the mysqlshow --status db_name ...

13.3.1 String Data Type Syntax

https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html

[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] A fixed-length string that is always right-padded with spaces to the specified length when stored. MySQL stores VARCHAR values as a 1-byte or 2-byte length prefix plus data.

30.4.5.5 The format_statement() Function

https://dev.mysql.com/doc/refman/8.0/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 ...

30.4.1 sys Schema Object Index

https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-index.html

The following tables list sys schema objects and provide a short description of each one.

10.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/8.0/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 ...

7.6.3.3 Thread Pool Operation

https://dev.mysql.com/doc/refman/8.0/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 ...

10.15.12 Example

https://dev.mysql.com/doc/refman/8.0/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 ...

13.2.9 2-Digit Years in Dates

https://dev.mysql.com/doc/refman/8.0/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.

3.1 Before You Begin

https://dev.mysql.com/doc/refman/8.0/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.0 to MySQL 5.7, ...

3.7 Upgrading MySQL Binary or Package-based Installations on Unix/Linux

https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html

In this case, you should remove all redo log files, start your MySQL 5.7 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 ...

Displaying 131 to 140 of 146 total results