PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/processlist-access.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. The following discussion enumerates the sources of process information, the privileges required ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/proxy-users.html
The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking purposes. This enables the external user to be a proxy for the second user; that is, to assume the ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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' (where 'Replica1' represents the real host name of Replica 1). You can tell a replica to change to a new source using the CHANGE ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/srjs-data-arguments.html
REAL is also treated as floating point, but UNSIGNED FLOAT and UNSIGNED DOUBLE are deprecated in MySQL, and are not supported by MLE. Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data ...
https://dev.mysql.com/doc/refman/9.7/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 ...