mysql using high memory

[lambov]

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:

[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
performance-schema=0
max_allowed_packet=268435456
open_files_limit=10000

+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| 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]

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.

 

[lambov]

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.

i'm sorry my thread on wrong category, may you move this thread to databse discussion?

 

[cPanelMichael]

Hello,

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

Thanks!

 

[lambov]

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]

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.

 

[lambov]

Hello,

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

Thank you.

i download from mysqlmymonlite.sh & mysqlmymon.sh server and mysql stats gathering tool and http://www.cpanel.net/application-catalog/mysqlmymonlite-sh-monitoring-stats-tool/

 

[cPanelMichael]

Hello,

You could try an alternative such as:

MySQLTuner-perl by major

Keep in mind these are third-party applications. You may want to consider contacting a qualified system administrator for help with tuning your server's performance:

System Administration Services | cPanel Forums

Thank you.