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/optimizer-tracing-typical-usage.html
To examine traces for multiple queries, repeat the previous two steps as needed. To perform optimizer tracing entails the following steps: Enable tracing by executing SET optimizer_trace="enabled=ON". See Section 8.15.3, “Traceable Statements”, ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
When the system has unused I/O capacity, more read-ahead can improve the performance of queries. Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
Increase buffer pool size When table data is cached in the InnoDB buffer pool, it can be accessed repeatedly by queries without requiring any disk I/O. If you follow best practices for database design and tuning techniques for SQL operations, but ...
https://dev.mysql.com/doc/refman/5.7/en/option-modifiers.html
Some options are “boolean” and control behavior that can be turned on or off. For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names at the beginning of query results.
https://dev.mysql.com/doc/refman/5.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
MySQL enables database administrators to expire account passwords manually, and to establish a policy for automatic password expiration. Expiration policy can be established globally, and individual accounts can be set to either defer to the global ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
Some of these queries use the LIKE operator and a pattern match instrument names. The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; ...