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/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/replication-solutions-performance.html
Figure 16.3 Using an Additional Replication Source to Improve Performance For this to work, you must configure the MySQL instances as follows: Source 1 is the primary source where all changes and updates are written to the database. The above ...If ... As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client connection to the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
Configuring Stage Event Collection Stage Event Progress Information Configuring Stage Event Collection To control whether to collect stage events, set the state of the relevant instruments and consumers: The setup_instruments table contains ... The ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
To turn on all restrictions, you can simply use TRADITIONAL mode, which includes both strict mode values and ERROR_FOR_DIVISION_BY_ZERO: SET sql_mode='TRADITIONAL'; If a number is inserted into an exact type column (DECIMAL or integer), it is ...For ... With precision math, exact-value numbers are used as given whenever ...