Base de conhecimento

1000 perguntas frequentes, 500 tutoriais e vídeos explicativos. Aqui, você encontra apenas soluções!

Base de conhecimento Modify the MySQL / MariaDB configuration on Cloud Server

Modify the MySQL / MariaDB configuration on Cloud Server

Atualização 21/05/2026

This guide explains how to view and modify the configuration settings for MySQL / MariaDB on a Managed 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 Managed 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 Parameters

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

Name	Description	Value
`bulk_insert_buffer_size`	Size of the buffer 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 type 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 scheduled tasks to be executed 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 (stores 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`	Size of the `InnoDB` log buffer	""
`innodb_log_file_size`	Size of the `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`	Enable or disable local file reading	0
`log_bin_enabled`	Enable or disable 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 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`	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`	Thread stack size	256K
`timeouts`	Timeout values (`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 will remain at its default value.

Modify MySQL / MariaDB parameters

To modify your instance configuration:

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

Link para esta FAQ: https://faq.infomaniak.com/1813

Esta seção de perguntas frequentes foi útil?

YesNoEmpty