burger
infomaniak
infomaniak
cloud-computing-logo
Cloud Computing
web-domain-logo
Web & Domains
event-marketing-logo
Events & Marketing
  • Our products
    • Collaborative tools icon chevron
    • Web & Domains icon chevron
    • Cloud Computing icon chevron
    • Events & Marketing icon chevron
    • Streaming icon chevron

      ksuiteCollaborative suite

      Discover the collaborative suite β†’ Discover β†’
    • kSuite Professional email, sovereign cloud and AI for sustainable performance
    • kSuite The suite for secure communication, storage and sharing
    • kdrive
      kDrive Store, collaborate and share your files
    • mail service
      Mail Service Create your email addresses with your domain
    • kChat
      kChat Communicate live with your teams
    • kmeet
      kMeet Organise your meetings online in complete security
    • swisstransfer
      SwissTransfer Send your files up to 50 GB free of charge.
    • kpaste
      kPaste Share and encrypt your sensitive information
    • ksuite
      Custom Brand Control the brand image of your products
    • kChat
      Chk Link reducer & QR code generator
      Find the web hosting solution you need
    • Domain name
      Domain name Reserve your domain name at the best price
    • Site Creator
      Site Creator Create your website with ease
    • web hosting
      Web Hosting Create your website with over 100 CMS
    • web hosting
      Wordpress Hosting Create your WordPress website easily
    • Cloud Server
      Cloud Server Power up your sites with guaranteed resources
    • Node.js Hosting Create a dynamic, interactive site with Node.js
    • SSL Certificat
      SSL certificates Secure your websites with an EV or DV certificate
    • Options
    • Domain privacy
      Domain Privacy Protect your domains’ private data
    • DNS Fast Anycast
      FastAnycast DNS Speed up your site access times
    • Dyn DNS
      DynDNS Access your devices remotely
    • Dyn DNS
      Renewal Warranty Secure your domains against loss and theft
      Find the right Cloud Computing solution

      Cloud services

    • public cloud
      Public Cloud (IaaS) Create your projects in a high-end, ultra-competitive Cloud
    • Cloud Server
      VPS Cloud Create a Windows / Linux server
    • Kubernetes service Deploy your containerised apps on a large scale.
    • VPS Lite
      VPS Lite Create a Windows/Linux server at a low cost
    • Database Service Manage your databases with a managed solution
    • jelastic cloud
      Jelastic Cloud (PaaS) Create your own customised environments
    • Other services

    • llm api
      AI Tools Boost your productivity with our sovereign AI
    • swiss backup
      Swiss Backup Back up your devices in the Cloud
    • nas synology
      NAS Synology Rent a NAS in our secure data centers
    • High availibility
      Very High Availability Create a multi-data center infrastructure with customised SLAs
    • Housing
      Housing Install your servers in our data centers
    • Auth Add a privacy-friendly login method to your apps
      Infomaniak Events, the independent local events portal
      Online ticketing service with a wide choice of concerts, shows and events.
    • online shop
      Ticketing Create your ticketing service and sell tickets
    • kdrive
      Access Control Control access to your events with ease
    • kdrive
      Guest manager Automate your event invitations
    • kdrive
      Newsletter Send your newsletters at competitive prices
    • Streaming radio
      Streaming radio Create and broadcast your own live radio station online
    • streaming video
      Video-Streaming Create and broadcast live events and TV online
    • VOD and AOD
      VOD & AOD service Host and broadcast your recordings without limits
  • Resources
    documentation icon Documentation
    Guides & tutorials
    API documentation
    special offers icon Special offers
    Get started for free
    Student programme
    Become an affiliate
    partner program icon Partner programme
    Find a partner
    Become a partner
    Infomaniak Academy
    support icon Support & contact
    Contact Support
    Premium support - 24/7
    Contact our sales department
    Hiring an expert
    Migrate to Infomaniak
  • About us
    forest
    icon Ecological commitment
    We pollute. But we are taking action to reduce the footprint of our services and infrastructure
    Discover our commitment β†’
    icon About Infomaniak
    Our vision, our values
    Our teams
    Infomaniak is recruiting
    Press and communication
    Blog and news
    icon Security
    Data confidentiality
    Bug Bounty Programme
  • Get started for free
    Sign in
  • search-icon
    close-icon
      icon

      Would your needs exceed our solutions? To find out, contact us so that we can advise you personally.

      Our flagship products:
  • search-icon
  • Get started for free
    Sign in
Price Price
Knowledge base

1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!

Knowledge base Modify MySQL / MariaDB limits on Cloud Server

    Modify 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 a Dedicated Cloud Server; resources are not shared.
    • There is only one instance of MySQL per Cloud Server.
    • The number and size of databases are limited only by the disk space and server resources.
    • For large volumes of data, MongoDB is recommended.

     

    Configure MySQL / MariaDB on Cloud Server

    List of modifiable MySQL / MariaDB variables:

    NameDescriptionValue
    bulk_insert_buffer_sizeBuffer size for bulk insert operations8M
    default_charset  
    declare_explicit_defaults_for_timestampOption to explicitly declare default values for timestamp type columns""
    declare_innodb_autoextend_incrementIncrement for the auto-expansion of the InnoDB table space""
    declare_key_bufferKey buffer size for tables MyISAM""
    ft_max_word_lenMaximum word length for full-text searchUndefined
    ft_min_word_lenMinimum word length for full-text search3
    innodb_additional_mem_pool_sizeSize of the additional memory pool for InnoDB""
    innodb_buffer_pool_sizeSize of the buffer memory pool InnoDB, which stores data and indexes""
    innodb_flush_log_at_trx_commitFrequency of writing logs InnoDB to disk""
    innodb_large_prefixActivation of the wide prefix extension InnoDB 
    innodb_lock_wait_timeoutMaximum wait time for obtaining locks InnoDB""
    innodb_log_buffer_sizeSize of the log buffer InnoDB""
    innodb_log_file_sizeSize of log files InnoDB""
    innodb_ft_min_token_sizeMinimum token size for full-text searchUndefined
    innodb_ft_max_token_sizeMaximum token size for full-text searchUndefined
    join_buffer_sizeSize of the join buffer for queries1M
    key_buffer_sizeKey buffer size for tables MyISAM4M
    lc_time_namesParameter for the date and time formatUndefined
    local_infileEnable or disable local file reading0
    log_bin_enabledEnable or disable binary logging of logs MySQLtrue
    max_allowed_packetMaximum size of allowed network packetsUndefined
    max_connect_errorsMaximum number of login errors before blocking10
    max_connectionsMaximum number of simultaneous connectionsUndefined
    max_heap_table_sizeMaximum size of in-memory tables8M
    max_user_connectionsMaximum number of simultaneous connections per user38
    myisam_max_sort_file_sizeMaximum size of the temporary file for sorting tables MyISAM2G
    myisam_sort_buffer_sizeSize of the sort buffer for tables MyISAM16M
    myisamrecoverRecovery options MyISAMmyisam-recover-options
    query_cache_enabledEnable or disable query cache 
    query_cache_limitSize limit of results stored in the query cache256K
    query_cache_sizeTotal size of the query cache64M
    query_cache_typeType of cache for queries0
    read_buffer_sizeSize of the read buffer for queries2M
    read_rnd_buffer_sizeSize of the random read buffer for queries2M
    seconds  
    table_open_cacheNumber of tables the server can keep open256
    thread_cache_sizeSize of the thread cache1
    thread_concurrencyNumber of concurrent threads. By default, this is 0 (infinite)0
    thread_stackStack size per thread256K
    timeoutsTimeouts (wait_timeout and interactive_timeout)30
    tmp_table_sizeMaximum size of in-memory temporary tables8M
    tmpdirPath of the temporary directory for temporary files"/home/nfs-clients/.mysql_tmp"

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

    Anything not defined is by default at its default value.

     

    Edit MySQL / MariaDB limits

    To configure HAProxy:

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


    Link to this FAQ:
    Has this FAQ been helpful?
    Thank you for your feedback. Improve this FAQ?
    Please do not ask any questions through this form, it is only used to improve our FAQ.
    Please use our contact form for any question.
    Your message has been sent. Thank you for suggesting an improvement to this FAQ.
    Display all FAQs for this product
    logo infomaniak
    Prices do not include VAT
    facebook
    twitter
    linkedin
    instagram

    Infomaniak

    About Infomaniak The team Infomaniak is recruiting Press space Infomaniak blog All certificates Products and offers Clients' opinions

    Support

    Assistance 7/7 FAQ and guides Premium Support Sales contact API REST Report abuse WHOIS Public Cloud status Service status

    Partnerships

    Become a reseller Affiliate programme Directory of partners Requests for quotes Infomaniak Academy

    Ecology

    Green hosting Certificates & awards

    Follow our development

    The email entered is invalid
    earth icon
    • EN
      • EN
      • DE
      • ES
      • FR
      • IT
    Β©2025 Infomaniak - Legal documents - Legal notice - Data Protection - Privacy Policy - Site map - Manage your cookies
    bcorp-logo
    icann-logo
    swiss
    new-iso
    swiss-hosting
    logo infomaniak
    Prices do not include VAT

    Infomaniak

    About Infomaniak The team Infomaniak is recruiting Press and media Infomaniak blog All certificates Products and offers Clients' opinions

    Support

    Assistance 7/7 FAQ and guides Premium Support offer Sales contact API REST Report abuse WHOIS Public Cloud status Service status

    Partnerships

    Become a reseller Affiliate programme Directory of partners Requests for quotes Infomaniak Academy

    Ecology

    Green hosting Certificates & awards

    Follow our development

    The email entered is invalid
    bcorp-logo
    icann-logo
    swiss
    new-iso
    swiss-hosting

    facebook
    twitter
    linkedin
    instagram
    Β©2025 Infomaniak
    Contracts - Legal notice - Data Protection - Privacy Policy - Site map - Manage your cookies

    Managers

    earth icon
    • EN
      • EN
      • DE
      • ES
      • FR
      • IT
    Your browser is outdated, security and browsability are no longer guaranteed. We recommend that you update it as soon as possible by clicking here.