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-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/flush.html
This operation does not perform an implicit UNLOCK TABLES, so an error results if you perform the operation while there is any active LOCK TABLES or use it a second time without first releasing the locks acquired. FLUSH DES_KEY_FILE Reloads the DES ...| table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during execution. If the server does not detect this change the next ...To avoid problems caused by metadata changes to tables or views referred to by the prepared statement, the server detects these changes and automatically reprepares the statement when it is next ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
However, if there are multiple triggers with the same trigger event and action time, the server executes only one of them when the trigger event occurs. Logging Changes Support for sending the server error log to syslog in MySQL 5.7.5 and up differs ... Before downgrading from MySQL 5.7, review the information in this ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. You can cope with deadlocks and reduce the likelihood of their occurrence with the following techniques: At any time, ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
This includes defining custom file paths for the error log, general log, slow query log (including the configuration of seconds it requires to execute a query), and the binary log. The Logging Options step enables you to define custom file paths for ...Otherwise, the process stops and displays an error message if an individual action times ...Unlike the initial setup, which ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
InnoDB supports a maximum of 128 rollback segments, 32 of which are allocated to the temporary tablespace. Note It is possible to encounter a concurrent transaction limit error before reaching the number of concurrent read-write transactions that ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
deleting from reference tables The server is executing the second part of a multiple-table delete and deleting the matched rows from the other tables. updating reference tables The server is executing the second part of a multiple-table update and ...This state is used even if the table could not be created due to some ... The following list describes thread State values that are associated with ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. Command Syntax Meaning default Reset every optimization to its default value opt_name=default Set the named optimization to its default value opt_name=off Disable the named ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
Your firewall may be configured on the basis of the application being executed, or the port number used by MySQL for communication (3306 by default). After a fresh installation, if you try to log on to the server as root without using a password, ...