MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.3 GA has been released 09/15/2016 03:06PM
MySQL Connector/Python 2.2.1 m2 Development Release has been released 09/13/2016 09:58AM
Oracle Enterprise Manager for MySQL Database 12.1.0.4.0 has been released 09/12/2016 02:59PM
MySQL Community Server 8.0.0-dmr has been released (part 3/3) 09/12/2016 08:52AM
MySQL Community Server 8.0.0-dmr has been released (part 2/3) 09/12/2016 08:50AM
Current Page: 5 of 13
Subject Views Written By Posted
Pruning problem.   2,105 Vladimiro Puggelli 09/21/2010 04:03AM
Re: Pruning problem.   1,089 Rick James 09/22/2010 07:57PM
Re: Pruning problem.   1,164 Vladimiro Puggelli 09/23/2010 03:16AM
Re: Pruning problem.   1,101 Rick James 09/23/2010 08:40AM
Re: Pruning problem.   1,047 Vladimiro Puggelli 09/24/2010 02:24AM
Re: Pruning problem.   1,183 Mattias Jonsson 09/28/2010 10:38AM
After partition also select is scanning all the partitions - need help   2,335 Venkat V 09/13/2010 08:50AM
Re: After partition also select is scanning all the partitions - need help   1,147 Mattias Jonsson 09/28/2010 10:31AM
Re: After partition also select is scanning all the partitions - need help   1,215 Rick James 09/14/2010 08:20PM
Re: After partition also select is scanning all the partitions - need help   1,345 Venkat V 09/16/2010 07:06PM
Re: After partition also select is scanning all the partitions - need help   1,233 Rick James 09/16/2010 08:51PM
Re: After partition also select is scanning all the partitions - need help   1,247 Venkat V 09/16/2010 09:45PM
Re: After partition also select is scanning all the partitions - need help   1,196 Rick James 09/16/2010 10:00PM
Re: After partition also select is scanning all the partitions - need help   1,200 Venkat V 09/21/2010 12:17AM
Re: After partition also select is scanning all the partitions - need help   1,153 Rick James 09/21/2010 04:18PM
Re: After partition also select is scanning all the partitions - need help   1,232 Venkat V 09/24/2010 06:14AM
Re: After partition also select is scanning all the partitions - need help   1,188 Rick James 09/24/2010 10:06PM
Re: After partition also select is scanning all the partitions - need help   1,507 Venkat V 09/24/2010 11:33PM
Re: After partition also select is scanning all the partitions - need help   1,208 Rick James 09/25/2010 01:27PM
How can I decide which partition type can I chose   3,311 Suresh Chary 09/08/2010 07:00AM
Re: How can I decide which partition type can I chose   1,202 john hango 09/09/2010 02:28PM
Re: How can I decide which partition type can I chose   1,253 Rick James 09/12/2010 03:11PM
Re: How can I decide which partition type can I chose   1,306 Rick James 09/13/2010 11:03AM
Re: How can I decide which partition type can I chose   1,112 Suresh Chary 09/14/2010 06:27AM
Re: How can I decide which partition type can I chose   1,639 Rick James 09/14/2010 07:44AM
Re: How can I decide which partition type can I chose   1,284 Suresh Chary 09/12/2010 10:10PM
Do I have to re write querries when Partitioning?   3,578 john hango 09/01/2010 11:17PM
Re: Do I have to re write querries when Partitioning?   1,493 Rick James 09/03/2010 07:26PM
Re: Do I have to re write querries when Partitioning?   1,518 john hango 09/05/2010 07:43PM
Re: Do I have to re write querries when Partitioning?   1,248 Rick James 09/10/2010 08:00PM
Re: Do I have to re write querries when Partitioning?   1,460 john hango 09/05/2010 07:45PM
Re: Do I have to re write querries when Partitioning?   1,276 john hango 09/05/2010 07:47PM
Re: Do I have to re write querries when Partitioning?   1,517 john hango 09/05/2010 07:51PM
Re: Do I have to re write querries when Partitioning?   1,676 john hango 09/05/2010 07:52PM
Here are some of the crons that run.   1,200 john hango 09/06/2010 11:38PM
Re: Here are some of the crons that run.   1,503 john hango 09/06/2010 11:39PM
Slowest query is when I click on a category on my site that has alot of products   1,932 john hango 09/08/2010 11:33AM
Re: Do I have to re write querries when Partitioning?   1,256 john hango 09/05/2010 07:52PM
Re: Do I have to re write querries when Partitioning?   1,303 john hango 09/02/2010 04:09AM
Evolve from Partition to Sharding?   3,188 John Smith 08/21/2010 04:56AM
Re: Evolve from Partition to Sharding?   1,430 Rick James 08/22/2010 09:02AM
Re: Evolve from Partition to Sharding?   1,842 John Smith 08/23/2010 12:03AM
Re: Evolve from Partition to Sharding?   1,339 Andy Grove 08/27/2010 07:41AM
Re: Evolve from Partition to Sharding?   1,278 Rick James 08/23/2010 12:42AM
Re: Evolve from Partition to Sharding?   1,945 John Smith 08/23/2010 12:48AM
Re: Evolve from Partition to Sharding?   1,252 Rick James 08/23/2010 09:45PM
Re: Evolve from Partition to Sharding?   1,373 John Smith 08/23/2010 10:18PM
Mysql cluster 7.1.5 can't use table partition!   2,529 yan wenwu 08/25/2010 10:13AM
Re: Mysql cluster 7.1.5 can't use table partition!   1,334 Rick James 08/26/2010 10:27PM
How to move InnoDB partitions from one machine to another?   2,207 John Smith 08/26/2010 03:16AM
Hash/key Partition by something other than PK   2,455 John Smith 08/23/2010 05:50AM
Re: Hash/key Partition by something other than PK   1,278 Rick James 08/24/2010 11:59PM
about SUBPARTITIONING BEHAVIOR ...   2,078 08/18/2010 07:46AM
Re: about SUBPARTITIONING BEHAVIOR ...   1,134 Mattias Jonsson 08/19/2010 05:59AM
first partition always   2,178 N N 08/10/2010 03:29AM
Re: first partition always   1,155 Aftab Khan 08/11/2010 05:44AM
Partitioning on the basis of DAY() function   3,324 Mirza Misbah Ulhaq 08/03/2010 07:09AM
Re: Partitioning on the basis of DAY() function   1,267 Rick James 08/04/2010 09:38PM
Partitioning dilemma   2,388 Philopator Ptolemy 07/20/2010 08:51AM
Re: Partitioning dilemma   1,302 Rick James 07/21/2010 11:58AM
Re: Partitioning dilemma   1,234 Philopator Ptolemy 07/21/2010 01:47PM
Re: Partitioning dilemma   1,312 Rick James 07/26/2010 11:15PM
Re: Partitioning dilemma   1,152 Philopator Ptolemy 07/27/2010 09:02AM
Re: Partitioning dilemma   1,202 Rick James 07/27/2010 08:06PM
MySQL DB Size increase after partitioning   3,450 Ronald Higgins 07/25/2010 11:37AM
Re: MySQL DB Size increase after partitioning   1,359 Rick James 07/26/2010 11:02PM
Why null errors in partition insert without nulls ??   2,380 Jorge Torralba 07/13/2010 12:21PM
Re: Why null errors in partition insert without nulls ??   1,193 Rick James 07/25/2010 10:29PM
Re: Why null errors in partition insert without nulls ??   1,203 Jonathon Coombes 07/24/2010 11:03PM
Using MySQL Partitioning Instead of MERGE Tables   2,308 Edwin DeSouza 07/24/2010 03:38PM
partitioning by month and pruning   2,001 Jorge Torralba 07/13/2010 11:51AM
Partition Pruning based on subquery / join result   3,943 Justin Holdsworth 07/09/2010 03:54AM
Re: Partition Pruning based on subquery / join result   1,652 Rick James 07/11/2010 11:30AM
Re: Partition Pruning based on subquery / join result   1,676 Justin Holdsworth 07/12/2010 05:05AM
Re: Partition Pruning based on subquery / join result   1,635 Rick James 07/12/2010 11:41PM
Re: Partition Pruning based on subquery / join result   1,657 Justin Holdsworth 07/13/2010 09:33AM
Partition table not support foreign key feature ?   2,511 Mayur P Vegad 06/30/2010 04:41AM
Re: Partition table not support foreign key feature ?   1,272 Rick James 07/01/2010 11:12PM
Re: Partition table not support foreign key feature ?   1,797 Mayur P Vegad 07/02/2010 05:05AM
Re: Partition table not support foreign key feature ?   1,585 Rick James 07/03/2010 12:35AM
Strange first partition behavior while pruning on table partitioned by date.   2,740 Alexey Efremov 06/29/2010 09:46AM
Re: Strange first partition behavior while pruning on table partitioned by date.   1,293 Rick James 06/30/2010 08:51PM
Re: Strange first partition behavior while pruning on table partitioned by date.   1,187 Alexey Efremov 07/01/2010 06:10AM
Exceptions with Partition Pruning   3,264 ratheesh balakrishnan 06/10/2010 04:36PM
Re: Exceptions with Partition Pruning   1,489 Rick James 06/12/2010 01:21AM
Re: Exceptions with Partition Pruning   1,452 ratheesh balakrishnan 06/14/2010 01:10PM
Re: Exceptions with Partition Pruning   1,308 Rick James 06/16/2010 09:31AM
Re: Exceptions with Partition Pruning   1,529 ratheesh balakrishnan 06/16/2010 05:28PM
Rebuilding vs. Optimizing Partition, Time Elapsed to complete   2,559 Thomas Lekai 06/07/2010 04:12PM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete   1,536 Mattias Jonsson 06/15/2010 04:51AM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete   1,512 Rick James 06/09/2010 09:40AM
Lock wait timeouts and partitioning   2,175 Mark Richman 06/05/2010 07:47AM
Re: Lock wait timeouts and partitioning   1,369 Rick James 06/06/2010 08:53AM
Re: Lock wait timeouts and partitioning   1,386 Mattias Jonsson 06/15/2010 04:42AM
Huge Disk Write while performing delete operation   2,297 Ramesh Kumar 06/10/2010 10:17PM
Re: Huge Disk Write while performing delete operation   1,238 Rick James 06/12/2010 12:50AM
Linear Partioning vs Ordinary   3,873 Double Dragon 03/15/2010 02:31AM
Re: Linear Partioning vs Ordinary   1,459 ratheesh balakrishnan 06/11/2010 04:09PM
Re: Linear Partioning vs Ordinary   1,854 Mattias Jonsson 03/24/2010 09:23AM
Re: Linear Partioning vs Ordinary   1,861 Rick James 03/19/2010 08:09AM
Can not partition existings tables   2,426 Olivier Bourdon 06/03/2010 04:06AM
Re: Can not partition existings tables   1,484 Rick James 06/04/2010 08:22PM
Re: Can not partition existings tables   1,448 Olivier Bourdon 06/07/2010 03:55AM
Re: Can not partition existings tables   1,395 Rick James 06/07/2010 11:18PM
Key Partition Performance Measurement   3,400 Imran Pathan 05/25/2010 01:05AM
Re: Key Partition Performance Measurement   1,441 Rick James 05/28/2010 11:39PM
Re: Key Partition Performance Measurement   1,405 Imran Pathan 05/27/2010 05:43AM
SOLVED; DISK USAGE When Alter table HASH   2,257 Hawk T 05/25/2010 03:29PM
Re: DISK USAGE When Alter table HASH   1,296 Hawk T 05/26/2010 09:22AM
Mystified by Partition Pruning on Dates   2,283 John Thompson 05/19/2010 03:45AM
Re: Mystified by Partition Pruning on Dates   1,387 Rick James 05/20/2010 07:58AM
Re: Mystified by Partition Pruning on Dates   1,467 John Thompson 05/20/2010 08:35AM
How to handle secondary keys in partitioning?   3,083 John Smith 05/04/2010 12:46AM
Re: How to handle secondary keys in partitioning?   1,721 Mattias Jonsson 05/05/2010 02:20AM
Re: How to handle secondary keys in partitioning?   2,059 John Smith 05/06/2010 12:34AM
Re: How to handle secondary keys in partitioning?   1,638 Rick James 05/06/2010 12:04AM
Re: How to handle secondary keys in partitioning?   1,880 Mattias Jonsson 05/06/2010 03:23PM
Re: How to handle secondary keys in partitioning?   1,552 John Smith 05/06/2010 10:50PM
Re: How to handle secondary keys in partitioning?   1,570 Mattias Jonsson 05/12/2010 05:29AM
Re: How to handle secondary keys in partitioning?   1,631 Mattias Jonsson 05/07/2010 02:38AM
Re: How to handle secondary keys in partitioning?   1,591 John Smith 05/08/2010 05:31PM
Re: How to handle secondary keys in partitioning?   1,678 Mattias Jonsson 05/09/2010 04:37AM
Re: How to handle secondary keys in partitioning?   1,504 John Smith 05/09/2010 12:41PM
Re: How to handle secondary keys in partitioning?   1,409 Mattias Jonsson 05/09/2010 01:23PM
Re: How to handle secondary keys in partitioning?   1,731 Mattias Jonsson 05/04/2010 01:29PM
Re: How to handle secondary keys in partitioning?   1,534 John Smith 05/04/2010 04:30PM
Partition pruning - how much optimization is smart?   3,034 MichaƂ Stolarczyk 05/09/2010 04:21AM
Re: Partition pruning - how much optimization is smart?   1,225 Mattias Jonsson 05/09/2010 01:28PM
Partitioning performance issues // 5.1   3,387 Ya Wi 02/17/2010 10:53AM
Re: Partitioning performance issues // 5.1   2,106 Mattias Jonsson 02/19/2010 04:17AM
Re: Partitioning performance issues // 5.1   1,916 Ya Wi 02/19/2010 10:11AM
Re: Partitioning performance issues // 5.1   2,477 Mattias Jonsson 02/19/2010 02:56PM
Re: Partitioning performance issues // 5.1   2,266 bob hagemann 04/18/2010 04:51PM
Re: Partitioning performance issues // 5.1   1,753 Mattias Jonsson 04/18/2010 11:31PM
problem about partition   2,353 h ch 04/15/2010 08:01PM
Re: problem about partition   1,563 Rick James 04/16/2010 10:08PM
Re: problem about partition   1,561 h ch 04/18/2010 08:16PM
Partitioning tables with grouping   2,419 sonam agarwal 04/10/2010 07:31AM
Re: Partitioning tables with grouping   1,414 Rick James 04/11/2010 10:41PM
Re: Partitioning tables with grouping   2,059 sonam agarwal 04/11/2010 11:00PM
Re: Partitioning tables with grouping   1,435 Rick James 04/13/2010 11:40PM
Re: Partitioning tables with grouping   1,578 sonam agarwal 04/14/2010 05:04AM
PARTITION BY RANGE (CHARACTER BASIS) ?   4,655 sonam agarwal 04/10/2010 08:35AM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?   1,843 Mattias Jonsson 04/13/2010 06:01PM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?   1,720 sonam agarwal 04/13/2010 07:53PM
CREATING VIEWS OF A PARTITION   2,621 Bhargavi M S 04/10/2010 10:06AM
Re: CREATING VIEWS OF A PARTITION   1,322 Rick James 04/11/2010 10:35PM
Re: CREATING VIEWS OF A PARTITION   1,536 Mattias Jonsson 04/13/2010 06:02PM
Partitioning Problem   2,951 sireesh beemineni 04/09/2010 07:07AM
Re: Partitioning Problem   1,466 Rick James 04/11/2010 10:46PM
partition pruning and DIV   3,367 Bill Moninger 03/26/2010 11:23AM
Re: partition pruning and DIV   1,627 Mattias Jonsson 04/07/2010 04:35PM
Re: partition pruning and DIV   1,555 Bill Moninger 04/07/2010 05:08PM
Re: partition pruning and DIV   1,484 Rick James 04/06/2010 09:20PM
ERROR 1016 (HY000) at line: Can't open file: './test/Tablename.frm' (errno: 24)   4,269 vikas warad 04/05/2010 06:24AM
Partition-wise mysqldump backup script at MySQL Forge   2,780 Roland Bouman 03/30/2010 03:17AM
Partitions outside of date range is included   3,450 Marius S 03/18/2010 10:22AM
Re: Partitions outside of date range is included   1,758 Mattias Jonsson 03/24/2010 09:30AM
Re: Partitions outside of date range is included   1,727 Rick James 03/20/2010 01:43PM
Can't repair/rebuild my partitions   3,307 Andreas Thorstensson 03/15/2010 07:20AM
Re: Can't repair/rebuild my partitions   1,657 Mattias Jonsson 03/24/2010 08:44AM
copying from unpartitioned to partitioned table   3,303 Rick Casey 03/09/2010 11:54AM
Re: copying from unpartitioned to partitioned table   1,564 Mattias Jonsson 03/24/2010 08:39AM
Re: copying from unpartitioned to partitioned table   1,671 Mattias Jonsson 03/11/2010 08:18AM
Re: copying from unpartitioned to partitioned table   1,721 Rick Casey 03/12/2010 10:58AM
Why Unique Key Constraint?   4,283 Double Dragon 03/14/2010 04:59AM
Re: Why Unique Key Constraint?   1,733 Rick James 03/20/2010 03:44PM
Partition by Key   4,720 Vanco Josifovski 03/09/2010 02:28AM
Re: Partition by Key   1,823 Mattias Jonsson 03/12/2010 02:17AM
ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed   14,478 Chaya Shindhe 02/18/2010 04:21AM
Re: ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed   10,256 Mattias Jonsson 02/19/2010 04:22AM
PARTITION BY LIST "catch-all" partition   4,276 Egor Ivkin 01/20/2010 03:25AM
Re: PARTITION BY LIST "catch-all" partition   1,957 Mattias Jonsson 01/23/2010 03:55AM
Re: PARTITION BY LIST "catch-all" partition   1,886 Egor Ivkin 01/23/2010 08:20AM
Re: PARTITION BY LIST "catch-all" partition   1,977 Rick James 01/22/2010 11:05PM
Re: PARTITION BY LIST "catch-all" partition   1,931 Egor Ivkin 01/23/2010 12:30AM
Why doesn't partitioning support INSERT DELAYED?   3,996 Ben Vaughn 01/14/2010 06:50PM
Re: Why doesn't partitioning support INSERT DELAYED?   2,098 Mattias Jonsson 01/16/2010 06:48PM
Re: Why doesn't partitioning support INSERT DELAYED?   1,984 Rick James 01/22/2010 11:16PM
Partitioning with range(to_days) issue   7,204 Jools Lebowski 10/29/2009 11:13AM
Re: Partitioning with range(to_days) issue   2,555 Sarah Sproehnle 11/05/2009 07:47PM
Re: Partitioning with range(to_days) issue   2,262 Jools Lebowski 01/13/2010 06:36AM
Re: Partitioning with range(to_days) issue   2,541 Jason Shoulet 11/05/2009 03:12AM
Re: Partitioning with range(to_days) issue   2,543 Rick James 11/05/2009 08:37AM
Re: Partitioning with range(to_days) issue   3,415 Jason Shoulet 11/05/2009 09:51AM
Re: Partitioning with range(to_days) issue   2,460 Mattias Jonsson 11/17/2009 05:51AM
Re: Partitioning with range(to_days) issue   2,861 Rick James 10/31/2009 12:00PM
Re: Partitioning with range(to_days) issue   2,625 Jools Lebowski 11/02/2009 04:07AM
Re: Partitioning with range(to_days) issue   2,534 Rick James 11/02/2009 10:22AM
Re: Partitioning with range(to_days) issue   2,551 Jools Lebowski 11/03/2009 02:18AM
Re: Partitioning with range(to_days) issue   3,205 Rick James 11/03/2009 09:32AM
Re: Partitioning with range(to_days) issue   2,287 Jools Lebowski 01/13/2010 05:17AM
Re: Partitioning with range(to_days) issue   2,204 Rick James 01/22/2010 11:09PM
Partitioned table using two storage engines?   2,763 Loren Sorensen 01/07/2010 03:47PM
Re: Partitioned table using two storage engines?   1,752 Mattias Jonsson 01/13/2010 05:00AM
Sub partitions   3,578 AR Mahdi 01/12/2010 03:09AM
Re: Sub partitions   1,799 Mattias Jonsson 01/13/2010 04:51AM
This topic has been moved.:  MySQL DB Size increase after partitioning   0 Ronald Higgins 07/25/2010 03:05PM
Current Page: 5 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.