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/index-condition-pushdown-optimization.html
ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage engine. ICP is not supported with secondary indexes created on virtual generated columns. The second ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-failure-conditions.html
The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary online log exceeds the value of the innodb_online_alter_log_max_size configuration option. A timeout occurs while waiting for an exclusive ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. DATE_ADD() enables you to add a time interval to a given date. MySQL provides several functions that you can use to perform calculations on dates, for example, ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
--connect-timeout=value Command-Line Format --connect-timeout=value Type Numeric Default Value 43200 The maximum number of seconds before connection timeout. --shutdown-timeout=value Command-Line Format --shutdown-timeout=seconds Type Numeric ...You ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. NON_UNIQUE 0 if the index ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
The NDB$EPOCH() and NDB$EPOCH_TRANS() functions discussed later in this section work by comparing the relative order of replication epochs applied on a primary and secondary NDB Cluster, and do not make use of timestamps. Individual rows read on the ...Some types of conflict resolution supported by NDB Cluster (NDB$OLD(), NDB$MAX(), NDB$MAX_DELETE_WIN()) implement this user-defined column as a “timestamp” column (although its type cannot be TIMESTAMP, as explained later in this ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
Note Do not enable the WITH_TEST_TRACE_PLUGIN option if you want to use your own protocol trace plugins because only one such plugin can be loaded at a time and an error occurs for attempts to load a second one. Many options configure compile-time ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
Once this limit is exceeded, you must rename or remove the file before it is possible to execute any additional DDL statements. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table ...
https://dev.mysql.com/doc/refman/5.7/en/log-file-maintenance.html
When using MySQL with logging enabled, you may want to back up and remove old log files from time to time and tell MySQL to start logging to new files. If you are using replication, you should set the variable no lower than the maximum number of ...