Re: speed up the data retriving

[Rick James]

What is the output of this? I suspect it is at least 3 million:
SELECT COUNT(*) FROM bwfdata.tbl_data
where timestamp>='2011-04-01'
and timestamp<='2011-04-30';
(That would explain why the EXPLAIN says ALL instead of RANGE.)

The data is 1,486,396,736 bytes. That will take some time to read.

Hash partitioning does not guarantee which partition will contain what.

What will you do with the data when you get it? If you are doing counts and summations, consider letting SQL do the work.

You have a possible bug:
`TimeStamp` datetime NOT NULL,
where timestamp>='2011-04-01' and timestamp<='2011-04-30';
That will exclude all of Apr. 30th except for midnight. Suggest doing
where timestamp>='2011-04-01'
and timestamp < DATE_ADD('2011-04-01', INTERVAL 1 MONTH);