Difference between revisions of "Trove/Configurations/mysql-options"
< Trove | Configurations
(Created page with "=== Integers === {| class="wikitable sortable" |- ! option !! Configurable by User !! default template (512MB) !! dynamic !! special case !! min !! max !! description |- | ke...") |
(→Integers) |
||
Line 5: | Line 5: | ||
! option !! Configurable by User !! default template (512MB) !! dynamic !! special case !! min !! max !! description | ! option !! Configurable by User !! default template (512MB) !! dynamic !! special case !! min !! max !! description | ||
|- | |- | ||
− | | key_buffer_size || Yes || | + | | key_buffer_size || Yes || 50M || true || false || 0 || 4294967296 || MyISAM index buffer |
|- | |- | ||
− | | | + | | join_buffer_size || Yes || || true || false || 0 || 4294967296 || Memory buffer used for joins on multiple tables that do not use an index |
|- | |- | ||
− | | | + | | sort_buffer_size || Yes || || true || false || 2097144 || 1.84467E+19 || Buffer used for all queries that perform a sort action |
|- | |- | ||
− | | | + | | innodb_buffer_pool_size || Yes || 150M || false || false || 0 || 68719476736 || Buffer used by innodb to cache data and indexes of it's tables |
|- | |- | ||
− | | | + | | innodb_flush_log_at_trx_commit || Yes || || true || false || 0 || 2 || Frequency by which Innodb will flush it's logs to disk |
|} | |} |
Revision as of 15:53, 21 October 2013
Integers
option | Configurable by User | default template (512MB) | dynamic | special case | min | max | description |
---|---|---|---|---|---|---|---|
key_buffer_size | Yes | 50M | true | false | 0 | 4294967296 | MyISAM index buffer |
join_buffer_size | Yes | true | false | 0 | 4294967296 | Memory buffer used for joins on multiple tables that do not use an index | |
sort_buffer_size | Yes | true | false | 2097144 | 1.84467E+19 | Buffer used for all queries that perform a sort action | |
innodb_buffer_pool_size | Yes | 150M | false | false | 0 | 68719476736 | Buffer used by innodb to cache data and indexes of it's tables |
innodb_flush_log_at_trx_commit | Yes | true | false | 0 | 2 | Frequency by which Innodb will flush it's logs to disk |