PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. InnoDB tables arrange your data on disk to optimize queries based on primary keys. Each InnoDB table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
The combination of InnoDB tables and memcached offers advantages over using either by themselves. Data written using the memcached protocol is transparently written to an InnoDB table, without going through the MySQL SQL layer. Data requested ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-dml.html
These operations are guaranteed to only affect one row when issued through the memcached interface, because the key is unique within the table. In the following SQL examples, t1 refers to the table used for memcached operations, based on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
Let the table contain rows having id values of 90 and 102. If the locks set on the index records in the scanned range do not lock out inserts made in the gaps (in this case, the gap between 90 and 102), another session can insert a new row into the ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
Issues relating to the InnoDB data dictionary include failed CREATE TABLE statements (orphan table files), inability to open InnoDB files, and system cannot find the path specified errors. If the problem is with table creation, tablespaces, or data ... The following general guidelines apply to troubleshooting InnoDB problems: When an operation fails or you suspect a bug, look at the MySQL server error log (see Section 5.4.2, “The Error ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Reserved words are permitted as identifiers if you quote them as described in Section 9.2, ...This ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
LDAP pluggable authentication provides these capabilities: External authentication: LDAP authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables in LDAP directories. The following tables show the ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. To view available MySQL memory instruments, query the Performance Schema setup_instruments table. After restarting the server, the ENABLED ... The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory ...
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. Then the keys are sorted and finally the rows are retrieved from ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
You may also wish to do this when performing bulk DELETE or UPDATE operations on NDB Cluster tables. If a data import operation does not complete successfully, for whatever reason, you should be prepared to perform any necessary cleanup including ...