Edit MySQL / MariaDB Limits on Cloud Server

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

Preamble

MySQL is installed on the Cloud Server Therefore, resources are dedicated and are not shared with other clients.
There is only one instance of MySQL by Cloud Server.
The number and size of databases are not restricted. Your only limit is your cloud server's storage space and resources.
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 changed:

Name of Variable	Explanation	Value
`bulk_insert_buffer_size`	Buffer size for block 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 self-extension of the InnoDB table space	""
`declare_key_buffer`	Keypad size for MyISAM tables	""
`ft_max_word_len`	Maximum word length for full-text search (Full-Text)	Indefinite
`ft_min_word_len`	Minimum word length for full-text search (Full-Text)	3
`innodb_additional_mem_pool_size`	Additional memory pool size for InnoDB	""
`innodb_buffer_pool_size`	InnoDB buffer pool size, which stores data and indexes	""
`innodb_flush_log_at_trx_commit`	Writing frequency of InnoDB logs on disk	""
`innodb_large_prefix`	InnoDB Wide Prefix Extension Activation
`innodb_lock_wait_timeout`	Maximum waiting time for InnoDB locks	""
`innodb_log_buffer_size`	Size of InnoDB newspaper buffer	""
`innodb_log_file_size`	Size of InnoDB log files	""
`innodb_ft_min_token_size`	Minimum size of token for full-text search (Full-Text)	Indefinite
`innodb_ft_max_token_size`	Maximum size of token for full-text search (Full-Text)	Indefinite
`join_buffer_size`	Joint buffer size for queries	1M
`key_buffer_size`	Keypad size for MyISAM tables	4M
`lc_time_names`	Parameter for time and date format	Indefinite
`local_infile`	Enable or disable local file playback	0
`log_bin_enabled`	Activation or deactivation of the MySQL log binary record	True
`max_allowed_packet`	Maximum size of network packages allowed	Indefinite
`max_connect_errors`	Maximum number of connection errors before blocking	10
`max_connections`	Maximum number of simultaneous connections	Indefinite
`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 for sorting MyISAM tables	2G
`myisam_sort_buffer_size`	Size of the sorting buffer for MyISAM tables	16M
`myisamrecover`	MyISAM Recovery Options	myisam-recover-options
`query_cache_enabled`	Enable or disable query cache
`query_cache_limit`	Limit on the size of the results stored in the query cache	256K
`query_cache_size`	Total size of query cache	64M
`query_cache_type`	Query cache type	0
`read_buffer_size`	Reading buffer size for queries	2M
`read_rnd_buffer_size`	Size of random reading buffer for queries	2M
`seconds`
`table_open_cache`	Number of tables the server can keep open	256
`thread_cache_size`	Size of threads cache	1
`thread_concurrency`	Number of competing threads. By default, it is 0 (infinite)	0
`thread_stack`	Battery 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 MySQL/MariaDB behavior on a Cloud Server. Everything that is not defined is in principle at its default value.

Edit MySQL / MariaDB Limits

To configure HAProxy:

Click here in order to access the management of your product on the Manager Infomaniak (Need help?).
Click directly on the nameallocated to the product concerned.
Click on MySQL/MariaDBin the left side menu.
Edit the required values.

Link to this FAQ:

Display all FAQs for this product