Re: Get partition name for specific date

[Rick James]

It's a bit kludgy, but this seems feasible:
EXPLAIN PARTITIONS SELECT * FROM tbl WHERE valid_at = '2012-09-28';
Then parse that to get the partition name.

Have you checked your SELECTs to see if they are doing "pruning"?

You are assuming there is only one day's worth of data in that partition. Because of that risky assumption, I prefer partitioning BY RANGE and do a DROP and REORGANIZE every day to shift the partitions.

Also, I find 92 to be a large number of partitions; I would go with weekly, not daily, for a quarter's worth of data.