Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
• MySQL Connector/Python 1.0.10 has been released 05/07/2013 12:33AM
• MySQL Connector/J 5.1.25 has been released 05/06/2013 10:30AM
• MySQL Connector/C 6.1.0 has been released 05/02/2013 02:28PM
• MySQL Connector/ODBC 5.2.5 has been released 05/02/2013 02:26PM
• MySQL for Excel 1.1.1 (GA) has been released 04/26/2013 04:33PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 12
Subject Views Written By Posted
partitions to quickly drop lots of data each month   1,123 Darren White 03/22/2012 02:20AM
Re: partitions to quickly drop lots of data each month   656 Rick James 03/22/2012 09:56PM
Move from unpartitioned database to partitioned database   1,494 Piyush Maheshwari 03/19/2012 07:43AM
Re: Move from unpartitioned database to partitioned database   915 Mattias Jonsson 03/20/2012 01:21AM
Re: Move from unpartitioned database to partitioned database   766 Piyush Maheshwari 03/20/2012 03:39AM
Re: Move from unpartitioned database to partitioned database   755 Mattias Jonsson 03/20/2012 03:56AM
Re: Move from unpartitioned database to partitioned database   997 Rick James 03/22/2012 07:48PM
list partitioning and range subpartitioning   910 jongse park 03/12/2012 02:35AM
Re: list partitioning and range subpartitioning   653 Mattias Jonsson 03/13/2012 07:23AM
I searched table on one partiton, but MySQL scanning two partitons   1,084 Yang Bingle 03/03/2012 04:01AM
Re: I searched table on one partiton, but MySQL scanning two partitons   691 Rick James 03/04/2012 02:28PM
I divided table on two parts, but MySQL scanning full table   1,671 oto shavadze 02/07/2012 11:27PM
Re: I divided table on two parts, but MySQL scanning full table   814 Rick James 02/08/2012 05:45PM
Re: I divided table on two parts, but MySQL scanning full table   748 oto shavadze 02/09/2012 11:12AM
Re: I divided table on two parts, but MySQL scanning full table   753 Rick James 02/11/2012 12:04AM
Re: I divided table on two parts, but MySQL scanning full table   823 oto shavadze 02/11/2012 01:10PM
KEY vs RANGE partitioning   1,406 Basilis Papadopoulos 02/08/2012 07:38AM
Re: KEY vs RANGE partitioning   834 Mattias Jonsson 02/09/2012 07:35AM
Re: KEY vs RANGE partitioning   697 Basilis Papadopoulos 02/09/2012 01:45AM
Re: KEY vs RANGE partitioning   989 Mattias Jonsson 02/09/2012 10:50AM
Re: KEY vs RANGE partitioning   770 Rick James 02/09/2012 04:22AM
How to divide the table into 1000 part   1,401 oto shavadze 02/06/2012 01:07AM
Re: How to divide the table into 1000 part   723 Rick James 02/07/2012 07:02PM
Re: How to divide the table into 1000 part   731 oto shavadze 02/08/2012 04:12AM
Suggestion for optimization - reg   1,354 suvendu mohapatra 01/23/2012 05:09AM
Re: Suggestion for optimization - reg   744 Rick James 01/24/2012 02:18AM
Re: Suggestion for optimization - reg   767 suvendu mohapatra 01/24/2012 06:50AM
Re: Suggestion for optimization - reg   633 Rick James 01/25/2012 09:09PM
Re: Suggestion for optimization - reg   649 suvendu mohapatra 01/26/2012 06:49AM
Re: Suggestion for optimization - reg   605 Rick James 01/26/2012 02:48PM
Re: Suggestion for optimization - reg   836 suvendu mohapatra 01/26/2012 04:32PM
Re: Suggestion for optimization - reg   649 Rick James 01/27/2012 08:41PM
Re: Suggestion for optimization - reg   670 suvendu mohapatra 01/25/2012 11:04PM
truncate partition not happening   1,605 samir devaliya 01/09/2012 08:06AM
Re: truncate partition not happening   991 Mattias Jonsson 01/12/2012 05:02AM
Re: truncate partition not happening   715 samir devaliya 01/13/2012 10:37PM
Re: truncate partition not happening   803 samir devaliya 01/16/2012 12:41AM
Re: truncate partition not happening   776 Mattias Jonsson 01/16/2012 04:22AM
Re: truncate partition not happening   732 Rick James 01/13/2012 09:58AM
Re: truncate partition not happening   944 Mattias Jonsson 01/13/2012 10:13AM
reorganize syntax / procedure   1,687 kevin foote 01/12/2012 03:36PM
Re: reorganize syntax / procedure   915 Rick James 01/13/2012 07:34PM
Re: reorganize syntax / procedure   1,084 Mattias Jonsson 01/13/2012 10:35AM
Re: reorganize syntax / procedure   719 kevin foote 01/13/2012 03:57PM
Best partitioning strategy VS shortest primary key   1,739 Jérémy Cohen Solal 12/19/2011 06:12AM
Re: Best partitioning strategy VS shortest primary key   862 Rick James 12/20/2011 10:31AM
Re: Best partitioning strategy VS shortest primary key   834 Jérémy Cohen Solal 12/21/2011 07:37AM
Re: Best partitioning strategy VS shortest primary key   1,117 Rick James 12/24/2011 03:03PM
partition with non primary key column   1,343 deva clementraj 12/09/2011 01:23AM
Re: partition with non primary key column   709 Rick James 12/13/2011 06:22PM
Re: partition with non primary key column   764 Mattias Jonsson 12/12/2011 06:34AM
Attaching a single partition to MySql on another server   1,285 Mirek K 11/29/2011 11:41AM
Re: Attaching a single partition to MySql on another server   748 Shantanu Oak 11/30/2011 05:00AM
Re: Attaching a single partition to MySql on another server   666 Mirek K 12/07/2011 03:48AM
Re: Attaching a single partition to MySql on another server   732 Mattias Jonsson 11/30/2011 02:24AM
Re: Attaching a single partition to MySql on another server   682 Mirek K 11/30/2011 06:02AM
Re: Attaching a single partition to MySql on another server   730 Mattias Jonsson 11/30/2011 06:12AM
Re: Attaching a single partition to MySql on another server   837 Rick James 11/30/2011 08:07PM
Partitioning Table - GPS Data   1,323 Daniel Alves 11/30/2011 01:53PM
Re: Partitioning Table - GPS Data   780 Daniel Alves 11/30/2011 03:15PM
Re: Partitioning Table - GPS Data   973 Rick James 12/01/2011 09:57PM
Re: Partitioning Table - GPS Data   637 Daniel Alves 12/02/2011 08:52AM
Re: Partitioning Table - GPS Data   595 Daniel Alves 12/02/2011 08:51AM
Re: Partitioning Table - GPS Data   712 Rick James 12/03/2011 10:26AM
Re: Partitioning Table - GPS Data   737 Daniel Alves 12/05/2011 05:43AM
Re: Partitioning Table - GPS Data   882 Rick James 12/06/2011 08:46PM
Multiple handlers per partition   1,010 Rolf Martin-Hoster 11/23/2011 10:26AM
Re: Multiple handlers per partition   646 Mattias Jonsson 11/30/2011 02:14AM
Data not balanced in partitions   1,307 Evan P 11/26/2011 05:41AM
Re: Data not balanced in partitions   656 Rick James 11/28/2011 11:25AM
Re: Data not balanced in partitions   640 Evan P 11/26/2011 12:34PM
Re: Data not balanced in partitions   774 Evan P 11/26/2011 12:51PM
can't create partitioning table   1,340 Jacky Shu 11/22/2011 10:26AM
Re: can't create partitioning table   587 Jacky Shu 11/24/2011 07:41AM
Re: can't create partitioning table   620 Rick James 11/24/2011 12:32AM
Partition Pruning   1,174 Scott Watson 11/14/2011 04:19PM
Re: Partition Pruning   715 Mattias Jonsson 11/21/2011 05:46AM
MyIsam partition by string   2,013 Chris XX 11/03/2011 09:32AM
Re: MyIsam partition by string   686 Mattias Jonsson 11/07/2011 03:12PM
Re: MyIsam partition by string   721 Rick James 11/05/2011 10:29PM
MySQl partitioning query issue   1,723 Madhu Venkatesh 11/02/2011 10:34AM
Re: MySQl partitioning query issue   675 Rick James 11/05/2011 08:42PM
Re: MySQl partitioning query issue   666 Madhu Venkatesh 11/02/2011 12:33PM
Partition Pruning Issue while using Day() function in Range   2,088 Battu Praveen Kumar 09/21/2011 04:00AM
Re: Partition Pruning Issue while using Day() function in Range   761 Rick James 09/23/2011 09:22AM
Re: Partition Pruning Issue while using Day() function in Range   979 Battu Praveen Kumar 10/02/2011 11:10PM
Re: Partition Pruning Issue while using Day() function in Range   761 Rick James 10/09/2011 01:44PM
Re: Partition Pruning Issue while using Day() function in Range   934 Mattias Jonsson 09/22/2011 03:36AM
Partition by State   2,054 Dustin Teter 07/11/2011 01:23PM
Re: Partition by State   687 nugik wibowo 09/24/2011 10:45AM
Re: Partition by State   789 Rick James 07/14/2011 01:16AM
Constant, random or timezone-dependent expressions in (sub)partitioning   2,503 Carlo Rossetti 09/18/2011 02:39AM
Re: Constant, random or timezone-dependent expressions in (sub)partitioning   1,269 Mattias Jonsson 09/19/2011 09:17AM
Re: Constant, random or timezone-dependent expressions in (sub)partitioning   940 Carlo Rossetti 09/19/2011 10:40AM
ALTER TABLE t_test ADD PARTITION BY LIST(field)?   2,328 Carlo Rossetti 09/18/2011 03:27AM
Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?   2,054 Mattias Jonsson 09/19/2011 09:10AM
Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?   983 Carlo Rossetti 09/19/2011 10:38AM
Question regarding Partitioning by key   1,431 kuku kuku 08/28/2011 03:47PM
Re: Question regarding Partitioning by key   738 Rick James 08/30/2011 09:35AM
Does my database server support partioning and Sharding   2,234 David Usherwood 08/26/2011 06:29AM
Re: Does my database server support partioning and Sharding   715 Rick James 08/27/2011 09:01AM
Re: Does my database server support partioning and Sharding   836 Liran Zelkha 08/29/2011 08:30AM
Can I add/change the number of hash subpartition?   2,173 Osamu Shibata 08/22/2011 12:11PM
Re: Can I add/change the number of hash subpartition?   1,294 Mattias Jonsson 08/26/2011 04:13AM
Re: Can I add/change the number of hash subpartition?   766 Rick James 08/25/2011 05:42PM
innodb_data_file_path and innodb_file_per_table   2,092 Rama Surendra Babu Gudimetla 08/25/2011 03:22AM
Re: innodb_data_file_path and innodb_file_per_table   935 Rick James 08/25/2011 10:27PM
ENUM partitioning options?   2,044 Nicholas Semenkovich 08/15/2011 10:48AM
Re: ENUM partitioning options?   822 Rick James 08/16/2011 09:50AM
ERROR 1062 (23000) at line 1: Duplicate entry   6,468 Jens Bijell 07/20/2011 07:53AM
Re: ERROR 1062 (23000) at line 1: Duplicate entry   2,685 Rick James 07/21/2011 09:24AM
Re: ERROR 1062 (23000) at line 1: Duplicate entry   2,245 Jens Bijell 08/04/2011 05:15AM
Re: ERROR 1062 (23000) at line 1: Duplicate entry   1,628 Rick James 08/09/2011 07:33PM
Tablespace   1,514 katie c 08/05/2011 12:03AM
Re: Tablespace   691 Rick James 08/09/2011 07:29PM
500 mil. rows table partitioning   2,105 Misha Krassovski 06/27/2011 09:15AM
Re: 500 mil. rows table partitioning   1,107 Rick James 07/01/2011 06:22PM
Re: 500 mil. rows table partitioning   808 Misha Krassovski 07/13/2011 02:43PM
Re: 500 mil. rows table partitioning   762 Rick James 07/14/2011 12:51AM
Re: 500 mil. rows table partitioning   693 Misha Krassovski 07/15/2011 12:42PM
Re: 500 mil. rows table partitioning   796 Rick James 07/15/2011 07:59PM
Re: 500 mil. rows table partitioning   662 Misha Krassovski 07/21/2011 09:40AM
Re: 500 mil. rows table partitioning   841 Rick James 07/21/2011 08:46PM
Re: 500 mil. rows table partitioning   1,126 Misha Krassovski 07/27/2011 06:27AM
Re: 500 mil. rows table partitioning   840 Rick James 07/30/2011 06:14PM
Partitions for already existing table   2,125 Alexander Karavaev 07/29/2011 03:43AM
Re: Partitions for already existing table   912 Rick James 07/30/2011 04:18PM
Is partitioning helpful in this case?   1,826 Aries Belgium 05/22/2011 04:18AM
Re: Is partitioning helpful in this case?   726 Mattias Jonsson 07/25/2011 04:41AM
Re: Is partitioning helpful in this case?   857 Shantanu Oak 06/28/2011 12:01AM
Re: Is partitioning helpful in this case?   787 Rick James 05/25/2011 08:07PM
I'm trying to range partition and i'm getting this error   1,538 john hango 07/20/2011 03:18AM
Re: I'm trying to range partition and i'm getting this error   736 john hango 07/20/2011 03:40AM
Re: I'm trying to range partition and i'm getting this error   830 Rick James 07/21/2011 10:37AM
How to partition that table?   2,042 Klaus Redegeld 06/30/2011 07:49AM
Re: How to partition that table?   957 Rick James 07/01/2011 11:25PM
Re: How to partition that table?   837 Klaus Redegeld 07/03/2011 03:27AM
Re: How to partition that table?   979 Rick James 07/03/2011 11:42AM
Partitioning by year and day   1,650 Adam Israel 06/16/2011 01:52AM
Re: Partitioning by year and day   822 Rick James 06/17/2011 09:34AM
Re: Partitioning by year and day   795 Adam Israel 06/17/2011 09:48AM
alter table partition and insert at same time   1,949 erd tas 06/13/2011 12:38AM
Re: alter table partition and insert at same time   709 Rick James 06/15/2011 11:50PM
Any difference in no-condition-group-by between on partition table and non-partition table?   2,607 Ming Lu 04/13/2011 09:46PM
Re: Any difference in no-condition-group-by between on partition table and non-partition table?   831 Rick James 04/14/2011 11:45PM
Re: Any difference in no-condition-group-by between on partition table and non-partition table?   840 Mattias Jonsson 05/02/2011 02:44AM
Re: Any difference in no-condition-group-by between on partition table and non-partition table?   943 Ming Lu 06/08/2011 09:47AM
REORGANIZE PARTITION Stuck: (status = setup)   2,740 Shaun Martinec 06/01/2011 07:36PM
Re: REORGANIZE PARTITION Stuck: (status = setup)   1,202 Shaun Martinec 06/01/2011 07:46PM
Re: REORGANIZE PARTITION Stuck: (status = setup)   1,530 Mattias Jonsson 06/03/2011 03:23AM
Re: REORGANIZE PARTITION Stuck: (status = setup)   1,597 Shaun Martinec 06/03/2011 08:28AM
Re: REORGANIZE PARTITION Stuck: (status = setup)   1,338 Mattias Jonsson 06/03/2011 02:01PM
Re: REORGANIZE PARTITION Stuck: (status = setup)   1,315 Rick James 06/02/2011 10:34PM
Partitioning & Tablespace   3,046 Lazuardi Nasution 05/29/2011 10:13AM
Re: Partitioning & Tablespace   1,015 Mattias Jonsson 05/31/2011 03:40PM
Re: Partitioning & Tablespace   965 Lazuardi Nasution 05/31/2011 07:58PM
Re: Partitioning & Tablespace   1,599 Mattias Jonsson 06/01/2011 03:57AM
Re: Partitioning & Tablespace   868 Lazuardi Nasution 06/02/2011 12:43AM
Re: Partitioning & Tablespace   918 Mattias Jonsson 06/02/2011 01:02PM
Re: Partitioning & Tablespace   772 Lazuardi Nasution 06/02/2011 08:44PM
Re: Partitioning & Tablespace   949 Rick James 06/02/2011 07:19PM
Re: Partitioning & Tablespace   1,141 Rick James 06/01/2011 07:34PM
Large Table Architecture   2,782 Darren Mitchell 05/24/2011 12:55PM
Re: Large Table Architecture   1,676 Rick James 05/25/2011 07:45PM
Re: Large Table Architecture   958 Darren Mitchell 05/25/2011 09:33PM
Re: Large Table Architecture   954 Rick James 05/25/2011 11:31PM
Re: Large Table Architecture   784 Darren Mitchell 05/26/2011 09:49AM
Re: Large Table Architecture   1,182 Rick James 05/26/2011 10:52AM
partition and subpartitioning help   2,275 deva clementraj 05/11/2011 04:01AM
Re: partition and subpartitioning help   756 Rick James 05/12/2011 10:45PM
Re: partition and subpartitioning help   892 deva clementraj 05/18/2011 06:26AM
Re: partition and subpartitioning help   715 Rick James 05/18/2011 11:15PM
Re: partition and subpartitioning help   738 deva clementraj 05/18/2011 06:13AM
speed up the data retriving   2,126 deva clementraj 04/28/2011 04:41AM
Re: speed up the data retriving   1,116 Rick James 04/29/2011 08:37AM
Re: speed up the data retriving   1,233 deva clementraj 05/02/2011 05:37AM
Re: speed up the data retriving   1,192 Rick James 05/02/2011 11:46PM
Re: speed up the data retriving   957 deva clementraj 05/04/2011 10:48PM
Re: speed up the data retriving   1,114 Rick James 05/05/2011 12:50AM
Re: speed up the data retriving   852 deva clementraj 05/05/2011 01:25AM
Solve this partition puzzle   2,274 santhosh edukulla 04/20/2011 04:22AM
Re: Solve this partition puzzle   634 Mattias Jonsson 05/02/2011 02:48AM
Re: Solve this partition puzzle   644 Rick James 04/22/2011 12:07AM
Create Partition   2,039 Aniket Bochare 04/27/2011 03:10PM
Re: Create Partition   635 Rick James 04/29/2011 08:47AM
data not storing in the correct partition   1,375 deva clementraj 04/28/2011 05:18AM
Re: data not storing in the correct partition   592 Rick James 04/29/2011 08:36AM
create partition with index and unique key   1,534 deva clementraj 04/28/2011 04:01AM
RE:How to make Partition for mytable   1,378 venkat puvvada 04/12/2011 11:40PM
Re: RE:How to make Partition for mytable   653 Rick James 04/15/2011 10:16PM
RE:how to make partititon for my table as required   2,078 venkat puvvada 04/13/2011 01:11AM
Re: RE:how to make partititon for my table as required   615 Rick James 04/14/2011 08:01AM
This topic has been moved.:  MyIsam partition by string   0 Chris XX 11/03/2011 07:41AM
This topic has been moved.:  MySQl partitioning query issue   6 Madhu Venkatesh 11/02/2011 12:50PM
This topic has been moved.:  Question regarding Partitioning by key   0 kuku kuku 08/28/2011 08:28PM
This topic has been moved.:  I'm trying to range partition and i'm getting this error   0 john hango 07/20/2011 05:58AM
This topic has been moved.:  alter table partition and insert at same time   0 erd tas 06/13/2011 09:18AM
This topic has been moved.:  Large Table Architecture   0 Darren Mitchell 05/26/2011 08:12AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 12
powered by phorum

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.