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/partitioning-types.html
However, it is not difficult in MySQL to create partitioning schemes based on DATE, TIME, or DATETIME columns, or based on expressions making use of such columns. When partitioning by KEY or LINEAR KEY, you can use a DATE, TIME, or DATETIME column ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. (OpenSSL imposes its own key-length limits, and server administrators can ...If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-restart-info.html
Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. Only the most recent report for any given node is shown. The restart_info table contains the following columns: node_id Node ID ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the ...A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated ...If the index is a covering index (one that includes all the ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
The MySQL Server's error log is then redirected to stderr, so that the error log goes into the Docker container's log and is viewable using the docker logs mysqld-container command. To make MySQL Server generate an error log when either of the two ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Included binaries are limited to: /usr/bin/my_print_defaults /usr/bin/mysql /usr/bin/mysql_config /usr/bin/mysql_install_db /usr/bin/mysql_tzinfo_to_sql /usr/bin/mysql_upgrade /usr/bin/mysqladmin /usr/bin/mysqlcheck /usr/bin/mysqldump /usr/bin/mysqlpump /usr/sbin/mysqld All binaries are stripped; they contain no debug ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
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 maximum of 64 distinct members. Duplicate values in the definition cause a warning, or an error if strict ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Preventing one-time operations such as table scans from interfering ...Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
Note When using internal_tmp_disk_storage_engine=INNODB, queries that generate on-disk internal temporary tables that exceed InnoDB row or column limits return Row size too large or Too many columns errors. Presence of any string column with a ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
Some statements require a lot of execution time on the source, but result in just a few rows being modified. It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors because InnoDB can no longer ...The logging format also can be switched at runtime, although note that there are a number of situations in which you cannot do this, as discussed later in this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
Important You must ensure that the replica mysqld is started with --slave-skip-errors=ddl_exist_errors before executing START SLAVE. In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary ...