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 Process taking too much ram

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

Tags:
  1. srikanta159

    srikanta159 Registered

    Joined:
    Sep 5, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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/wind.foxnapdns.com.err --open-files-limit=50000 --pid-file=/var/lib/mysql/servername.com.pid 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 Forums Analyst
    Staff Member

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

    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.
     
Loading...

Share This Page