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/optimizing-innodb-transaction-management.html
Queries that normally could retrieve all the result columns from a secondary index, instead look up the appropriate values from the table data. To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
For example: SELECT * FROM t1 WHERE t1.column1 IN (SELECT column1 FROM t2 ORDER BY column1); SELECT * FROM t1 WHERE t1.column1 IN (SELECT DISTINCT column1 FROM t2); SELECT * FROM t1 WHERE EXISTS (SELECT * FROM t2 LIMIT 1); Replace a join with a ...
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html
You can increase this if the server needs to handle big queries (for example, if you are working with big BLOB columns). A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-linear-hash.html
CEILING(3.7004397181411) is 4, and V = POWER(2,4), which is 16.) Set N = F(column_list) & (V - 1). MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
MySQL 5.7 provides a number of ways to modify partitioned tables. It is possible to add, drop, redefine, merge, or split existing partitions. All of these actions can be carried out using the partitioning extensions to the ALTER TABLE statement.
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
Note As of MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is removed in MySQL 8.0, when the storage engine used for a given table is expected to provide its own (“native”) partitioning handler. Use of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_accounts_size ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-cond-instances-table.html
The cond_instances table has these columns: NAME The instrument name associated with the condition. The cond_instances table lists all the conditions seen by the Performance Schema while the server executes. A condition is a synchronization ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively ...