MySQL :: MySQL Forums :: Partitioning

Announcements	Last Post
• Announcing January 2026 Releases featuring MySQL Server 9.6.0 Innovation, 8.4.8 LTS and 8.0.45	01/23/2026 11:56AM

New Topic

Pages:

« 1 2 3 4 5

...

14 »

Subject

Views

Written By

Posted

Partition

3,814

Dhileepan M

08/10/2012 12:37AM

Re: Partition

2,160

Jonathan Stephens

08/11/2012 03:37AM

Re: Partition

1,939

Rick James

08/19/2012 03:18PM

Add new partition for Range by date

6,373

Mannoj Kumar

08/09/2012 04:05AM

Re: Add new partition for Range by date

2,163

Jonathan Stephens

08/12/2012 01:20AM

Re: Add new partition for Range by date

2,598

Rick James

08/18/2012 07:53PM

Re: Add new partition for Range by date

2,753

Rick James

08/10/2012 01:05AM

Re: Add new partition for Range by date

2,206

Mannoj Kumar

08/10/2012 03:17AM

Re: Add new partition for Range by date

2,518

Aftab Khan

08/12/2012 01:06AM

how to partition a table with string type unique column .

5,139

qufu dai

08/14/2012 01:40AM

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

2,567

Mattias Jonsson

08/16/2012 02:16AM

Partition or not ?

3,324

Srikanth Mamidi

08/07/2012 12:58AM

Re: Partition or not ?

2,111

Rick James

08/09/2012 08:04PM

Partitioning with timestamp column

13,160

dileep ch

08/01/2012 10:25PM

Re: Partitioning with timestamp column

4,449

Rick James

08/02/2012 09:26PM

Re: Partitioning with timestamp column

4,179

dileep ch

08/02/2012 11:44PM

Re: Partitioning with timestamp column

5,298

Rick James

08/03/2012 07:30PM

Accessing more partitions than needed

3,044

dileep ch

07/19/2012 01:12AM

Re: Accessing more partitions than needed

1,662

Mattias Jonsson

07/19/2012 05:23AM

Upgrading 5.1 to 5.5

1,720

dileep ch

08/02/2012 12:18AM

Re: Upgrading 5.1 to 5.5

1,622

Mattias Jonsson

08/02/2012 02:44AM

Re: Accessing more partitions than needed

1,369

dileep ch

07/19/2012 06:01AM

Partition and subpartition are different column

3,002

Toeh Boot

07/23/2012 10:54AM

Re: Partition and subpartition are different column

1,874

Rick James

07/28/2012 12:42PM

Re: Partition and subpartition are different column

2,060

Mattias Jonsson

07/24/2012 04:57AM

MySQL 5.5.24 Server Crash

3,725

Bryce Byrd

07/13/2012 08:48AM

Re: MySQL 5.5.24 Server Crash

1,589

Mattias Jonsson

07/17/2012 02:30PM

Size of partition table space

8,414

gustavo guido

06/29/2012 02:46PM

Re: Size of partition table space

2,350

Aftab Khan

07/02/2012 07:46AM

Re: Size of partition table space

2,481

Rick James

07/03/2012 12:56PM

Re: Size of partition table space

2,836

Rick James

07/01/2012 12:32PM

Re: Size of partition table space

2,449

gustavo guido

07/02/2012 07:41AM

Exchange All Partitions

9,947

Rob Dukes

06/13/2012 05:36AM

Re: Exchange All Partitions

1,552

Mattias Jonsson

06/18/2012 04:01AM

Re: Exchange All Partitions

1,607

Rick James

06/15/2012 08:52PM

Re: Exchange All Partitions

1,486

Rob Dukes

06/17/2012 12:32AM

Re: Exchange All Partitions

1,634

Rick James

06/17/2012 07:51PM

Re: Exchange All Partitions

1,483

Rob Dukes

06/17/2012 10:34PM

Re: Exchange All Partitions

1,605

Rick James

06/19/2012 08:32AM

Fetching data from a particular partion in a table

8,101

Senthilnathan Thiyagarajan

05/17/2012 05:19AM

Re: Fetching data from a particular partion in a table

1,634

Mattias Jonsson

05/18/2012 11:29AM

Help in Paritioning the Table

2,761

Amar Sheth

05/07/2012 05:02AM

Re: Help in Paritioning the Table

1,900

Rick James

05/08/2012 09:29AM

Help to optimize subpartition

3,657

Paki Paki

04/19/2012 05:28AM

Re: Help to optimize subpartition

2,286

Rick James

04/20/2012 06:54PM

Re: Help to optimize subpartition

2,146

Paki Paki

04/21/2012 04:15PM

Re: Help to optimize subpartition

2,078

Mattias Jonsson

05/02/2012 07:59AM

Re: Help to optimize subpartition

1,677

Mattias Jonsson

05/02/2012 01:41PM

Partition problem (Data striping)

3,509

Randy Roadax

04/10/2012 07:09PM

Re: Partition problem (Data striping)

2,398

Mattias Jonsson

04/13/2012 08:08AM

Re: Partition problem (Data striping)

2,274

Randy Roadax

04/13/2012 03:20PM

Re: Partition problem (Data striping)

2,316

Mattias Jonsson

04/13/2012 04:17PM

Re: Partition problem (Data striping)

2,124

Randy Roadax

04/13/2012 04:36PM

Re: Partition problem (Data striping)

2,023

Mattias Jonsson

04/14/2012 05:25PM

Re: Partition problem (Data striping)

2,053

Rick James

04/12/2012 07:02PM

Re: Partition problem (Data striping)

2,021

Randy Roadax

04/12/2012 08:30PM

Re: Partition problem (Data striping)

2,066

Rick James

04/13/2012 04:49PM

Re: Partition problem (Data striping)

2,127

Randy Roadax

04/13/2012 06:18PM

key partition

2,923

jongse park

04/12/2012 06:28AM

Re: key partition

1,960

Rick James

04/13/2012 04:12PM

Re: key partition

2,088

Mattias Jonsson

04/13/2012 08:16AM

Partition using non primary key

4,083

dileep ch

04/04/2012 10:57PM

Re: Partition using non primary key

2,439

Rick James

04/05/2012 07:57PM

Rolling partitions

3,382

Piyush Maheshwari

03/29/2012 02:19AM

Re: Rolling partitions

2,083

Rick James

03/31/2012 11:22AM

When partition a table

3,541

David Simal González

03/28/2012 11:15AM

Re: When partition a table

2,123

Rick James

03/31/2012 06:53AM

partitions to quickly drop lots of data each month

3,821

Darren White

03/22/2012 02:20AM

Re: partitions to quickly drop lots of data each month

1,846

Rick James

03/22/2012 09:56PM

Move from unpartitioned database to partitioned database

4,333

Piyush Maheshwari

03/19/2012 07:43AM

Re: Move from unpartitioned database to partitioned database

2,379

Mattias Jonsson

03/20/2012 01:21AM

Re: Move from unpartitioned database to partitioned database

2,243

Piyush Maheshwari

03/20/2012 03:39AM

Re: Move from unpartitioned database to partitioned database

1,994

Mattias Jonsson

03/20/2012 03:56AM

Re: Move from unpartitioned database to partitioned database

3,045

Rick James

03/22/2012 07:48PM

list partitioning and range subpartitioning

2,506

jongse park

03/12/2012 02:35AM

Re: list partitioning and range subpartitioning

1,707

Mattias Jonsson

03/13/2012 07:23AM

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

4,026

Yang Bingle

03/03/2012 04:01AM

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

2,012

Rick James

03/04/2012 02:28PM

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

3,991

oto shavadze

02/07/2012 11:27PM

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

2,156

Rick James

02/08/2012 05:45PM

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

2,138

oto shavadze

02/09/2012 11:12AM

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

2,224

Rick James

02/11/2012 12:04AM

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

2,054

oto shavadze

02/11/2012 01:10PM

KEY vs RANGE partitioning

4,171

Basilis Papadopoulos

02/08/2012 07:38AM

Re: KEY vs RANGE partitioning

2,280

Mattias Jonsson

02/09/2012 07:35AM

Re: KEY vs RANGE partitioning

2,079

Basilis Papadopoulos

02/09/2012 01:45AM

Re: KEY vs RANGE partitioning

2,347

Mattias Jonsson

02/09/2012 10:50AM

Re: KEY vs RANGE partitioning

2,190

Rick James

02/09/2012 04:22AM

How to divide the table into 1000 part

3,752

oto shavadze

02/06/2012 01:07AM

Re: How to divide the table into 1000 part

1,705

Rick James

02/07/2012 07:02PM

Re: How to divide the table into 1000 part

1,728

oto shavadze

02/08/2012 04:12AM

Suggestion for optimization - reg

3,631

suvendu mohapatra

01/23/2012 05:09AM

Re: Suggestion for optimization - reg

2,090

Rick James

01/24/2012 02:18AM

Re: Suggestion for optimization - reg

2,030

suvendu mohapatra

01/24/2012 06:50AM

Re: Suggestion for optimization - reg

1,912

Rick James

01/25/2012 09:09PM

Re: Suggestion for optimization - reg

1,890

suvendu mohapatra

01/26/2012 06:49AM

Re: Suggestion for optimization - reg

1,805

Rick James

01/26/2012 02:48PM

Re: Suggestion for optimization - reg

2,261

suvendu mohapatra

01/26/2012 04:32PM

Re: Suggestion for optimization - reg

1,953

Rick James

01/27/2012 08:41PM

Re: Suggestion for optimization - reg

1,975

suvendu mohapatra

01/25/2012 11:04PM

truncate partition not happening

4,103

samir devaliya

01/09/2012 08:06AM

Re: truncate partition not happening

2,282

Mattias Jonsson

01/12/2012 05:02AM

Re: truncate partition not happening

1,789

samir devaliya

01/13/2012 10:37PM

Re: truncate partition not happening

2,074

samir devaliya

01/16/2012 12:41AM

Re: truncate partition not happening

1,836

Mattias Jonsson

01/16/2012 04:22AM

Re: truncate partition not happening

1,867

Rick James

01/13/2012 09:58AM

Re: truncate partition not happening

2,337

Mattias Jonsson

01/13/2012 10:13AM

reorganize syntax / procedure

4,821

kevin foote

01/12/2012 03:36PM

Re: reorganize syntax / procedure

2,641

Rick James

01/13/2012 07:34PM

Re: reorganize syntax / procedure

5,428

Mattias Jonsson

01/13/2012 10:35AM

Re: reorganize syntax / procedure

2,146

kevin foote

01/13/2012 03:57PM

Best partitioning strategy VS shortest primary key

5,104

Jérémy Cohen Solal

12/19/2011 06:12AM

Re: Best partitioning strategy VS shortest primary key

2,527

Rick James

12/20/2011 10:31AM

Re: Best partitioning strategy VS shortest primary key

2,367

Jérémy Cohen Solal

12/21/2011 07:37AM

Re: Best partitioning strategy VS shortest primary key

2,707

Rick James

12/24/2011 03:03PM

partition with non primary key column

3,244

deva clementraj

12/09/2011 01:23AM

Re: partition with non primary key column

1,901

Rick James

12/13/2011 06:22PM

Re: partition with non primary key column

2,123

Mattias Jonsson

12/12/2011 06:34AM

Attaching a single partition to MySql on another server

3,149

Mirek K

11/29/2011 11:41AM

Re: Attaching a single partition to MySql on another server

2,073

Shantanu Oak

11/30/2011 05:00AM

Re: Attaching a single partition to MySql on another server

1,789

Mirek K

12/07/2011 03:48AM

Re: Attaching a single partition to MySql on another server

1,959

Mattias Jonsson

11/30/2011 02:24AM

Re: Attaching a single partition to MySql on another server

1,800

Mirek K

11/30/2011 06:02AM

Re: Attaching a single partition to MySql on another server

1,851

Mattias Jonsson

11/30/2011 06:12AM

Re: Attaching a single partition to MySql on another server

2,040

Rick James

11/30/2011 08:07PM

Partitioning Table - GPS Data

4,053

Daniel Alves

11/30/2011 01:53PM

Re: Partitioning Table - GPS Data

1,968

Daniel Alves

11/30/2011 03:15PM

Re: Partitioning Table - GPS Data

2,287

Rick James

12/01/2011 09:57PM

Re: Partitioning Table - GPS Data

1,850

Daniel Alves

12/02/2011 08:52AM

Re: Partitioning Table - GPS Data

1,904

Daniel Alves

12/02/2011 08:51AM

Re: Partitioning Table - GPS Data

2,009

Rick James

12/03/2011 10:26AM

Re: Partitioning Table - GPS Data

1,989

Daniel Alves

12/05/2011 05:43AM

Re: Partitioning Table - GPS Data

2,243

Rick James

12/06/2011 08:46PM

Multiple handlers per partition

2,663

Rolf Martin-Hoster

11/23/2011 10:26AM

Re: Multiple handlers per partition

1,763

Mattias Jonsson

11/30/2011 02:14AM

Data not balanced in partitions

3,303

Evan P

11/26/2011 05:41AM

Re: Data not balanced in partitions

1,874

Rick James

11/28/2011 11:25AM

Re: Data not balanced in partitions

1,628

Evan P

11/26/2011 12:34PM

Re: Data not balanced in partitions

1,976

Evan P

11/26/2011 12:51PM

can't create partitioning table

3,208

Jacky Shu

11/22/2011 10:26AM

Re: can't create partitioning table

1,490

Jacky Shu

11/24/2011 07:41AM

Re: can't create partitioning table

1,638

Rick James

11/24/2011 12:32AM

Partition Pruning

3,031

Scott Watson

11/14/2011 04:19PM

Re: Partition Pruning

1,679

Mattias Jonsson

11/21/2011 05:46AM

MyIsam partition by string

4,809

Chris XX

11/03/2011 09:32AM

Re: MyIsam partition by string

1,863

Mattias Jonsson

11/07/2011 03:12PM

Re: MyIsam partition by string

1,902

Rick James

11/05/2011 10:29PM

MySQl partitioning query issue

3,992

Madhu Venkatesh

11/02/2011 10:34AM

Re: MySQl partitioning query issue

1,787

Rick James

11/05/2011 08:42PM

Re: MySQl partitioning query issue

1,652

Madhu Venkatesh

11/02/2011 12:33PM

Partition Pruning Issue while using Day() function in Range

5,010

Battu Praveen Kumar

09/21/2011 04:00AM

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

2,062

Rick James

09/23/2011 09:22AM

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

2,667

Battu Praveen Kumar

10/02/2011 11:10PM

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

2,246

Rick James

10/09/2011 01:44PM

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

2,293

Mattias Jonsson

09/22/2011 03:36AM

Partition by State

4,532

Dustin Teter

07/11/2011 01:23PM

Re: Partition by State

1,866

nugik wibowo

09/24/2011 10:45AM

Re: Partition by State

2,107

Rick James

07/14/2011 01:16AM

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

9,366

Carlo Rossetti

09/18/2011 02:39AM

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

3,437

Mattias Jonsson

09/19/2011 09:17AM

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

2,361

Carlo Rossetti

09/19/2011 10:40AM

ALTER TABLE t_test ADD PARTITION BY LIST(field)?

6,316

Carlo Rossetti

09/18/2011 03:27AM

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

20,456

Mattias Jonsson

09/19/2011 09:10AM

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

3,466

Carlo Rossetti

09/19/2011 10:38AM

Question regarding Partitioning by key

3,628

kuku kuku

08/28/2011 03:47PM

Re: Question regarding Partitioning by key

1,823

Rick James

08/30/2011 09:35AM

Does my database server support partioning and Sharding

4,408

David Usherwood

08/26/2011 06:29AM

Re: Does my database server support partioning and Sharding

1,854

Rick James

08/27/2011 09:01AM

Re: Does my database server support partioning and Sharding

1,782

Liran Zelkha

08/29/2011 08:30AM

Can I add/change the number of hash subpartition?

4,647

Osamu Shibata

08/22/2011 12:11PM

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

2,747

Mattias Jonsson

08/26/2011 04:13AM

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

1,888

Rick James

08/25/2011 05:42PM

innodb_data_file_path and innodb_file_per_table

4,015

Rama Surendra Babu Gudimetla

08/25/2011 03:22AM

Re: innodb_data_file_path and innodb_file_per_table

1,997

Rick James

08/25/2011 10:27PM

ENUM partitioning options?

4,599

Nicholas Semenkovich

08/15/2011 10:48AM

Re: ENUM partitioning options?

1,997

Rick James

08/16/2011 09:50AM

Tablespace

3,750

katie c

08/05/2011 12:03AM

Re: Tablespace

1,612

Rick James

08/09/2011 07:29PM

500 mil. rows table partitioning

4,120

Misha Krassovski

06/27/2011 09:15AM