Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Community Server 5.5.39 has been released 08/01/2014 01:43AM
MySQL Utilities 1.4.4 GA has been released 07/31/2014 09:12PM
MySQL Connector/C++ 1.1.4 has been released 07/31/2014 02:41PM
MySQL Connector/Python 2.0.0 Alpha has been released 07/24/2014 11:56AM
MySQL Connector/NET 6.9.2 RC has been released 07/18/2014 07:41PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 12
Subject Views Written By Posted
Prunning partitions with range by date   1,336 Diogo Domanski 09/27/2012 01:18PM
Re: Prunning partitions with range by date   817 Aftab Khan 09/27/2012 01:39PM
Re: Prunning partitions with range by date (SOLVED)   758 Diogo Domanski 09/27/2012 03:00PM
What Method is Best   1,290 Larry Adams 09/12/2012 03:12PM
Re: What Method is Best   856 Mattias Jonsson 09/14/2012 02:36AM
Re: What Method is Best   787 Larry Adams 09/14/2012 05:30AM
Re: What Method is Best   730 Rick James 09/14/2012 11:11PM
timestamp, datetime as default value as current_timestamp [PARTITION]   1,765 Mannoj Kumar 08/29/2012 01:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,000 Aftab Khan 08/29/2012 04:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   849 Mattias Jonsson 08/31/2012 06:00PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   723 Aftab Khan 09/03/2012 03:19AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,196 Mannoj Kumar 08/29/2012 04:32AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   852 Aftab Khan 08/29/2012 09:16AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   807 Mannoj Kumar 09/03/2012 11:26PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   967 Rick James 09/04/2012 08:05PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   942 Mannoj Kumar 09/07/2012 05:49AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   802 Rick James 08/30/2012 10:35PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   777 Aftab Khan 08/31/2012 02:04AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   875 Rick James 08/31/2012 09:52AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   752 Mattias Jonsson 09/05/2012 12:36AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   802 Rick James 09/05/2012 08:29AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   879 Aftab Khan 08/31/2012 01:58AM
Modify primary key for partitioning   1,406 Aurelien PANIZZA 08/10/2012 10:29AM
Re: Modify primary key for partitioning   876 Rick James 08/18/2012 09:39PM
Re: Modify primary key for partitioning   955 Aurelien PANIZZA 08/20/2012 06:33AM
Re: Modify primary key for partitioning   875 Aftab Khan 08/22/2012 10:16AM
Re: Modify primary key for partitioning   801 Aurelien PANIZZA 08/28/2012 10:14AM
Re: Modify primary key for partitioning   772 Rick James 08/30/2012 10:26PM
Re: Modify primary key for partitioning   983 Aurelien PANIZZA 08/31/2012 03:05AM
Re: Modify primary key for partitioning   772 Aftab Khan 08/31/2012 03:38AM
Re: Modify primary key for partitioning   739 Aurelien PANIZZA 08/31/2012 06:48AM
Re: Modify primary key for partitioning   793 Rick James 08/31/2012 09:39AM
Re: Modify primary key for partitioning   748 Aurelien PANIZZA 09/04/2012 01:02AM
Re: Modify primary key for partitioning   813 Rick James 08/23/2012 09:16AM
Re: Modify primary key for partitioning   835 Aftab Khan 08/23/2012 10:42AM
particular field type not allowed to this type of partitioning   2,490 Dhileepan M 08/23/2012 11:24PM
Re: particular field type not allowed to this type of partitioning   902 Mattias Jonsson 08/24/2012 04:15AM
Re: particular field type not allowed to this type of partitioning   1,199 Aftab Khan 08/24/2012 01:59AM
Re: particular field type not allowed to this type of partitioning   873 Dhileepan M 08/24/2012 03:46AM
Simply MySQL Partition on One Column (groupID)   1,234 Andrew Barlow 08/20/2012 07:43AM
Re: Simply MySQL Partition on One Column (groupID)   785 Aftab Khan 08/22/2012 09:46AM
Re: Simply MySQL Partition on One Column (groupID)   838 Rick James 08/21/2012 08:44AM
range columns including datetime column   1,333 Rob Voyer 08/15/2012 10:01PM
Re: range columns including datetime column   799 Mattias Jonsson 08/16/2012 02:42AM
Re: range columns including datetime column   759 Rob Voyer 08/16/2012 07:15AM
Re: range columns including datetime column   733 Mattias Jonsson 08/16/2012 09:35AM
Re: range columns including datetime column   713 Rob Voyer 08/16/2012 09:54AM
Re: range columns including datetime column   795 Rick James 08/19/2012 10:55PM
Re: range columns including datetime column   749 Mattias Jonsson 08/20/2012 03:21AM
Partition   1,473 Dhileepan M 08/10/2012 12:37AM
Re: Partition   1,000 Jonathan Stephens 08/11/2012 03:37AM
Re: Partition   902 Rick James 08/19/2012 03:18PM
Add new partition for Range by date   1,645 Mannoj Kumar 08/09/2012 04:05AM
Re: Add new partition for Range by date   806 Jonathan Stephens 08/12/2012 01:20AM
Re: Add new partition for Range by date   940 Rick James 08/18/2012 07:53PM
Re: Add new partition for Range by date   953 Rick James 08/10/2012 01:05AM
Re: Add new partition for Range by date   814 Mannoj Kumar 08/10/2012 03:17AM
Re: Add new partition for Range by date   843 Aftab Khan 08/12/2012 01:06AM
how to partition a table with string type unique column .   1,550 qufu dai 08/14/2012 01:40AM
Re: how to partition a table with string type unique column .   797 Mattias Jonsson 08/16/2012 02:16AM
Partition or not ?   1,255 Srikanth Mamidi 08/07/2012 12:58AM
Re: Partition or not ?   805 Rick James 08/09/2012 08:04PM
Partitioning with timestamp column   3,010 dileep ch 08/01/2012 10:25PM
Re: Partitioning with timestamp column   1,369 Rick James 08/02/2012 09:26PM
Re: Partitioning with timestamp column   1,355 dileep ch 08/02/2012 11:44PM
Re: Partitioning with timestamp column   1,532 Rick James 08/03/2012 07:30PM
Accessing more partitions than needed   1,167 dileep ch 07/19/2012 01:12AM
Re: Accessing more partitions than needed   706 Mattias Jonsson 07/19/2012 05:23AM
Upgrading 5.1 to 5.5   749 dileep ch 08/02/2012 12:18AM
Re: Upgrading 5.1 to 5.5   703 Mattias Jonsson 08/02/2012 02:44AM
Re: Accessing more partitions than needed   640 dileep ch 07/19/2012 06:01AM
Partition and subpartition are different column   1,127 Toeh Boot 07/23/2012 10:54AM
Re: Partition and subpartition are different column   778 Rick James 07/28/2012 12:42PM
Re: Partition and subpartition are different column   765 Mattias Jonsson 07/24/2012 04:57AM
MySQL 5.5.24 Server Crash   1,507 Bryce Byrd 07/13/2012 08:48AM
Re: MySQL 5.5.24 Server Crash   732 Mattias Jonsson 07/17/2012 02:30PM
Size of partition table space   2,236 gustavo guido 06/29/2012 02:46PM
Re: Size of partition table space   953 Aftab Khan 07/02/2012 07:46AM
Re: Size of partition table space   990 Rick James 07/03/2012 12:56PM
Re: Size of partition table space   1,016 Rick James 07/01/2012 12:32PM
Re: Size of partition table space   998 gustavo guido 07/02/2012 07:41AM
Exchange All Partitions   4,386 Rob Dukes 06/13/2012 05:36AM
Re: Exchange All Partitions   690 Mattias Jonsson 06/18/2012 04:01AM
Re: Exchange All Partitions   715 Rick James 06/15/2012 08:52PM
Re: Exchange All Partitions   657 Rob Dukes 06/17/2012 12:32AM
Re: Exchange All Partitions   682 Rick James 06/17/2012 07:51PM
Re: Exchange All Partitions   670 Rob Dukes 06/17/2012 10:34PM
Re: Exchange All Partitions   724 Rick James 06/19/2012 08:32AM
Fetching data from a particular partion in a table   4,520 Senthilnathan Thiyagarajan 05/17/2012 05:19AM
Re: Fetching data from a particular partion in a table   909 Mattias Jonsson 05/18/2012 11:29AM
Help in Paritioning the Table   1,214 Amar Sheth 05/07/2012 05:02AM
Re: Help in Paritioning the Table   825 Rick James 05/08/2012 09:29AM
Help to optimize subpartition   1,509 Paki Paki 04/19/2012 05:28AM
Re: Help to optimize subpartition   927 Rick James 04/20/2012 06:54PM
Re: Help to optimize subpartition   900 Paki Paki 04/21/2012 04:15PM
Re: Help to optimize subpartition   994 Mattias Jonsson 05/02/2012 07:59AM
Re: Help to optimize subpartition   770 Mattias Jonsson 05/02/2012 01:41PM
Partition problem (Data striping)   1,596 Randy Roadax 04/10/2012 07:09PM
Re: Partition problem (Data striping)   944 Mattias Jonsson 04/13/2012 08:08AM
Re: Partition problem (Data striping)   952 Randy Roadax 04/13/2012 03:20PM
Re: Partition problem (Data striping)   950 Mattias Jonsson 04/13/2012 04:17PM
Re: Partition problem (Data striping)   890 Randy Roadax 04/13/2012 04:36PM
Re: Partition problem (Data striping)   807 Mattias Jonsson 04/14/2012 05:25PM
Re: Partition problem (Data striping)   797 Rick James 04/12/2012 07:02PM
Re: Partition problem (Data striping)   934 Randy Roadax 04/12/2012 08:30PM
Re: Partition problem (Data striping)   827 Rick James 04/13/2012 04:49PM
Re: Partition problem (Data striping)   911 Randy Roadax 04/13/2012 06:18PM
key partition   1,228 jongse park 04/12/2012 06:28AM
Re: key partition   852 Rick James 04/13/2012 04:12PM
Re: key partition   815 Mattias Jonsson 04/13/2012 08:16AM
Partition using non primary key   1,898 dileep ch 04/04/2012 10:57PM
Re: Partition using non primary key   1,153 Rick James 04/05/2012 07:57PM
Rolling partitions   1,555 Piyush Maheshwari 03/29/2012 02:19AM
Re: Rolling partitions   860 Rick James 03/31/2012 11:22AM
When partition a table   1,283 David Simal González 03/28/2012 11:15AM
Re: When partition a table   945 Rick James 03/31/2012 06:53AM
partitions to quickly drop lots of data each month   1,466 Darren White 03/22/2012 02:20AM
Re: partitions to quickly drop lots of data each month   823 Rick James 03/22/2012 09:56PM
Move from unpartitioned database to partitioned database   1,888 Piyush Maheshwari 03/19/2012 07:43AM
Re: Move from unpartitioned database to partitioned database   1,116 Mattias Jonsson 03/20/2012 01:21AM
Re: Move from unpartitioned database to partitioned database   974 Piyush Maheshwari 03/20/2012 03:39AM
Re: Move from unpartitioned database to partitioned database   923 Mattias Jonsson 03/20/2012 03:56AM
Re: Move from unpartitioned database to partitioned database   1,479 Rick James 03/22/2012 07:48PM
list partitioning and range subpartitioning   1,058 jongse park 03/12/2012 02:35AM
Re: list partitioning and range subpartitioning   831 Mattias Jonsson 03/13/2012 07:23AM
I searched table on one partiton, but MySQL scanning two partitons   1,536 Yang Bingle 03/03/2012 04:01AM
Re: I searched table on one partiton, but MySQL scanning two partitons   882 Rick James 03/04/2012 02:28PM
I divided table on two parts, but MySQL scanning full table   2,018 oto shavadze 02/07/2012 11:27PM
Re: I divided table on two parts, but MySQL scanning full table   1,008 Rick James 02/08/2012 05:45PM
Re: I divided table on two parts, but MySQL scanning full table   935 oto shavadze 02/09/2012 11:12AM
Re: I divided table on two parts, but MySQL scanning full table   995 Rick James 02/11/2012 12:04AM
Re: I divided table on two parts, but MySQL scanning full table   1,007 oto shavadze 02/11/2012 01:10PM
KEY vs RANGE partitioning   1,726 Basilis Papadopoulos 02/08/2012 07:38AM
Re: KEY vs RANGE partitioning   1,090 Mattias Jonsson 02/09/2012 07:35AM
Re: KEY vs RANGE partitioning   894 Basilis Papadopoulos 02/09/2012 01:45AM
Re: KEY vs RANGE partitioning   1,222 Mattias Jonsson 02/09/2012 10:50AM
Re: KEY vs RANGE partitioning   998 Rick James 02/09/2012 04:22AM
How to divide the table into 1000 part   1,725 oto shavadze 02/06/2012 01:07AM
Re: How to divide the table into 1000 part   834 Rick James 02/07/2012 07:02PM
Re: How to divide the table into 1000 part   847 oto shavadze 02/08/2012 04:12AM
Suggestion for optimization - reg   1,625 suvendu mohapatra 01/23/2012 05:09AM
Re: Suggestion for optimization - reg   877 Rick James 01/24/2012 02:18AM
Re: Suggestion for optimization - reg   876 suvendu mohapatra 01/24/2012 06:50AM
Re: Suggestion for optimization - reg   765 Rick James 01/25/2012 09:09PM
Re: Suggestion for optimization - reg   767 suvendu mohapatra 01/26/2012 06:49AM
Re: Suggestion for optimization - reg   720 Rick James 01/26/2012 02:48PM
Re: Suggestion for optimization - reg   986 suvendu mohapatra 01/26/2012 04:32PM
Re: Suggestion for optimization - reg   756 Rick James 01/27/2012 08:41PM
Re: Suggestion for optimization - reg   820 suvendu mohapatra 01/25/2012 11:04PM
truncate partition not happening   1,932 samir devaliya 01/09/2012 08:06AM
Re: truncate partition not happening   1,150 Mattias Jonsson 01/12/2012 05:02AM
Re: truncate partition not happening   819 samir devaliya 01/13/2012 10:37PM
Re: truncate partition not happening   935 samir devaliya 01/16/2012 12:41AM
Re: truncate partition not happening   881 Mattias Jonsson 01/16/2012 04:22AM
Re: truncate partition not happening   832 Rick James 01/13/2012 09:58AM
Re: truncate partition not happening   1,100 Mattias Jonsson 01/13/2012 10:13AM
reorganize syntax / procedure   2,214 kevin foote 01/12/2012 03:36PM
Re: reorganize syntax / procedure   1,175 Rick James 01/13/2012 07:34PM
Re: reorganize syntax / procedure   1,551 Mattias Jonsson 01/13/2012 10:35AM
Re: reorganize syntax / procedure   873 kevin foote 01/13/2012 03:57PM
Best partitioning strategy VS shortest primary key   2,224 Jérémy Cohen Solal 12/19/2011 06:12AM
Re: Best partitioning strategy VS shortest primary key   1,106 Rick James 12/20/2011 10:31AM
Re: Best partitioning strategy VS shortest primary key   1,055 Jérémy Cohen Solal 12/21/2011 07:37AM
Re: Best partitioning strategy VS shortest primary key   1,400 Rick James 12/24/2011 03:03PM
partition with non primary key column   1,520 deva clementraj 12/09/2011 01:23AM
Re: partition with non primary key column   868 Rick James 12/13/2011 06:22PM
Re: partition with non primary key column   928 Mattias Jonsson 12/12/2011 06:34AM
Attaching a single partition to MySql on another server   1,531 Mirek K 11/29/2011 11:41AM
Re: Attaching a single partition to MySql on another server   965 Shantanu Oak 11/30/2011 05:00AM
Re: Attaching a single partition to MySql on another server   766 Mirek K 12/07/2011 03:48AM
Re: Attaching a single partition to MySql on another server   840 Mattias Jonsson 11/30/2011 02:24AM
Re: Attaching a single partition to MySql on another server   811 Mirek K 11/30/2011 06:02AM
Re: Attaching a single partition to MySql on another server   850 Mattias Jonsson 11/30/2011 06:12AM
Re: Attaching a single partition to MySql on another server   968 Rick James 11/30/2011 08:07PM
Partitioning Table - GPS Data   1,719 Daniel Alves 11/30/2011 01:53PM
Re: Partitioning Table - GPS Data   903 Daniel Alves 11/30/2011 03:15PM
Re: Partitioning Table - GPS Data   1,114 Rick James 12/01/2011 09:57PM
Re: Partitioning Table - GPS Data   805 Daniel Alves 12/02/2011 08:52AM
Re: Partitioning Table - GPS Data   850 Daniel Alves 12/02/2011 08:51AM
Re: Partitioning Table - GPS Data   963 Rick James 12/03/2011 10:26AM
Re: Partitioning Table - GPS Data   874 Daniel Alves 12/05/2011 05:43AM
Re: Partitioning Table - GPS Data   1,021 Rick James 12/06/2011 08:46PM
Multiple handlers per partition   1,211 Rolf Martin-Hoster 11/23/2011 10:26AM
Re: Multiple handlers per partition   836 Mattias Jonsson 11/30/2011 02:14AM
Data not balanced in partitions   1,574 Evan P 11/26/2011 05:41AM
Re: Data not balanced in partitions   824 Rick James 11/28/2011 11:25AM
Re: Data not balanced in partitions   746 Evan P 11/26/2011 12:34PM
Re: Data not balanced in partitions   940 Evan P 11/26/2011 12:51PM
can't create partitioning table   1,615 Jacky Shu 11/22/2011 10:26AM
Re: can't create partitioning table   677 Jacky Shu 11/24/2011 07:41AM
Re: can't create partitioning table   739 Rick James 11/24/2011 12:32AM
Partition Pruning   1,464 Scott Watson 11/14/2011 04:19PM
Re: Partition Pruning   830 Mattias Jonsson 11/21/2011 05:46AM
MyIsam partition by string   2,502 Chris XX 11/03/2011 09:32AM
Re: MyIsam partition by string   851 Mattias Jonsson 11/07/2011 03:12PM
Re: MyIsam partition by string   899 Rick James 11/05/2011 10:29PM
MySQl partitioning query issue   2,011 Madhu Venkatesh 11/02/2011 10:34AM
Re: MySQl partitioning query issue   821 Rick James 11/05/2011 08:42PM
Re: MySQl partitioning query issue   781 Madhu Venkatesh 11/02/2011 12:33PM
Partition Pruning Issue while using Day() function in Range   2,497 Battu Praveen Kumar 09/21/2011 04:00AM
Re: Partition Pruning Issue while using Day() function in Range   982 Rick James 09/23/2011 09:22AM
Re: Partition Pruning Issue while using Day() function in Range   1,221 Battu Praveen Kumar 10/02/2011 11:10PM
Re: Partition Pruning Issue while using Day() function in Range   984 Rick James 10/09/2011 01:44PM
Re: Partition Pruning Issue while using Day() function in Range   1,145 Mattias Jonsson 09/22/2011 03:36AM
Partition by State   2,466 Dustin Teter 07/11/2011 01:23PM
Re: Partition by State   824 nugik wibowo 09/24/2011 10:45AM
Re: Partition by State   1,022 Rick James 07/14/2011 01:16AM
Constant, random or timezone-dependent expressions in (sub)partitioning   3,003 Carlo Rossetti 09/18/2011 02:39AM
Re: Constant, random or timezone-dependent expressions in (sub)partitioning   1,586 Mattias Jonsson 09/19/2011 09:17AM
Re: Constant, random or timezone-dependent expressions in (sub)partitioning   1,107 Carlo Rossetti 09/19/2011 10:40AM
ALTER TABLE t_test ADD PARTITION BY LIST(field)?   2,927 Carlo Rossetti 09/18/2011 03:27AM
Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?   3,718 Mattias Jonsson 09/19/2011 09:10AM
Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?   1,198 Carlo Rossetti 09/19/2011 10:38AM
Question regarding Partitioning by key   1,718 kuku kuku 08/28/2011 03:47PM
Re: Question regarding Partitioning by key   909 Rick James 08/30/2011 09:35AM
This topic has been moved.:  MyIsam partition by string   0 Chris XX 11/03/2011 07:41AM
This topic has been moved.:  MySQl partitioning query issue   6 Madhu Venkatesh 11/02/2011 12:50PM
This topic has been moved.:  Question regarding Partitioning by key   0 kuku kuku 08/28/2011 08:28PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 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.