Trove/Configurations/mysql-options
< Trove | Configurations
Booleans
| 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
| 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 |
