Timeline for Where is my old partition in mysql show create table?
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 2, 2013 at 17:43 | vote | accept | newbie14 | ||
| Dec 25, 2012 at 2:11 | comment | added | newbie14 | @ypercube so I guess I am missing ALTER TABLE tblData ADD PARTITION. Can I say I am missing the word ADD? | |
| Dec 24, 2012 at 10:57 | answer | added | Maxime Fouilleul | timeline score: 1 | |
| Dec 24, 2012 at 7:40 | comment | added | ypercubeᵀᴹ |
As @Phil's comment, see the documentation: Management of RANGE and LIST Partitions, and the paragraph: "To add a new range or list partition to a previously partitioned table, use the ALTER TABLE ... ADD PARTITION statement. For tables ..."
|
|
| Dec 24, 2012 at 2:17 | comment | added | newbie14 | @phil so what should I be doing to keep adding new partition when I need them? | |
| Dec 24, 2012 at 1:54 | comment | added | Philᵀᴹ |
I suspect you're actually repartitioning the entire table like that (and making the p20 partition very big). From the documentation, I think you need a REORGANIZE PARTITION clause. I'm sure a MySQL DBA will answer it soon and take my credit :)
|
|
| Dec 24, 2012 at 1:42 | history | asked | newbie14 | CC BY-SA 3.0 |