Looking for professional to optimize mysql queries

Discussion in 'MySQL' started by deriklogov, Sep 2, 2009.

0
  1. #1
    Looking for professional to optimize mysql queries
    I already track down list of queries which takes very slow to run.
    Need to optimize them.
     
    deriklogov, Sep 2, 2009 IP
  2. nyxano

    nyxano Peon

    Messages:
    417
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Depending on the number of queries, you could post them here and people might be able to help you out that way. Sometimes just looking at a query, it can be optimized. Other queries would need to know the table structure and the relationship(s) between each table.
     
    nyxano, Sep 2, 2009 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    BTW, are your tables properly indexed and your queries using them?
     
    mwasif, Sep 4, 2009 IP
  4. Lavee

    Lavee Well-Known Member

    Messages:
    234
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    108
    #4
    Send me the queries by PM or post here. I can help


    Thanks

    Lavee
     
    Lavee, Sep 9, 2009 IP
  5. phones2me

    phones2me Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    bear in mind not to over index your tables, as indexing itself carries an additional overhead
     
    phones2me, Oct 14, 2009 IP
  6. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #6
    let queries be posted here and while discussing ways to optimize them, we all will get to learn mysql query optimization.. hope you all will enjoy sharing knowledge like me :)
     
    mastermunj, Oct 16, 2009 IP
  7. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I second that.
    Since this is not the help for hire part of the forum the idea would be to share knowledge.

    So please give us your:
    - Queries
    - DB Schema
    - DB server and if relevant your table type
    - Row counts for each table

    Optional :
    - Are DB and www seperate servers
    - Hardware specs for www and db server
    - Interconnection between www and db server
     
    chisara, Oct 19, 2009 IP