|
first partition always
|
1,507 |
N N
|
08/10/2010 03:29AM
|
|
Re: first partition always
|
862 |
Aftab Khan
|
08/11/2010 05:44AM
|
|
Partitioning on the basis of DAY() function
|
2,565 |
Mirza Misbah Ulhaq
|
08/03/2010 07:09AM
|
|
Re: Partitioning on the basis of DAY() function
|
989 |
Rick James
|
08/04/2010 09:38PM
|
|
Partitioning dilemma
|
1,727 |
Philopator Ptolemy
|
07/20/2010 08:51AM
|
|
Re: Partitioning dilemma
|
883 |
Rick James
|
07/21/2010 11:58AM
|
|
Re: Partitioning dilemma
|
845 |
Philopator Ptolemy
|
07/21/2010 01:47PM
|
|
Re: Partitioning dilemma
|
949 |
Rick James
|
07/26/2010 11:15PM
|
|
Re: Partitioning dilemma
|
782 |
Philopator Ptolemy
|
07/27/2010 09:02AM
|
|
Re: Partitioning dilemma
|
781 |
Rick James
|
07/27/2010 08:06PM
|
|
MySQL DB Size increase after partitioning
|
2,727 |
Ronald Higgins
|
07/25/2010 11:37AM
|
|
Re: MySQL DB Size increase after partitioning
|
1,017 |
Rick James
|
07/26/2010 11:02PM
|
|
Why null errors in partition insert without nulls ??
|
1,764 |
Jorge Torralba
|
07/13/2010 12:21PM
|
|
Re: Why null errors in partition insert without nulls ??
|
873 |
Rick James
|
07/25/2010 10:29PM
|
|
Re: Why null errors in partition insert without nulls ??
|
868 |
Jonathon Coombes
|
07/24/2010 11:03PM
|
|
Using MySQL Partitioning Instead of MERGE Tables
|
1,509 |
Edwin DeSouza
|
07/24/2010 03:38PM
|
|
partitioning by month and pruning
|
1,482 |
Jorge Torralba
|
07/13/2010 11:51AM
|
|
Partition Pruning based on subquery / join result
|
2,354 |
Justin Holdsworth
|
07/09/2010 03:54AM
|
|
Re: Partition Pruning based on subquery / join result
|
1,195 |
Rick James
|
07/11/2010 11:30AM
|
|
Re: Partition Pruning based on subquery / join result
|
1,112 |
Justin Holdsworth
|
07/12/2010 05:05AM
|
|
Re: Partition Pruning based on subquery / join result
|
1,052 |
Rick James
|
07/12/2010 11:41PM
|
|
Re: Partition Pruning based on subquery / join result
|
1,144 |
Justin Holdsworth
|
07/13/2010 09:33AM
|
|
Partition table not support foreign key feature ?
|
1,911 |
Mayur P Vegad
|
06/30/2010 04:41AM
|
|
Re: Partition table not support foreign key feature ?
|
898 |
Rick James
|
07/01/2010 11:12PM
|
|
Re: Partition table not support foreign key feature ?
|
1,386 |
Mayur P Vegad
|
07/02/2010 05:05AM
|
|
Re: Partition table not support foreign key feature ?
|
1,215 |
Rick James
|
07/03/2010 12:35AM
|
|
Strange first partition behavior while pruning on table partitioned by date.
|
2,018 |
Alexey Efremov
|
06/29/2010 09:46AM
|
|
Re: Strange first partition behavior while pruning on table partitioned by date.
|
901 |
Rick James
|
06/30/2010 08:51PM
|
|
Re: Strange first partition behavior while pruning on table partitioned by date.
|
866 |
Alexey Efremov
|
07/01/2010 06:10AM
|
|
Exceptions with Partition Pruning
|
2,459 |
ratheesh balakrishnan
|
06/10/2010 04:36PM
|
|
Re: Exceptions with Partition Pruning
|
1,068 |
Rick James
|
06/12/2010 01:21AM
|
|
Re: Exceptions with Partition Pruning
|
971 |
ratheesh balakrishnan
|
06/14/2010 01:10PM
|
|
Re: Exceptions with Partition Pruning
|
918 |
Rick James
|
06/16/2010 09:31AM
|
|
Re: Exceptions with Partition Pruning
|
1,100 |
ratheesh balakrishnan
|
06/16/2010 05:28PM
|
|
Rebuilding vs. Optimizing Partition, Time Elapsed to complete
|
1,836 |
Thomas Lekai
|
06/07/2010 04:12PM
|
|
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete
|
1,184 |
Mattias Jonsson
|
06/15/2010 04:51AM
|
|
Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete
|
1,125 |
Rick James
|
06/09/2010 09:40AM
|
|
Lock wait timeouts and partitioning
|
1,626 |
Mark Richman
|
06/05/2010 07:47AM
|
|
Re: Lock wait timeouts and partitioning
|
1,053 |
Rick James
|
06/06/2010 08:53AM
|
|
Re: Lock wait timeouts and partitioning
|
1,043 |
Mattias Jonsson
|
06/15/2010 04:42AM
|
|
Huge Disk Write while performing delete operation
|
1,777 |
Ramesh Kumar
|
06/10/2010 10:17PM
|
|
Re: Huge Disk Write while performing delete operation
|
900 |
Rick James
|
06/12/2010 12:50AM
|
|
Linear Partioning vs Ordinary
|
3,091 |
Double Dragon
|
03/15/2010 02:31AM
|
|
Re: Linear Partioning vs Ordinary
|
1,066 |
ratheesh balakrishnan
|
06/11/2010 04:09PM
|
|
Re: Linear Partioning vs Ordinary
|
1,402 |
Mattias Jonsson
|
03/24/2010 09:23AM
|
|
Re: Linear Partioning vs Ordinary
|
1,450 |
Rick James
|
03/19/2010 08:09AM
|
|
Can not partition existings tables
|
1,799 |
Olivier Bourdon
|
06/03/2010 04:06AM
|
|
Re: Can not partition existings tables
|
1,109 |
Rick James
|
06/04/2010 08:22PM
|
|
Re: Can not partition existings tables
|
1,129 |
Olivier Bourdon
|
06/07/2010 03:55AM
|
|
Re: Can not partition existings tables
|
1,049 |
Rick James
|
06/07/2010 11:18PM
|
|
Key Partition Performance Measurement
|
2,507 |
Imran Pathan
|
05/25/2010 01:05AM
|
|
Re: Key Partition Performance Measurement
|
1,122 |
Rick James
|
05/28/2010 11:39PM
|
|
Re: Key Partition Performance Measurement
|
1,078 |
Imran Pathan
|
05/27/2010 05:43AM
|
|
SOLVED; DISK USAGE When Alter table HASH
|
1,637 |
Hawk T
|
05/25/2010 03:29PM
|
|
Re: DISK USAGE When Alter table HASH
|
1,049 |
Hawk T
|
05/26/2010 09:22AM
|
|
Mystified by Partition Pruning on Dates
|
1,715 |
John Thompson
|
05/19/2010 03:45AM
|
|
Re: Mystified by Partition Pruning on Dates
|
1,084 |
Rick James
|
05/20/2010 07:58AM
|
|
Re: Mystified by Partition Pruning on Dates
|
1,109 |
John Thompson
|
05/20/2010 08:35AM
|
|
How to handle secondary keys in partitioning?
|
2,155 |
John Smith
|
05/04/2010 12:46AM
|
|
Re: How to handle secondary keys in partitioning?
|
1,287 |
Mattias Jonsson
|
05/05/2010 02:20AM
|
|
Re: How to handle secondary keys in partitioning?
|
1,588 |
John Smith
|
05/06/2010 12:34AM
|
|
Re: How to handle secondary keys in partitioning?
|
1,194 |
Rick James
|
05/06/2010 12:04AM
|
|
Re: How to handle secondary keys in partitioning?
|
1,350 |
Mattias Jonsson
|
05/06/2010 03:23PM
|
|
Re: How to handle secondary keys in partitioning?
|
1,067 |
John Smith
|
05/06/2010 10:50PM
|
|
Re: How to handle secondary keys in partitioning?
|
1,155 |
Mattias Jonsson
|
05/12/2010 05:29AM
|
|
Re: How to handle secondary keys in partitioning?
|
1,214 |
Mattias Jonsson
|
05/07/2010 02:38AM
|
|
Re: How to handle secondary keys in partitioning?
|
1,152 |
John Smith
|
05/08/2010 05:31PM
|
|
Re: How to handle secondary keys in partitioning?
|
1,226 |
Mattias Jonsson
|
05/09/2010 04:37AM
|
|
Re: How to handle secondary keys in partitioning?
|
1,126 |
John Smith
|
05/09/2010 12:41PM
|
|
Re: How to handle secondary keys in partitioning?
|
1,030 |
Mattias Jonsson
|
05/09/2010 01:23PM
|
|
Re: How to handle secondary keys in partitioning?
|
1,251 |
Mattias Jonsson
|
05/04/2010 01:29PM
|
|
Re: How to handle secondary keys in partitioning?
|
1,074 |
John Smith
|
05/04/2010 04:30PM
|
|
Partition pruning - how much optimization is smart?
|
1,900 |
MichaĆ Stolarczyk
|
05/09/2010 04:21AM
|
|
Re: Partition pruning - how much optimization is smart?
|
906 |
Mattias Jonsson
|
05/09/2010 01:28PM
|
|
Partitioning performance issues // 5.1
|
2,810 |
Ya Wi
|
02/17/2010 10:53AM
|
|
Re: Partitioning performance issues // 5.1
|
1,730 |
Mattias Jonsson
|
02/19/2010 04:17AM
|
|
Re: Partitioning performance issues // 5.1
|
1,576 |
Ya Wi
|
02/19/2010 10:11AM
|
|
Re: Partitioning performance issues // 5.1
|
2,019 |
Mattias Jonsson
|
02/19/2010 02:56PM
|
|
Re: Partitioning performance issues // 5.1
|
1,880 |
bob hagemann
|
04/18/2010 04:51PM
|
|
Re: Partitioning performance issues // 5.1
|
1,380 |
Mattias Jonsson
|
04/18/2010 11:31PM
|
|
problem about partition
|
1,776 |
h ch
|
04/15/2010 08:01PM
|
|
Re: problem about partition
|
1,215 |
Rick James
|
04/16/2010 10:08PM
|
|
Re: problem about partition
|
1,176 |
h ch
|
04/18/2010 08:16PM
|
|
Partitioning tables with grouping
|
1,837 |
sonam agarwal
|
04/10/2010 07:31AM
|
|
Re: Partitioning tables with grouping
|
1,052 |
Rick James
|
04/11/2010 10:41PM
|
|
Re: Partitioning tables with grouping
|
1,649 |
sonam agarwal
|
04/11/2010 11:00PM
|
|
Re: Partitioning tables with grouping
|
1,096 |
Rick James
|
04/13/2010 11:40PM
|
|
Re: Partitioning tables with grouping
|
1,161 |
sonam agarwal
|
04/14/2010 05:04AM
|
|
PARTITION BY RANGE (CHARACTER BASIS) ?
|
3,909 |
sonam agarwal
|
04/10/2010 08:35AM
|
|
Re: PARTITION BY RANGE (CHARACTER BASIS) ?
|
1,511 |
Mattias Jonsson
|
04/13/2010 06:01PM
|
|
Re: PARTITION BY RANGE (CHARACTER BASIS) ?
|
1,375 |
sonam agarwal
|
04/13/2010 07:53PM
|
|
CREATING VIEWS OF A PARTITION
|
2,135 |
Bhargavi M S
|
04/10/2010 10:06AM
|
|
Re: CREATING VIEWS OF A PARTITION
|
1,042 |
Rick James
|
04/11/2010 10:35PM
|
|
Re: CREATING VIEWS OF A PARTITION
|
1,242 |
Mattias Jonsson
|
04/13/2010 06:02PM
|
|
Partitioning Problem
|
2,186 |
sireesh beemineni
|
04/09/2010 07:07AM
|
|
Re: Partitioning Problem
|
1,127 |
Rick James
|
04/11/2010 10:46PM
|
|
partition pruning and DIV
|
2,590 |
Bill Moninger
|
03/26/2010 11:23AM
|
|
Re: partition pruning and DIV
|
1,232 |
Mattias Jonsson
|
04/07/2010 04:35PM
|
|
Re: partition pruning and DIV
|
1,195 |
Bill Moninger
|
04/07/2010 05:08PM
|
|
Re: partition pruning and DIV
|
1,108 |
Rick James
|
04/06/2010 09:20PM
|
|
ERROR 1016 (HY000) at line: Can't open file: './test/Tablename.frm' (errno: 24)
|
2,466 |
vikas warad
|
04/05/2010 06:24AM
|
|
Partition-wise mysqldump backup script at MySQL Forge
|
1,879 |
Roland Bouman
|
03/30/2010 03:17AM
|
|
Partitions outside of date range is included
|
2,551 |
Marius S
|
03/18/2010 10:22AM
|
|
Re: Partitions outside of date range is included
|
1,297 |
Mattias Jonsson
|
03/24/2010 09:30AM
|
|
Re: Partitions outside of date range is included
|
1,386 |
Rick James
|
03/20/2010 01:43PM
|
|
Can't repair/rebuild my partitions
|
2,221 |
Andreas Thorstensson
|
03/15/2010 07:20AM
|
|
Re: Can't repair/rebuild my partitions
|
1,258 |
Mattias Jonsson
|
03/24/2010 08:44AM
|
|
copying from unpartitioned to partitioned table
|
2,578 |
Rick Casey
|
03/09/2010 11:54AM
|
|
Re: copying from unpartitioned to partitioned table
|
1,190 |
Mattias Jonsson
|
03/24/2010 08:39AM
|
|
Re: copying from unpartitioned to partitioned table
|
1,258 |
Mattias Jonsson
|
03/11/2010 08:18AM
|
|
Re: copying from unpartitioned to partitioned table
|
1,321 |
Rick Casey
|
03/12/2010 10:58AM
|
|
Why Unique Key Constraint?
|
3,669 |
Double Dragon
|
03/14/2010 04:59AM
|
|
Re: Why Unique Key Constraint?
|
1,424 |
Rick James
|
03/20/2010 03:44PM
|
|
Partition by Key
|
3,518 |
Vanco Josifovski
|
03/09/2010 02:28AM
|
|
Re: Partition by Key
|
1,474 |
Mattias Jonsson
|
03/12/2010 02:17AM
|
|
ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed
|
8,116 |
Chaya Shindhe
|
02/18/2010 04:21AM
|
|
Re: ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed
|
6,334 |
Mattias Jonsson
|
02/19/2010 04:22AM
|
|
PARTITION BY LIST "catch-all" partition
|
3,474 |
Egor Ivkin
|
01/20/2010 03:25AM
|
|
Re: PARTITION BY LIST "catch-all" partition
|
1,551 |
Mattias Jonsson
|
01/23/2010 03:55AM
|
|
Re: PARTITION BY LIST "catch-all" partition
|
1,470 |
Egor Ivkin
|
01/23/2010 08:20AM
|
|
Re: PARTITION BY LIST "catch-all" partition
|
1,547 |
Rick James
|
01/22/2010 11:05PM
|
|
Re: PARTITION BY LIST "catch-all" partition
|
1,508 |
Egor Ivkin
|
01/23/2010 12:30AM
|
|
Why doesn't partitioning support INSERT DELAYED?
|
3,187 |
Ben Vaughn
|
01/14/2010 06:50PM
|
|
Re: Why doesn't partitioning support INSERT DELAYED?
|
1,683 |
Mattias Jonsson
|
01/16/2010 06:48PM
|
|
Re: Why doesn't partitioning support INSERT DELAYED?
|
1,591 |
Rick James
|
01/22/2010 11:16PM
|
|
Partitioning with range(to_days) issue
|
5,057 |
Jools Lebowski
|
10/29/2009 11:13AM
|
|
Re: Partitioning with range(to_days) issue
|
2,109 |
Sarah Sproehnle
|
11/05/2009 07:47PM
|
|
Re: Partitioning with range(to_days) issue
|
1,722 |
Jools Lebowski
|
01/13/2010 06:36AM
|
|
Re: Partitioning with range(to_days) issue
|
1,993 |
Jason Shoulet
|
11/05/2009 03:12AM
|
|
Re: Partitioning with range(to_days) issue
|
2,014 |
Rick James
|
11/05/2009 08:37AM
|
|
Re: Partitioning with range(to_days) issue
|
2,805 |
Jason Shoulet
|
11/05/2009 09:51AM
|
|
Re: Partitioning with range(to_days) issue
|
1,944 |
Mattias Jonsson
|
11/17/2009 05:51AM
|
|
Re: Partitioning with range(to_days) issue
|
2,242 |
Rick James
|
10/31/2009 12:00PM
|
|
Re: Partitioning with range(to_days) issue
|
2,104 |
Jools Lebowski
|
11/02/2009 04:07AM
|
|
Re: Partitioning with range(to_days) issue
|
1,983 |
Rick James
|
11/02/2009 10:22AM
|
|
Re: Partitioning with range(to_days) issue
|
1,967 |
Jools Lebowski
|
11/03/2009 02:18AM
|
|
Re: Partitioning with range(to_days) issue
|
2,434 |
Rick James
|
11/03/2009 09:32AM
|
|
Re: Partitioning with range(to_days) issue
|
1,787 |
Jools Lebowski
|
01/13/2010 05:17AM
|
|
Re: Partitioning with range(to_days) issue
|
1,624 |
Rick James
|
01/22/2010 11:09PM
|
|
Partitioned table using two storage engines?
|
2,173 |
Loren Sorensen
|
01/07/2010 03:47PM
|
|
Re: Partitioned table using two storage engines?
|
1,398 |
Mattias Jonsson
|
01/13/2010 05:00AM
|
|
Sub partitions
|
2,760 |
AR Mahdi
|
01/12/2010 03:09AM
|
|
Re: Sub partitions
|
1,422 |
Mattias Jonsson
|
01/13/2010 04:51AM
|
|
Comments: Giuseppe Maxia - A deep look at MySQL 5.5 partitioning enhancements
|
4,819 |
DevZone Comment System
|
12/24/2009 01:26PM
|
|
Building Indexes across partitioned tables longer each day
|
2,896 |
Edward Capriolo
|
12/21/2009 10:46AM
|
|
Re: Building Indexes across partitioned tables longer each day
|
1,726 |
Rick James
|
12/22/2009 10:17PM
|
|
Re: Building Indexes across partitioned tables longer each day
|
1,616 |
Edward Capriolo
|
12/23/2009 12:30PM
|
|
Re: Building Indexes across partitioned tables longer each day
|
1,640 |
Mattias Jonsson
|
12/22/2009 02:48AM
|
|
alter table rebuild partition locks reads
|
3,760 |
Chris C
|
12/18/2009 01:24AM
|
|
Re: alter table rebuild partition locks reads
|
1,855 |
Chris C
|
12/18/2009 02:27AM
|
|
Re: alter table rebuild partition locks reads
|
1,646 |
Rick James
|
12/19/2009 09:22AM
|
|
Re: alter table rebuild partition locks reads
|
1,639 |
Chris C
|
12/20/2009 08:41PM
|
|
Re: alter table rebuild partition locks reads
|
1,772 |
Chris C
|
12/21/2009 03:04PM
|
|
Re: alter table rebuild partition locks reads
|
1,639 |
Mattias Jonsson
|
12/22/2009 02:37AM
|
|
Re: alter table rebuild partition locks reads
|
1,673 |
Chris C
|
12/22/2009 10:17AM
|
|
Hash and Linear Hash partition table not performing well
|
4,200 |
Neeraj Khandelwal
|
11/27/2009 03:04AM
|
|
Re: Hash and Linear Hash partition table not performing well
|
1,978 |
Mattias Jonsson
|
12/07/2009 04:44AM
|
|
Re: Hash and Linear Hash partition table not performing well
|
1,794 |
Neeraj Khandelwal
|
12/08/2009 01:05AM
|
|
Re: Hash and Linear Hash partition table not performing well
|
2,382 |
Mattias Jonsson
|
12/22/2009 03:29AM
|
|
Re: Hash and Linear Hash partition table not performing well
|
2,015 |
Rick James
|
12/05/2009 11:49PM
|
|
Re: Hash and Linear Hash partition table not performing well
|
2,093 |
Neeraj Khandelwal
|
12/08/2009 03:42AM
|
|
Re: Hash and Linear Hash partition table not performing well
|
2,587 |
Rick James
|
12/09/2009 08:08PM
|
|
Archiving Partition .MYD files
|
3,773 |
Dominic Edwards
|
12/11/2009 05:41AM
|
|
Re: Archiving Partition .MYD files
|
1,864 |
Dominic Edwards
|
12/11/2009 05:48AM
|
|
Re: Archiving Partition .MYD files
|
1,828 |
Rick James
|
12/12/2009 03:48PM
|
|
Re: Archiving Partition .MYD files
|
1,896 |
Mattias Jonsson
|
12/22/2009 03:00AM
|
|
partitioning question?
|
2,474 |
asmaa atef
|
12/14/2009 08:34AM
|
|
Re: partitioning question?
|
1,595 |
Mattias Jonsson
|
12/22/2009 02:50AM
|
|
Re: partitioning question?
|
1,648 |
Rick James
|
12/16/2009 12:33AM
|
|
Re: partitioning question?
|
1,239 |
asmaa atef
|
12/16/2009 07:44AM
|
|
Re: partitioning question?
|
1,550 |
Rick James
|
12/16/2009 11:53PM
|
|
Re: partitioning question?
|
1,527 |
asmaa atef
|
12/17/2009 02:39AM
|
|
Re: partitioning question?
|
1,550 |
Rick James
|
12/18/2009 12:40AM
|
|
Minimum number of rows for using partitioning
|
3,559 |
Ramesh Kumar
|
12/10/2009 10:57PM
|
|
Re: Minimum number of rows for using partitioning
|
1,700 |
Rick James
|
12/12/2009 10:58PM
|
|
Re: Minimum number of rows for using partitioning
|
1,775 |
Ramesh Kumar
|
12/13/2009 09:57PM
|
|
Re: Minimum number of rows for using partitioning
|
1,713 |
Rick James
|
12/14/2009 12:17AM
|
|
Re: Minimum number of rows for using partitioning
|
1,806 |
Ramesh Kumar
|
12/14/2009 12:57AM
|
|
Range Partition Pruning on TO_DAYS Problem
|
2,716 |
Dominic Edwards
|
11/12/2009 10:06AM
|
|
Re: Range Partition Pruning on TO_DAYS Problem
|
2,199 |
Mattias Jonsson
|
11/17/2009 06:09AM
|
|
Re: Range Partition Pruning on TO_DAYS Problem
|
1,726 |
Rick James
|
11/17/2009 08:41PM
|
|
Re: Range Partition Pruning on TO_DAYS Problem
|
1,601 |
Dominic Edwards
|
12/11/2009 05:45AM
|
|
Create new partition for an existing table?
|
3,330 |
hung chu
|
11/26/2009 10:27PM
|
|
Re: Create new partition for an existing table?
|
1,837 |
Rick James
|
12/05/2009 11:55PM
|
|
This topic has been moved.:
MySQL DB Size increase after partitioning
|
0 |
Ronald Higgins
|
07/25/2010 03:05PM
|