Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Utilities 1.6.2 Beta has been released 08/31/2015 02:28PM
MySQL Enterprise Monitor 3.0.24 has been released 08/28/2015 01:07PM
MySQL Connector/NET 6.9.7 has been released 08/05/2015 06:38AM
MySQL Community Server 5.7.8 has been released (part 3/3) 08/03/2015 09:14AM
MySQL Community Server 5.7.8 has been released (part 2/3) 08/03/2015 09:12AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 13
Subject Views Written By Posted
Sticky:  MySQL 5.7: InnoDB Native Partitioning (1 Posts)   921 Edwin Desouza 10/02/2014 09:56AM
Sticky:  MySQL Partitioning: Articles, FAQs, Blogs (1 Posts)   16,311 Edwin DeSouza 05/23/2006 04:59PM
Does Mysql Date Partition can be created on date time for every day???   69 Akshath Hegde 08/23/2015 12:18AM
Re: Does Mysql Date Partition can be created on date time for every day???   23 Rick James 08/23/2015 05:55PM
Re: Does Mysql Date Partition can be created on date time for every day???   20 Akshath Hegde 08/26/2015 02:53AM
Re: Does Mysql Date Partition can be created on date time for every day???   15 Rick James 08/27/2015 07:40AM
No other way than delete primary key to create partitions by single datetime columns?   80 Sam Young 08/20/2015 08:00PM
Re: No other way than delete primary key to create partitions by single datetime columns?   26 Jonathan Stephens 08/21/2015 02:53AM
Re: No other way than delete primary key to create partitions by single datetime columns?   19 Sam Young 08/23/2015 08:57PM
Re: No other way than delete primary key to create partitions by single datetime columns?   22 Rick James 08/22/2015 03:35PM
Re: No other way than delete primary key to create partitions by single datetime columns?   20 Sam Young 08/23/2015 09:23PM
Re: No other way than delete primary key to create partitions by single datetime columns?   20 Rick James 08/24/2015 12:36PM
Re: No other way than delete primary key to create partitions by single datetime columns?   21 Sam Young 08/26/2015 12:53AM
Re: No other way than delete primary key to create partitions by single datetime columns?   19 Rick James 08/26/2015 10:02AM
Re: No other way than delete primary key to create partitions by single datetime columns?   15 Sam Young 08/26/2015 07:42PM
Dose MySQL support a dynamic pruning in mysql partitioning ?   93 jongse park 08/05/2015 08:41PM
Re: Dose MySQL support a dynamic pruning in mysql partitioning ?   31 Jonathan Stephens 08/06/2015 03:31AM
How to partition for performance   127 Doug Wolfgram 07/29/2015 09:42PM
Re: How to partition for performance   63 Rick James 07/31/2015 01:36PM
Re: How to partition for performance   63 Rick James 07/31/2015 02:23PM
Partition and Subpartition using Unixtime   153 Jaineera Naveen 07/09/2015 07:53AM
Re: Partition and Subpartition using Unixtime   70 Rick James 07/09/2015 11:59PM
Optimum partition for a bigger table   148 Jaineera Naveen 07/09/2015 12:35AM
Re: Optimum partition for a bigger table   75 Rick James 07/09/2015 11:36PM
Mysql 5.5 Partittioning row field   194 Shubham Jain 06/24/2015 10:19PM
Re: Mysql 5.5 Partittioning row field   86 Jonathan Stephens 06/25/2015 10:16AM
Re: Mysql 5.5 Partittioning row field   81 Rick James 06/26/2015 12:15AM
Re: Mysql 5.5 Partittioning row field   79 Jonathan Stephens 06/26/2015 02:40AM
Re: Mysql 5.5 Partittioning row field   71 Shubham Jain 06/26/2015 07:02AM
subpartiton by key doesn't evenly distribute data   217 jongse park 06/10/2015 11:20PM
Re: subpartiton by key doesn't evenly distribute data   91 Rick James 06/13/2015 08:25AM
Re: subpartiton by key doesn't evenly distribute data   90 jongse park 06/15/2015 12:01AM
Re: subpartiton by key doesn't evenly distribute data   85 Rick James 06/15/2015 07:07PM
Re: subpartiton by key doesn't evenly distribute data   95 jongse park 06/15/2015 10:41PM
Re: subpartiton by key doesn't evenly distribute data   87 Rick James 06/16/2015 07:36PM
Advice on partitioning   420 me su 04/24/2015 01:40PM
Re: Advice on partitioning   209 Rick James 04/24/2015 05:34PM
Re: Advice on partitioning   187 Mehdi Salarkia 04/27/2015 09:05AM
Re: Advice on partitioning   181 Rick James 04/27/2015 02:22PM
Re: Advice on partitioning   141 Drew Morris 04/28/2015 11:02AM
Re: Advice on partitioning   149 Rick James 04/28/2015 12:32PM
Re: Advice on partitioning   141 Mehdi Salarkia 04/28/2015 04:07PM
Re: Advice on partitioning   89 Mehdi Salarkia 06/15/2015 06:39PM
Re: Advice on partitioning   89 Rick James 06/15/2015 07:05PM
Re: Advice on partitioning   80 Mehdi Salarkia 06/16/2015 06:40PM
Partition by range for float data type column float(12,9) in mysql server 5.6   334 esha sethi 05/15/2015 11:49PM
Re: Partition by range for float data type column float(12,9) in mysql server 5.6   122 Rick James 05/17/2015 12:04AM
Select using partition dynamically   294 Jose Lima 05/07/2015 06:21PM
Re: Select using partition dynamically   118 Rick James 05/11/2015 12:53PM
Partitioning & Replication   355 Robert Gunther 04/09/2015 06:30PM
Re: Partitioning & Replication   149 Rick James 04/12/2015 09:43PM
how to speed up for List partitioning table   548 jongse park 12/28/2014 07:59PM
Re: how to speed up for List partitioning table   262 Rick James 12/30/2014 03:05PM
wrong output generate while using partitions   649 Shivam Patel 12/13/2014 07:56AM
Re: wrong output generate while using partitions   314 Rick James 12/14/2014 10:33PM
Re: wrong output generate while using partitions   304 Shivam Patel 12/16/2014 01:24AM
Re: wrong output generate while using partitions   304 Jonathan Stephens 12/16/2014 02:32AM
Re: wrong output generate while using partitions   311 Shivam Patel 12/16/2014 04:00AM
Re: wrong output generate while using partitions   281 Rick James 12/16/2014 04:28PM
Re: wrong output generate while using partitions   311 Shivam Patel 12/17/2014 07:20AM
Re: wrong output generate while using partitions   300 Rick James 12/17/2014 11:27AM
large InnoDB table partitioning without explicit PK   941 Miko M 11/12/2014 07:41PM
Re: large InnoDB table partitioning without explicit PK   449 Rick James 11/13/2014 06:40PM
Re: large InnoDB table partitioning without explicit PK   386 Miko M 11/14/2014 03:02AM
Re: large InnoDB table partitioning without explicit PK   326 Rick James 11/15/2014 12:05AM
Re: large InnoDB table partitioning without explicit PK   340 Miko M 11/16/2014 07:39PM
Re: large InnoDB table partitioning without explicit PK   269 Rick James 11/17/2014 04:21PM
Re: large InnoDB table partitioning without explicit PK   281 Rick James 11/17/2014 07:48PM
Re: large InnoDB table partitioning without explicit PK   306 Miko M 11/18/2014 02:00AM
Re: large InnoDB table partitioning without explicit PK   355 Rick James 11/18/2014 11:35PM
Re: large InnoDB table partitioning without explicit PK   331 Miko M 11/22/2014 06:44AM
Re: large InnoDB table partitioning without explicit PK   293 Miko M 11/18/2014 01:13AM
(non-unique) index more efficient than partition pruning   375 Miko M 11/19/2014 12:27AM
Re: (non-unique) index more efficient than partition pruning   387 Rick James 11/19/2014 06:01PM
Re: (non-unique) index more efficient than partition pruning   335 Miko M 11/22/2014 08:39AM
Re: large InnoDB table partitioning without explicit PK   321 Miko M 11/14/2014 03:04AM
Re: large InnoDB table partitioning without explicit PK   304 Miko M 11/14/2014 03:05AM
Re: large InnoDB table partitioning without explicit PK   313 Rick James 11/15/2014 12:32AM
Re: large InnoDB table partitioning without explicit PK   340 Miko M 11/16/2014 08:31PM
Re: large InnoDB table partitioning without explicit PK   314 Rick James 11/19/2014 12:12AM
Re: large InnoDB table partitioning without explicit PK   329 Miko M 11/22/2014 09:07AM
Re: large InnoDB table partitioning without explicit PK   284 Rick James 11/23/2014 09:00PM
Re: large InnoDB table partitioning without explicit PK   283 Miko M 12/01/2014 11:16AM
Online Partition addition use "add partition" clause or "reorganize" clause?   831 Tom Song 10/21/2014 03:53AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   397 Tom Song 10/22/2014 11:58PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   348 Rick James 10/23/2014 04:36PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   394 Tom Song 10/24/2014 02:05AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?   295 Mikael Ronström 11/13/2014 06:54AM
Partitioning on account_id   894 Ketil Stadskleiv 10/13/2014 02:54PM
Re: Partitioning on account_id   456 Rick James 10/14/2014 06:04PM
Range partition and unique key   768 Pierrick VODOZ 09/24/2014 08:42AM
Re: Range partition and unique key   367 Rick James 09/25/2014 09:59AM
Re: Range partition and unique key   365 Pierrick VODOZ 09/26/2014 03:40AM
Re: Range partition and unique key   393 Rick James 09/27/2014 08:25AM
Horizontal partitioning on a per user basis?   725 Peter Sarkozi 09/18/2014 05:40PM
Re: Horizontal partitioning on a per user basis?   399 Luke Taylor 09/19/2014 01:12AM
Re: Horizontal partitioning on a per user basis?   402 Rick James 09/19/2014 11:18PM
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   1,151 Raghavendra K 08/22/2014 12:37AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   491 Rick James 08/24/2014 09:14PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   478 Raghavendra K 08/25/2014 11:38AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   429 Rick James 08/26/2014 02:31PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   384 Raghavendra K 08/30/2014 03:43AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)   415 Rick James 09/01/2014 08:28PM
Not Taking Paritioning when using Subquery or Join   834 Marc Vettorel 08/27/2014 07:08AM
Re: Not Taking Paritioning when using Subquery or Join   426 Marc Vettorel 08/27/2014 07:19AM
Re: Not Taking Paritioning when using Subquery or Join   411 Rick James 08/28/2014 10:19AM
EXCHANGE PARTITION and DATA DIRECTORY errors   899 Ekundayo Lasode 08/16/2014 09:47AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors   412 Mattias Jonsson 08/19/2014 03:32AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors   408 Ekundayo Lasode 08/19/2014 06:28AM
Storing time series data using partitioning   1,009 Florian Rampp 08/14/2014 05:45AM
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"   815 Jon Jacob 07/20/2014 07:50AM
Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"   449 Rick James 07/21/2014 06:50PM
Range partitioning on floor (decimal(14.4)) doesn't work :/   854 Max Herman 07/12/2014 12:35PM
Re: Range partitioning on floor (decimal(14.4)) doesn't work :/   443 Rick James 07/14/2014 06:45PM
why explain partition shows first partition in every select query?   977 Aamir Sohail 05/27/2014 07:18AM
Re: why explain partition shows first partition in every select query?   502 Rick James 05/27/2014 03:10PM
Re: why explain partition shows first partition in every select query?   471 Aamir Sohail 05/28/2014 12:52AM
Storing, accessing and configuring my partitions in diferent servers   816 Victor Bombella 05/23/2014 11:54PM
Re: Storing, accessing and configuring my partitions in diferent servers   447 Rick James 05/25/2014 04:57PM
missing data after partitioning - bug?   907 rol and 05/23/2014 12:51PM
Re: missing data after partitioning - bug?   471 Rick James 05/25/2014 04:27PM
MySql Partitioning problem (bug?)   5,470 K T 05/07/2014 04:39PM
Re: MySql Partitioning problem (bug?)   540 Rick James 05/09/2014 11:59PM
Re: MySql Partitioning problem (bug?)   520 K T 05/10/2014 03:41PM
Re: MySql Partitioning problem (bug?)   494 K T 05/10/2014 03:44PM
Re: MySql Partitioning problem (bug?)   510 Mattias Jonsson 05/16/2014 06:15AM
MySQL partition by range on YEAR(date) weird results   1,189 Adelin Feraru 05/12/2014 02:15AM
Re: MySQL partition by range on YEAR(date) weird results   534 Rick James 05/15/2014 12:01AM
Re: MySQL partition by range on YEAR(date) weird results   481 Adelin Feraru 05/15/2014 03:38AM
Re: MySQL partition by range on YEAR(date) weird results   492 Mattias Jonsson 05/15/2014 11:42AM
Storing tables on multiple partitions   982 sdgbfdsg fdhgfdhds 04/09/2014 08:04AM
Re: Storing tables on multiple partitions   508 Rick James 04/11/2014 04:32PM
Re: Storing tables on multiple partitions   552 mi Su 04/29/2014 01:09AM
MySql Horizontal partitioning - Pros-Cons   1,740 Manohar K 04/14/2014 11:43AM
Re: MySql Horizontal partitioning - Pros-Cons   759 Rick James 04/17/2014 11:16PM
Re: MySql Horizontal partitioning - Pros-Cons   583 Rick James 04/19/2014 03:42PM
Consumption of more hard disk space in "Copying to tmp table" phase   1,555 Raghavendra K 04/14/2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   515 Mattias Jonsson 04/14/2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   499 Raghavendra K 04/16/2014 06:40AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   486 Mattias Jonsson 04/17/2014 12:55PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase   461 Rick James 04/17/2014 11:36PM
Failed to read from the .par file   2,185 IGG t 04/02/2014 09:49AM
Re: Failed to read from the .par file   1,084 Rick James 04/05/2014 01:13PM
How to extend partition when there is no unallocated space in hard disk?   1,047 mi Su 01/06/2014 01:21AM
Re: How to extend partition when there is no unallocated space in hard disk?   759 Rick James 01/08/2014 05:22PM
Partitioning or indexing for millions of records   1,488 Aamir Sohail 11/26/2013 05:44AM
Re: Partitioning or indexing for millions of records   1,123 Rick James 11/27/2013 12:39PM
Re: Partitioning or indexing for millions of records   855 Aamir Sohail 11/28/2013 12:40AM
Re: Partitioning or indexing for millions of records   856 Rick James 11/28/2013 09:07PM
Re: Partitioning or indexing for millions of records   795 Aamir Sohail 11/29/2013 04:11AM
Re: Partitioning or indexing for millions of records   796 Rick James 11/30/2013 01:30PM
Re: Partitioning or indexing for millions of records   683 chris arndt 12/31/2013 11:34AM
best way to take backup for old partition and create new one?   1,243 Aamir Sohail 12/04/2013 05:57AM
Re: best way to take backup for old partition and create new one?   681 Rick James 12/05/2013 12:15PM
Re: best way to take backup for old partition and create new one?   621 mi Su 12/10/2013 11:46PM
Re: best way to take backup for old partition and create new one?   615 Rick James 12/13/2013 12:51AM
Am I doing this correctly?   1,251 Jim Buckley Barrett 11/29/2013 05:03AM
Re: Am I doing this correctly?   705 Jim Buckley Barrett 11/29/2013 06:22AM
Re: Am I doing this correctly?   733 Rick James 11/30/2013 02:18PM
Re: Am I doing this correctly?   663 mi Su 12/04/2013 12:38AM
Re: Am I doing this correctly?   718 Jim Buckley Barrett 12/05/2013 03:48AM
Re: Am I doing this correctly?   666 Rick James 12/05/2013 10:21AM
Re: Am I doing this correctly?   670 Jim Buckley Barrett 12/10/2013 09:49AM
Re: Am I doing this correctly?   736 Jim Buckley Barrett 12/05/2013 03:51AM
error 1503: A primary key must include all columns in the table   2,250 Aamir Sohail 11/28/2013 01:28AM
Re: error 1503: A primary key must include all columns in the table   1,085 Rick James 11/29/2013 01:15AM
Re: error 1503: A primary key must include all columns in the table   845 Aamir Sohail 11/29/2013 04:19AM
Partition data backup and restore   2,446 Seungho Nam Nam 10/18/2013 12:48AM
Re: Partition data backup and restore   1,223 Mattias Jonsson 10/18/2013 02:59AM
Re: Partition data backup and restore   978 Steven Robinson 11/07/2013 11:29PM
Changing 5.1.61 Enterprise Commerical Build to allow partitioning   1,145 mark silverman 09/19/2013 08:11AM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   666 Rick James 09/24/2013 08:51PM
Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning   725 Mattias Jonsson 10/04/2013 01:02AM
Reorganize Partition Syntax error   1,562 IGG t 09/16/2013 03:13AM
Re: Reorganize Partition Syntax error   702 IGG t 09/16/2013 09:39AM
Re: Reorganize Partition Syntax error   663 Rick James 09/17/2013 07:19PM
How to do partition for 100GB MySQL existing Table in zero downtime?   1,793 Prabhu Raja Singh 09/13/2013 01:40AM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   1,074 Rick James 09/15/2013 09:33PM
Re: How to do partition for 100GB MySQL existing Table in zero downtime?   1,029 Prabhu Raja Singh 09/16/2013 03:26AM
Partitioning by date, and maintaining uniqueness   1,632 IGG t 08/13/2013 09:51AM
Re: Partitioning by date, and maintaining uniqueness   839 Rick James 08/14/2013 09:20AM
Re: Partitioning by date, and maintaining uniqueness   797 IGG t 08/14/2013 10:28AM
Re: Partitioning by date, and maintaining uniqueness   808 Rick James 08/31/2013 05:35PM
mysql tables in use 500, locked 500   1,538 bruce.zuo bruce 07/16/2013 03:14AM
Re: mysql tables in use 500, locked 500   878 Rick James 07/21/2013 12:26AM
Re: mysql tables in use 500, locked 500   791 bruce.zuo bruce 07/24/2013 07:12AM
Re: mysql tables in use 500, locked 500   744 Mattias Jonsson 08/13/2013 05:42AM
Create index on partition table (manually and dynamically)   3,034 Vladimir Pivovar 07/05/2013 11:26PM
Re: Create index on parttion table (manually and dynamically)   1,191 Rick James 07/06/2013 10:52PM
Re: Create index on parttion table (manually and dynamically)   1,077 Vladimir Pivovar 07/07/2013 12:20AM
Re: Create index on parttion table (manually and dynamically)   1,028 Vladimir Pivovar 07/07/2013 10:57AM
Re: Create index on parttion table (manually and dynamically)   1,092 Rick James 07/08/2013 09:46AM
Re: Create index on partition table (manually and dynamically)   1,122 Vladimir Pivovar 07/10/2013 02:23PM
how to remove partitiong in mysql version5.6   1,424 heiansan white 06/13/2013 01:41AM
Re: how to remove partitiong in mysql version5.6   820 Rick James 06/15/2013 01:50PM
No. of partitions in NDB cluster   1,291 Alax James 05/31/2013 02:14AM
IP vs Date Partition   1,567 Tim Linden 05/13/2013 10:28AM
Re: IP vs Date Partition   1,200 Rick James 05/14/2013 09:59PM
Re: IP vs Date Partition   1,145 Tim Linden 05/15/2013 10:06AM
How should I partition this table?   1,970 Ron Bergin 04/26/2013 09:18AM
Re: How should I partition this table?   1,092 Rick James 04/27/2013 09:58PM
Re: How should I partition this table?   1,005 Ron Bergin 04/28/2013 11:29AM
Re: How should I partition this table?   982 Rick James 04/29/2013 08:10AM
Re: How should I partition this table?   959 Ron Bergin 04/30/2013 08:39AM
Re: How should I partition this table?   984 Rick James 05/01/2013 11:45PM
Re: How should I partition this table?   976 Ron Bergin 05/02/2013 08:17AM
Re: How should I partition this table?   889 Ron Bergin 05/02/2013 11:55AM
Re: How should I partition this table?   950 Rick James 05/03/2013 09:00AM
Re: How should I partition this table?   948 Ron Bergin 05/03/2013 09:32AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 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.