MySQL Forums
Forum List  »  Partitioning
Announcements Last Post
•   MySQL Connector/J 5.1.43 has been released 07/21/2017 02:07PM
•   MySQL Cluster 7.5.7 has been released 07/19/2017 04:43AM
•   MySQL Cluster 7.4.16 has been released 07/18/2017 01:43PM
•   MySQL Cluster 7.2.30 has been released 07/18/2017 10:21AM
•   MySQL Community Server 8.0.2-dmr has been released (part 2/2) 07/18/2017 01:08AM

Advanced Search
New Topic
Pages:
« 1
...
3 4 5 6 7
...
13 »

Subject
Views
Written By
Posted
Partitioning increasing query time  
2,078
kushal kewlani
12/09/2010 07:38AM
Re: Partitioning increasing query time  
1,158
Rick James
12/10/2010 11:49AM
A first table partitioning exercise.  
2,522
patrick flaherty
12/01/2010 06:15PM
Re: A first table partitioning exercise.  
1,189
patrick flaherty
12/05/2010 12:28PM
Re: A first table partitioning exercise.  
1,266
patrick flaherty
12/03/2010 03:46PM
Re: A first table partitioning exercise.  
2,332
Mattias Jonsson
12/04/2010 06:00AM
Re: A first table partitioning exercise.  
1,107
patrick flaherty
12/04/2010 01:40PM
Re: A first table partitioning exercise.  
1,143
Mattias Jonsson
12/04/2010 05:38PM
Re: A first table partitioning exercise.  
1,269
Mattias Jonsson
12/02/2010 03:03PM
Re: A first table partitioning exercise.  
1,322
Rick James
12/02/2010 11:00PM
Re: A first table partitioning exercise.  
1,222
patrick flaherty
12/01/2010 06:49PM
not able to create multi column partition keys  
3,501
jose PK
12/02/2010 03:06AM
Re: not able to create multi column partition keys  
1,355
Mattias Jonsson
12/02/2010 10:31AM
Re: not able to create multi column partition keys  
3,644
jose PK
12/03/2010 02:02AM
Re: not able to create multi column partition keys  
2,264
Mattias Jonsson
12/03/2010 03:11AM
Re: not able to create multi column partition keys  
1,417
Rick James
12/05/2010 12:46AM
Re: not able to create multi column partition keys  
1,266
jose PK
12/03/2010 03:41AM
Moving data from HEAP table to KEY partitioned ISAM table - advice needed  
2,287
Simon Hubbard
11/26/2010 06:09AM
Re: Moving data from HEAP table to KEY partitioned ISAM table - advice needed  
1,111
Rick James
11/27/2010 11:57AM
Restrict users to individual records  
2,175
Michael Burns
11/18/2010 04:27PM
Re: Restrict users to individual records  
1,101
Rick James
11/20/2010 02:48PM
Use Partition to split data for user  
2,381
Nicola Campanelli
10/10/2010 01:23AM
Re: Use Partition to split data for user  
1,178
Mattias Jonsson
11/08/2010 06:22AM
Is Partitioning a good way to handle deletes?  
1,938
John Smith
11/06/2010 05:34PM
Re: Is Partitioning a good way to handle deletes?  
1,083
Mattias Jonsson
11/08/2010 06:19AM
slower queries after partitioning  
5,626
Mat private
10/21/2010 11:46AM
Re: slower queries after partitioning  
2,287
Rick James
10/23/2010 01:24AM
Re: slower queries after partitioning  
1,498
Mat private
10/25/2010 07:39AM
Re: slower queries after partitioning  
1,514
Mat private
10/25/2010 08:04AM
Re: slower queries after partitioning  
1,532
Mat private
10/23/2010 10:57AM
Re: slower queries after partitioning  
1,638
Rick James
10/23/2010 06:09PM
Re: slower queries after partitioning  
1,505
Mat private
10/24/2010 02:30AM
Re: slower queries after partitioning  
1,674
Mat private
10/23/2010 10:48AM
Re: slower queries after partitioning  
1,808
Mat private
10/23/2010 08:44AM
Re: slower queries after partitioning  
2,134
Rick James
10/23/2010 09:43AM
Partitioning help  
2,487
Anantha Varatharajan
09/24/2010 02:16AM
Re: Partitioning help  
1,327
Rick James
09/25/2010 01:09PM
Re: Partitioning help  
1,261
Anantha Varatharajan
09/27/2010 03:43AM
Re: Partitioning help  
1,243
Rick James
09/27/2010 07:55PM
Re: Partitioning help  
1,221
Anantha Varatharajan
10/12/2010 01:55AM
Re: Partitioning help  
1,225
Rick James
10/12/2010 08:03AM
Re: Partitioning help  
1,115
Anantha Varatharajan
10/13/2010 03:27AM
Re: Partitioning help  
1,250
Rick James
10/13/2010 06:03PM
partition by rows & fields  
2,073
Stan Chernov
10/06/2010 09:35AM
Re: partition by rows & fields  
1,016
Rick James
10/10/2010 01:02PM
When do I start... partitioning?  
2,254
Keysle Sorm
10/08/2010 10:52PM
Re: When do I start... partitioning?  
1,320
Rick James
10/10/2010 11:23AM
Partition querry  
2,519
Ionut Filip
09/28/2010 01:58AM
Re: Partition querry  
1,193
Mattias Jonsson
09/29/2010 04:56AM
Re: Partition querry  
1,218
Rick James
09/28/2010 05:46PM
Re: Partition querry  
1,213
Large Arnaud
09/28/2010 06:08AM
Partition Pruning  
3,030
Andrew McGhie
09/17/2010 06:04AM
Re: Partition Pruning  
1,320
Rick James
09/21/2010 04:33PM
Re: Partition Pruning  
1,245
Andrew McGhie
09/23/2010 09:17AM
Re: Partition Pruning  
1,321
Mattias Jonsson
09/28/2010 10:51AM
Re: Partition Pruning  
1,184
Rick James
09/28/2010 04:52PM
Re: Partition Pruning  
1,709
Mattias Jonsson
09/29/2010 04:49AM
Re: Partition Pruning  
1,293
Shawn Taylor
09/21/2010 02:41PM
Re: Partition Pruning  
1,252
laptop alias
09/17/2010 06:43AM
Partition Pruning  
2,535
Andrew McGhie
09/17/2010 07:18AM
Re: Partition Pruning  
1,229
Rick James
09/18/2010 04:13PM
Re: Partition Pruning  
1,213
Mattias Jonsson
09/28/2010 10:59AM
Re: Partition Pruning  
1,253
Andrew McGhie
09/17/2010 07:23AM
Pruning problem.  
2,277
Vladimiro Puggelli
09/21/2010 04:03AM
Re: Pruning problem.  
1,196
Rick James
09/22/2010 07:57PM
Re: Pruning problem.  
1,242
Vladimiro Puggelli
09/23/2010 03:16AM
Re: Pruning problem.  
1,198
Rick James
09/23/2010 08:40AM
Re: Pruning problem.  
1,139
Vladimiro Puggelli
09/24/2010 02:24AM
Re: Pruning problem.  
1,327
Mattias Jonsson
09/28/2010 10:38AM
After partition also select is scanning all the partitions - need help  
2,648
Venkat V
09/13/2010 08:50AM
Re: After partition also select is scanning all the partitions - need help  
1,317
Mattias Jonsson
09/28/2010 10:31AM
Re: After partition also select is scanning all the partitions - need help  
1,298
Rick James
09/14/2010 08:20PM
Re: After partition also select is scanning all the partitions - need help  
1,442
Venkat V
09/16/2010 07:06PM
Re: After partition also select is scanning all the partitions - need help  
1,322
Rick James
09/16/2010 08:51PM
Re: After partition also select is scanning all the partitions - need help  
1,323
Venkat V
09/16/2010 09:45PM
Re: After partition also select is scanning all the partitions - need help  
1,285
Rick James
09/16/2010 10:00PM
Re: After partition also select is scanning all the partitions - need help  
1,281
Venkat V
09/21/2010 12:17AM
Re: After partition also select is scanning all the partitions - need help  
1,314
Rick James
09/21/2010 04:18PM
Re: After partition also select is scanning all the partitions - need help  
1,339
Venkat V
09/24/2010 06:14AM
Re: After partition also select is scanning all the partitions - need help  
1,382
Rick James
09/24/2010 10:06PM
Re: After partition also select is scanning all the partitions - need help  
1,606
Venkat V
09/24/2010 11:33PM
Re: After partition also select is scanning all the partitions - need help  
1,381
Rick James
09/25/2010 01:27PM
How can I decide which partition type can I chose  
3,620
Suresh Chary
09/08/2010 07:00AM
Re: How can I decide which partition type can I chose  
1,280
john hango
09/09/2010 02:28PM
Re: How can I decide which partition type can I chose  
1,416
Rick James
09/12/2010 03:11PM
Re: How can I decide which partition type can I chose  
1,389
Rick James
09/13/2010 11:03AM
Re: How can I decide which partition type can I chose  
1,185
Suresh Chary
09/14/2010 06:27AM
Re: How can I decide which partition type can I chose  
1,823
Rick James
09/14/2010 07:44AM
Re: How can I decide which partition type can I chose  
1,484
Suresh Chary
09/12/2010 10:10PM
Do I have to re write querries when Partitioning?  
3,818
john hango
09/01/2010 11:17PM
Re: Do I have to re write querries when Partitioning?  
1,591
Rick James
09/03/2010 07:26PM
Re: Do I have to re write querries when Partitioning?  
1,699
john hango
09/05/2010 07:43PM
Re: Do I have to re write querries when Partitioning?  
1,345
Rick James
09/10/2010 08:00PM
Re: Do I have to re write querries when Partitioning?  
1,589
john hango
09/05/2010 07:45PM
Re: Do I have to re write querries when Partitioning?  
1,387
john hango
09/05/2010 07:47PM
Re: Do I have to re write querries when Partitioning?  
1,632
john hango
09/05/2010 07:51PM
Re: Do I have to re write querries when Partitioning?  
1,773
john hango
09/05/2010 07:52PM
Here are some of the crons that run.  
1,276
john hango
09/06/2010 11:38PM
Re: Here are some of the crons that run.  
1,611
john hango
09/06/2010 11:39PM
Slowest query is when I click on a category on my site that has alot of products  
2,200
john hango
09/08/2010 11:33AM
Re: Do I have to re write querries when Partitioning?  
1,351
john hango
09/05/2010 07:52PM
Re: Do I have to re write querries when Partitioning?  
1,386
john hango
09/02/2010 04:09AM
Evolve from Partition to Sharding?  
3,432
John Smith
08/21/2010 04:56AM
Re: Evolve from Partition to Sharding?  
1,521
Rick James
08/22/2010 09:02AM
Re: Evolve from Partition to Sharding?  
1,968
John Smith
08/23/2010 12:03AM
Re: Evolve from Partition to Sharding?  
1,432
Andy Grove
08/27/2010 07:41AM
Re: Evolve from Partition to Sharding?  
1,351
Rick James
08/23/2010 12:42AM
Re: Evolve from Partition to Sharding?  
2,078
John Smith
08/23/2010 12:48AM
Re: Evolve from Partition to Sharding?  
1,337
Rick James
08/23/2010 09:45PM
Re: Evolve from Partition to Sharding?  
1,456
John Smith
08/23/2010 10:18PM
Mysql cluster 7.1.5 can't use table partition!  
2,736
yan wenwu
08/25/2010 10:13AM
Re: Mysql cluster 7.1.5 can't use table partition!  
1,493
Rick James
08/26/2010 10:27PM
How to move InnoDB partitions from one machine to another?  
2,387
John Smith
08/26/2010 03:16AM
Hash/key Partition by something other than PK  
2,606
John Smith
08/23/2010 05:50AM
Re: Hash/key Partition by something other than PK  
1,357
Rick James
08/24/2010 11:59PM
about SUBPARTITIONING BEHAVIOR ...  
2,337
08/18/2010 07:46AM
Re: about SUBPARTITIONING BEHAVIOR ...  
1,216
Mattias Jonsson
08/19/2010 05:59AM
first partition always  
2,390
N N
08/10/2010 03:29AM
Re: first partition always  
1,316
Aftab Khan
08/11/2010 05:44AM
Partitioning on the basis of DAY() function  
3,482
Mirza Misbah Ulhaq
08/03/2010 07:09AM
Re: Partitioning on the basis of DAY() function  
1,388
Rick James
08/04/2010 09:38PM
Partitioning dilemma  
2,531
Philopator Ptolemy
07/20/2010 08:51AM
Re: Partitioning dilemma  
1,375
Rick James
07/21/2010 11:58AM
Re: Partitioning dilemma  
1,303
Philopator Ptolemy
07/21/2010 01:47PM
Re: Partitioning dilemma  
1,392
Rick James
07/26/2010 11:15PM
Re: Partitioning dilemma  
1,231
Philopator Ptolemy
07/27/2010 09:02AM
Re: Partitioning dilemma  
1,288
Rick James
07/27/2010 08:06PM
MySQL DB Size increase after partitioning  
3,783
Ronald Higgins
07/25/2010 11:37AM
Re: MySQL DB Size increase after partitioning  
1,530
Rick James
07/26/2010 11:02PM
Why null errors in partition insert without nulls ??  
2,525
Jorge Torralba
07/13/2010 12:21PM
Re: Why null errors in partition insert without nulls ??  
1,253
Rick James
07/25/2010 10:29PM
Re: Why null errors in partition insert without nulls ??  
1,259
Jonathon Coombes
07/24/2010 11:03PM
Using MySQL Partitioning Instead of MERGE Tables  
2,678
Edwin DeSouza
07/24/2010 03:38PM
partitioning by month and pruning  
2,389
Jorge Torralba
07/13/2010 11:51AM
Partition Pruning based on subquery / join result  
4,282
Justin Holdsworth
07/09/2010 03:54AM
Re: Partition Pruning based on subquery / join result  
1,788
Rick James
07/11/2010 11:30AM
Re: Partition Pruning based on subquery / join result  
1,815
Justin Holdsworth
07/12/2010 05:05AM
Re: Partition Pruning based on subquery / join result  
1,758
Rick James
07/12/2010 11:41PM
Re: Partition Pruning based on subquery / join result  
1,754
Justin Holdsworth
07/13/2010 09:33AM
Partition table not support foreign key feature ?  
2,714
Mayur P Vegad
06/30/2010 04:41AM
Re: Partition table not support foreign key feature ?  
1,369
Rick James
07/01/2010 11:12PM
Re: Partition table not support foreign key feature ?  
1,909
Mayur P Vegad
07/02/2010 05:05AM
Re: Partition table not support foreign key feature ?  
1,775
Rick James
07/03/2010 12:35AM
Strange first partition behavior while pruning on table partitioned by date.  
2,910
Alexey Efremov
06/29/2010 09:46AM
Re: Strange first partition behavior while pruning on table partitioned by date.  
1,362
Rick James
06/30/2010 08:51PM
Re: Strange first partition behavior while pruning on table partitioned by date.  
1,302
Alexey Efremov
07/01/2010 06:10AM
Exceptions with Partition Pruning  
3,446
ratheesh balakrishnan
06/10/2010 04:36PM
Re: Exceptions with Partition Pruning  
1,558
Rick James
06/12/2010 01:21AM
Re: Exceptions with Partition Pruning  
1,619
ratheesh balakrishnan
06/14/2010 01:10PM
Re: Exceptions with Partition Pruning  
1,374
Rick James
06/16/2010 09:31AM
Re: Exceptions with Partition Pruning  
1,632
ratheesh balakrishnan
06/16/2010 05:28PM
Rebuilding vs. Optimizing Partition, Time Elapsed to complete  
2,791
Thomas Lekai
06/07/2010 04:12PM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete  
1,636
Mattias Jonsson
06/15/2010 04:51AM
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete  
1,701
Rick James
06/09/2010 09:40AM
Lock wait timeouts and partitioning  
2,313
Mark Richman
06/05/2010 07:47AM
Re: Lock wait timeouts and partitioning  
1,424
Rick James
06/06/2010 08:53AM
Re: Lock wait timeouts and partitioning  
1,448
Mattias Jonsson
06/15/2010 04:42AM
Huge Disk Write while performing delete operation  
2,440
Ramesh Kumar
06/10/2010 10:17PM
Re: Huge Disk Write while performing delete operation  
1,345
Rick James
06/12/2010 12:50AM
Linear Partioning vs Ordinary  
4,021
Double Dragon
03/15/2010 02:31AM
Re: Linear Partioning vs Ordinary  
1,554
ratheesh balakrishnan
06/11/2010 04:09PM
Re: Linear Partioning vs Ordinary  
1,972
Mattias Jonsson
03/24/2010 09:23AM
Re: Linear Partioning vs Ordinary  
1,941
Rick James
03/19/2010 08:09AM
Can not partition existings tables  
2,590
Olivier Bourdon
06/03/2010 04:06AM
Re: Can not partition existings tables  
1,600
Rick James
06/04/2010 08:22PM
Re: Can not partition existings tables  
1,524
Olivier Bourdon
06/07/2010 03:55AM
Re: Can not partition existings tables  
1,457
Rick James
06/07/2010 11:18PM
Key Partition Performance Measurement  
3,673
Imran Pathan
05/25/2010 01:05AM
Re: Key Partition Performance Measurement  
1,502
Rick James
05/28/2010 11:39PM
Re: Key Partition Performance Measurement  
1,518
Imran Pathan
05/27/2010 05:43AM
SOLVED; DISK USAGE When Alter table HASH  
2,380
Hawk T
05/25/2010 03:29PM
Re: DISK USAGE When Alter table HASH  
1,398
Hawk T
05/26/2010 09:22AM
Mystified by Partition Pruning on Dates  
2,448
John Thompson
05/19/2010 03:45AM
Re: Mystified by Partition Pruning on Dates  
1,465
Rick James
05/20/2010 07:58AM
Re: Mystified by Partition Pruning on Dates  
1,579
John Thompson
05/20/2010 08:35AM
How to handle secondary keys in partitioning?  
3,291
John Smith
05/04/2010 12:46AM
Re: How to handle secondary keys in partitioning?  
1,838
Mattias Jonsson
05/05/2010 02:20AM
Re: How to handle secondary keys in partitioning?  
2,149
John Smith
05/06/2010 12:34AM
Re: How to handle secondary keys in partitioning?  
1,696
Rick James
05/06/2010 12:04AM
Re: How to handle secondary keys in partitioning?  
2,051
Mattias Jonsson
05/06/2010 03:23PM
Re: How to handle secondary keys in partitioning?  
1,718
John Smith
05/06/2010 10:50PM
Re: How to handle secondary keys in partitioning?  
1,641
Mattias Jonsson
05/12/2010 05:29AM
Re: How to handle secondary keys in partitioning?  
1,718
Mattias Jonsson
05/07/2010 02:38AM
Re: How to handle secondary keys in partitioning?  
1,668
John Smith
05/08/2010 05:31PM
Re: How to handle secondary keys in partitioning?  
1,745
Mattias Jonsson
05/09/2010 04:37AM
Re: How to handle secondary keys in partitioning?  
1,613
John Smith
05/09/2010 12:41PM
Re: How to handle secondary keys in partitioning?  
1,562
Mattias Jonsson
05/09/2010 01:23PM
Re: How to handle secondary keys in partitioning?  
1,889
Mattias Jonsson
05/04/2010 01:29PM
Re: How to handle secondary keys in partitioning?  
1,640
John Smith
05/04/2010 04:30PM
Partition pruning - how much optimization is smart?  
3,158
Michał Stolarczyk
05/09/2010 04:21AM
Re: Partition pruning - how much optimization is smart?  
1,310
Mattias Jonsson
05/09/2010 01:28PM
Partitioning performance issues // 5.1  
3,565
Ya Wi
02/17/2010 10:53AM
Re: Partitioning performance issues // 5.1  
2,165
Mattias Jonsson
02/19/2010 04:17AM
Re: Partitioning performance issues // 5.1  
2,022
Ya Wi
02/19/2010 10:11AM
Re: Partitioning performance issues // 5.1  
2,593
Mattias Jonsson
02/19/2010 02:56PM
Re: Partitioning performance issues // 5.1  
2,322
bob hagemann
04/18/2010 04:51PM
Re: Partitioning performance issues // 5.1  
1,825
Mattias Jonsson
04/18/2010 11:31PM
problem about partition  
2,468
h ch
04/15/2010 08:01PM
Re: problem about partition  
1,638
Rick James
04/16/2010 10:08PM
Re: problem about partition  
1,641
h ch
04/18/2010 08:16PM
Partitioning tables with grouping  
2,543
sonam agarwal
04/10/2010 07:31AM
Re: Partitioning tables with grouping  
1,489
Rick James
04/11/2010 10:41PM
Re: Partitioning tables with grouping  
2,120
sonam agarwal
04/11/2010 11:00PM
Re: Partitioning tables with grouping  
1,521
Rick James
04/13/2010 11:40PM
Re: Partitioning tables with grouping  
1,655
sonam agarwal
04/14/2010 05:04AM
PARTITION BY RANGE (CHARACTER BASIS) ?  
4,822
sonam agarwal
04/10/2010 08:35AM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?  
1,928
Mattias Jonsson
04/13/2010 06:01PM
Re: PARTITION BY RANGE (CHARACTER BASIS) ?  
1,779
sonam agarwal
04/13/2010 07:53PM
CREATING VIEWS OF A PARTITION  
2,734
Bhargavi M S
04/10/2010 10:06AM
Re: CREATING VIEWS OF A PARTITION  
1,411
Rick James
04/11/2010 10:35PM
Re: CREATING VIEWS OF A PARTITION  
1,601
Mattias Jonsson
04/13/2010 06:02PM
Partitioning Problem  
3,096
sireesh beemineni
04/09/2010 07:07AM
Re: Partitioning Problem  
1,524
Rick James
04/11/2010 10:46PM
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:
« 1
...
3 4 5 6 7
...
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.