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. I only have 2 web sites with few visitor every day.
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.
The values suggested by mysqltuner.pl can be a bit excessive for a small VPS, especially since you only have two low-traffic websites. You might not need to increase everything as recommended. For example, join_buffer_size can often stay at 256K-512K, and tmp_table_size and max_heap_table_size may work fine at 32M-64M. Instead of blindly following the recommendations, check actual performance metrics like Created_tmp_disk_tables to see if temporary tables are hitting disk frequently. Similarly, adjusting innodb_log_buffer_size to around 8M-16M should be sufficient unless you see high transaction logs. Monitor performance after each change to ensure the adjustments are actually beneficial.
For a small VPS with minimal traffic, the suggested values may be excessive. Adjust them gradually based on real usage. Focus on join_buffer_size, tmp_table_size, and innodb_log_buffer_size, but monitor performance before making large changes.
