MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 161 to 170 of 178 total results

https://dev.mysql.com/doc/refman/8.0/en/server-options.html

When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program Options”. The most common methods are to provide options in an option file or on the command line.

7.1.10 Server Status Variables

https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html

The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | SESSION] STATUS statement (see Section 15.7.7.37, “SHOW STATUS Statement”).

15.7.7.38 SHOW TABLE STATUS Statement

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

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character ...

30.4.5.5 The format_statement() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-format-statement.html

Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...

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

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 information operating system file size limits, refer to the documentation ...

7.6.3.3 Thread Pool Operation

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

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

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. For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates ...

Displaying 161 to 170 of 178 total results