Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Modify MySQL / MariaDB limits
This guide explains how to modify MySQL/MariaDB limits on a Managed Cloud Server.
Here is a list of MySQL/MariaDB variables that can be modified:
Variable Name | Explanation | 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-extension of InnoDB tablespace | "" |
declare_key_buffer | Key buffer size for MyISAM tables | "" |
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, which stores data and indexes | "" |
innodb_flush_log_at_trx_commit | Frequency of writing InnoDB logs to disk | "" |
innodb_large_prefix | Enabling of the InnoDB large prefix extension | |
innodb_lock_wait_timeout | Maximum waiting time for obtaining InnoDB locks | "" |
innodb_log_buffer_size | Size of the 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 the time and date format | Undefined |
local_infile | Enabling or disabling local file reading | 0 |
log_bin_enabled | Enabling or disabling binary logging of MySQL logs | 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 for sorting MyISAM tables | 2G |
myisam_sort_buffer_size | Sort buffer size for MyISAM tables | 16M |
myisamrecover | MyISAM recovery options | myisam-recover-options |
query_cache_enabled | Enabling or disabling the query cache | |
query_cache_limit | Size limit of results stored in the query cache | 256K |
query_cache_size | Total size of the query cache | 64M |
query_cache_type | Type of query cache | 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 | Stack size per thread | 256K |
timeouts | Timeouts (wait_timeout and interactive_timeout) | 30 |
tmp_table_size | Maximum size of temporary in-memory tables | 8M |
tmpdir | Path of the temporary directory for temporary files | "/home/nfs-clients/.mysql_tmp" |
These variables allow configuring various aspects of MySQL/MariaDB behavior on a Cloud Server. Anything not defined defaults to its default value.
Editing 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 using the left side menu for example)
- choose Cloud Server (under the Web & Domain universe)
- click on the name of the concerned object in the table that appears
- click on MySQL/MariaDB in the left side menu
- edit the necessary values
Link to this FAQ: