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/events-privileges.html
The same would be true if root had issued either of these statements: DROP USER jon@ghidora; RENAME USER jon@ghidora TO someotherguy@ghidora; You can verify that this is true by examining the Information Schema EVENTS table before and after issuing ... 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/8.0/en/firewall-reference.html
For example, if the profile was in PROTECTING mode, that is no longer true after calling sp_reload_firewall_group_rules() and you must set it to PROTECTING again explicitly. For example, if the profile was in PROTECTING mode, that is no longer true ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise Firewall”. This section describes how to configure MySQL Enterprise Firewall using SQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
Table 14.26 GTID Functions Name Description Deprecated GTID_SUBSET() Return true if all GTIDs in subset are also in set; otherwise false. 8.0.18 GTID_SUBSET(set1,set2) Given two sets of global transaction identifiers set1 and set2, returns true if ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
If that is successful, the host name is updated with the resolved host name and the validation flag is set to true. For permanent failures, the host name remains NULL and the validation flag is set to true. The MySQL server maintains an in-memory ...
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
That is true for names of cursors, conditions, procedures, functions, savepoints, stored routine parameters, stored program local variables, and plugins. It is not true for names of columns, constraints, databases, partitions, statements prepared ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 is not true when expr1 or expr2 (or both) are NULL. This affects ref accesses for comparisons of the form tbl_name.key = expr: MySQL does not access ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
This result is true whether or not there are concurrently executing “INSERT-like” statements (of any type). This result is true whether or not there are concurrently executing “INSERT-like” statements (of any type). InnoDB provides a ...