Search Results
https://dev.mysql.com/doc/refman/9.7/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. It first checks all index entries for errors and then reads through all rows. This causes myisamchk to keep going, up through a maximum of 20 ...What it cannot find is corruption that involves only the data file (which is very ...
https://dev.mysql.com/doc/refman/9.7/en/sys-statements-with-errors-or-warnings.html
These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-no-data-found.html
The following list enumerates all NDB errors of type ND (No data found). NDB error code 626 MySQL error HA_ERR_KEY_NOT_FOUND Error message Tuple did not exist .
https://dev.mysql.com/doc/refman/9.7/en/using-log-files.html
If you find the text mysqld restarted in the error log (normally a file named host_name.err) you probably have found a query that causes mysqld to fail. If you get a lot of these errors, without mysqld having died unexpectedly just before, then ...
https://dev.mysql.com/doc/mysql-errors/9.7/en/index.html
It lists all error messages produced by server and client programs in MySQL 9.7. This document accompanies Error Messages and Common Problems, in MySQL 9.7 Reference Manual. For help with using MySQL, please visit the MySQL Forums, where you can ...
https://dev.mysql.com/doc/internals/en/use-of-disable-abort-on-error.html
This option is very useful when starting to write a new test because the test will not abort if your script contains some failing statements or SQL syntax errors. By disabling the abort, you get to see more of the errors per test run and can fix ...
https://dev.mysql.com/doc/refman/9.7/en/error-creating-innodb.html
Runtime Problems If InnoDB prints an operating system error during a file operation, usually the problem has one of the following solutions: Make sure the InnoDB data file directory and the InnoDB log directory exist. In particular, any MAX value in ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system ...
https://dev.mysql.com/doc/internals/en/troubleshooting-platform-checks.html
If you suspect that a platform check returned wrong result, examine CMakeFiles/CMakeError.log and CMakeFiles/CMakeOutput.log under the build directory.
https://dev.mysql.com/doc/refman/9.7/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/9.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.