PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/perror.html
perror displays the error message for MySQL or operating system error codes. For example, for the ER_WRONG_VALUE_FOR_VAR error, perror understands any of these arguments: 1231, 001231, MY-1231, or MY-001231, or ER_WRONG_VALUE_FOR_VAR. The meaning ...A given error code may mean different things on different operating ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/sys-statements-with-errors-or-warnings.html
These views display normalized statements that have produced errors or warnings. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these columns: query The normalized statement string. db The default ...By ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html
Use a noop or deadline I/O scheduler with native AIO on Linux InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform read-ahead and write requests for data file pages. Increase buffer pool size When table data is cached in the ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O ...
https://dev.mysql.com/doc/refman/8.0/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 8.2, “Access Control and Account Management”, and Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbxfrm.html
The .Data, .ctl, and .log files comprising the backup must be encrypted separately, and these files must be encrypted separately for each data node. An encrypted file can be re-encrypted with a new password using the --encrypt-password and ... The ...--decrypt-password-from-stdin[=TRUE|FALSE] Command-Line Format --decrypt-password-from-stdin Introduced 8.0.24-ndb-8.0.24 Decrypts a file encrypted by NDB, using a password supplied from standard ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tde-implementation.html
The PK (unique to each node) encrypts the data on each node in its own secrets file. The data in the secrets file includes a unique, randomly generated Node Master Key (NMK). The NMK encrypts (using wrapping) one or more randomly generated data ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html
Static and Live Backups To back up a server's binary log files with mysqlbinlog, you must specify file names that actually exist on the server. If the --result-file value consists only of a directory name, the value must end with the pathname ... By ...In continuous-backup operation, mysqlbinlog runs until the connection ends (for example, when the server exits) or mysqlbinlog is forcibly ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
If --add-drop-database is used with --all-databases or with --databases where the list of schemas to be dumped includes mysql, the dump file contains a DROP DATABASE `mysql` statement that causes an error when the dump file is reloaded. Because the ...To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those ...