Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Unanswered: Managing Large DataBase in Mysql

    HI
    I am facing problem in managing a huge database in Mysql.
    I m having a database which holds 50 lakhs and more records.
    i want to know ,how to compress the database so that my select query runs faster.
    also how can i prevent my disk space from been run out due to this large database ,because my database will go on increasing.

    shall i have to switch to another database or mysql has some solutions for it.

    pls help me in this regard.

    regards
    debarati

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    what are 50 lakhs ?

  3. #3
    Join Date
    Mar 2004
    Posts
    480
    Have you indexed your tables on the columns that you perform most of your joins on?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by osy45
    what are 50 lakhs ?
    http://en.wikipedia.org/wiki/Lakh
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Nov 2004
    Posts
    2
    Quote Originally Posted by osy45
    what are 50 lakhs ?
    50 lakhs means 50,00000 records.
    it is an enoromous data , then how to do the entire database optimisation,

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    5,000,000 isn't that large a database, MySQL should be able to handle it. I'm not to sure where the management tools are on MySQL. It doesn't come with equivalents to SQL Server Tools, but I have a suspiscion its self maitaining. Ie recovers space dynamically, self optimises. If you have bulk updates / deletes then it may be prudent to reindex the database - not too sure what the correct command for that is though.

    Have you considered approach mySQL directly? I've always found them to be very approachable and helpful

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •