Properties:
| Applicable To | InnoDB |
| Server Startup Option |
--innodb_log_file_size=<value>
|
| Scope | Global |
| Dynamic | Yes |
| Possible Values |
Integer: Range: 1M - 4G <1M will be adjusted to 1M |
| Default Value | 5M |
| Category | Performance, Maintenance |
Description:
This variable defines the size of each log file in a log group.
While setting this variable it should be noted that combined size
of all log files should be less than …
Properties:
| Applicable To | MyISAM |
| Server Startup Option |
--bulk_insert_buffer_size=<value>
|
| Scope | Both |
| Dynamic | Yes |
| Possible Values |
Integer:
Range: 0 - 4294967295 (4G) |
| Default Value | 8388608 (8M) |
| Category | Performance |
Description:
This cache is used by MyISAM to optimize bulk inserts. This cache
is a special tree-like structure. Bulk inserts include statements
like LOAD DATA INFILE..., …
Properties:
| Applicable To | MySQL Server |
| Server Startup Option |
--log-queries-not-using-indexes
|
| Scope | Global |
| Dynamic | Yes |
| Possible Values | Boolean |
| Default | False |
| Category | Performance, Monitoring, Best Practices |
Description:
If you have slow query logs enabled (with
--log-slow-queries), this variable will help
interpret all those queries that are not using indexes as slow
queries.
Usage:
While …
[Read more]Properties:
| Applicable To | MySQL Server |
| Introduced In | 5.1.5 |
| Server Startup Option | --binlog-format=<value> |
| Scope | Both |
| Dynamic | Yes |
| Possible Values | enum(ROW, STATEMENT, MIXED) |
| Default |
< 5.1.12: STATEMENT >= 5.1.12: MIXED |
| Categories | Replication, Performance |
Description:
Starting with 5.1.5, MySQL has implemented ROW based replication format which logs the physical …
[Read more]Properties:
| Applicable To | InnoDB on Unix like OS |
| Server Startup Option | --innodb_flush_method=<value> |
| Scope | Global |
| Dynamic | No |
| Possible Values | enum(O_DSYNC, O_DIRECT, <<none>> ) |
| Default Value | <<none>> |
| Category | Performance |
Description:
This variable changes the way InnoDB open files and flush data to disk and is should be considered as very important for InnoDB performance. By default, InnoDB uses …
[Read more]Properties:
| Applicable To | MySQL/Linux |
| Server Startup Option | --large-pages |
| Scope | Global |
| Dynamic | No way |
| Possible Values | True|False flag |
| Default Value | False |
| Category | Performance, Administration |
Description:
This option, currently available only for Linux, if set enables the usage of large pages by MySQL. Many operating systems/system architectures support optional memory pages bigger than the default size (4 KB). Usually the large page size is 2 MB, this …
[Read more]Well, the first summary of last 10 variable day outs.
Day Outs:
Properties:
| Applicable To | InnoDB |
| Server Startup Option | --innodb-file-per-table |
| Scope | Global |
| Dynamic |
General InnoDB Engine: No InnoDB plug-in: Yes |
| Possible Values | Enable|Disable Flag |
| Default Value | Disabled |
| Category | Maintenance |
Description:
This variable if enabled, makes InnoDB to create a separate
.ibd file for storing indexes and data. Setting this
variable makes it easy to manage disks with huge tables. Having …
Properties:
| Applicable To | MySQL Server |
| Server Startup Option | --long-query-time=<value> |
| Scope | Both |
| Dynamic | Yes |
| Possible Values |
(< 5.1.21): Integer (>=5.1.21): Numeric |
| Minimum Value |
(< 5.1.21): 1 (>=5.1.21): 0 |
| Default Value | 10 |
| Category | Monitoring |
Description:
In case (as generally the case is) one wants to know about the bottlenecks in their …
[Read more]Properties:
| Applicable To | InnoDB |
| Server Startup Option | --innodb-additional-mem-pool-size=<value> |
| Scope | Global |
| Dynamic | No |
| Possible Values | Integer: Range: 524288 (512K) - 4294967295 (4G) |
| Default Value | 1048576 (1M) |
| Category | Performance |
Description:
As per MySQL documentation, this pool is used to store data …
[Read more]