Skip to main content

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 ?

Comments

7 comments

Date Votes
  • 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.
    0
  • 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?
    0
  • cPanelMichael
    Hello, This thread would associate more with optimization due to it's relation to performance/memory usage. Thanks!
    0
  • 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?
    0
  • 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.
    0
  • 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
    0
  • 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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post