Trove/Configurations/mysql-options
< Trove | Configurations
Overview
These are a list of the options that can be part of a configuration group for mysql.
Options that are not dynamic require a restart of the mysql service.
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 |
Special Cases
- ft_stopword_file requires the ability to upload a file to the server. We may not be able to support this feature immediately but it is critical to support this as soon as possible.
- tmp_table_size cannot be more than max_heap_table_size or else the lesser of the two will be the size that is applied to system generated tmp tables. This only applies to tmp tables and not to user created heap/memory tables.
- innodb_log_file_size requires the following steps. Stop the service, backup and remove the old /var/lib/mysql/ib_logfileXX files, add the variable setting to the my.cnf, start the service and verify that the service started. If the service didn't come back up, stop the service, remove the newly generated files and replace them with the backed up files. If everything restarted successfully you don't need to keep the backed up files around, delete them.
- if you change ft_min_word_length or ft_max_word_length you must rebuild all indexes on all tables with full text indexes. This is done with REPAIR TABLE <tablename> QUICK;
- default_time_zone must be set as default_time_zone in the my.cnf file but must be set as time_zone in the mysql client.
