missing data after partitioning an existing table

2014-05-23 Thread Roland RoLaNd
I know a couple of things, but table partitioning isn't one of them. i have a 35 GB sized table which is causing performance issues, my research came across partitioning, which is what i tried and failed with today. i tried altering the table, that kept going for 2 hours with absolutely no

Re: missing data after partitioning an existing table

2014-05-23 Thread Christophe
Hi there, Le 23/05/2014 21:06, Roland RoLaNd a écrit : [...] Ouch This post is somewhat ... unreadable ! Please format ! Christophe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: missing data after partitioning an existing table

2014-05-23 Thread Roland RoLaNd
Excuse me , and thanks for the heads up. I know a couple of things, but table partitioning isn't one of them. i have a 35 GB sized table which is causing performance issues, my research came across partitioning, which is what i tried and failed with today. i tried altering the table, that

RE: missing data after partitioning an existing table

2014-05-23 Thread Roland RoLaNd
I APOLOGIZE for  unwilling spamming this list!  i switched to plain text, and the formatting is still messed up when i paste from sublime. Background information: i have a 35 GB sized table which is causing performance issue, which is why i decided to add partitioning by month using the