Skip navigation links

MySQL Forums :: Partitioning


Advanced Search

Announcements Last Post
MySQL Connector/Python v1.2.3 GA has been released 08/22/2014 12:04PM
MySQL Utilities 1.5.1 has been released 08/20/2014 11:12AM
MySQL Workbench 6.2.1 BETA has been released 08/19/2014 04:54AM
MySQL Cluster Manager 1.3.2 has been released 08/15/2014 04:19PM
MySQL Connector/Java 5.1.32 has been released 08/11/2014 01:45PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 12
Subject Views Written By Posted
Regarding optimizing hugh data with mysql   1,275 Santosh Bhabal 10/08/2012 05:47AM
Re: Regarding optimizing hugh data with mysql   754 Rick James 10/09/2012 11:23PM
Partitioning by year/quarter   1,906 Ravi Malghan 09/24/2012 10:32AM
Re: Partitioning by year/quarter   1,047 Aftab Khan 09/27/2012 01:31PM
Re: Partitioning by year/quarter   808 Rick James 10/02/2012 09:15PM
Partitioning help   1,145 Naresh Kondeboina 09/25/2012 02:09PM
Re: Partitioning help   737 Aftab Khan 09/27/2012 01:12PM
Re: Partitioning help   737 Naresh Kondeboina 09/27/2012 08:38PM
Re: Partitioning help   727 Rick James 10/01/2012 11:54PM
Prunning partitions with range by date   1,362 Diogo Domanski 09/27/2012 01:18PM
Re: Prunning partitions with range by date   832 Aftab Khan 09/27/2012 01:39PM
Re: Prunning partitions with range by date (SOLVED)   768 Diogo Domanski 09/27/2012 03:00PM
What Method is Best   1,317 Larry Adams 09/12/2012 03:12PM
Re: What Method is Best   872 Mattias Jonsson 09/14/2012 02:36AM
Re: What Method is Best   800 Larry Adams 09/14/2012 05:30AM
Re: What Method is Best   739 Rick James 09/14/2012 11:11PM
timestamp, datetime as default value as current_timestamp [PARTITION]   1,820 Mannoj Kumar 08/29/2012 01:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,027 Aftab Khan 08/29/2012 04:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   874 Mattias Jonsson 08/31/2012 06:00PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   737 Aftab Khan 09/03/2012 03:19AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   1,226 Mannoj Kumar 08/29/2012 04:32AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   866 Aftab Khan 08/29/2012 09:16AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   822 Mannoj Kumar 09/03/2012 11:26PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   988 Rick James 09/04/2012 08:05PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   953 Mannoj Kumar 09/07/2012 05:49AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   825 Rick James 08/30/2012 10:35PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   791 Aftab Khan 08/31/2012 02:04AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   893 Rick James 08/31/2012 09:52AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   776 Mattias Jonsson 09/05/2012 12:36AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   814 Rick James 09/05/2012 08:29AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION]   904 Aftab Khan 08/31/2012 01:58AM
Modify primary key for partitioning   1,435 Aurelien PANIZZA 08/10/2012 10:29AM
Re: Modify primary key for partitioning   888 Rick James 08/18/2012 09:39PM
Re: Modify primary key for partitioning   983 Aurelien PANIZZA 08/20/2012 06:33AM
Re: Modify primary key for partitioning   884 Aftab Khan 08/22/2012 10:16AM
Re: Modify primary key for partitioning   818 Aurelien PANIZZA 08/28/2012 10:14AM
Re: Modify primary key for partitioning   784 Rick James 08/30/2012 10:26PM
Re: Modify primary key for partitioning   1,021 Aurelien PANIZZA 08/31/2012 03:05AM
Re: Modify primary key for partitioning   790 Aftab Khan 08/31/2012 03:38AM
Re: Modify primary key for partitioning   751 Aurelien PANIZZA 08/31/2012 06:48AM
Re: Modify primary key for partitioning   812 Rick James 08/31/2012 09:39AM
Re: Modify primary key for partitioning   756 Aurelien PANIZZA 09/04/2012 01:02AM
Re: Modify primary key for partitioning   823 Rick James 08/23/2012 09:16AM
Re: Modify primary key for partitioning   847 Aftab Khan 08/23/2012 10:42AM
particular field type not allowed to this type of partitioning   2,581 Dhileepan M 08/23/2012 11:24PM
Re: particular field type not allowed to this type of partitioning   916 Mattias Jonsson 08/24/2012 04:15AM
Re: particular field type not allowed to this type of partitioning   1,236 Aftab Khan 08/24/2012 01:59AM
Re: particular field type not allowed to this type of partitioning   894 Dhileepan M 08/24/2012 03:46AM
Simply MySQL Partition on One Column (groupID)   1,252 Andrew Barlow 08/20/2012 07:43AM
Re: Simply MySQL Partition on One Column (groupID)   794 Aftab Khan 08/22/2012 09:46AM
Re: Simply MySQL Partition on One Column (groupID)   852 Rick James 08/21/2012 08:44AM
range columns including datetime column   1,361 Rob Voyer 08/15/2012 10:01PM
Re: range columns including datetime column   810 Mattias Jonsson 08/16/2012 02:42AM
Re: range columns including datetime column   773 Rob Voyer 08/16/2012 07:15AM
Re: range columns including datetime column   750 Mattias Jonsson 08/16/2012 09:35AM
Re: range columns including datetime column   731 Rob Voyer 08/16/2012 09:54AM
Re: range columns including datetime column   805 Rick James 08/19/2012 10:55PM
Re: range columns including datetime column   762 Mattias Jonsson 08/20/2012 03:21AM
Partition   1,516 Dhileepan M 08/10/2012 12:37AM
Re: Partition   1,034 Jonathan Stephens 08/11/2012 03:37AM
Re: Partition   929 Rick James 08/19/2012 03:18PM
Add new partition for Range by date   1,671 Mannoj Kumar 08/09/2012 04:05AM
Re: Add new partition for Range by date   816 Jonathan Stephens 08/12/2012 01:20AM
Re: Add new partition for Range by date   956 Rick James 08/18/2012 07:53PM
Re: Add new partition for Range by date   967 Rick James 08/10/2012 01:05AM
Re: Add new partition for Range by date   823 Mannoj Kumar 08/10/2012 03:17AM
Re: Add new partition for Range by date   853 Aftab Khan 08/12/2012 01:06AM
how to partition a table with string type unique column .   1,589 qufu dai 08/14/2012 01:40AM
Re: how to partition a table with string type unique column .   808 Mattias Jonsson 08/16/2012 02:16AM
Partition or not ?   1,278 Srikanth Mamidi 08/07/2012 12:58AM
Re: Partition or not ?   815 Rick James 08/09/2012 08:04PM
Partitioning with timestamp column   3,109 dileep ch 08/01/2012 10:25PM
Re: Partitioning with timestamp column   1,410 Rick James 08/02/2012 09:26PM
Re: Partitioning with timestamp column   1,391 dileep ch 08/02/2012 11:44PM
Re: Partitioning with timestamp column   1,583 Rick James 08/03/2012 07:30PM
Accessing more partitions than needed   1,187 dileep ch 07/19/2012 01:12AM
Re: Accessing more partitions than needed   712 Mattias Jonsson 07/19/2012 05:23AM
Upgrading 5.1 to 5.5   766 dileep ch 08/02/2012 12:18AM
Re: Upgrading 5.1 to 5.5   725 Mattias Jonsson 08/02/2012 02:44AM
Re: Accessing more partitions than needed   650 dileep ch 07/19/2012 06:01AM
Partition and subpartition are different column   1,138 Toeh Boot 07/23/2012 10:54AM
Re: Partition and subpartition are different column   789 Rick James 07/28/2012 12:42PM
Re: Partition and subpartition are different column   775 Mattias Jonsson 07/24/2012 04:57AM
MySQL 5.5.24 Server Crash   1,551 Bryce Byrd 07/13/2012 08:48AM
Re: MySQL 5.5.24 Server Crash   742 Mattias Jonsson 07/17/2012 02:30PM
Size of partition table space   2,275 gustavo guido 06/29/2012 02:46PM
Re: Size of partition table space   964 Aftab Khan 07/02/2012 07:46AM
Re: Size of partition table space   1,012 Rick James 07/03/2012 12:56PM
Re: Size of partition table space   1,035 Rick James 07/01/2012 12:32PM
Re: Size of partition table space   1,012 gustavo guido 07/02/2012 07:41AM
Exchange All Partitions   4,589 Rob Dukes 06/13/2012 05:36AM
Re: Exchange All Partitions   702 Mattias Jonsson 06/18/2012 04:01AM
Re: Exchange All Partitions   726 Rick James 06/15/2012 08:52PM
Re: Exchange All Partitions   662 Rob Dukes 06/17/2012 12:32AM
Re: Exchange All Partitions   696 Rick James 06/17/2012 07:51PM
Re: Exchange All Partitions   682 Rob Dukes 06/17/2012 10:34PM
Re: Exchange All Partitions   734 Rick James 06/19/2012 08:32AM
Fetching data from a particular partion in a table   4,709 Senthilnathan Thiyagarajan 05/17/2012 05:19AM
Re: Fetching data from a particular partion in a table   914 Mattias Jonsson 05/18/2012 11:29AM
Help in Paritioning the Table   1,229 Amar Sheth 05/07/2012 05:02AM
Re: Help in Paritioning the Table   835 Rick James 05/08/2012 09:29AM
Help to optimize subpartition   1,524 Paki Paki 04/19/2012 05:28AM
Re: Help to optimize subpartition   938 Rick James 04/20/2012 06:54PM
Re: Help to optimize subpartition   910 Paki Paki 04/21/2012 04:15PM
Re: Help to optimize subpartition   1,006 Mattias Jonsson 05/02/2012 07:59AM
Re: Help to optimize subpartition   775 Mattias Jonsson 05/02/2012 01:41PM
Partition problem (Data striping)   1,608 Randy Roadax 04/10/2012 07:09PM
Re: Partition problem (Data striping)   955 Mattias Jonsson 04/13/2012 08:08AM
Re: Partition problem (Data striping)   960 Randy Roadax 04/13/2012 03:20PM
Re: Partition problem (Data striping)   959 Mattias Jonsson 04/13/2012 04:17PM
Re: Partition problem (Data striping)   894 Randy Roadax 04/13/2012 04:36PM
Re: Partition problem (Data striping)   820 Mattias Jonsson 04/14/2012 05:25PM
Re: Partition problem (Data striping)   802 Rick James 04/12/2012 07:02PM
Re: Partition problem (Data striping)   942 Randy Roadax 04/12/2012 08:30PM
Re: Partition problem (Data striping)   835 Rick James 04/13/2012 04:49PM
Re: Partition problem (Data striping)   929 Randy Roadax 04/13/2012 06:18PM
key partition   1,238 jongse park 04/12/2012 06:28AM
Re: key partition   862 Rick James 04/13/2012 04:12PM
Re: key partition   824 Mattias Jonsson 04/13/2012 08:16AM
Partition using non primary key   1,920 dileep ch 04/04/2012 10:57PM
Re: Partition using non primary key   1,170 Rick James 04/05/2012 07:57PM
Rolling partitions   1,573 Piyush Maheshwari 03/29/2012 02:19AM
Re: Rolling partitions   871 Rick James 03/31/2012 11:22AM
When partition a table   1,306 David Simal González 03/28/2012 11:15AM
Re: When partition a table   956 Rick James 03/31/2012 06:53AM
partitions to quickly drop lots of data each month   1,487 Darren White 03/22/2012 02:20AM
Re: partitions to quickly drop lots of data each month   831 Rick James 03/22/2012 09:56PM
Move from unpartitioned database to partitioned database   1,917 Piyush Maheshwari 03/19/2012 07:43AM
Re: Move from unpartitioned database to partitioned database   1,129 Mattias Jonsson 03/20/2012 01:21AM
Re: Move from unpartitioned database to partitioned database   992 Piyush Maheshwari 03/20/2012 03:39AM
Re: Move from unpartitioned database to partitioned database   935 Mattias Jonsson 03/20/2012 03:56AM
Re: Move from unpartitioned database to partitioned database   1,496 Rick James 03/22/2012 07:48PM
list partitioning and range subpartitioning   1,071 jongse park 03/12/2012 02:35AM
Re: list partitioning and range subpartitioning   844 Mattias Jonsson 03/13/2012 07:23AM
I searched table on one partiton, but MySQL scanning two partitons   1,559 Yang Bingle 03/03/2012 04:01AM
Re: I searched table on one partiton, but MySQL scanning two partitons   890 Rick James 03/04/2012 02:28PM
I divided table on two parts, but MySQL scanning full table   2,034 oto shavadze 02/07/2012 11:27PM
Re: I divided table on two parts, but MySQL scanning full table   1,015 Rick James 02/08/2012 05:45PM
Re: I divided table on two parts, but MySQL scanning full table   947 oto shavadze 02/09/2012 11:12AM
Re: I divided table on two parts, but MySQL scanning full table   1,010 Rick James 02/11/2012 12:04AM
Re: I divided table on two parts, but MySQL scanning full table   1,015 oto shavadze 02/11/2012 01:10PM
KEY vs RANGE partitioning   1,751 Basilis Papadopoulos 02/08/2012 07:38AM
Re: KEY vs RANGE partitioning   1,104 Mattias Jonsson 02/09/2012 07:35AM
Re: KEY vs RANGE partitioning   901 Basilis Papadopoulos 02/09/2012 01:45AM
Re: KEY vs RANGE partitioning   1,232 Mattias Jonsson 02/09/2012 10:50AM
Re: KEY vs RANGE partitioning   1,005 Rick James 02/09/2012 04:22AM
How to divide the table into 1000 part   1,736 oto shavadze 02/06/2012 01:07AM
Re: How to divide the table into 1000 part   850 Rick James 02/07/2012 07:02PM
Re: How to divide the table into 1000 part   855 oto shavadze 02/08/2012 04:12AM
Suggestion for optimization - reg   1,640 suvendu mohapatra 01/23/2012 05:09AM
Re: Suggestion for optimization - reg   880 Rick James 01/24/2012 02:18AM
Re: Suggestion for optimization - reg   879 suvendu mohapatra 01/24/2012 06:50AM
Re: Suggestion for optimization - reg   770 Rick James 01/25/2012 09:09PM
Re: Suggestion for optimization - reg   774 suvendu mohapatra 01/26/2012 06:49AM
Re: Suggestion for optimization - reg   725 Rick James 01/26/2012 02:48PM
Re: Suggestion for optimization - reg   992 suvendu mohapatra 01/26/2012 04:32PM
Re: Suggestion for optimization - reg   760 Rick James 01/27/2012 08:41PM
Re: Suggestion for optimization - reg   827 suvendu mohapatra 01/25/2012 11:04PM
truncate partition not happening   1,948 samir devaliya 01/09/2012 08:06AM
Re: truncate partition not happening   1,157 Mattias Jonsson 01/12/2012 05:02AM
Re: truncate partition not happening   828 samir devaliya 01/13/2012 10:37PM
Re: truncate partition not happening   946 samir devaliya 01/16/2012 12:41AM
Re: truncate partition not happening   889 Mattias Jonsson 01/16/2012 04:22AM
Re: truncate partition not happening   841 Rick James 01/13/2012 09:58AM
Re: truncate partition not happening   1,115 Mattias Jonsson 01/13/2012 10:13AM
reorganize syntax / procedure   2,241 kevin foote 01/12/2012 03:36PM
Re: reorganize syntax / procedure   1,190 Rick James 01/13/2012 07:34PM
Re: reorganize syntax / procedure   1,577 Mattias Jonsson 01/13/2012 10:35AM
Re: reorganize syntax / procedure   881 kevin foote 01/13/2012 03:57PM
Best partitioning strategy VS shortest primary key   2,254 Jérémy Cohen Solal 12/19/2011 06:12AM
Re: Best partitioning strategy VS shortest primary key   1,116 Rick James 12/20/2011 10:31AM
Re: Best partitioning strategy VS shortest primary key   1,063 Jérémy Cohen Solal 12/21/2011 07:37AM
Re: Best partitioning strategy VS shortest primary key   1,411 Rick James 12/24/2011 03:03PM
partition with non primary key column   1,533 deva clementraj 12/09/2011 01:23AM
Re: partition with non primary key column   874 Rick James 12/13/2011 06:22PM
Re: partition with non primary key column   935 Mattias Jonsson 12/12/2011 06:34AM
Attaching a single partition to MySql on another server   1,549 Mirek K 11/29/2011 11:41AM
Re: Attaching a single partition to MySql on another server   972 Shantanu Oak 11/30/2011 05:00AM
Re: Attaching a single partition to MySql on another server   777 Mirek K 12/07/2011 03:48AM
Re: Attaching a single partition to MySql on another server   853 Mattias Jonsson 11/30/2011 02:24AM
Re: Attaching a single partition to MySql on another server   818 Mirek K 11/30/2011 06:02AM
Re: Attaching a single partition to MySql on another server   860 Mattias Jonsson 11/30/2011 06:12AM
Re: Attaching a single partition to MySql on another server   985 Rick James 11/30/2011 08:07PM
Partitioning Table - GPS Data   1,746 Daniel Alves 11/30/2011 01:53PM
Re: Partitioning Table - GPS Data   910 Daniel Alves 11/30/2011 03:15PM
Re: Partitioning Table - GPS Data   1,124 Rick James 12/01/2011 09:57PM
Re: Partitioning Table - GPS Data   820 Daniel Alves 12/02/2011 08:52AM
Re: Partitioning Table - GPS Data   857 Daniel Alves 12/02/2011 08:51AM
Re: Partitioning Table - GPS Data   982 Rick James 12/03/2011 10:26AM
Re: Partitioning Table - GPS Data   888 Daniel Alves 12/05/2011 05:43AM
Re: Partitioning Table - GPS Data   1,030 Rick James 12/06/2011 08:46PM
Multiple handlers per partition   1,226 Rolf Martin-Hoster 11/23/2011 10:26AM
Re: Multiple handlers per partition   844 Mattias Jonsson 11/30/2011 02:14AM
Data not balanced in partitions   1,595 Evan P 11/26/2011 05:41AM
Re: Data not balanced in partitions   833 Rick James 11/28/2011 11:25AM
Re: Data not balanced in partitions   758 Evan P 11/26/2011 12:34PM
Re: Data not balanced in partitions   949 Evan P 11/26/2011 12:51PM
can't create partitioning table   1,631 Jacky Shu 11/22/2011 10:26AM
Re: can't create partitioning table   683 Jacky Shu 11/24/2011 07:41AM
Re: can't create partitioning table   755 Rick James 11/24/2011 12:32AM
Partition Pruning   1,475 Scott Watson 11/14/2011 04:19PM
Re: Partition Pruning   837 Mattias Jonsson 11/21/2011 05:46AM
MyIsam partition by string   2,525 Chris XX 11/03/2011 09:32AM
Re: MyIsam partition by string   863 Mattias Jonsson 11/07/2011 03:12PM
Re: MyIsam partition by string   908 Rick James 11/05/2011 10:29PM
MySQl partitioning query issue   2,025 Madhu Venkatesh 11/02/2011 10:34AM
Re: MySQl partitioning query issue   833 Rick James 11/05/2011 08:42PM
Re: MySQl partitioning query issue   791 Madhu Venkatesh 11/02/2011 12:33PM
Partition Pruning Issue while using Day() function in Range   2,528 Battu Praveen Kumar 09/21/2011 04:00AM
Re: Partition Pruning Issue while using Day() function in Range   997 Rick James 09/23/2011 09:22AM
Re: Partition Pruning Issue while using Day() function in Range   1,239 Battu Praveen Kumar 10/02/2011 11:10PM
Re: Partition Pruning Issue while using Day() function in Range   993 Rick James 10/09/2011 01:44PM
Re: Partition Pruning Issue while using Day() function in Range   1,165 Mattias Jonsson 09/22/2011 03:36AM
Partition by State   2,485 Dustin Teter 07/11/2011 01:23PM
Re: Partition by State   837 nugik wibowo 09/24/2011 10:45AM
Re: Partition by State   1,035 Rick James 07/14/2011 01:16AM
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
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.