HELP : How to management a large Mysql db ?

Discussion in 'MySQL' started by weisheng, Oct 1, 2012.

0
  1. #1
    i have a mysql database, it have about 2,500,000 rows. i don't know how to management it for my website mylyric.net . Export, import and query so hard and slow.
    Can i make more table and when query, i will must use Join ?
    Could you tell me ? Thankyou very much !
     
    weisheng, Oct 1, 2012 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    No, you don't break a table up because of size. That violates one of the prime directives of database design.

    (2.5 million records isn't particularly large, but backing them up on a slow host is slow.)
     
    Rukbat, Oct 15, 2012 IP
  3. plussy

    plussy Peon

    Messages:
    152
    Likes Received:
    5
    Best Answers:
    9
    Trophy Points:
    0
    #3
    if it is slow then you need to optimise your querys. mysql can handle easily this many entries.
     
    plussy, Oct 16, 2012 IP
  4. sekhar203

    sekhar203 Active Member

    Messages:
    96
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #4
    hmm nice information...
     
    sekhar203, Oct 16, 2012 IP
  5. iliveforyou

    iliveforyou Active Member

    Messages:
    207
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #5
    add some index for query
     
    iliveforyou, Oct 28, 2012 IP
  6. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #6
    Export and import don't depend on optimization or indexes - it's just slow for large databases on slow computers. But it doesn't affect the user experience.

    Optimization (of both the database and the queries) and the proper index design will speed up queries.
     
    Rukbat, Oct 28, 2012 IP