PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
To check whether disabling use of index extensions improves performance, use this statement: SET optimizer_switch = 'use_index_extensions=off'; Use of index extensions by the optimizer is subject to the usual limits on the number of key parts in an ...This can result in more efficient query execution plans and better ... InnoDB automatically ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-metrics-table.html
To start, stop, and reset counters, set one of the system variables innodb_monitor_enable, innodb_monitor_disable, innodb_monitor_reset, or innodb_monitor_reset_all, using the name of the counter, the name of the module, a wildcard match for such a ... The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-multiple_io_threads.html
You can set values for these parameters in the MySQL option file (my.cnf or my.ini); you cannot change values dynamically. These parameters signify the number of background threads used for read and write requests, respectively. The default value ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-configuration.html
You can also set a location for the backup files using the BackupDataDir configuration parameter. Five configuration parameters are essential for backup: BackupDataBufferSize The amount of memory used to buffer data before it is written to disk. In ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. When comparing values from different columns, declare those ...
https://dev.mysql.com/doc/refman/5.7/en/perror.html
For most system errors, MySQL displays, in addition to an internal text message, the system error code in one of the following styles: message ... (Errcode: #) You can find out what the error code means by examining the documentation for your ...
https://dev.mysql.com/doc/refman/5.7/en/procedure-analyse.html
You may need to try different settings for the arguments so that PROCEDURE ANALYSE() does not suggest the ENUM data type when it is not appropriate. ANALYSE() examines the result from a query and returns an analysis of the results that suggests ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multiple-buffer-pools.html
For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency, by reducing contention as different threads read and write to cached pages. This feature is typically intended for ...Multiple buffer pool instances are configured using the innodb_buffer_pool_instances configuration option, and you might also adjust the innodb_buffer_pool_size ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-long-table.html
To set the table size explicitly, set the performance_schema_events_stages_history_long_size system variable at server startup. The Performance Schema autosizes the value of N during server startup. For more information about the relationship ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-long-table.html
To set the table size explicitly, set the performance_schema_events_statements_history_long_size system variable at server startup. For more information about the relationship between the three events_statements_xxx event tables, see Section 25.9, ... The events_statements_history_long table contains the N most recent statement events that have ended globally, across all ...