mysqltuner.pl suggestion problem

Discussion in 'Server Operation' started by concept21, Feb 12, 2025.

  1. concept21

    concept21 Active Member

    Hello Linux Experts,
    My VPS is running ISPConfig 3.2 on Ubuntu 24.04. It has 8GB RAM and 80GB SSD.
    I ran mysqltuner.pl to check the mariadb health. It reported:
    Are the suggested memories accurate? They seem too much for a mini server. Please advise. :oops:
    I only have 2 web sites with few visitor every day.
     
  2. remkoh

    remkoh Active Member HowtoForge Supporter

    Suggestions are probably based on available resources and database size among other things.

    8GB RAM is quit the overkill for a simple 2 site webserver with only a few visitors.
    One of my own webservers has only 2 GB RAM and one of the websites on it is doing thousends of visitors and an avarage of 30GB traffic a day. It runs just fine. Though the database runs on a separate server.
     
  3. concept21

    concept21 Active Member

    Yes, I had better refuse its suggestion and keep these 16M or 32M
    tmp_table_size
    max_heap_table_size
     
  4. concept21

    concept21 Active Member

    Hello wayose,
    Thank you. Let me try. :rolleyes:
     
  5. concept21

    concept21 Active Member

    Hello Friend,
    Could you suggest values for them? :rolleyes:
    key_buffer_size
    innodb_log_file_size
     

Share This Page