MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.3 GA has been released 09/15/2016 03:06PM
MySQL Connector/Python 2.2.1 m2 Development Release has been released 09/13/2016 09:58AM
Oracle Enterprise Manager for MySQL Database 12.1.0.4.0 has been released 09/12/2016 02:59PM
MySQL Community Server 8.0.0-dmr has been released (part 3/3) 09/12/2016 08:52AM
MySQL Community Server 8.0.0-dmr has been released (part 2/3) 09/12/2016 08:50AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 13
Subject Views Written By Posted
best way to take backup for old partition and create new one?   1,991 Aamir Sohail 12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?   1,075 Rick James 12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?   1,011 mi Su 12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?   976 Rick James 12/13/2013 12:51AM
Am I doing this correctly?   1,891 Jim Buckley Barrett 11/29/2013 05:03AM
Re: Am I doing this correctly?   1,086 Jim Buckley Barrett 11/29/2013 06:22AM
Re: Am I doing this correctly?   1,184 Rick James 11/30/2013 02:18PM
Re: Am I doing this correctly?   1,022 mi Su 12/04/2013 12:38AM
Re: Am I doing this correctly?   1,084 Jim Buckley Barrett 12/05/2013 03:48AM
Re: Am I doing this correctly?   1,089 Rick James 12/05/2013 10:21AM
Re: Am I doing this correctly?   1,060 Jim Buckley Barrett 12/10/2013 09:49AM
Re: Am I doing this correctly?   1,083 Jim Buckley Barrett 12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table   4,473 Aamir Sohail 11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table   2,192 Rick James 11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table   1,613 Aamir Sohail 11/29/2013 04:19AM
Partition data backup and restore   3,906 Seungho Nam Nam 10/18/2013 12:48AM
Re: Partition data backup and restore   1,990 Mattias Jonsson 10/18/2013 02:59AM
Re: Partition data backup and restore   1,590 Steven Robinson 11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning   1,704 mark silverman 09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   1,004 Rick James 09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   1,060 Mattias Jonsson 10/04/2013 01:02AM
Reorganize Partition Syntax error   2,181 IGG t 09/16/2013 03:13AM
Re: Reorganize Partition Syntax error   972 IGG t 09/16/2013 09:39AM
Re: Reorganize Partition Syntax error   949 Rick James 09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?   2,503 Prabhu Raja Singh 09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   1,494 Rick James 09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   1,387 Prabhu Raja Singh 09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness   2,096 IGG t 08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness   1,046 Rick James 08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness   1,005 IGG t 08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness   1,019 Rick James 08/31/2013 05:35PM
mysql tables in use 500, locked 500   2,003 bruce.zuo bruce 07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500   1,124 Rick James 07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500   977 bruce.zuo bruce 07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500   942 Mattias Jonsson 08/13/2013 05:42AM
Create index on partition table (manually and dynamically)   4,111 Vladimir Pivovar 07/05/2013 11:26PM
Re: Create index on parttion table (manually and dynamically)   1,463 Rick James 07/06/2013 10:52PM
Re: Create index on parttion table (manually and dynamically)   1,329 Vladimir Pivovar 07/07/2013 12:20AM
Re: Create index on parttion table (manually and dynamically)   1,294 Vladimir Pivovar 07/07/2013 10:57AM
Re: Create index on parttion table (manually and dynamically)   1,361 Rick James 07/08/2013 09:46AM
Re: Create index on partition table (manually and dynamically)   1,536 Vladimir Pivovar 07/10/2013 02:23PM
how to remove partitiong in mysql version5.6   1,909 heiansan white 06/13/2013 01:41AM
Re: how to remove partitiong in mysql version5.6   1,056 Rick James 06/15/2013 01:50PM
No. of partitions in NDB cluster   1,628 Alax James 05/31/2013 02:14AM
IP vs Date Partition   1,975 Tim Linden 05/13/2013 10:28AM
Re: IP vs Date Partition   1,433 Rick James 05/14/2013 09:59PM
Re: IP vs Date Partition   1,358 Tim Linden 05/15/2013 10:06AM
How should I partition this table?   2,399 Ron Bergin 04/26/2013 09:18AM
Re: How should I partition this table?   1,244 Rick James 04/27/2013 09:58PM
Re: How should I partition this table?   1,169 Ron Bergin 04/28/2013 11:29AM
Re: How should I partition this table?   1,127 Rick James 04/29/2013 08:10AM
Re: How should I partition this table?   1,125 Ron Bergin 04/30/2013 08:39AM
Re: How should I partition this table?   1,154 Rick James 05/01/2013 11:45PM
Re: How should I partition this table?   1,145 Ron Bergin 05/02/2013 08:17AM
Re: How should I partition this table?   1,038 Ron Bergin 05/02/2013 11:55AM
Re: How should I partition this table?   1,091 Rick James 05/03/2013 09:00AM
Re: How should I partition this table?   1,116 Ron Bergin 05/03/2013 09:32AM
Performance doubt   1,792 Xavier Borrut 03/26/2013 06:41AM
Re: Performance doubt   1,069 Rick James 03/28/2013 12:34AM
Re: Performance doubt   723 Mattias Jonsson 04/09/2013 01:49AM
Event add partition works but not the drop partition   1,858 Frwa Onto 04/04/2013 11:22PM
Re: Event add partition works but not the drop partition   947 Frwa Onto 04/05/2013 04:13AM
Should I partition?   1,977 Jacob Steinberger 03/19/2013 02:57PM
Re: Should I partition?   1,139 Rick James 03/21/2013 08:49PM
Re: Should I partition?   1,074 NOT_FOUND NOT_FOUND 04/03/2013 10:08AM
Re: Should I partition?   1,000 Rick James 04/04/2013 11:35PM
Partitioned table problem after upgrade to 5.5   2,084 Ming Wang 03/06/2013 04:07AM
Re: Partitioned table problem after upgrade to 5.5   1,018 Mattias Jonsson 03/06/2013 04:38AM
Re: Partitioned table problem after upgrade to 5.5   1,027 Ming Wang 03/07/2013 08:23PM
Re: Partitioned table problem after upgrade to 5.5   937 Rick James 03/07/2013 11:32PM
Re: Partitioned table problem after upgrade to 5.5   979 Mattias Jonsson 03/08/2013 02:20AM
If you use a partition table in mysql5.5, Contact function   1,712 kyung gi lee 02/25/2013 03:12AM
Re: If you use a partition table in mysql5.5, Contact function   1,038 Rick James 02/28/2013 09:34AM
How to (temporary) disable one partition in the partitioned table   2,005 First Bell 02/13/2013 11:01PM
Re: How to (temporary) disable one partition in the partitioned table   1,124 Rick James 02/22/2013 01:00AM
Re: How to (temporary) disable one partition in the partitioned table   1,290 Mattias Jonsson 02/28/2013 05:51AM
Index with partitioning   2,119 Hélio Hélio 01/30/2013 06:23AM
Re: Index with partitioning   1,287 Rick James 02/01/2013 10:20PM
Re: Index with partitioning   1,395 Hélio Hélio 02/04/2013 08:03AM
Re: Index with partitioning   1,252 Rick James 02/07/2013 10:09PM
Re: Index with partitioning   1,261 Hélio Hélio 02/08/2013 06:55AM
Re: Index with partitioning   1,145 Rick James 02/09/2013 01:22PM
Re: Index with partitioning   1,422 Hélio Hélio 02/14/2013 12:26PM
MySQL Partitioning showing low performance   1,849 Manosh Manohar 02/05/2013 12:10AM
Re: MySQL Partitioning showing low performance   1,132 Rick James 02/07/2013 10:14PM
Re: MySQL Partitioning showing low performance   1,017 Manosh Manohar 02/08/2013 12:39AM
How to let the query run on one partition   2,096 Shawn Liu 01/09/2013 08:29AM
Re: How to let the query run on one partition   1,055 Rick James 01/10/2013 08:45PM
How to partition by City \ State   1,911 Noah Goodrich 12/19/2012 10:06PM
Re: How to partition by City \ State   1,066 Rick James 12/20/2012 10:00PM
Partition behaiour seems abnormal in range partition   1,970 Rahul K K 12/10/2012 12:05AM
Re: Partition behaiour seems abnormal in range partition   960 Rick James 12/20/2012 02:56PM
partition by range on decimal type   2,838 Greg K 11/20/2012 07:15AM
Re: partition by range on decimal type   1,375 Rick James 11/21/2012 10:39AM
Re: partition by range on decimal type   1,181 Greg K 11/22/2012 02:26AM
Re: partition by range on decimal type   1,241 Rick James 11/22/2012 11:02PM
Re: partition by range on decimal type   1,382 Greg K 11/23/2012 12:45AM
Re: partition by range on decimal type   1,464 Rick James 11/23/2012 09:03PM
Fortnight partitions   2,648 Srikanth Mamidi 11/19/2012 11:24PM
Re: Fortnight partitions   1,636 Rick James 11/20/2012 10:56PM
Re: Fortnight partitions   1,083 Srikanth Mamidi 11/20/2012 11:23PM
Re: Fortnight partitions   1,263 Rick James 11/21/2012 08:54PM
Re: Fortnight partitions   1,207 Srikanth Mamidi 11/23/2012 12:04AM
milliseconds in mysql equivalent to java for Partitioning   3,172 Manjunath C 11/12/2012 01:36AM
Re: milliseconds in mysql equivalent to java for Partitioning   1,559 Rick James 11/13/2012 09:15AM
Re: milliseconds in mysql equivalent to java for Partitioning   1,364 Manjunath C 11/14/2012 04:17AM
Partitioning not working need primary key?   2,961 newbie Shai 10/20/2012 11:12AM
Re: Partitioning not working need primary key?   1,531 Mattias Jonsson 10/22/2012 07:14AM
Re: Partitioning not working need primary key?   1,283 newbie Shai 10/22/2012 11:59AM
Re: Partitioning not working need primary key?   1,290 Rick James 10/22/2012 09:37PM
Re: Partitioning not working need primary key?   1,334 newbie Shai 10/23/2012 08:36AM
Re: Partitioning not working need primary key?   1,289 Rick James 10/23/2012 09:50AM
Re: Partitioning not working need primary key?   1,256 newbie Shai 10/24/2012 09:05AM
Re: Partitioning not working need primary key?   1,227 Rick James 10/24/2012 09:26PM
Re: Partitioning not working need primary key?   1,255 newbie Shai 10/25/2012 09:45PM
Re: Partitioning not working need primary key?   1,314 Rick James 10/25/2012 11:22PM
Re: Partitioning not working need primary key?   1,265 newbie Shai 10/27/2012 07:21AM
Re: Partitioning not working need primary key?   1,203 Rick James 10/27/2012 12:01PM
Re: Partitioning not working need primary key?   1,186 newbie Shai 10/28/2012 12:10PM
Re: Partitioning not working need primary key?   1,229 Rick James 10/28/2012 02:12PM
Re: Partitioning not working need primary key?   1,334 newbie Shai 11/01/2012 10:55AM
Re: Partitioning not working need primary key?   1,166 Rick James 11/02/2012 12:37AM
Re: Partitioning not working need primary key?   1,194 newbie Shai 11/03/2012 10:37AM
Re: Partitioning not working need primary key?   1,254 Rick James 11/03/2012 11:37AM
Re: Partitioning not working need primary key?   1,172 newbie Shai 10/29/2012 06:51PM
Does partitioning make sense for this application?   2,190 Paul Schmehl 10/25/2012 08:46PM
Re: Does partitioning make sense for this application?   1,244 Rick James 10/26/2012 07:41PM
Re: Does partitioning make sense for this application?   1,399 Paul Schmehl 10/26/2012 09:55PM
Re: Does partitioning make sense for this application?   1,038 Rick James 10/27/2012 09:42PM
Re: Does partitioning make sense for this application?   1,013 Paul Schmehl 10/27/2012 10:41PM
Re: Does partitioning make sense for this application?   1,003 Rick James 10/28/2012 06:09PM
Re: Does partitioning make sense for this application?   990 Paul Schmehl 10/28/2012 08:58PM
Re: Does partitioning make sense for this application?   1,081 Rick James 10/30/2012 12:15PM
Programatic Partitioning   1,679 Jardel Morais 10/22/2012 04:44AM
Get partition name for specific date   2,070 Jan Bromberger 10/08/2012 12:48PM
Re: Get partition name for specific date   1,200 Rick James 10/09/2012 09:21AM
Re: Get partition name for specific date   1,034 Jan Bromberger 10/10/2012 03:18AM
Re: Get partition name for specific date   1,122 Rick James 10/11/2012 07:12PM
Row movement for MySQL partitionned tables   2,073 jongse park 10/10/2012 11:14PM
Re: Row movement for MySQL partitionned tables   1,133 Mattias Jonsson 10/11/2012 05:32AM
columns partitioning row inserted in wrong partition   1,852 martino merci 10/10/2012 02:54AM
Re: columns partitioning row inserted in wrong partition   977 Mattias Jonsson 10/10/2012 11:15AM
Regarding optimizing hugh data with mysql   1,764 Santosh Bhabal 10/08/2012 05:47AM
Re: Regarding optimizing hugh data with mysql   1,009 Rick James 10/09/2012 11:23PM
Partitioning by year/quarter   3,073 Ravi Malghan 09/24/2012 10:32AM
Re: Partitioning by year/quarter   1,578 Aftab Khan 09/27/2012 01:31PM
Re: Partitioning by year/quarter   1,205 Rick James 10/02/2012 09:15PM
Partitioning help   1,593 Naresh Kondeboina 09/25/2012 02:09PM
Re: Partitioning help   1,007 Aftab Khan 09/27/2012 01:12PM
Re: Partitioning help   1,010 Naresh Kondeboina 09/27/2012 08:38PM
Re: Partitioning help   1,024 Rick James 10/01/2012 11:54PM
Prunning partitions with range by date   1,847 Diogo Domanski 09/27/2012 01:18PM
Re: Prunning partitions with range by date   1,129 Aftab Khan 09/27/2012 01:39PM
Re: Prunning partitions with range by date (SOLVED)   1,055 Diogo Domanski 09/27/2012 03:00PM
What Method is Best   1,930 Larry Adams 09/12/2012 03:12PM
Re: What Method is Best   1,167 Mattias Jonsson 09/14/2012 02:36AM
Re: What Method is Best   1,138 Larry Adams 09/14/2012 05:30AM
Re: What Method is Best   1,038 Rick James 09/14/2012 11:11PM
timestamp, datetime as default value as current_timestamp [PARTITION]   2,858 Mannoj Kumar 08/29/2012 01:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,368 Aftab Khan 08/29/2012 04:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,184 Mattias Jonsson 08/31/2012 06:00PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,054 Aftab Khan 09/03/2012 03:19AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   2,099 Mannoj Kumar 08/29/2012 04:32AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,199 Aftab Khan 08/29/2012 09:16AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,134 Mannoj Kumar 09/03/2012 11:26PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,331 Rick James 09/04/2012 08:05PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,298 Mannoj Kumar 09/07/2012 05:49AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,117 Rick James 08/30/2012 10:35PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,085 Aftab Khan 08/31/2012 02:04AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,208 Rick James 08/31/2012 09:52AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,171 Mattias Jonsson 09/05/2012 12:36AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,099 Rick James 09/05/2012 08:29AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,189 Aftab Khan 08/31/2012 01:58AM
Modify primary key for partitioning   2,119 Aurelien PANIZZA 08/10/2012 10:29AM
Re: Modify primary key for partitioning   1,180 Rick James 08/18/2012 09:39PM
Re: Modify primary key for partitioning   1,305 Aurelien PANIZZA 08/20/2012 06:33AM
Re: Modify primary key for partitioning   1,194 Aftab Khan 08/22/2012 10:16AM
Re: Modify primary key for partitioning   1,130 Aurelien PANIZZA 08/28/2012 10:14AM
Re: Modify primary key for partitioning   1,029 Rick James 08/30/2012 10:26PM
Re: Modify primary key for partitioning   1,422 Aurelien PANIZZA 08/31/2012 03:05AM
Re: Modify primary key for partitioning   1,104 Aftab Khan 08/31/2012 03:38AM
Re: Modify primary key for partitioning   1,114 Aurelien PANIZZA 08/31/2012 06:48AM
Re: Modify primary key for partitioning   1,097 Rick James 08/31/2012 09:39AM
Re: Modify primary key for partitioning   1,072 Aurelien PANIZZA 09/04/2012 01:02AM
Re: Modify primary key for partitioning   1,112 Rick James 08/23/2012 09:16AM
Re: Modify primary key for partitioning   1,142 Aftab Khan 08/23/2012 10:42AM
particular field type not allowed to this type of partitioning   5,114 Dhileepan M 08/23/2012 11:24PM
Re: particular field type not allowed to this type of partitioning   1,234 Mattias Jonsson 08/24/2012 04:15AM
Re: particular field type not allowed to this type of partitioning   1,976 Aftab Khan 08/24/2012 01:59AM
Re: particular field type not allowed to this type of partitioning   1,270 Dhileepan M 08/24/2012 03:46AM
Simply MySQL Partition on One Column (groupID)   1,722 Andrew Barlow 08/20/2012 07:43AM
Re: Simply MySQL Partition on One Column (groupID)   1,021 Aftab Khan 08/22/2012 09:46AM
Re: Simply MySQL Partition on One Column (groupID)   1,098 Rick James 08/21/2012 08:44AM
range columns including datetime column   1,929 Rob Voyer 08/15/2012 10:01PM
Re: range columns including datetime column   1,069 Mattias Jonsson 08/16/2012 02:42AM
Re: range columns including datetime column   1,054 Rob Voyer 08/16/2012 07:15AM
Re: range columns including datetime column   1,003 Mattias Jonsson 08/16/2012 09:35AM
Re: range columns including datetime column   992 Rob Voyer 08/16/2012 09:54AM
Re: range columns including datetime column   1,089 Rick James 08/19/2012 10:55PM
Re: range columns including datetime column   973 Mattias Jonsson 08/20/2012 03:21AM
Partition   2,162 Dhileepan M 08/10/2012 12:37AM
Re: Partition   1,437 Jonathan Stephens 08/11/2012 03:37AM
Re: Partition   1,280 Rick James 08/19/2012 03:18PM
Add new partition for Range by date   2,412 Mannoj Kumar 08/09/2012 04:05AM
Re: Add new partition for Range by date   1,063 Jonathan Stephens 08/12/2012 01:20AM
Re: Add new partition for Range by date   1,514 Rick James 08/18/2012 07:53PM
Re: Add new partition for Range by date   1,304 Rick James 08/10/2012 01:05AM
Re: Add new partition for Range by date   1,067 Mannoj Kumar 08/10/2012 03:17AM
Re: Add new partition for Range by date   1,142 Aftab Khan 08/12/2012 01:06AM
how to partition a table with string type unique column .   2,546 qufu dai 08/14/2012 01:40AM
Re: how to partition a table with string type unique column .   1,108 Mattias Jonsson 08/16/2012 02:16AM
Partition or not ?   1,916 Srikanth Mamidi 08/07/2012 12:58AM
Re: Partition or not ?   1,131 Rick James 08/09/2012 08:04PM
Partitioning with timestamp column   5,112 dileep ch 08/01/2012 10:25PM
Re: Partitioning with timestamp column   2,072 Rick James 08/02/2012 09:26PM
Re: Partitioning with timestamp column   1,979 dileep ch 08/02/2012 11:44PM
Re: Partitioning with timestamp column   2,266 Rick James 08/03/2012 07:30PM
Accessing more partitions than needed   1,704 dileep ch 07/19/2012 01:12AM
Re: Accessing more partitions than needed   993 Mattias Jonsson 07/19/2012 05:23AM
Upgrading 5.1 to 5.5   1,077 dileep ch 08/02/2012 12:18AM
Re: Upgrading 5.1 to 5.5   970 Mattias Jonsson 08/02/2012 02:44AM
Re: Accessing more partitions than needed   833 dileep ch 07/19/2012 06:01AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 13

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.