Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Cluster 7.1.33 has been released 10/21/2014 04:54AM
MySQL Cluster 7.3.7 has been released 10/17/2014 07:46PM
MySQL Cluster 7.2.18 has been released 10/16/2014 12:07PM
MySQL Enterprise Monitor 3.0.15 has been released 10/01/2014 10:49AM
MySQL Connector/NET 6.9.4 has been released 09/26/2014 04:00PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 12
Subject Views Written By Posted
Does partitioning make sense for this application?   1,561 Paul Schmehl 10/25/2012 08:46PM
Re: Does partitioning make sense for this application?   924 Rick James 10/26/2012 07:41PM
Re: Does partitioning make sense for this application?   911 Paul Schmehl 10/26/2012 09:55PM
Re: Does partitioning make sense for this application?   757 Rick James 10/27/2012 09:42PM
Re: Does partitioning make sense for this application?   728 Paul Schmehl 10/27/2012 10:41PM
Re: Does partitioning make sense for this application?   721 Rick James 10/28/2012 06:09PM
Re: Does partitioning make sense for this application?   750 Paul Schmehl 10/28/2012 08:58PM
Re: Does partitioning make sense for this application?   779 Rick James 10/30/2012 12:15PM
Programatic Partitioning   1,231 Jardel Morais 10/22/2012 04:44AM
Get partition name for specific date   1,483 Jan Bromberger 10/08/2012 12:48PM
Re: Get partition name for specific date   899 Rick James 10/09/2012 09:21AM
Re: Get partition name for specific date   821 Jan Bromberger 10/10/2012 03:18AM
Re: Get partition name for specific date   840 Rick James 10/11/2012 07:12PM
Row movement for MySQL partitionned tables   1,449 jongse park 10/10/2012 11:14PM
Re: Row movement for MySQL partitionned tables   809 Mattias Jonsson 10/11/2012 05:32AM
columns partitioning row inserted in wrong partition   1,406 martino merci 10/10/2012 02:54AM
Re: columns partitioning row inserted in wrong partition   744 Mattias Jonsson 10/10/2012 11:15AM
Regarding optimizing hugh data with mysql   1,306 Santosh Bhabal 10/08/2012 05:47AM
Re: Regarding optimizing hugh data with mysql   775 Rick James 10/09/2012 11:23PM
Partitioning by year/quarter   1,989 Ravi Malghan 09/24/2012 10:32AM
Re: Partitioning by year/quarter   1,089 Aftab Khan 09/27/2012 01:31PM
Re: Partitioning by year/quarter   844 Rick James 10/02/2012 09:15PM
Partitioning help   1,173 Naresh Kondeboina 09/25/2012 02:09PM
Re: Partitioning help   759 Aftab Khan 09/27/2012 01:12PM
Re: Partitioning help   761 Naresh Kondeboina 09/27/2012 08:38PM
Re: Partitioning help   744 Rick James 10/01/2012 11:54PM
Prunning partitions with range by date   1,404 Diogo Domanski 09/27/2012 01:18PM
Re: Prunning partitions with range by date   851 Aftab Khan 09/27/2012 01:39PM
Re: Prunning partitions with range by date (SOLVED)   788 Diogo Domanski 09/27/2012 03:00PM
What Method is Best   1,365 Larry Adams 09/12/2012 03:12PM
Re: What Method is Best   896 Mattias Jonsson 09/14/2012 02:36AM
Re: What Method is Best   824 Larry Adams 09/14/2012 05:30AM
Re: What Method is Best   758 Rick James 09/14/2012 11:11PM
timestamp, datetime as default value as current_timestamp [PARTITION]   1,892 Mannoj Kumar 08/29/2012 01:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,055 Aftab Khan 08/29/2012 04:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   899 Mattias Jonsson 08/31/2012 06:00PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   768 Aftab Khan 09/03/2012 03:19AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,278 Mannoj Kumar 08/29/2012 04:32AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   880 Aftab Khan 08/29/2012 09:16AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   836 Mannoj Kumar 09/03/2012 11:26PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,012 Rick James 09/04/2012 08:05PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   971 Mannoj Kumar 09/07/2012 05:49AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   848 Rick James 08/30/2012 10:35PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   807 Aftab Khan 08/31/2012 02:04AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   904 Rick James 08/31/2012 09:52AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   801 Mattias Jonsson 09/05/2012 12:36AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   827 Rick James 09/05/2012 08:29AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   923 Aftab Khan 08/31/2012 01:58AM
Modify primary key for partitioning   1,472 Aurelien PANIZZA 08/10/2012 10:29AM
Re: Modify primary key for partitioning   904 Rick James 08/18/2012 09:39PM
Re: Modify primary key for partitioning   1,003 Aurelien PANIZZA 08/20/2012 06:33AM
Re: Modify primary key for partitioning   899 Aftab Khan 08/22/2012 10:16AM
Re: Modify primary key for partitioning   837 Aurelien PANIZZA 08/28/2012 10:14AM
Re: Modify primary key for partitioning   800 Rick James 08/30/2012 10:26PM
Re: Modify primary key for partitioning   1,046 Aurelien PANIZZA 08/31/2012 03:05AM
Re: Modify primary key for partitioning   817 Aftab Khan 08/31/2012 03:38AM
Re: Modify primary key for partitioning   764 Aurelien PANIZZA 08/31/2012 06:48AM
Re: Modify primary key for partitioning   827 Rick James 08/31/2012 09:39AM
Re: Modify primary key for partitioning   772 Aurelien PANIZZA 09/04/2012 01:02AM
Re: Modify primary key for partitioning   833 Rick James 08/23/2012 09:16AM
Re: Modify primary key for partitioning   858 Aftab Khan 08/23/2012 10:42AM
particular field type not allowed to this type of partitioning   2,708 Dhileepan M 08/23/2012 11:24PM
Re: particular field type not allowed to this type of partitioning   934 Mattias Jonsson 08/24/2012 04:15AM
Re: particular field type not allowed to this type of partitioning   1,283 Aftab Khan 08/24/2012 01:59AM
Re: particular field type not allowed to this type of partitioning   914 Dhileepan M 08/24/2012 03:46AM
Simply MySQL Partition on One Column (groupID)   1,279 Andrew Barlow 08/20/2012 07:43AM
Re: Simply MySQL Partition on One Column (groupID)   805 Aftab Khan 08/22/2012 09:46AM
Re: Simply MySQL Partition on One Column (groupID)   866 Rick James 08/21/2012 08:44AM
range columns including datetime column   1,403 Rob Voyer 08/15/2012 10:01PM
Re: range columns including datetime column   828 Mattias Jonsson 08/16/2012 02:42AM
Re: range columns including datetime column   788 Rob Voyer 08/16/2012 07:15AM
Re: range columns including datetime column   775 Mattias Jonsson 08/16/2012 09:35AM
Re: range columns including datetime column   756 Rob Voyer 08/16/2012 09:54AM
Re: range columns including datetime column   822 Rick James 08/19/2012 10:55PM
Re: range columns including datetime column   778 Mattias Jonsson 08/20/2012 03:21AM
Partition   1,577 Dhileepan M 08/10/2012 12:37AM
Re: Partition   1,086 Jonathan Stephens 08/11/2012 03:37AM
Re: Partition   974 Rick James 08/19/2012 03:18PM
Add new partition for Range by date   1,719 Mannoj Kumar 08/09/2012 04:05AM
Re: Add new partition for Range by date   831 Jonathan Stephens 08/12/2012 01:20AM
Re: Add new partition for Range by date   983 Rick James 08/18/2012 07:53PM
Re: Add new partition for Range by date   986 Rick James 08/10/2012 01:05AM
Re: Add new partition for Range by date   830 Mannoj Kumar 08/10/2012 03:17AM
Re: Add new partition for Range by date   864 Aftab Khan 08/12/2012 01:06AM
how to partition a table with string type unique column .   1,643 qufu dai 08/14/2012 01:40AM
Re: how to partition a table with string type unique column .   824 Mattias Jonsson 08/16/2012 02:16AM
Partition or not ?   1,305 Srikanth Mamidi 08/07/2012 12:58AM
Re: Partition or not ?   832 Rick James 08/09/2012 08:04PM
Partitioning with timestamp column   3,248 dileep ch 08/01/2012 10:25PM
Re: Partitioning with timestamp column   1,452 Rick James 08/02/2012 09:26PM
Re: Partitioning with timestamp column   1,430 dileep ch 08/02/2012 11:44PM
Re: Partitioning with timestamp column   1,640 Rick James 08/03/2012 07:30PM
Accessing more partitions than needed   1,223 dileep ch 07/19/2012 01:12AM
Re: Accessing more partitions than needed   722 Mattias Jonsson 07/19/2012 05:23AM
Upgrading 5.1 to 5.5   788 dileep ch 08/02/2012 12:18AM
Re: Upgrading 5.1 to 5.5   737 Mattias Jonsson 08/02/2012 02:44AM
Re: Accessing more partitions than needed   662 dileep ch 07/19/2012 06:01AM
Partition and subpartition are different column   1,157 Toeh Boot 07/23/2012 10:54AM
Re: Partition and subpartition are different column   800 Rick James 07/28/2012 12:42PM
Re: Partition and subpartition are different column   786 Mattias Jonsson 07/24/2012 04:57AM
MySQL 5.5.24 Server Crash   1,610 Bryce Byrd 07/13/2012 08:48AM
Re: MySQL 5.5.24 Server Crash   755 Mattias Jonsson 07/17/2012 02:30PM
Size of partition table space   2,361 gustavo guido 06/29/2012 02:46PM
Re: Size of partition table space   979 Aftab Khan 07/02/2012 07:46AM
Re: Size of partition table space   1,034 Rick James 07/03/2012 12:56PM
Re: Size of partition table space   1,056 Rick James 07/01/2012 12:32PM
Re: Size of partition table space   1,027 gustavo guido 07/02/2012 07:41AM
Exchange All Partitions   4,733 Rob Dukes 06/13/2012 05:36AM
Re: Exchange All Partitions   712 Mattias Jonsson 06/18/2012 04:01AM
Re: Exchange All Partitions   737 Rick James 06/15/2012 08:52PM
Re: Exchange All Partitions   673 Rob Dukes 06/17/2012 12:32AM
Re: Exchange All Partitions   709 Rick James 06/17/2012 07:51PM
Re: Exchange All Partitions   691 Rob Dukes 06/17/2012 10:34PM
Re: Exchange All Partitions   746 Rick James 06/19/2012 08:32AM
Fetching data from a particular partion in a table   4,862 Senthilnathan Thiyagarajan 05/17/2012 05:19AM
Re: Fetching data from a particular partion in a table   926 Mattias Jonsson 05/18/2012 11:29AM
Help in Paritioning the Table   1,254 Amar Sheth 05/07/2012 05:02AM
Re: Help in Paritioning the Table   849 Rick James 05/08/2012 09:29AM
Help to optimize subpartition   1,554 Paki Paki 04/19/2012 05:28AM
Re: Help to optimize subpartition   965 Rick James 04/20/2012 06:54PM
Re: Help to optimize subpartition   931 Paki Paki 04/21/2012 04:15PM
Re: Help to optimize subpartition   1,024 Mattias Jonsson 05/02/2012 07:59AM
Re: Help to optimize subpartition   791 Mattias Jonsson 05/02/2012 01:41PM
Partition problem (Data striping)   1,627 Randy Roadax 04/10/2012 07:09PM
Re: Partition problem (Data striping)   972 Mattias Jonsson 04/13/2012 08:08AM
Re: Partition problem (Data striping)   977 Randy Roadax 04/13/2012 03:20PM
Re: Partition problem (Data striping)   974 Mattias Jonsson 04/13/2012 04:17PM
Re: Partition problem (Data striping)   910 Randy Roadax 04/13/2012 04:36PM
Re: Partition problem (Data striping)   843 Mattias Jonsson 04/14/2012 05:25PM
Re: Partition problem (Data striping)   810 Rick James 04/12/2012 07:02PM
Re: Partition problem (Data striping)   953 Randy Roadax 04/12/2012 08:30PM
Re: Partition problem (Data striping)   859 Rick James 04/13/2012 04:49PM
Re: Partition problem (Data striping)   949 Randy Roadax 04/13/2012 06:18PM
key partition   1,251 jongse park 04/12/2012 06:28AM
Re: key partition   881 Rick James 04/13/2012 04:12PM
Re: key partition   845 Mattias Jonsson 04/13/2012 08:16AM
Partition using non primary key   1,952 dileep ch 04/04/2012 10:57PM
Re: Partition using non primary key   1,202 Rick James 04/05/2012 07:57PM
Rolling partitions   1,601 Piyush Maheshwari 03/29/2012 02:19AM
Re: Rolling partitions   885 Rick James 03/31/2012 11:22AM
When partition a table   1,338 David Simal González 03/28/2012 11:15AM
Re: When partition a table   966 Rick James 03/31/2012 06:53AM
partitions to quickly drop lots of data each month   1,507 Darren White 03/22/2012 02:20AM
Re: partitions to quickly drop lots of data each month   841 Rick James 03/22/2012 09:56PM
Move from unpartitioned database to partitioned database   1,956 Piyush Maheshwari 03/19/2012 07:43AM
Re: Move from unpartitioned database to partitioned database   1,141 Mattias Jonsson 03/20/2012 01:21AM
Re: Move from unpartitioned database to partitioned database   1,004 Piyush Maheshwari 03/20/2012 03:39AM
Re: Move from unpartitioned database to partitioned database   949 Mattias Jonsson 03/20/2012 03:56AM
Re: Move from unpartitioned database to partitioned database   1,521 Rick James 03/22/2012 07:48PM
list partitioning and range subpartitioning   1,084 jongse park 03/12/2012 02:35AM
Re: list partitioning and range subpartitioning   851 Mattias Jonsson 03/13/2012 07:23AM
I searched table on one partiton, but MySQL scanning two partitons   1,593 Yang Bingle 03/03/2012 04:01AM
Re: I searched table on one partiton, but MySQL scanning two partitons   907 Rick James 03/04/2012 02:28PM
I divided table on two parts, but MySQL scanning full table   2,062 oto shavadze 02/07/2012 11:27PM
Re: I divided table on two parts, but MySQL scanning full table   1,031 Rick James 02/08/2012 05:45PM
Re: I divided table on two parts, but MySQL scanning full table   964 oto shavadze 02/09/2012 11:12AM
Re: I divided table on two parts, but MySQL scanning full table   1,027 Rick James 02/11/2012 12:04AM
Re: I divided table on two parts, but MySQL scanning full table   1,028 oto shavadze 02/11/2012 01:10PM
KEY vs RANGE partitioning   1,789 Basilis Papadopoulos 02/08/2012 07:38AM
Re: KEY vs RANGE partitioning   1,121 Mattias Jonsson 02/09/2012 07:35AM
Re: KEY vs RANGE partitioning   916 Basilis Papadopoulos 02/09/2012 01:45AM
Re: KEY vs RANGE partitioning   1,245 Mattias Jonsson 02/09/2012 10:50AM
Re: KEY vs RANGE partitioning   1,018 Rick James 02/09/2012 04:22AM
How to divide the table into 1000 part   1,765 oto shavadze 02/06/2012 01:07AM
Re: How to divide the table into 1000 part   860 Rick James 02/07/2012 07:02PM
Re: How to divide the table into 1000 part   865 oto shavadze 02/08/2012 04:12AM
Suggestion for optimization - reg   1,673 suvendu mohapatra 01/23/2012 05:09AM
Re: Suggestion for optimization - reg   891 Rick James 01/24/2012 02:18AM
Re: Suggestion for optimization - reg   890 suvendu mohapatra 01/24/2012 06:50AM
Re: Suggestion for optimization - reg   780 Rick James 01/25/2012 09:09PM
Re: Suggestion for optimization - reg   779 suvendu mohapatra 01/26/2012 06:49AM
Re: Suggestion for optimization - reg   736 Rick James 01/26/2012 02:48PM
Re: Suggestion for optimization - reg   1,002 suvendu mohapatra 01/26/2012 04:32PM
Re: Suggestion for optimization - reg   770 Rick James 01/27/2012 08:41PM
Re: Suggestion for optimization - reg   837 suvendu mohapatra 01/25/2012 11:04PM
truncate partition not happening   1,973 samir devaliya 01/09/2012 08:06AM
Re: truncate partition not happening   1,167 Mattias Jonsson 01/12/2012 05:02AM
Re: truncate partition not happening   837 samir devaliya 01/13/2012 10:37PM
Re: truncate partition not happening   959 samir devaliya 01/16/2012 12:41AM
Re: truncate partition not happening   909 Mattias Jonsson 01/16/2012 04:22AM
Re: truncate partition not happening   852 Rick James 01/13/2012 09:58AM
Re: truncate partition not happening   1,138 Mattias Jonsson 01/13/2012 10:13AM
reorganize syntax / procedure   2,268 kevin foote 01/12/2012 03:36PM
Re: reorganize syntax / procedure   1,208 Rick James 01/13/2012 07:34PM
Re: reorganize syntax / procedure   1,610 Mattias Jonsson 01/13/2012 10:35AM
Re: reorganize syntax / procedure   889 kevin foote 01/13/2012 03:57PM
Best partitioning strategy VS shortest primary key   2,302 Jérémy Cohen Solal 12/19/2011 06:12AM
Re: Best partitioning strategy VS shortest primary key   1,134 Rick James 12/20/2011 10:31AM
Re: Best partitioning strategy VS shortest primary key   1,077 Jérémy Cohen Solal 12/21/2011 07:37AM
Re: Best partitioning strategy VS shortest primary key   1,428 Rick James 12/24/2011 03:03PM
partition with non primary key column   1,551 deva clementraj 12/09/2011 01:23AM
Re: partition with non primary key column   884 Rick James 12/13/2011 06:22PM
Re: partition with non primary key column   951 Mattias Jonsson 12/12/2011 06:34AM
Attaching a single partition to MySql on another server   1,571 Mirek K 11/29/2011 11:41AM
Re: Attaching a single partition to MySql on another server   984 Shantanu Oak 11/30/2011 05:00AM
Re: Attaching a single partition to MySql on another server   791 Mirek K 12/07/2011 03:48AM
Re: Attaching a single partition to MySql on another server   882 Mattias Jonsson 11/30/2011 02:24AM
Re: Attaching a single partition to MySql on another server   828 Mirek K 11/30/2011 06:02AM
Re: Attaching a single partition to MySql on another server   870 Mattias Jonsson 11/30/2011 06:12AM
Re: Attaching a single partition to MySql on another server   1,006 Rick James 11/30/2011 08:07PM
Partitioning Table - GPS Data   1,782 Daniel Alves 11/30/2011 01:53PM
Re: Partitioning Table - GPS Data   922 Daniel Alves 11/30/2011 03:15PM
Re: Partitioning Table - GPS Data   1,135 Rick James 12/01/2011 09:57PM
Re: Partitioning Table - GPS Data   841 Daniel Alves 12/02/2011 08:52AM
Re: Partitioning Table - GPS Data   873 Daniel Alves 12/02/2011 08:51AM
Re: Partitioning Table - GPS Data   1,003 Rick James 12/03/2011 10:26AM
Re: Partitioning Table - GPS Data   914 Daniel Alves 12/05/2011 05:43AM
Re: Partitioning Table - GPS Data   1,043 Rick James 12/06/2011 08:46PM
Multiple handlers per partition   1,246 Rolf Martin-Hoster 11/23/2011 10:26AM
Re: Multiple handlers per partition   854 Mattias Jonsson 11/30/2011 02:14AM
Data not balanced in partitions   1,617 Evan P 11/26/2011 05:41AM
Re: Data not balanced in partitions   843 Rick James 11/28/2011 11:25AM
Re: Data not balanced in partitions   764 Evan P 11/26/2011 12:34PM
Re: Data not balanced in partitions   962 Evan P 11/26/2011 12:51PM
can't create partitioning table   1,659 Jacky Shu 11/22/2011 10:26AM
Re: can't create partitioning table   690 Jacky Shu 11/24/2011 07:41AM
Re: can't create partitioning table   781 Rick James 11/24/2011 12:32AM
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.