Configuring MySQL
How do I set a time zone?
A time zone is specified in terms of a UTC offset. Moscow'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 steps described in Managing databases.
What value should I set for innodb_buffer_pool_size?
Recommended parameter range:
- Minimum 25% of host RAM.
- Maximum 75% of host RAM provided that at least 1 to 1.6 GB are free for running queries, monitoring, and system processes.
How do I disable InnoDB strict mode?
By default, InnoDB strict mode is enabled. If you disable this mode using MySQL tools, the following error will occur:
Mysql query error: (1227) Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation (400)
To disable strict mode, change the innodb_strict_mode
parameter value via the Yandex Cloud interfaces. You should also make sure that your configuration contains no command that disables strict mode, such as $connection–>queryExecute("SET innodb_strict_mode=0");
.
How do I change character sets and collation rules (CHARACTER SET, COLLATE)?
Follow the steps described 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, API, or Terraform) to modify these. Follow the instructions in Updating a cluster.