Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL for Excel 1.3.3 has been released 10/27/2014 03:08PM
MySQL Cluster 7.1.33 has been released 10/21/2014 04:54AM
MySQL Cluster 7.3.7 has been released 10/17/2014 07:46PM
MySQL Cluster 7.2.18 has been released 10/16/2014 12:07PM
MySQL Enterprise Monitor 3.0.15 has been released 10/01/2014 10:49AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 12
Subject Views Written By Posted
Sticky:  MySQL 5.7: InnoDB Native Partitioning (1 Posts)   100 Edwin Desouza 10/02/2014 09:56AM
Sticky:  MySQL Partitioning: Articles, FAQs, Blogs (1 Posts)   15,514 Edwin DeSouza 05/23/2006 04:59PM
Online Partition addition use "add partition" clause or "reorganize" clause?   82 Tom Song 10/21/2014 03:53AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   14 Tom Song 10/22/2014 11:58PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   22 Rick James 10/23/2014 04:36PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   12 Tom Song 10/24/2014 02:05AM
Partitioning on account_id   79 Ketil Stadskleiv 10/13/2014 02:54PM
Re: Partitioning on account_id   29 Rick James 10/14/2014 06:04PM
Range partition and unique key   127 Pierrick VODOZ 09/24/2014 08:42AM
Re: Range partition and unique key   61 Rick James 09/25/2014 09:59AM
Re: Range partition and unique key   48 Pierrick VODOZ 09/26/2014 03:40AM
Re: Range partition and unique key   45 Rick James 09/27/2014 08:25AM
Horizontal partitioning on a per user basis?   131 Peter Sarkozi 09/18/2014 05:40PM
Re: Horizontal partitioning on a per user basis?   66 Luke Taylor 09/19/2014 01:12AM
Re: Horizontal partitioning on a per user basis?   56 Rick James 09/19/2014 11:18PM
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   237 Raghavendra K 08/22/2014 12:37AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   91 Rick James 08/24/2014 09:14PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   77 Raghavendra K 08/25/2014 11:38AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   73 Rick James 08/26/2014 02:31PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   67 Raghavendra K 08/30/2014 03:43AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   68 Rick James 09/01/2014 08:28PM
Not Taking Paritioning when using Subquery or Join   167 Marc Vettorel 08/27/2014 07:08AM
Re: Not Taking Paritioning when using Subquery or Join   85 Marc Vettorel 08/27/2014 07:19AM
Re: Not Taking Paritioning when using Subquery or Join   76 Rick James 08/28/2014 10:19AM
EXCHANGE PARTITION and DATA DIRECTORY errors   204 Ekundayo Lasode 08/16/2014 09:47AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors   81 Mattias Jonsson 08/19/2014 03:32AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors   76 Ekundayo Lasode 08/19/2014 06:28AM
Storing time series data using partitioning   121 Florian Rampp 08/14/2014 05:45AM
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"   213 Jon Jacob 07/20/2014 07:50AM
Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"   109 Rick James 07/21/2014 06:50PM
Range partitioning on floor (decimal(14.4)) doesn't work :/   255 Max Herman 07/12/2014 12:35PM
Re: Range partitioning on floor (decimal(14.4)) doesn't work :/   110 Rick James 07/14/2014 06:45PM
why explain partition shows first partition in every select query?   353 Aamir Sohail 05/27/2014 07:18AM
Re: why explain partition shows first partition in every select query?   175 Rick James 05/27/2014 03:10PM
Re: why explain partition shows first partition in every select query?   148 Aamir Sohail 05/28/2014 12:52AM
Storing, accessing and configuring my partitions in diferent servers   289 Victor Bombella 05/23/2014 11:54PM
Re: Storing, accessing and configuring my partitions in diferent servers   156 Rick James 05/25/2014 04:57PM
missing data after partitioning - bug?   309 rol and 05/23/2014 12:51PM
Re: missing data after partitioning - bug?   149 Rick James 05/25/2014 04:27PM
MySql Partitioning problem (bug?)   4,907 K T 05/07/2014 04:39PM
Re: MySql Partitioning problem (bug?)   180 Rick James 05/09/2014 11:59PM
Re: MySql Partitioning problem (bug?)   161 K T 05/10/2014 03:41PM
Re: MySql Partitioning problem (bug?)   163 K T 05/10/2014 03:44PM
Re: MySql Partitioning problem (bug?)   174 Mattias Jonsson 05/16/2014 06:15AM
MySQL partition by range on YEAR(date) weird results   482 Adelin Feraru 05/12/2014 02:15AM
Re: MySQL partition by range on YEAR(date) weird results   177 Rick James 05/15/2014 12:01AM
Re: MySQL partition by range on YEAR(date) weird results   169 Adelin Feraru 05/15/2014 03:38AM
Re: MySQL partition by range on YEAR(date) weird results   160 Mattias Jonsson 05/15/2014 11:42AM
Storing tables on multiple partitions   397 sdgbfdsg fdhgfdhds 04/09/2014 08:04AM
Re: Storing tables on multiple partitions   214 Rick James 04/11/2014 04:32PM
Re: Storing tables on multiple partitions   188 mi Su 04/29/2014 01:09AM
MySql Horizontal partitioning - Pros-Cons   443 Manohar K 04/14/2014 11:43AM
Re: MySql Horizontal partitioning - Pros-Cons   247 Rick James 04/17/2014 11:16PM
Re: MySql Horizontal partitioning - Pros-Cons   235 Rick James 04/19/2014 03:42PM
Consumption of more hard disk space in "Copying to tmp table" phase   461 Raghavendra K 04/14/2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   184 Mattias Jonsson 04/14/2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   201 Raghavendra K 04/16/2014 06:40AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   180 Mattias Jonsson 04/17/2014 12:55PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   176 Rick James 04/17/2014 11:36PM
Failed to read from the .par file   807 IGG t 04/02/2014 09:49AM
Re: Failed to read from the .par file   366 Rick James 04/05/2014 01:13PM
How to extend partition when there is no unallocated space in hard disk?   502 mi Su 01/06/2014 01:21AM
Re: How to extend partition when there is no unallocated space in hard disk?   431 Rick James 01/08/2014 05:22PM
Partitioning or indexing for millions of records   872 Aamir Sohail 11/26/2013 05:44AM
Re: Partitioning or indexing for millions of records   718 Rick James 11/27/2013 12:39PM
Re: Partitioning or indexing for millions of records   483 Aamir Sohail 11/28/2013 12:40AM
Re: Partitioning or indexing for millions of records   510 Rick James 11/28/2013 09:07PM
Re: Partitioning or indexing for millions of records   449 Aamir Sohail 11/29/2013 04:11AM
Re: Partitioning or indexing for millions of records   446 Rick James 11/30/2013 01:30PM
Re: Partitioning or indexing for millions of records   342 chris arndt 12/31/2013 11:34AM
best way to take backup for old partition and create new one?   624 Aamir Sohail 12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?   365 Rick James 12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?   329 mi Su 12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?   295 Rick James 12/13/2013 12:51AM
Am I doing this correctly?   675 Jim Buckley Barrett 11/29/2013 05:03AM
Re: Am I doing this correctly?   370 Jim Buckley Barrett 11/29/2013 06:22AM
Re: Am I doing this correctly?   376 Rick James 11/30/2013 02:18PM
Re: Am I doing this correctly?   327 mi Su 12/04/2013 12:38AM
Re: Am I doing this correctly?   350 Jim Buckley Barrett 12/05/2013 03:48AM
Re: Am I doing this correctly?   334 Rick James 12/05/2013 10:21AM
Re: Am I doing this correctly?   312 Jim Buckley Barrett 12/10/2013 09:49AM
Re: Am I doing this correctly?   327 Jim Buckley Barrett 12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table   1,136 Aamir Sohail 11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table   526 Rick James 11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table   408 Aamir Sohail 11/29/2013 04:19AM
Partition data backup and restore   1,278 Seungho Nam Nam 10/18/2013 12:48AM
Re: Partition data backup and restore   670 Mattias Jonsson 10/18/2013 02:59AM
Re: Partition data backup and restore   524 Steven Robinson 11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning   630 mark silverman 09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   380 Rick James 09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   385 Mattias Jonsson 10/04/2013 01:02AM
Reorganize Partition Syntax error   881 IGG t 09/16/2013 03:13AM
Re: Reorganize Partition Syntax error   406 IGG t 09/16/2013 09:39AM
Re: Reorganize Partition Syntax error   356 Rick James 09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?   1,099 Prabhu Raja Singh 09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   628 Rick James 09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   588 Prabhu Raja Singh 09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness   1,034 IGG t 08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness   533 Rick James 08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness   498 IGG t 08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness   486 Rick James 08/31/2013 05:35PM
mysql tables in use 500, locked 500   992 bruce.zuo bruce 07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500   552 Rick James 07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500   454 bruce.zuo bruce 07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500   403 Mattias Jonsson 08/13/2013 05:42AM
Create index on partition table (manually and dynamically)   1,896 Vladimir Pivovar 07/05/2013 11:26PM
Re: Create index on parttion table (manually and dynamically)   715 Rick James 07/06/2013 10:52PM
Re: Create index on parttion table (manually and dynamically)   649 Vladimir Pivovar 07/07/2013 12:20AM
Re: Create index on parttion table (manually and dynamically)   620 Vladimir Pivovar 07/07/2013 10:57AM
Re: Create index on parttion table (manually and dynamically)   668 Rick James 07/08/2013 09:46AM
Re: Create index on partition table (manually and dynamically)   695 Vladimir Pivovar 07/10/2013 02:23PM
how to remove partitiong in mysql version5.6   921 heiansan white 06/13/2013 01:41AM
Re: how to remove partitiong in mysql version5.6   506 Rick James 06/15/2013 01:50PM
No. of partitions in NDB cluster   833 Alax James 05/31/2013 02:14AM
IP vs Date Partition   1,003 Tim Linden 05/13/2013 10:28AM
Re: IP vs Date Partition   727 Rick James 05/14/2013 09:59PM
Re: IP vs Date Partition   731 Tim Linden 05/15/2013 10:06AM
How should I partition this table?   1,285 Ron Bergin 04/26/2013 09:18AM
Re: How should I partition this table?   717 Rick James 04/27/2013 09:58PM
Re: How should I partition this table?   632 Ron Bergin 04/28/2013 11:29AM
Re: How should I partition this table?   598 Rick James 04/29/2013 08:10AM
Re: How should I partition this table?   616 Ron Bergin 04/30/2013 08:39AM
Re: How should I partition this table?   601 Rick James 05/01/2013 11:45PM
Re: How should I partition this table?   596 Ron Bergin 05/02/2013 08:17AM
Re: How should I partition this table?   560 Ron Bergin 05/02/2013 11:55AM
Re: How should I partition this table?   600 Rick James 05/03/2013 09:00AM
Re: How should I partition this table?   595 Ron Bergin 05/03/2013 09:32AM
Performance doubt   1,063 Xavier Borrut 03/26/2013 06:41AM
Re: Performance doubt   618 Rick James 03/28/2013 12:34AM
Re: Performance doubt   272 Mattias Jonsson 04/09/2013 01:49AM
Event add partition works but not the drop partition   1,088 Frwa Onto 04/04/2013 11:22PM
Re: Event add partition works but not the drop partition   525 Frwa Onto 04/05/2013 04:13AM
Should I partition?   1,171 Jacob Steinberger 03/19/2013 02:57PM
Re: Should I partition?   739 Rick James 03/21/2013 08:49PM
Re: Should I partition?   655 NOT_FOUND NOT_FOUND 04/03/2013 10:08AM
Re: Should I partition?   595 Rick James 04/04/2013 11:35PM
Partitioned table problem after upgrade to 5.5   1,216 Ming Wang 03/06/2013 04:07AM
Re: Partitioned table problem after upgrade to 5.5   613 Mattias Jonsson 03/06/2013 04:38AM
Re: Partitioned table problem after upgrade to 5.5   613 Ming Wang 03/07/2013 08:23PM
Re: Partitioned table problem after upgrade to 5.5   550 Rick James 03/07/2013 11:32PM
Re: Partitioned table problem after upgrade to 5.5   609 Mattias Jonsson 03/08/2013 02:20AM
If you use a partition table in mysql5.5, Contact function   1,033 kyung gi lee 02/25/2013 03:12AM
Re: If you use a partition table in mysql5.5, Contact function   608 Rick James 02/28/2013 09:34AM
How to (temporary) disable one partition in the partitioned table   1,212 First Bell 02/13/2013 11:01PM
Re: How to (temporary) disable one partition in the partitioned table   723 Rick James 02/22/2013 01:00AM
Re: How to (temporary) disable one partition in the partitioned table   780 Mattias Jonsson 02/28/2013 05:51AM
Index with partitioning   1,330 Hélio Hélio 01/30/2013 06:23AM
Re: Index with partitioning   844 Rick James 02/01/2013 10:20PM
Re: Index with partitioning   840 Hélio Hélio 02/04/2013 08:03AM
Re: Index with partitioning   780 Rick James 02/07/2013 10:09PM
Re: Index with partitioning   828 Hélio Hélio 02/08/2013 06:55AM
Re: Index with partitioning   782 Rick James 02/09/2013 01:22PM
Re: Index with partitioning   920 Hélio Hélio 02/14/2013 12:26PM
MySQL Partitioning showing low performance   1,190 Manosh Manohar 02/05/2013 12:10AM
Re: MySQL Partitioning showing low performance   715 Rick James 02/07/2013 10:14PM
Re: MySQL Partitioning showing low performance   667 Manosh Manohar 02/08/2013 12:39AM
How to let the query run on one partition   1,376 Shawn Liu 01/09/2013 08:29AM
Re: How to let the query run on one partition   709 Rick James 01/10/2013 08:45PM
How to partition by City \ State   1,206 Noah Goodrich 12/19/2012 10:06PM
Re: How to partition by City \ State   739 Rick James 12/20/2012 10:00PM
Partition behaiour seems abnormal in range partition   1,334 Rahul K K 12/10/2012 12:05AM
Re: Partition behaiour seems abnormal in range partition   655 Rick James 12/20/2012 02:56PM
partition by range on decimal type   1,601 Greg K 11/20/2012 07:15AM
Re: partition by range on decimal type   822 Rick James 11/21/2012 10:39AM
Re: partition by range on decimal type   769 Greg K 11/22/2012 02:26AM
Re: partition by range on decimal type   778 Rick James 11/22/2012 11:02PM
Re: partition by range on decimal type   1,010 Greg K 11/23/2012 12:45AM
Re: partition by range on decimal type   1,039 Rick James 11/23/2012 09:03PM
Fortnight partitions   1,700 Srikanth Mamidi 11/19/2012 11:24PM
Re: Fortnight partitions   1,079 Rick James 11/20/2012 10:56PM
Re: Fortnight partitions   769 Srikanth Mamidi 11/20/2012 11:23PM
Re: Fortnight partitions   877 Rick James 11/21/2012 08:54PM
Re: Fortnight partitions   925 Srikanth Mamidi 11/23/2012 12:04AM
milliseconds in mysql equivalent to java for Partitioning   1,792 Manjunath C 11/12/2012 01:36AM
Re: milliseconds in mysql equivalent to java for Partitioning   1,014 Rick James 11/13/2012 09:15AM
Re: milliseconds in mysql equivalent to java for Partitioning   897 Manjunath C 11/14/2012 04:17AM
Partitioning not working need primary key?   1,909 newbie Shai 10/20/2012 11:12AM
Re: Partitioning not working need primary key?   1,087 Mattias Jonsson 10/22/2012 07:14AM
Re: Partitioning not working need primary key?   925 newbie Shai 10/22/2012 11:59AM
Re: Partitioning not working need primary key?   936 Rick James 10/22/2012 09:37PM
Re: Partitioning not working need primary key?   931 newbie Shai 10/23/2012 08:36AM
Re: Partitioning not working need primary key?   947 Rick James 10/23/2012 09:50AM
Re: Partitioning not working need primary key?   918 newbie Shai 10/24/2012 09:05AM
Re: Partitioning not working need primary key?   869 Rick James 10/24/2012 09:26PM
Re: Partitioning not working need primary key?   883 newbie Shai 10/25/2012 09:45PM
Re: Partitioning not working need primary key?   911 Rick James 10/25/2012 11:22PM
Re: Partitioning not working need primary key?   886 newbie Shai 10/27/2012 07:21AM
Re: Partitioning not working need primary key?   830 Rick James 10/27/2012 12:01PM
Re: Partitioning not working need primary key?   834 newbie Shai 10/28/2012 12:10PM
Re: Partitioning not working need primary key?   872 Rick James 10/28/2012 02:12PM
Re: Partitioning not working need primary key?   875 newbie Shai 11/01/2012 10:55AM
Re: Partitioning not working need primary key?   837 Rick James 11/02/2012 12:37AM
Re: Partitioning not working need primary key?   835 newbie Shai 11/03/2012 10:37AM
Re: Partitioning not working need primary key?   901 Rick James 11/03/2012 11:37AM
Re: Partitioning not working need primary key?   785 newbie Shai 10/29/2012 06:51PM
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.