Re: RE:how to make partititon for my table as required

[Rick James]

It would help to see the table. Please do
SHOW CREATE TABLE pvk_table_test_solve1 \G
SHOW TABLE STATUS LIKE pvk_table_test_solve1 \G

You mentioned reading_datetime (in the PRIMARY KEY) and reading_date (in the partition key) -- are they separate fields?
Almost always is it best to have date&time in a single field.

WHERE reading_date >='2009-10-02' AND reading_date <= '2010-10-02'
If reading_date is a DATE, then you are including Oct 2 from both years; did you mean to?
If it is DATETIME or TIMESTAMP, then you are including midnight from 2010-10-02, which is probably a mistake.

Please explain why you think PARTITIONing is useful in your case. (Often people are drawn to PARTITION by false claims.)

Let's see the SELECT statements you will apply to this table. We would like to see if HASH will provide any benefit for them.