Re: Is partitioning helpful in this case?

[Rick James]

There are many possible tips to help you, but first please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
How much RAM do you have?

It sounds like the indexes are killing you. We can discuss how to get rid of them, and still get what you need. Please provide the queries you use for accessing the table.

Timestamps to datetimes are virtually compatible in SELECTs, etc. But, I may argue against partitioning on timestamp, or even against partitioning at all. Again, I need more info.