Modify MySQL / MariaDB limits on Cloud Server

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

Introduction

MySQL is installed on the Cloud Server. Therefore, the resources are dedicated and not shared with other clients. There is only one instance of MySQL per Cloud Server.

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 sites/applications.

Configure MySQL / MariaDB on Cloud Server

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

Variable Name	Explanation	Value
`bulk_insert_buffer_size`	Size of buffer for bulk insert operations	8M
`default_charset`
`declare_explicit_defaults_for_timestamp`	Option to explicitly declare default values for timestamp columns	""
`declare_innodb_autoextend_increment`	Increment for InnoDB table space auto-extension	""
`declare_key_buffer`	Key buffer size for MyISAM tables	""
`ft_max_word_len`	Maximum length of words for Full-Text search	Undefined
`ft_min_word_len`	Minimum length of words for Full-Text search	3
`innodb_additional_mem_pool_size`	Additional memory pool size for InnoDB	""
`innodb_buffer_pool_size`	Size of InnoDB buffer pool, which stores data and indexes	""
`innodb_flush_log_at_trx_commit`	Frequency of writing InnoDB logs to disk	""
`innodb_large_prefix`	Enable InnoDB large prefix extension
`innodb_lock_wait_timeout`	Maximum wait time for obtaining InnoDB locks	""
`innodb_log_buffer_size`	Size of InnoDB log buffer	""
`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`	Parameter for time and date format	Undefined
`local_infile`	Enable or disable local file reading	0
`log_bin_enabled`	Enable or disable MySQL binary logging	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 temporary file for MyISAM table sorting	2G
`myisam_sort_buffer_size`	Sort buffer size for MyISAM tables	16M
`myisamrecover`	MyISAM recovery options	myisam-recover-options
`query_cache_enabled`	Enable or disable query cache
`query_cache_limit`	Limit of size of results stored in query cache	256K
`query_cache_size`	Total size of query cache	64M
`query_cache_type`	Query cache type	0
`read_buffer_size`	Read buffer size for queries	2M
`read_rnd_buffer_size`	Random read buffer size for queries	2M
`seconds`
`table_open_cache`	Number of tables the server can keep open	256
`thread_cache_size`	Thread cache size	1
`thread_concurrency`	Number of concurrent threads. By default, it's 0 (infinite)	0
`thread_stack`	Thread stack size	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 MySQL/MariaDB behavior on a Cloud Server. Everything not defined is typically at its default value.

Edit MySQL / MariaDB Limits

To configure HAProxy:

Log in to the Infomaniak Manager (manager.infomaniak.com) from a web browser like Brave or Firefox
Click on the icon at the top right of the interface (or navigate through the left sidebar menu, for example)
Choose Cloud Server (Web & Domain universe)
Click on the name of the relevant object in the displayed table
Click on MySQL/MariaDB in the left sidebar menu
Edit the necessary values

Link to this FAQ:

Display all FAQs for this product