PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking the EVENT privilege from a user does not delete or disable any events that may ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
Important If you insert multiple rows using a single INSERT statement, LAST_INSERT_ID() returns the value generated for the first inserted row only. It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
InnoDB file-per-table tablespaces may report IMPORTING, which indicates that the tablespace is not yet available. It is also important to remember that once an extent is used, it cannot be freed again without dropping the data file of which it is a ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbd.html
Important This option does not affect either of the following types of files: Backup files that have already been created by the affected node NDB Cluster Disk Data files (see Section 21.6.11, “NDB Cluster Disk Data Tables”). Important Do not ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-issues.html
For this reason, to guarantee high availability, it is extremely important to maintain a backup replication channel, to monitor the primary channel, and to fail over to the secondary replication channel when necessary to keep the replica cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-privileges.html
It is important to keep in mind that, by default, the MySQL grant tables use the MyISAM storage engine. The most important points to remember regarding the MySQL privilege system with regard to NDB Cluster are listed here: Users and privileges ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-multi.html
Some notes about mysqld_multi: Most important: Before using mysqld_multi be sure that you understand the meanings of the options that are passed to the mysqld servers and why you would want to have separate mysqld processes. Important Make sure that ... mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
$> mysqldump --no-data --routines --events --triggers --databases > myschema.sql Important Once you have created the NDB native backup using ndb_mgm, you must not make any schema changes before creating the backup of the schema, if you do so. It is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html
It is extremely important that you make sure the replica has processed all updates before continuing. Important It is important to understand that logs containing transactions without GTIDs cannot be used on servers where GTIDs are enabled. This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-disable-gtids.html
It is important to understand that logs containing GTID transactions cannot be used after the next step. This section describes how to disable GTID transactions on servers that are already online. This procedure does not require taking the server ...