How can I view partition details of a table, like how many partitions are there in a table and storage size of each partition?
You can check the INFORMATION_SCHEMA to get this kind of information, try this page: Visit http://dev.mysql.com/doc/refman/5.1/en/partitioning-info.html