MySQL 8.0

How to Install and Configure MySQL 8.0 on Ubuntu 24.04 VPS with Low Memory Optimization

Philip Jensen

— 2 min read

Introduction

At ByteHosting, we understand that running a MySQL database efficiently on a VPS with limited resources can be challenging. If you're planning to install MySQL 8.0 on Ubuntu 24.04 VPS with only 1GB of RAM, optimizing its configuration is essential to ensure smooth performance without overloading your server. In this guide, we’ll walk you through a practical, step-by-step process to install and configure MySQL 8.0 tailored for low-memory environments.

Prerequisites: VPS Setup and System Update

Before we begin, ensure your VPS is set up with Ubuntu 24.04. We recommend a clean installation to avoid conflicts. Once your server is ready, connect via SSH:

ssh your_username@your_server_ip

Next, update your system packages to the latest versions:

sudo apt update && sudo apt upgrade -y

This ensures your system is secure and compatible with the latest MySQL packages.

Installing MySQL 8.0 from Official Repositories

Ubuntu 24.04 includes MySQL 8.0 in its official repositories, making installation straightforward. To install MySQL server, run:

sudo apt install mysql-server -y

After installation, verify that MySQL is running:

systemctl status mysql

You should see an active status indicating MySQL is operational.

Configuring MySQL for Low-Memory Environments

Default MySQL configurations are not optimized for systems with only 1GB RAM. We need to tweak the settings to reduce memory usage. The main configuration file is located at /etc/mysql/mysql.conf.d/mysqld.cnf.

Adjusting Buffer Pool Size

The InnoDB buffer pool consumes the most memory. For low-memory servers, set it to a small value:

[mysqld]
innodb_buffer_pool_size=64M

Reducing Other Memory Usage

  • Set key_buffer_size (for MyISAM) to 16M:
  • Limit the query cache:
  • Disable or reduce the size of the tmp_table_size and max_heap_table_size:
tmp_table_size=32M
max_heap_table_size=32M
query_cache_size=16M
query_cache_type=1
key_buffer_size=16M

Apply these changes by editing the configuration file:

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

After editing, restart MySQL to apply the new settings:

sudo systemctl restart mysql

Securing MySQL Installation

Security is crucial, especially on a public-facing server. Run the built-in security script:

sudo mysql_secure_installation

This script will prompt you to set a root password, remove anonymous users, disallow root login remotely, and remove test databases. Follow the prompts to enhance your MySQL security.

Verifying MySQL Operation and Performance Tuning

To verify MySQL is working correctly, log in:

sudo mysql -u root -p

Run some basic commands to check status:

SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
SHOW STATUS LIKE 'Threads_connected';

Monitor server performance and adjust configurations as needed. Use tools like mysqltuner for recommendations:

sudo apt install mysqltuner -y
mysqltuner

Troubleshooting Common Issues with MySQL on Low RAM

  • MySQL fails to start: Check logs at /var/log/mysql/error.log for errors related to memory.
  • Slow performance: Ensure buffer sizes are not too large; monitor system resources.
  • High swap usage: Reduce buffer sizes further or consider upgrading RAM if possible.

Final Tips for Maintenance and Monitoring

Regularly update your system and MySQL to benefit from security patches and performance improvements. Use monitoring tools like htop or vnStat to keep an eye on resource usage. Backup your databases frequently to prevent data loss.

Conclusion

Installing and configuring MySQL 8.0 on Ubuntu 24.04 VPS with low memory requires careful tuning to balance performance and resource consumption. By following our guide, you can run a reliable MySQL server on a 1GB RAM VPS without overloading your system. At ByteHosting, we’re committed to providing affordable, high-quality VPS hosting solutions that support your projects — whether you’re deploying small databases or large-scale applications. If you need a cost-effective VPS plan, explore our offerings in Frankfurt, Germany, and get started today!

Read more