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: Rick James ()
Date: August 24, 2014 09:14PM

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

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

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.

> memory 8GB.

What is the value of innodb_buffer_pool_size? I would expect 5-6GB.

> tmp_table_size = 1G
> max_heap_table_size = 1G

These large values can hurt you if there is a sudden rush of connections needing tmp tables.

> Size of the db is 280GB and the free space available on HD is 360GB

Sounds sufficient for the ALTER.

> UNIQUE KEY `event_id_model_key_idx` (`event_id`,`model_key`,`time`),

If you don't really need it to be UNIQUE, the ALTER will probably run a lot faster with an ordinary (non-UNIQUE) INDEX.

Options: ReplyQuote


Subject Views Written By Posted
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 2934 Raghavendra K 08/22/2014 12:37AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1113 Rick James 08/24/2014 09:14PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1115 Raghavendra K 08/25/2014 11:38AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1117 Rick James 08/26/2014 02:31PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 987 Raghavendra K 08/30/2014 03:43AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1106 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.