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

what are 50 lakhs ?

Have you indexed your tables on the columns that you perform most of your joins on?

http://en.wikipedia.org/wiki/Lakh

50 lakhs means 50,00000 records.
it is an enoromous data , then how to do the entire database optimisation,

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