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/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-error-messages.html
The error_messages table provides information about The error_messages table contains the following columns: error_code Numeric error code error_description Description of error error_status Error status code error_classification Error ...
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/get-diagnostics.html
(You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The keyword STACKED means to retrieve information from the second diagnostics area, which is available only ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
This can be done by setting an appropriate value in the config.ini file for the MaxNoOfExecutionThreads configuration parameter or the ThreadConfig configuration parameter. Trace files are generated by critical errors in ndbmtd processes in a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
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 table * the number of partitions Typically, the greater the resulting ... ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that violates this limitation fails with NDB error 851 Maximum offset for fixed-size columns exceeded. When using the NDB storage ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
This removal operation is called a purge, and it is quite fast, usually taking the same order of time as the SQL statement that did the deletion. Multi-Versioning and Secondary Indexes InnoDB multiversion concurrency control (MVCC) treats secondary ...It keeps information about old versions of changed rows to support transactional features such as concurrency and ...
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 ...