PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-object-cache.html
character set definition cache partition: Stores character set definition objects and has a hardcoded object limit of 256. The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
For example: docker run --name mysql1 -d container-registry.oracle.com/mysql/community-server:tag --character-set-server=utf8mb4 --collation-server=utf8mb4_col The command starts the MySQL Server with utf8mb4 as the default character set and ...A ...
https://dev.mysql.com/doc/refman/8.0/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/8.0/en/error-log.html
For information about selecting the error message character set and language, see Section 12.6, “Error Message Character Set”, and Section 12.12, “Setting the Error Message Language”. This section discusses how to configure the MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-language.html
For information about changing the character set for error messages (rather than the language), see Section 12.6, “Error Message Character Set”. By default, mysqld produces error messages in English, but they can be displayed instead in any of ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
In the following queries, tbl_name can be used as a const table: SELECT * FROM tbl_name WHERE primary_key=1; SELECT * FROM tbl_name WHERE primary_key_part1=1 AND primary_key_part2=2; eq_ref One row is read from this table for each combination of ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). There is no need to enclose the ... {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name } format_name: { TRADITIONAL | JSON | TREE } explainable_stmt: { select_stmt | TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
The tables_priv and columns_priv tables contain scope columns indicating tables or table/column combinations to which each row applies. The following table shows the number of characters permitted in each column. Table 8.8 Grant Table Scope Column ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
Qualifiers have these characteristics: An unqualified name consists of a single identifier. The components of a multiple-part name must be separated by period (.) characters. The qualifier character is a separate token and need not be contiguous ...