Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.9 has been released 04/14/2014 05:53PM
MySQL Cluster 7.2.16 has been released 04/09/2014 04:32AM
MySQL Cluster 7.3.5 has been released 04/07/2014 08:15PM
MySQL Connector/ODBC 5.3.2 GA has been released 04/07/2014 08:14PM
MySQL Connector/NET 6.7.5 has been released 04/04/2014 09:15AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 12
Subject Views Written By Posted
Sticky:  FREE! MySQL Health Check (1 Posts)   1,313 Edwin Desouza 02/07/2013 10:18PM
Sticky:  A deep look at MySQL 5.5 partitioning enhancements (2 Posts)   9,100 Giuseppe Maxia 12/24/2009 02:55PM
Sticky:  MySQL 5.5: Partitioning Enhancements (1 Posts)   7,599 Edwin DeSouza 12/15/2009 02:55PM
Sticky:  MySQL University - Boosting performance with partitions (1 Posts)   9,423 Edwin DeSouza 06/01/2009 10:47AM
Sticky:  MySQL Partitioning: Optimizations - A “behind the scenes” look (1 Posts)   10,817 Edwin DeSouza 09/28/2006 01:25AM
Sticky:  MySQL Partitioning: Articles, FAQs, Blogs (1 Posts)   14,896 Edwin DeSouza 05/23/2006 04:59PM
Sticky:  MySQL Partitioning: Blogs by Mikael Ronstrom (1 Posts)   9,266 Edwin DeSouza 03/27/2006 09:06PM
Consumption of more hard disk space in "Copying to tmp table" phase   22 Raghavendra K 04/14/2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   9 Mattias Jonsson 04/14/2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   3 Raghavendra K 04/16/2014 06:40AM
MySql Horizontal partitioning - Pros-Cons   15 Manohar K 04/14/2014 11:43AM
Storing tables on multiple partitions   35 sdgbfdsg fdhgfdhds 04/09/2014 08:04AM
Re: Storing tables on multiple partitions   9 Rick James 04/11/2014 04:32PM
Failed to read from the .par file   59 IGG t 04/02/2014 09:49AM
Re: Failed to read from the .par file   15 Rick James 04/05/2014 01:13PM
How to extend partition when there is no unallocated space in hard disk?   198 mi Su 01/06/2014 01:21AM
Re: How to extend partition when there is no unallocated space in hard disk?   178 Rick James 01/08/2014 05:22PM
Partitioning or indexing for millions of records   487 Aamir Sohail 11/26/2013 05:44AM
Re: Partitioning or indexing for millions of records   382 Rick James 11/27/2013 12:39PM
Re: Partitioning or indexing for millions of records   258 Aamir Sohail 11/28/2013 12:40AM
Re: Partitioning or indexing for millions of records   241 Rick James 11/28/2013 09:07PM
Re: Partitioning or indexing for millions of records   215 Aamir Sohail 11/29/2013 04:11AM
Re: Partitioning or indexing for millions of records   208 Rick James 11/30/2013 01:30PM
Re: Partitioning or indexing for millions of records   137 chris arndt 12/31/2013 11:34AM
best way to take backup for old partition and create new one?   259 Aamir Sohail 12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?   151 Rick James 12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?   142 mi Su 12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?   120 Rick James 12/13/2013 12:51AM
Am I doing this correctly?   320 Jim Buckley Barrett 11/29/2013 05:03AM
Re: Am I doing this correctly?   160 Jim Buckley Barrett 11/29/2013 06:22AM
Re: Am I doing this correctly?   149 Rick James 11/30/2013 02:18PM
Re: Am I doing this correctly?   134 mi Su 12/04/2013 12:38AM
Re: Am I doing this correctly?   129 Jim Buckley Barrett 12/05/2013 03:48AM
Re: Am I doing this correctly?   119 Rick James 12/05/2013 10:21AM
Re: Am I doing this correctly?   117 Jim Buckley Barrett 12/10/2013 09:49AM
Re: Am I doing this correctly?   118 Jim Buckley Barrett 12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table   411 Aamir Sohail 11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table   201 Rick James 11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table   158 Aamir Sohail 11/29/2013 04:19AM
Partition data backup and restore   527 Seungho Nam Nam 10/18/2013 12:48AM
Re: Partition data backup and restore   300 Mattias Jonsson 10/18/2013 02:59AM
Re: Partition data backup and restore   208 Steven Robinson 11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning   331 mark silverman 09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   187 Rick James 09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   180 Mattias Jonsson 10/04/2013 01:02AM
Reorganize Partition Syntax error   470 IGG t 09/16/2013 03:13AM
Re: Reorganize Partition Syntax error   199 IGG t 09/16/2013 09:39AM
Re: Reorganize Partition Syntax error   167 Rick James 09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?   626 Prabhu Raja Singh 09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   404 Rick James 09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   310 Prabhu Raja Singh 09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness   607 IGG t 08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness   323 Rick James 08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness   290 IGG t 08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness   267 Rick James 08/31/2013 05:35PM
mysql tables in use 500, locked 500   637 bruce.zuo bruce 07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500   320 Rick James 07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500   274 bruce.zuo bruce 07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500   220 Mattias Jonsson 08/13/2013 05:42AM
Create index on partition table (manually and dynamically)   990 Vladimir Pivovar 07/05/2013 11:26PM
Re: Create index on parttion table (manually and dynamically)   421 Rick James 07/06/2013 10:52PM
Re: Create index on parttion table (manually and dynamically)   394 Vladimir Pivovar 07/07/2013 12:20AM
Re: Create index on parttion table (manually and dynamically)   378 Vladimir Pivovar 07/07/2013 10:57AM
Re: Create index on parttion table (manually and dynamically)   390 Rick James 07/08/2013 09:46AM
Re: Create index on partition table (manually and dynamically)   425 Vladimir Pivovar 07/10/2013 02:23PM
how to remove partitiong in mysql version5.6   601 heiansan white 06/13/2013 01:41AM
Re: how to remove partitiong in mysql version5.6   323 Rick James 06/15/2013 01:50PM
No. of partitions in NDB cluster   555 Alax James 05/31/2013 02:14AM
IP vs Date Partition   683 Tim Linden 05/13/2013 10:28AM
Re: IP vs Date Partition   436 Rick James 05/14/2013 09:59PM
Re: IP vs Date Partition   424 Tim Linden 05/15/2013 10:06AM
How should I partition this table?   846 Ron Bergin 04/26/2013 09:18AM
Re: How should I partition this table?   492 Rick James 04/27/2013 09:58PM
Re: How should I partition this table?   427 Ron Bergin 04/28/2013 11:29AM
Re: How should I partition this table?   408 Rick James 04/29/2013 08:10AM
Re: How should I partition this table?   408 Ron Bergin 04/30/2013 08:39AM
Re: How should I partition this table?   394 Rick James 05/01/2013 11:45PM
Re: How should I partition this table?   366 Ron Bergin 05/02/2013 08:17AM
Re: How should I partition this table?   357 Ron Bergin 05/02/2013 11:55AM
Re: How should I partition this table?   380 Rick James 05/03/2013 09:00AM
Re: How should I partition this table?   389 Ron Bergin 05/03/2013 09:32AM
Performance doubt   753 Xavier Borrut 03/26/2013 06:41AM
Re: Performance doubt   432 Rick James 03/28/2013 12:34AM
Re: Performance doubt   88 Mattias Jonsson 04/09/2013 01:49AM
Event add partition works but not the drop partition   729 Frwa Onto 04/04/2013 11:22PM
Re: Event add partition works but not the drop partition   348 Frwa Onto 04/05/2013 04:13AM
Should I partition?   821 Jacob Steinberger 03/19/2013 02:57PM
Re: Should I partition?   520 Rick James 03/21/2013 08:49PM
Re: Should I partition?   450 NOT_FOUND NOT_FOUND 04/03/2013 10:08AM
Re: Should I partition?   405 Rick James 04/04/2013 11:35PM
Partitioned table problem after upgrade to 5.5   836 Ming Wang 03/06/2013 04:07AM
Re: Partitioned table problem after upgrade to 5.5   431 Mattias Jonsson 03/06/2013 04:38AM
Re: Partitioned table problem after upgrade to 5.5   432 Ming Wang 03/07/2013 08:23PM
Re: Partitioned table problem after upgrade to 5.5   385 Rick James 03/07/2013 11:32PM
Re: Partitioned table problem after upgrade to 5.5   417 Mattias Jonsson 03/08/2013 02:20AM
If you use a partition table in mysql5.5, Contact function   737 kyung gi lee 02/25/2013 03:12AM
Re: If you use a partition table in mysql5.5, Contact function   425 Rick James 02/28/2013 09:34AM
How to (temporary) disable one partition in the partitioned table   904 First Bell 02/13/2013 11:01PM
Re: How to (temporary) disable one partition in the partitioned table   533 Rick James 02/22/2013 01:00AM
Re: How to (temporary) disable one partition in the partitioned table   563 Mattias Jonsson 02/28/2013 05:51AM
Index with partitioning   997 Hélio Hélio 01/30/2013 06:23AM
Re: Index with partitioning   624 Rick James 02/01/2013 10:20PM
Re: Index with partitioning   600 Hélio Hélio 02/04/2013 08:03AM
Re: Index with partitioning   590 Rick James 02/07/2013 10:09PM
Re: Index with partitioning   612 Hélio Hélio 02/08/2013 06:55AM
Re: Index with partitioning   582 Rick James 02/09/2013 01:22PM
Re: Index with partitioning   680 Hélio Hélio 02/14/2013 12:26PM
MySQL Partitioning showing low performance   878 Manosh Manohar 02/05/2013 12:10AM
Re: MySQL Partitioning showing low performance   539 Rick James 02/07/2013 10:14PM
Re: MySQL Partitioning showing low performance   468 Manosh Manohar 02/08/2013 12:39AM
How to let the query run on one partition   991 Shawn Liu 01/09/2013 08:29AM
Re: How to let the query run on one partition   539 Rick James 01/10/2013 08:45PM
How to partition by City \ State   899 Noah Goodrich 12/19/2012 10:06PM
Re: How to partition by City \ State   547 Rick James 12/20/2012 10:00PM
Partition behaiour seems abnormal in range partition   983 Rahul K K 12/10/2012 12:05AM
Re: Partition behaiour seems abnormal in range partition   481 Rick James 12/20/2012 02:56PM
partition by range on decimal type   1,196 Greg K 11/20/2012 07:15AM
Re: partition by range on decimal type   622 Rick James 11/21/2012 10:39AM
Re: partition by range on decimal type   568 Greg K 11/22/2012 02:26AM
Re: partition by range on decimal type   559 Rick James 11/22/2012 11:02PM
Re: partition by range on decimal type   798 Greg K 11/23/2012 12:45AM
Re: partition by range on decimal type   824 Rick James 11/23/2012 09:03PM
Fortnight partitions   1,177 Srikanth Mamidi 11/19/2012 11:24PM
Re: Fortnight partitions   735 Rick James 11/20/2012 10:56PM
Re: Fortnight partitions   578 Srikanth Mamidi 11/20/2012 11:23PM
Re: Fortnight partitions   621 Rick James 11/21/2012 08:54PM
Re: Fortnight partitions   750 Srikanth Mamidi 11/23/2012 12:04AM
milliseconds in mysql equivalent to java for Partitioning   1,243 Manjunath C 11/12/2012 01:36AM
Re: milliseconds in mysql equivalent to java for Partitioning   710 Rick James 11/13/2012 09:15AM
Re: milliseconds in mysql equivalent to java for Partitioning   607 Manjunath C 11/14/2012 04:17AM
Partitioning not working need primary key?   1,488 newbie Shai 10/20/2012 11:12AM
Re: Partitioning not working need primary key?   851 Mattias Jonsson 10/22/2012 07:14AM
Re: Partitioning not working need primary key?   710 newbie Shai 10/22/2012 11:59AM
Re: Partitioning not working need primary key?   722 Rick James 10/22/2012 09:37PM
Re: Partitioning not working need primary key?   706 newbie Shai 10/23/2012 08:36AM
Re: Partitioning not working need primary key?   748 Rick James 10/23/2012 09:50AM
Re: Partitioning not working need primary key?   700 newbie Shai 10/24/2012 09:05AM
Re: Partitioning not working need primary key?   676 Rick James 10/24/2012 09:26PM
Re: Partitioning not working need primary key?   638 newbie Shai 10/25/2012 09:45PM
Re: Partitioning not working need primary key?   661 Rick James 10/25/2012 11:22PM
Re: Partitioning not working need primary key?   636 newbie Shai 10/27/2012 07:21AM
Re: Partitioning not working need primary key?   637 Rick James 10/27/2012 12:01PM
Re: Partitioning not working need primary key?   614 newbie Shai 10/28/2012 12:10PM
Re: Partitioning not working need primary key?   633 Rick James 10/28/2012 02:12PM
Re: Partitioning not working need primary key?   650 newbie Shai 11/01/2012 10:55AM
Re: Partitioning not working need primary key?   649 Rick James 11/02/2012 12:37AM
Re: Partitioning not working need primary key?   640 newbie Shai 11/03/2012 10:37AM
Re: Partitioning not working need primary key?   672 Rick James 11/03/2012 11:37AM
Re: Partitioning not working need primary key?   592 newbie Shai 10/29/2012 06:51PM
Does partitioning make sense for this application?   1,240 Paul Schmehl 10/25/2012 08:46PM
Re: Does partitioning make sense for this application?   728 Rick James 10/26/2012 07:41PM
Re: Does partitioning make sense for this application?   683 Paul Schmehl 10/26/2012 09:55PM
Re: Does partitioning make sense for this application?   580 Rick James 10/27/2012 09:42PM
Re: Does partitioning make sense for this application?   555 Paul Schmehl 10/27/2012 10:41PM
Re: Does partitioning make sense for this application?   548 Rick James 10/28/2012 06:09PM
Re: Does partitioning make sense for this application?   548 Paul Schmehl 10/28/2012 08:58PM
Re: Does partitioning make sense for this application?   574 Rick James 10/30/2012 12:15PM
Programatic Partitioning   963 Jardel Morais 10/22/2012 04:44AM
Get partition name for specific date   1,192 Jan Bromberger 10/08/2012 12:48PM
Re: Get partition name for specific date   725 Rick James 10/09/2012 09:21AM
Re: Get partition name for specific date   644 Jan Bromberger 10/10/2012 03:18AM
Re: Get partition name for specific date   672 Rick James 10/11/2012 07:12PM
Row movement for MySQL partitionned tables   1,145 jongse park 10/10/2012 11:14PM
Re: Row movement for MySQL partitionned tables   632 Mattias Jonsson 10/11/2012 05:32AM
columns partitioning row inserted in wrong partition   1,143 martino merci 10/10/2012 02:54AM
Re: columns partitioning row inserted in wrong partition   602 Mattias Jonsson 10/10/2012 11:15AM
Regarding optimizing hugh data with mysql   1,077 Santosh Bhabal 10/08/2012 05:47AM
Re: Regarding optimizing hugh data with mysql   643 Rick James 10/09/2012 11:23PM
Partitioning by year/quarter   1,529 Ravi Malghan 09/24/2012 10:32AM
Re: Partitioning by year/quarter   879 Aftab Khan 09/27/2012 01:31PM
Re: Partitioning by year/quarter   644 Rick James 10/02/2012 09:15PM
Partitioning help   973 Naresh Kondeboina 09/25/2012 02:09PM
Re: Partitioning help   625 Aftab Khan 09/27/2012 01:12PM
Re: Partitioning help   621 Naresh Kondeboina 09/27/2012 08:38PM
Re: Partitioning help   616 Rick James 10/01/2012 11:54PM
Prunning partitions with range by date   1,154 Diogo Domanski 09/27/2012 01:18PM
Re: Prunning partitions with range by date   724 Aftab Khan 09/27/2012 01:39PM
Re: Prunning partitions with range by date (SOLVED)   654 Diogo Domanski 09/27/2012 03:00PM
What Method is Best   1,111 Larry Adams 09/12/2012 03:12PM
Re: What Method is Best   751 Mattias Jonsson 09/14/2012 02:36AM
Re: What Method is Best   689 Larry Adams 09/14/2012 05:30AM
Re: What Method is Best   637 Rick James 09/14/2012 11:11PM
timestamp, datetime as default value as current_timestamp [PARTITION]   1,566 Mannoj Kumar 08/29/2012 01:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   884 Aftab Khan 08/29/2012 04:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   754 Mattias Jonsson 08/31/2012 06:00PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   657 Aftab Khan 09/03/2012 03:19AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,042 Mannoj Kumar 08/29/2012 04:32AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   769 Aftab Khan 08/29/2012 09:16AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   731 Mannoj Kumar 09/03/2012 11:26PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   867 Rick James 09/04/2012 08:05PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   860 Mannoj Kumar 09/07/2012 05:49AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   710 Rick James 08/30/2012 10:35PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   709 Aftab Khan 08/31/2012 02:04AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   775 Rick James 08/31/2012 09:52AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   676 Mattias Jonsson 09/05/2012 12:36AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   732 Rick James 09/05/2012 08:29AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   793 Aftab Khan 08/31/2012 01:58AM
Modify primary key for partitioning   1,282 Aurelien PANIZZA 08/10/2012 10:29AM
Re: Modify primary key for partitioning   805 Rick James 08/18/2012 09:39PM
Re: Modify primary key for partitioning   853 Aurelien PANIZZA 08/20/2012 06:33AM
Re: Modify primary key for partitioning   798 Aftab Khan 08/22/2012 10:16AM
Re: Modify primary key for partitioning   724 Aurelien PANIZZA 08/28/2012 10:14AM
Re: Modify primary key for partitioning   711 Rick James 08/30/2012 10:26PM
Re: Modify primary key for partitioning   847 Aurelien PANIZZA 08/31/2012 03:05AM
Re: Modify primary key for partitioning   691 Aftab Khan 08/31/2012 03:38AM
Re: Modify primary key for partitioning   673 Aurelien PANIZZA 08/31/2012 06:48AM
Re: Modify primary key for partitioning   705 Rick James 08/31/2012 09:39AM
Re: Modify primary key for partitioning   678 Aurelien PANIZZA 09/04/2012 01:02AM
Re: Modify primary key for partitioning   746 Rick James 08/23/2012 09:16AM
Re: Modify primary key for partitioning   763 Aftab Khan 08/23/2012 10:42AM
particular field type not allowed to this type of partitioning   2,125 Dhileepan M 08/23/2012 11:24PM
Re: particular field type not allowed to this type of partitioning   814 Mattias Jonsson 08/24/2012 04:15AM
Re: particular field type not allowed to this type of partitioning   1,046 Aftab Khan 08/24/2012 01:59AM
Re: particular field type not allowed to this type of partitioning   779 Dhileepan M 08/24/2012 03:46AM
Simply MySQL Partition on One Column (groupID)   1,131 Andrew Barlow 08/20/2012 07:43AM
Re: Simply MySQL Partition on One Column (groupID)   734 Aftab Khan 08/22/2012 09:46AM
Re: Simply MySQL Partition on One Column (groupID)   771 Rick James 08/21/2012 08:44AM
range columns including datetime column   1,220 Rob Voyer 08/15/2012 10:01PM
Re: range columns including datetime column   736 Mattias Jonsson 08/16/2012 02:42AM
Re: range columns including datetime column   688 Rob Voyer 08/16/2012 07:15AM
Re: range columns including datetime column   677 Mattias Jonsson 08/16/2012 09:35AM
Re: range columns including datetime column   644 Rob Voyer 08/16/2012 09:54AM
Re: range columns including datetime column   734 Rick James 08/19/2012 10:55PM
Re: range columns including datetime column   692 Mattias Jonsson 08/20/2012 03:21AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 12

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.