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/mysql-indexes.html
Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. If the table has an index for the columns in question, MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
Windows requires a newly added member to first log out and then log in again to join a local group. MySQL Installer provides a wizard-like tool to install and configure new MySQL products for Windows. Unlike the initial setup, which runs only once, ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. MySQL supports an extension for optionally ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table and referencing it with a join query when needed. When storing a large blob ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
If a table contains string columns such as name and address, but many queries do not retrieve those columns, consider splitting the string columns into a separate table and using join queries with a foreign key when necessary. For character and ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-features-to-trace.html
They are: Greedy search: With an N-table join, this could explore factorial(N) plans. dynamic_range: Only the first call to the range optimizer on this JOIN_TAB::SQL_SELECT is traced. Some features in the optimizer can be invoked many times during ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
(For unique indexes, this is always 1.) MySQL uses this to decide which index to choose when you join two tables based on a nonconstant expression. Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
Effects on DML statements SELECT statements (including those containing unions or joins) lock only those partitions that actually need to be read. In MySQL 5.7, partition lock pruning eliminates unneeded locks in many cases, and most statements ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-group-members-table.html
RECOVERING: The server has joined a group from which it is retrieving data. This table shows network and status information for replication group members. The network addresses shown are the addresses used to connect clients to the group, and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-restrictions.html
For example, if you select events from a performance_schema table into a temporary table, intending to join that table with the original table later, there might be no matches. The Performance Schema avoids using mutexes to collect or produce data, ...