Difference between revisions of "Trove/Configurations/mysql-options"

Revision as of 15:53, 21 October 2013

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

@@ Line 5: / Line 5: @@
 ! option !! Configurable by User !! default template (512MB) !! dynamic !! special case !! min !! max !! description
 |-
-| key_buffer_size || Yes || 50MB || true || false || 0 || 4294967296 || MyISAM index buffer
+| key_buffer_size || Yes || 50M || true || false || 0 || 4294967296 || MyISAM index buffer
 |-
-| Example || Example || Example || Example || Example || Example || Example || Example
+| join_buffer_size || Yes ||  || true || false || 0 || 4294967296 || Memory buffer used for joins on multiple tables that do not use an index
 |-
-| Example || Example || Example || Example || Example || Example || Example || Example
+| sort_buffer_size || Yes ||  || true || false || 2097144 || 1.84467E+19 || Buffer used for all queries that perform a sort action
 |-
-| Example || Example || Example || Example || Example || Example || Example || Example
+| innodb_buffer_pool_size || Yes || 150M || false || false || 0 || 68719476736 || Buffer used by innodb to cache data and indexes of it's tables
 |-
-| Example || Example || Example || Example || Example || Example || Example || Example
+| innodb_flush_log_at_trx_commit || Yes ||  || true || false || 0 || 2 || Frequency by which Innodb will flush it's logs to disk
 |}