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:
    1
    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:
    16
    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:
    16
    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,475
    Likes Received:
    20
    Trophy Points:
    38
    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:
    1
    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:
    1
    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