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

Storing tables on multiple partitions

3,040

sdgbfdsg fdhgfdhds

04/09/2014 08:04AM

Re: Storing tables on multiple partitions

1,806

Rick James

04/11/2014 04:32PM

Re: Storing tables on multiple partitions

1,640

mi Su

04/29/2014 01:09AM

MySql Horizontal partitioning - Pros-Cons

5,125

Manohar K

04/14/2014 11:43AM

Re: MySql Horizontal partitioning - Pros-Cons

2,572

Rick James

04/17/2014 11:16PM

Re: MySql Horizontal partitioning - Pros-Cons

1,942

Rick James

04/19/2014 03:42PM

Consumption of more hard disk space in "Copying to tmp table" phase

4,267

Raghavendra K

04/14/2014 01:07AM

Re: Consumption of more hard disk space in "Copying to tmp table" phase

1,725

Mattias Jonsson

04/14/2014 05:05PM

Re: Consumption of more hard disk space in "Copying to tmp table" phase

1,662

Raghavendra K

04/16/2014 06:40AM

Re: Consumption of more hard disk space in "Copying to tmp table" phase

1,657

Mattias Jonsson

04/17/2014 12:55PM

Re: Consumption of more hard disk space in "Copying to tmp table" phase

1,721

Rick James

04/17/2014 11:36PM

Failed to read from the .par file

17,919

IGG t

04/02/2014 09:49AM

Re: Failed to read from the .par file

8,864

Rick James

04/05/2014 01:13PM

How to extend partition when there is no unallocated space in hard disk?

3,010

mi Su

01/06/2014 01:21AM

Re: How to extend partition when there is no unallocated space in hard disk?

2,163

Rick James

01/08/2014 05:22PM

Partitioning or indexing for millions of records

3,472

Aamir Sohail

11/26/2013 05:44AM

Re: Partitioning or indexing for millions of records

2,522

Rick James

11/27/2013 12:39PM

Re: Partitioning or indexing for millions of records

2,038

Aamir Sohail

11/28/2013 12:40AM

Re: Partitioning or indexing for millions of records

2,129

Rick James

11/28/2013 09:07PM

Re: Partitioning or indexing for millions of records

2,031

Aamir Sohail

11/29/2013 04:11AM

Re: Partitioning or indexing for millions of records

1,982

Rick James

11/30/2013 01:30PM

Re: Partitioning or indexing for millions of records

1,777

chris arndt

12/31/2013 11:34AM

best way to take backup for old partition and create new one?

3,282

Aamir Sohail

12/04/2013 05:57AM

Re: best way to take backup for old partition and create new one?

1,727

Rick James

12/05/2013 12:15PM

Re: best way to take backup for old partition and create new one?

1,692

mi Su

12/10/2013 11:46PM

Re: best way to take backup for old partition and create new one?

1,651

Rick James

12/13/2013 12:51AM

Am I doing this correctly?

3,063

Jim Buckley Barrett

11/29/2013 05:03AM

Re: Am I doing this correctly?

1,776

Jim Buckley Barrett

11/29/2013 06:22AM

Re: Am I doing this correctly?

1,871

Rick James

11/30/2013 02:18PM

Re: Am I doing this correctly?

1,636

mi Su

12/04/2013 12:38AM

Re: Am I doing this correctly?

1,717

Jim Buckley Barrett

12/05/2013 03:48AM

Re: Am I doing this correctly?

1,805

Rick James

12/05/2013 10:21AM

Re: Am I doing this correctly?

1,690

Jim Buckley Barrett

12/10/2013 09:49AM

Re: Am I doing this correctly?

1,701

Jim Buckley Barrett

12/05/2013 03:51AM

error 1503: A primary key must include all columns in the table

17,562

Aamir Sohail

11/28/2013 01:28AM

Re: error 1503: A primary key must include all columns in the table

7,192

Rick James

11/29/2013 01:15AM

Re: error 1503: A primary key must include all columns in the table

4,385

Aamir Sohail

11/29/2013 04:19AM

Partition data backup and restore

11,210

Seungho Nam Nam

10/18/2013 12:48AM

Re: Partition data backup and restore

5,008

Mattias Jonsson

10/18/2013 02:59AM

Re: Partition data backup and restore

3,430

Steven Robinson

11/07/2013 11:29PM

Changing 5.1.61 Enterprise Commerical Build to allow partitioning

3,188

mark silverman

09/19/2013 08:11AM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,694

Rick James

09/24/2013 08:51PM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,761

Mattias Jonsson

10/04/2013 01:02AM

Reorganize Partition Syntax error

4,352

IGG t

09/16/2013 03:13AM

Re: Reorganize Partition Syntax error

1,573

IGG t

09/16/2013 09:39AM

Re: Reorganize Partition Syntax error

1,650

Rick James

09/17/2013 07:19PM

How to do partition for 100GB MySQL existing Table in zero downtime?

4,690

Prabhu Raja Singh

09/13/2013 01:40AM

Re: How to do partition for 100GB MySQL existing Table in zero downtime?

2,709

Rick James

09/15/2013 09:33PM

Re: How to do partition for 100GB MySQL existing Table in zero downtime?

2,372

Prabhu Raja Singh

09/16/2013 03:26AM

Partitioning by date, and maintaining uniqueness

7,143

IGG t

08/13/2013 09:51AM

Re: Partitioning by date, and maintaining uniqueness

1,916

Rick James

08/14/2013 09:20AM

Re: Partitioning by date, and maintaining uniqueness

1,828

IGG t

08/14/2013 10:28AM

Re: Partitioning by date, and maintaining uniqueness

1,846

Rick James

08/31/2013 05:35PM

mysql tables in use 500, locked 500

3,467

bruce.zuo bruce

07/16/2013 03:14AM

Re: mysql tables in use 500, locked 500

1,913

Rick James

07/21/2013 12:26AM

Re: mysql tables in use 500, locked 500

1,750

bruce.zuo bruce

07/24/2013 07:12AM

Re: mysql tables in use 500, locked 500

1,658

Mattias Jonsson

08/13/2013 05:42AM

Create index on partition table (manually and dynamically)

10,310

Vladimir Pivovar

07/05/2013 11:26PM

Re: Create index on parttion table (manually and dynamically)

3,240

Rick James

07/06/2013 10:52PM

Re: Create index on parttion table (manually and dynamically)

2,934

Vladimir Pivovar

07/07/2013 12:20AM

Re: Create index on parttion table (manually and dynamically)

2,545

Vladimir Pivovar

07/07/2013 10:57AM

Re: Create index on parttion table (manually and dynamically)

2,844

Rick James

07/08/2013 09:46AM

Re: Create index on partition table (manually and dynamically)

3,210

Vladimir Pivovar

07/10/2013 02:23PM

how to remove partitiong in mysql version5.6

3,381

heiansan white

06/13/2013 01:41AM

Re: how to remove partitiong in mysql version5.6

1,674

Rick James

06/15/2013 01:50PM

No. of partitions in NDB cluster

2,624

Alax James

05/31/2013 02:14AM

IP vs Date Partition

4,102

Tim Linden

05/13/2013 10:28AM

Re: IP vs Date Partition

2,076

Rick James

05/14/2013 09:59PM

Re: IP vs Date Partition

2,041

Tim Linden

05/15/2013 10:06AM

How should I partition this table?

4,036

Ron Bergin

04/26/2013 09:18AM

Re: How should I partition this table?

2,103

Rick James

04/27/2013 09:58PM

Re: How should I partition this table?

1,962

Ron Bergin

04/28/2013 11:29AM

Re: How should I partition this table?

1,904

Rick James

04/29/2013 08:10AM

Re: How should I partition this table?

1,867

Ron Bergin

04/30/2013 08:39AM

Re: How should I partition this table?

2,007

Rick James

05/01/2013 11:45PM

Re: How should I partition this table?

1,883

Ron Bergin

05/02/2013 08:17AM

Re: How should I partition this table?

1,755

Ron Bergin

05/02/2013 11:55AM

Re: How should I partition this table?

1,864

Rick James

05/03/2013 09:00AM

Re: How should I partition this table?

1,873

Ron Bergin

05/03/2013 09:32AM

Performance doubt

3,135

Xavier Borrut

03/26/2013 06:41AM

Re: Performance doubt

1,690

Rick James

03/28/2013 12:34AM

Re: Performance doubt

1,356

Mattias Jonsson

04/09/2013 01:49AM

Event add partition works but not the drop partition

3,366

Frwa Onto

04/04/2013 11:22PM

Re: Event add partition works but not the drop partition

1,600

Frwa Onto

04/05/2013 04:13AM

Should I partition?

3,119

Jacob Steinberger

03/19/2013 02:57PM

Re: Should I partition?

1,819

Rick James

03/21/2013 08:49PM

Re: Should I partition?

1,706

NOT_FOUND NOT_FOUND

04/03/2013 10:08AM

Re: Should I partition?

1,605

Rick James

04/04/2013 11:35PM

Partitioned table problem after upgrade to 5.5

3,256

Ming Wang

03/06/2013 04:07AM

Re: Partitioned table problem after upgrade to 5.5

1,698

Mattias Jonsson

03/06/2013 04:38AM

Re: Partitioned table problem after upgrade to 5.5

1,615

Ming Wang

03/07/2013 08:23PM

Re: Partitioned table problem after upgrade to 5.5

1,472

Rick James

03/07/2013 11:32PM

Re: Partitioned table problem after upgrade to 5.5

1,512

Mattias Jonsson

03/08/2013 02:20AM

If you use a partition table in mysql5.5, Contact function

2,888

kyung gi lee

02/25/2013 03:12AM

Re: If you use a partition table in mysql5.5, Contact function

1,711

Rick James

02/28/2013 09:34AM

How to (temporary) disable one partition in the partitioned table

3,595

First Bell

02/13/2013 11:01PM

Re: How to (temporary) disable one partition in the partitioned table

2,049

Rick James

02/22/2013 01:00AM

Re: How to (temporary) disable one partition in the partitioned table

2,290

Mattias Jonsson

02/28/2013 05:51AM

Index with partitioning

3,605

Hélio Hélio

01/30/2013 06:23AM

Re: Index with partitioning

2,126

Rick James

02/01/2013 10:20PM

Re: Index with partitioning

2,347

Hélio Hélio

02/04/2013 08:03AM

Re: Index with partitioning

2,024

Rick James

02/07/2013 10:09PM

Re: Index with partitioning

2,038

Hélio Hélio

02/08/2013 06:55AM

Re: Index with partitioning

1,962

Rick James

02/09/2013 01:22PM

Re: Index with partitioning

3,128

Hélio Hélio

02/14/2013 12:26PM

MySQL Partitioning showing low performance

3,240

Manosh Manohar

02/05/2013 12:10AM

Re: MySQL Partitioning showing low performance

1,736

Rick James

02/07/2013 10:14PM

Re: MySQL Partitioning showing low performance

1,615

Manosh Manohar

02/08/2013 12:39AM

How to let the query run on one partition

3,313

Shawn Liu

01/09/2013 08:29AM

Re: How to let the query run on one partition

1,741

Rick James

01/10/2013 08:45PM

How to partition by City \ State

4,138

Noah Goodrich

12/19/2012 10:06PM

Re: How to partition by City \ State

1,946

Rick James

12/20/2012 10:00PM

Partition behaiour seems abnormal in range partition

3,204

Rahul K K

12/10/2012 12:05AM

Re: Partition behaiour seems abnormal in range partition

1,692

Rick James

12/20/2012 02:56PM

partition by range on decimal type

6,846

Greg K

11/20/2012 07:15AM

Re: partition by range on decimal type

2,772

Rick James

11/21/2012 10:39AM

Re: partition by range on decimal type

2,129

Greg K

11/22/2012 02:26AM

Re: partition by range on decimal type

2,226

Rick James

11/22/2012 11:02PM

Re: partition by range on decimal type

2,224

Greg K

11/23/2012 12:45AM

Re: partition by range on decimal type

2,398

Rick James

11/23/2012 09:03PM

Fortnight partitions

4,700

Srikanth Mamidi

11/19/2012 11:24PM

Re: Fortnight partitions

2,759

Rick James

11/20/2012 10:56PM

Re: Fortnight partitions

1,903

Srikanth Mamidi

11/20/2012 11:23PM

Re: Fortnight partitions

1,975

Rick James

11/21/2012 08:54PM

Re: Fortnight partitions

1,945

Srikanth Mamidi

11/23/2012 12:04AM

milliseconds in mysql equivalent to java for Partitioning

4,668

Manjunath C

11/12/2012 01:36AM

Re: milliseconds in mysql equivalent to java for Partitioning

2,339

Rick James

11/13/2012 09:15AM

Re: milliseconds in mysql equivalent to java for Partitioning

1,998

Manjunath C

11/14/2012 04:17AM

Partitioning not working need primary key?

5,164

newbie Shai

10/20/2012 11:12AM

Re: Partitioning not working need primary key?

2,507

Mattias Jonsson

10/22/2012 07:14AM

Re: Partitioning not working need primary key?

2,201

newbie Shai

10/22/2012 11:59AM

Re: Partitioning not working need primary key?

2,227

Rick James

10/22/2012 09:37PM

Re: Partitioning not working need primary key?

2,332

newbie Shai

10/23/2012 08:36AM

Re: Partitioning not working need primary key?

2,200

Rick James

10/23/2012 09:50AM

Re: Partitioning not working need primary key?

2,222

newbie Shai

10/24/2012 09:05AM

Re: Partitioning not working need primary key?

2,236

Rick James

10/24/2012 09:26PM

Re: Partitioning not working need primary key?

2,191

newbie Shai

10/25/2012 09:45PM

Re: Partitioning not working need primary key?

7,618

Rick James

10/25/2012 11:22PM

Re: Partitioning not working need primary key?

2,216

newbie Shai

10/27/2012 07:21AM

Re: Partitioning not working need primary key?

2,137

Rick James

10/27/2012 12:01PM

Re: Partitioning not working need primary key?

2,087

newbie Shai

10/28/2012 12:10PM

Re: Partitioning not working need primary key?

2,170

Rick James

10/28/2012 02:12PM

Re: Partitioning not working need primary key?

2,248

newbie Shai

11/01/2012 10:55AM

Re: Partitioning not working need primary key?

7,469

Rick James

11/02/2012 12:37AM

Re: Partitioning not working need primary key?

2,048

newbie Shai

11/03/2012 10:37AM

Re: Partitioning not working need primary key?

2,116

Rick James

11/03/2012 11:37AM

Re: Partitioning not working need primary key?

2,037

newbie Shai

10/29/2012 06:51PM

Does partitioning make sense for this application?

3,703

Paul Schmehl

10/25/2012 08:46PM

Re: Does partitioning make sense for this application?

2,197

Rick James

10/26/2012 07:41PM

Re: Does partitioning make sense for this application?

2,400

Paul Schmehl

10/26/2012 09:55PM

Re: Does partitioning make sense for this application?

1,767

Rick James

10/27/2012 09:42PM

Re: Does partitioning make sense for this application?

1,775

Paul Schmehl

10/27/2012 10:41PM

Re: Does partitioning make sense for this application?

1,914

Rick James

10/28/2012 06:09PM

Re: Does partitioning make sense for this application?

1,738

Paul Schmehl

10/28/2012 08:58PM

Re: Does partitioning make sense for this application?

1,939

Rick James

10/30/2012 12:15PM

Programatic Partitioning

2,821

Jardel Morais

10/22/2012 04:44AM

Get partition name for specific date

3,407

Jan Bromberger

10/08/2012 12:48PM

Re: Get partition name for specific date

1,907

Rick James

10/09/2012 09:21AM

Re: Get partition name for specific date

1,793

Jan Bromberger

10/10/2012 03:18AM

Re: Get partition name for specific date

1,938

Rick James

10/11/2012 07:12PM

Row movement for MySQL partitionned tables

4,828

jongse park

10/10/2012 11:14PM

Re: Row movement for MySQL partitionned tables

2,242

Mattias Jonsson

10/11/2012 05:32AM

columns partitioning row inserted in wrong partition

3,393

martino merci

10/10/2012 02:54AM

Re: columns partitioning row inserted in wrong partition

1,710

Mattias Jonsson

10/10/2012 11:15AM

Regarding optimizing hugh data with mysql

3,040

Santosh Bhabal

10/08/2012 05:47AM

Re: Regarding optimizing hugh data with mysql

1,788

Rick James

10/09/2012 11:23PM

Partitioning by year/quarter

8,605

Ravi Malghan

09/24/2012 10:32AM

Re: Partitioning by year/quarter

3,662

Aftab Khan

09/27/2012 01:31PM

Re: Partitioning by year/quarter

2,617

Rick James

10/02/2012 09:15PM

Partitioning help

3,617

Naresh Kondeboina

09/25/2012 02:09PM

Re: Partitioning help

1,708

Aftab Khan

09/27/2012 01:12PM

Re: Partitioning help

1,775

Naresh Kondeboina

09/27/2012 08:38PM

Re: Partitioning help

1,647

Rick James

10/01/2012 11:54PM

Prunning partitions with range by date

3,365

Diogo Domanski

09/27/2012 01:18PM

Re: Prunning partitions with range by date

1,946

Aftab Khan

09/27/2012 01:39PM

Re: Prunning partitions with range by date (SOLVED)

1,773

Diogo Domanski

09/27/2012 03:00PM

What Method is Best

3,582

Larry Adams

09/12/2012 03:12PM

Re: What Method is Best

2,172

Mattias Jonsson

09/14/2012 02:36AM

Re: What Method is Best

1,992

Larry Adams

09/14/2012 05:30AM

Re: What Method is Best

1,897

Rick James

09/14/2012 11:11PM

timestamp, datetime as default value as current_timestamp [PARTITION]

6,364

Mannoj Kumar

08/29/2012 01:21AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,437

Aftab Khan

08/29/2012 04:21AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,339

Mattias Jonsson

08/31/2012 06:00PM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,119

Aftab Khan

09/03/2012 03:19AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

3,569

Mannoj Kumar

08/29/2012 04:32AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,273

Aftab Khan

08/29/2012 09:16AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,085

Mannoj Kumar

09/03/2012 11:26PM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,405

Rick James

09/04/2012 08:05PM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,293

Mannoj Kumar

09/07/2012 05:49AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,209

Rick James

08/30/2012 10:35PM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,030

Aftab Khan

08/31/2012 02:04AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,289

Rick James

08/31/2012 09:52AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,131

Mattias Jonsson

09/05/2012 12:36AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,051

Rick James

09/05/2012 08:29AM

Re: timestamp, datetime as default value as current_timestamp [PARTITION]

2,393

Aftab Khan

08/31/2012 01:58AM

Modify primary key for partitioning

3,485

Aurelien PANIZZA

08/10/2012 10:29AM