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/perl-support.html
Although earlier versions are available, they do not support the full functionality of MySQL 8.0. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.0/en/replica-connection-thread-states.html
In MySQL 8.0.26, incompatible changes were made to instrumentation names, including the names of thread stages, containing the terms “master”, which is changed to “source”, “slave”, which is changed to “replica”, and “mts” (for ... These thread states occur on a replica server but are associated with connection threads, not with the I/O or SQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-replica.html
In MySQL 8.0.27 and later, asynchronous connection failover for replicas is activated automatically for a replication channel on a Group Replication primary when you set SOURCE_CONNECTION_AUTO_FAILOVER=1 in the CHANGE REPLICATION SOURCE TO ...The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-select.html
Prior to MySQL 8.0.21, the statement is logged as two transactions. As of MySQL 8.0.21, on storage engines that support atomic DDL, it is logged as one transaction. If the destination table exists and IF NOT EXISTS is given, MySQL 8.0 ignores the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html
In a different session on the source, use the SHOW MASTER STATUS statement to determine the current binary log file name and position: mysql> SHOW MASTER STATUS\G *************************** 1. row *************************** File: mysql-bin.000003 ... To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-configuration.html
Replicas in a multi-source replication topology require TABLE repositories for the replica's connection metadata repository and applier metadata repository, which are the default in MySQL 8.0. A multi-source replication topology requires at least ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
For information about the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics Area”. A condition area contains condition information items, such as the SQLSTATE value, MYSQL_ERRNO, or MESSAGE_TEXT. ERROR 1051 (42S02): Unknown table ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin.html
MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL distributions include a postparse query rewrite plugin named Rewriter and scripts for installing ...These elements work together to provide statement-rewriting capability: A server-side plugin named Rewriter examines statements and may rewrite them, based on its in-memory cache of rewrite ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...