High Memory | High Ram

Hi, I installed CyberPanel and currently doesn’t have any web application now. But the RAM usage is too high. I check to ram usage using htop, I found that the Mysql process to high.

How to solve this?

1 Like

Welcome @unique_id00 Happy you are here

Run nano /etc/my.cnf and set

innodb-buffer-pool-size = 500M

Check this out MariaDB / MySQL Tweaks As Default & Option

Basically run nano /etc/my.cnf use the keyboard shortcut CTRL+W to search for skip-name-resolve and comment it out. Restart mariadb systemctl restart mysqld

Thank you for your help.
I found the my.cnf on /etc/mysql/. Is it the same thing?
image

Here the my.cnf file

You did not read this MariaDB / MySQL Tweaks As Default & Option

Read it then add the following considering said reference is not formatted for easy read:

[mysqld]
user= mysql
pid-file= /var/lib/mysql/mysql.pid
socket= /var/lib/mysql/mysql.sock
port= 3306
datadir= /var/lib/mysql

open_files_limit=50000
max_allowed_packet=268435456

skip-name-resolve=1
innodb_buffer_pool_size=1G

innodb_log_file_size=256M
innodb_flush_method=O_DIRECT
innodb_io_capacity=1000
innodb_old_blocks_time=1000
innodb_open_files=5000

key_buffer_size=16M
read_buffer_size=256K
read_rnd_buffer_size=256K
query_cache_size=256M
query_cache_limit=5M
join_buffer_size=4M
sort_buffer_size=4M
max_heap_table_size=64M
tmp_table_size=64M
table_open_cache=4500
table_definition_cache=4000
thread_cache_size=50

Then make the following changes High Memory | High Ram - #2 by josephgodwinke