MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)
Posted by: Rick James
Date: August 26, 2014 02:31PM

> 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.

Let's see the SELECT -- it is not obvious that PARTITIONs will help any.

For further discussion of a rolling-time partition setup:
http://mysql.rjweb.org/doc.php/partitionmaint

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.