Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Workbench 6.3.3 GA has been released 04/24/2015 08:36AM
MySQL Connector/Python 2.0.4 GA has been released 04/22/2015 02:03AM
MySQL Cluster 7.3.9 has been released 04/15/2015 11:11PM
MySQL Cluster Manager 1.3.5 has been released 04/15/2015 10:42AM
MySQL Cluster 7.4.6 has been released 04/14/2015 07:07AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 12
Subject Views Written By Posted
Sticky:  MySQL 5.7: InnoDB Native Partitioning (1 Posts)   616 Edwin Desouza 10/02/2014 09:56AM
Sticky:  MySQL Partitioning: Articles, FAQs, Blogs (1 Posts)   15,967 Edwin DeSouza 05/23/2006 04:59PM
Advice on partitioning   51 me su 04/24/2015 01:40PM
Re: Advice on partitioning   15 Rick James 04/24/2015 05:34PM
Re: Advice on partitioning   16 Mehdi Salarkia 04/27/2015 09:05AM
Re: Advice on partitioning   3 Rick James 04/27/2015 02:22PM
Partitioning & Replication   104 Robert Gunther 04/09/2015 06:30PM
Re: Partitioning & Replication   31 Rick James 04/12/2015 09:43PM
how to speed up for List partitioning table   310 jongse park 12/28/2014 07:59PM
Re: how to speed up for List partitioning table   139 Rick James 12/30/2014 03:05PM
wrong output generate while using partitions   383 Shivam Patel 12/13/2014 07:56AM
Re: wrong output generate while using partitions   183 Rick James 12/14/2014 10:33PM
Re: wrong output generate while using partitions   168 Shivam Patel 12/16/2014 01:24AM
Re: wrong output generate while using partitions   168 Jonathan Stephens 12/16/2014 02:32AM
Re: wrong output generate while using partitions   173 Shivam Patel 12/16/2014 04:00AM
Re: wrong output generate while using partitions   154 Rick James 12/16/2014 04:28PM
Re: wrong output generate while using partitions   169 Shivam Patel 12/17/2014 07:20AM
Re: wrong output generate while using partitions   171 Rick James 12/17/2014 11:27AM
large InnoDB table partitioning without explicit PK   593 Miko M 11/12/2014 07:41PM
Re: large InnoDB table partitioning without explicit PK   271 Rick James 11/13/2014 06:40PM
Re: large InnoDB table partitioning without explicit PK   214 Miko M 11/14/2014 03:02AM
Re: large InnoDB table partitioning without explicit PK   194 Rick James 11/15/2014 12:05AM
Re: large InnoDB table partitioning without explicit PK   217 Miko M 11/16/2014 07:39PM
Re: large InnoDB table partitioning without explicit PK   150 Rick James 11/17/2014 04:21PM
Re: large InnoDB table partitioning without explicit PK   149 Rick James 11/17/2014 07:48PM
Re: large InnoDB table partitioning without explicit PK   172 Miko M 11/18/2014 02:00AM
Re: large InnoDB table partitioning without explicit PK   213 Rick James 11/18/2014 11:35PM
Re: large InnoDB table partitioning without explicit PK   191 Miko M 11/22/2014 06:44AM
Re: large InnoDB table partitioning without explicit PK   169 Miko M 11/18/2014 01:13AM
(non-unique) index more efficient than partition pruning   233 Miko M 11/19/2014 12:27AM
Re: (non-unique) index more efficient than partition pruning   232 Rick James 11/19/2014 06:01PM
Re: (non-unique) index more efficient than partition pruning   200 Miko M 11/22/2014 08:39AM
Re: large InnoDB table partitioning without explicit PK   175 Miko M 11/14/2014 03:04AM
Re: large InnoDB table partitioning without explicit PK   162 Miko M 11/14/2014 03:05AM
Re: large InnoDB table partitioning without explicit PK   175 Rick James 11/15/2014 12:32AM
Re: large InnoDB table partitioning without explicit PK   198 Miko M 11/16/2014 08:31PM
Re: large InnoDB table partitioning without explicit PK   197 Rick James 11/19/2014 12:12AM
Re: large InnoDB table partitioning without explicit PK   185 Miko M 11/22/2014 09:07AM
Re: large InnoDB table partitioning without explicit PK   167 Rick James 11/23/2014 09:00PM
Re: large InnoDB table partitioning without explicit PK   159 Miko M 12/01/2014 11:16AM
Online Partition addition use "add partition" clause or "reorganize" clause?   571 Tom Song 10/21/2014 03:53AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   252 Tom Song 10/22/2014 11:58PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   234 Rick James 10/23/2014 04:36PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   268 Tom Song 10/24/2014 02:05AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   169 Mikael Ronström 11/13/2014 06:54AM
Partitioning on account_id   579 Ketil Stadskleiv 10/13/2014 02:54PM
Re: Partitioning on account_id   323 Rick James 10/14/2014 06:04PM
Range partition and unique key   551 Pierrick VODOZ 09/24/2014 08:42AM
Re: Range partition and unique key   252 Rick James 09/25/2014 09:59AM
Re: Range partition and unique key   237 Pierrick VODOZ 09/26/2014 03:40AM
Re: Range partition and unique key   256 Rick James 09/27/2014 08:25AM
Horizontal partitioning on a per user basis?   508 Peter Sarkozi 09/18/2014 05:40PM
Re: Horizontal partitioning on a per user basis?   284 Luke Taylor 09/19/2014 01:12AM
Re: Horizontal partitioning on a per user basis?   281 Rick James 09/19/2014 11:18PM
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   810 Raghavendra K 08/22/2014 12:37AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   347 Rick James 08/24/2014 09:14PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   342 Raghavendra K 08/25/2014 11:38AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   287 Rick James 08/26/2014 02:31PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   262 Raghavendra K 08/30/2014 03:43AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   279 Rick James 09/01/2014 08:28PM
Not Taking Paritioning when using Subquery or Join   596 Marc Vettorel 08/27/2014 07:08AM
Re: Not Taking Paritioning when using Subquery or Join   296 Marc Vettorel 08/27/2014 07:19AM
Re: Not Taking Paritioning when using Subquery or Join   302 Rick James 08/28/2014 10:19AM
EXCHANGE PARTITION and DATA DIRECTORY errors   636 Ekundayo Lasode 08/16/2014 09:47AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors   276 Mattias Jonsson 08/19/2014 03:32AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors   284 Ekundayo Lasode 08/19/2014 06:28AM
Storing time series data using partitioning   635 Florian Rampp 08/14/2014 05:45AM
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"   592 Jon Jacob 07/20/2014 07:50AM
Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"   321 Rick James 07/21/2014 06:50PM
Range partitioning on floor (decimal(14.4)) doesn't work :/   657 Max Herman 07/12/2014 12:35PM
Re: Range partitioning on floor (decimal(14.4)) doesn't work :/   323 Rick James 07/14/2014 06:45PM
why explain partition shows first partition in every select query?   766 Aamir Sohail 05/27/2014 07:18AM
Re: why explain partition shows first partition in every select query?   370 Rick James 05/27/2014 03:10PM
Re: why explain partition shows first partition in every select query?   355 Aamir Sohail 05/28/2014 12:52AM
Storing, accessing and configuring my partitions in diferent servers   618 Victor Bombella 05/23/2014 11:54PM
Re: Storing, accessing and configuring my partitions in diferent servers   339 Rick James 05/25/2014 04:57PM
missing data after partitioning - bug?   679 rol and 05/23/2014 12:51PM
Re: missing data after partitioning - bug?   332 Rick James 05/25/2014 04:27PM
MySql Partitioning problem (bug?)   5,251 K T 05/07/2014 04:39PM
Re: MySql Partitioning problem (bug?)   403 Rick James 05/09/2014 11:59PM
Re: MySql Partitioning problem (bug?)   381 K T 05/10/2014 03:41PM
Re: MySql Partitioning problem (bug?)   364 K T 05/10/2014 03:44PM
Re: MySql Partitioning problem (bug?)   391 Mattias Jonsson 05/16/2014 06:15AM
MySQL partition by range on YEAR(date) weird results   915 Adelin Feraru 05/12/2014 02:15AM
Re: MySQL partition by range on YEAR(date) weird results   408 Rick James 05/15/2014 12:01AM
Re: MySQL partition by range on YEAR(date) weird results   371 Adelin Feraru 05/15/2014 03:38AM
Re: MySQL partition by range on YEAR(date) weird results   363 Mattias Jonsson 05/15/2014 11:42AM
Storing tables on multiple partitions   759 sdgbfdsg fdhgfdhds 04/09/2014 08:04AM
Re: Storing tables on multiple partitions   391 Rick James 04/11/2014 04:32PM
Re: Storing tables on multiple partitions   416 mi Su 04/29/2014 01:09AM
MySql Horizontal partitioning - Pros-Cons   1,346 Manohar K 04/14/2014 11:43AM
Re: MySql Horizontal partitioning - Pros-Cons   545 Rick James 04/17/2014 11:16PM
Re: MySql Horizontal partitioning - Pros-Cons   466 Rick James 04/19/2014 03:42PM
Consumption of more hard disk space in "Copying to tmp table" phase   1,227 Raghavendra K 04/14/2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   396 Mattias Jonsson 04/14/2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   386 Raghavendra K 04/16/2014 06:40AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   374 Mattias Jonsson 04/17/2014 12:55PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   351 Rick James 04/17/2014 11:36PM
Failed to read from the .par file   1,599 IGG t 04/02/2014 09:49AM
Re: Failed to read from the .par file   759 Rick James 04/05/2014 01:13PM
How to extend partition when there is no unallocated space in hard disk?   852 mi Su 01/06/2014 01:21AM
Re: How to extend partition when there is no unallocated space in hard disk?   625 Rick James 01/08/2014 05:22PM
Partitioning or indexing for millions of records   1,253 Aamir Sohail 11/26/2013 05:44AM
Re: Partitioning or indexing for millions of records   986 Rick James 11/27/2013 12:39PM
Re: Partitioning or indexing for millions of records   735 Aamir Sohail 11/28/2013 12:40AM
Re: Partitioning or indexing for millions of records   724 Rick James 11/28/2013 09:07PM
Re: Partitioning or indexing for millions of records   668 Aamir Sohail 11/29/2013 04:11AM
Re: Partitioning or indexing for millions of records   667 Rick James 11/30/2013 01:30PM
Re: Partitioning or indexing for millions of records   559 chris arndt 12/31/2013 11:34AM
best way to take backup for old partition and create new one?   1,008 Aamir Sohail 12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?   568 Rick James 12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?   508 mi Su 12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?   500 Rick James 12/13/2013 12:51AM
Am I doing this correctly?   1,048 Jim Buckley Barrett 11/29/2013 05:03AM
Re: Am I doing this correctly?   577 Jim Buckley Barrett 11/29/2013 06:22AM
Re: Am I doing this correctly?   607 Rick James 11/30/2013 02:18PM
Re: Am I doing this correctly?   531 mi Su 12/04/2013 12:38AM
Re: Am I doing this correctly?   583 Jim Buckley Barrett 12/05/2013 03:48AM
Re: Am I doing this correctly?   558 Rick James 12/05/2013 10:21AM
Re: Am I doing this correctly?   538 Jim Buckley Barrett 12/10/2013 09:49AM
Re: Am I doing this correctly?   589 Jim Buckley Barrett 12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table   1,764 Aamir Sohail 11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table   855 Rick James 11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table   667 Aamir Sohail 11/29/2013 04:19AM
Partition data backup and restore   1,993 Seungho Nam Nam 10/18/2013 12:48AM
Re: Partition data backup and restore   997 Mattias Jonsson 10/18/2013 02:59AM
Re: Partition data backup and restore   808 Steven Robinson 11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning   956 mark silverman 09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   557 Rick James 09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   600 Mattias Jonsson 10/04/2013 01:02AM
Reorganize Partition Syntax error   1,293 IGG t 09/16/2013 03:13AM
Re: Reorganize Partition Syntax error   595 IGG t 09/16/2013 09:39AM
Re: Reorganize Partition Syntax error   545 Rick James 09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?   1,548 Prabhu Raja Singh 09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   925 Rick James 09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   883 Prabhu Raja Singh 09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness   1,399 IGG t 08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness   722 Rick James 08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness   685 IGG t 08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness   689 Rick James 08/31/2013 05:35PM
mysql tables in use 500, locked 500   1,334 bruce.zuo bruce 07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500   759 Rick James 07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500   665 bruce.zuo bruce 07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500   630 Mattias Jonsson 08/13/2013 05:42AM
Create index on partition table (manually and dynamically)   2,601 Vladimir Pivovar 07/05/2013 11:26PM
Re: Create index on parttion table (manually and dynamically)   1,016 Rick James 07/06/2013 10:52PM
Re: Create index on parttion table (manually and dynamically)   916 Vladimir Pivovar 07/07/2013 12:20AM
Re: Create index on parttion table (manually and dynamically)   871 Vladimir Pivovar 07/07/2013 10:57AM
Re: Create index on parttion table (manually and dynamically)   924 Rick James 07/08/2013 09:46AM
Re: Create index on partition table (manually and dynamically)   963 Vladimir Pivovar 07/10/2013 02:23PM
how to remove partitiong in mysql version5.6   1,214 heiansan white 06/13/2013 01:41AM
Re: how to remove partitiong in mysql version5.6   702 Rick James 06/15/2013 01:50PM
No. of partitions in NDB cluster   1,117 Alax James 05/31/2013 02:14AM
IP vs Date Partition   1,324 Tim Linden 05/13/2013 10:28AM
Re: IP vs Date Partition   1,003 Rick James 05/14/2013 09:59PM
Re: IP vs Date Partition   1,023 Tim Linden 05/15/2013 10:06AM
How should I partition this table?   1,724 Ron Bergin 04/26/2013 09:18AM
Re: How should I partition this table?   947 Rick James 04/27/2013 09:58PM
Re: How should I partition this table?   874 Ron Bergin 04/28/2013 11:29AM
Re: How should I partition this table?   838 Rick James 04/29/2013 08:10AM
Re: How should I partition this table?   838 Ron Bergin 04/30/2013 08:39AM
Re: How should I partition this table?   847 Rick James 05/01/2013 11:45PM
Re: How should I partition this table?   853 Ron Bergin 05/02/2013 08:17AM
Re: How should I partition this table?   780 Ron Bergin 05/02/2013 11:55AM
Re: How should I partition this table?   821 Rick James 05/03/2013 09:00AM
Re: How should I partition this table?   810 Ron Bergin 05/03/2013 09:32AM
Performance doubt   1,368 Xavier Borrut 03/26/2013 06:41AM
Re: Performance doubt   814 Rick James 03/28/2013 12:34AM
Re: Performance doubt   440 Mattias Jonsson 04/09/2013 01:49AM
Event add partition works but not the drop partition   1,390 Frwa Onto 04/04/2013 11:22PM
Re: Event add partition works but not the drop partition   733 Frwa Onto 04/05/2013 04:13AM
Should I partition?   1,513 Jacob Steinberger 03/19/2013 02:57PM
Re: Should I partition?   918 Rick James 03/21/2013 08:49PM
Re: Should I partition?   841 NOT_FOUND NOT_FOUND 04/03/2013 10:08AM
Re: Should I partition?   767 Rick James 04/04/2013 11:35PM
Partitioned table problem after upgrade to 5.5   1,607 Ming Wang 03/06/2013 04:07AM
Re: Partitioned table problem after upgrade to 5.5   819 Mattias Jonsson 03/06/2013 04:38AM
Re: Partitioned table problem after upgrade to 5.5   795 Ming Wang 03/07/2013 08:23PM
Re: Partitioned table problem after upgrade to 5.5   735 Rick James 03/07/2013 11:32PM
Re: Partitioned table problem after upgrade to 5.5   793 Mattias Jonsson 03/08/2013 02:20AM
If you use a partition table in mysql5.5, Contact function   1,310 kyung gi lee 02/25/2013 03:12AM
Re: If you use a partition table in mysql5.5, Contact function   781 Rick James 02/28/2013 09:34AM
How to (temporary) disable one partition in the partitioned table   1,512 First Bell 02/13/2013 11:01PM
Re: How to (temporary) disable one partition in the partitioned table   884 Rick James 02/22/2013 01:00AM
Re: How to (temporary) disable one partition in the partitioned table   994 Mattias Jonsson 02/28/2013 05:51AM
Index with partitioning   1,681 Hélio Hélio 01/30/2013 06:23AM
Re: Index with partitioning   1,062 Rick James 02/01/2013 10:20PM
Re: Index with partitioning   1,048 Hélio Hélio 02/04/2013 08:03AM
Re: Index with partitioning   1,012 Rick James 02/07/2013 10:09PM
Re: Index with partitioning   1,038 Hélio Hélio 02/08/2013 06:55AM
Re: Index with partitioning   954 Rick James 02/09/2013 01:22PM
Re: Index with partitioning   1,159 Hélio Hélio 02/14/2013 12:26PM
MySQL Partitioning showing low performance   1,478 Manosh Manohar 02/05/2013 12:10AM
Re: MySQL Partitioning showing low performance   917 Rick James 02/07/2013 10:14PM
Re: MySQL Partitioning showing low performance   851 Manosh Manohar 02/08/2013 12:39AM
How to let the query run on one partition   1,695 Shawn Liu 01/09/2013 08:29AM
Re: How to let the query run on one partition   869 Rick James 01/10/2013 08:45PM
How to partition by City \ State   1,492 Noah Goodrich 12/19/2012 10:06PM
Re: How to partition by City \ State   907 Rick James 12/20/2012 10:00PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 12

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.