how to configure mariadb innodb for maximum memory saving? 1gb of ram

al1r4d

I have 1 GB of RAM on my server. Currently running Wordpress and the other projects.

How do I configure MariaDB and InnoDB for maximum memory savings? Let's pretend I only have 256 MB of RAM.

I know memory is cheap, and I can enlarge the capacity if I want. But optimizing a server is my hobby, and I want to get maximum performance.

This is my.cnf

[mysqld]
performance_schema = off
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
query_cache_limit = 256K
query_cache_size = 0
thread_concurrency = 2
innodb_file_per_table = 1

Thank you

Microcharon

Limit some value like

sort_buffer_size = 32K
read_buffer_size=32K
read_rnd_buffer_size=32K

No need to optimize server anymore, WordPress itself may take much RAM if more guests visit your site.

dahartigan

Use less memory or add more memory

al1r4d

@Microcharon said:
Limit some value like

sort_buffer_size = 32K
read_buffer_size=32K
read_rnd_buffer_size=32K

No need to optimize server anymore, WordPress itself may take much RAM if more guests visit your site.

how many visitors are present at the same time with that specification?
25 visitor sper second?

al1r4d

@dahartigan said:
Use less memory or add more memory

Hehe

al1r4d

up

Daniel15

Disabling the query cache (query_cache_size = 0) is going to hurt performance quite a bit.

Your best bet is to reduce the number of times you need to hit the database. For example, use Nginx FastCGI cache, WordPress super cache (stores cache as HTML files on disk that Nginx can serve directly), etc. Failing that, switch to SQLite.

al1r4d

@Daniel15 said:
Disabling the query cache (query_cache_size = 0) is going to hurt performance quite a bit.

Your best bet is to reduce the number of times you need to hit the database. For example, use Nginx FastCGI cache, WordPress super cache (stores cache as HTML files on disk that Nginx can serve directly), etc. Failing that, switch to SQLite.

Thank you, Sir

fazar

@RustyKumar this thread might useful for you.

al1r4d

@fazar said:
@RustyKumar this thread might useful for you.

oke bang