MySQL Forums
Forum List  »  Partitioning
Announcements Last Post
•   MySQL Cluster Manager 1.4.6 has been released 05/09/2018 09:15AM
•   MySQL for Visual Studio 1.2.8 has been released 05/04/2018 03:03AM
•   MySQL Connector/NET 6.9.12 GA has been released 05/04/2018 01:42AM
•   MySQL Connector/C++ 1.1.11 has been released 04/30/2018 11:56AM
•   MySQL Connector/NET 6.10.7 GA has been released 04/30/2018 09:08AM

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

Subject
Views
Written By
Posted
Select using partition dynamically  
2,066
Jose Lima
05/07/2015 06:21PM
Re: Select using partition dynamically  
1,060
Rick James
05/11/2015 12:53PM
Partitioning & Replication  
1,673
Robert Gunther
04/09/2015 06:30PM
Re: Partitioning & Replication  
905
Rick James
04/12/2015 09:43PM
how to speed up for List partitioning table  
1,963
jongse park
12/28/2014 07:59PM
Re: how to speed up for List partitioning table  
1,077
Rick James
12/30/2014 03:05PM
wrong output generate while using partitions  
2,189
Shivam Patel
12/13/2014 07:56AM
Re: wrong output generate while using partitions  
1,154
Rick James
12/14/2014 10:33PM
Re: wrong output generate while using partitions  
1,056
Shivam Patel
12/16/2014 01:24AM
Re: wrong output generate while using partitions  
1,128
Jonathan Stephens
12/16/2014 02:32AM
Re: wrong output generate while using partitions  
1,126
Shivam Patel
12/16/2014 04:00AM
Re: wrong output generate while using partitions  
1,048
Rick James
12/16/2014 04:28PM
Re: wrong output generate while using partitions  
1,167
Shivam Patel
12/17/2014 07:20AM
Re: wrong output generate while using partitions  
1,164
Rick James
12/17/2014 11:27AM
large InnoDB table partitioning without explicit PK  
2,925
Miko M
11/12/2014 07:41PM
Re: large InnoDB table partitioning without explicit PK  
1,632
Rick James
11/13/2014 06:40PM
Re: large InnoDB table partitioning without explicit PK  
1,468
Miko M
11/14/2014 03:02AM
Re: large InnoDB table partitioning without explicit PK  
1,125
Rick James
11/15/2014 12:05AM
Re: large InnoDB table partitioning without explicit PK  
1,165
Miko M
11/16/2014 07:39PM
Re: large InnoDB table partitioning without explicit PK  
1,041
Rick James
11/17/2014 04:21PM
Re: large InnoDB table partitioning without explicit PK  
1,153
Rick James
11/17/2014 07:48PM
Re: large InnoDB table partitioning without explicit PK  
1,114
Miko M
11/18/2014 02:00AM
Re: large InnoDB table partitioning without explicit PK  
1,150
Rick James
11/18/2014 11:35PM
Re: large InnoDB table partitioning without explicit PK  
1,190
Miko M
11/22/2014 06:44AM
Re: large InnoDB table partitioning without explicit PK  
1,095
Miko M
11/18/2014 01:13AM
(non-unique) index more efficient than partition pruning  
1,329
Miko M
11/19/2014 12:27AM
Re: (non-unique) index more efficient than partition pruning  
1,169
Rick James
11/19/2014 06:01PM
Re: (non-unique) index more efficient than partition pruning  
1,244
Miko M
11/22/2014 08:39AM
Re: large InnoDB table partitioning without explicit PK  
1,243
Miko M
11/14/2014 03:04AM
Re: large InnoDB table partitioning without explicit PK  
1,311
Miko M
11/14/2014 03:05AM
Re: large InnoDB table partitioning without explicit PK  
1,354
Rick James
11/15/2014 12:32AM
Re: large InnoDB table partitioning without explicit PK  
1,324
Miko M
11/16/2014 08:31PM
Re: large InnoDB table partitioning without explicit PK  
1,112
Rick James
11/19/2014 12:12AM
Re: large InnoDB table partitioning without explicit PK  
1,086
Miko M
11/22/2014 09:07AM
Re: large InnoDB table partitioning without explicit PK  
1,075
Rick James
11/23/2014 09:00PM
Re: large InnoDB table partitioning without explicit PK  
1,180
Miko M
12/01/2014 11:16AM
Online Partition addition use "add partition" clause or "reorganize" clause?  
2,376
Tom Song
10/21/2014 03:53AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,119
Tom Song
10/22/2014 11:58PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,083
Rick James
10/23/2014 04:36PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,098
Tom Song
10/24/2014 02:05AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,048
Mikael Ronström
11/13/2014 06:54AM
Partitioning on account_id  
2,556
Ketil Stadskleiv
10/13/2014 02:54PM
Re: Partitioning on account_id  
1,281
Rick James
10/14/2014 06:04PM
Range partition and unique key  
2,143
Pierrick VODOZ
09/24/2014 08:42AM
Re: Range partition and unique key  
1,106
Rick James
09/25/2014 09:59AM
Re: Range partition and unique key  
1,235
Pierrick VODOZ
09/26/2014 03:40AM
Re: Range partition and unique key  
1,220
Rick James
09/27/2014 08:25AM
Horizontal partitioning on a per user basis?  
2,105
Peter Sarkozi
09/18/2014 05:40PM
Re: Horizontal partitioning on a per user basis?  
1,094
Luke Taylor
09/19/2014 01:12AM
Re: Horizontal partitioning on a per user basis?  
1,148
Rick James
09/19/2014 11:18PM
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)  
3,623
Raghavendra K
08/22/2014 12:37AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)  
1,340
Rick James
08/24/2014 09:14PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)  
1,273
Raghavendra K
08/25/2014 11:38AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)  
1,301
Rick James
08/26/2014 02:31PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)  
1,131
Raghavendra K
08/30/2014 03:43AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)  
1,270
Rick James
09/01/2014 08:28PM
Not Taking Paritioning when using Subquery or Join  
2,110
Marc Vettorel
08/27/2014 07:08AM
Re: Not Taking Paritioning when using Subquery or Join  
1,137
Marc Vettorel
08/27/2014 07:19AM
Re: Not Taking Paritioning when using Subquery or Join  
1,156
Rick James
08/28/2014 10:19AM
EXCHANGE PARTITION and DATA DIRECTORY errors  
2,533
Ekundayo Lasode
08/16/2014 09:47AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors  
1,223
Mattias Jonsson
08/19/2014 03:32AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors  
1,180
Ekundayo Lasode
08/19/2014 06:28AM
Storing time series data using partitioning  
2,935
Florian Rampp
08/14/2014 05:45AM
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"  
2,121
Jon Jacob
07/20/2014 07:50AM
Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"  
1,198
Rick James
07/21/2014 06:50PM
Range partitioning on floor (decimal(14.4)) doesn't work :/  
2,194
Max Herman
07/12/2014 12:35PM
Re: Range partitioning on floor (decimal(14.4)) doesn't work :/  
1,232
Rick James
07/14/2014 06:45PM
why explain partition shows first partition in every select query?  
2,497
Aamir Sohail
05/27/2014 07:18AM
Re: why explain partition shows first partition in every select query?  
1,193
Rick James
05/27/2014 03:10PM
Re: why explain partition shows first partition in every select query?  
1,130
Aamir Sohail
05/28/2014 12:52AM
Storing, accessing and configuring my partitions in diferent servers  
1,977
Victor Bombella
05/23/2014 11:54PM
Re: Storing, accessing and configuring my partitions in diferent servers  
1,052
Rick James
05/25/2014 04:57PM
missing data after partitioning - bug?  
2,391
rol and
05/23/2014 12:51PM
Re: missing data after partitioning - bug?  
1,157
Rick James
05/25/2014 04:27PM
MySql Partitioning problem (bug?)  
6,608
K T
05/07/2014 04:39PM
Re: MySql Partitioning problem (bug?)  
1,202
Rick James
05/09/2014 11:59PM
Re: MySql Partitioning problem (bug?)  
1,168
K T
05/10/2014 03:41PM
Re: MySql Partitioning problem (bug?)  
1,134
K T
05/10/2014 03:44PM
Re: MySql Partitioning problem (bug?)  
1,158
Mattias Jonsson
05/16/2014 06:15AM
MySQL partition by range on YEAR(date) weird results  
2,616
Adelin Feraru
05/12/2014 02:15AM
Re: MySQL partition by range on YEAR(date) weird results  
1,231
Rick James
05/15/2014 12:01AM
Re: MySQL partition by range on YEAR(date) weird results  
1,086
Adelin Feraru
05/15/2014 03:38AM
Re: MySQL partition by range on YEAR(date) weird results  
1,118
Mattias Jonsson
05/15/2014 11:42AM
Storing tables on multiple partitions  
2,078
sdgbfdsg fdhgfdhds
04/09/2014 08:04AM
Re: Storing tables on multiple partitions  
1,110
Rick James
04/11/2014 04:32PM
Re: Storing tables on multiple partitions  
1,117
mi Su
04/29/2014 01:09AM
MySql Horizontal partitioning - Pros-Cons  
3,618
Manohar K
04/14/2014 11:43AM
Re: MySql Horizontal partitioning - Pros-Cons  
1,812
Rick James
04/17/2014 11:16PM
Re: MySql Horizontal partitioning - Pros-Cons  
1,348
Rick James
04/19/2014 03:42PM
Consumption of more hard disk space in "Copying to tmp table" phase  
2,918
Raghavendra K
04/14/2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,121
Mattias Jonsson
04/14/2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,099
Raghavendra K
04/16/2014 06:40AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,092
Mattias Jonsson
04/17/2014 12:55PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,104
Rick James
04/17/2014 11:36PM
Failed to read from the .par file  
7,362
IGG t
04/02/2014 09:49AM
Re: Failed to read from the .par file  
4,359
Rick James
04/05/2014 01:13PM
How to extend partition when there is no unallocated space in hard disk?  
2,097
mi Su
01/06/2014 01:21AM
Re: How to extend partition when there is no unallocated space in hard disk?  
1,424
Rick James
01/08/2014 05:22PM
Partitioning or indexing for millions of records  
2,453
Aamir Sohail
11/26/2013 05:44AM
Re: Partitioning or indexing for millions of records  
1,855
Rick James
11/27/2013 12:39PM
Re: Partitioning or indexing for millions of records  
1,397
Aamir Sohail
11/28/2013 12:40AM
Re: Partitioning or indexing for millions of records  
1,496
Rick James
11/28/2013 09:07PM
Re: Partitioning or indexing for millions of records  
1,372
Aamir Sohail
11/29/2013 04:11AM
Re: Partitioning or indexing for millions of records  
1,358
Rick James
11/30/2013 01:30PM
Re: Partitioning or indexing for millions of records  
1,215
chris arndt
12/31/2013 11:34AM
best way to take backup for old partition and create new one?  
2,353
Aamir Sohail
12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?  
1,209
Rick James
12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?  
1,172
mi Su
12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?  
1,123
Rick James
12/13/2013 12:51AM
Am I doing this correctly?  
2,143
Jim Buckley Barrett
11/29/2013 05:03AM
Re: Am I doing this correctly?  
1,213
Jim Buckley Barrett
11/29/2013 06:22AM
Re: Am I doing this correctly?  
1,309
Rick James
11/30/2013 02:18PM
Re: Am I doing this correctly?  
1,130
mi Su
12/04/2013 12:38AM
Re: Am I doing this correctly?  
1,195
Jim Buckley Barrett
12/05/2013 03:48AM
Re: Am I doing this correctly?  
1,242
Rick James
12/05/2013 10:21AM
Re: Am I doing this correctly?  
1,147
Jim Buckley Barrett
12/10/2013 09:49AM
Re: Am I doing this correctly?  
1,199
Jim Buckley Barrett
12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table  
8,242
Aamir Sohail
11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table  
3,649
Rick James
11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table  
2,477
Aamir Sohail
11/29/2013 04:19AM
Partition data backup and restore  
6,505
Seungho Nam Nam
10/18/2013 12:48AM
Re: Partition data backup and restore  
3,068
Mattias Jonsson
10/18/2013 02:59AM
Re: Partition data backup and restore  
2,229
Steven Robinson
11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,996
mark silverman
09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,185
Rick James
09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,193
Mattias Jonsson
10/04/2013 01:02AM
Reorganize Partition Syntax error  
2,699
IGG t
09/16/2013 03:13AM
Re: Reorganize Partition Syntax error  
1,087
IGG t
09/16/2013 09:39AM
Re: Reorganize Partition Syntax error  
1,089
Rick James
09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?  
3,107
Prabhu Raja Singh
09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?  
1,898
Rick James
09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?  
1,669
Prabhu Raja Singh
09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness  
2,632
IGG t
08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness  
1,159
Rick James
08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness  
1,114
IGG t
08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness  
1,113
Rick James
08/31/2013 05:35PM
mysql tables in use 500, locked 500  
2,436
bruce.zuo bruce
07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500  
1,302
Rick James
07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500  
1,163
bruce.zuo bruce
07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500  
1,065
Mattias Jonsson
08/13/2013 05:42AM
Create index on partition table (manually and dynamically)  
5,483
Vladimir Pivovar
07/05/2013 11:26PM
Re: Create index on parttion table (manually and dynamically)  
1,847
Rick James
07/06/2013 10:52PM
Re: Create index on parttion table (manually and dynamically)  
1,696
Vladimir Pivovar
07/07/2013 12:20AM
Re: Create index on parttion table (manually and dynamically)  
1,561
Vladimir Pivovar
07/07/2013 10:57AM
Re: Create index on parttion table (manually and dynamically)  
1,641
Rick James
07/08/2013 09:46AM
Re: Create index on partition table (manually and dynamically)  
1,916
Vladimir Pivovar
07/10/2013 02:23PM
how to remove partitiong in mysql version5.6  
2,165
heiansan white
06/13/2013 01:41AM
Re: how to remove partitiong in mysql version5.6  
1,161
Rick James
06/15/2013 01:50PM
No. of partitions in NDB cluster  
1,783
Alax James
05/31/2013 02:14AM
IP vs Date Partition  
2,422
Tim Linden
05/13/2013 10:28AM
Re: IP vs Date Partition  
1,570
Rick James
05/14/2013 09:59PM
Re: IP vs Date Partition  
1,535
Tim Linden
05/15/2013 10:06AM
How should I partition this table?  
2,786
Ron Bergin
04/26/2013 09:18AM
Re: How should I partition this table?  
1,450
Rick James
04/27/2013 09:58PM
Re: How should I partition this table?  
1,278
Ron Bergin
04/28/2013 11:29AM
Re: How should I partition this table?  
1,238
Rick James
04/29/2013 08:10AM
Re: How should I partition this table?  
1,264
Ron Bergin
04/30/2013 08:39AM
Re: How should I partition this table?  
1,391
Rick James
05/01/2013 11:45PM
Re: How should I partition this table?  
1,253
Ron Bergin
05/02/2013 08:17AM
Re: How should I partition this table?  
1,151
Ron Bergin
05/02/2013 11:55AM
Re: How should I partition this table?  
1,214
Rick James
05/03/2013 09:00AM
Re: How should I partition this table?  
1,232
Ron Bergin
05/03/2013 09:32AM
Performance doubt  
2,099
Xavier Borrut
03/26/2013 06:41AM
Re: Performance doubt  
1,187
Rick James
03/28/2013 12:34AM
Re: Performance doubt  
831
Mattias Jonsson
04/09/2013 01:49AM
Event add partition works but not the drop partition  
2,289
Frwa Onto
04/04/2013 11:22PM
Re: Event add partition works but not the drop partition  
1,098
Frwa Onto
04/05/2013 04:13AM
Should I partition?  
2,250
Jacob Steinberger
03/19/2013 02:57PM
Re: Should I partition?  
1,248
Rick James
03/21/2013 08:49PM
Re: Should I partition?  
1,209
NOT_FOUND NOT_FOUND
04/03/2013 10:08AM
Re: Should I partition?  
1,113
Rick James
04/04/2013 11:35PM
Partitioned table problem after upgrade to 5.5  
2,266
Ming Wang
03/06/2013 04:07AM
Re: Partitioned table problem after upgrade to 5.5  
1,153
Mattias Jonsson
03/06/2013 04:38AM
Re: Partitioned table problem after upgrade to 5.5  
1,111
Ming Wang
03/07/2013 08:23PM
Re: Partitioned table problem after upgrade to 5.5  
1,016
Rick James
03/07/2013 11:32PM
Re: Partitioned table problem after upgrade to 5.5  
1,071
Mattias Jonsson
03/08/2013 02:20AM
If you use a partition table in mysql5.5, Contact function  
1,890
kyung gi lee
02/25/2013 03:12AM
Re: If you use a partition table in mysql5.5, Contact function  
1,202
Rick James
02/28/2013 09:34AM
How to (temporary) disable one partition in the partitioned table  
2,395
First Bell
02/13/2013 11:01PM
Re: How to (temporary) disable one partition in the partitioned table  
1,396
Rick James
02/22/2013 01:00AM
Re: How to (temporary) disable one partition in the partitioned table  
1,469
Mattias Jonsson
02/28/2013 05:51AM
Index with partitioning  
2,395
Hélio Hélio
01/30/2013 06:23AM
Re: Index with partitioning  
1,408
Rick James
02/01/2013 10:20PM
Re: Index with partitioning  
1,573
Hélio Hélio
02/04/2013 08:03AM
Re: Index with partitioning  
1,421
Rick James
02/07/2013 10:09PM
Re: Index with partitioning  
1,415
Hélio Hélio
02/08/2013 06:55AM
Re: Index with partitioning  
1,261
Rick James
02/09/2013 01:22PM
Re: Index with partitioning  
1,737
Hélio Hélio
02/14/2013 12:26PM
MySQL Partitioning showing low performance  
2,160
Manosh Manohar
02/05/2013 12:10AM
Re: MySQL Partitioning showing low performance  
1,274
Rick James
02/07/2013 10:14PM
Re: MySQL Partitioning showing low performance  
1,116
Manosh Manohar
02/08/2013 12:39AM
How to let the query run on one partition  
2,333
Shawn Liu
01/09/2013 08:29AM
Re: How to let the query run on one partition  
1,237
Rick James
01/10/2013 08:45PM
How to partition by City \ State  
2,250
Noah Goodrich
12/19/2012 10:06PM
Re: How to partition by City \ State  
1,291
Rick James
12/20/2012 10:00PM
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.