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/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/backup-policy.html
For example, for the MyISAM tables in the mysql database, there must be no administrative changes to MySQL accounts during the backup. The MySQL binary logs are important for recovery because they form the set of incremental backups. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
To import the dump file into a new database, and have the tables re-created as they exist in the original database, ensure the server has the proper settings for the configuration parameters innodb_file_format and innodb_file_per_table. SQL ...ERROR ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
(Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of setup_objects; the row for information_schema.% simply makes this default explicit.) When the Performance Schema checks for a match in setup_objects, it ...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
If the variable is set to ALWAYS (or 2), concurrent inserts at the end of the table are permitted even for tables that have deleted rows. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the ...
https://dev.mysql.com/doc/refman/5.7/en/security-options.html
For descriptions of each of these, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”. The following table shows mysqld options and system variables that affect security.
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-account-enabled.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Parameters in_host VARCHAR(60): The host name of the account to check. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...