Trove/Configurations/mysql-options

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.

Some variables require creating a new mysql connection so that they will be applied.

Special Cases
(todo) These will be implemented after initial work is done to create a configuration.


 * 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 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.