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-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 24.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Deprecated INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-engines.html
For those unaccustomed to working with NDB, unexpected behaviors can arise due to its distributed nature with regard to transactions, foreign keys, table limits, and other characteristics. The NDB storage engine is implemented using a distributed, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-errors.html
For example, since MyISAM ignores foreign key constraints, an INSERT or UPDATE statement accessing an InnoDB table on the source might cause a foreign key violation but the same statement performed on a MyISAM version of the same table on the ... If ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 6.4.5.1, “Elements of MySQL Enterprise Audit”. For general information about ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
TRX_FOREIGN_KEY_CHECKS Whether foreign key checks are turned on or off for the current transaction. TRX_LAST_FOREIGN_KEY_ERROR The detailed error message for the last foreign key error, if any; otherwise NULL. The INNODB_TRX table provides ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-truncate-table-reclaim-space.html
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the TRUNCATE TABLE operation fails. A foreign key constraint between two columns in the same table, however, is permitted. To ...
https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html
This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command line or as a Windows service. The information here applies primarily if you ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
The format of the CREATE SERVER statement is: CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) The server_name is used in the connection string when creating a new FEDERATED table. If you are creating a ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
ndb_show_foreign_key_mock_tables Command-Line Format --ndb-show-foreign-key-mock-tables[={OFF|ON}] System Variable ndb_show_foreign_key_mock_tables Scope Global Dynamic Yes Type Boolean Default Value OFF Show the mock tables used by NDB to support ...--ndb-distribution=[KEYHASH|LINHASH] Command-Line Format --ndb-distribution={KEYHASH|LINHASH} System Variable ndb_distribution Scope Global Dynamic Yes Type Enumeration Default Value KEYHASH Valid Values LINHASHKEYHASH Controls the default distribution method for NDB ...