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/problems.html
This section lists some common problems and error messages that you may encounter. It describes how to determine the causes of the problems and what to do to solve them.
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
OpenSSL also imposes a maximum key length of 10,000 bits and 16,384 bits for DSA and RSA keys, respectively, for create_asymmetric_priv_key(), and a maximum key length of 10,000 bits for create_dh_parameters(). If those maximum values are too high, ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
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-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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/comp-err.html
comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. It compiles the errmsg.sys file from the text-format error information file located at sql/share/errmsg-utf8.txt in ...
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/optimize-table.html
To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a sequence of OPTIMIZE TABLE statements until the search index is fully updated.