PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. The following list indicates possible causes of and fixes for this ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
This access method merges index scans from a single table only, not scans across multiple tables. AND key_partN = constN Any range condition over the primary key of an InnoDB table. If all columns used in the query are covered by the used indexes, ... The Index Merge access method retrieves rows with multiple range scans and merges their results into ...
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/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 ...