{How to optimize my database }

Discussion in 'MySQL' started by seoarticle, Dec 2, 2012.

0
  1. #1
    how to optimize my database from extra load.
    My hosting said that your database consume more cpu usage please optimize it to run on our server.
    please some one guide me.
    its on shared server linux based
    http://thewhir.info/
     
    seoarticle, Dec 2, 2012 IP
  2. EricBruggema

    EricBruggema Well-Known Member

    Messages:
    1,740
    Likes Received:
    28
    Best Answers:
    13
    Trophy Points:
    175
    #2
    Make give us the database structure and used queries? and what did you try for yourselve? have you tried EXPLAIN <querystatement> to check what's going on with a query?
     
    EricBruggema, Dec 2, 2012 IP
  3. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #3
    Max connections per hour exceeded. Make sure you're closing every connection you open.
     
    Rukbat, Dec 2, 2012 IP