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!

Suggestions MySQL for Wordpress

Discussion in 'Workarounds and Optimization' started by jlucho, Jul 6, 2018.

  1. jlucho

    jlucho Active Member

    Joined:
    Aug 5, 2006
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    156
    hello


    I have the following server :

    i7-7700 CPU (8 cores)
    8Gb DDR4 Ram
    250Gb SSD M.2
    100Mbit port


    I have 10 website with wordpress and high visits

    high consumption mysql


    what would be the recommended configuration, for "my.cnf", to have an optimal performance?
     
  2. vacancy

    vacancy Well-Known Member

    Joined:
    Sep 20, 2012
    Messages:
    198
    Likes Received:
    25
    Trophy Points:
    28
    cPanel Access Level:
    Root Administrator
    You can follow up the instant mysql queries from the "Show Mysql Process" section on whm. It is necessary to consult a software engineer to determine which database is the source of continuous and long-running queries.

    You can also check this link.

    Tutorial - Troubleshooting high server loads on Linux servers
     
  3. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    2,721
    Likes Received:
    186
    Trophy Points:
    143
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    That article is a great one provided by @vacancy the forums also have a number of useful threads that discuss high load attributed to MySQL
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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