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/audit-log-restrictions.html
Prior to MySQL 5.7.21, MySQL Enterprise Audit uses MyISAM tables in the mysql system database. MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as memcached, Node.JS, ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
You may also find the MySQL User Forums to be helpful. Section 23.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. Section 23.4.4, “Event Metadata”, shows how to obtain information about ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. TABLE_CATALOG The name of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. TABLE_SCHEMA The name of ...TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-model.html
Typically, several users are permitted to lock every row in InnoDB tables, or any random subset of the rows, without causing InnoDB memory exhaustion. The InnoDB transaction model aims combine the best properties of a multi-versioning database with ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-file.html
In such cases we try to let NDB Cluster users know in advance if a change is not backward compatible. Configuring NDB Cluster requires working with two files: my.cnf: Specifies options for all NDB Cluster executables. config.ini: This file, ...This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-workloads.html
Due to its distributed architecture and multi-node implementation, NDB Cluster also has specific constraints that may keep some workloads from performing well. A number of major differences in behavior between the NDB and InnoDB storage engines with ... NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low ...
https://dev.mysql.com/doc/refman/5.7/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code. For a ...CONDITION statement declares a named error condition, associating a name with a condition that needs specific ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-transactions.html
INNODB_LOCKS: Each transaction in InnoDB that is waiting for another transaction to release a lock (INNODB_TRX.TRX_STATE is LOCK WAIT) is blocked by exactly one blocking lock request. That blocking lock request is for a row or table lock held by ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-linux-quick.html
Note Installation packages for MySQL Shell are available only for a limited number of Linux distributions, and only for 64-bit systems. For supported Linux distributions, the easiest way to install MySQL Shell on Linux is to use the MySQL APT ...If ...