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

Revision as of 15:58, 21 October 2013

option	Configurable by User	default template (512MB)	dynamic	special case	max	description
innodb_file_per_table	Yes		false	false	1	Create a separate tablespace for each innodb table when enabled
autocommit	Yes		true	false	1	Enable or disable MySQL's autocommit feature
local_infile	Yes	0	true	false	1	Enable client side import files for clients not supporting mysqldump formatted files

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 1: / Line 1: @@
+=== Booleans ===
+{| class="wikitable sortable"
+|-
+! option !! Configurable by User !! default template (512MB) !! dynamic !! special case !! min !! max !! description
+|-
+| innodb_file_per_table || Yes ||  || false || false || 0 || 1 || Create a separate tablespace for each innodb table when enabled
+|-
+| autocommit || Yes ||  || true || false || 0 || 1 || Enable or disable MySQL's autocommit feature
+|-
+| local_infile || Yes || 0 || true || false || 0 || 1 || Enable client side import files for clients not supporting mysqldump formatted files
+|}
 === Integers ===