MySQL Forums
Forum List  »  Partitioning
Announcements Last Post
•   MySQL Connector/ODBC 5.3.13 has been released 04/29/2019 05:44PM
•   MySQL Cluster 7.6.10 has been released 04/27/2019 03:25AM
•   MySQL Cluster 7.5.14 has been released 04/26/2019 12:12PM
•   MySQL Cluster 7.3.25 has been released 04/26/2019 11:34AM
•   MySQL Cluster 7.4.24 has been released 04/26/2019 11:00AM

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

Subject
Views
Written By
Posted
How to partition for performance  
1,953
Doug Wolfgram
07/29/2015 09:42PM
Re: How to partition for performance  
1,168
Rick James
07/31/2015 01:36PM
Re: How to partition for performance  
1,153
Rick James
07/31/2015 02:23PM
Partition and Subpartition using Unixtime  
1,711
Jaineera Naveen
07/09/2015 07:53AM
Re: Partition and Subpartition using Unixtime  
997
Rick James
07/09/2015 11:59PM
Optimum partition for a bigger table  
1,631
Jaineera Naveen
07/09/2015 12:35AM
Re: Optimum partition for a bigger table  
995
Rick James
07/09/2015 11:36PM
Mysql 5.5 Partittioning row field  
1,715
Shubham Jain
06/24/2015 10:19PM
Re: Mysql 5.5 Partittioning row field  
1,278
Jonathan Stephens
06/25/2015 10:16AM
Re: Mysql 5.5 Partittioning row field  
1,075
Rick James
06/26/2015 12:15AM
Re: Mysql 5.5 Partittioning row field  
1,260
Jonathan Stephens
06/26/2015 02:40AM
Re: Mysql 5.5 Partittioning row field  
1,062
Shubham Jain
06/26/2015 07:02AM
subpartiton by key doesn't evenly distribute data  
1,769
jongse park
06/10/2015 11:20PM
Re: subpartiton by key doesn't evenly distribute data  
921
Rick James
06/13/2015 08:25AM
Re: subpartiton by key doesn't evenly distribute data  
957
jongse park
06/15/2015 12:01AM
Re: subpartiton by key doesn't evenly distribute data  
896
Rick James
06/15/2015 07:07PM
Re: subpartiton by key doesn't evenly distribute data  
1,067
jongse park
06/15/2015 10:41PM
Re: subpartiton by key doesn't evenly distribute data  
963
Rick James
06/16/2015 07:36PM
Advice on partitioning  
2,131
me su
04/24/2015 01:40PM
Re: Advice on partitioning  
1,184
Rick James
04/24/2015 05:34PM
Re: Advice on partitioning  
1,199
Mehdi Salarkia
04/27/2015 09:05AM
Re: Advice on partitioning  
1,221
Rick James
04/27/2015 02:22PM
Re: Advice on partitioning  
1,040
Drew Morris
04/28/2015 11:02AM
Re: Advice on partitioning  
1,069
Rick James
04/28/2015 12:32PM
Re: Advice on partitioning  
1,089
Mehdi Salarkia
04/28/2015 04:07PM
Re: Advice on partitioning  
933
Mehdi Salarkia
06/15/2015 06:39PM
Re: Advice on partitioning  
1,106
Rick James
06/15/2015 07:05PM
Re: Advice on partitioning  
1,055
Mehdi Salarkia
06/16/2015 06:40PM
Partition by range for float data type column float(12,9) in mysql server 5.6  
2,303
esha sethi
05/15/2015 11:49PM
Re: Partition by range for float data type column float(12,9) in mysql server 5.6  
1,367
Rick James
05/17/2015 12:04AM
Select using partition dynamically  
2,514
Jose Lima
05/07/2015 06:21PM
Re: Select using partition dynamically  
1,241
Rick James
05/11/2015 12:53PM
Partitioning & Replication  
1,821
Robert Gunther
04/09/2015 06:30PM
Re: Partitioning & Replication  
977
Rick James
04/12/2015 09:43PM
how to speed up for List partitioning table  
2,090
jongse park
12/28/2014 07:59PM
Re: how to speed up for List partitioning table  
1,174
Rick James
12/30/2014 03:05PM
wrong output generate while using partitions  
2,330
Shivam Patel
12/13/2014 07:56AM
Re: wrong output generate while using partitions  
1,278
Rick James
12/14/2014 10:33PM
Re: wrong output generate while using partitions  
1,169
Shivam Patel
12/16/2014 01:24AM
Re: wrong output generate while using partitions  
1,257
Jonathan Stephens
12/16/2014 02:32AM
Re: wrong output generate while using partitions  
1,236
Shivam Patel
12/16/2014 04:00AM
Re: wrong output generate while using partitions  
1,143
Rick James
12/16/2014 04:28PM
Re: wrong output generate while using partitions  
1,291
Shivam Patel
12/17/2014 07:20AM
Re: wrong output generate while using partitions  
1,284
Rick James
12/17/2014 11:27AM
large InnoDB table partitioning without explicit PK  
3,245
Miko M
11/12/2014 07:41PM
Re: large InnoDB table partitioning without explicit PK  
1,800
Rick James
11/13/2014 06:40PM
Re: large InnoDB table partitioning without explicit PK  
1,652
Miko M
11/14/2014 03:02AM
Re: large InnoDB table partitioning without explicit PK  
1,217
Rick James
11/15/2014 12:05AM
Re: large InnoDB table partitioning without explicit PK  
1,275
Miko M
11/16/2014 07:39PM
Re: large InnoDB table partitioning without explicit PK  
1,180
Rick James
11/17/2014 04:21PM
Re: large InnoDB table partitioning without explicit PK  
1,264
Rick James
11/17/2014 07:48PM
Re: large InnoDB table partitioning without explicit PK  
1,253
Miko M
11/18/2014 02:00AM
Re: large InnoDB table partitioning without explicit PK  
1,295
Rick James
11/18/2014 11:35PM
Re: large InnoDB table partitioning without explicit PK  
1,311
Miko M
11/22/2014 06:44AM
Re: large InnoDB table partitioning without explicit PK  
1,189
Miko M
11/18/2014 01:13AM
(non-unique) index more efficient than partition pruning  
1,520
Miko M
11/19/2014 12:27AM
Re: (non-unique) index more efficient than partition pruning  
1,279
Rick James
11/19/2014 06:01PM
Re: (non-unique) index more efficient than partition pruning  
1,397
Miko M
11/22/2014 08:39AM
Re: large InnoDB table partitioning without explicit PK  
1,423
Miko M
11/14/2014 03:04AM
Re: large InnoDB table partitioning without explicit PK  
1,466
Miko M
11/14/2014 03:05AM
Re: large InnoDB table partitioning without explicit PK  
1,499
Rick James
11/15/2014 12:32AM
Re: large InnoDB table partitioning without explicit PK  
1,489
Miko M
11/16/2014 08:31PM
Re: large InnoDB table partitioning without explicit PK  
1,254
Rick James
11/19/2014 12:12AM
Re: large InnoDB table partitioning without explicit PK  
1,204
Miko M
11/22/2014 09:07AM
Re: large InnoDB table partitioning without explicit PK  
1,208
Rick James
11/23/2014 09:00PM
Re: large InnoDB table partitioning without explicit PK  
1,322
Miko M
12/01/2014 11:16AM
Online Partition addition use "add partition" clause or "reorganize" clause?  
2,531
Tom Song
10/21/2014 03:53AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,196
Tom Song
10/22/2014 11:58PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,178
Rick James
10/23/2014 04:36PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,153
Tom Song
10/24/2014 02:05AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,154
Mikael Ronström
11/13/2014 06:54AM
Partitioning on account_id  
2,700
Ketil Stadskleiv
10/13/2014 02:54PM
Re: Partitioning on account_id  
1,353
Rick James
10/14/2014 06:04PM
Range partition and unique key  
2,298
Pierrick VODOZ
09/24/2014 08:42AM
Re: Range partition and unique key  
1,202
Rick James
09/25/2014 09:59AM
Re: Range partition and unique key  
1,322
Pierrick VODOZ
09/26/2014 03:40AM
Re: Range partition and unique key  
1,315
Rick James
09/27/2014 08:25AM
Horizontal partitioning on a per user basis?  
2,209
Peter Sarkozi
09/18/2014 05:40PM
Re: Horizontal partitioning on a per user basis?  
1,165
Luke Taylor
09/19/2014 01:12AM
Re: Horizontal partitioning on a per user basis?  
1,223
Rick James
09/19/2014 11:18PM
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)  
4,215
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,498
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,419
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,417
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,267
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,412
Rick James
09/01/2014 08:28PM
Not Taking Paritioning when using Subquery or Join  
2,281
Marc Vettorel
08/27/2014 07:08AM
Re: Not Taking Paritioning when using Subquery or Join  
1,196
Marc Vettorel
08/27/2014 07:19AM
Re: Not Taking Paritioning when using Subquery or Join  
1,255
Rick James
08/28/2014 10:19AM
EXCHANGE PARTITION and DATA DIRECTORY errors  
2,866
Ekundayo Lasode
08/16/2014 09:47AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors  
1,375
Mattias Jonsson
08/19/2014 03:32AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors  
1,276
Ekundayo Lasode
08/19/2014 06:28AM
Storing time series data using partitioning  
3,138
Florian Rampp
08/14/2014 05:45AM
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"  
2,225
Jon Jacob
07/20/2014 07:50AM
Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"  
1,286
Rick James
07/21/2014 06:50PM
Range partitioning on floor (decimal(14.4)) doesn't work :/  
2,320
Max Herman
07/12/2014 12:35PM
Re: Range partitioning on floor (decimal(14.4)) doesn't work :/  
1,303
Rick James
07/14/2014 06:45PM
why explain partition shows first partition in every select query?  
2,715
Aamir Sohail
05/27/2014 07:18AM
Re: why explain partition shows first partition in every select query?  
1,319
Rick James
05/27/2014 03:10PM
Re: why explain partition shows first partition in every select query?  
1,192
Aamir Sohail
05/28/2014 12:52AM
Storing, accessing and configuring my partitions in diferent servers  
2,048
Victor Bombella
05/23/2014 11:54PM
Re: Storing, accessing and configuring my partitions in diferent servers  
1,107
Rick James
05/25/2014 04:57PM
missing data after partitioning - bug?  
2,574
rol and
05/23/2014 12:51PM
Re: missing data after partitioning - bug?  
1,240
Rick James
05/25/2014 04:27PM
MySql Partitioning problem (bug?)  
6,769
K T
05/07/2014 04:39PM
Re: MySql Partitioning problem (bug?)  
1,278
Rick James
05/09/2014 11:59PM
Re: MySql Partitioning problem (bug?)  
1,240
K T
05/10/2014 03:41PM
Re: MySql Partitioning problem (bug?)  
1,190
K T
05/10/2014 03:44PM
Re: MySql Partitioning problem (bug?)  
1,224
Mattias Jonsson
05/16/2014 06:15AM
MySQL partition by range on YEAR(date) weird results  
2,782
Adelin Feraru
05/12/2014 02:15AM
Re: MySQL partition by range on YEAR(date) weird results  
1,300
Rick James
05/15/2014 12:01AM
Re: MySQL partition by range on YEAR(date) weird results  
1,175
Adelin Feraru
05/15/2014 03:38AM
Re: MySQL partition by range on YEAR(date) weird results  
1,200
Mattias Jonsson
05/15/2014 11:42AM
Storing tables on multiple partitions  
2,217
sdgbfdsg fdhgfdhds
04/09/2014 08:04AM
Re: Storing tables on multiple partitions  
1,185
Rick James
04/11/2014 04:32PM
Re: Storing tables on multiple partitions  
1,176
mi Su
04/29/2014 01:09AM
MySql Horizontal partitioning - Pros-Cons  
3,989
Manohar K
04/14/2014 11:43AM
Re: MySql Horizontal partitioning - Pros-Cons  
1,982
Rick James
04/17/2014 11:16PM
Re: MySql Horizontal partitioning - Pros-Cons  
1,471
Rick James
04/19/2014 03:42PM
Consumption of more hard disk space in "Copying to tmp table" phase  
3,101
Raghavendra K
04/14/2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,205
Mattias Jonsson
04/14/2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,175
Raghavendra K
04/16/2014 06:40AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,183
Mattias Jonsson
04/17/2014 12:55PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,181
Rick James
04/17/2014 11:36PM
Failed to read from the .par file  
9,361
IGG t
04/02/2014 09:49AM
Re: Failed to read from the .par file  
5,384
Rick James
04/05/2014 01:13PM
How to extend partition when there is no unallocated space in hard disk?  
2,198
mi Su
01/06/2014 01:21AM
Re: How to extend partition when there is no unallocated space in hard disk?  
1,541
Rick James
01/08/2014 05:22PM
Partitioning or indexing for millions of records  
2,555
Aamir Sohail
11/26/2013 05:44AM
Re: Partitioning or indexing for millions of records  
1,946
Rick James
11/27/2013 12:39PM
Re: Partitioning or indexing for millions of records  
1,477
Aamir Sohail
11/28/2013 12:40AM
Re: Partitioning or indexing for millions of records  
1,574
Rick James
11/28/2013 09:07PM
Re: Partitioning or indexing for millions of records  
1,452
Aamir Sohail
11/29/2013 04:11AM
Re: Partitioning or indexing for millions of records  
1,442
Rick James
11/30/2013 01:30PM
Re: Partitioning or indexing for millions of records  
1,293
chris arndt
12/31/2013 11:34AM
best way to take backup for old partition and create new one?  
2,459
Aamir Sohail
12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?  
1,256
Rick James
12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?  
1,214
mi Su
12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?  
1,160
Rick James
12/13/2013 12:51AM
Am I doing this correctly?  
2,236
Jim Buckley Barrett
11/29/2013 05:03AM
Re: Am I doing this correctly?  
1,269
Jim Buckley Barrett
11/29/2013 06:22AM
Re: Am I doing this correctly?  
1,379
Rick James
11/30/2013 02:18PM
Re: Am I doing this correctly?  
1,187
mi Su
12/04/2013 12:38AM
Re: Am I doing this correctly?  
1,236
Jim Buckley Barrett
12/05/2013 03:48AM
Re: Am I doing this correctly?  
1,288
Rick James
12/05/2013 10:21AM
Re: Am I doing this correctly?  
1,215
Jim Buckley Barrett
12/10/2013 09:49AM
Re: Am I doing this correctly?  
1,258
Jim Buckley Barrett
12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table  
11,164
Aamir Sohail
11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table  
4,766
Rick James
11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table  
3,138
Aamir Sohail
11/29/2013 04:19AM
Partition data backup and restore  
7,666
Seungho Nam Nam
10/18/2013 12:48AM
Re: Partition data backup and restore  
3,551
Mattias Jonsson
10/18/2013 02:59AM
Re: Partition data backup and restore  
2,524
Steven Robinson
11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
2,136
mark silverman
09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,234
Rick James
09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,268
Mattias Jonsson
10/04/2013 01:02AM
Reorganize Partition Syntax error  
2,826
IGG t
09/16/2013 03:13AM
Re: Reorganize Partition Syntax error  
1,135
IGG t
09/16/2013 09:39AM
Re: Reorganize Partition Syntax error  
1,151
Rick James
09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?  
3,386
Prabhu Raja Singh
09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?  
2,038
Rick James
09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?  
1,794
Prabhu Raja Singh
09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness  
2,741
IGG t
08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness  
1,210
Rick James
08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness  
1,150
IGG t
08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness  
1,158
Rick James
08/31/2013 05:35PM
mysql tables in use 500, locked 500  
2,549
bruce.zuo bruce
07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500  
1,395
Rick James
07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500  
1,293
bruce.zuo bruce
07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500  
1,134
Mattias Jonsson
08/13/2013 05:42AM
Create index on partition table (manually and dynamically)  
6,409
Vladimir Pivovar
07/05/2013 11:26PM
Re: Create index on parttion table (manually and dynamically)  
2,106
Rick James
07/06/2013 10:52PM
Re: Create index on parttion table (manually and dynamically)  
1,933
Vladimir Pivovar
07/07/2013 12:20AM
Re: Create index on parttion table (manually and dynamically)  
1,742
Vladimir Pivovar
07/07/2013 10:57AM
Re: Create index on parttion table (manually and dynamically)  
1,843
Rick James
07/08/2013 09:46AM
Re: Create index on partition table (manually and dynamically)  
2,129
Vladimir Pivovar
07/10/2013 02:23PM
how to remove partitiong in mysql version5.6  
2,243
heiansan white
06/13/2013 01:41AM
Re: how to remove partitiong in mysql version5.6  
1,219
Rick James
06/15/2013 01:50PM
No. of partitions in NDB cluster  
1,856
Alax James
05/31/2013 02:14AM
IP vs Date Partition  
2,524
Tim Linden
05/13/2013 10:28AM
Re: IP vs Date Partition  
1,608
Rick James
05/14/2013 09:59PM
Re: IP vs Date Partition  
1,579
Tim Linden
05/15/2013 10:06AM
How should I partition this table?  
2,925
Ron Bergin
04/26/2013 09:18AM
Re: How should I partition this table?  
1,541
Rick James
04/27/2013 09:58PM
Re: How should I partition this table?  
1,372
Ron Bergin
04/28/2013 11:29AM
Re: How should I partition this table?  
1,312
Rick James
04/29/2013 08:10AM
Re: How should I partition this table?  
1,348
Ron Bergin
04/30/2013 08:39AM
Re: How should I partition this table?  
1,476
Rick James
05/01/2013 11:45PM
Re: How should I partition this table?  
1,330
Ron Bergin
05/02/2013 08:17AM
Re: How should I partition this table?  
1,221
Ron Bergin
05/02/2013 11:55AM
Re: How should I partition this table?  
1,288
Rick James
05/03/2013 09:00AM
Re: How should I partition this table?  
1,293
Ron Bergin
05/03/2013 09:32AM
Performance doubt  
2,239
Xavier Borrut
03/26/2013 06:41AM
Re: Performance doubt  
1,237
Rick James
03/28/2013 12:34AM
Re: Performance doubt  
898
Mattias Jonsson
04/09/2013 01:49AM
Event add partition works but not the drop partition  
2,386
Frwa Onto
04/04/2013 11:22PM
Re: Event add partition works but not the drop partition  
1,140
Frwa Onto
04/05/2013 04:13AM
Should I partition?  
2,310
Jacob Steinberger
03/19/2013 02:57PM
Re: Should I partition?  
1,279
Rick James
03/21/2013 08:49PM
Re: Should I partition?  
1,261
NOT_FOUND NOT_FOUND
04/03/2013 10:08AM
Re: Should I partition?  
1,165
Rick James
04/04/2013 11:35PM
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.