How to optimize MySQL databases?

Discussion in 'MySQL' started by tradester, Jun 8, 2008.

0
  1. #1
    Hi
    Have quite a few sites running many MySQL databases which is causing sites to load slowly.
    How can I optimize MySQL databases?
    Would appreciate help.
    Thanks :)
     
    tradester, Jun 8, 2008 IP
  2. Kynlem

    Kynlem Peon

    Messages:
    14
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    There isn't a short answer for your questions. Reducing the number of queries, denormalization and caching all can help to improve performance. How exactly to do that? Depends on your case.
     
    Kynlem, Jun 9, 2008 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    Start here: http://www.mysqlperformanceblog.com/

    The pre-made my.cnf templates are a decent first start at optimizing your my.cnf file.

    After that you need to learn how and when to use indexes, caching, etc.
     
    jestep, Jun 9, 2008 IP
  4. clobberx

    clobberx Active Member

    Messages:
    73
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    61
    #4
    check this http://www.developer.com/db/article.php/3667831
     
    clobberx, Jun 9, 2008 IP
  5. Nepopec

    Nepopec Peon

    Messages:
    40
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    try to reload all tables in you database, may be there some mistake:confused:
     
    Nepopec, Jun 10, 2008 IP