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


Advanced Search

Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)
Posted by: Raghavendra K ()
Date: August 25, 2014 11:38AM

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.

Options: ReplyQuote


Subject Views Written By Posted
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 2994 Raghavendra K 08/22/2014 12:37AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1137 Rick James 08/24/2014 09:14PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1134 Raghavendra K 08/25/2014 11:38AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1138 Rick James 08/26/2014 02:31PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1005 Raghavendra K 08/30/2014 03:43AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1127 Rick James 09/01/2014 08:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.