Modify MySQL / MariaDB limits on Cloud Server

This guide explains how to modify the limits of MySQL / MariaDB on a Serveur Cloud.

Preamble

MySQL is installed on a dedicated Cloud Server; resources are not shared.
Only one instance of MySQL is present per Cloud Server.
The number and size of the databases are only limited by the disk space and the server's resources.
For large volumes of data, MongoDB is recommended.

Configure MySQL / MariaDB on Cloud Server

List of modifiable MySQL / MariaDB variables:

Name	Description	Value
`bulk_insert_buffer_size`	Buffer size for bulk insertion operations	8M
`default_charset`
`declare_explicit_defaults_for_timestamp`	Option to explicitly declare default values for timestamp type columns	""
`declare_innodb_autoextend_increment`	Increment for the auto-extending of the InnoDB table space	""
`declare_key_buffer`	Size of the key buffer for tables `MyISAM`	""
`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`, which stores the data and indexes	""
`innodb_flush_log_at_trx_commit`	Journal write frequency `InnoDB` on disk	""
`innodb_large_prefix`	Enable wide prefix extension `InnoDB`
`innodb_lock_wait_timeout`	Maximum wait time for acquiring locks `InnoDB`	""
`innodb_log_buffer_size`	Journal buffer size `InnoDB`	""
`innodb_log_file_size`	Size of the journal 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`	Join buffer size for queries	1M
`key_buffer_size`	Size of the key buffer for tables `MyISAM`	4M
`lc_time_names`	Parameter for the time and date format	Undefined
`local_infile`	Enabling or disabling local file reading	0
`log_bin_enabled`	Enabling or disabling binary logging `MySQL`	true
`max_allowed_packet`	Maximum allowed network packet size	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 for table sorting `MyISAM`	2G
`myisam_sort_buffer_size`	Size of the sort buffer for tables `MyISAM`	16M
`myisamrecover`	Recovery options `MyISAM`	myisam-recover-options
`query_cache_enabled`	Enabling or disabling the query cache
`query_cache_limit`	Limit on the size of results stored in the query cache	256K
`query_cache_size`	Total size of the query cache	64M
`query_cache_type`	Query cache type	0
`read_buffer_size`	Size of the read buffer for queries	2M
`read_rnd_buffer_size`	Size of the random read buffer for requests	2M
`seconds`
`table_open_cache`	Number of tables that the server can keep open	256
`thread_cache_size`	Thread cache size	1
`thread_concurrency`	Number of concurrent threads. By default, this is 0 (infinite)	0
`thread_stack`	Stack size per thread	256K
`timeouts`	Timeouts (`wait_timeout` and `interactive_timeout`)	30
`tmp_table_size`	Maximum size of temporary tables in memory	8M
`tmpdir`	Path to the temporary directory for temporary files	"/home/nfs-clients/.mysql_tmp

These variables allow you to configure various aspects of the behavior of MySQL/MariaDB on a Cloud Server.

Anything that is not defined is, by default, set to its default value.

Edit the MySQL / MariaDB limits

To configure HAProxy:

Click here to access the management of your product on the Infomaniak Manager (need help?).
Click directly on the name assigned to the relevant product.
Click on MySQL/MariaDB in the left sidebar.
Edit the necessary values.

Link to this FAQ:

Display all FAQs for this product