Knowledge base

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

Knowledge base Modify the MySQL/MariaDB configuration on your Cloud Server

Modify the MySQL/MariaDB configuration on your Cloud Server

Update 08/13/2026

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

Introduction

MySQL is installed on a Dedicated Cloud Server: resources are not shared with other customers.
Only one MySQL or MariaDB instance 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 parameters

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 you to explicitly declare default values for timestamp columns.	""
`declare_innodb_autoextend_increment`	Increment used for automatic extension of the InnoDB tablespace	""
`declare_key_buffer`	Key buffer size for `MyISAM` tables	""
`event_scheduler`	Enable or disable the `MariaDB` event scheduler (allows you to run 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 `InnoDB` buffer pool (storage of data and indexes)	""
`innodb_flush_log_at_trx_commit`	Frequency of writing `InnoDB` logs to disk	""
`innodb_large_prefix`	Enable large prefix for `InnoDB` indexes
`innodb_lock_wait_timeout`	Maximum wait time for obtaining `InnoDB` locks	""
`innodb_log_buffer_size`	`InnoDB` log buffer size	""
`innodb_log_file_size`	Size of `InnoDB` log files	""
`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`	Join buffer size for queries	1M
`key_buffer_size`	Key buffer size for `MyISAM` tables	4M
`lc_time_names`	Defines the language used for the format of month and day names	Undefined
`local_infile`	Enables or disables local file loading	0
`log_bin_enabled`	Enables or disables binary transaction logging	true
`max_allowed_packet`	Maximum size of allowed network packets	Unlimited
`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 tables in memory	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 sorting `MyISAM` tables	2G
`myisam_sort_buffer_size`	Sort buffer size for `MyISAM` tables	16M
`myisamrecover`	Automatic recovery options for `MyISAM` tables	myisam-recover-options
`query_cache_enabled`	Enable or disable the query cache
`query_cache_limit`	Size limit for results stored in the query cache	256K
`query_cache_size`	Total size of the query cache	64M
`query_cache_type`	Cache type used for requests	0
`read_buffer_size`	Sequential read buffer size	2M
`read_rnd_buffer_size`	Random read buffer size	2M
`table_open_cache`	Number of tables the server can keep open simultaneously	256
`thread_cache_size`	Thread cache size	1
`thread_concurrency`	Number of concurrent threads (0 = unlimited)	0
`thread_stack`	Stack size per thread	256K
`timeouts`	Wait timeouts (`wait_timeout` and `interactive_timeout`)	30
`tmp_table_size`	Maximum size of temporary tables in memory	8M
`tmpdir`	Temporary directory used for temporary files	"/home/nfs-clients/.mysql_tmp"

Any undefined parameter will retain its default value.

Modify MySQL / MariaDB parameters

To modify your instance's configuration:

Click here to access your product's management interface in the Infomaniak Manager (need help?).
Select the name of the relevant Cloud Server.
Click on MySQL / MariaDB in the sidebar menu.
Edit the desired settings and then save your changes.

Link to this FAQ: https://faq.infomaniak.com/1813

Has this FAQ been helpful?

YesNoEmpty