Knowledge base

1000 FAQs, 500 tutorials and instructional videos. Here, there are only solutions!

Knowledge base Modify MySQL / MariaDB configuration on Cloud Server

Modify MySQL / MariaDB configuration on Cloud Server

This guide explains how to view and modify the configuration settings MySQL / MariaDB of a Cloud Server. These settings allow you to adjust the behavior, performance, and some features of the service, including resource limits.

Preamble

MySQL is installed on a Dedicated Cloud Server: resources are not shared with other customers.
Only one instance of MySQL or MariaDB is present per Cloud Server.
The number and size of databases depend solely on the available disk space and resources.
For very large volumes of non-relational data, MongoDB is recommended.

Configurable MySQL / MariaDB settings

The following list presents the main variables that you can customize in your MySQL / MariaDB instance:

Name	Description	Value
`bulk_insert_buffer_size`	Buffer size for bulk insert operations	8M
`default_charset`	Defines the default character set for the database	utf8mb4
`declare_explicit_defaults_for_timestamp`	Allows explicitly declaring default values for timestamp-type columns	""
`declare_innodb_autoextend_increment`	Increment used for the automatic extension of the InnoDB table space	""
`declare_key_buffer`	Key buffer size for tables `MyISAM`	""
`event_scheduler`	Enable or disable the event scheduler `MariaDB` (allows executing scheduled tasks on the server side)	OFF
`ft_max_word_len`	Maximum word length for full-text search	Undefined
`ft_min_word_len`	Minimum word length for full-text search	3
`innodb_additional_mem_pool_size`	Size of the additional memory pool for `InnoDB`	""
`innodb_buffer_pool_size`	Size of the buffer memory pool `InnoDB` (data and index storage)	""
`innodb_flush_log_at_trx_commit`	Frequency of writing logs `InnoDB` to disk	""
`innodb_large_prefix`	Enable the large prefix for indexes `InnoDB`
`innodb_lock_wait_timeout`	Maximum wait time for obtaining locks `InnoDB`	""
`innodb_log_buffer_size`	Size of the log buffer `InnoDB`	""
`innodb_log_file_size`	Size of the log files `InnoDB`	""
`innodb_ft_min_token_size`	Minimum token size for full-text search	Undefined
`innodb_ft_max_token_size`	Maximum token size for full-text search	Undefined
`join_buffer_size`	Size of the join buffer for queries	1M
`key_buffer_size`	Key buffer size for tables `MyISAM`	4M
`lc_time_names`	Defines the language used for the format of month and day names	Undefined
`local_infile`	Enables or disables local file reading	0
`log_bin_enabled`	Enables or disables binary logging of transactions	true
`max_allowed_packet`	Maximum size of allowed network packets	Undefined
`max_connect_errors`	Maximum number of connection errors before blocking	10
`max_connections`	Maximum number of simultaneous connections	Undefined
`max_heap_table_size`	Maximum size of in-memory tables	8M
`max_user_connections`	Maximum number of simultaneous connections per user	38
`myisam_max_sort_file_size`	Maximum size of the temporary file used for table sorting `MyISAM`	2G
`myisam_sort_buffer_size`	Size of the sort buffer for tables `MyISAM`	16M
`myisamrecover`	Automatic recovery options for tables `MyISAM`	myisam-recover-options
`query_cache_enabled`	Enable or disable the query cache
`query_cache_limit`	Size limit of results stored in the query cache	256K
`query_cache_size`	Total size of the query cache	64M
`query_cache_type`	Type of cache used for queries	0
`read_buffer_size`	Size of the sequential read buffer	2M
`read_rnd_buffer_size`	Size of the random read buffer	2M
`table_open_cache`	Number of tables the server can keep open simultaneously	256
`thread_cache_size`	Size of the thread cache	1
`thread_concurrency`	Number of concurrent threads (0 = unlimited)	0
`thread_stack`	Stack size per thread	256K
`timeouts`	Timeouts (`wait_timeout` and `interactive_timeout`)	30
`tmp_table_size`	Maximum size of in-memory temporary tables	8M
`tmpdir`	Temporary directory used for temporary files	"/home/nfs-clients/.mysql_tmp"

Any undefined parameter remains at its default value.

Modify MySQL / MariaDB parameters

To modify the configuration of your instance:

Click here to access the management of your product in the Infomaniak Manager (need help?).
Select the name of the Cloud Server concerned.
Click on MySQL / MariaDB in the sidebar menu.
Edit the desired parameters and then validate your changes.

Link to this FAQ:

https://faq.infomaniak.com/1813

Has this FAQ been helpful?

YesNoEmpty