Properties:
| Applicable To | InnoDB | ||||||
| Introduced In | 5.1.22 | ||||||
| Server Startup Option | --innodb-autoinc-lock-mode=<value> | ||||||
| Scope | Global | ||||||
| Dynamic | No | ||||||
| Possible Values |
enum(0,1,2) Interpretation:
|
Apr
15
2008
Apr
11
2008
Properties:
| Applicable To | InnoDB |
| Type | Status Variable |
| Scope | GLOBAL | SESSION |
| Dynamic | NA |
| Possible Values | Integer |
| Default Value | NA |
| Category | Performance |
Description:
According to the official documentation, this variable defines
"The number of logical reads that InnoDB could not
satisfy from the buffer pool …
Apr
08
2008
Properties:
| Applicable To | InnoDB | |||||
| Server Startup Option | --innodb_thread_concurrency=<value> | |||||
| Scope | Global | |||||
| Dynamic | Yes | |||||
| Possible Values |
Integer: Range: 0 - 1000 Interpretation:
|
Apr
03
2008
Properties:
| Applicable To | InnoDB |
| Server Startup Option | --innodb_buffer_pool_size=<value> |
| Scope | Global |
| Dynamic | No |
| Possible Values |
Integer Range: 1048576 (1MB) - 4294967295 (4GB) (more for 64 bit machines) |
| Default Value | 8388608 (8MB) |
| Category | Performance |
Description:
One of the Peter's "what to …
[Read more]
Mar
29
2008
Properties:
| Applicable To | MySQL Server |
| Server Startup Option | --max_connect_errors=<value> |
| Scope | Global |
| Dynamic | Yes |
| Possible Values |
Integer Range: 1 - 4294967295 |
| Default Value | 10 |
| Category | Security |
Description:
This variable determines how many interrupted connections can occur from a host. If the number of interrupted connections from this host surpasses this number, that host is blocked from further connections. All of the …
[Read more]
Mar
28
2008
Properties:
| Engine(s) | MyISAM |
| Server Startup Option | --key_buffer_size=<value> |
| Scope | Global |
| Dynamic | Yes |
| Possible Values |
Integer Range: 8 - 4294967295 (4 GB) |
| Default Value | 131072 (128 KB) |
| Category | Performance |
Description:
This is a global buffer where MySQL caches frequently used blocks of index data for MyISAM data. Maximum allowed size is 4GB on a 32 bit platform. Greater values are permitted for 64-bit platforms beyond MySQL …
[Read more]