MySQL Forums
Forum List  »  Partitioning
Announcements Last Post
•   Announcing April 2026 Releases featuring MySQL Server 9.7.0, 8.4.9 and 8.0.46 04/27/2026 03:22AM

Advanced Search
New Topic
Pages:
« 1
...
4 5 6 7 8
...
14 »

Subject
Views
Written By
Posted
slower queries after partitioning  
8,481
Mat private
10/21/2010 11:46AM
Re: slower queries after partitioning  
3,479
Rick James
10/23/2010 01:24AM
Re: slower queries after partitioning  
2,235
Mat private
10/25/2010 07:39AM
Re: slower queries after partitioning  
2,290
Mat private
10/25/2010 08:04AM
Re: slower queries after partitioning  
2,402
Mat private
10/23/2010 10:57AM
Re: slower queries after partitioning  
2,503
Rick James
10/23/2010 06:09PM
Re: slower queries after partitioning  
2,228
Mat private
10/24/2010 02:30AM
Re: slower queries after partitioning  
2,422
Mat private
10/23/2010 10:48AM
Re: slower queries after partitioning  
2,823
Mat private
10/23/2010 08:44AM
Re: slower queries after partitioning  
3,015
Rick James
10/23/2010 09:43AM
Partitioning help  
3,712
Anantha Varatharajan
09/24/2010 02:16AM
Re: Partitioning help  
1,973
Rick James
09/25/2010 01:09PM
Re: Partitioning help  
1,924
Anantha Varatharajan
09/27/2010 03:43AM
Re: Partitioning help  
1,974
Rick James
09/27/2010 07:55PM
Re: Partitioning help  
1,867
Anantha Varatharajan
10/12/2010 01:55AM
Re: Partitioning help  
1,845
Rick James
10/12/2010 08:03AM
Re: Partitioning help  
1,753
Anantha Varatharajan
10/13/2010 03:27AM
Re: Partitioning help  
1,782
Rick James
10/13/2010 06:03PM
partition by rows & fields  
3,060
Stan Chernov
10/06/2010 09:35AM
Re: partition by rows & fields  
1,499
Rick James
10/10/2010 01:02PM
When do I start... partitioning?  
3,599
Keysle Sorm
10/08/2010 10:52PM
Re: When do I start... partitioning?  
1,969
Rick James
10/10/2010 11:23AM
Partition querry  
3,473
Ionut Filip
09/28/2010 01:58AM
Re: Partition querry  
1,798
Mattias Jonsson
09/29/2010 04:56AM
Re: Partition querry  
1,698
Rick James
09/28/2010 05:46PM
Re: Partition querry  
1,758
Large Arnaud
09/28/2010 06:08AM
Partition Pruning  
4,728
Andrew McGhie
09/17/2010 06:04AM
Re: Partition Pruning  
1,777
Rick James
09/21/2010 04:33PM
Re: Partition Pruning  
1,798
Andrew McGhie
09/23/2010 09:17AM
Re: Partition Pruning  
1,913
Mattias Jonsson
09/28/2010 10:51AM
Re: Partition Pruning  
1,725
Rick James
09/28/2010 04:52PM
Re: Partition Pruning  
2,396
Mattias Jonsson
09/29/2010 04:49AM
Re: Partition Pruning  
1,877
Shawn Taylor
09/21/2010 02:41PM
Re: Partition Pruning  
1,782
laptop alias
09/17/2010 06:43AM
Partition Pruning  
3,594
Andrew McGhie
09/17/2010 07:18AM
Re: Partition Pruning  
1,759
Rick James
09/18/2010 04:13PM
Re: Partition Pruning  
1,715
Mattias Jonsson
09/28/2010 10:59AM
Re: Partition Pruning  
1,753
Andrew McGhie
09/17/2010 07:23AM
Pruning problem.  
3,144
Vladimiro Puggelli
09/21/2010 04:03AM
Re: Pruning problem.  
1,756
Rick James
09/22/2010 07:57PM
Re: Pruning problem.  
1,777
Vladimiro Puggelli
09/23/2010 03:16AM
Re: Pruning problem.  
1,784
Rick James
09/23/2010 08:40AM
Re: Pruning problem.  
1,651
Vladimiro Puggelli
09/24/2010 02:24AM
Re: Pruning problem.  
1,863
Mattias Jonsson
09/28/2010 10:38AM
After partition also select is scanning all the partitions - need help  
3,954
Venkat V
09/13/2010 08:50AM
Re: After partition also select is scanning all the partitions - need help  
2,001
Mattias Jonsson
09/28/2010 10:31AM
Re: After partition also select is scanning all the partitions - need help  
1,997
Rick James
09/14/2010 08:20PM
Re: After partition also select is scanning all the partitions - need help  
2,201
Venkat V
09/16/2010 07:06PM
Re: After partition also select is scanning all the partitions - need help  
2,054
Rick James
09/16/2010 08:51PM
Re: After partition also select is scanning all the partitions - need help  
1,972
Venkat V
09/16/2010 09:45PM
Re: After partition also select is scanning all the partitions - need help  
1,985
Rick James
09/16/2010 10:00PM
Re: After partition also select is scanning all the partitions - need help  
1,947
Venkat V
09/21/2010 12:17AM
Re: After partition also select is scanning all the partitions - need help  
2,006
Rick James
09/21/2010 04:18PM
Re: After partition also select is scanning all the partitions - need help  
2,010
Venkat V
09/24/2010 06:14AM
Re: After partition also select is scanning all the partitions - need help  
2,089
Rick James
09/24/2010 10:06PM
Re: After partition also select is scanning all the partitions - need help  
2,303
Venkat V
09/24/2010 11:33PM
Re: After partition also select is scanning all the partitions - need help  
2,025
Rick James
09/25/2010 01:27PM
How can I decide which partition type can I chose  
4,922
Suresh Chary
09/08/2010 07:00AM
Re: How can I decide which partition type can I chose  
1,749
john hango
09/09/2010 02:28PM
Re: How can I decide which partition type can I chose  
1,989
Rick James
09/12/2010 03:11PM
Re: How can I decide which partition type can I chose  
1,999
Rick James
09/13/2010 11:03AM
Re: How can I decide which partition type can I chose  
1,830
Suresh Chary
09/14/2010 06:27AM
Re: How can I decide which partition type can I chose  
2,534
Rick James
09/14/2010 07:44AM
Re: How can I decide which partition type can I chose  
2,067
Suresh Chary
09/12/2010 10:10PM
Do I have to re write querries when Partitioning?  
5,474
john hango
09/01/2010 11:17PM
Re: Do I have to re write querries when Partitioning?  
2,252
Rick James
09/03/2010 07:26PM
Re: Do I have to re write querries when Partitioning?  
5,762
john hango
09/05/2010 07:43PM
Re: Do I have to re write querries when Partitioning?  
2,024
Rick James
09/10/2010 08:00PM
Re: Do I have to re write querries when Partitioning?  
2,401
john hango
09/05/2010 07:45PM
Re: Do I have to re write querries when Partitioning?  
9,891
john hango
09/05/2010 07:47PM
Re: Do I have to re write querries when Partitioning?  
4,133
john hango
09/05/2010 07:51PM
Re: Do I have to re write querries when Partitioning?  
4,114
john hango
09/05/2010 07:52PM
Here are some of the crons that run.  
1,957
john hango
09/06/2010 11:38PM
Re: Here are some of the crons that run.  
2,572
john hango
09/06/2010 11:39PM
Slowest query is when I click on a category on my site that has alot of products  
3,667
john hango
09/08/2010 11:33AM
Re: Do I have to re write querries when Partitioning?  
2,162
john hango
09/05/2010 07:52PM
Re: Do I have to re write querries when Partitioning?  
2,069
john hango
09/02/2010 04:09AM
Evolve from Partition to Sharding?  
4,504
John Smith
08/21/2010 04:56AM
Re: Evolve from Partition to Sharding?  
2,035
Rick James
08/22/2010 09:02AM
Re: Evolve from Partition to Sharding?  
2,656
John Smith
08/23/2010 12:03AM
Re: Evolve from Partition to Sharding?  
2,059
Andy Grove
08/27/2010 07:41AM
Re: Evolve from Partition to Sharding?  
1,824
Rick James
08/23/2010 12:42AM
Re: Evolve from Partition to Sharding?  
2,695
John Smith
08/23/2010 12:48AM
Re: Evolve from Partition to Sharding?  
1,840
Rick James
08/23/2010 09:45PM
Re: Evolve from Partition to Sharding?  
2,005
John Smith
08/23/2010 10:18PM
Mysql cluster 7.1.5 can't use table partition!  
3,850
yan wenwu
08/25/2010 10:13AM
Re: Mysql cluster 7.1.5 can't use table partition!  
1,958
Rick James
08/26/2010 10:27PM
How to move InnoDB partitions from one machine to another?  
3,404
John Smith
08/26/2010 03:16AM
Hash/key Partition by something other than PK  
3,462
John Smith
08/23/2010 05:50AM
Re: Hash/key Partition by something other than PK  
1,750
Rick James
08/24/2010 11:59PM
about SUBPARTITIONING BEHAVIOR ...  
3,362
08/18/2010 07:46AM
Re: about SUBPARTITIONING BEHAVIOR ...  
1,727
Mattias Jonsson
08/19/2010 05:59AM
first partition always  
3,180
N N
08/10/2010 03:29AM
Re: first partition always  
1,709
Aftab Khan
08/11/2010 05:44AM
Partitioning on the basis of DAY() function  
4,317
Mirza Misbah Ulhaq
08/03/2010 07:09AM
Re: Partitioning on the basis of DAY() function  
1,835
Rick James
08/04/2010 09:38PM
Partitioning dilemma  
3,394
Philopator Ptolemy
07/20/2010 08:51AM
Re: Partitioning dilemma  
1,945
Rick James
07/21/2010 11:58AM
Re: Partitioning dilemma  
1,826
Philopator Ptolemy
07/21/2010 01:47PM
Re: Partitioning dilemma  
1,963
Rick James
07/26/2010 11:15PM
Re: Partitioning dilemma  
1,714
Philopator Ptolemy
07/27/2010 09:02AM
Re: Partitioning dilemma  
1,797
Rick James
07/27/2010 08:06PM
MySQL DB Size increase after partitioning  
4,886
Ronald Higgins
07/25/2010 11:37AM
Re: MySQL DB Size increase after partitioning  
2,078
Rick James
07/26/2010 11:02PM
Why null errors in partition insert without nulls ??  
3,445
Jorge Torralba
07/13/2010 12:21PM
Re: Why null errors in partition insert without nulls ??  
1,640
Rick James
07/25/2010 10:29PM
Re: Why null errors in partition insert without nulls ??  
1,699
Jonathon Coombes
07/24/2010 11:03PM
Using MySQL Partitioning Instead of MERGE Tables  
3,835
Edwin DeSouza
07/24/2010 03:38PM
partitioning by month and pruning  
3,213
Jorge Torralba
07/13/2010 11:51AM
Partition Pruning based on subquery / join result  
6,124
Justin Holdsworth
07/09/2010 03:54AM
Re: Partition Pruning based on subquery / join result  
2,428
Rick James
07/11/2010 11:30AM
Re: Partition Pruning based on subquery / join result  
2,577
Justin Holdsworth
07/12/2010 05:05AM
Re: Partition Pruning based on subquery / join result  
2,553
Rick James
07/12/2010 11:41PM
Re: Partition Pruning based on subquery / join result  
2,350
Justin Holdsworth
07/13/2010 09:33AM
Partition table not support foreign key feature ?  
3,649
Mayur P Vegad
06/30/2010 04:41AM
Re: Partition table not support foreign key feature ?  
1,802
Rick James
07/01/2010 11:12PM
Re: Partition table not support foreign key feature ?  
2,358
Mayur P Vegad
07/02/2010 05:05AM
Re: Partition table not support foreign key feature ?  
2,287
Rick James
07/03/2010 12:35AM
Strange first partition behavior while pruning on table partitioned by date.  
3,855
Alexey Efremov
06/29/2010 09:46AM
Re: Strange first partition behavior while pruning on table partitioned by date.  
1,845
Rick James
06/30/2010 08:51PM
Re: Strange first partition behavior while pruning on table partitioned by date.  
1,749
Alexey Efremov
07/01/2010 06:10AM
Exceptions with Partition Pruning  
4,739
ratheesh balakrishnan
06/10/2010 04:36PM
Re: Exceptions with Partition Pruning  
2,143
Rick James
06/12/2010 01:21AM
Re: Exceptions with Partition Pruning  
2,202
ratheesh balakrishnan
06/14/2010 01:10PM
Re: Exceptions with Partition Pruning  
1,874
Rick James
06/16/2010 09:31AM
Re: Exceptions with Partition Pruning  
2,259
ratheesh balakrishnan
06/16/2010 05:28PM
Rebuilding vs. Optimizing Partition, Time Elapsed to complete  
3,629
Thomas Lekai
06/07/2010 04:12PM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete  
2,034
Mattias Jonsson
06/15/2010 04:51AM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete  
2,079
Rick James
06/09/2010 09:40AM
Lock wait timeouts and partitioning  
3,041
Mark Richman
06/05/2010 07:47AM
Re: Lock wait timeouts and partitioning  
1,800
Rick James
06/06/2010 08:53AM
Re: Lock wait timeouts and partitioning  
1,847
Mattias Jonsson
06/15/2010 04:42AM
Huge Disk Write while performing delete operation  
3,173
Ramesh Kumar
06/10/2010 10:17PM
Re: Huge Disk Write while performing delete operation  
1,739
Rick James
06/12/2010 12:50AM
Linear Partioning vs Ordinary  
4,805
Double Dragon
03/15/2010 02:31AM
Re: Linear Partioning vs Ordinary  
1,955
ratheesh balakrishnan
06/11/2010 04:09PM
Re: Linear Partioning vs Ordinary  
2,432
Mattias Jonsson
03/24/2010 09:23AM
Re: Linear Partioning vs Ordinary  
2,399
Rick James
03/19/2010 08:09AM
Can not partition existings tables  
3,498
Olivier Bourdon
06/03/2010 04:06AM
Re: Can not partition existings tables  
2,029
Rick James
06/04/2010 08:22PM
Re: Can not partition existings tables  
1,978
Olivier Bourdon
06/07/2010 03:55AM
Re: Can not partition existings tables  
1,927
Rick James
06/07/2010 11:18PM
Key Partition Performance Measurement  
4,654
Imran Pathan
05/25/2010 01:05AM
Re: Key Partition Performance Measurement  
1,937
Rick James
05/28/2010 11:39PM
Re: Key Partition Performance Measurement  
1,919
Imran Pathan
05/27/2010 05:43AM
SOLVED; DISK USAGE When Alter table HASH  
3,122
Hawk T
05/25/2010 03:29PM
Re: DISK USAGE When Alter table HASH  
1,821
Hawk T
05/26/2010 09:22AM
Mystified by Partition Pruning on Dates  
3,388
John Thompson
05/19/2010 03:45AM
Re: Mystified by Partition Pruning on Dates  
1,911
Rick James
05/20/2010 07:58AM
Re: Mystified by Partition Pruning on Dates  
2,062
John Thompson
05/20/2010 08:35AM
How to handle secondary keys in partitioning?  
4,688
John Smith
05/04/2010 12:46AM
Re: How to handle secondary keys in partitioning?  
2,423
Mattias Jonsson
05/05/2010 02:20AM
Re: How to handle secondary keys in partitioning?  
2,690
John Smith
05/06/2010 12:34AM
Re: How to handle secondary keys in partitioning?  
2,272
Rick James
05/06/2010 12:04AM
Re: How to handle secondary keys in partitioning?  
2,667
Mattias Jonsson
05/06/2010 03:23PM
Re: How to handle secondary keys in partitioning?  
2,325
John Smith
05/06/2010 10:50PM
Re: How to handle secondary keys in partitioning?  
2,258
Mattias Jonsson
05/12/2010 05:29AM
Re: How to handle secondary keys in partitioning?  
2,280
Mattias Jonsson
05/07/2010 02:38AM
Re: How to handle secondary keys in partitioning?  
2,254
John Smith
05/08/2010 05:31PM
Re: How to handle secondary keys in partitioning?  
2,295
Mattias Jonsson
05/09/2010 04:37AM
Re: How to handle secondary keys in partitioning?  
2,171
John Smith
05/09/2010 12:41PM
Re: How to handle secondary keys in partitioning?  
2,147
Mattias Jonsson
05/09/2010 01:23PM
Re: How to handle secondary keys in partitioning?  
2,571
Mattias Jonsson
05/04/2010 01:29PM
Re: How to handle secondary keys in partitioning?  
2,217
John Smith
05/04/2010 04:30PM
Partition pruning - how much optimization is smart?  
3,850
Michał Stolarczyk
05/09/2010 04:21AM
Re: Partition pruning - how much optimization is smart?  
1,691
Mattias Jonsson
05/09/2010 01:28PM
Partitioning performance issues // 5.1  
4,392
Ya Wi
02/17/2010 10:53AM
Re: Partitioning performance issues // 5.1  
2,577
Mattias Jonsson
02/19/2010 04:17AM
Re: Partitioning performance issues // 5.1  
2,425
Ya Wi
02/19/2010 10:11AM
Re: Partitioning performance issues // 5.1  
3,077
Mattias Jonsson
02/19/2010 02:56PM
Re: Partitioning performance issues // 5.1  
2,716
bob hagemann
04/18/2010 04:51PM
Re: Partitioning performance issues // 5.1  
2,209
Mattias Jonsson
04/18/2010 11:31PM
problem about partition  
3,176
h ch
04/15/2010 08:01PM
Re: problem about partition  
2,051
Rick James
04/16/2010 10:08PM
Re: problem about partition  
2,025
h ch
04/18/2010 08:16PM
Partitioning tables with grouping  
3,229
sonam agarwal
04/10/2010 07:31AM
Re: Partitioning tables with grouping  
1,900
Rick James
04/11/2010 10:41PM
Re: Partitioning tables with grouping  
2,589
sonam agarwal
04/11/2010 11:00PM
Re: Partitioning tables with grouping  
1,942
Rick James
04/13/2010 11:40PM
Re: Partitioning tables with grouping  
2,088
sonam agarwal
04/14/2010 05:04AM
PARTITION BY RANGE (CHARACTER BASIS) ?  
5,699
sonam agarwal
04/10/2010 08:35AM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?  
2,346
Mattias Jonsson
04/13/2010 06:01PM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?  
2,254
sonam agarwal
04/13/2010 07:53PM
CREATING VIEWS OF A PARTITION  
3,491
Bhargavi M S
04/10/2010 10:06AM
Re: CREATING VIEWS OF A PARTITION  
1,782
Rick James
04/11/2010 10:35PM
Re: CREATING VIEWS OF A PARTITION  
2,020
Mattias Jonsson
04/13/2010 06:02PM
Partitioning Problem  
3,922
sireesh beemineni
04/09/2010 07:07AM
Re: Partitioning Problem  
1,966
Rick James
04/11/2010 10:46PM
partition pruning and DIV  
4,429
Bill Moninger
03/26/2010 11:23AM
Re: partition pruning and DIV  
2,269
Mattias Jonsson
04/07/2010 04:35PM
Re: partition pruning and DIV  
2,014
Bill Moninger
04/07/2010 05:08PM
Re: partition pruning and DIV  
1,915
Rick James
04/06/2010 09:20PM
ERROR 1016 (HY000) at line: Can't open file: './test/Tablename.frm' (errno: 24)  
6,376
vikas warad
04/05/2010 06:24AM
Partition-wise mysqldump backup script at MySQL Forge  
4,295
Roland Bouman
03/30/2010 03:17AM
Partitions outside of date range is included  
4,461
Marius S
03/18/2010 10:22AM
Re: Partitions outside of date range is included  
2,282
Mattias Jonsson
03/24/2010 09:30AM
Re: Partitions outside of date range is included  
2,143
Rick James
03/20/2010 01:43PM
Can't repair/rebuild my partitions  
4,430
Andreas Thorstensson
03/15/2010 07:20AM
Re: Can't repair/rebuild my partitions  
2,120
Mattias Jonsson
03/24/2010 08:44AM
copying from unpartitioned to partitioned table  
4,341
Rick Casey
03/09/2010 11:54AM
Re: copying from unpartitioned to partitioned table  
2,051
Mattias Jonsson
03/24/2010 08:39AM
Re: copying from unpartitioned to partitioned table  
2,396
Mattias Jonsson
03/11/2010 08:18AM
Re: copying from unpartitioned to partitioned table  
2,223
Rick Casey
03/12/2010 10:58AM
Why Unique Key Constraint?  
5,179
Double Dragon
03/14/2010 04:59AM
Re: Why Unique Key Constraint?  
2,199
Rick James
03/20/2010 03:44PM
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:
« 1
...
4 5 6 7 8
...
14 »

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.