MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Cluster 7.5.5 has been released 01/17/2017 02:22PM
MySQL Cluster 7.2.27 has been released 01/17/2017 11:04AM
MySQL Cluster 7.3.16 has been released 01/17/2017 10:56AM
MySQL Cluster 7.4.14 has been released 01/17/2017 10:38AM
MySQL Connector/C 6.1.9 GA has been released 01/10/2017 09:47AM
Current Page: 5 of 13
Subject Views Written By Posted
Use Partition to split data for user   2,249 Nicola Campanelli 10/10/2010 01:23AM
Re: Use Partition to split data for user   1,100 Mattias Jonsson 11/08/2010 06:22AM
Is Partitioning a good way to handle deletes?   1,860 John Smith 11/06/2010 05:34PM
Re: Is Partitioning a good way to handle deletes?   1,042 Mattias Jonsson 11/08/2010 06:19AM
slower queries after partitioning   5,164 Mat private 10/21/2010 11:46AM
Re: slower queries after partitioning   2,143 Rick James 10/23/2010 01:24AM
Re: slower queries after partitioning   1,435 Mat private 10/25/2010 07:39AM
Re: slower queries after partitioning   1,449 Mat private 10/25/2010 08:04AM
Re: slower queries after partitioning   1,464 Mat private 10/23/2010 10:57AM
Re: slower queries after partitioning   1,536 Rick James 10/23/2010 06:09PM
Re: slower queries after partitioning   1,443 Mat private 10/24/2010 02:30AM
Re: slower queries after partitioning   1,572 Mat private 10/23/2010 10:48AM
Re: slower queries after partitioning   1,723 Mat private 10/23/2010 08:44AM
Re: slower queries after partitioning   2,032 Rick James 10/23/2010 09:43AM
Partitioning help   2,285 Anantha Varatharajan 09/24/2010 02:16AM
Re: Partitioning help   1,281 Rick James 09/25/2010 01:09PM
Re: Partitioning help   1,201 Anantha Varatharajan 09/27/2010 03:43AM
Re: Partitioning help   1,206 Rick James 09/27/2010 07:55PM
Re: Partitioning help   1,166 Anantha Varatharajan 10/12/2010 01:55AM
Re: Partitioning help   1,117 Rick James 10/12/2010 08:03AM
Re: Partitioning help   1,075 Anantha Varatharajan 10/13/2010 03:27AM
Re: Partitioning help   1,176 Rick James 10/13/2010 06:03PM
partition by rows & fields   1,979 Stan Chernov 10/06/2010 09:35AM
Re: partition by rows & fields   964 Rick James 10/10/2010 01:02PM
When do I start... partitioning?   2,144 Keysle Sorm 10/08/2010 10:52PM
Re: When do I start... partitioning?   1,214 Rick James 10/10/2010 11:23AM
Partition querry   2,401 Ionut Filip 09/28/2010 01:58AM
Re: Partition querry   1,115 Mattias Jonsson 09/29/2010 04:56AM
Re: Partition querry   1,178 Rick James 09/28/2010 05:46PM
Re: Partition querry   1,175 Large Arnaud 09/28/2010 06:08AM
Partition Pruning   2,746 Andrew McGhie 09/17/2010 06:04AM
Re: Partition Pruning   1,255 Rick James 09/21/2010 04:33PM
Re: Partition Pruning   1,167 Andrew McGhie 09/23/2010 09:17AM
Re: Partition Pruning   1,280 Mattias Jonsson 09/28/2010 10:51AM
Re: Partition Pruning   1,095 Rick James 09/28/2010 04:52PM
Re: Partition Pruning   1,573 Mattias Jonsson 09/29/2010 04:49AM
Re: Partition Pruning   1,254 Shawn Taylor 09/21/2010 02:41PM
Re: Partition Pruning   1,201 laptop alias 09/17/2010 06:43AM
Partition Pruning   2,352 Andrew McGhie 09/17/2010 07:18AM
Re: Partition Pruning   1,162 Rick James 09/18/2010 04:13PM
Re: Partition Pruning   1,126 Mattias Jonsson 09/28/2010 10:59AM
Re: Partition Pruning   1,201 Andrew McGhie 09/17/2010 07:23AM
Pruning problem.   2,190 Vladimiro Puggelli 09/21/2010 04:03AM
Re: Pruning problem.   1,120 Rick James 09/22/2010 07:57PM
Re: Pruning problem.   1,196 Vladimiro Puggelli 09/23/2010 03:16AM
Re: Pruning problem.   1,141 Rick James 09/23/2010 08:40AM
Re: Pruning problem.   1,072 Vladimiro Puggelli 09/24/2010 02:24AM
Re: Pruning problem.   1,214 Mattias Jonsson 09/28/2010 10:38AM
After partition also select is scanning all the partitions - need help   2,434 Venkat V 09/13/2010 08:50AM
Re: After partition also select is scanning all the partitions - need help   1,193 Mattias Jonsson 09/28/2010 10:31AM
Re: After partition also select is scanning all the partitions - need help   1,233 Rick James 09/14/2010 08:20PM
Re: After partition also select is scanning all the partitions - need help   1,396 Venkat V 09/16/2010 07:06PM
Re: After partition also select is scanning all the partitions - need help   1,268 Rick James 09/16/2010 08:51PM
Re: After partition also select is scanning all the partitions - need help   1,268 Venkat V 09/16/2010 09:45PM
Re: After partition also select is scanning all the partitions - need help   1,218 Rick James 09/16/2010 10:00PM
Re: After partition also select is scanning all the partitions - need help   1,234 Venkat V 09/21/2010 12:17AM
Re: After partition also select is scanning all the partitions - need help   1,175 Rick James 09/21/2010 04:18PM
Re: After partition also select is scanning all the partitions - need help   1,266 Venkat V 09/24/2010 06:14AM
Re: After partition also select is scanning all the partitions - need help   1,221 Rick James 09/24/2010 10:06PM
Re: After partition also select is scanning all the partitions - need help   1,543 Venkat V 09/24/2010 11:33PM
Re: After partition also select is scanning all the partitions - need help   1,234 Rick James 09/25/2010 01:27PM
How can I decide which partition type can I chose   3,399 Suresh Chary 09/08/2010 07:00AM
Re: How can I decide which partition type can I chose   1,231 john hango 09/09/2010 02:28PM
Re: How can I decide which partition type can I chose   1,309 Rick James 09/12/2010 03:11PM
Re: How can I decide which partition type can I chose   1,331 Rick James 09/13/2010 11:03AM
Re: How can I decide which partition type can I chose   1,143 Suresh Chary 09/14/2010 06:27AM
Re: How can I decide which partition type can I chose   1,669 Rick James 09/14/2010 07:44AM
Re: How can I decide which partition type can I chose   1,315 Suresh Chary 09/12/2010 10:10PM
Do I have to re write querries when Partitioning?   3,696 john hango 09/01/2010 11:17PM
Re: Do I have to re write querries when Partitioning?   1,542 Rick James 09/03/2010 07:26PM
Re: Do I have to re write querries when Partitioning?   1,571 john hango 09/05/2010 07:43PM
Re: Do I have to re write querries when Partitioning?   1,280 Rick James 09/10/2010 08:00PM
Re: Do I have to re write querries when Partitioning?   1,500 john hango 09/05/2010 07:45PM
Re: Do I have to re write querries when Partitioning?   1,314 john hango 09/05/2010 07:47PM
Re: Do I have to re write querries when Partitioning?   1,558 john hango 09/05/2010 07:51PM
Re: Do I have to re write querries when Partitioning?   1,701 john hango 09/05/2010 07:52PM
Here are some of the crons that run.   1,227 john hango 09/06/2010 11:38PM
Re: Here are some of the crons that run.   1,543 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,997 john hango 09/08/2010 11:33AM
Re: Do I have to re write querries when Partitioning?   1,290 john hango 09/05/2010 07:52PM
Re: Do I have to re write querries when Partitioning?   1,328 john hango 09/02/2010 04:09AM
Evolve from Partition to Sharding?   3,234 John Smith 08/21/2010 04:56AM
Re: Evolve from Partition to Sharding?   1,457 Rick James 08/22/2010 09:02AM
Re: Evolve from Partition to Sharding?   1,883 John Smith 08/23/2010 12:03AM
Re: Evolve from Partition to Sharding?   1,382 Andy Grove 08/27/2010 07:41AM
Re: Evolve from Partition to Sharding?   1,302 Rick James 08/23/2010 12:42AM
Re: Evolve from Partition to Sharding?   1,974 John Smith 08/23/2010 12:48AM
Re: Evolve from Partition to Sharding?   1,286 Rick James 08/23/2010 09:45PM
Re: Evolve from Partition to Sharding?   1,401 John Smith 08/23/2010 10:18PM
Mysql cluster 7.1.5 can't use table partition!   2,614 yan wenwu 08/25/2010 10:13AM
Re: Mysql cluster 7.1.5 can't use table partition!   1,380 Rick James 08/26/2010 10:27PM
How to move InnoDB partitions from one machine to another?   2,277 John Smith 08/26/2010 03:16AM
Hash/key Partition by something other than PK   2,523 John Smith 08/23/2010 05:50AM
Re: Hash/key Partition by something other than PK   1,314 Rick James 08/24/2010 11:59PM
about SUBPARTITIONING BEHAVIOR ...   2,134 08/18/2010 07:46AM
Re: about SUBPARTITIONING BEHAVIOR ...   1,159 Mattias Jonsson 08/19/2010 05:59AM
first partition always   2,221 N N 08/10/2010 03:29AM
Re: first partition always   1,184 Aftab Khan 08/11/2010 05:44AM
Partitioning on the basis of DAY() function   3,400 Mirza Misbah Ulhaq 08/03/2010 07:09AM
Re: Partitioning on the basis of DAY() function   1,293 Rick James 08/04/2010 09:38PM
Partitioning dilemma   2,443 Philopator Ptolemy 07/20/2010 08:51AM
Re: Partitioning dilemma   1,327 Rick James 07/21/2010 11:58AM
Re: Partitioning dilemma   1,261 Philopator Ptolemy 07/21/2010 01:47PM
Re: Partitioning dilemma   1,338 Rick James 07/26/2010 11:15PM
Re: Partitioning dilemma   1,178 Philopator Ptolemy 07/27/2010 09:02AM
Re: Partitioning dilemma   1,225 Rick James 07/27/2010 08:06PM
MySQL DB Size increase after partitioning   3,545 Ronald Higgins 07/25/2010 11:37AM
Re: MySQL DB Size increase after partitioning   1,385 Rick James 07/26/2010 11:02PM
Why null errors in partition insert without nulls ??   2,442 Jorge Torralba 07/13/2010 12:21PM
Re: Why null errors in partition insert without nulls ??   1,216 Rick James 07/25/2010 10:29PM
Re: Why null errors in partition insert without nulls ??   1,223 Jonathon Coombes 07/24/2010 11:03PM
Using MySQL Partitioning Instead of MERGE Tables   2,402 Edwin DeSouza 07/24/2010 03:38PM
partitioning by month and pruning   2,072 Jorge Torralba 07/13/2010 11:51AM
Partition Pruning based on subquery / join result   4,062 Justin Holdsworth 07/09/2010 03:54AM
Re: Partition Pruning based on subquery / join result   1,704 Rick James 07/11/2010 11:30AM
Re: Partition Pruning based on subquery / join result   1,727 Justin Holdsworth 07/12/2010 05:05AM
Re: Partition Pruning based on subquery / join result   1,675 Rick James 07/12/2010 11:41PM
Re: Partition Pruning based on subquery / join result   1,689 Justin Holdsworth 07/13/2010 09:33AM
Partition table not support foreign key feature ?   2,574 Mayur P Vegad 06/30/2010 04:41AM
Re: Partition table not support foreign key feature ?   1,306 Rick James 07/01/2010 11:12PM
Re: Partition table not support foreign key feature ?   1,823 Mayur P Vegad 07/02/2010 05:05AM
Re: Partition table not support foreign key feature ?   1,610 Rick James 07/03/2010 12:35AM
Strange first partition behavior while pruning on table partitioned by date.   2,818 Alexey Efremov 06/29/2010 09:46AM
Re: Strange first partition behavior while pruning on table partitioned by date.   1,316 Rick James 06/30/2010 08:51PM
Re: Strange first partition behavior while pruning on table partitioned by date.   1,214 Alexey Efremov 07/01/2010 06:10AM
Exceptions with Partition Pruning   3,325 ratheesh balakrishnan 06/10/2010 04:36PM
Re: Exceptions with Partition Pruning   1,518 Rick James 06/12/2010 01:21AM
Re: Exceptions with Partition Pruning   1,502 ratheesh balakrishnan 06/14/2010 01:10PM
Re: Exceptions with Partition Pruning   1,332 Rick James 06/16/2010 09:31AM
Re: Exceptions with Partition Pruning   1,571 ratheesh balakrishnan 06/16/2010 05:28PM
Rebuilding vs. Optimizing Partition, Time Elapsed to complete   2,628 Thomas Lekai 06/07/2010 04:12PM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete   1,556 Mattias Jonsson 06/15/2010 04:51AM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete   1,549 Rick James 06/09/2010 09:40AM
Lock wait timeouts and partitioning   2,239 Mark Richman 06/05/2010 07:47AM
Re: Lock wait timeouts and partitioning   1,385 Rick James 06/06/2010 08:53AM
Re: Lock wait timeouts and partitioning   1,405 Mattias Jonsson 06/15/2010 04:42AM
Huge Disk Write while performing delete operation   2,350 Ramesh Kumar 06/10/2010 10:17PM
Re: Huge Disk Write while performing delete operation   1,270 Rick James 06/12/2010 12:50AM
Linear Partioning vs Ordinary   3,935 Double Dragon 03/15/2010 02:31AM
Re: Linear Partioning vs Ordinary   1,513 ratheesh balakrishnan 06/11/2010 04:09PM
Re: Linear Partioning vs Ordinary   1,879 Mattias Jonsson 03/24/2010 09:23AM
Re: Linear Partioning vs Ordinary   1,883 Rick James 03/19/2010 08:09AM
Can not partition existings tables   2,484 Olivier Bourdon 06/03/2010 04:06AM
Re: Can not partition existings tables   1,523 Rick James 06/04/2010 08:22PM
Re: Can not partition existings tables   1,472 Olivier Bourdon 06/07/2010 03:55AM
Re: Can not partition existings tables   1,417 Rick James 06/07/2010 11:18PM
Key Partition Performance Measurement   3,484 Imran Pathan 05/25/2010 01:05AM
Re: Key Partition Performance Measurement   1,461 Rick James 05/28/2010 11:39PM
Re: Key Partition Performance Measurement   1,439 Imran Pathan 05/27/2010 05:43AM
SOLVED; DISK USAGE When Alter table HASH   2,305 Hawk T 05/25/2010 03:29PM
Re: DISK USAGE When Alter table HASH   1,317 Hawk T 05/26/2010 09:22AM
Mystified by Partition Pruning on Dates   2,341 John Thompson 05/19/2010 03:45AM
Re: Mystified by Partition Pruning on Dates   1,417 Rick James 05/20/2010 07:58AM
Re: Mystified by Partition Pruning on Dates   1,504 John Thompson 05/20/2010 08:35AM
How to handle secondary keys in partitioning?   3,152 John Smith 05/04/2010 12:46AM
Re: How to handle secondary keys in partitioning?   1,786 Mattias Jonsson 05/05/2010 02:20AM
Re: How to handle secondary keys in partitioning?   2,092 John Smith 05/06/2010 12:34AM
Re: How to handle secondary keys in partitioning?   1,659 Rick James 05/06/2010 12:04AM
Re: How to handle secondary keys in partitioning?   1,906 Mattias Jonsson 05/06/2010 03:23PM
Re: How to handle secondary keys in partitioning?   1,587 John Smith 05/06/2010 10:50PM
Re: How to handle secondary keys in partitioning?   1,595 Mattias Jonsson 05/12/2010 05:29AM
Re: How to handle secondary keys in partitioning?   1,671 Mattias Jonsson 05/07/2010 02:38AM
Re: How to handle secondary keys in partitioning?   1,616 John Smith 05/08/2010 05:31PM
Re: How to handle secondary keys in partitioning?   1,704 Mattias Jonsson 05/09/2010 04:37AM
Re: How to handle secondary keys in partitioning?   1,537 John Smith 05/09/2010 12:41PM
Re: How to handle secondary keys in partitioning?   1,447 Mattias Jonsson 05/09/2010 01:23PM
Re: How to handle secondary keys in partitioning?   1,763 Mattias Jonsson 05/04/2010 01:29PM
Re: How to handle secondary keys in partitioning?   1,561 John Smith 05/04/2010 04:30PM
Partition pruning - how much optimization is smart?   3,095 MichaƂ Stolarczyk 05/09/2010 04:21AM
Re: Partition pruning - how much optimization is smart?   1,250 Mattias Jonsson 05/09/2010 01:28PM
Partitioning performance issues // 5.1   3,455 Ya Wi 02/17/2010 10:53AM
Re: Partitioning performance issues // 5.1   2,129 Mattias Jonsson 02/19/2010 04:17AM
Re: Partitioning performance issues // 5.1   1,955 Ya Wi 02/19/2010 10:11AM
Re: Partitioning performance issues // 5.1   2,501 Mattias Jonsson 02/19/2010 02:56PM
Re: Partitioning performance issues // 5.1   2,285 bob hagemann 04/18/2010 04:51PM
Re: Partitioning performance issues // 5.1   1,776 Mattias Jonsson 04/18/2010 11:31PM
problem about partition   2,393 h ch 04/15/2010 08:01PM
Re: problem about partition   1,592 Rick James 04/16/2010 10:08PM
Re: problem about partition   1,597 h ch 04/18/2010 08:16PM
Partitioning tables with grouping   2,471 sonam agarwal 04/10/2010 07:31AM
Re: Partitioning tables with grouping   1,447 Rick James 04/11/2010 10:41PM
Re: Partitioning tables with grouping   2,081 sonam agarwal 04/11/2010 11:00PM
Re: Partitioning tables with grouping   1,457 Rick James 04/13/2010 11:40PM
Re: Partitioning tables with grouping   1,601 sonam agarwal 04/14/2010 05:04AM
PARTITION BY RANGE (CHARACTER BASIS) ?   4,719 sonam agarwal 04/10/2010 08:35AM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?   1,882 Mattias Jonsson 04/13/2010 06:01PM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?   1,742 sonam agarwal 04/13/2010 07:53PM
CREATING VIEWS OF A PARTITION   2,660 Bhargavi M S 04/10/2010 10:06AM
Re: CREATING VIEWS OF A PARTITION   1,348 Rick James 04/11/2010 10:35PM
Re: CREATING VIEWS OF A PARTITION   1,555 Mattias Jonsson 04/13/2010 06:02PM
Partitioning Problem   3,007 sireesh beemineni 04/09/2010 07:07AM
Re: Partitioning Problem   1,488 Rick James 04/11/2010 10:46PM
partition pruning and DIV   3,425 Bill Moninger 03/26/2010 11:23AM
Re: partition pruning and DIV   1,661 Mattias Jonsson 04/07/2010 04:35PM
Re: partition pruning and DIV   1,577 Bill Moninger 04/07/2010 05:08PM
Re: partition pruning and DIV   1,522 Rick James 04/06/2010 09:20PM
ERROR 1016 (HY000) at line: Can't open file: './test/Tablename.frm' (errno: 24)   4,461 vikas warad 04/05/2010 06:24AM
Partition-wise mysqldump backup script at MySQL Forge   2,845 Roland Bouman 03/30/2010 03:17AM
Partitions outside of date range is included   3,526 Marius S 03/18/2010 10:22AM
Re: Partitions outside of date range is included   1,804 Mattias Jonsson 03/24/2010 09:30AM
Re: Partitions outside of date range is included   1,745 Rick James 03/20/2010 01:43PM
Can't repair/rebuild my partitions   3,363 Andreas Thorstensson 03/15/2010 07:20AM
Re: Can't repair/rebuild my partitions   1,681 Mattias Jonsson 03/24/2010 08:44AM
This topic has been moved.:  Partition querry   0 Ionut Filip 09/28/2010 07:57PM
This topic has been moved.:  Partition Pruning   0 Andrew McGhie 09/17/2010 07:59AM
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.