MariaDB

How to Install and Configure MariaDB 10.11 for Optimal Performance on a 1GB RAM Ubuntu VPS

Philip Jensen

— 3 min read

Introduction

At our company, we understand the importance of a reliable and efficient database system, especially when operating on a VPS with limited resources like 1GB of RAM. MariaDB 10.11 is a popular choice for many developers and businesses due to its performance and compatibility. However, to truly optimize MariaDB 10.11 performance for a 1GB RAM VPS, proper configuration and tuning are essential. In this guide, we’ll walk you through the steps to set up, configure, and optimize MariaDB 10.11 on your Ubuntu VPS for optimal performance and stability.

1. Prerequisites: Setting up your Ubuntu VPS and installing MariaDB 10.11

Before diving into optimization, ensure your Ubuntu VPS is properly set up. We recommend using a clean Ubuntu 22.04 LTS installation for stability and compatibility. Once your server is ready, follow these steps to install MariaDB 10.11:

sudo apt update
sudo apt install software-properties-common
sudo add-apt-repository 'ppa:ondrej/mariadb-10.11'
sudo apt update
sudo apt install mariadb-server

After installation, secure your MariaDB server by running:

sudo mysql_secure_installation

This will help you set a root password, remove anonymous users, and disable remote root login, enhancing security on your minimal VPS.

2. Configuring MariaDB for low-memory usage: key settings and parameters

MariaDB’s configuration file is located at /etc/mysql/mariadb.conf.d/50-server.cnf. To optimize for a 1GB RAM VPS, we need to adjust several key parameters to reduce memory consumption while maintaining performance.

Basic tuning principles:

  • Limit buffer sizes to prevent excessive memory usage
  • Disable or reduce cache sizes that are unnecessary for small environments
  • Enable performance schema only if needed, as it consumes additional resources

Sample configuration adjustments:

[mysqld]
# Reduce the InnoDB buffer pool size to fit within available RAM
innodb_buffer_pool_size = 128M
# Limit key buffer size
key_buffer_size = 16M
# Reduce query cache size
query_cache_size = 16M
# Set maximum allowed packet size
max_allowed_packet = 16M
# Disable performance schema for low-resource environments
performance_schema = OFF
# Limit thread cache size
thread_cache_size = 8

After editing, restart MariaDB to apply changes:

sudo systemctl restart mariadb

3. Optimizing query cache and buffer sizes for 1GB RAM

Properly tuning cache and buffer sizes is crucial for optimizing MariaDB 10.11 performance on a low-memory VPS. Here are some practical tips:

Query Cache

While query cache can improve read performance, it can also become a bottleneck if not configured properly. For a 1GB RAM VPS, we recommend setting a modest cache size:

query_cache_size = 16M
query_cache_type = 1  # Enable query cache

InnoDB Buffer Pool

This is the most important setting for InnoDB storage engine. Allocate about 20-25% of your total RAM, but not exceeding 128MB for a 1GB system:

innodb_buffer_pool_size = 128M

Other buffers

  • Sort buffer size: sort_buffer_size = 1M
  • Join buffer size: join_buffer_size = 1M
  • Read buffer size: read_buffer_size = 1M

Adjust these values based on your workload, but keep total memory usage in check.

4. Implementing security best practices for MariaDB on a minimal VPS

Security is vital, even on a minimal VPS. Here are some best practices:

  • Use strong, unique passwords for your MariaDB root and user accounts
  • Restrict remote access by binding MariaDB to localhost in my.cnf
  • Remove anonymous users and test databases:
  • Regularly update MariaDB to benefit from security patches and improvements
DELETE FROM mysql.user WHERE User='';
DROP DATABASE IF EXISTS test;
FLUSH PRIVILEGES;
[mysqld]
bind-address = 127.0.0.1

5. Verifying MariaDB performance and stability after tuning

Once you’ve applied your configuration changes, it’s important to verify that MariaDB is performing well and remains stable. Use tools like mysqltuner to analyze your setup:

sudo apt install mysqltuner.pl
perl mysqltuner.pl

This script provides recommendations based on your current configuration and workload. Monitor server logs and resource usage with htop or top to ensure MariaDB isn’t consuming excessive resources.

6. Troubleshooting common MariaDB performance issues on low-resource VPSs

If you encounter performance issues, consider the following troubleshooting steps:

  1. Check for slow queries using SHOW PROCESSLIST; and optimize them
  2. Ensure your buffer sizes are not set too high, causing memory swapping
  3. Review server logs for errors or warnings
  4. Disable unnecessary features or plugins that consume resources
  5. Upgrade your VPS plan if your workload outgrows the current resources

By carefully tuning and monitoring your MariaDB 10.11 setup, you can achieve reliable and efficient database performance even on a 1GB RAM VPS.

Conclusion

Optimizing MariaDB 10.11 for a 1GB RAM Ubuntu VPS requires a balanced approach—reducing memory usage while maintaining performance. By following our configuration tips, adjusting cache sizes, and implementing security best practices, you can ensure your database runs smoothly and securely. Remember, continuous monitoring and fine-tuning are key to long-term success. If you’re looking for a reliable VPS hosting environment to support your MariaDB deployment, our plans are designed to provide the right balance of performance and affordability.

Read more