Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Connector/Python 2.0.0 Alpha has been released 07/24/2014 11:56AM
MySQL Connector/NET 6.9.2 RC has been released 07/18/2014 07:41PM
MySQL Connector/ODBC 5.3.4 has been released 07/18/2014 05:49PM
MySQL Enterprise Monitor 3.0.13 has been released 07/18/2014 03:20PM
MySQL Cluster 7.1.32 has been released 07/15/2014 09:06PM
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,527 Edwin Desouza 02/07/2013 10:18PM
Sticky:  A deep look at MySQL 5.5 partitioning enhancements (2 Posts)   9,349 Giuseppe Maxia 12/24/2009 02:55PM
Sticky:  MySQL 5.5: Partitioning Enhancements (1 Posts)   7,797 Edwin DeSouza 12/15/2009 02:55PM
Sticky:  MySQL University - Boosting performance with partitions (1 Posts)   9,672 Edwin DeSouza 06/01/2009 10:47AM
Sticky:  MySQL Partitioning: Optimizations - A “behind the scenes” look (1 Posts)   11,016 Edwin DeSouza 09/28/2006 01:25AM
Sticky:  MySQL Partitioning: Articles, FAQs, Blogs (1 Posts)   15,235 Edwin DeSouza 05/23/2006 04:59PM
Sticky:  MySQL Partitioning: Blogs by Mikael Ronstrom (1 Posts)   9,450 Edwin DeSouza 03/27/2006 09:06PM
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"   55 Jon Jacob 07/20/2014 07:50AM
Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"   15 Rick James 07/21/2014 06:50PM
Range partitioning on floor (decimal(14.4)) doesn't work :/   69 Max Herman 07/12/2014 12:35PM
Re: Range partitioning on floor (decimal(14.4)) doesn't work :/   25 Rick James 07/14/2014 06:45PM
why explain partition shows first partition in every select query?   190 Aamir Sohail 05/27/2014 07:18AM
Re: why explain partition shows first partition in every select query?   87 Rick James 05/27/2014 03:10PM
Re: why explain partition shows first partition in every select query?   68 Aamir Sohail 05/28/2014 12:52AM
Storing, accessing and configuring my partitions in diferent servers   144 Victor Bombella 05/23/2014 11:54PM
Re: Storing, accessing and configuring my partitions in diferent servers   70 Rick James 05/25/2014 04:57PM
missing data after partitioning - bug?   172 rol and 05/23/2014 12:51PM
Re: missing data after partitioning - bug?   68 Rick James 05/25/2014 04:27PM
MySql Partitioning problem (bug?)   4,735 K T 05/07/2014 04:39PM
Re: MySql Partitioning problem (bug?)   98 Rick James 05/09/2014 11:59PM
Re: MySql Partitioning problem (bug?)   80 K T 05/10/2014 03:41PM
Re: MySql Partitioning problem (bug?)   85 K T 05/10/2014 03:44PM
Re: MySql Partitioning problem (bug?)   80 Mattias Jonsson 05/16/2014 06:15AM
MySQL partition by range on YEAR(date) weird results   272 Adelin Feraru 05/12/2014 02:15AM
Re: MySQL partition by range on YEAR(date) weird results   87 Rick James 05/15/2014 12:01AM
Re: MySQL partition by range on YEAR(date) weird results   80 Adelin Feraru 05/15/2014 03:38AM
Re: MySQL partition by range on YEAR(date) weird results   77 Mattias Jonsson 05/15/2014 11:42AM
Storing tables on multiple partitions   239 sdgbfdsg fdhgfdhds 04/09/2014 08:04AM
Re: Storing tables on multiple partitions   122 Rick James 04/11/2014 04:32PM
Re: Storing tables on multiple partitions   97 mi Su 04/29/2014 01:09AM
MySql Horizontal partitioning - Pros-Cons   246 Manohar K 04/14/2014 11:43AM
Re: MySql Horizontal partitioning - Pros-Cons   135 Rick James 04/17/2014 11:16PM
Re: MySql Horizontal partitioning - Pros-Cons   120 Rick James 04/19/2014 03:42PM
Consumption of more hard disk space in "Copying to tmp table" phase   249 Raghavendra K 04/14/2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   98 Mattias Jonsson 04/14/2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   103 Raghavendra K 04/16/2014 06:40AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   95 Mattias Jonsson 04/17/2014 12:55PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   94 Rick James 04/17/2014 11:36PM
Failed to read from the .par file   430 IGG t 04/02/2014 09:49AM
Re: Failed to read from the .par file   195 Rick James 04/05/2014 01:13PM
How to extend partition when there is no unallocated space in hard disk?   364 mi Su 01/06/2014 01:21AM
Re: How to extend partition when there is no unallocated space in hard disk?   323 Rick James 01/08/2014 05:22PM
Partitioning or indexing for millions of records   698 Aamir Sohail 11/26/2013 05:44AM
Re: Partitioning or indexing for millions of records   577 Rick James 11/27/2013 12:39PM
Re: Partitioning or indexing for millions of records   380 Aamir Sohail 11/28/2013 12:40AM
Re: Partitioning or indexing for millions of records   388 Rick James 11/28/2013 09:07PM
Re: Partitioning or indexing for millions of records   321 Aamir Sohail 11/29/2013 04:11AM
Re: Partitioning or indexing for millions of records   325 Rick James 11/30/2013 01:30PM
Re: Partitioning or indexing for millions of records   253 chris arndt 12/31/2013 11:34AM
best way to take backup for old partition and create new one?   451 Aamir Sohail 12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?   266 Rick James 12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?   235 mi Su 12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?   216 Rick James 12/13/2013 12:51AM
Am I doing this correctly?   508 Jim Buckley Barrett 11/29/2013 05:03AM
Re: Am I doing this correctly?   272 Jim Buckley Barrett 11/29/2013 06:22AM
Re: Am I doing this correctly?   271 Rick James 11/30/2013 02:18PM
Re: Am I doing this correctly?   232 mi Su 12/04/2013 12:38AM
Re: Am I doing this correctly?   251 Jim Buckley Barrett 12/05/2013 03:48AM
Re: Am I doing this correctly?   220 Rick James 12/05/2013 10:21AM
Re: Am I doing this correctly?   211 Jim Buckley Barrett 12/10/2013 09:49AM
Re: Am I doing this correctly?   213 Jim Buckley Barrett 12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table   800 Aamir Sohail 11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table   379 Rick James 11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table   296 Aamir Sohail 11/29/2013 04:19AM
Partition data backup and restore   907 Seungho Nam Nam 10/18/2013 12:48AM
Re: Partition data backup and restore   490 Mattias Jonsson 10/18/2013 02:59AM
Re: Partition data backup and restore   371 Steven Robinson 11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning   496 mark silverman 09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   280 Rick James 09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   282 Mattias Jonsson 10/04/2013 01:02AM
Reorganize Partition Syntax error   691 IGG t 09/16/2013 03:13AM
Re: Reorganize Partition Syntax error   303 IGG t 09/16/2013 09:39AM
Re: Reorganize Partition Syntax error   271 Rick James 09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?   855 Prabhu Raja Singh 09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   535 Rick James 09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   461 Prabhu Raja Singh 09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness   837 IGG t 08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness   445 Rick James 08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness   403 IGG t 08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness   382 Rick James 08/31/2013 05:35PM
mysql tables in use 500, locked 500   840 bruce.zuo bruce 07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500   448 Rick James 07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500   374 bruce.zuo bruce 07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500   314 Mattias Jonsson 08/13/2013 05:42AM
Create index on partition table (manually and dynamically)   1,460 Vladimir Pivovar 07/05/2013 11:26PM
Re: Create index on parttion table (manually and dynamically)   577 Rick James 07/06/2013 10:52PM
Re: Create index on parttion table (manually and dynamically)   537 Vladimir Pivovar 07/07/2013 12:20AM
Re: Create index on parttion table (manually and dynamically)   512 Vladimir Pivovar 07/07/2013 10:57AM
Re: Create index on parttion table (manually and dynamically)   551 Rick James 07/08/2013 09:46AM
Re: Create index on partition table (manually and dynamically)   581 Vladimir Pivovar 07/10/2013 02:23PM
how to remove partitiong in mysql version5.6   769 heiansan white 06/13/2013 01:41AM
Re: how to remove partitiong in mysql version5.6   417 Rick James 06/15/2013 01:50PM
No. of partitions in NDB cluster   701 Alax James 05/31/2013 02:14AM
IP vs Date Partition   857 Tim Linden 05/13/2013 10:28AM
Re: IP vs Date Partition   582 Rick James 05/14/2013 09:59PM
Re: IP vs Date Partition   589 Tim Linden 05/15/2013 10:06AM
How should I partition this table?   1,056 Ron Bergin 04/26/2013 09:18AM
Re: How should I partition this table?   615 Rick James 04/27/2013 09:58PM
Re: How should I partition this table?   529 Ron Bergin 04/28/2013 11:29AM
Re: How should I partition this table?   506 Rick James 04/29/2013 08:10AM
Re: How should I partition this table?   521 Ron Bergin 04/30/2013 08:39AM
Re: How should I partition this table?   497 Rick James 05/01/2013 11:45PM
Re: How should I partition this table?   484 Ron Bergin 05/02/2013 08:17AM
Re: How should I partition this table?   457 Ron Bergin 05/02/2013 11:55AM
Re: How should I partition this table?   488 Rick James 05/03/2013 09:00AM
Re: How should I partition this table?   511 Ron Bergin 05/03/2013 09:32AM
Performance doubt   911 Xavier Borrut 03/26/2013 06:41AM
Re: Performance doubt   529 Rick James 03/28/2013 12:34AM
Re: Performance doubt   185 Mattias Jonsson 04/09/2013 01:49AM
Event add partition works but not the drop partition   912 Frwa Onto 04/04/2013 11:22PM
Re: Event add partition works but not the drop partition   443 Frwa Onto 04/05/2013 04:13AM
Should I partition?   997 Jacob Steinberger 03/19/2013 02:57PM
Re: Should I partition?   634 Rick James 03/21/2013 08:49PM
Re: Should I partition?   558 NOT_FOUND NOT_FOUND 04/03/2013 10:08AM
Re: Should I partition?   506 Rick James 04/04/2013 11:35PM
Partitioned table problem after upgrade to 5.5   1,033 Ming Wang 03/06/2013 04:07AM
Re: Partitioned table problem after upgrade to 5.5   528 Mattias Jonsson 03/06/2013 04:38AM
Re: Partitioned table problem after upgrade to 5.5   532 Ming Wang 03/07/2013 08:23PM
Re: Partitioned table problem after upgrade to 5.5   473 Rick James 03/07/2013 11:32PM
Re: Partitioned table problem after upgrade to 5.5   520 Mattias Jonsson 03/08/2013 02:20AM
If you use a partition table in mysql5.5, Contact function   890 kyung gi lee 02/25/2013 03:12AM
Re: If you use a partition table in mysql5.5, Contact function   519 Rick James 02/28/2013 09:34AM
How to (temporary) disable one partition in the partitioned table   1,063 First Bell 02/13/2013 11:01PM
Re: How to (temporary) disable one partition in the partitioned table   635 Rick James 02/22/2013 01:00AM
Re: How to (temporary) disable one partition in the partitioned table   667 Mattias Jonsson 02/28/2013 05:51AM
Index with partitioning   1,176 Hélio Hélio 01/30/2013 06:23AM
Re: Index with partitioning   737 Rick James 02/01/2013 10:20PM
Re: Index with partitioning   729 Hélio Hélio 02/04/2013 08:03AM
Re: Index with partitioning   693 Rick James 02/07/2013 10:09PM
Re: Index with partitioning   718 Hélio Hélio 02/08/2013 06:55AM
Re: Index with partitioning   695 Rick James 02/09/2013 01:22PM
Re: Index with partitioning   818 Hélio Hélio 02/14/2013 12:26PM
MySQL Partitioning showing low performance   1,040 Manosh Manohar 02/05/2013 12:10AM
Re: MySQL Partitioning showing low performance   629 Rick James 02/07/2013 10:14PM
Re: MySQL Partitioning showing low performance   559 Manosh Manohar 02/08/2013 12:39AM
How to let the query run on one partition   1,199 Shawn Liu 01/09/2013 08:29AM
Re: How to let the query run on one partition   628 Rick James 01/10/2013 08:45PM
How to partition by City \ State   1,050 Noah Goodrich 12/19/2012 10:06PM
Re: How to partition by City \ State   647 Rick James 12/20/2012 10:00PM
Partition behaiour seems abnormal in range partition   1,156 Rahul K K 12/10/2012 12:05AM
Re: Partition behaiour seems abnormal in range partition   572 Rick James 12/20/2012 02:56PM
partition by range on decimal type   1,401 Greg K 11/20/2012 07:15AM
Re: partition by range on decimal type   730 Rick James 11/21/2012 10:39AM
Re: partition by range on decimal type   678 Greg K 11/22/2012 02:26AM
Re: partition by range on decimal type   678 Rick James 11/22/2012 11:02PM
Re: partition by range on decimal type   916 Greg K 11/23/2012 12:45AM
Re: partition by range on decimal type   945 Rick James 11/23/2012 09:03PM
Fortnight partitions   1,442 Srikanth Mamidi 11/19/2012 11:24PM
Re: Fortnight partitions   915 Rick James 11/20/2012 10:56PM
Re: Fortnight partitions   684 Srikanth Mamidi 11/20/2012 11:23PM
Re: Fortnight partitions   760 Rick James 11/21/2012 08:54PM
Re: Fortnight partitions   844 Srikanth Mamidi 11/23/2012 12:04AM
milliseconds in mysql equivalent to java for Partitioning   1,521 Manjunath C 11/12/2012 01:36AM
Re: milliseconds in mysql equivalent to java for Partitioning   858 Rick James 11/13/2012 09:15AM
Re: milliseconds in mysql equivalent to java for Partitioning   752 Manjunath C 11/14/2012 04:17AM
Partitioning not working need primary key?   1,719 newbie Shai 10/20/2012 11:12AM
Re: Partitioning not working need primary key?   971 Mattias Jonsson 10/22/2012 07:14AM
Re: Partitioning not working need primary key?   823 newbie Shai 10/22/2012 11:59AM
Re: Partitioning not working need primary key?   836 Rick James 10/22/2012 09:37PM
Re: Partitioning not working need primary key?   815 newbie Shai 10/23/2012 08:36AM
Re: Partitioning not working need primary key?   859 Rick James 10/23/2012 09:50AM
Re: Partitioning not working need primary key?   815 newbie Shai 10/24/2012 09:05AM
Re: Partitioning not working need primary key?   779 Rick James 10/24/2012 09:26PM
Re: Partitioning not working need primary key?   752 newbie Shai 10/25/2012 09:45PM
Re: Partitioning not working need primary key?   798 Rick James 10/25/2012 11:22PM
Re: Partitioning not working need primary key?   760 newbie Shai 10/27/2012 07:21AM
Re: Partitioning not working need primary key?   745 Rick James 10/27/2012 12:01PM
Re: Partitioning not working need primary key?   740 newbie Shai 10/28/2012 12:10PM
Re: Partitioning not working need primary key?   766 Rick James 10/28/2012 02:12PM
Re: Partitioning not working need primary key?   774 newbie Shai 11/01/2012 10:55AM
Re: Partitioning not working need primary key?   745 Rick James 11/02/2012 12:37AM
Re: Partitioning not working need primary key?   744 newbie Shai 11/03/2012 10:37AM
Re: Partitioning not working need primary key?   799 Rick James 11/03/2012 11:37AM
Re: Partitioning not working need primary key?   699 newbie Shai 10/29/2012 06:51PM
Does partitioning make sense for this application?   1,427 Paul Schmehl 10/25/2012 08:46PM
Re: Does partitioning make sense for this application?   833 Rick James 10/26/2012 07:41PM
Re: Does partitioning make sense for this application?   816 Paul Schmehl 10/26/2012 09:55PM
Re: Does partitioning make sense for this application?   673 Rick James 10/27/2012 09:42PM
Re: Does partitioning make sense for this application?   652 Paul Schmehl 10/27/2012 10:41PM
Re: Does partitioning make sense for this application?   645 Rick James 10/28/2012 06:09PM
Re: Does partitioning make sense for this application?   654 Paul Schmehl 10/28/2012 08:58PM
Re: Does partitioning make sense for this application?   688 Rick James 10/30/2012 12:15PM
Programatic Partitioning   1,115 Jardel Morais 10/22/2012 04:44AM
Get partition name for specific date   1,359 Jan Bromberger 10/08/2012 12:48PM
Re: Get partition name for specific date   832 Rick James 10/09/2012 09:21AM
Re: Get partition name for specific date   741 Jan Bromberger 10/10/2012 03:18AM
Re: Get partition name for specific date   769 Rick James 10/11/2012 07:12PM
Row movement for MySQL partitionned tables   1,340 jongse park 10/10/2012 11:14PM
Re: Row movement for MySQL partitionned tables   747 Mattias Jonsson 10/11/2012 05:32AM
columns partitioning row inserted in wrong partition   1,303 martino merci 10/10/2012 02:54AM
Re: columns partitioning row inserted in wrong partition   689 Mattias Jonsson 10/10/2012 11:15AM
Regarding optimizing hugh data with mysql   1,233 Santosh Bhabal 10/08/2012 05:47AM
Re: Regarding optimizing hugh data with mysql   732 Rick James 10/09/2012 11:23PM
Partitioning by year/quarter   1,796 Ravi Malghan 09/24/2012 10:32AM
Re: Partitioning by year/quarter   1,013 Aftab Khan 09/27/2012 01:31PM
Re: Partitioning by year/quarter   765 Rick James 10/02/2012 09:15PM
Partitioning help   1,111 Naresh Kondeboina 09/25/2012 02:09PM
Re: Partitioning help   720 Aftab Khan 09/27/2012 01:12PM
Re: Partitioning help   710 Naresh Kondeboina 09/27/2012 08:38PM
Re: Partitioning help   705 Rick James 10/01/2012 11:54PM
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.