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/innodb-troubleshooting-datadict.html
Cannot Open Datafile With innodb_file_per_table enabled (the default), the following messages may appear at startup if a file-per-table tablespace file (.ibd file) is missing: [ERROR] InnoDB: Operating system error number 2 in a file operation.
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
If either of these conditions is true, the following happens: The server checks the table for errors. If the server finds an error, it tries to do a fast table repair (with sorting and without re-creating the data file). If the repair fails because ... The following options to mysqld can be used to change the behavior of MyISAM ...
25.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-auto-sync.html
It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster Replication”). The following Perl script reset-replica.pl serves as an example of how you can do this.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
Examples of incidents are server failures, database resynchronization, some software updates, and some hardware changes.) When the replica encounters a gap in the replication log, it stops with an error message. Note The NDB storage engine uses ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
For example: # at 141 #100309 9:28:36 server id 123 end_log_pos 245 Query thread_id=3350 exec_time=11 error_code=0 In the first line, the number following at indicates the file offset, or starting position, of the event in the binary log file. Like ...Note that from MySQL 8.0.14, mysqlbinlog returns a suitable error if you attempt to read an encrypted binary log file directly, but older versions of mysqlbinlog do not recognise the file as a binary log file at ...
https://dev.mysql.com/doc/refman/8.0/en/network-namespace-support.html
If an error occurs during server startup for attempts to use a namespace, the server does not start. If errors occur for X Plugin during plugin initialization such that it is unable to bind to any address, the plugin fails its initialization ... A ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-status-table.html
LAST_ERROR_NUMBER, LAST_ERROR_MESSAGE The error number and error message of the most recent error that caused the I/O thread to stop. An error number of 0 and message of the empty string mean “no error.” If the LAST_ERROR_MESSAGE value is not ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
An error in a manually entered setting might not be discovered until much later. SET statements that persist system variables avoid the possibility of malformed settings because settings with syntax errors do not succeed and do not change server ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
If any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE error occurs (ER_LONGITUDE_OUT_OF_RANGE prior to MySQL 8.0.12). If ... Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
With the IGNORE modifier, the update statement does not abort even if errors occur during the update. Rows updated to values that would cause data conversion errors are updated to the closest valid values instead. (This is because the order in which ... UPDATE is a DML statement that modifies rows in a ...