PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
Copying over binary logs to the target server in advance is usually faster than reading the entire transaction execution history from the source in real time. There are a number of techniques when using MySQL Replication with Global Transaction ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.html
On the other replicas Replica 2 and Replica 3, use STOP REPLICA and CHANGE REPLICATION SOURCE TO SOURCE_HOST='Replica1' or CHANGE MASTER TO MASTER_HOST='Replica1' (where 'Replica1' represents the real host name of Replica 1). You can tell a replica ...
https://dev.mysql.com/doc/refman/8.0/en/security-plugins.html
Data masking hides sensitive information by replacing real values with substitutes. MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. For ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
An interactive client is defined as a client that uses the CLIENT_INTERACTIVE option to mysql_real_connect(). This value is measured in real time, not CPU time, so a query that is under the threshold on a lightly loaded system might be above the ...
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
This is a problem because many real world subqueries become very slow unless the equality can be pushed down. To help the query optimizer better execute your queries, use these suggestions: Declare a column as NOT NULL if it really is. Certain ...
https://dev.mysql.com/doc/refman/8.0/en/user-variables.html
Assignment of decimal and real values does not preserve the precision or scale of the value. You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
If any of the operands of a +, -, /, *, % is a real or string value, the precision of the result is the precision of the operand with the maximum precision. Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...