Important thing should do when we delete large number of records from a MySQL table

When you deleting large number of records from a MySQL table, remember to execute following command after deleting the records.

OPTIMIZE TABLE tablename;

By executing this command we can improve performance of the table queries and save storage space.

You can find detail explanation from : http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html

MySQL 5.1 New Features: MySQL Partitions

I had a problem with handling huge amount of data in one of my MySQL databases. Problem is its take too much time to generate reports from a huge data collection.
I found many ways to solve this problem and also this new MySQL table Partitioning feature. Its come with MySQL 5.1.

Using this feature we can increased performance of MySQL data scan operations as I needed above. And also simplified data management.

Read following for more:
http://dev.mysql.com/tech-resources/articles/performance-partitioning.html

%d bloggers like this: