MySQL :: MySQL Forums :: Partitioning

Announcements	Last Post
• Announcing August 2026 Releases featuring MySQL Server, MySQL NDB Cluster, Shell and Connector/ODBC	08/25/2026 01:01AM

New Topic

Pages:

« 1 2 3 4 5

...

14 »

Subject

Views

Written By

Posted

Partition

3,961

Dhileepan M

08/10/2012 12:37AM

Re: Partition

2,218

Jonathan Stephens

08/11/2012 03:37AM

Re: Partition

1,999

Rick James

08/19/2012 03:18PM

Add new partition for Range by date

6,583

Mannoj Kumar

08/09/2012 04:05AM

Re: Add new partition for Range by date

2,233

Jonathan Stephens

08/12/2012 01:20AM

Re: Add new partition for Range by date

2,657

Rick James

08/18/2012 07:53PM

Re: Add new partition for Range by date

2,819

Rick James

08/10/2012 01:05AM

Re: Add new partition for Range by date

2,276

Mannoj Kumar

08/10/2012 03:17AM

Re: Add new partition for Range by date

2,592

Aftab Khan

08/12/2012 01:06AM

how to partition a table with string type unique column .

5,282

qufu dai

08/14/2012 01:40AM

Re: how to partition a table with string type unique column .

2,635

Mattias Jonsson

08/16/2012 02:16AM

Partition or not ?

3,419

Srikanth Mamidi

08/07/2012 12:58AM

Re: Partition or not ?

2,181

Rick James

08/09/2012 08:04PM

Partitioning with timestamp column

13,333

dileep ch

08/01/2012 10:25PM

Re: Partitioning with timestamp column

4,548

Rick James

08/02/2012 09:26PM

Re: Partitioning with timestamp column

4,235

dileep ch

08/02/2012 11:44PM

Re: Partitioning with timestamp column

5,404

Rick James

08/03/2012 07:30PM

Accessing more partitions than needed

3,150

dileep ch

07/19/2012 01:12AM

Re: Accessing more partitions than needed

1,719

Mattias Jonsson

07/19/2012 05:23AM

Upgrading 5.1 to 5.5

1,776

dileep ch

08/02/2012 12:18AM

Re: Upgrading 5.1 to 5.5

1,687

Mattias Jonsson

08/02/2012 02:44AM

Re: Accessing more partitions than needed

1,432

dileep ch

07/19/2012 06:01AM

Partition and subpartition are different column

3,119

Toeh Boot

07/23/2012 10:54AM

Re: Partition and subpartition are different column

1,976

Rick James

07/28/2012 12:42PM

Re: Partition and subpartition are different column

2,117

Mattias Jonsson

07/24/2012 04:57AM

MySQL 5.5.24 Server Crash

3,827

Bryce Byrd

07/13/2012 08:48AM

Re: MySQL 5.5.24 Server Crash

1,642

Mattias Jonsson

07/17/2012 02:30PM

Size of partition table space

8,857

gustavo guido

06/29/2012 02:46PM

Re: Size of partition table space

2,424

Aftab Khan

07/02/2012 07:46AM

Re: Size of partition table space

2,566

Rick James

07/03/2012 12:56PM

Re: Size of partition table space

2,920

Rick James

07/01/2012 12:32PM

Re: Size of partition table space

2,517

gustavo guido

07/02/2012 07:41AM

Exchange All Partitions

10,135

Rob Dukes

06/13/2012 05:36AM

Re: Exchange All Partitions

1,654

Mattias Jonsson

06/18/2012 04:01AM

Re: Exchange All Partitions

1,709

Rick James

06/15/2012 08:52PM

Re: Exchange All Partitions

1,553

Rob Dukes

06/17/2012 12:32AM

Re: Exchange All Partitions

1,707

Rick James

06/17/2012 07:51PM

Re: Exchange All Partitions

1,561

Rob Dukes

06/17/2012 10:34PM

Re: Exchange All Partitions

1,688

Rick James

06/19/2012 08:32AM

Fetching data from a particular partion in a table

8,226

Senthilnathan Thiyagarajan

05/17/2012 05:19AM

Re: Fetching data from a particular partion in a table

1,684

Mattias Jonsson

05/18/2012 11:29AM

Help in Paritioning the Table

2,870

Amar Sheth

05/07/2012 05:02AM

Re: Help in Paritioning the Table

1,955

Rick James

05/08/2012 09:29AM

Help to optimize subpartition

3,791

Paki Paki

04/19/2012 05:28AM

Re: Help to optimize subpartition

2,378

Rick James

04/20/2012 06:54PM

Re: Help to optimize subpartition

2,231

Paki Paki

04/21/2012 04:15PM

Re: Help to optimize subpartition

2,147

Mattias Jonsson

05/02/2012 07:59AM

Re: Help to optimize subpartition

1,730

Mattias Jonsson

05/02/2012 01:41PM

Partition problem (Data striping)

3,698

Randy Roadax

04/10/2012 07:09PM

Re: Partition problem (Data striping)

2,492

Mattias Jonsson

04/13/2012 08:08AM

Re: Partition problem (Data striping)

2,356

Randy Roadax

04/13/2012 03:20PM

Re: Partition problem (Data striping)

2,398

Mattias Jonsson

04/13/2012 04:17PM

Re: Partition problem (Data striping)

2,202

Randy Roadax

04/13/2012 04:36PM

Re: Partition problem (Data striping)

2,117

Mattias Jonsson

04/14/2012 05:25PM

Re: Partition problem (Data striping)

2,142

Rick James

04/12/2012 07:02PM

Re: Partition problem (Data striping)

2,126

Randy Roadax

04/12/2012 08:30PM

Re: Partition problem (Data striping)

2,169

Rick James

04/13/2012 04:49PM

Re: Partition problem (Data striping)

2,210

Randy Roadax

04/13/2012 06:18PM

key partition

3,075

jongse park

04/12/2012 06:28AM

Re: key partition

2,032

Rick James

04/13/2012 04:12PM

Re: key partition

2,156

Mattias Jonsson

04/13/2012 08:16AM

Partition using non primary key

4,195

dileep ch

04/04/2012 10:57PM

Re: Partition using non primary key

2,511

Rick James

04/05/2012 07:57PM

Rolling partitions

3,491

Piyush Maheshwari

03/29/2012 02:19AM

Re: Rolling partitions

2,138

Rick James

03/31/2012 11:22AM

When partition a table

3,793

David Simal González

03/28/2012 11:15AM

Re: When partition a table

2,193

Rick James

03/31/2012 06:53AM

partitions to quickly drop lots of data each month

4,147

Darren White

03/22/2012 02:20AM

Re: partitions to quickly drop lots of data each month

1,924

Rick James

03/22/2012 09:56PM

Move from unpartitioned database to partitioned database

4,617

Piyush Maheshwari

03/19/2012 07:43AM

Re: Move from unpartitioned database to partitioned database

2,470

Mattias Jonsson

03/20/2012 01:21AM

Re: Move from unpartitioned database to partitioned database

2,318

Piyush Maheshwari

03/20/2012 03:39AM

Re: Move from unpartitioned database to partitioned database

2,081

Mattias Jonsson

03/20/2012 03:56AM

Re: Move from unpartitioned database to partitioned database

3,149

Rick James

03/22/2012 07:48PM

list partitioning and range subpartitioning

2,627

jongse park

03/12/2012 02:35AM

Re: list partitioning and range subpartitioning

1,762

Mattias Jonsson

03/13/2012 07:23AM

I searched table on one partiton, but MySQL scanning two partitons

4,190

Yang Bingle

03/03/2012 04:01AM

Re: I searched table on one partiton, but MySQL scanning two partitons

2,071

Rick James

03/04/2012 02:28PM

I divided table on two parts, but MySQL scanning full table

4,158

oto shavadze

02/07/2012 11:27PM

Re: I divided table on two parts, but MySQL scanning full table

2,252

Rick James

02/08/2012 05:45PM

Re: I divided table on two parts, but MySQL scanning full table

2,230

oto shavadze

02/09/2012 11:12AM

Re: I divided table on two parts, but MySQL scanning full table

2,298

Rick James

02/11/2012 12:04AM

Re: I divided table on two parts, but MySQL scanning full table

2,120

oto shavadze

02/11/2012 01:10PM

KEY vs RANGE partitioning

4,450

Basilis Papadopoulos

02/08/2012 07:38AM

Re: KEY vs RANGE partitioning

2,377

Mattias Jonsson

02/09/2012 07:35AM

Re: KEY vs RANGE partitioning

2,167

Basilis Papadopoulos

02/09/2012 01:45AM

Re: KEY vs RANGE partitioning

2,423

Mattias Jonsson

02/09/2012 10:50AM

Re: KEY vs RANGE partitioning

2,267

Rick James

02/09/2012 04:22AM

How to divide the table into 1000 part

3,894

oto shavadze

02/06/2012 01:07AM

Re: How to divide the table into 1000 part

1,798

Rick James

02/07/2012 07:02PM

Re: How to divide the table into 1000 part

1,796

oto shavadze

02/08/2012 04:12AM

Suggestion for optimization - reg

3,787

suvendu mohapatra

01/23/2012 05:09AM

Re: Suggestion for optimization - reg

2,201

Rick James

01/24/2012 02:18AM

Re: Suggestion for optimization - reg

2,113

suvendu mohapatra

01/24/2012 06:50AM

Re: Suggestion for optimization - reg

2,001

Rick James

01/25/2012 09:09PM

Re: Suggestion for optimization - reg

1,982

suvendu mohapatra

01/26/2012 06:49AM

Re: Suggestion for optimization - reg

1,905

Rick James

01/26/2012 02:48PM

Re: Suggestion for optimization - reg

2,350

suvendu mohapatra

01/26/2012 04:32PM

Re: Suggestion for optimization - reg

2,037

Rick James

01/27/2012 08:41PM

Re: Suggestion for optimization - reg

2,076

suvendu mohapatra

01/25/2012 11:04PM

truncate partition not happening

4,247

samir devaliya

01/09/2012 08:06AM

Re: truncate partition not happening

2,362

Mattias Jonsson

01/12/2012 05:02AM

Re: truncate partition not happening

1,865

samir devaliya

01/13/2012 10:37PM

Re: truncate partition not happening

2,154

samir devaliya

01/16/2012 12:41AM

Re: truncate partition not happening

1,906

Mattias Jonsson

01/16/2012 04:22AM

Re: truncate partition not happening

1,928

Rick James

01/13/2012 09:58AM

Re: truncate partition not happening

2,432

Mattias Jonsson

01/13/2012 10:13AM

reorganize syntax / procedure

5,008

kevin foote

01/12/2012 03:36PM

Re: reorganize syntax / procedure

2,720

Rick James

01/13/2012 07:34PM

Re: reorganize syntax / procedure

5,507

Mattias Jonsson

01/13/2012 10:35AM

Re: reorganize syntax / procedure

2,224

kevin foote

01/13/2012 03:57PM

Best partitioning strategy VS shortest primary key

5,273

Jérémy Cohen Solal

12/19/2011 06:12AM

Re: Best partitioning strategy VS shortest primary key

2,598

Rick James

12/20/2011 10:31AM

Re: Best partitioning strategy VS shortest primary key

2,445

Jérémy Cohen Solal

12/21/2011 07:37AM

Re: Best partitioning strategy VS shortest primary key

2,790

Rick James

12/24/2011 03:03PM

partition with non primary key column

3,449

deva clementraj

12/09/2011 01:23AM

Re: partition with non primary key column

2,018

Rick James

12/13/2011 06:22PM

Re: partition with non primary key column

2,202

Mattias Jonsson

12/12/2011 06:34AM

Attaching a single partition to MySql on another server

3,265

Mirek K

11/29/2011 11:41AM

Re: Attaching a single partition to MySql on another server

2,156

Shantanu Oak

11/30/2011 05:00AM

Re: Attaching a single partition to MySql on another server

1,852

Mirek K

12/07/2011 03:48AM

Re: Attaching a single partition to MySql on another server

2,045

Mattias Jonsson

11/30/2011 02:24AM

Re: Attaching a single partition to MySql on another server

1,881

Mirek K

11/30/2011 06:02AM

Re: Attaching a single partition to MySql on another server

1,930

Mattias Jonsson

11/30/2011 06:12AM

Re: Attaching a single partition to MySql on another server

2,115

Rick James

11/30/2011 08:07PM

Partitioning Table - GPS Data

4,228

Daniel Alves

11/30/2011 01:53PM

Re: Partitioning Table - GPS Data

2,052

Daniel Alves

11/30/2011 03:15PM

Re: Partitioning Table - GPS Data

2,362

Rick James

12/01/2011 09:57PM

Re: Partitioning Table - GPS Data

1,909

Daniel Alves

12/02/2011 08:52AM

Re: Partitioning Table - GPS Data

1,958

Daniel Alves

12/02/2011 08:51AM

Re: Partitioning Table - GPS Data

2,086

Rick James

12/03/2011 10:26AM

Re: Partitioning Table - GPS Data

2,067

Daniel Alves

12/05/2011 05:43AM

Re: Partitioning Table - GPS Data

2,307

Rick James

12/06/2011 08:46PM

Multiple handlers per partition

2,757

Rolf Martin-Hoster

11/23/2011 10:26AM

Re: Multiple handlers per partition

1,814

Mattias Jonsson

11/30/2011 02:14AM

Data not balanced in partitions

3,417

Evan P

11/26/2011 05:41AM

Re: Data not balanced in partitions

1,931

Rick James

11/28/2011 11:25AM

Re: Data not balanced in partitions

1,705

Evan P

11/26/2011 12:34PM

Re: Data not balanced in partitions

2,035

Evan P

11/26/2011 12:51PM

can't create partitioning table

3,330

Jacky Shu

11/22/2011 10:26AM

Re: can't create partitioning table

1,558

Jacky Shu

11/24/2011 07:41AM

Re: can't create partitioning table

1,717

Rick James

11/24/2011 12:32AM

Partition Pruning

3,168

Scott Watson

11/14/2011 04:19PM

Re: Partition Pruning

1,732

Mattias Jonsson

11/21/2011 05:46AM

MyIsam partition by string

4,962

Chris XX

11/03/2011 09:32AM

Re: MyIsam partition by string

1,940

Mattias Jonsson

11/07/2011 03:12PM

Re: MyIsam partition by string

1,981

Rick James

11/05/2011 10:29PM

MySQl partitioning query issue

4,117

Madhu Venkatesh

11/02/2011 10:34AM

Re: MySQl partitioning query issue

1,831

Rick James

11/05/2011 08:42PM

Re: MySQl partitioning query issue

1,740

Madhu Venkatesh

11/02/2011 12:33PM

Partition Pruning Issue while using Day() function in Range

5,535

Battu Praveen Kumar

09/21/2011 04:00AM

Re: Partition Pruning Issue while using Day() function in Range

2,123

Rick James

09/23/2011 09:22AM

Re: Partition Pruning Issue while using Day() function in Range

2,749

Battu Praveen Kumar

10/02/2011 11:10PM

Re: Partition Pruning Issue while using Day() function in Range

2,329

Rick James

10/09/2011 01:44PM

Re: Partition Pruning Issue while using Day() function in Range

2,345

Mattias Jonsson

09/22/2011 03:36AM

Partition by State

4,641

Dustin Teter

07/11/2011 01:23PM

Re: Partition by State

1,928

nugik wibowo

09/24/2011 10:45AM

Re: Partition by State

2,171

Rick James

07/14/2011 01:16AM

Constant, random or timezone-dependent expressions in (sub)partitioning

9,567

Carlo Rossetti

09/18/2011 02:39AM

Re: Constant, random or timezone-dependent expressions in (sub)partitioning

3,518

Mattias Jonsson

09/19/2011 09:17AM

Re: Constant, random or timezone-dependent expressions in (sub)partitioning

2,435

Carlo Rossetti

09/19/2011 10:40AM

ALTER TABLE t_test ADD PARTITION BY LIST(field)?

6,535

Carlo Rossetti

09/18/2011 03:27AM

Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?

20,556

Mattias Jonsson

09/19/2011 09:10AM

Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?

3,553

Carlo Rossetti

09/19/2011 10:38AM

Question regarding Partitioning by key

3,751

kuku kuku

08/28/2011 03:47PM

Re: Question regarding Partitioning by key

1,891

Rick James

08/30/2011 09:35AM

Does my database server support partioning and Sharding

4,548

David Usherwood

08/26/2011 06:29AM

Re: Does my database server support partioning and Sharding

1,939

Rick James

08/27/2011 09:01AM

Re: Does my database server support partioning and Sharding

1,857

Liran Zelkha

08/29/2011 08:30AM

Can I add/change the number of hash subpartition?

4,760

Osamu Shibata

08/22/2011 12:11PM

Re: Can I add/change the number of hash subpartition?

2,832

Mattias Jonsson

08/26/2011 04:13AM

Re: Can I add/change the number of hash subpartition?

1,964

Rick James

08/25/2011 05:42PM

innodb_data_file_path and innodb_file_per_table

4,130

Rama Surendra Babu Gudimetla

08/25/2011 03:22AM

Re: innodb_data_file_path and innodb_file_per_table

2,068

Rick James

08/25/2011 10:27PM

ENUM partitioning options?

4,749

Nicholas Semenkovich

08/15/2011 10:48AM

Re: ENUM partitioning options?

2,069

Rick James

08/16/2011 09:50AM

Tablespace

3,863

katie c

08/05/2011 12:03AM

Re: Tablespace

1,673

Rick James

08/09/2011 07:29PM

500 mil. rows table partitioning

4,285

Misha Krassovski

06/27/2011 09:15AM