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/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructs result in CPU and I/O operations at the hardware level, which you must minimize and make as ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-issues.html
MySQL uses a cost-based optimizer to determine the best way to resolve a query. In many cases, MySQL can calculate the best possible query plan, but sometimes MySQL does not have enough information about the data at hand and has to make ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-memory-tables.html
For best performance with MEMORY tables, examine the kinds of queries against each table, and specify the type to use for each associated index, either a B-tree index or a hash index. B-tree indexes are fast for queries that do greater-than or ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
However, STRAIGHT_JOIN may prevent indexes from being used because it disables semijoin transformations; see Section 8.2.2.1, “Optimizing Subqueries, Derived Tables, and View References with Semijoin Transformations”. MySQL implements an A LEFT ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
You frequently run queries that depend directly on the column used for partitioning the table. A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
Note The information in this section applies fully only before MySQL 5.7.5, and only for accounts that use the mysql_native_password or mysql_old_password authentication plugins. This includes removal of the mysql_old_password authentication plugin ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this purpose. The discussion here relies on the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering.html
This involves the use of WHERE clauses in queries that select information from Performance Schema tables, to specify which of the available events you want to see. For information about writing queries to retrieve information (post-filtering), see ... Events are processed in a producer/consumer fashion: Instrumented code is the source for events and produces events to be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
row *************************** ENGINE: PERFORMANCE_SCHEMA SUPPORT: YES COMMENT: Performance Schema TRANSACTIONS: NO XA: NO SAVEPOINTS: NO mysql> SHOW ENGINES\G ... Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance Schema Transactions: NO ... This section briefly introduces the Performance Schema with examples that show how to use ...