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 the Serveur Cloud; therefore, resources are dedicated and not shared with other clients.
There is only one instance of MySQL per Serveur Cloud.
The number and size of databases are not restricted. Your only limit is the storage space and resources of your Cloud Server.
If necessary, MongoDB allows you to manage huge amounts of data without compromising the flexibility and performance of your websites/applications.

Configure MySQL / MariaDB on Cloud Server

Here is the list of MySQL / MariaDB variables whose value can be modified:

Name	Description	Value
`bulk_insert_buffer_size`	Buffer size for bulk insert 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-extend 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 pool `InnoDB`, which stores the data and indexes	""
`innodb_flush_log_at_trx_commit`	Journal write frequency `InnoDB` to disk	""
`innodb_large_prefix`	Enable large prefix extension `InnoDB`
`innodb_lock_wait_timeout`	Maximum wait time for lock acquisition `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`	Size of the join buffer 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`	Enable or disable 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	Unlimited
`max_heap_table_size`	Maximum in-memory table size	8MB
`max_user_connections`	Maximum number of simultaneous connections per user	38
`myisam_max_sort_file_size`	Maximum size of the temporary file for sorting tables `MyISAM`	2GB
`myisam_sort_buffer_size`	Sort buffer size 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`	Query read buffer size	2M
`read_rnd_buffer_size`	Size of the random read buffer for queries	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`	Temporary directory path 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, at its default value.

Edit the MySQL / MariaDB limits

To configure HAProxy:

Click here to access the management of your product on the Manager Infomaniak (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