PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
This principle applies to the INFORMATION_SCHEMA tables shown in the following table, which shows the columns for which a constant lookup value enables the server to avoid a directory scan. The following list indicates how the preceding optimization ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part of every unique key that the table may have. In other words, every unique key on the table must ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
SET column values that consist of multiple set members are specified with members separated by commas (,). For example, a column specified as SET('one', 'two') NOT NULL can have any of these values: '' 'one' 'two' 'one,two' A SET column can have a ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or TIMESTAMP, and fsp is the fractional seconds precision. (This differs from the standard SQL default of 6, for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
Tags are matched based on the tag or attribute name and the column name. User variables can be especially useful when you want to insert data from an XML file into table columns whose names do not match those of the XML fields. You can work around ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE COLUMNS, see Section 22.2.3.1, “RANGE COLUMNS partitioning”. Similar to partitioning ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
The number of indexed columns in a table The number of partitions. Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
The INSTRUMENTED and HISTORY column values for new threads are determined by the contents of the setup_actors table. For information about how to use the setup_actors table to control these columns, see Section 25.4.6, “Pre-Filtering by Thread”.
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
This is where the privilege columns in the grant tables come into play. These privileges can come from any of the user, db, tables_priv, columns_priv, or procs_priv tables. (You may find it helpful to refer to Section 6.2.3, “Grant Tables”, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
When converting utf8mb3 columns to utf8mb4, you need not worry about converting supplementary characters because there are none. In terms of table structure, these are the primary potential incompatibilities: For the variable-length character data ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...