Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Workbench 6.3.3 GA has been released 04/24/2015 08:36AM
MySQL Connector/Python 2.0.4 GA has been released 04/22/2015 02:03AM
MySQL Cluster 7.3.9 has been released 04/15/2015 11:11PM
MySQL Cluster Manager 1.3.5 has been released 04/15/2015 10:42AM
MySQL Cluster 7.4.6 has been released 04/14/2015 07:07AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 4 of 12
Subject Views Written By Posted
Range partition ordering for ORDER BY LIMIT queries   3,067 Nikos Sarkas 01/27/2011 05:21PM
Re: Range partition ordering for ORDER BY LIMIT queries   992 Mattias Jonsson 02/22/2011 05:22AM
error 1032 : cannot find record when updating a view   1,674 Hugo T. 02/07/2011 08:48PM
Re: error 1032 : cannot find record when updating a view   886 Mattias Jonsson 02/22/2011 04:49AM
CREATE_TIME is NULL for all partitions   3,498 Urs Weiss 01/25/2011 08:32AM
Re: CREATE_TIME is NULL for all partitions   990 Rick James 01/26/2011 09:14PM
Re: CREATE_TIME is NULL for all partitions   1,012 Urs Weiss 01/27/2011 01:03AM
Re: CREATE_TIME is NULL for all partitions   1,017 Rick James 01/27/2011 10:05AM
Re: CREATE_TIME is NULL for all partitions   1,270 Urs Weiss 01/28/2011 01:24AM
PARTITION BY RANGE ,problem for NULL values   3,312 soumen chowdhury 01/19/2011 11:55PM
Re: PARTITION BY RANGE ,problem for NULL values   1,167 Mattias Jonsson 01/20/2011 05:32AM
Re: PARTITION BY RANGE ,problem for NULL values   1,754 soumen chowdhury 01/20/2011 06:10AM
Re: PARTITION BY RANGE ,problem for NULL values   1,106 Mattias Jonsson 01/20/2011 07:05AM
Re: PARTITION BY RANGE ,problem for NULL values   1,009 soumen chowdhury 01/25/2011 01:29AM
Re: PARTITION BY RANGE ,problem for NULL values   1,404 soumen chowdhury 01/21/2011 12:54AM
Re: PARTITION BY RANGE ,problem for NULL values   1,537 Rick James 01/23/2011 12:08PM
Re: PARTITION BY RANGE ,problem for NULL values   1,786 soumen chowdhury 01/19/2011 11:59PM
Get Partition Tables   1,555 Shahzad Salam Kasi 01/20/2011 05:49AM
Re: Get Partition Tables   834 Rick James 01/23/2011 11:54AM
Partition by threadid or postid?   1,855 Lam Vu Nhat 01/11/2011 03:01AM
Re: Partition by threadid or postid?   1,067 Rick James 01/12/2011 10:29AM
Is there a SWITCH equivalent in MySQL?   2,852 John Gagnon 12/22/2010 02:27PM
Re: Is there a SWITCH equivalent in MySQL?   1,285 Mattias Jonsson 01/02/2011 04:41PM
Re: Is there a SWITCH equivalent in MySQL?   1,093 Rick James 12/24/2010 10:48AM
mysql tools   1,391 harry singh 12/25/2010 01:27AM
foreign key in partition   3,052 harry singh 12/24/2010 06:02AM
Re: foreign key in partition   1,182 Aftab Khan 12/24/2010 11:09AM
Re: foreign key in partition   1,065 harry singh 12/25/2010 01:25AM
Using partitioning with ARCHIVE engine for data archiving   3,441 Veerabahu Subramanian 12/20/2010 10:12AM
Re: Using partitioning with ARCHIVE engine for data archiving   1,916 Mattias Jonsson 12/20/2010 04:53PM
Re: Using partitioning with ARCHIVE engine for data archiving   1,162 Veerabahu Subramanian 12/22/2010 08:51AM
Re: Using partitioning with ARCHIVE engine for data archiving   1,309 Veerabahu Subramanian 12/21/2010 11:20PM
partition full scan   1,598 arun roy manoharan 12/13/2010 06:55AM
Re: partition full scan   1,077 Mattias Jonsson 12/14/2010 04:58AM
Partitions by key alternatively empty   1,964 Mat N 12/10/2010 06:24AM
Re: Partitions by key alternatively empty   976 Rick James 12/11/2010 02:04PM
Re: Partitions by key alternatively empty   974 Mat N 12/13/2010 08:01AM
Re: Partitions by key alternatively empty   934 Mattias Jonsson 12/14/2010 04:47AM
Partition by year and month   12,482 IGGt . 12/07/2010 08:35AM
Re: Partition by year and month   5,135 Rick James 12/08/2010 10:01PM
Re: Partition by year and month   4,639 IGGt . 12/13/2010 03:07AM
Re: Partition by year and month   4,368 Rick James 12/13/2010 08:22AM
Re: Partition by year and month   4,370 IGGt . 12/13/2010 08:25AM
MySQL Partitioning impact on MySQL Replication   1,480 Edwin DeSouza 12/11/2010 02:15PM
Partitioning increasing query time   1,735 kushal kewlani 12/09/2010 07:38AM
Re: Partitioning increasing query time   979 Rick James 12/10/2010 11:49AM
A first table partitioning exercise.   2,157 patrick flaherty 12/01/2010 06:15PM
Re: A first table partitioning exercise.   959 patrick flaherty 12/05/2010 12:28PM
Re: A first table partitioning exercise.   1,029 patrick flaherty 12/03/2010 03:46PM
Re: A first table partitioning exercise.   1,958 Mattias Jonsson 12/04/2010 06:00AM
Re: A first table partitioning exercise.   911 patrick flaherty 12/04/2010 01:40PM
Re: A first table partitioning exercise.   956 Mattias Jonsson 12/04/2010 05:38PM
Re: A first table partitioning exercise.   1,067 Mattias Jonsson 12/02/2010 03:03PM
Re: A first table partitioning exercise.   1,122 Rick James 12/02/2010 11:00PM
Re: A first table partitioning exercise.   1,006 patrick flaherty 12/01/2010 06:49PM
not able to create multi column partition keys   3,057 jose PK 12/02/2010 03:06AM
Re: not able to create multi column partition keys   1,114 Mattias Jonsson 12/02/2010 10:31AM
Re: not able to create multi column partition keys   2,742 jose PK 12/03/2010 02:02AM
Re: not able to create multi column partition keys   2,014 Mattias Jonsson 12/03/2010 03:11AM
Re: not able to create multi column partition keys   1,222 Rick James 12/05/2010 12:46AM
Re: not able to create multi column partition keys   1,054 jose PK 12/03/2010 03:41AM
Moving data from HEAP table to KEY partitioned ISAM table - advice needed   1,834 Simon Hubbard 11/26/2010 06:09AM
Re: Moving data from HEAP table to KEY partitioned ISAM table - advice needed   913 Rick James 11/27/2010 11:57AM
Restrict users to individual records   1,719 Michael Burns 11/18/2010 04:27PM
Re: Restrict users to individual records   866 Rick James 11/20/2010 02:48PM
Use Partition to split data for user   1,974 Nicola Campanelli 10/10/2010 01:23AM
Re: Use Partition to split data for user   965 Mattias Jonsson 11/08/2010 06:22AM
Is Partitioning a good way to handle deletes?   1,548 John Smith 11/06/2010 05:34PM
Re: Is Partitioning a good way to handle deletes?   876 Mattias Jonsson 11/08/2010 06:19AM
slower queries after partitioning   4,118 Mat private 10/21/2010 11:46AM
Re: slower queries after partitioning   1,648 Rick James 10/23/2010 01:24AM
Re: slower queries after partitioning   1,120 Mat private 10/25/2010 07:39AM
Re: slower queries after partitioning   1,187 Mat private 10/25/2010 08:04AM
Re: slower queries after partitioning   1,143 Mat private 10/23/2010 10:57AM
Re: slower queries after partitioning   1,234 Rick James 10/23/2010 06:09PM
Re: slower queries after partitioning   1,157 Mat private 10/24/2010 02:30AM
Re: slower queries after partitioning   1,232 Mat private 10/23/2010 10:48AM
Re: slower queries after partitioning   1,390 Mat private 10/23/2010 08:44AM
Re: slower queries after partitioning   1,671 Rick James 10/23/2010 09:43AM
Partitioning help   1,892 Anantha Varatharajan 09/24/2010 02:16AM
Re: Partitioning help   1,078 Rick James 09/25/2010 01:09PM
Re: Partitioning help   995 Anantha Varatharajan 09/27/2010 03:43AM
Re: Partitioning help   997 Rick James 09/27/2010 07:55PM
Re: Partitioning help   941 Anantha Varatharajan 10/12/2010 01:55AM
Re: Partitioning help   944 Rick James 10/12/2010 08:03AM
Re: Partitioning help   899 Anantha Varatharajan 10/13/2010 03:27AM
Re: Partitioning help   940 Rick James 10/13/2010 06:03PM
partition by rows & fields   1,584 Stan Chernov 10/06/2010 09:35AM
Re: partition by rows & fields   801 Rick James 10/10/2010 01:02PM
When do I start... partitioning?   1,764 Keysle Sorm 10/08/2010 10:52PM
Re: When do I start... partitioning?   1,009 Rick James 10/10/2010 11:23AM
Partition querry   1,988 Ionut Filip 09/28/2010 01:58AM
Re: Partition querry   936 Mattias Jonsson 09/29/2010 04:56AM
Re: Partition querry   987 Rick James 09/28/2010 05:46PM
Re: Partition querry   967 Large Arnaud 09/28/2010 06:08AM
Partition Pruning   2,295 Andrew McGhie 09/17/2010 06:04AM
Re: Partition Pruning   1,100 Rick James 09/21/2010 04:33PM
Re: Partition Pruning   994 Andrew McGhie 09/23/2010 09:17AM
Re: Partition Pruning   1,107 Mattias Jonsson 09/28/2010 10:51AM
Re: Partition Pruning   947 Rick James 09/28/2010 04:52PM
Re: Partition Pruning   1,334 Mattias Jonsson 09/29/2010 04:49AM
Re: Partition Pruning   1,071 Shawn Taylor 09/21/2010 02:41PM
Re: Partition Pruning   1,025 laptop alias 09/17/2010 06:43AM
Partition Pruning   1,897 Andrew McGhie 09/17/2010 07:18AM
Re: Partition Pruning   995 Rick James 09/18/2010 04:13PM
Re: Partition Pruning   951 Mattias Jonsson 09/28/2010 10:59AM
Re: Partition Pruning   1,010 Andrew McGhie 09/17/2010 07:23AM
Pruning problem.   1,769 Vladimiro Puggelli 09/21/2010 04:03AM
Re: Pruning problem.   944 Rick James 09/22/2010 07:57PM
Re: Pruning problem.   996 Vladimiro Puggelli 09/23/2010 03:16AM
Re: Pruning problem.   949 Rick James 09/23/2010 08:40AM
Re: Pruning problem.   904 Vladimiro Puggelli 09/24/2010 02:24AM
Re: Pruning problem.   1,012 Mattias Jonsson 09/28/2010 10:38AM
After partition also select is scanning all the partitions - need help   1,999 Venkat V 09/13/2010 08:50AM
Re: After partition also select is scanning all the partitions - need help   928 Mattias Jonsson 09/28/2010 10:31AM
Re: After partition also select is scanning all the partitions - need help   1,052 Rick James 09/14/2010 08:20PM
Re: After partition also select is scanning all the partitions - need help   1,093 Venkat V 09/16/2010 07:06PM
Re: After partition also select is scanning all the partitions - need help   1,025 Rick James 09/16/2010 08:51PM
Re: After partition also select is scanning all the partitions - need help   1,051 Venkat V 09/16/2010 09:45PM
Re: After partition also select is scanning all the partitions - need help   1,015 Rick James 09/16/2010 10:00PM
Re: After partition also select is scanning all the partitions - need help   975 Venkat V 09/21/2010 12:17AM
Re: After partition also select is scanning all the partitions - need help   965 Rick James 09/21/2010 04:18PM
Re: After partition also select is scanning all the partitions - need help   1,004 Venkat V 09/24/2010 06:14AM
Re: After partition also select is scanning all the partitions - need help   1,046 Rick James 09/24/2010 10:06PM
Re: After partition also select is scanning all the partitions - need help   1,322 Venkat V 09/24/2010 11:33PM
Re: After partition also select is scanning all the partitions - need help   1,027 Rick James 09/25/2010 01:27PM
How can I decide which partition type can I chose   2,928 Suresh Chary 09/08/2010 07:00AM
Re: How can I decide which partition type can I chose   1,067 john hango 09/09/2010 02:28PM
Re: How can I decide which partition type can I chose   1,112 Rick James 09/12/2010 03:11PM
Re: How can I decide which partition type can I chose   1,179 Rick James 09/13/2010 11:03AM
Re: How can I decide which partition type can I chose   999 Suresh Chary 09/14/2010 06:27AM
Re: How can I decide which partition type can I chose   1,502 Rick James 09/14/2010 07:44AM
Re: How can I decide which partition type can I chose   1,126 Suresh Chary 09/12/2010 10:10PM
Do I have to re write querries when Partitioning?   3,137 john hango 09/01/2010 11:17PM
Re: Do I have to re write querries when Partitioning?   1,212 Rick James 09/03/2010 07:26PM
Re: Do I have to re write querries when Partitioning?   1,314 john hango 09/05/2010 07:43PM
Re: Do I have to re write querries when Partitioning?   1,052 Rick James 09/10/2010 08:00PM
Re: Do I have to re write querries when Partitioning?   1,165 john hango 09/05/2010 07:45PM
Re: Do I have to re write querries when Partitioning?   1,060 john hango 09/05/2010 07:47PM
Re: Do I have to re write querries when Partitioning?   1,263 john hango 09/05/2010 07:51PM
Re: Do I have to re write querries when Partitioning?   1,414 john hango 09/05/2010 07:52PM
Here are some of the crons that run.   1,023 john hango 09/06/2010 11:38PM
Re: Here are some of the crons that run.   1,205 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,657 john hango 09/08/2010 11:33AM
Re: Do I have to re write querries when Partitioning?   985 john hango 09/05/2010 07:52PM
Re: Do I have to re write querries when Partitioning?   1,105 john hango 09/02/2010 04:09AM
Evolve from Partition to Sharding?   2,872 John Smith 08/21/2010 04:56AM
Re: Evolve from Partition to Sharding?   1,253 Rick James 08/22/2010 09:02AM
Re: Evolve from Partition to Sharding?   1,662 John Smith 08/23/2010 12:03AM
Re: Evolve from Partition to Sharding?   1,148 Andy Grove 08/27/2010 07:41AM
Re: Evolve from Partition to Sharding?   1,141 Rick James 08/23/2010 12:42AM
Re: Evolve from Partition to Sharding?   1,782 John Smith 08/23/2010 12:48AM
Re: Evolve from Partition to Sharding?   1,099 Rick James 08/23/2010 09:45PM
Re: Evolve from Partition to Sharding?   1,206 John Smith 08/23/2010 10:18PM
Mysql cluster 7.1.5 can't use table partition!   2,173 yan wenwu 08/25/2010 10:13AM
Re: Mysql cluster 7.1.5 can't use table partition!   1,150 Rick James 08/26/2010 10:27PM
How to move InnoDB partitions from one machine to another?   1,887 John Smith 08/26/2010 03:16AM
Hash/key Partition by something other than PK   2,149 John Smith 08/23/2010 05:50AM
Re: Hash/key Partition by something other than PK   1,135 Rick James 08/24/2010 11:59PM
about SUBPARTITIONING BEHAVIOR ...   1,806 08/18/2010 07:46AM
Re: about SUBPARTITIONING BEHAVIOR ...   1,020 Mattias Jonsson 08/19/2010 05:59AM
first partition always   1,930 N N 08/10/2010 03:29AM
Re: first partition always   1,033 Aftab Khan 08/11/2010 05:44AM
Partitioning on the basis of DAY() function   2,997 Mirza Misbah Ulhaq 08/03/2010 07:09AM
Re: Partitioning on the basis of DAY() function   1,165 Rick James 08/04/2010 09:38PM
Partitioning dilemma   2,091 Philopator Ptolemy 07/20/2010 08:51AM
Re: Partitioning dilemma   1,118 Rick James 07/21/2010 11:58AM
Re: Partitioning dilemma   1,076 Philopator Ptolemy 07/21/2010 01:47PM
Re: Partitioning dilemma   1,183 Rick James 07/26/2010 11:15PM
Re: Partitioning dilemma   998 Philopator Ptolemy 07/27/2010 09:02AM
Re: Partitioning dilemma   1,017 Rick James 07/27/2010 08:06PM
MySQL DB Size increase after partitioning   3,126 Ronald Higgins 07/25/2010 11:37AM
Re: MySQL DB Size increase after partitioning   1,225 Rick James 07/26/2010 11:02PM
Why null errors in partition insert without nulls ??   2,051 Jorge Torralba 07/13/2010 12:21PM
Re: Why null errors in partition insert without nulls ??   1,066 Rick James 07/25/2010 10:29PM
Re: Why null errors in partition insert without nulls ??   1,060 Jonathon Coombes 07/24/2010 11:03PM
Using MySQL Partitioning Instead of MERGE Tables   1,958 Edwin DeSouza 07/24/2010 03:38PM
partitioning by month and pruning   1,701 Jorge Torralba 07/13/2010 11:51AM
Partition Pruning based on subquery / join result   3,193 Justin Holdsworth 07/09/2010 03:54AM
Re: Partition Pruning based on subquery / join result   1,477 Rick James 07/11/2010 11:30AM
Re: Partition Pruning based on subquery / join result   1,447 Justin Holdsworth 07/12/2010 05:05AM
Re: Partition Pruning based on subquery / join result   1,391 Rick James 07/12/2010 11:41PM
Re: Partition Pruning based on subquery / join result   1,435 Justin Holdsworth 07/13/2010 09:33AM
Partition table not support foreign key feature ?   2,218 Mayur P Vegad 06/30/2010 04:41AM
Re: Partition table not support foreign key feature ?   1,103 Rick James 07/01/2010 11:12PM
Re: Partition table not support foreign key feature ?   1,615 Mayur P Vegad 07/02/2010 05:05AM
Re: Partition table not support foreign key feature ?   1,422 Rick James 07/03/2010 12:35AM
Strange first partition behavior while pruning on table partitioned by date.   2,396 Alexey Efremov 06/29/2010 09:46AM
Re: Strange first partition behavior while pruning on table partitioned by date.   1,150 Rick James 06/30/2010 08:51PM
Re: Strange first partition behavior while pruning on table partitioned by date.   1,071 Alexey Efremov 07/01/2010 06:10AM
Exceptions with Partition Pruning   2,957 ratheesh balakrishnan 06/10/2010 04:36PM
Re: Exceptions with Partition Pruning   1,325 Rick James 06/12/2010 01:21AM
Re: Exceptions with Partition Pruning   1,232 ratheesh balakrishnan 06/14/2010 01:10PM
Re: Exceptions with Partition Pruning   1,173 Rick James 06/16/2010 09:31AM
Re: Exceptions with Partition Pruning   1,339 ratheesh balakrishnan 06/16/2010 05:28PM
Rebuilding vs. Optimizing Partition, Time Elapsed to complete   2,215 Thomas Lekai 06/07/2010 04:12PM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete   1,388 Mattias Jonsson 06/15/2010 04:51AM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete   1,349 Rick James 06/09/2010 09:40AM
Lock wait timeouts and partitioning   1,917 Mark Richman 06/05/2010 07:47AM
Re: Lock wait timeouts and partitioning   1,233 Rick James 06/06/2010 08:53AM
Re: Lock wait timeouts and partitioning   1,251 Mattias Jonsson 06/15/2010 04:42AM
This topic has been moved.:  A first table partitioning exercise.   0 patrick flaherty 12/01/2010 11:45PM
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
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 4 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.