Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Connector/NET 6.9.7 has been released 08/05/2015 06:38AM
MySQL Community Server 5.7.8 has been released (part 3/3) 08/03/2015 09:14AM
MySQL Community Server 5.7.8 has been released (part 2/3) 08/03/2015 09:12AM
MySQL Community Server 5.7.8 has been released (part 1/3) 08/03/2015 09:09AM
MySQL Enterprise Monitor 3.0.23 has been released 07/31/2015 12:40PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 of 13
Subject Views Written By Posted
list partitioning and range subpartitioning   1,277 jongse park 03/12/2012 02:35AM
Re: list partitioning and range subpartitioning   943 Mattias Jonsson 03/13/2012 07:23AM
I searched table on one partiton, but MySQL scanning two partitons   1,852 Yang Bingle 03/03/2012 04:01AM
Re: I searched table on one partiton, but MySQL scanning two partitons   1,037 Rick James 03/04/2012 02:28PM
I divided table on two parts, but MySQL scanning full table   2,346 oto shavadze 02/07/2012 11:27PM
Re: I divided table on two parts, but MySQL scanning full table   1,138 Rick James 02/08/2012 05:45PM
Re: I divided table on two parts, but MySQL scanning full table   1,099 oto shavadze 02/09/2012 11:12AM
Re: I divided table on two parts, but MySQL scanning full table   1,190 Rick James 02/11/2012 12:04AM
Re: I divided table on two parts, but MySQL scanning full table   1,134 oto shavadze 02/11/2012 01:10PM
KEY vs RANGE partitioning   2,056 Basilis Papadopoulos 02/08/2012 07:38AM
Re: KEY vs RANGE partitioning   1,250 Mattias Jonsson 02/09/2012 07:35AM
Re: KEY vs RANGE partitioning   1,046 Basilis Papadopoulos 02/09/2012 01:45AM
Re: KEY vs RANGE partitioning   1,374 Mattias Jonsson 02/09/2012 10:50AM
Re: KEY vs RANGE partitioning   1,164 Rick James 02/09/2012 04:22AM
How to divide the table into 1000 part   1,978 oto shavadze 02/06/2012 01:07AM
Re: How to divide the table into 1000 part   941 Rick James 02/07/2012 07:02PM
Re: How to divide the table into 1000 part   950 oto shavadze 02/08/2012 04:12AM
Suggestion for optimization - reg   1,954 suvendu mohapatra 01/23/2012 05:09AM
Re: Suggestion for optimization - reg   1,008 Rick James 01/24/2012 02:18AM
Re: Suggestion for optimization - reg   1,030 suvendu mohapatra 01/24/2012 06:50AM
Re: Suggestion for optimization - reg   926 Rick James 01/25/2012 09:09PM
Re: Suggestion for optimization - reg   954 suvendu mohapatra 01/26/2012 06:49AM
Re: Suggestion for optimization - reg   906 Rick James 01/26/2012 02:48PM
Re: Suggestion for optimization - reg   1,192 suvendu mohapatra 01/26/2012 04:32PM
Re: Suggestion for optimization - reg   948 Rick James 01/27/2012 08:41PM
Re: Suggestion for optimization - reg   1,028 suvendu mohapatra 01/25/2012 11:04PM
truncate partition not happening   2,246 samir devaliya 01/09/2012 08:06AM
Re: truncate partition not happening   1,348 Mattias Jonsson 01/12/2012 05:02AM
Re: truncate partition not happening   951 samir devaliya 01/13/2012 10:37PM
Re: truncate partition not happening   1,082 samir devaliya 01/16/2012 12:41AM
Re: truncate partition not happening   1,059 Mattias Jonsson 01/16/2012 04:22AM
Re: truncate partition not happening   998 Rick James 01/13/2012 09:58AM
Re: truncate partition not happening   1,336 Mattias Jonsson 01/13/2012 10:13AM
reorganize syntax / procedure   2,555 kevin foote 01/12/2012 03:36PM
Re: reorganize syntax / procedure   1,358 Rick James 01/13/2012 07:34PM
Re: reorganize syntax / procedure   1,963 Mattias Jonsson 01/13/2012 10:35AM
Re: reorganize syntax / procedure   1,009 kevin foote 01/13/2012 03:57PM
Best partitioning strategy VS shortest primary key   2,752 Jérémy Cohen Solal 12/19/2011 06:12AM
Re: Best partitioning strategy VS shortest primary key   1,276 Rick James 12/20/2011 10:31AM
Re: Best partitioning strategy VS shortest primary key   1,242 Jérémy Cohen Solal 12/21/2011 07:37AM
Re: Best partitioning strategy VS shortest primary key   1,607 Rick James 12/24/2011 03:03PM
partition with non primary key column   1,685 deva clementraj 12/09/2011 01:23AM
Re: partition with non primary key column   999 Rick James 12/13/2011 06:22PM
Re: partition with non primary key column   1,035 Mattias Jonsson 12/12/2011 06:34AM
Attaching a single partition to MySql on another server   1,780 Mirek K 11/29/2011 11:41AM
Re: Attaching a single partition to MySql on another server   1,161 Shantanu Oak 11/30/2011 05:00AM
Re: Attaching a single partition to MySql on another server   943 Mirek K 12/07/2011 03:48AM
Re: Attaching a single partition to MySql on another server   1,047 Mattias Jonsson 11/30/2011 02:24AM
Re: Attaching a single partition to MySql on another server   969 Mirek K 11/30/2011 06:02AM
Re: Attaching a single partition to MySql on another server   982 Mattias Jonsson 11/30/2011 06:12AM
Re: Attaching a single partition to MySql on another server   1,160 Rick James 11/30/2011 08:07PM
Partitioning Table - GPS Data   2,145 Daniel Alves 11/30/2011 01:53PM
Re: Partitioning Table - GPS Data   1,083 Daniel Alves 11/30/2011 03:15PM
Re: Partitioning Table - GPS Data   1,304 Rick James 12/01/2011 09:57PM
Re: Partitioning Table - GPS Data   965 Daniel Alves 12/02/2011 08:52AM
Re: Partitioning Table - GPS Data   1,009 Daniel Alves 12/02/2011 08:51AM
Re: Partitioning Table - GPS Data   1,144 Rick James 12/03/2011 10:26AM
Re: Partitioning Table - GPS Data   1,049 Daniel Alves 12/05/2011 05:43AM
Re: Partitioning Table - GPS Data   1,198 Rick James 12/06/2011 08:46PM
Multiple handlers per partition   1,413 Rolf Martin-Hoster 11/23/2011 10:26AM
Re: Multiple handlers per partition   958 Mattias Jonsson 11/30/2011 02:14AM
Data not balanced in partitions   1,826 Evan P 11/26/2011 05:41AM
Re: Data not balanced in partitions   955 Rick James 11/28/2011 11:25AM
Re: Data not balanced in partitions   873 Evan P 11/26/2011 12:34PM
Re: Data not balanced in partitions   1,098 Evan P 11/26/2011 12:51PM
can't create partitioning table   1,852 Jacky Shu 11/22/2011 10:26AM
Re: can't create partitioning table   819 Jacky Shu 11/24/2011 07:41AM
Re: can't create partitioning table   896 Rick James 11/24/2011 12:32AM
Partition Pruning   1,691 Scott Watson 11/14/2011 04:19PM
Re: Partition Pruning   952 Mattias Jonsson 11/21/2011 05:46AM
MyIsam partition by string   2,826 Chris XX 11/03/2011 09:32AM
Re: MyIsam partition by string   1,005 Mattias Jonsson 11/07/2011 03:12PM
Re: MyIsam partition by string   1,056 Rick James 11/05/2011 10:29PM
MySQl partitioning query issue   2,267 Madhu Venkatesh 11/02/2011 10:34AM
Re: MySQl partitioning query issue   974 Rick James 11/05/2011 08:42PM
Re: MySQl partitioning query issue   925 Madhu Venkatesh 11/02/2011 12:33PM
Partition Pruning Issue while using Day() function in Range   2,880 Battu Praveen Kumar 09/21/2011 04:00AM
Re: Partition Pruning Issue while using Day() function in Range   1,132 Rick James 09/23/2011 09:22AM
Re: Partition Pruning Issue while using Day() function in Range   1,401 Battu Praveen Kumar 10/02/2011 11:10PM
Re: Partition Pruning Issue while using Day() function in Range   1,137 Rick James 10/09/2011 01:44PM
Re: Partition Pruning Issue while using Day() function in Range   1,281 Mattias Jonsson 09/22/2011 03:36AM
Partition by State   2,758 Dustin Teter 07/11/2011 01:23PM
Re: Partition by State   963 nugik wibowo 09/24/2011 10:45AM
Re: Partition by State   1,185 Rick James 07/14/2011 01:16AM
Constant, random or timezone-dependent expressions in (sub)partitioning   3,500 Carlo Rossetti 09/18/2011 02:39AM
Re: Constant, random or timezone-dependent expressions in (sub)partitioning   1,794 Mattias Jonsson 09/19/2011 09:17AM
Re: Constant, random or timezone-dependent expressions in (sub)partitioning   1,284 Carlo Rossetti 09/19/2011 10:40AM
ALTER TABLE t_test ADD PARTITION BY LIST(field)?   3,560 Carlo Rossetti 09/18/2011 03:27AM
Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?   5,382 Mattias Jonsson 09/19/2011 09:10AM
Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?   1,421 Carlo Rossetti 09/19/2011 10:38AM
Question regarding Partitioning by key   1,950 kuku kuku 08/28/2011 03:47PM
Re: Question regarding Partitioning by key   1,010 Rick James 08/30/2011 09:35AM
Does my database server support partioning and Sharding   2,861 David Usherwood 08/26/2011 06:29AM
Re: Does my database server support partioning and Sharding   1,022 Rick James 08/27/2011 09:01AM
Re: Does my database server support partioning and Sharding   1,049 Liran Zelkha 08/29/2011 08:30AM
Can I add/change the number of hash subpartition?   2,787 Osamu Shibata 08/22/2011 12:11PM
Re: Can I add/change the number of hash subpartition?   1,740 Mattias Jonsson 08/26/2011 04:13AM
Re: Can I add/change the number of hash subpartition?   1,030 Rick James 08/25/2011 05:42PM
innodb_data_file_path and innodb_file_per_table   2,604 Rama Surendra Babu Gudimetla 08/25/2011 03:22AM
Re: innodb_data_file_path and innodb_file_per_table   1,206 Rick James 08/25/2011 10:27PM
ENUM partitioning options?   2,751 Nicholas Semenkovich 08/15/2011 10:48AM
Re: ENUM partitioning options?   1,137 Rick James 08/16/2011 09:50AM
Tablespace   2,182 katie c 08/05/2011 12:03AM
Re: Tablespace   926 Rick James 08/09/2011 07:29PM
500 mil. rows table partitioning   2,653 Misha Krassovski 06/27/2011 09:15AM
Re: 500 mil. rows table partitioning   1,490 Rick James 07/01/2011 06:22PM
Re: 500 mil. rows table partitioning   1,204 Misha Krassovski 07/13/2011 02:43PM
Re: 500 mil. rows table partitioning   1,155 Rick James 07/14/2011 12:51AM
Re: 500 mil. rows table partitioning   1,132 Misha Krassovski 07/15/2011 12:42PM
Re: 500 mil. rows table partitioning   1,162 Rick James 07/15/2011 07:59PM
Re: 500 mil. rows table partitioning   1,124 Misha Krassovski 07/21/2011 09:40AM
Re: 500 mil. rows table partitioning   1,201 Rick James 07/21/2011 08:46PM
Re: 500 mil. rows table partitioning   1,431 Misha Krassovski 07/27/2011 06:27AM
Re: 500 mil. rows table partitioning   1,161 Rick James 07/30/2011 06:14PM
Partitions for already existing table   2,584 Alexander Karavaev 07/29/2011 03:43AM
Re: Partitions for already existing table   1,105 Rick James 07/30/2011 04:18PM
Is partitioning helpful in this case?   2,291 Aries Belgium 05/22/2011 04:18AM
Re: Is partitioning helpful in this case?   931 Mattias Jonsson 07/25/2011 04:41AM
Re: Is partitioning helpful in this case?   1,194 Shantanu Oak 06/28/2011 12:01AM
Re: Is partitioning helpful in this case?   1,108 Rick James 05/25/2011 08:07PM
I'm trying to range partition and i'm getting this error   2,244 john hango 07/20/2011 03:18AM
Re: I'm trying to range partition and i'm getting this error   960 john hango 07/20/2011 03:40AM
Re: I'm trying to range partition and i'm getting this error   1,106 Rick James 07/21/2011 10:37AM
How to partition that table?   3,389 Klaus Redegeld 06/30/2011 07:49AM
Re: How to partition that table?   1,521 Rick James 07/01/2011 11:25PM
Re: How to partition that table?   1,350 Klaus Redegeld 07/03/2011 03:27AM
Re: How to partition that table?   1,400 Rick James 07/03/2011 11:42AM
Partitioning by year and day   2,187 Adam Israel 06/16/2011 01:52AM
Re: Partitioning by year and day   1,128 Rick James 06/17/2011 09:34AM
Re: Partitioning by year and day   1,149 Adam Israel 06/17/2011 09:48AM
alter table partition and insert at same time   2,738 erd tas 06/13/2011 12:38AM
Re: alter table partition and insert at same time   982 Rick James 06/15/2011 11:50PM
Any difference in no-condition-group-by between on partition table and non-partition table?   3,306 Ming Lu 04/13/2011 09:46PM
Re: Any difference in no-condition-group-by between on partition table and non-partition table?   1,100 Rick James 04/14/2011 11:45PM
Re: Any difference in no-condition-group-by between on partition table and non-partition table?   1,197 Mattias Jonsson 05/02/2011 02:44AM
Re: Any difference in no-condition-group-by between on partition table and non-partition table?   1,245 Ming Lu 06/08/2011 09:47AM
REORGANIZE PARTITION Stuck: (status = setup)   3,441 Shaun Martinec 06/01/2011 07:36PM
Re: REORGANIZE PARTITION Stuck: (status = setup)   1,753 Shaun Martinec 06/01/2011 07:46PM
Re: REORGANIZE PARTITION Stuck: (status = setup)   2,072 Mattias Jonsson 06/03/2011 03:23AM
Re: REORGANIZE PARTITION Stuck: (status = setup)   2,002 Shaun Martinec 06/03/2011 08:28AM
Re: REORGANIZE PARTITION Stuck: (status = setup)   1,672 Mattias Jonsson 06/03/2011 02:01PM
Re: REORGANIZE PARTITION Stuck: (status = setup)   1,663 Rick James 06/02/2011 10:34PM
Partitioning & Tablespace   3,725 Lazuardi Nasution 05/29/2011 10:13AM
Re: Partitioning & Tablespace   1,390 Mattias Jonsson 05/31/2011 03:40PM
Re: Partitioning & Tablespace   1,326 Lazuardi Nasution 05/31/2011 07:58PM
Re: Partitioning & Tablespace   2,036 Mattias Jonsson 06/01/2011 03:57AM
Re: Partitioning & Tablespace   1,342 Lazuardi Nasution 06/02/2011 12:43AM
Re: Partitioning & Tablespace   1,269 Mattias Jonsson 06/02/2011 01:02PM
Re: Partitioning & Tablespace   1,125 Lazuardi Nasution 06/02/2011 08:44PM
Re: Partitioning & Tablespace   1,379 Rick James 06/02/2011 07:19PM
Re: Partitioning & Tablespace   1,560 Rick James 06/01/2011 07:34PM
Large Table Architecture   3,803 Darren Mitchell 05/24/2011 12:55PM
Re: Large Table Architecture   2,259 Rick James 05/25/2011 07:45PM
Re: Large Table Architecture   1,296 Darren Mitchell 05/25/2011 09:33PM
Re: Large Table Architecture   1,365 Rick James 05/25/2011 11:31PM
Re: Large Table Architecture   1,134 Darren Mitchell 05/26/2011 09:49AM
Re: Large Table Architecture   1,539 Rick James 05/26/2011 10:52AM
partition and subpartitioning help   2,811 deva clementraj 05/11/2011 04:01AM
Re: partition and subpartitioning help   1,046 Rick James 05/12/2011 10:45PM
Re: partition and subpartitioning help   1,175 deva clementraj 05/18/2011 06:26AM
Re: partition and subpartitioning help   1,050 Rick James 05/18/2011 11:15PM
Re: partition and subpartitioning help   1,052 deva clementraj 05/18/2011 06:13AM
speed up the data retriving   2,676 deva clementraj 04/28/2011 04:41AM
Re: speed up the data retriving   1,386 Rick James 04/29/2011 08:37AM
Re: speed up the data retriving   1,610 deva clementraj 05/02/2011 05:37AM
Re: speed up the data retriving   1,453 Rick James 05/02/2011 11:46PM
Re: speed up the data retriving   1,251 deva clementraj 05/04/2011 10:48PM
Re: speed up the data retriving   1,402 Rick James 05/05/2011 12:50AM
Re: speed up the data retriving   1,115 deva clementraj 05/05/2011 01:25AM
Solve this partition puzzle   2,712 santhosh edukulla 04/20/2011 04:22AM
Re: Solve this partition puzzle   923 Mattias Jonsson 05/02/2011 02:48AM
Re: Solve this partition puzzle   914 Rick James 04/22/2011 12:07AM
data not storing in the correct partition   1,740 deva clementraj 04/28/2011 05:18AM
Re: data not storing in the correct partition   791 Rick James 04/29/2011 08:36AM
create partition with index and unique key   2,180 deva clementraj 04/28/2011 04:01AM
RE:How to make Partition for mytable   1,732 venkat puvvada 04/12/2011 11:40PM
Re: RE:How to make Partition for mytable   876 Rick James 04/15/2011 10:16PM
RE:how to make partititon for my table as required   2,505 venkat puvvada 04/13/2011 01:11AM
Re: RE:how to make partititon for my table as required   796 Rick James 04/14/2011 08:01AM
Removing data from partitioned table   2,112 santhosh edukulla 04/06/2011 12:22AM
Partitioning and multiple threads   2,677 Manish Nema 03/29/2011 05:26AM
Re: Partitioning and multiple threads   919 Rick James 03/31/2011 10:05PM
Partitions   2,001 Ranga Pulavarthi 03/28/2011 02:38AM
Re: Partitions   850 Rick James 03/29/2011 08:20AM
Partitioning table by timestamp column type   3,029 zlatko josic 03/24/2011 07:00AM
Re: Partitioning table by timestamp column type   1,465 Rick James 03/25/2011 09:14AM
Re: Partitioning table by timestamp column type   1,354 zlatko josic 03/25/2011 03:03PM
Re: Partitioning table by timestamp column type   960 Rick James 03/25/2011 07:02PM
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
This topic has been moved.:  Partitions   0 Ranga Pulavarthi 03/28/2011 06:54AM
This topic has been moved.:  Partitioning table by timestamp column type   0 zlatko josic 03/24/2011 07:07AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 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.