Search Results
https://dev.mysql.com/doc/refman/8.4/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. For DECIMAL columns, MySQL performs operations with a precision of 65 decimal digits, which should solve most common inaccuracy problems.
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-pausing.html
You can stop and start replication on the replica using the STOP REPLICA and START REPLICA statements. The I/O (receiver) thread continues to read events from the source but they are not executed. This makes it easier for the replica to catch up ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-encryption-keys.html
The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL Keyring”).
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
For more information on setting up a server and client for encrypted connections, see Section 8.3.1, “Configuring MySQL to Use Encrypted Connections”. The protocols, ciphers, and ciphersuites that you can specify in these lists depend on the SSL ... To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the sources using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication applier metadata repositories, and provisioned the replica with data ...
https://dev.mysql.com/doc/refman/8.4/en/select-benchmarking.html
To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value is always zero, but mysql prints a line displaying approximately how long the statement took to ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html
Example: mysql> CREATE TABLE t1 ( i1 INT CHECK (i1 <> 0), -- column constraint i2 INT, CHECK (i2 > i1), -- table constraint CHECK (i2 <> 0) NOT ENFORCED -- table constraint, not enforced ); mysql> SHOW CREATE TABLE t1\G *************************** 1. For example, when changing the storage engine from InnoDB to MyISAM, options specific to InnoDB, such as ROW_FORMAT=COMPACT, are retained, as shown here: mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) ROW_FORMAT=COMPACT ENGINE=InnoDB; mysql> ALTER TABLE t1 ENGINE=MyISAM; mysql> SHOW CREATE TABLE t1\G *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...
https://dev.mysql.com/doc/refman/8.4/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-elements.html
In older versions of MySQL, the monitoring tables were INFORMATION_SCHEMA tables (see Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”). The INFORMATION_SCHEMA tables are deprecated; expect them to be removed in a future version of MySQL.