PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
Option Value Meaning 1 Reject the document and produce an error. If srid refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. For geographic SRS geometry arguments, if any argument has a longitude or latitude that ... This section describes functions for converting between GeoJSON documents and spatial ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
This script assists in creating the error log file only if the log location matches a pattern (/var/log/mysql*.log for RPM platforms, /var/log/mysql/*.log for Debian platforms). In other cases, the error log directory must be writable or the error ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
If the argument size exceeds 511 bytes, an ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE error occurs. Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-failure-handling.html
If a failure occurs during the prerequisite check, the CLONE INSTANCE operation reports an error. If the cloning operation is unable to obtain a DDL lock within the time limit specified by the clone_ddl_timeout variable, an error is reported. For ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
An error is returned if the explicit specification cannot be satisfied. An error is reported if a table or tablespace already exists. As of MySQL 8.0.18, an error is reported if duplicate undo tablespace file names are encountered during a cloning ... The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
If binary logging is enabled and binlog_format is set to STATEMENT, the statement is logged and executed but a warning message is written to the error log, because replication slaves might diverge. For nontransactional tables, an error occurs, but ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
In MySQL, common debug macro keywords to enable are enter, exit, error, warning, info, and loop. The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for ...
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.