MySQL :: MySQL Forums :: Partitioning

Announcements	Last Post
• Announcing April 2026 Releases featuring MySQL Server 9.7.0, 8.4.9 and 8.0.46	04/27/2026 03:22AM

New Topic

Pages:

« 1 2 3 4 5

...

14 »

Subject

Views

Written By

Posted

Partition

3,873

Dhileepan M

08/10/2012 12:37AM

Re: Partition

2,183

Jonathan Stephens

08/11/2012 03:37AM

Re: Partition

1,965

Rick James

08/19/2012 03:18PM

Add new partition for Range by date

6,469

Mannoj Kumar

08/09/2012 04:05AM

Re: Add new partition for Range by date

2,189

Jonathan Stephens

08/12/2012 01:20AM

Re: Add new partition for Range by date

2,622

Rick James

08/18/2012 07:53PM

Re: Add new partition for Range by date

2,773

Rick James

08/10/2012 01:05AM

Re: Add new partition for Range by date

2,230

Mannoj Kumar

08/10/2012 03:17AM

Re: Add new partition for Range by date

2,552

Aftab Khan

08/12/2012 01:06AM

how to partition a table with string type unique column .

5,203

qufu dai

08/14/2012 01:40AM

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

2,595

Mattias Jonsson

08/16/2012 02:16AM

Partition or not ?

3,376

Srikanth Mamidi

08/07/2012 12:58AM

Re: Partition or not ?

2,136

Rick James

08/09/2012 08:04PM

Partitioning with timestamp column

13,255

dileep ch

08/01/2012 10:25PM

Re: Partitioning with timestamp column

4,477

Rick James

08/02/2012 09:26PM

Re: Partitioning with timestamp column

4,199

dileep ch

08/02/2012 11:44PM

Re: Partitioning with timestamp column

5,336

Rick James

08/03/2012 07:30PM

Accessing more partitions than needed

3,092

dileep ch

07/19/2012 01:12AM

Re: Accessing more partitions than needed

1,687

Mattias Jonsson

07/19/2012 05:23AM

Upgrading 5.1 to 5.5

1,742

dileep ch

08/02/2012 12:18AM

Re: Upgrading 5.1 to 5.5

1,650

Mattias Jonsson

08/02/2012 02:44AM

Re: Accessing more partitions than needed

1,384

dileep ch

07/19/2012 06:01AM

Partition and subpartition are different column

3,051

Toeh Boot

07/23/2012 10:54AM

Re: Partition and subpartition are different column

1,897

Rick James

07/28/2012 12:42PM

Re: Partition and subpartition are different column

2,087

Mattias Jonsson

07/24/2012 04:57AM

MySQL 5.5.24 Server Crash

3,767

Bryce Byrd

07/13/2012 08:48AM

Re: MySQL 5.5.24 Server Crash

1,606

Mattias Jonsson

07/17/2012 02:30PM

Size of partition table space

8,554

gustavo guido

06/29/2012 02:46PM

Re: Size of partition table space

2,378

Aftab Khan

07/02/2012 07:46AM

Re: Size of partition table space

2,510

Rick James

07/03/2012 12:56PM

Re: Size of partition table space

2,877

Rick James

07/01/2012 12:32PM

Re: Size of partition table space

2,478

gustavo guido

07/02/2012 07:41AM

Exchange All Partitions

10,057

Rob Dukes

06/13/2012 05:36AM

Re: Exchange All Partitions

1,590

Mattias Jonsson

06/18/2012 04:01AM

Re: Exchange All Partitions

1,643

Rick James

06/15/2012 08:52PM

Re: Exchange All Partitions

1,512

Rob Dukes

06/17/2012 12:32AM

Re: Exchange All Partitions

1,663

Rick James

06/17/2012 07:51PM

Re: Exchange All Partitions

1,515

Rob Dukes

06/17/2012 10:34PM

Re: Exchange All Partitions

1,641

Rick James

06/19/2012 08:32AM

Fetching data from a particular partion in a table

8,141

Senthilnathan Thiyagarajan

05/17/2012 05:19AM

Re: Fetching data from a particular partion in a table

1,653

Mattias Jonsson

05/18/2012 11:29AM

Help in Paritioning the Table

2,810

Amar Sheth

05/07/2012 05:02AM

Re: Help in Paritioning the Table

1,919

Rick James

05/08/2012 09:29AM

Help to optimize subpartition

3,726

Paki Paki

04/19/2012 05:28AM

Re: Help to optimize subpartition

2,323

Rick James

04/20/2012 06:54PM

Re: Help to optimize subpartition

2,174

Paki Paki

04/21/2012 04:15PM

Re: Help to optimize subpartition

2,109

Mattias Jonsson

05/02/2012 07:59AM

Re: Help to optimize subpartition

1,698

Mattias Jonsson

05/02/2012 01:41PM

Partition problem (Data striping)

3,620

Randy Roadax

04/10/2012 07:09PM

Re: Partition problem (Data striping)

2,437

Mattias Jonsson

04/13/2012 08:08AM

Re: Partition problem (Data striping)

2,311

Randy Roadax

04/13/2012 03:20PM

Re: Partition problem (Data striping)

2,356

Mattias Jonsson

04/13/2012 04:17PM

Re: Partition problem (Data striping)

2,158

Randy Roadax

04/13/2012 04:36PM

Re: Partition problem (Data striping)

2,056

Mattias Jonsson

04/14/2012 05:25PM

Re: Partition problem (Data striping)

2,097

Rick James

04/12/2012 07:02PM

Re: Partition problem (Data striping)

2,061

Randy Roadax

04/12/2012 08:30PM

Re: Partition problem (Data striping)

2,102

Rick James

04/13/2012 04:49PM

Re: Partition problem (Data striping)

2,165

Randy Roadax

04/13/2012 06:18PM

key partition

2,982

jongse park

04/12/2012 06:28AM

Re: key partition

1,991

Rick James

04/13/2012 04:12PM

Re: key partition

2,110

Mattias Jonsson

04/13/2012 08:16AM

Partition using non primary key

4,131

dileep ch

04/04/2012 10:57PM

Re: Partition using non primary key

2,461

Rick James

04/05/2012 07:57PM

Rolling partitions

3,424

Piyush Maheshwari

03/29/2012 02:19AM

Re: Rolling partitions

2,095

Rick James

03/31/2012 11:22AM

When partition a table

3,599

David Simal González

03/28/2012 11:15AM

Re: When partition a table

2,151

Rick James

03/31/2012 06:53AM

partitions to quickly drop lots of data each month

3,980

Darren White

03/22/2012 02:20AM

Re: partitions to quickly drop lots of data each month

1,884

Rick James

03/22/2012 09:56PM

Move from unpartitioned database to partitioned database

4,519

Piyush Maheshwari

03/19/2012 07:43AM

Re: Move from unpartitioned database to partitioned database

2,406

Mattias Jonsson

03/20/2012 01:21AM

Re: Move from unpartitioned database to partitioned database

2,276

Piyush Maheshwari

03/20/2012 03:39AM

Re: Move from unpartitioned database to partitioned database

2,022

Mattias Jonsson

03/20/2012 03:56AM

Re: Move from unpartitioned database to partitioned database

3,097

Rick James

03/22/2012 07:48PM

list partitioning and range subpartitioning

2,551

jongse park

03/12/2012 02:35AM

Re: list partitioning and range subpartitioning

1,724

Mattias Jonsson

03/13/2012 07:23AM

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

4,085

Yang Bingle

03/03/2012 04:01AM

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

2,033

Rick James

03/04/2012 02:28PM

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

4,073

oto shavadze

02/07/2012 11:27PM

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

2,188

Rick James

02/08/2012 05:45PM

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

2,162

oto shavadze

02/09/2012 11:12AM

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

2,248

Rick James

02/11/2012 12:04AM

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

2,079

oto shavadze

02/11/2012 01:10PM

KEY vs RANGE partitioning

4,233

Basilis Papadopoulos

02/08/2012 07:38AM

Re: KEY vs RANGE partitioning

2,320

Mattias Jonsson

02/09/2012 07:35AM

Re: KEY vs RANGE partitioning

2,109

Basilis Papadopoulos

02/09/2012 01:45AM

Re: KEY vs RANGE partitioning

2,375

Mattias Jonsson

02/09/2012 10:50AM

Re: KEY vs RANGE partitioning

2,214

Rick James

02/09/2012 04:22AM

How to divide the table into 1000 part

3,812

oto shavadze

02/06/2012 01:07AM

Re: How to divide the table into 1000 part

1,739

Rick James

02/07/2012 07:02PM

Re: How to divide the table into 1000 part

1,751

oto shavadze

02/08/2012 04:12AM

Suggestion for optimization - reg

3,712

suvendu mohapatra

01/23/2012 05:09AM

Re: Suggestion for optimization - reg

2,135

Rick James

01/24/2012 02:18AM

Re: Suggestion for optimization - reg

2,061

suvendu mohapatra

01/24/2012 06:50AM

Re: Suggestion for optimization - reg

1,953

Rick James

01/25/2012 09:09PM

Re: Suggestion for optimization - reg

1,926

suvendu mohapatra

01/26/2012 06:49AM

Re: Suggestion for optimization - reg

1,842

Rick James

01/26/2012 02:48PM

Re: Suggestion for optimization - reg

2,291

suvendu mohapatra

01/26/2012 04:32PM

Re: Suggestion for optimization - reg

1,990

Rick James

01/27/2012 08:41PM

Re: Suggestion for optimization - reg

2,020

suvendu mohapatra

01/25/2012 11:04PM

truncate partition not happening

4,167

samir devaliya

01/09/2012 08:06AM

Re: truncate partition not happening

2,309

Mattias Jonsson

01/12/2012 05:02AM

Re: truncate partition not happening

1,817

samir devaliya

01/13/2012 10:37PM

Re: truncate partition not happening

2,105

samir devaliya

01/16/2012 12:41AM

Re: truncate partition not happening

1,861

Mattias Jonsson

01/16/2012 04:22AM

Re: truncate partition not happening

1,891

Rick James

01/13/2012 09:58AM

Re: truncate partition not happening

2,377

Mattias Jonsson

01/13/2012 10:13AM

reorganize syntax / procedure

4,908

kevin foote

01/12/2012 03:36PM

Re: reorganize syntax / procedure

2,676

Rick James

01/13/2012 07:34PM

Re: reorganize syntax / procedure

5,465

Mattias Jonsson

01/13/2012 10:35AM

Re: reorganize syntax / procedure

2,164

kevin foote

01/13/2012 03:57PM

Best partitioning strategy VS shortest primary key

5,165

Jérémy Cohen Solal

12/19/2011 06:12AM

Re: Best partitioning strategy VS shortest primary key

2,553

Rick James

12/20/2011 10:31AM

Re: Best partitioning strategy VS shortest primary key

2,390

Jérémy Cohen Solal

12/21/2011 07:37AM

Re: Best partitioning strategy VS shortest primary key

2,746

Rick James

12/24/2011 03:03PM

partition with non primary key column

3,331

deva clementraj

12/09/2011 01:23AM

Re: partition with non primary key column

1,925

Rick James

12/13/2011 06:22PM

Re: partition with non primary key column

2,156

Mattias Jonsson

12/12/2011 06:34AM

Attaching a single partition to MySql on another server

3,200

Mirek K

11/29/2011 11:41AM

Re: Attaching a single partition to MySql on another server

2,103

Shantanu Oak

11/30/2011 05:00AM

Re: Attaching a single partition to MySql on another server

1,816

Mirek K

12/07/2011 03:48AM

Re: Attaching a single partition to MySql on another server

1,984

Mattias Jonsson

11/30/2011 02:24AM

Re: Attaching a single partition to MySql on another server

1,821

Mirek K

11/30/2011 06:02AM

Re: Attaching a single partition to MySql on another server

1,874

Mattias Jonsson

11/30/2011 06:12AM

Re: Attaching a single partition to MySql on another server

2,063

Rick James

11/30/2011 08:07PM

Partitioning Table - GPS Data

4,141

Daniel Alves

11/30/2011 01:53PM

Re: Partitioning Table - GPS Data

1,992

Daniel Alves

11/30/2011 03:15PM

Re: Partitioning Table - GPS Data

2,312

Rick James

12/01/2011 09:57PM

Re: Partitioning Table - GPS Data

1,867

Daniel Alves

12/02/2011 08:52AM

Re: Partitioning Table - GPS Data

1,918

Daniel Alves

12/02/2011 08:51AM

Re: Partitioning Table - GPS Data

2,029

Rick James

12/03/2011 10:26AM

Re: Partitioning Table - GPS Data

2,016

Daniel Alves

12/05/2011 05:43AM

Re: Partitioning Table - GPS Data

2,272

Rick James

12/06/2011 08:46PM

Multiple handlers per partition

2,700

Rolf Martin-Hoster

11/23/2011 10:26AM

Re: Multiple handlers per partition

1,778

Mattias Jonsson

11/30/2011 02:14AM

Data not balanced in partitions

3,347

Evan P

11/26/2011 05:41AM

Re: Data not balanced in partitions

1,895

Rick James

11/28/2011 11:25AM

Re: Data not balanced in partitions

1,659

Evan P

11/26/2011 12:34PM

Re: Data not balanced in partitions

1,998

Evan P

11/26/2011 12:51PM

can't create partitioning table

3,266

Jacky Shu

11/22/2011 10:26AM

Re: can't create partitioning table

1,511

Jacky Shu

11/24/2011 07:41AM

Re: can't create partitioning table

1,671

Rick James

11/24/2011 12:32AM

Partition Pruning

3,077

Scott Watson

11/14/2011 04:19PM

Re: Partition Pruning

1,701

Mattias Jonsson

11/21/2011 05:46AM

MyIsam partition by string

4,849

Chris XX

11/03/2011 09:32AM

Re: MyIsam partition by string

1,880

Mattias Jonsson

11/07/2011 03:12PM

Re: MyIsam partition by string

1,924

Rick James

11/05/2011 10:29PM

MySQl partitioning query issue

4,042

Madhu Venkatesh

11/02/2011 10:34AM

Re: MySQl partitioning query issue

1,804

Rick James

11/05/2011 08:42PM

Re: MySQl partitioning query issue

1,669

Madhu Venkatesh

11/02/2011 12:33PM

Partition Pruning Issue while using Day() function in Range

5,288

Battu Praveen Kumar

09/21/2011 04:00AM

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

2,080

Rick James

09/23/2011 09:22AM

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

2,704

Battu Praveen Kumar

10/02/2011 11:10PM

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

2,275

Rick James

10/09/2011 01:44PM

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

2,316

Mattias Jonsson

09/22/2011 03:36AM

Partition by State

4,577

Dustin Teter

07/11/2011 01:23PM

Re: Partition by State

1,892

nugik wibowo

09/24/2011 10:45AM

Re: Partition by State

2,129

Rick James

07/14/2011 01:16AM

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

9,446

Carlo Rossetti

09/18/2011 02:39AM

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

3,476

Mattias Jonsson

09/19/2011 09:17AM

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

2,383

Carlo Rossetti

09/19/2011 10:40AM

ALTER TABLE t_test ADD PARTITION BY LIST(field)?

6,436

Carlo Rossetti

09/18/2011 03:27AM

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

20,498

Mattias Jonsson

09/19/2011 09:10AM

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

3,498

Carlo Rossetti

09/19/2011 10:38AM

Question regarding Partitioning by key

3,688

kuku kuku

08/28/2011 03:47PM

Re: Question regarding Partitioning by key

1,854

Rick James

08/30/2011 09:35AM

Does my database server support partioning and Sharding

4,469

David Usherwood

08/26/2011 06:29AM

Re: Does my database server support partioning and Sharding

1,885

Rick James

08/27/2011 09:01AM

Re: Does my database server support partioning and Sharding

1,810

Liran Zelkha

08/29/2011 08:30AM

Can I add/change the number of hash subpartition?

4,698

Osamu Shibata

08/22/2011 12:11PM

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

2,775

Mattias Jonsson

08/26/2011 04:13AM

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

1,906

Rick James

08/25/2011 05:42PM

innodb_data_file_path and innodb_file_per_table

4,063

Rama Surendra Babu Gudimetla

08/25/2011 03:22AM

Re: innodb_data_file_path and innodb_file_per_table

2,015

Rick James

08/25/2011 10:27PM

ENUM partitioning options?

4,657

Nicholas Semenkovich

08/15/2011 10:48AM

Re: ENUM partitioning options?

2,021

Rick James

08/16/2011 09:50AM

Tablespace

3,799

katie c

08/05/2011 12:03AM

Re: Tablespace

1,636

Rick James

08/09/2011 07:29PM

500 mil. rows table partitioning

4,202

Misha Krassovski

06/27/2011 09:15AM