https://dev.mysql.com/data-dictionary-information-schema.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE information_schema_stats_expiry can be set to 0 to have ...
https://dev.mysql.com/data-dictionary-usage-differences.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. (To update the cached values at any time for a given table, use ANALYZE TABLE.) If there are no cached statistics or statistics ...
https://dev.mysql.com/data-locks-table.html
Use the data_locks table to help diagnose performance problems that occur during times of heavy concurrent load. Lock ID formats are internal and subject to change at any time. For information about which lock requests are blocked by which held ...
https://dev.mysql.com/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional ...
https://dev.mysql.com/docker-mysql-getting-started.html
For example: shell> docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES a24888f0d6f4 mysql/mysql-server "/entrypoint.sh my..." 14 seconds ago Up 13 seconds (health: starting) 3306/tcp, 33060/tcp mysql1 The container initialization might ... Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux ...
https://dev.mysql.com/dynamic-format.html
In this case, you may have to run OPTIMIZE TABLE or myisamchk -r from time to time to improve performance. Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table ...
https://dev.mysql.com/encryption-functions.html
The size penalty for storing the hex string in a CHAR column is at least two times, up to eight times if the value is stored in a column that uses the utf8 character set (where each character uses 4 bytes). If you want to store these results, use a ...
https://dev.mysql.com/entering-queries.html
These values are imprecise because they represent wall clock time (not CPU or machine time), and because they are affected by factors such as server load and network latency. (For brevity, the “rows in set” line is sometimes not shown in the ...
https://dev.mysql.com/environment-variables.html
This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual. Options on the command line take precedence over values specified in option files and ...
https://dev.mysql.com/error-log-components.html
Whether the component can be listed multiple times in the log_error_services value. If log_json_writer is named multiple times in the log_error_services value, they all write to the console, which is likely not useful. This section describes the ...
