MySQL Forums
Forum List  »  Partitioning
Announcements Last Post
•   MySQL Cluster 7.3.30 has been released 07/14/2020 12:50PM
•   MySQL Cluster 7.4.29 has been released 07/14/2020 02:18AM
•   MySQL Cluster 7.5.19 has been released 07/14/2020 02:09AM
•   MySQL Cluster 7.6.15 has been released 07/14/2020 01:57AM
•   MySQL Connector/J 8.0.21 has been released 07/13/2020 09:07AM

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

Subject
Views
Written By
Posted
Licensing requirements  
2,008
Damien Kick
12/16/2015 03:18PM
Re: Licensing requirements  
1,146
Damien Kick
12/16/2015 03:39PM
Re: Licensing requirements  
1,034
Rick James
01/05/2016 10:59AM
Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails  
5,981
MONU VERMA
11/20/2015 07:45AM
Re: Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails  
4,363
Rick James
12/17/2015 01:01PM
query optimization  
2,096
Srilakshmi Manjunath
10/29/2015 03:08AM
Re: query optimization  
1,140
Rick James
10/30/2015 04:58PM
Dose mysql partitioning support global index ?  
2,971
jongse park
09/21/2015 07:31PM
Re: Dose mysql partitioning support global index ?  
2,073
Jonathan Stephens
09/21/2015 11:30PM
Re: Dose mysql partitioning support global index ?  
1,433
Rick James
10/02/2015 09:51PM
Should I PARTITION my table?  
2,008
Rick James
10/01/2015 09:11PM
Does Mysql Date Partition can be created on date time for every day???  
3,710
Akshath Hegde
08/23/2015 12:18AM
Re: Does Mysql Date Partition can be created on date time for every day???  
1,727
Rick James
08/23/2015 05:55PM
Re: Does Mysql Date Partition can be created on date time for every day???  
1,862
Akshath Hegde
08/26/2015 02:53AM
Re: Does Mysql Date Partition can be created on date time for every day???  
1,643
Rick James
08/27/2015 07:40AM
No other way than delete primary key to create partitions by single datetime columns?  
2,061
Sam Young
08/20/2015 08:00PM
Re: No other way than delete primary key to create partitions by single datetime columns?  
1,313
Jonathan Stephens
08/21/2015 02:53AM
Re: No other way than delete primary key to create partitions by single datetime columns?  
1,182
Sam Young
08/23/2015 08:57PM
Re: No other way than delete primary key to create partitions by single datetime columns?  
1,214
Rick James
08/22/2015 03:35PM
Re: No other way than delete primary key to create partitions by single datetime columns?  
1,187
Sam Young
08/23/2015 09:23PM
Re: No other way than delete primary key to create partitions by single datetime columns?  
1,213
Rick James
08/24/2015 12:36PM
Re: No other way than delete primary key to create partitions by single datetime columns?  
1,246
Sam Young
08/26/2015 12:53AM
Re: No other way than delete primary key to create partitions by single datetime columns?  
1,184
Rick James
08/26/2015 10:02AM
Re: No other way than delete primary key to create partitions by single datetime columns?  
1,139
Sam Young
08/26/2015 07:42PM
Dose MySQL support a dynamic pruning in mysql partitioning ?  
1,895
jongse park
08/05/2015 08:41PM
Re: Dose MySQL support a dynamic pruning in mysql partitioning ?  
1,103
Jonathan Stephens
08/06/2015 03:31AM
How to partition for performance  
2,138
Doug Wolfgram
07/29/2015 09:42PM
Re: How to partition for performance  
1,286
Rick James
07/31/2015 01:36PM
Re: How to partition for performance  
1,256
Rick James
07/31/2015 02:23PM
Partition and Subpartition using Unixtime  
1,854
Jaineera Naveen
07/09/2015 07:53AM
Re: Partition and Subpartition using Unixtime  
1,104
Rick James
07/09/2015 11:59PM
Optimum partition for a bigger table  
1,821
Jaineera Naveen
07/09/2015 12:35AM
Re: Optimum partition for a bigger table  
1,098
Rick James
07/09/2015 11:36PM
Mysql 5.5 Partittioning row field  
1,871
Shubham Jain
06/24/2015 10:19PM
Re: Mysql 5.5 Partittioning row field  
1,411
Jonathan Stephens
06/25/2015 10:16AM
Re: Mysql 5.5 Partittioning row field  
1,190
Rick James
06/26/2015 12:15AM
Re: Mysql 5.5 Partittioning row field  
1,371
Jonathan Stephens
06/26/2015 02:40AM
Re: Mysql 5.5 Partittioning row field  
1,150
Shubham Jain
06/26/2015 07:02AM
subpartiton by key doesn't evenly distribute data  
1,928
jongse park
06/10/2015 11:20PM
Re: subpartiton by key doesn't evenly distribute data  
1,017
Rick James
06/13/2015 08:25AM
Re: subpartiton by key doesn't evenly distribute data  
1,052
jongse park
06/15/2015 12:01AM
Re: subpartiton by key doesn't evenly distribute data  
986
Rick James
06/15/2015 07:07PM
Re: subpartiton by key doesn't evenly distribute data  
1,195
jongse park
06/15/2015 10:41PM
Re: subpartiton by key doesn't evenly distribute data  
1,038
Rick James
06/16/2015 07:36PM
Advice on partitioning  
2,340
me su
04/24/2015 01:40PM
Re: Advice on partitioning  
1,313
Rick James
04/24/2015 05:34PM
Re: Advice on partitioning  
1,345
Mehdi Salarkia
04/27/2015 09:05AM
Re: Advice on partitioning  
1,331
Rick James
04/27/2015 02:22PM
Re: Advice on partitioning  
1,151
Drew Morris
04/28/2015 11:02AM
Re: Advice on partitioning  
1,186
Rick James
04/28/2015 12:32PM
Re: Advice on partitioning  
1,193
Mehdi Salarkia
04/28/2015 04:07PM
Re: Advice on partitioning  
1,041
Mehdi Salarkia
06/15/2015 06:39PM
Re: Advice on partitioning  
1,227
Rick James
06/15/2015 07:05PM
Re: Advice on partitioning  
1,167
Mehdi Salarkia
06/16/2015 06:40PM
Partition by range for float data type column float(12,9) in mysql server 5.6  
2,574
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,549
Rick James
05/17/2015 12:04AM
Select using partition dynamically  
2,993
Jose Lima
05/07/2015 06:21PM
Re: Select using partition dynamically  
1,428
Rick James
05/11/2015 12:53PM
Partitioning & Replication  
1,978
Robert Gunther
04/09/2015 06:30PM
Re: Partitioning & Replication  
1,046
Rick James
04/12/2015 09:43PM
how to speed up for List partitioning table  
2,248
jongse park
12/28/2014 07:59PM
Re: how to speed up for List partitioning table  
1,297
Rick James
12/30/2014 03:05PM
wrong output generate while using partitions  
2,505
Shivam Patel
12/13/2014 07:56AM
Re: wrong output generate while using partitions  
1,410
Rick James
12/14/2014 10:33PM
Re: wrong output generate while using partitions  
1,294
Shivam Patel
12/16/2014 01:24AM
Re: wrong output generate while using partitions  
1,386
Jonathan Stephens
12/16/2014 02:32AM
Re: wrong output generate while using partitions  
1,360
Shivam Patel
12/16/2014 04:00AM
Re: wrong output generate while using partitions  
1,250
Rick James
12/16/2014 04:28PM
Re: wrong output generate while using partitions  
1,423
Shivam Patel
12/17/2014 07:20AM
Re: wrong output generate while using partitions  
1,408
Rick James
12/17/2014 11:27AM
large InnoDB table partitioning without explicit PK  
3,630
Miko M
11/12/2014 07:41PM
Re: large InnoDB table partitioning without explicit PK  
1,993
Rick James
11/13/2014 06:40PM
Re: large InnoDB table partitioning without explicit PK  
1,831
Miko M
11/14/2014 03:02AM
Re: large InnoDB table partitioning without explicit PK  
1,346
Rick James
11/15/2014 12:05AM
Re: large InnoDB table partitioning without explicit PK  
1,412
Miko M
11/16/2014 07:39PM
Re: large InnoDB table partitioning without explicit PK  
1,326
Rick James
11/17/2014 04:21PM
Re: large InnoDB table partitioning without explicit PK  
1,392
Rick James
11/17/2014 07:48PM
Re: large InnoDB table partitioning without explicit PK  
1,400
Miko M
11/18/2014 02:00AM
Re: large InnoDB table partitioning without explicit PK  
1,421
Rick James
11/18/2014 11:35PM
Re: large InnoDB table partitioning without explicit PK  
1,441
Miko M
11/22/2014 06:44AM
Re: large InnoDB table partitioning without explicit PK  
1,323
Miko M
11/18/2014 01:13AM
(non-unique) index more efficient than partition pruning  
1,670
Miko M
11/19/2014 12:27AM
Re: (non-unique) index more efficient than partition pruning  
1,428
Rick James
11/19/2014 06:01PM
Re: (non-unique) index more efficient than partition pruning  
1,548
Miko M
11/22/2014 08:39AM
Re: large InnoDB table partitioning without explicit PK  
1,597
Miko M
11/14/2014 03:04AM
Re: large InnoDB table partitioning without explicit PK  
1,628
Miko M
11/14/2014 03:05AM
Re: large InnoDB table partitioning without explicit PK  
1,660
Rick James
11/15/2014 12:32AM
Re: large InnoDB table partitioning without explicit PK  
1,670
Miko M
11/16/2014 08:31PM
Re: large InnoDB table partitioning without explicit PK  
1,416
Rick James
11/19/2014 12:12AM
Re: large InnoDB table partitioning without explicit PK  
1,333
Miko M
11/22/2014 09:07AM
Re: large InnoDB table partitioning without explicit PK  
1,344
Rick James
11/23/2014 09:00PM
Re: large InnoDB table partitioning without explicit PK  
1,484
Miko M
12/01/2014 11:16AM
Online Partition addition use "add partition" clause or "reorganize" clause?  
2,704
Tom Song
10/21/2014 03:53AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,290
Tom Song
10/22/2014 11:58PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,310
Rick James
10/23/2014 04:36PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,243
Tom Song
10/24/2014 02:05AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?  
1,292
Mikael Ronström
11/13/2014 06:54AM
Partitioning on account_id  
2,860
Ketil Stadskleiv
10/13/2014 02:54PM
Re: Partitioning on account_id  
1,456
Rick James
10/14/2014 06:04PM
Range partition and unique key  
2,473
Pierrick VODOZ
09/24/2014 08:42AM
Re: Range partition and unique key  
1,287
Rick James
09/25/2014 09:59AM
Re: Range partition and unique key  
1,406
Pierrick VODOZ
09/26/2014 03:40AM
Re: Range partition and unique key  
1,411
Rick James
09/27/2014 08:25AM
Horizontal partitioning on a per user basis?  
2,346
Peter Sarkozi
09/18/2014 05:40PM
Re: Horizontal partitioning on a per user basis?  
1,239
Luke Taylor
09/19/2014 01:12AM
Re: Horizontal partitioning on a per user basis?  
1,293
Rick James
09/19/2014 11:18PM
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)  
4,765
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,655
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,604
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,559
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,421
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,559
Rick James
09/01/2014 08:28PM
Not Taking Paritioning when using Subquery or Join  
2,459
Marc Vettorel
08/27/2014 07:08AM
Re: Not Taking Paritioning when using Subquery or Join  
1,285
Marc Vettorel
08/27/2014 07:19AM
Re: Not Taking Paritioning when using Subquery or Join  
1,350
Rick James
08/28/2014 10:19AM
EXCHANGE PARTITION and DATA DIRECTORY errors  
3,346
Ekundayo Lasode
08/16/2014 09:47AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors  
1,538
Mattias Jonsson
08/19/2014 03:32AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors  
1,419
Ekundayo Lasode
08/19/2014 06:28AM
Storing time series data using partitioning  
3,460
Florian Rampp
08/14/2014 05:45AM
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"  
2,366
Jon Jacob
07/20/2014 07:50AM
Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"  
1,383
Rick James
07/21/2014 06:50PM
Range partitioning on floor (decimal(14.4)) doesn't work :/  
2,450
Max Herman
07/12/2014 12:35PM
Re: Range partitioning on floor (decimal(14.4)) doesn't work :/  
1,403
Rick James
07/14/2014 06:45PM
why explain partition shows first partition in every select query?  
2,879
Aamir Sohail
05/27/2014 07:18AM
Re: why explain partition shows first partition in every select query?  
1,443
Rick James
05/27/2014 03:10PM
Re: why explain partition shows first partition in every select query?  
1,292
Aamir Sohail
05/28/2014 12:52AM
Storing, accessing and configuring my partitions in diferent servers  
2,176
Victor Bombella
05/23/2014 11:54PM
Re: Storing, accessing and configuring my partitions in diferent servers  
1,185
Rick James
05/25/2014 04:57PM
missing data after partitioning - bug?  
2,747
rol and
05/23/2014 12:51PM
Re: missing data after partitioning - bug?  
1,333
Rick James
05/25/2014 04:27PM
MySql Partitioning problem (bug?)  
6,905
K T
05/07/2014 04:39PM
Re: MySql Partitioning problem (bug?)  
1,361
Rick James
05/09/2014 11:59PM
Re: MySql Partitioning problem (bug?)  
1,325
K T
05/10/2014 03:41PM
Re: MySql Partitioning problem (bug?)  
1,274
K T
05/10/2014 03:44PM
Re: MySql Partitioning problem (bug?)  
1,326
Mattias Jonsson
05/16/2014 06:15AM
MySQL partition by range on YEAR(date) weird results  
3,021
Adelin Feraru
05/12/2014 02:15AM
Re: MySQL partition by range on YEAR(date) weird results  
1,391
Rick James
05/15/2014 12:01AM
Re: MySQL partition by range on YEAR(date) weird results  
1,270
Adelin Feraru
05/15/2014 03:38AM
Re: MySQL partition by range on YEAR(date) weird results  
1,297
Mattias Jonsson
05/15/2014 11:42AM
Storing tables on multiple partitions  
2,376
sdgbfdsg fdhgfdhds
04/09/2014 08:04AM
Re: Storing tables on multiple partitions  
1,268
Rick James
04/11/2014 04:32PM
Re: Storing tables on multiple partitions  
1,248
mi Su
04/29/2014 01:09AM
MySql Horizontal partitioning - Pros-Cons  
4,293
Manohar K
04/14/2014 11:43AM
Re: MySql Horizontal partitioning - Pros-Cons  
2,129
Rick James
04/17/2014 11:16PM
Re: MySql Horizontal partitioning - Pros-Cons  
1,580
Rick James
04/19/2014 03:42PM
Consumption of more hard disk space in "Copying to tmp table" phase  
3,316
Raghavendra K
04/14/2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,303
Mattias Jonsson
04/14/2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,264
Raghavendra K
04/16/2014 06:40AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,284
Mattias Jonsson
04/17/2014 12:55PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase  
1,281
Rick James
04/17/2014 11:36PM
Failed to read from the .par file  
11,471
IGG t
04/02/2014 09:49AM
Re: Failed to read from the .par file  
6,361
Rick James
04/05/2014 01:13PM
How to extend partition when there is no unallocated space in hard disk?  
2,336
mi Su
01/06/2014 01:21AM
Re: How to extend partition when there is no unallocated space in hard disk?  
1,670
Rick James
01/08/2014 05:22PM
Partitioning or indexing for millions of records  
2,701
Aamir Sohail
11/26/2013 05:44AM
Re: Partitioning or indexing for millions of records  
2,045
Rick James
11/27/2013 12:39PM
Re: Partitioning or indexing for millions of records  
1,612
Aamir Sohail
11/28/2013 12:40AM
Re: Partitioning or indexing for millions of records  
1,683
Rick James
11/28/2013 09:07PM
Re: Partitioning or indexing for millions of records  
1,574
Aamir Sohail
11/29/2013 04:11AM
Re: Partitioning or indexing for millions of records  
1,552
Rick James
11/30/2013 01:30PM
Re: Partitioning or indexing for millions of records  
1,389
chris arndt
12/31/2013 11:34AM
best way to take backup for old partition and create new one?  
2,597
Aamir Sohail
12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?  
1,332
Rick James
12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?  
1,303
mi Su
12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?  
1,247
Rick James
12/13/2013 12:51AM
Am I doing this correctly?  
2,360
Jim Buckley Barrett
11/29/2013 05:03AM
Re: Am I doing this correctly?  
1,360
Jim Buckley Barrett
11/29/2013 06:22AM
Re: Am I doing this correctly?  
1,474
Rick James
11/30/2013 02:18PM
Re: Am I doing this correctly?  
1,273
mi Su
12/04/2013 12:38AM
Re: Am I doing this correctly?  
1,312
Jim Buckley Barrett
12/05/2013 03:48AM
Re: Am I doing this correctly?  
1,366
Rick James
12/05/2013 10:21AM
Re: Am I doing this correctly?  
1,302
Jim Buckley Barrett
12/10/2013 09:49AM
Re: Am I doing this correctly?  
1,341
Jim Buckley Barrett
12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table  
13,236
Aamir Sohail
11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table  
5,710
Rick James
11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table  
3,622
Aamir Sohail
11/29/2013 04:19AM
Partition data backup and restore  
8,704
Seungho Nam Nam
10/18/2013 12:48AM
Re: Partition data backup and restore  
3,991
Mattias Jonsson
10/18/2013 02:59AM
Re: Partition data backup and restore  
2,760
Steven Robinson
11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
2,321
mark silverman
09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,309
Rick James
09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning  
1,352
Mattias Jonsson
10/04/2013 01:02AM
Reorganize Partition Syntax error  
3,015
IGG t
09/16/2013 03:13AM
Re: Reorganize Partition Syntax error  
1,215
IGG t
09/16/2013 09:39AM
Re: Reorganize Partition Syntax error  
1,243
Rick James
09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?  
3,637
Prabhu Raja Singh
09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?  
2,148
Rick James
09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?  
1,890
Prabhu Raja Singh
09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness  
2,944
IGG t
08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness  
1,303
Rick James
08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness  
1,233
IGG t
08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness  
1,230
Rick James
08/31/2013 05:35PM
mysql tables in use 500, locked 500  
2,684
bruce.zuo bruce
07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500  
1,486
Rick James
07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500  
1,369
bruce.zuo bruce
07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500  
1,221
Mattias Jonsson
08/13/2013 05:42AM
Pages:
« 1 2 3 4 5
...
14 »

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.