Timeline for What are the options for archiving old data of mariadb tables if partitioning can not be implemented due to a restriction
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 18, 2019 at 5:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 19, 2019 at 21:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 18, 2019 at 4:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 11, 2018 at 21:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 12, 2018 at 22:28 | comment | added | Rick James |
Also unusual (but not necessarily "wrong") -- the PK is something other than the AUTO_INCREMENT. uniq1 was promoted to be the PK (by InnoDB's rules for PKs), hence the wording of the error message.
|
|
| Mar 12, 2018 at 22:26 | answer | added | Rick James | timeline score: 1 | |
| Mar 12, 2018 at 22:19 | comment | added | Rick James |
It is extremely rare to have four UNIQUE keys on a table. Please justify them, since 3 of them are in the way of partitioning.
|
|
| Mar 12, 2018 at 22:18 | history | edited | Rick James | CC BY-SA 3.0 |
formatting
|
| Mar 12, 2018 at 14:59 | comment | added | Gerard H. Pille | You could add col1 to your primary key, and add a unique key replacing the original primary one. What is the primary key of tbl ? | |
| Mar 12, 2018 at 13:50 | history | asked | Avijit batabyal | CC BY-SA 3.0 |