Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
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
MySQL Cluster 7.2.20 has been released 04/14/2015 05:43AM
MySQL Community Server 5.7.7 has been released 04/08/2015 12:27PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 12
Subject Views Written By Posted
partition by range on decimal type   2,017 Greg K 11/20/2012 07:15AM
Re: partition by range on decimal type   1,027 Rick James 11/21/2012 10:39AM
Re: partition by range on decimal type   973 Greg K 11/22/2012 02:26AM
Re: partition by range on decimal type   1,009 Rick James 11/22/2012 11:02PM
Re: partition by range on decimal type   1,198 Greg K 11/23/2012 12:45AM
Re: partition by range on decimal type   1,246 Rick James 11/23/2012 09:03PM
Fortnight partitions   2,078 Srikanth Mamidi 11/19/2012 11:24PM
Re: Fortnight partitions   1,374 Rick James 11/20/2012 10:56PM
Re: Fortnight partitions   893 Srikanth Mamidi 11/20/2012 11:23PM
Re: Fortnight partitions   1,084 Rick James 11/21/2012 08:54PM
Re: Fortnight partitions   1,055 Srikanth Mamidi 11/23/2012 12:04AM
milliseconds in mysql equivalent to java for Partitioning   2,196 Manjunath C 11/12/2012 01:36AM
Re: milliseconds in mysql equivalent to java for Partitioning   1,265 Rick James 11/13/2012 09:15AM
Re: milliseconds in mysql equivalent to java for Partitioning   1,106 Manjunath C 11/14/2012 04:17AM
Partitioning not working need primary key?   2,245 newbie Shai 10/20/2012 11:12AM
Re: Partitioning not working need primary key?   1,284 Mattias Jonsson 10/22/2012 07:14AM
Re: Partitioning not working need primary key?   1,068 newbie Shai 10/22/2012 11:59AM
Re: Partitioning not working need primary key?   1,069 Rick James 10/22/2012 09:37PM
Re: Partitioning not working need primary key?   1,116 newbie Shai 10/23/2012 08:36AM
Re: Partitioning not working need primary key?   1,087 Rick James 10/23/2012 09:50AM
Re: Partitioning not working need primary key?   1,059 newbie Shai 10/24/2012 09:05AM
Re: Partitioning not working need primary key?   1,038 Rick James 10/24/2012 09:26PM
Re: Partitioning not working need primary key?   1,061 newbie Shai 10/25/2012 09:45PM
Re: Partitioning not working need primary key?   1,095 Rick James 10/25/2012 11:22PM
Re: Partitioning not working need primary key?   1,079 newbie Shai 10/27/2012 07:21AM
Re: Partitioning not working need primary key?   987 Rick James 10/27/2012 12:01PM
Re: Partitioning not working need primary key?   976 newbie Shai 10/28/2012 12:10PM
Re: Partitioning not working need primary key?   1,032 Rick James 10/28/2012 02:12PM
Re: Partitioning not working need primary key?   1,042 newbie Shai 11/01/2012 10:55AM
Re: Partitioning not working need primary key?   959 Rick James 11/02/2012 12:37AM
Re: Partitioning not working need primary key?   984 newbie Shai 11/03/2012 10:37AM
Re: Partitioning not working need primary key?   1,053 Rick James 11/03/2012 11:37AM
Re: Partitioning not working need primary key?   946 newbie Shai 10/29/2012 06:51PM
Does partitioning make sense for this application?   1,752 Paul Schmehl 10/25/2012 08:46PM
Re: Does partitioning make sense for this application?   1,031 Rick James 10/26/2012 07:41PM
Re: Does partitioning make sense for this application?   1,059 Paul Schmehl 10/26/2012 09:55PM
Re: Does partitioning make sense for this application?   857 Rick James 10/27/2012 09:42PM
Re: Does partitioning make sense for this application?   829 Paul Schmehl 10/27/2012 10:41PM
Re: Does partitioning make sense for this application?   810 Rick James 10/28/2012 06:09PM
Re: Does partitioning make sense for this application?   839 Paul Schmehl 10/28/2012 08:58PM
Re: Does partitioning make sense for this application?   903 Rick James 10/30/2012 12:15PM
Programatic Partitioning   1,331 Jardel Morais 10/22/2012 04:44AM
Get partition name for specific date   1,636 Jan Bromberger 10/08/2012 12:48PM
Re: Get partition name for specific date   1,012 Rick James 10/09/2012 09:21AM
Re: Get partition name for specific date   897 Jan Bromberger 10/10/2012 03:18AM
Re: Get partition name for specific date   920 Rick James 10/11/2012 07:12PM
Row movement for MySQL partitionned tables   1,630 jongse park 10/10/2012 11:14PM
Re: Row movement for MySQL partitionned tables   893 Mattias Jonsson 10/11/2012 05:32AM
columns partitioning row inserted in wrong partition   1,556 martino merci 10/10/2012 02:54AM
Re: columns partitioning row inserted in wrong partition   813 Mattias Jonsson 10/10/2012 11:15AM
Regarding optimizing hugh data with mysql   1,452 Santosh Bhabal 10/08/2012 05:47AM
Re: Regarding optimizing hugh data with mysql   841 Rick James 10/09/2012 11:23PM
Partitioning by year/quarter   2,312 Ravi Malghan 09/24/2012 10:32AM
Re: Partitioning by year/quarter   1,229 Aftab Khan 09/27/2012 01:31PM
Re: Partitioning by year/quarter   974 Rick James 10/02/2012 09:15PM
Partitioning help   1,328 Naresh Kondeboina 09/25/2012 02:09PM
Re: Partitioning help   843 Aftab Khan 09/27/2012 01:12PM
Re: Partitioning help   836 Naresh Kondeboina 09/27/2012 08:38PM
Re: Partitioning help   847 Rick James 10/01/2012 11:54PM
Prunning partitions with range by date   1,560 Diogo Domanski 09/27/2012 01:18PM
Re: Prunning partitions with range by date   930 Aftab Khan 09/27/2012 01:39PM
Re: Prunning partitions with range by date (SOLVED)   866 Diogo Domanski 09/27/2012 03:00PM
What Method is Best   1,566 Larry Adams 09/12/2012 03:12PM
Re: What Method is Best   980 Mattias Jonsson 09/14/2012 02:36AM
Re: What Method is Best   927 Larry Adams 09/14/2012 05:30AM
Re: What Method is Best   826 Rick James 09/14/2012 11:11PM
timestamp, datetime as default value as current_timestamp [PARTITION]   2,211 Mannoj Kumar 08/29/2012 01:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,202 Aftab Khan 08/29/2012 04:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,007 Mattias Jonsson 08/31/2012 06:00PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   888 Aftab Khan 09/03/2012 03:19AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,536 Mannoj Kumar 08/29/2012 04:32AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,015 Aftab Khan 08/29/2012 09:16AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   951 Mannoj Kumar 09/03/2012 11:26PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,160 Rick James 09/04/2012 08:05PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,080 Mannoj Kumar 09/07/2012 05:49AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   956 Rick James 08/30/2012 10:35PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   923 Aftab Khan 08/31/2012 02:04AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,041 Rick James 08/31/2012 09:52AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   944 Mattias Jonsson 09/05/2012 12:36AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   943 Rick James 09/05/2012 08:29AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,030 Aftab Khan 08/31/2012 01:58AM
Modify primary key for partitioning   1,695 Aurelien PANIZZA 08/10/2012 10:29AM
Re: Modify primary key for partitioning   1,029 Rick James 08/18/2012 09:39PM
Re: Modify primary key for partitioning   1,122 Aurelien PANIZZA 08/20/2012 06:33AM
Re: Modify primary key for partitioning   1,009 Aftab Khan 08/22/2012 10:16AM
Re: Modify primary key for partitioning   957 Aurelien PANIZZA 08/28/2012 10:14AM
Re: Modify primary key for partitioning   865 Rick James 08/30/2012 10:26PM
Re: Modify primary key for partitioning   1,205 Aurelien PANIZZA 08/31/2012 03:05AM
Re: Modify primary key for partitioning   938 Aftab Khan 08/31/2012 03:38AM
Re: Modify primary key for partitioning   904 Aurelien PANIZZA 08/31/2012 06:48AM
Re: Modify primary key for partitioning   927 Rick James 08/31/2012 09:39AM
Re: Modify primary key for partitioning   902 Aurelien PANIZZA 09/04/2012 01:02AM
Re: Modify primary key for partitioning   967 Rick James 08/23/2012 09:16AM
Re: Modify primary key for partitioning   964 Aftab Khan 08/23/2012 10:42AM
particular field type not allowed to this type of partitioning   3,235 Dhileepan M 08/23/2012 11:24PM
Re: particular field type not allowed to this type of partitioning   1,023 Mattias Jonsson 08/24/2012 04:15AM
Re: particular field type not allowed to this type of partitioning   1,474 Aftab Khan 08/24/2012 01:59AM
Re: particular field type not allowed to this type of partitioning   1,031 Dhileepan M 08/24/2012 03:46AM
Simply MySQL Partition on One Column (groupID)   1,392 Andrew Barlow 08/20/2012 07:43AM
Re: Simply MySQL Partition on One Column (groupID)   863 Aftab Khan 08/22/2012 09:46AM
Re: Simply MySQL Partition on One Column (groupID)   927 Rick James 08/21/2012 08:44AM
range columns including datetime column   1,552 Rob Voyer 08/15/2012 10:01PM
Re: range columns including datetime column   902 Mattias Jonsson 08/16/2012 02:42AM
Re: range columns including datetime column   858 Rob Voyer 08/16/2012 07:15AM
Re: range columns including datetime column   865 Mattias Jonsson 08/16/2012 09:35AM
Re: range columns including datetime column   842 Rob Voyer 08/16/2012 09:54AM
Re: range columns including datetime column   908 Rick James 08/19/2012 10:55PM
Re: range columns including datetime column   855 Mattias Jonsson 08/20/2012 03:21AM
Partition   1,773 Dhileepan M 08/10/2012 12:37AM
Re: Partition   1,212 Jonathan Stephens 08/11/2012 03:37AM
Re: Partition   1,066 Rick James 08/19/2012 03:18PM
Add new partition for Range by date   1,980 Mannoj Kumar 08/09/2012 04:05AM
Re: Add new partition for Range by date   918 Jonathan Stephens 08/12/2012 01:20AM
Re: Add new partition for Range by date   1,146 Rick James 08/18/2012 07:53PM
Re: Add new partition for Range by date   1,092 Rick James 08/10/2012 01:05AM
Re: Add new partition for Range by date   924 Mannoj Kumar 08/10/2012 03:17AM
Re: Add new partition for Range by date   957 Aftab Khan 08/12/2012 01:06AM
how to partition a table with string type unique column .   1,891 qufu dai 08/14/2012 01:40AM
Re: how to partition a table with string type unique column .   897 Mattias Jonsson 08/16/2012 02:16AM
Partition or not ?   1,433 Srikanth Mamidi 08/07/2012 12:58AM
Re: Partition or not ?   900 Rick James 08/09/2012 08:04PM
Partitioning with timestamp column   3,645 dileep ch 08/01/2012 10:25PM
Re: Partitioning with timestamp column   1,636 Rick James 08/02/2012 09:26PM
Re: Partitioning with timestamp column   1,584 dileep ch 08/02/2012 11:44PM
Re: Partitioning with timestamp column   1,827 Rick James 08/03/2012 07:30PM
Accessing more partitions than needed   1,359 dileep ch 07/19/2012 01:12AM
Re: Accessing more partitions than needed   782 Mattias Jonsson 07/19/2012 05:23AM
Upgrading 5.1 to 5.5   855 dileep ch 08/02/2012 12:18AM
Re: Upgrading 5.1 to 5.5   795 Mattias Jonsson 08/02/2012 02:44AM
Re: Accessing more partitions than needed   709 dileep ch 07/19/2012 06:01AM
Partition and subpartition are different column   1,268 Toeh Boot 07/23/2012 10:54AM
Re: Partition and subpartition are different column   860 Rick James 07/28/2012 12:42PM
Re: Partition and subpartition are different column   840 Mattias Jonsson 07/24/2012 04:57AM
MySQL 5.5.24 Server Crash   1,818 Bryce Byrd 07/13/2012 08:48AM
Re: MySQL 5.5.24 Server Crash   803 Mattias Jonsson 07/17/2012 02:30PM
Size of partition table space   2,671 gustavo guido 06/29/2012 02:46PM
Re: Size of partition table space   1,068 Aftab Khan 07/02/2012 07:46AM
Re: Size of partition table space   1,124 Rick James 07/03/2012 12:56PM
Re: Size of partition table space   1,184 Rick James 07/01/2012 12:32PM
Re: Size of partition table space   1,124 gustavo guido 07/02/2012 07:41AM
Exchange All Partitions   5,014 Rob Dukes 06/13/2012 05:36AM
Re: Exchange All Partitions   762 Mattias Jonsson 06/18/2012 04:01AM
Re: Exchange All Partitions   818 Rick James 06/15/2012 08:52PM
Re: Exchange All Partitions   747 Rob Dukes 06/17/2012 12:32AM
Re: Exchange All Partitions   811 Rick James 06/17/2012 07:51PM
Re: Exchange All Partitions   754 Rob Dukes 06/17/2012 10:34PM
Re: Exchange All Partitions   819 Rick James 06/19/2012 08:32AM
Fetching data from a particular partion in a table   5,093 Senthilnathan Thiyagarajan 05/17/2012 05:19AM
Re: Fetching data from a particular partion in a table   977 Mattias Jonsson 05/18/2012 11:29AM
Help in Paritioning the Table   1,381 Amar Sheth 05/07/2012 05:02AM
Re: Help in Paritioning the Table   924 Rick James 05/08/2012 09:29AM
Help to optimize subpartition   1,723 Paki Paki 04/19/2012 05:28AM
Re: Help to optimize subpartition   1,069 Rick James 04/20/2012 06:54PM
Re: Help to optimize subpartition   1,023 Paki Paki 04/21/2012 04:15PM
Re: Help to optimize subpartition   1,110 Mattias Jonsson 05/02/2012 07:59AM
Re: Help to optimize subpartition   854 Mattias Jonsson 05/02/2012 01:41PM
Partition problem (Data striping)   1,813 Randy Roadax 04/10/2012 07:09PM
Re: Partition problem (Data striping)   1,086 Mattias Jonsson 04/13/2012 08:08AM
Re: Partition problem (Data striping)   1,112 Randy Roadax 04/13/2012 03:20PM
Re: Partition problem (Data striping)   1,120 Mattias Jonsson 04/13/2012 04:17PM
Re: Partition problem (Data striping)   1,040 Randy Roadax 04/13/2012 04:36PM
Re: Partition problem (Data striping)   952 Mattias Jonsson 04/14/2012 05:25PM
Re: Partition problem (Data striping)   912 Rick James 04/12/2012 07:02PM
Re: Partition problem (Data striping)   1,047 Randy Roadax 04/12/2012 08:30PM
Re: Partition problem (Data striping)   966 Rick James 04/13/2012 04:49PM
Re: Partition problem (Data striping)   1,056 Randy Roadax 04/13/2012 06:18PM
key partition   1,359 jongse park 04/12/2012 06:28AM
Re: key partition   949 Rick James 04/13/2012 04:12PM
Re: key partition   954 Mattias Jonsson 04/13/2012 08:16AM
Partition using non primary key   2,112 dileep ch 04/04/2012 10:57PM
Re: Partition using non primary key   1,316 Rick James 04/05/2012 07:57PM
Rolling partitions   1,755 Piyush Maheshwari 03/29/2012 02:19AM
Re: Rolling partitions   956 Rick James 03/31/2012 11:22AM
When partition a table   1,499 David Simal González 03/28/2012 11:15AM
Re: When partition a table   1,031 Rick James 03/31/2012 06:53AM
partitions to quickly drop lots of data each month   1,628 Darren White 03/22/2012 02:20AM
Re: partitions to quickly drop lots of data each month   890 Rick James 03/22/2012 09:56PM
Move from unpartitioned database to partitioned database   2,174 Piyush Maheshwari 03/19/2012 07:43AM
Re: Move from unpartitioned database to partitioned database   1,228 Mattias Jonsson 03/20/2012 01:21AM
Re: Move from unpartitioned database to partitioned database   1,067 Piyush Maheshwari 03/20/2012 03:39AM
Re: Move from unpartitioned database to partitioned database   1,037 Mattias Jonsson 03/20/2012 03:56AM
Re: Move from unpartitioned database to partitioned database   1,643 Rick James 03/22/2012 07:48PM
list partitioning and range subpartitioning   1,206 jongse park 03/12/2012 02:35AM
Re: list partitioning and range subpartitioning   907 Mattias Jonsson 03/13/2012 07:23AM
I searched table on one partiton, but MySQL scanning two partitons   1,768 Yang Bingle 03/03/2012 04:01AM
Re: I searched table on one partiton, but MySQL scanning two partitons   992 Rick James 03/04/2012 02:28PM
I divided table on two parts, but MySQL scanning full table   2,229 oto shavadze 02/07/2012 11:27PM
Re: I divided table on two parts, but MySQL scanning full table   1,098 Rick James 02/08/2012 05:45PM
Re: I divided table on two parts, but MySQL scanning full table   1,050 oto shavadze 02/09/2012 11:12AM
Re: I divided table on two parts, but MySQL scanning full table   1,127 Rick James 02/11/2012 12:04AM
Re: I divided table on two parts, but MySQL scanning full table   1,083 oto shavadze 02/11/2012 01:10PM
KEY vs RANGE partitioning   1,955 Basilis Papadopoulos 02/08/2012 07:38AM
Re: KEY vs RANGE partitioning   1,192 Mattias Jonsson 02/09/2012 07:35AM
Re: KEY vs RANGE partitioning   993 Basilis Papadopoulos 02/09/2012 01:45AM
Re: KEY vs RANGE partitioning   1,327 Mattias Jonsson 02/09/2012 10:50AM
Re: KEY vs RANGE partitioning   1,117 Rick James 02/09/2012 04:22AM
How to divide the table into 1000 part   1,887 oto shavadze 02/06/2012 01:07AM
Re: How to divide the table into 1000 part   909 Rick James 02/07/2012 07:02PM
Re: How to divide the table into 1000 part   920 oto shavadze 02/08/2012 04:12AM
Suggestion for optimization - reg   1,859 suvendu mohapatra 01/23/2012 05:09AM
Re: Suggestion for optimization - reg   960 Rick James 01/24/2012 02:18AM
Re: Suggestion for optimization - reg   973 suvendu mohapatra 01/24/2012 06:50AM
Re: Suggestion for optimization - reg   874 Rick James 01/25/2012 09:09PM
Re: Suggestion for optimization - reg   888 suvendu mohapatra 01/26/2012 06:49AM
Re: Suggestion for optimization - reg   841 Rick James 01/26/2012 02:48PM
Re: Suggestion for optimization - reg   1,120 suvendu mohapatra 01/26/2012 04:32PM
Re: Suggestion for optimization - reg   876 Rick James 01/27/2012 08:41PM
Re: Suggestion for optimization - reg   957 suvendu mohapatra 01/25/2012 11:04PM
truncate partition not happening   2,135 samir devaliya 01/09/2012 08:06AM
Re: truncate partition not happening   1,285 Mattias Jonsson 01/12/2012 05:02AM
Re: truncate partition not happening   914 samir devaliya 01/13/2012 10:37PM
Re: truncate partition not happening   1,041 samir devaliya 01/16/2012 12:41AM
Re: truncate partition not happening   1,002 Mattias Jonsson 01/16/2012 04:22AM
Re: truncate partition not happening   956 Rick James 01/13/2012 09:58AM
Re: truncate partition not happening   1,264 Mattias Jonsson 01/13/2012 10:13AM
reorganize syntax / procedure   2,431 kevin foote 01/12/2012 03:36PM
Re: reorganize syntax / procedure   1,307 Rick James 01/13/2012 07:34PM
Re: reorganize syntax / procedure   1,850 Mattias Jonsson 01/13/2012 10:35AM
Re: reorganize syntax / procedure   959 kevin foote 01/13/2012 03:57PM
Best partitioning strategy VS shortest primary key   2,555 Jérémy Cohen Solal 12/19/2011 06:12AM
Re: Best partitioning strategy VS shortest primary key   1,212 Rick James 12/20/2011 10:31AM
Re: Best partitioning strategy VS shortest primary key   1,172 Jérémy Cohen Solal 12/21/2011 07:37AM
Re: Best partitioning strategy VS shortest primary key   1,544 Rick James 12/24/2011 03:03PM
partition with non primary key column   1,637 deva clementraj 12/09/2011 01:23AM
Re: partition with non primary key column   947 Rick James 12/13/2011 06:22PM
Re: partition with non primary key column   1,011 Mattias Jonsson 12/12/2011 06:34AM
Attaching a single partition to MySql on another server   1,706 Mirek K 11/29/2011 11:41AM
Re: Attaching a single partition to MySql on another server   1,100 Shantanu Oak 11/30/2011 05:00AM
Re: Attaching a single partition to MySql on another server   899 Mirek K 12/07/2011 03:48AM
Re: Attaching a single partition to MySql on another server   994 Mattias Jonsson 11/30/2011 02:24AM
Re: Attaching a single partition to MySql on another server   922 Mirek K 11/30/2011 06:02AM
Re: Attaching a single partition to MySql on another server   939 Mattias Jonsson 11/30/2011 06:12AM
Re: Attaching a single partition to MySql on another server   1,111 Rick James 11/30/2011 08:07PM
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.