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 slow on 1 website. [moved]

Discussion in 'Workarounds and Optimization' started by X22, Sep 29, 2005.

  1. X22

    X22 Member

    Joined:
    May 5, 2005
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    151
    MYSQL slow on 1 website.

    Hello,

    I host quite a database intensive website and the site is allways slow, does cpanel allocate a certain amount of memory or power for accounts in mysql?

    If so how do i up the limits?

    Thanks.
     
  2. cguimont

    cguimont Well-Known Member

    Joined:
    Jul 13, 2004
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    166
    I don't think there are. But I would check the tables inside the database to see if they are optimized.
     
  3. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Lewisville, Tx
    Depending on the forum there are lots of tweaks you can do in your code. Make sure your server is tuned for optimal performance.
     
  4. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,472
    Likes Received:
    20
    Trophy Points:
    463
    Location:
    Go on, have a guess
    If this is your own server you should also optimize MySQL for your load distribution. If it isn't your server, you should ask your web hosting provider about it (e.g. enabling MySQL query caching).
     
  5. X22

    X22 Member

    Joined:
    May 5, 2005
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    151
    This is my own server, thing is all other websites work fine apart from this particular site.

    Any advise would be appreciated.

    Thanks.
     
  6. X22

    X22 Member

    Joined:
    May 5, 2005
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    151
    Just to mention this server is a duel xeon 2.4 with 2GB of ram.

    Current load: 2 users, load average: 0.60, 0.66, 0.64

    mytop:

    MySQL on localhost (4.0.25-standard) up 0+06:56:48 [11:25:00]
    Queries: 222.6k qps: 9 Slow: 1.0 Se/In/Up/De(%): 33/03/33/03
    qps now: 17 Slow qps: 0.0 Threads: 2 ( 2/ 18) 05/02/02/81
    Cache Hits: 13.6k Hits/s: 0.6 Hits now: 0.0 Ratio: 18.4% Ratio now: 0.0%
    Key Efficiency: 94.7% Bps in/out: 853.9/ 1.6k Now in/out: 1.4k/948.7
     
Loading...

Share This Page