PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: name The function name as referred to in SQL statements. Permitted values are 0 ...
https://dev.mysql.com/doc/refman/5.7/en/old-native-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. MySQL includes two plugins that implement native authentication; that is, authentication based on the password hashing methods in use from before the introduction of ...
https://dev.mysql.com/doc/refman/5.7/en/option-defaults-equals.html
You might try starting the server with --log-error my-errors, but this does not have the intended effect, as shown here: $> mysqld_safe --log-error my-errors & [1] 31357 $> 080111 22:53:31 mysqld_safe Logging to '/usr/local/mysql/var/tonfisk.err'.
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
In both of these cases, the partitioning key is the id column, even though it is not shown in the output of SHOW CREATE TABLE or in the PARTITION_EXPRESSION column of the Information Schema PARTITIONS table. Partitioning by key is similar to ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
You can cause this type of error to be ignored by using the IGNORE keyword, although a warning is issued for each row containing unmatched partitioning column values, as shown here. List partitioning in MySQL is similar to range partitioning in ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
This section provides a conceptual overview of partitioning in MySQL 5.7. For information on partitioning restrictions and feature limitations, see Section 22.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
For all supported statements, this option uses the syntax shown here: PARTITION (partition_names) partition_names: partition_name, ... MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively from high to low. The consumer settings in the setup_consumers table form a hierarchy from ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table size. Of the tables that contain stage event rows, events_stages_current is ...