Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
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
MySQL for Visual Studio 1.2.4 has been released 07/28/2015 01:57AM
Current Page: 5 of 12
Subject Views Written By Posted
Partition Pruning based on subquery / join result   3,299 Justin Holdsworth 07/09/2010 03:54AM
Re: Partition Pruning based on subquery / join result   1,502 Rick James 07/11/2010 11:30AM
Re: Partition Pruning based on subquery / join result   1,477 Justin Holdsworth 07/12/2010 05:05AM
Re: Partition Pruning based on subquery / join result   1,424 Rick James 07/12/2010 11:41PM
Re: Partition Pruning based on subquery / join result   1,477 Justin Holdsworth 07/13/2010 09:33AM
Partition table not support foreign key feature ?   2,262 Mayur P Vegad 06/30/2010 04:41AM
Re: Partition table not support foreign key feature ?   1,126 Rick James 07/01/2010 11:12PM
Re: Partition table not support foreign key feature ?   1,641 Mayur P Vegad 07/02/2010 05:05AM
Re: Partition table not support foreign key feature ?   1,442 Rick James 07/03/2010 12:35AM
Strange first partition behavior while pruning on table partitioned by date.   2,442 Alexey Efremov 06/29/2010 09:46AM
Re: Strange first partition behavior while pruning on table partitioned by date.   1,170 Rick James 06/30/2010 08:51PM
Re: Strange first partition behavior while pruning on table partitioned by date.   1,091 Alexey Efremov 07/01/2010 06:10AM
Exceptions with Partition Pruning   3,013 ratheesh balakrishnan 06/10/2010 04:36PM
Re: Exceptions with Partition Pruning   1,364 Rick James 06/12/2010 01:21AM
Re: Exceptions with Partition Pruning   1,276 ratheesh balakrishnan 06/14/2010 01:10PM
Re: Exceptions with Partition Pruning   1,204 Rick James 06/16/2010 09:31AM
Re: Exceptions with Partition Pruning   1,370 ratheesh balakrishnan 06/16/2010 05:28PM
Rebuilding vs. Optimizing Partition, Time Elapsed to complete   2,265 Thomas Lekai 06/07/2010 04:12PM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete   1,404 Mattias Jonsson 06/15/2010 04:51AM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete   1,365 Rick James 06/09/2010 09:40AM
Lock wait timeouts and partitioning   1,952 Mark Richman 06/05/2010 07:47AM
Re: Lock wait timeouts and partitioning   1,258 Rick James 06/06/2010 08:53AM
Re: Lock wait timeouts and partitioning   1,270 Mattias Jonsson 06/15/2010 04:42AM
Huge Disk Write while performing delete operation   2,069 Ramesh Kumar 06/10/2010 10:17PM
Re: Huge Disk Write while performing delete operation   1,096 Rick James 06/12/2010 12:50AM
Linear Partioning vs Ordinary   3,629 Double Dragon 03/15/2010 02:31AM
Re: Linear Partioning vs Ordinary   1,337 ratheesh balakrishnan 06/11/2010 04:09PM
Re: Linear Partioning vs Ordinary   1,724 Mattias Jonsson 03/24/2010 09:23AM
Re: Linear Partioning vs Ordinary   1,735 Rick James 03/19/2010 08:09AM
Can not partition existings tables   2,238 Olivier Bourdon 06/03/2010 04:06AM
Re: Can not partition existings tables   1,342 Rick James 06/04/2010 08:22PM
Re: Can not partition existings tables   1,347 Olivier Bourdon 06/07/2010 03:55AM
Re: Can not partition existings tables   1,294 Rick James 06/07/2010 11:18PM
Key Partition Performance Measurement   3,142 Imran Pathan 05/25/2010 01:05AM
Re: Key Partition Performance Measurement   1,343 Rick James 05/28/2010 11:39PM
Re: Key Partition Performance Measurement   1,287 Imran Pathan 05/27/2010 05:43AM
SOLVED; DISK USAGE When Alter table HASH   1,992 Hawk T 05/25/2010 03:29PM
Re: DISK USAGE When Alter table HASH   1,209 Hawk T 05/26/2010 09:22AM
Mystified by Partition Pruning on Dates   2,059 John Thompson 05/19/2010 03:45AM
Re: Mystified by Partition Pruning on Dates   1,277 Rick James 05/20/2010 07:58AM
Re: Mystified by Partition Pruning on Dates   1,335 John Thompson 05/20/2010 08:35AM
How to handle secondary keys in partitioning?   2,752 John Smith 05/04/2010 12:46AM
Re: How to handle secondary keys in partitioning?   1,587 Mattias Jonsson 05/05/2010 02:20AM
Re: How to handle secondary keys in partitioning?   1,882 John Smith 05/06/2010 12:34AM
Re: How to handle secondary keys in partitioning?   1,503 Rick James 05/06/2010 12:04AM
Re: How to handle secondary keys in partitioning?   1,724 Mattias Jonsson 05/06/2010 03:23PM
Re: How to handle secondary keys in partitioning?   1,387 John Smith 05/06/2010 10:50PM
Re: How to handle secondary keys in partitioning?   1,452 Mattias Jonsson 05/12/2010 05:29AM
Re: How to handle secondary keys in partitioning?   1,485 Mattias Jonsson 05/07/2010 02:38AM
Re: How to handle secondary keys in partitioning?   1,426 John Smith 05/08/2010 05:31PM
Re: How to handle secondary keys in partitioning?   1,534 Mattias Jonsson 05/09/2010 04:37AM
Re: How to handle secondary keys in partitioning?   1,388 John Smith 05/09/2010 12:41PM
Re: How to handle secondary keys in partitioning?   1,299 Mattias Jonsson 05/09/2010 01:23PM
Re: How to handle secondary keys in partitioning?   1,583 Mattias Jonsson 05/04/2010 01:29PM
Re: How to handle secondary keys in partitioning?   1,397 John Smith 05/04/2010 04:30PM
Partition pruning - how much optimization is smart?   2,746 MichaƂ Stolarczyk 05/09/2010 04:21AM
Re: Partition pruning - how much optimization is smart?   1,099 Mattias Jonsson 05/09/2010 01:28PM
Partitioning performance issues // 5.1   3,189 Ya Wi 02/17/2010 10:53AM
Re: Partitioning performance issues // 5.1   1,994 Mattias Jonsson 02/19/2010 04:17AM
Re: Partitioning performance issues // 5.1   1,795 Ya Wi 02/19/2010 10:11AM
Re: Partitioning performance issues // 5.1   2,349 Mattias Jonsson 02/19/2010 02:56PM
Re: Partitioning performance issues // 5.1   2,131 bob hagemann 04/18/2010 04:51PM
Re: Partitioning performance issues // 5.1   1,646 Mattias Jonsson 04/18/2010 11:31PM
problem about partition   2,170 h ch 04/15/2010 08:01PM
Re: problem about partition   1,457 Rick James 04/16/2010 10:08PM
Re: problem about partition   1,436 h ch 04/18/2010 08:16PM
Partitioning tables with grouping   2,212 sonam agarwal 04/10/2010 07:31AM
Re: Partitioning tables with grouping   1,313 Rick James 04/11/2010 10:41PM
Re: Partitioning tables with grouping   1,956 sonam agarwal 04/11/2010 11:00PM
Re: Partitioning tables with grouping   1,344 Rick James 04/13/2010 11:40PM
Re: Partitioning tables with grouping   1,474 sonam agarwal 04/14/2010 05:04AM
PARTITION BY RANGE (CHARACTER BASIS) ?   4,440 sonam agarwal 04/10/2010 08:35AM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?   1,736 Mattias Jonsson 04/13/2010 06:01PM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?   1,618 sonam agarwal 04/13/2010 07:53PM
CREATING VIEWS OF A PARTITION   2,440 Bhargavi M S 04/10/2010 10:06AM
Re: CREATING VIEWS OF A PARTITION   1,236 Rick James 04/11/2010 10:35PM
Re: CREATING VIEWS OF A PARTITION   1,448 Mattias Jonsson 04/13/2010 06:02PM
Partitioning Problem   2,750 sireesh beemineni 04/09/2010 07:07AM
Re: Partitioning Problem   1,364 Rick James 04/11/2010 10:46PM
partition pruning and DIV   3,113 Bill Moninger 03/26/2010 11:23AM
Re: partition pruning and DIV   1,487 Mattias Jonsson 04/07/2010 04:35PM
Re: partition pruning and DIV   1,440 Bill Moninger 04/07/2010 05:08PM
Re: partition pruning and DIV   1,359 Rick James 04/06/2010 09:20PM
ERROR 1016 (HY000) at line: Can't open file: './test/Tablename.frm' (errno: 24)   3,566 vikas warad 04/05/2010 06:24AM
Partition-wise mysqldump backup script at MySQL Forge   2,497 Roland Bouman 03/30/2010 03:17AM
Partitions outside of date range is included   3,119 Marius S 03/18/2010 10:22AM
Re: Partitions outside of date range is included   1,583 Mattias Jonsson 03/24/2010 09:30AM
Re: Partitions outside of date range is included   1,621 Rick James 03/20/2010 01:43PM
Can't repair/rebuild my partitions   2,950 Andreas Thorstensson 03/15/2010 07:20AM
Re: Can't repair/rebuild my partitions   1,535 Mattias Jonsson 03/24/2010 08:44AM
copying from unpartitioned to partitioned table   3,031 Rick Casey 03/09/2010 11:54AM
Re: copying from unpartitioned to partitioned table   1,431 Mattias Jonsson 03/24/2010 08:39AM
Re: copying from unpartitioned to partitioned table   1,506 Mattias Jonsson 03/11/2010 08:18AM
Re: copying from unpartitioned to partitioned table   1,592 Rick Casey 03/12/2010 10:58AM
Why Unique Key Constraint?   4,036 Double Dragon 03/14/2010 04:59AM
Re: Why Unique Key Constraint?   1,615 Rick James 03/20/2010 03:44PM
Partition by Key   4,244 Vanco Josifovski 03/09/2010 02:28AM
Re: Partition by Key   1,703 Mattias Jonsson 03/12/2010 02:17AM
ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed   12,809 Chaya Shindhe 02/18/2010 04:21AM
Re: ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed   9,378 Mattias Jonsson 02/19/2010 04:22AM
PARTITION BY LIST "catch-all" partition   3,957 Egor Ivkin 01/20/2010 03:25AM
Re: PARTITION BY LIST "catch-all" partition   1,814 Mattias Jonsson 01/23/2010 03:55AM
Re: PARTITION BY LIST "catch-all" partition   1,783 Egor Ivkin 01/23/2010 08:20AM
Re: PARTITION BY LIST "catch-all" partition   1,857 Rick James 01/22/2010 11:05PM
Re: PARTITION BY LIST "catch-all" partition   1,814 Egor Ivkin 01/23/2010 12:30AM
Why doesn't partitioning support INSERT DELAYED?   3,762 Ben Vaughn 01/14/2010 06:50PM
Re: Why doesn't partitioning support INSERT DELAYED?   1,960 Mattias Jonsson 01/16/2010 06:48PM
Re: Why doesn't partitioning support INSERT DELAYED?   1,875 Rick James 01/22/2010 11:16PM
Partitioning with range(to_days) issue   6,581 Jools Lebowski 10/29/2009 11:13AM
Re: Partitioning with range(to_days) issue   2,447 Sarah Sproehnle 11/05/2009 07:47PM
Re: Partitioning with range(to_days) issue   2,113 Jools Lebowski 01/13/2010 06:36AM
Re: Partitioning with range(to_days) issue   2,383 Jason Shoulet 11/05/2009 03:12AM
Re: Partitioning with range(to_days) issue   2,379 Rick James 11/05/2009 08:37AM
Re: Partitioning with range(to_days) issue   3,282 Jason Shoulet 11/05/2009 09:51AM
Re: Partitioning with range(to_days) issue   2,320 Mattias Jonsson 11/17/2009 05:51AM
Re: Partitioning with range(to_days) issue   2,685 Rick James 10/31/2009 12:00PM
Re: Partitioning with range(to_days) issue   2,467 Jools Lebowski 11/02/2009 04:07AM
Re: Partitioning with range(to_days) issue   2,390 Rick James 11/02/2009 10:22AM
Re: Partitioning with range(to_days) issue   2,365 Jools Lebowski 11/03/2009 02:18AM
Re: Partitioning with range(to_days) issue   3,020 Rick James 11/03/2009 09:32AM
Re: Partitioning with range(to_days) issue   2,130 Jools Lebowski 01/13/2010 05:17AM
Re: Partitioning with range(to_days) issue   2,056 Rick James 01/22/2010 11:09PM
Partitioned table using two storage engines?   2,542 Loren Sorensen 01/07/2010 03:47PM
Re: Partitioned table using two storage engines?   1,644 Mattias Jonsson 01/13/2010 05:00AM
Sub partitions   3,208 AR Mahdi 01/12/2010 03:09AM
Re: Sub partitions   1,587 Mattias Jonsson 01/13/2010 04:51AM
Comments: Giuseppe Maxia - A deep look at MySQL 5.5 partitioning enhancements   5,818 DevZone Comment System 12/24/2009 01:26PM
Building Indexes across partitioned tables longer each day   3,433 Edward Capriolo 12/21/2009 10:46AM
Re: Building Indexes across partitioned tables longer each day   1,984 Rick James 12/22/2009 10:17PM
Re: Building Indexes across partitioned tables longer each day   1,874 Edward Capriolo 12/23/2009 12:30PM
Re: Building Indexes across partitioned tables longer each day   1,893 Mattias Jonsson 12/22/2009 02:48AM
alter table rebuild partition locks reads   4,576 Chris C 12/18/2009 01:24AM
Re: alter table rebuild partition locks reads   2,166 Chris C 12/18/2009 02:27AM
Re: alter table rebuild partition locks reads   1,978 Rick James 12/19/2009 09:22AM
Re: alter table rebuild partition locks reads   1,963 Chris C 12/20/2009 08:41PM
Re: alter table rebuild partition locks reads   2,121 Chris C 12/21/2009 03:04PM
Re: alter table rebuild partition locks reads   1,943 Mattias Jonsson 12/22/2009 02:37AM
Re: alter table rebuild partition locks reads   1,925 Chris C 12/22/2009 10:17AM
Hash and Linear Hash partition table not performing well   4,963 Neeraj Khandelwal 11/27/2009 03:04AM
Re: Hash and Linear Hash partition table not performing well   2,278 Mattias Jonsson 12/07/2009 04:44AM
Re: Hash and Linear Hash partition table not performing well   2,098 Neeraj Khandelwal 12/08/2009 01:05AM
Re: Hash and Linear Hash partition table not performing well   2,821 Mattias Jonsson 12/22/2009 03:29AM
Re: Hash and Linear Hash partition table not performing well   2,332 Rick James 12/05/2009 11:49PM
Re: Hash and Linear Hash partition table not performing well   2,451 Neeraj Khandelwal 12/08/2009 03:42AM
Re: Hash and Linear Hash partition table not performing well   2,916 Rick James 12/09/2009 08:08PM
Archiving Partition .MYD files   4,517 Dominic Edwards 12/11/2009 05:41AM
Re: Archiving Partition .MYD files   2,176 Dominic Edwards 12/11/2009 05:48AM
Re: Archiving Partition .MYD files   2,182 Rick James 12/12/2009 03:48PM
Re: Archiving Partition .MYD files   2,267 Mattias Jonsson 12/22/2009 03:00AM
partitioning question?   2,952 asmaa atef 12/14/2009 08:34AM
Re: partitioning question?   1,857 Mattias Jonsson 12/22/2009 02:50AM
Re: partitioning question?   1,904 Rick James 12/16/2009 12:33AM
Re: partitioning question?   1,675 asmaa atef 12/16/2009 07:44AM
Re: partitioning question?   1,822 Rick James 12/16/2009 11:53PM
Re: partitioning question?   1,803 asmaa atef 12/17/2009 02:39AM
Re: partitioning question?   1,809 Rick James 12/18/2009 12:40AM
Minimum number of rows for using partitioning   4,253 Ramesh Kumar 12/10/2009 10:57PM
Re: Minimum number of rows for using partitioning   1,984 Rick James 12/12/2009 10:58PM
Re: Minimum number of rows for using partitioning   2,102 Ramesh Kumar 12/13/2009 09:57PM
Re: Minimum number of rows for using partitioning   1,978 Rick James 12/14/2009 12:17AM
Re: Minimum number of rows for using partitioning   2,174 Ramesh Kumar 12/14/2009 12:57AM
Range Partition Pruning on TO_DAYS Problem   3,247 Dominic Edwards 11/12/2009 10:06AM
Re: Range Partition Pruning on TO_DAYS Problem   2,479 Mattias Jonsson 11/17/2009 06:09AM
Re: Range Partition Pruning on TO_DAYS Problem   1,994 Rick James 11/17/2009 08:41PM
Re: Range Partition Pruning on TO_DAYS Problem   1,876 Dominic Edwards 12/11/2009 05:45AM
Create new partition for an existing table?   3,748 hung chu 11/26/2009 10:27PM
Re: Create new partition for an existing table?   2,103 Rick James 12/05/2009 11:55PM
How transaction work with partitioned table?   2,386 hung chu 11/30/2009 04:13AM
Re: How transaction work with partitioned table?   1,749 Rick James 12/05/2009 11:45PM
I have a partitioned data set; how to best migrate to MySQL's Partioning?   2,662 Joseph Masters 12/04/2009 11:24AM
Re: I have a partitioned data set; how to best migrate to MySQL's Partioning?   1,660 Rick James 12/05/2009 03:06PM
partitioning   2,848 gururaj sheth 11/19/2009 12:39AM
Re: partitioning   1,879 Devart Team 11/20/2009 05:01AM
Re: partitioning   1,886 Rick James 11/20/2009 07:47PM
Subpartitioned by LIST   4,681 Praveen TS 11/06/2009 03:57AM
Re: Subpartitioned by LIST   2,297 Mattias Jonsson 11/17/2009 05:56AM
Re: Subpartitioned by LIST   2,086 Praveen TS 11/08/2009 10:36PM
Re: Subpartitioned by LIST   2,167 Rick James 11/09/2009 09:44AM
Re: Subpartitioned by LIST   1,798 Rick James 11/07/2009 04:07PM
Subpartition Pruning   3,952 Mathuvathanan Mounasamy 10/16/2009 04:08AM
Re: Subpartition Pruning   1,969 Mattias Jonsson 11/17/2009 05:40AM
Vertical Partitioning   2,835 Laavanya K 11/10/2009 09:41PM
Re: Vertical Partitioning   2,062 Rick James 11/11/2009 11:57PM
Re: Vertical Partitioning   1,789 Laavanya K 11/12/2009 12:02AM
Re: Vertical Partitioning   1,829 Rick James 11/12/2009 08:47PM
MySQL Partitioning (WL#4444, WL#4571): New partitioning SQL syntax added   2,388 Edwin DeSouza 11/11/2009 11:19AM
This topic has been moved.:  partitioning   0 gururaj sheth 11/20/2009 06:52AM
Current Page: 5 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.