PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
LAST_ALTERED The date and time when the routine was last modified. DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. The ROUTINES table provides information about stored routines (stored procedures and ...The ROUTINES table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-crash-recovery.html
This section describes how to check for and deal with data corruption in MySQL databases. If you run myisamchk to check tables that mysqld is updating at the same time, you may get a warning that a table is corrupt even when it is not. If the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...Do ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
If a variable with a VARIABLE_SOURCE value other than DYNAMIC is set at runtime, VARIABLE_SOURCE becomes DYNAMIC and VARIABLE_PATH becomes the empty string. The variables_info table shows, for each system variable, the source from which it was most ...COMPILED is the value used for variables not set any other ...
https://dev.mysql.com/doc/refman/8.0/en/using-log-files.html
You can also try the command EXPLAIN on all SELECT statements that takes a long time to ensure that mysqld is using indexes properly. You can find the queries that take a long time to execute by starting mysqld with the slow query log enabled. If ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-enum.html
ENUM and SET columns provide an efficient way to define columns that can contain only a given set of values. See Section 13.3.5, “The ENUM Type”, and Section 13.3.6, “The SET Type”. For a column defined as ENUM('a','b','c'), values such as ...Unless strict mode is disabled (not recommended, but see Section 7.1.11, “Server SQL Modes”), the definition of a ENUM or SET column acts as a constraint on values entered into the ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components.html
MySQL Enterprise Data Masking and De-Identification implements these elements: A table in the mysql system database for persistent storage of dictionaries and terms. A component named component_masking that implements masking functionality and ...
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. See Section 27.2.2, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 17.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...For example, if you archive the output of INNODB_CMP_RESET every 60 minutes, you see the statistics for each hourly ...