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/numeric-type-attributes.html
For example, applications can use the LPAD() function to zero-pad numbers up to the desired width, or they can store the formatted numbers in CHAR columns. MySQL supports an extension for optionally specifying the display width of integer data ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
For example, applications could use the LPAD() function to zero-pad numbers up to the desired width, or they could store the formatted numbers in CHAR columns. For integer data types, M indicates the minimum display width. Display width is ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-numeric.html
If you are using numeric data, it is faster in many cases to access information from a database (using a live connection) than to access a text file. Information in the database is likely to be stored in a more compact format than in the text file, ... For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-overview.html
Does each table use an appropriate row format? This choice also depends on the storage engine used for the table. Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
Histogram information is available using INFORMATION_SCHEMA.COLUMN_STATISTICS, which is implemented as a view on the data dictionary table. last-updated: When the histogram was generated, as a UTC value in YYYY-MM-DD hh:mm:ss.uuuuuu format. Values ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-attribute-tables.html
These Performance Schema tables expose attribute information: session_account_connect_attrs: Connection attributes for the current session, and other sessions associated with the session account session_connect_attrs: Connection attributes for all ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
For more information about the relationship between the three events_statements_xxx event tables, see Section 29.9, “Performance Schema Tables for Current and Historical Events”. For information about configuring whether to collect statement ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-firewall-groups-table.html
The value is NULL, or a non-NULL account that has the format user_name@host_name: If the value is NULL, the firewall records allowlist rules for statements received from any account that is a member of the group. The firewall_groups table provides ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups. For operational and configuration information about the host cache, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
For a comparison of this table with other sources, see Sources of Process Information. Otherwise (without the PROCESS privilege), nonanonymous users have access to information about their own threads but not threads for other users, and anonymous ...