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.
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