Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql using high memory

Discussion in 'Workarounds and Optimization' started by lambov, Nov 29, 2016.

  1. lambov

    lambov Member

    Joined:
    Oct 9, 2016
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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 ?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,424
    Trophy Points:
    363
    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.
     
  3. lambov

    lambov Member

    Joined:
    Oct 9, 2016
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Earth
    cPanel Access Level:
    Root Administrator
    i'm sorry my thread on wrong category, may you move this thread to databse discussion?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,424
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thanks!
     
  5. lambov

    lambov Member

    Joined:
    Oct 9, 2016
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Earth
    cPanel Access Level:
    Root Administrator
    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?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,424
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thank you.
     
  7. lambov

    lambov Member

    Joined:
    Oct 9, 2016
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Earth
    cPanel Access Level:
    Root Administrator
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,424
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page