lambov

Member
Oct 9, 2016
21
0
51
Earth
cPanel Access Level
Root Administrator
i am runninf cpanel fro webhosting and about 20 account hosted, the most of them is new website with low traffict
my memory usage is about 1GB of 4GB and CPU usage within 0.2 of 4cores

based top/htop mysql usage is on top of chart:
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/my.hostname.nett.err --open-files-limit=10000 --pid-file=/var/lib/mysql/my.hostname.net.pid

i'm using cpanel+cloudlinux with mariadb 10.0 and mysql governor by cloudlinux
this is my mysql conf:
Code:
[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
performance-schema=0
max_allowed_packet=268435456
open_files_limit=10000
Code:
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| Id   | User         | Host      | db           | Command | Time | State | Info             | Progress |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| 183  | eximstats    | localhost | eximstats    | Sleep   | 378  |       |                  | 0.000    |
| 3259 | leechprotect | localhost | leechprotect | Sleep   | 776  |       |                  | 0.000    |
| 3491 | root         | localhost |              | Query   | 0    | init  | show processlist | 0.000    |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
how to reduce memory usage by mysql ?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello,

You could try running a MySQL tuning script to see what it recommends. There's a thread here you may find helpful:

Database Discussions

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello,

This thread would associate more with optimization due to it's relation to performance/memory usage.

Thanks!
 

lambov

Member
Oct 9, 2016
21
0
51
Earth
cPanel Access Level
Root Administrator
Hello,

You could try running a MySQL tuning script to see what it recommends. There's a thread here you may find helpful:

Database Discussions

Thank you.
whats best MySQL tuning script that i should run?
i have tried mysqlmymonlite.sh server stats gathering tool for cPanel Server
but i get error
-------------------------------------------------
mysqltuner output
-------------------------------------------------
mysqltuner.pl [found]
: No such file or directory

Report Complete:
Tue Nov 29 16:01:59 WIB 2016

any alternative option?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
mysqltuner.pl [found]
: No such file or directory
Hello,

Which directory did you download it to, and what command are you using to start it?

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463