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/group-by-handling.html
Result set sorting occurs after values have been chosen, and ORDER BY does not affect which value within each group the server chooses. SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
The consistency level can have different affects on read-only and read/write transactions processed by the group as demonstrated in this section. AFTER A read/write transaction waits until its changes have been applied to all of the other members.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
Restore backup of s2 onto the host for s3: s3> mysqlbackup --defaults-file=/etc/my.cnf \ --datadir=/var/lib/mysql \ --backup-image=/backups/my.mbi_2206_1429 \ --backup-dir=/tmp/restore_`date +%d%m_%H%M` copy-back-and-apply-log Note The command above ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
The locking interface has these characteristics: Locks have three attributes: Lock namespace, lock name, and lock mode: Locks are identified by the combination of namespace and lock name. Namespace and lock names must be non-NULL, nonempty, and have ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-example.html
Wait until both of the new data nodes have started before proceeding with the next step. REORGANIZE PARTITION statements for NDBCLUSTER tables created after the new data nodes have been added; data added to such tables is distributed among all data ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...
https://dev.mysql.com/doc/refman/8.0/en/proxy-users.html
The proxy user account must have the PROXY privilege for the proxied account. Granting and Revoking the PROXY Privilege The PROXY privilege is needed to enable an external user to connect as and have the privileges of another user. The second ...The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
Tables that use the MEMORY storage engine are deleted automatically the first time they are accessed after the server is started, because rows might have been lost during the shutdown. The two parts of the transaction are therefore replicated ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
Inconsistencies in the sequence of transactions from the relay log which have been executed can cause this value to be a “low-water mark”. In other words, transactions appearing before the position are guaranteed to have committed, but ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
It is strongly recommended that you never change the SQL mode once you have created tables employing user-defined partitioning. It is always permissible to have spaces after a loadable function or stored function name, regardless of whether ... The ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
The distinction between system and regular accounts enables better control over certain account administration issues by protecting accounts that have the SYSTEM_USER privilege from accounts that do not have the privilege. To kill a session or ...