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 2 3 4 5
...
13 »

Subject
Views
Written By
Posted
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"  
2,006
Jon Jacob
07/20/2014 07:50AM
Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"  
1,135
Rick James
07/21/2014 06:50PM
Range partitioning on floor (decimal(14.4)) doesn't work :/  
2,087
Max Herman
07/12/2014 12:35PM
Re: Range partitioning on floor (decimal(14.4)) doesn't work :/  
1,171
Rick James
07/14/2014 06:45PM
why explain partition shows first partition in every select query?  
2,216
Aamir Sohail
05/27/2014 07:18AM
Re: why explain partition shows first partition in every select query?  
1,138
Rick James
05/27/2014 03:10PM
Re: why explain partition shows first partition in every select query?  
1,088
Aamir Sohail
05/28/2014 12:52AM
Storing, accessing and configuring my partitions in diferent servers  
1,895
Victor Bombella
05/23/2014 11:54PM
Re: Storing, accessing and configuring my partitions in diferent servers  
1,018
Rick James
05/25/2014 04:57PM
missing data after partitioning - bug?  
2,095
rol and
05/23/2014 12:51PM
Re: missing data after partitioning - bug?  
1,107
Rick James
05/25/2014 04:27PM
MySql Partitioning problem (bug?)  
6,510
K T
05/07/2014 04:39PM
Re: MySql Partitioning problem (bug?)  
1,158
Rick James
05/09/2014 11:59PM
Re: MySql Partitioning problem (bug?)  
1,115
K T
05/10/2014 03:41PM
Re: MySql Partitioning problem (bug?)  
1,086
K T
05/10/2014 03:44PM
Re: MySql Partitioning problem (bug?)  
1,089
Mattias Jonsson
05/16/2014 06:15AM
MySQL partition by range on YEAR(date) weird results  
2,454
Adelin Feraru
05/12/2014 02:15AM
Re: MySQL partition by range on YEAR(date) weird results  
1,175
Rick James
05/15/2014 12:01AM
Re: MySQL partition by range on YEAR(date) weird results  
1,040
Adelin Feraru
05/15/2014 03:38AM
Re: MySQL partition by range on YEAR(date) weird results  
1,065
Mattias Jonsson
05/15/2014 11:42AM
Storing tables on multiple partitions  
1,995
sdgbfdsg fdhgfdhds
04/09/2014 08:04AM
Re: Storing tables on multiple partitions  
1,062
Rick James
04/11/2014 04:32PM
Re: Storing tables on multiple partitions  
1,078
mi Su
04/29/2014 01:09AM
MySql Horizontal partitioning - Pros-Cons  
3,288
Manohar K
04/14/2014 11:43AM
Re: MySql Horizontal partitioning - Pros-Cons  
1,653
Rick James
04/17/2014 11:16PM
Re: MySql Horizontal partitioning - Pros-Cons  
1,237
Rick James
04/19/2014 03:42PM
Consumption of more hard disk space in "Copying to tmp table" phase  
2,744
Raghavendra K
04/14/2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,065
Mattias Jonsson
04/14/2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,034
Raghavendra K
04/16/2014 06:40AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,039
Mattias Jonsson
04/17/2014 12:55PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,044
Rick James
04/17/2014 11:36PM
Failed to read from the .par file  
5,826
IGG t
04/02/2014 09:49AM
Re: Failed to read from the .par file  
3,466
Rick James
04/05/2014 01:13PM
How to extend partition when there is no unallocated space in hard disk?  
1,964
mi Su
01/06/2014 01:21AM
Re: How to extend partition when there is no unallocated space in hard disk?  
1,367
Rick James
01/08/2014 05:22PM
Partitioning or indexing for millions of records  
2,373
Aamir Sohail
11/26/2013 05:44AM
Re: Partitioning or indexing for millions of records  
1,800
Rick James
11/27/2013 12:39PM
Re: Partitioning or indexing for millions of records  
1,347
Aamir Sohail
11/28/2013 12:40AM
Re: Partitioning or indexing for millions of records  
1,451
Rick James
11/28/2013 09:07PM
Re: Partitioning or indexing for millions of records  
1,290
Aamir Sohail
11/29/2013 04:11AM
Re: Partitioning or indexing for millions of records  
1,306
Rick James
11/30/2013 01:30PM
Re: Partitioning or indexing for millions of records  
1,170
chris arndt
12/31/2013 11:34AM
best way to take backup for old partition and create new one?  
2,268
Aamir Sohail
12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?  
1,160
Rick James
12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?  
1,095
mi Su
12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?  
1,059
Rick James
12/13/2013 12:51AM
Am I doing this correctly?  
2,080
Jim Buckley Barrett
11/29/2013 05:03AM
Re: Am I doing this correctly?  
1,177
Jim Buckley Barrett
11/29/2013 06:22AM
Re: Am I doing this correctly?  
1,266
Rick James
11/30/2013 02:18PM
Re: Am I doing this correctly?  
1,100
mi Su
12/04/2013 12:38AM
Re: Am I doing this correctly?  
1,166
Jim Buckley Barrett
12/05/2013 03:48AM
Re: Am I doing this correctly?  
1,203
Rick James
12/05/2013 10:21AM
Re: Am I doing this correctly?  
1,117
Jim Buckley Barrett
12/10/2013 09:49AM
Re: Am I doing this correctly?  
1,160
Jim Buckley Barrett
12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table  
6,713
Aamir Sohail
11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table  
3,059
Rick James
11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table  
2,158
Aamir Sohail
11/29/2013 04:19AM
Partition data backup and restore  
5,254
Seungho Nam Nam
10/18/2013 12:48AM
Re: Partition data backup and restore  
2,468
Mattias Jonsson
10/18/2013 02:59AM
Re: Partition data backup and restore  
1,911
Steven Robinson
11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,898
mark silverman
09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,155
Rick James
09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,134
Mattias Jonsson
10/04/2013 01:02AM
Reorganize Partition Syntax error  
2,597
IGG t
09/16/2013 03:13AM
Re: Reorganize Partition Syntax error  
1,051
IGG t
09/16/2013 09:39AM
Re: Reorganize Partition Syntax error  
1,036
Rick James
09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?  
2,825
Prabhu Raja Singh
09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?  
1,693
Rick James
09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?  
1,563
Prabhu Raja Singh
09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness  
2,423
IGG t
08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness  
1,127
Rick James
08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness  
1,076
IGG t
08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness  
1,073
Rick James
08/31/2013 05:35PM
mysql tables in use 500, locked 500  
2,249
bruce.zuo bruce
07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500  
1,223
Rick James
07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500  
1,059
bruce.zuo bruce
07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500  
1,018
Mattias Jonsson
08/13/2013 05:42AM
Create index on partition table (manually and dynamically)  
4,831
Vladimir Pivovar
07/05/2013 11:26PM
Re: Create index on parttion table (manually and dynamically)  
1,643
Rick James
07/06/2013 10:52PM
Re: Create index on parttion table (manually and dynamically)  
1,497
Vladimir Pivovar
07/07/2013 12:20AM
Re: Create index on parttion table (manually and dynamically)  
1,422
Vladimir Pivovar
07/07/2013 10:57AM
Re: Create index on parttion table (manually and dynamically)  
1,501
Rick James
07/08/2013 09:46AM
Re: Create index on partition table (manually and dynamically)  
1,767
Vladimir Pivovar
07/10/2013 02:23PM
how to remove partitiong in mysql version5.6  
2,102
heiansan white
06/13/2013 01:41AM
Re: how to remove partitiong in mysql version5.6  
1,130
Rick James
06/15/2013 01:50PM
No. of partitions in NDB cluster  
1,741
Alax James
05/31/2013 02:14AM
IP vs Date Partition  
2,278
Tim Linden
05/13/2013 10:28AM
Re: IP vs Date Partition  
1,526
Rick James
05/14/2013 09:59PM
Re: IP vs Date Partition  
1,484
Tim Linden
05/15/2013 10:06AM
How should I partition this table?  
2,636
Ron Bergin
04/26/2013 09:18AM
Re: How should I partition this table?  
1,391
Rick James
04/27/2013 09:58PM
Re: How should I partition this table?  
1,229
Ron Bergin
04/28/2013 11:29AM
Re: How should I partition this table?  
1,196
Rick James
04/29/2013 08:10AM
Re: How should I partition this table?  
1,217
Ron Bergin
04/30/2013 08:39AM
Re: How should I partition this table?  
1,343
Rick James
05/01/2013 11:45PM
Re: How should I partition this table?  
1,210
Ron Bergin
05/02/2013 08:17AM
Re: How should I partition this table?  
1,117
Ron Bergin
05/02/2013 11:55AM
Re: How should I partition this table?  
1,165
Rick James
05/03/2013 09:00AM
Re: How should I partition this table?  
1,187
Ron Bergin
05/03/2013 09:32AM
Performance doubt  
2,033
Xavier Borrut
03/26/2013 06:41AM
Re: Performance doubt  
1,151
Rick James
03/28/2013 12:34AM
Re: Performance doubt  
793
Mattias Jonsson
04/09/2013 01:49AM
Event add partition works but not the drop partition  
2,145
Frwa Onto
04/04/2013 11:22PM
Re: Event add partition works but not the drop partition  
1,020
Frwa Onto
04/05/2013 04:13AM
Should I partition?  
2,174
Jacob Steinberger
03/19/2013 02:57PM
Re: Should I partition?  
1,217
Rick James
03/21/2013 08:49PM
Re: Should I partition?  
1,154
NOT_FOUND NOT_FOUND
04/03/2013 10:08AM
Re: Should I partition?  
1,063
Rick James
04/04/2013 11:35PM
Partitioned table problem after upgrade to 5.5  
2,210
Ming Wang
03/06/2013 04:07AM
Re: Partitioned table problem after upgrade to 5.5  
1,121
Mattias Jonsson
03/06/2013 04:38AM
Re: Partitioned table problem after upgrade to 5.5  
1,085
Ming Wang
03/07/2013 08:23PM
Re: Partitioned table problem after upgrade to 5.5  
989
Rick James
03/07/2013 11:32PM
Re: Partitioned table problem after upgrade to 5.5  
1,042
Mattias Jonsson
03/08/2013 02:20AM
If you use a partition table in mysql5.5, Contact function  
1,843
kyung gi lee
02/25/2013 03:12AM
Re: If you use a partition table in mysql5.5, Contact function  
1,170
Rick James
02/28/2013 09:34AM
How to (temporary) disable one partition in the partitioned table  
2,306
First Bell
02/13/2013 11:01PM
Re: How to (temporary) disable one partition in the partitioned table  
1,339
Rick James
02/22/2013 01:00AM
Re: How to (temporary) disable one partition in the partitioned table  
1,422
Mattias Jonsson
02/28/2013 05:51AM
Index with partitioning  
2,284
Hélio Hélio
01/30/2013 06:23AM
Re: Index with partitioning  
1,347
Rick James
02/01/2013 10:20PM
Re: Index with partitioning  
1,524
Hélio Hélio
02/04/2013 08:03AM
Re: Index with partitioning  
1,356
Rick James
02/07/2013 10:09PM
Re: Index with partitioning  
1,337
Hélio Hélio
02/08/2013 06:55AM
Re: Index with partitioning  
1,214
Rick James
02/09/2013 01:22PM
Re: Index with partitioning  
1,561
Hélio Hélio
02/14/2013 12:26PM
MySQL Partitioning showing low performance  
2,091
Manosh Manohar
02/05/2013 12:10AM
Re: MySQL Partitioning showing low performance  
1,241
Rick James
02/07/2013 10:14PM
Re: MySQL Partitioning showing low performance  
1,082
Manosh Manohar
02/08/2013 12:39AM
How to let the query run on one partition  
2,244
Shawn Liu
01/09/2013 08:29AM
Re: How to let the query run on one partition  
1,170
Rick James
01/10/2013 08:45PM
How to partition by City \ State  
2,168
Noah Goodrich
12/19/2012 10:06PM
Re: How to partition by City \ State  
1,207
Rick James
12/20/2012 10:00PM
Partition behaiour seems abnormal in range partition  
2,102
Rahul K K
12/10/2012 12:05AM
Re: Partition behaiour seems abnormal in range partition  
1,075
Rick James
12/20/2012 02:56PM
partition by range on decimal type  
3,261
Greg K
11/20/2012 07:15AM
Re: partition by range on decimal type  
1,531
Rick James
11/21/2012 10:39AM
Re: partition by range on decimal type  
1,271
Greg K
11/22/2012 02:26AM
Re: partition by range on decimal type  
1,349
Rick James
11/22/2012 11:02PM
Re: partition by range on decimal type  
1,475
Greg K
11/23/2012 12:45AM
Re: partition by range on decimal type  
1,579
Rick James
11/23/2012 09:03PM
Fortnight partitions  
2,922
Srikanth Mamidi
11/19/2012 11:24PM
Re: Fortnight partitions  
1,760
Rick James
11/20/2012 10:56PM
Re: Fortnight partitions  
1,156
Srikanth Mamidi
11/20/2012 11:23PM
Re: Fortnight partitions  
1,324
Rick James
11/21/2012 08:54PM
Re: Fortnight partitions  
1,285
Srikanth Mamidi
11/23/2012 12:04AM
milliseconds in mysql equivalent to java for Partitioning  
3,391
Manjunath C
11/12/2012 01:36AM
Re: milliseconds in mysql equivalent to java for Partitioning  
1,658
Rick James
11/13/2012 09:15AM
Re: milliseconds in mysql equivalent to java for Partitioning  
1,437
Manjunath C
11/14/2012 04:17AM
Partitioning not working need primary key?  
3,254
newbie Shai
10/20/2012 11:12AM
Re: Partitioning not working need primary key?  
1,635
Mattias Jonsson
10/22/2012 07:14AM
Re: Partitioning not working need primary key?  
1,389
newbie Shai
10/22/2012 11:59AM
Re: Partitioning not working need primary key?  
1,384
Rick James
10/22/2012 09:37PM
Re: Partitioning not working need primary key?  
1,461
newbie Shai
10/23/2012 08:36AM
Re: Partitioning not working need primary key?  
1,365
Rick James
10/23/2012 09:50AM
Re: Partitioning not working need primary key?  
1,357
newbie Shai
10/24/2012 09:05AM
Re: Partitioning not working need primary key?  
1,322
Rick James
10/24/2012 09:26PM
Re: Partitioning not working need primary key?  
1,340
newbie Shai
10/25/2012 09:45PM
Re: Partitioning not working need primary key?  
1,404
Rick James
10/25/2012 11:22PM
Re: Partitioning not working need primary key?  
1,358
newbie Shai
10/27/2012 07:21AM
Re: Partitioning not working need primary key?  
1,283
Rick James
10/27/2012 12:01PM
Re: Partitioning not working need primary key?  
1,301
newbie Shai
10/28/2012 12:10PM
Re: Partitioning not working need primary key?  
1,303
Rick James
10/28/2012 02:12PM
Re: Partitioning not working need primary key?  
1,455
newbie Shai
11/01/2012 10:55AM
Re: Partitioning not working need primary key?  
1,254
Rick James
11/02/2012 12:37AM
Re: Partitioning not working need primary key?  
1,293
newbie Shai
11/03/2012 10:37AM
Re: Partitioning not working need primary key?  
1,339
Rick James
11/03/2012 11:37AM
Re: Partitioning not working need primary key?  
1,246
newbie Shai
10/29/2012 06:51PM
Does partitioning make sense for this application?  
2,390
Paul Schmehl
10/25/2012 08:46PM
Re: Does partitioning make sense for this application?  
1,419
Rick James
10/26/2012 07:41PM
Re: Does partitioning make sense for this application?  
1,521
Paul Schmehl
10/26/2012 09:55PM
Re: Does partitioning make sense for this application?  
1,103
Rick James
10/27/2012 09:42PM
Re: Does partitioning make sense for this application?  
1,102
Paul Schmehl
10/27/2012 10:41PM
Re: Does partitioning make sense for this application?  
1,186
Rick James
10/28/2012 06:09PM
Re: Does partitioning make sense for this application?  
1,052
Paul Schmehl
10/28/2012 08:58PM
Re: Does partitioning make sense for this application?  
1,149
Rick James
10/30/2012 12:15PM
Programatic Partitioning  
1,880
Jardel Morais
10/22/2012 04:44AM
Get partition name for specific date  
2,328
Jan Bromberger
10/08/2012 12:48PM
Re: Get partition name for specific date  
1,307
Rick James
10/09/2012 09:21AM
Re: Get partition name for specific date  
1,147
Jan Bromberger
10/10/2012 03:18AM
Re: Get partition name for specific date  
1,256
Rick James
10/11/2012 07:12PM
Row movement for MySQL partitionned tables  
2,404
jongse park
10/10/2012 11:14PM
Re: Row movement for MySQL partitionned tables  
1,341
Mattias Jonsson
10/11/2012 05:32AM
columns partitioning row inserted in wrong partition  
2,047
martino merci
10/10/2012 02:54AM
Re: columns partitioning row inserted in wrong partition  
1,085
Mattias Jonsson
10/10/2012 11:15AM
Regarding optimizing hugh data with mysql  
2,078
Santosh Bhabal
10/08/2012 05:47AM
Re: Regarding optimizing hugh data with mysql  
1,191
Rick James
10/09/2012 11:23PM
Partitioning by year/quarter  
3,730
Ravi Malghan
09/24/2012 10:32AM
Re: Partitioning by year/quarter  
1,868
Aftab Khan
09/27/2012 01:31PM
Re: Partitioning by year/quarter  
1,362
Rick James
10/02/2012 09:15PM
Partitioning help  
1,792
Naresh Kondeboina
09/25/2012 02:09PM
Re: Partitioning help  
1,117
Aftab Khan
09/27/2012 01:12PM
Re: Partitioning help  
1,102
Naresh Kondeboina
09/27/2012 08:38PM
Re: Partitioning help  
1,120
Rick James
10/01/2012 11:54PM
Pages:
« 1 2 3 4 5
...
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.