Configuring MySQL
How do I set a time zone?
A time zone is specified in terms of a UTC offset. Istanbul's, for instance, is '+03:00'
. Time zone names are not supported.
For more information, see the MySQL documentation
How do I set the SQL mode (sql_mode)?
Follow the instructions in Managing databases.
What value should I set for innodb_buffer_pool_size?
Recommended parameter range:
- A minimum of 25% of host RAM.
- A maximum of 85% of host RAM provided that at least 1 to 1.6 GB are left over for query execution, monitoring, and system processes.
How do I change character sets and collation rules (CHARACTER SET, COLLATE)?
Follow the instructions in Managing databases.
How do I configure other parameters?
Editable MySQL settings are listed in the documentation. You can use one of the available interfaces (management console, CLI etc.) to modify these. Follow the instructions in Updating a cluster.