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/create-event.html
For information about user auditing within events, see Section 6.2.18, “SQL-Based Account Activity Auditing”. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
In such cases, the server returns ER_HOST_NOT_PRIVILEGED and does not even ask for a user name or password. For example, the database does not exist or the user has no privileges to access it. MySQL does not perform matching of Host column values in ...COUNT_HOST_ACL_ERRORS The number of errors that occur because no users are permitted to connect from the client ... The MySQL server maintains an in-memory host ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
The maximum possible number of user-defined partitions for a table using the NDB storage engine is determined according to the version of the NDB Cluster software being used, the number of data nodes, and other factors. More specifically, this means ...Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were ...For a list of SQL functions which ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html
For example: CALL mysql.sp_set_firewall_mode(user, mode); The following list describes each firewall stored procedure: sp_reload_firewall_rules(user) This stored procedure provides control over firewall operation for individual account profiles. The ...Each mysql system database table is accessible only by accounts that have the SELECT privilege for ...The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-client-commands.html
ENTER SINGLE USER MODE node_id Enters single user mode, whereby only the MySQL server identified by the node ID node_id is permitted to access the database. EXIT SINGLE USER MODE Exits single user mode, enabling all SQL nodes (that is, all running ...Note It is possible to use EXIT SINGLE USER MODE even when not in single user mode, although the command has no effect in this ...Commands for the event logs are given in Section 21.6.3, “Event Reports Generated in NDB ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-users-table.html
To set the table size explicitly, set the performance_schema_users_size system variable at server startup. The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
--output-workers=# Command-Line Format --output-workers=# Introduced 5.7.18-ndb-7.6.2 Type Integer Default Value 2 Minimum Value 1 Maximum Value 4294967295 Set the number of threads processing output or relaying database operations. --resume ...See ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...ndb_import ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
Important For users familiar with the ANSI/ISO SQL Standard, please note that no storage engine, including InnoDB, recognizes or enforces the MATCH clause used in referential integrity constraint definitions. Character data types (CHAR, VARCHAR, the ...By default, tables are created in the default database, using the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
Normally, each MySQL server's user privilege tables in the mysql database must use the MyISAM storage engine, which means that a user account and its associated privileges created on one SQL node are not available on the cluster's other SQL nodes. A ...This support is not enabled by default; you should follow the procedure outlined in this section in order to do ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: 46b876e64cd5c41009d91c754921f1d4 normalized_pattern: select ? For information about statement ...To ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...