Help me to optimize Mysql.

Discussion in 'MySQL' started by moulikminda, Jun 21, 2009.

0
  1. #1
    I have a site which has around 10000 members registered in it.
    Server Config :
    Intel(R) Xeon(R) CPU X3210 @ 2.13GHz
    2GB Ram

    I've noticed that the site load some times reaches 4.
    When i checked in the WHM, I found that MYSQL load it very high.
    What should i do to decrease the load?


    Also i have noticed that my earlier coder has used double instead of decimal in the type in a table. Because of this, some of the users balance is being shown as 1.19999999 instead of 1.2. Is it fine to change the type to decimal (11,2)?
     
    moulikminda, Jun 21, 2009 IP
  2. moulikminda

    moulikminda Peon

    Messages:
    24
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    any one please help?
     
    moulikminda, Jun 23, 2009 IP
  3. Mark Henderson

    Mark Henderson Well-Known Member

    Messages:
    402
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    110
    #3
    This is the kind of thing you PAY a sys admin for. I doubt anyone will help you for free.
     
    Mark Henderson, Jun 23, 2009 IP
  4. ice_cube

    ice_cube Peon

    Messages:
    32
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Need more details.....like what version of MySQL do you use ?

    And still need to know the code. So many programmer write a code, connect to mysql and never close the connection. IMO, this will load more resources
     
    ice_cube, Jun 26, 2009 IP
  5. Wrighty

    Wrighty Peon

    Messages:
    199
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If you PM me a link & some details, I can give you a quote for optimisation. I'll inspect for free etc... however any modifications will cost - of course, depending of the ability of your previous coder, I'm sure at least 50% of the queries could be optimised. :)

    PM me for further info.
     
    Wrighty, Jun 26, 2009 IP
  6. Goramba

    Goramba Peon

    Messages:
    128
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Indexes can help the system run orders of magnitude faster. Create a slow-queries log file and set it to something like 1 second to log. Post the queries here and I'll suggest a few indexes.
     
    Goramba, Jun 27, 2009 IP
  7. theapparatus

    theapparatus Peon

    Messages:
    2,925
    Likes Received:
    119
    Best Answers:
    0
    Trophy Points:
    0
    #7
    It would be helpful if you mention what software this "site" is running.
     
    theapparatus, Jun 27, 2009 IP
  8. Goramba

    Goramba Peon

    Messages:
    128
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Why would that be necessary?
     
    Goramba, Jun 27, 2009 IP
  9. wd_2k6

    wd_2k6 Peon

    Messages:
    1,740
    Likes Received:
    54
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Think they mean like if they are using a CMS like WP so then you can tell why server load might be high
     
    wd_2k6, Jun 28, 2009 IP
  10. theapparatus

    theapparatus Peon

    Messages:
    2,925
    Likes Received:
    119
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Or what to look for to reduce the load. Like caching or additional plugins or server adjustments or the like.
     
    theapparatus, Jun 28, 2009 IP