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!

MySql Process taking too much ram

Discussion in 'Database Discussion' started by srikanta159, Sep 5, 2017.

  1. srikanta159

    srikanta159 Registered

    Sep 5, 2017
    Likes Received:
    Trophy Points:
    Bardhaman, West Bengal, India
    cPanel Access Level:
    Root Administrator
    /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/ --open-files-limit=50000 --pid-file=/var/lib/mysql/ this process taking highest cpu

    i have running mysqltunner . its given me some recommendation.
    -------- Recommendations ---------------------------------------------------------------------------
    General recommendations:
    3 user(s) used basic or weak password.
    MySQL started within last 24 hours - recommendations may be inaccurate
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
    Set thread_cache_size to 4 as a starting value
    Performance should be activated for better diagnostics
    Consider installing Sys schema from GitHub - mysql/mysql-sys: The MySQL sys schema
    Variables to adjust:
    query_cache_size (=0)
    query_cache_type (=0)
    query_cache_limit (> 1M, or use smaller result sets)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    thread_cache_size (start at 4)
    performance_schema = ON enable PFS
    innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
    innodb_buffer_pool_instances (=1)

    can any one tell me what should i add into my my.cnf and what things to do.
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator

    Advice about tuning specific configuration values typically requires the help of a qualified system administrator. I'll leave this thread open for additional user-feedback, but I did want to note the "mysqladmin processlist" command is helpful if you are noticing bad MySQL performance. The command can help determine if any specific databases are responsible for the poor performance.

    You can also find a list of companies offering system administration services if you do not receive sufficient user-feedback to this thread:

    System Administration Services | cPanel Forums

    Thank you.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice