Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)

[Raghavendra K]

Thanks for the reply Rick

> Maybe: http://forums.mysql.com/read.php?10,617680,617725

Above link did not mention how to resolve/fix. Did I miss anything?

> The first of these is redundant and can (should) be dropped:
> KEY `landscape_idx` (`landscape_h`),
> KEY `landscape_and_time_idx` (`landscape_h`,`time`),

Sure I will be removing one

> It looks like you are setting up 'weekly' partitions? You have only 3 to start with; you will be adding more as time goes on? And you won't be DROPping old partitions?
> What do you hope to gain by PARTITIONs? Only in certain situations will you get any performance boost.

yeah I was setting up 'weekly' partitions, with rotation of dropping old & creating new partitions.
My DB ('event' table in the topic chain) has around 500Million of records and get add new records 2.5M avg. per day, when I query the DB based on datetime, execution completion is taking weeks.
To make query execution fast and for good performance decided to go with 'weekly' partitions.