MySQL :: MySQL Forums :: Partitioning

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

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

How can i partition this table?

3,280

spalat palat

12/27/2016 02:27PM

Re: How can i partition this table?

1,708

Peter Brawley

12/27/2016 04:32PM

Re: How can i partition this table?

1,607

spalat palat

12/28/2016 06:37AM

Re: How can i partition this table?

1,485

Peter Brawley

12/28/2016 10:05AM

Re: How can i partition this table?

1,768

spalat palat

12/29/2016 06:52AM

Re: How can i partition this table?

1,531

Peter Brawley

01/10/2017 11:47AM

Count(*) query is slower on partitioned table

9,522

Darren Demicoli

12/03/2016 11:53AM

Re: Count(*) query is slower on partitioned table

2,751

Rick James

12/10/2016 12:30AM

Re: Count(*) query is slower on partitioned table

2,562

Darren Demicoli

12/10/2016 06:48AM

Re: Count(*) query is slower on partitioned table

2,334

Rick James

12/12/2016 01:56PM

Re: Count(*) query is slower on partitioned table

2,475

Darren Demicoli

12/13/2016 02:50PM

Re: Count(*) query is slower on partitioned table

2,243

Rick James

12/21/2016 12:35AM

Performance with partition

2,482

Luciano Brandão lbrandao

11/18/2016 06:46PM

Re: Performance with partition

1,597

Rick James

11/19/2016 05:34PM

Query to a partitioned table using all partitions

3,434

Raghupradeep Aravindakshan

11/06/2016 11:22PM

Re: Query to a partitioned table using all partitions

1,702

Rick James

11/12/2016 05:55PM

Re: Query to a partitioned table using all partitions

1,424

Raghupradeep Aravindakshan

11/18/2016 03:16AM

Re: Query to a partitioned table using all partitions

1,441

Rick James

11/19/2016 03:42PM

Performance com partition

2,194

Luciano Brandão lbrandao

11/18/2016 06:41PM

Index on partitions

2,818

Rathi Rao

10/12/2016 06:57AM

Re: Index on partitions

1,419

Rick James

10/16/2016 03:33PM

Index management in a partitioned table

2,743

Rathi Rao

09/29/2016 12:14AM

Re: Index management in a partitioned table

1,569

Rick James

10/02/2016 12:40PM

Re: Index management in a partitioned table

1,325

Rathi Rao

10/03/2016 11:59PM

subpartition accross disk show error

2,912

Fei Tian

09/19/2016 05:23PM

Re: subpartition accross disk show error

1,386

Jon Stephens

09/20/2016 02:00AM

Re: subpartition accross disk show error

1,249

Fei Tian

09/20/2016 03:06AM

Re: subpartition accross disk show error

1,331

Jon Stephens

09/20/2016 11:42AM

Re: subpartition accross disk show error

1,382

Rick James

10/02/2016 12:58PM

what is user-defined partitioning

3,107

aaron chan

07/04/2016 07:33PM

Re: what is user-defined partitioning

1,723

Rick James

07/09/2016 10:53PM

Re: what is user-defined partitioning

1,652

Jon Stephens

07/12/2016 01:02AM

Re: what is user-defined partitioning

1,337

Rick James

07/15/2016 05:17PM

Re: what is user-defined partitioning

1,562

Jon Stephens

09/20/2016 03:36AM

Re: what is user-defined partitioning

1,326

Rick James

09/24/2016 04:40PM

Unable to EXCHANGE PARTITION when partition uses tablespace

2,648

bob Dave

06/02/2016 03:24AM

Create partition on non key column

2,506

Kapil Gupta

05/26/2016 05:51AM

Re: Create partition on non key column

1,352

Rick James

05/29/2016 12:28AM

MySql composite partitioning

3,086

Btissam Ghazi

03/08/2016 05:10PM

Re: MySql composite partitioning

1,521

Rick James

03/09/2016 06:59PM

MYSQL - CDC Capturing

5,824

Akshath Hegde

01/31/2016 11:48PM

Re: MYSQL - CDC Capturing

2,067

Rick James

02/01/2016 08:07PM

Re: MYSQL - CDC Capturing

1,850

Akshath Hegde

02/01/2016 09:43PM

Re: MYSQL - CDC Capturing

1,772

Rick James

02/02/2016 09:29PM

Re: MYSQL - CDC Capturing

1,978

Akshath Hegde

02/03/2016 12:23AM

Re: MYSQL - CDC Capturing

1,882

Rick James

02/04/2016 10:38PM

Partitioning of ndbcluster

2,855

Peter Mueller

01/04/2016 07:29AM

Re: Partitioning of ndbcluster

1,457

Rick James

01/05/2016 11:00PM

partition by varchar - random behavior?

3,513

mk mkrous

01/02/2016 02:07PM

Re: partition by varchar - random behavior?

1,691

Rick James

01/05/2016 10:55PM

Licensing requirements

2,776

Damien Kick

12/16/2015 03:18PM

Re: Licensing requirements

1,571

Damien Kick

12/16/2015 03:39PM

Re: Licensing requirements

1,419

Rick James

01/05/2016 10:59AM

Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails

8,540

MONU VERMA

11/20/2015 07:45AM

Re: Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails

5,599

Rick James

12/17/2015 01:01PM

query optimization

3,105

Srilakshmi Manjunath

10/29/2015 03:08AM

Re: query optimization

1,543

Rick James

10/30/2015 04:58PM

Dose mysql partitioning support global index ?

4,137

jongse park

09/21/2015 07:31PM

Re: Dose mysql partitioning support global index ?

2,575

Jonathan Stephens

09/21/2015 11:30PM

Re: Dose mysql partitioning support global index ?

1,958

Rick James

10/02/2015 09:51PM

Should I PARTITION my table?

2,828

Rick James

10/01/2015 09:11PM

Does Mysql Date Partition can be created on date time for every day???

5,033

Akshath Hegde

08/23/2015 12:18AM

Re: Does Mysql Date Partition can be created on date time for every day???

2,409

Rick James

08/23/2015 05:55PM

Re: Does Mysql Date Partition can be created on date time for every day???

2,777

Akshath Hegde

08/26/2015 02:53AM

Re: Does Mysql Date Partition can be created on date time for every day???

2,292

Rick James

08/27/2015 07:40AM

No other way than delete primary key to create partitions by single datetime columns?

3,011

Sam Young

08/20/2015 08:00PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1,795

Jonathan Stephens

08/21/2015 02:53AM

Re: No other way than delete primary key to create partitions by single datetime columns?

1,702

Sam Young

08/23/2015 08:57PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1,715

Rick James

08/22/2015 03:35PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1,636

Sam Young

08/23/2015 09:23PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1,697

Rick James

08/24/2015 12:36PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1,781

Sam Young

08/26/2015 12:53AM

Re: No other way than delete primary key to create partitions by single datetime columns?

1,749

Rick James

08/26/2015 10:02AM

Re: No other way than delete primary key to create partitions by single datetime columns?

1,630

Sam Young

08/26/2015 07:42PM

Dose MySQL support a dynamic pruning in mysql partitioning ?

2,518

jongse park

08/05/2015 08:41PM

Re: Dose MySQL support a dynamic pruning in mysql partitioning ?

1,513

Jonathan Stephens

08/06/2015 03:31AM

How to partition for performance

2,966

Doug Wolfgram

07/29/2015 09:42PM

Re: How to partition for performance

1,655

Rick James

07/31/2015 01:36PM

Re: How to partition for performance

1,674

Rick James

07/31/2015 02:23PM

Partition and Subpartition using Unixtime

2,606

Jaineera Naveen

07/09/2015 07:53AM

Re: Partition and Subpartition using Unixtime

2,297

Rick James

07/09/2015 11:59PM

Optimum partition for a bigger table

2,487

Jaineera Naveen

07/09/2015 12:35AM

Re: Optimum partition for a bigger table

1,541

Rick James

07/09/2015 11:36PM

Mysql 5.5 Partittioning row field

2,783

Shubham Jain

06/24/2015 10:19PM

Re: Mysql 5.5 Partittioning row field

1,838

Jonathan Stephens

06/25/2015 10:16AM

Re: Mysql 5.5 Partittioning row field

1,663

Rick James

06/26/2015 12:15AM

Re: Mysql 5.5 Partittioning row field

1,821

Jonathan Stephens

06/26/2015 02:40AM

Re: Mysql 5.5 Partittioning row field

1,568

Shubham Jain

06/26/2015 07:02AM

subpartiton by key doesn't evenly distribute data

2,721

jongse park

06/10/2015 11:20PM

Re: subpartiton by key doesn't evenly distribute data

1,412

Rick James

06/13/2015 08:25AM

Re: subpartiton by key doesn't evenly distribute data

1,502

jongse park

06/15/2015 12:01AM

Re: subpartiton by key doesn't evenly distribute data

1,416

Rick James

06/15/2015 07:07PM

Re: subpartiton by key doesn't evenly distribute data

1,639

jongse park

06/15/2015 10:41PM

Re: subpartiton by key doesn't evenly distribute data

1,490

Rick James

06/16/2015 07:36PM

Advice on partitioning

3,454

me su

04/24/2015 01:40PM

Re: Advice on partitioning

1,871

Rick James

04/24/2015 05:34PM

Re: Advice on partitioning

1,845

04/27/2015 09:05AM

Re: Advice on partitioning

1,892

Rick James

04/27/2015 02:22PM

Re: Advice on partitioning

1,643

Drew Morris

04/28/2015 11:02AM

Re: Advice on partitioning

1,692

Rick James

04/28/2015 12:32PM

Re: Advice on partitioning

1,629

04/28/2015 04:07PM

Re: Advice on partitioning

1,510

06/15/2015 06:39PM

Re: Advice on partitioning

1,658

Rick James

06/15/2015 07:05PM

Re: Advice on partitioning

1,615

06/16/2015 06:40PM

Partition by range for float data type column float(12,9) in mysql server 5.6

3,824

esha sethi

05/15/2015 11:49PM

Re: Partition by range for float data type column float(12,9) in mysql server 5.6

2,093

Rick James

05/17/2015 12:04AM

Select using partition dynamically

4,210

Jose Lima

05/07/2015 06:21PM

Re: Select using partition dynamically

2,065

Rick James

05/11/2015 12:53PM

Partitioning & Replication

2,631

04/09/2015 06:30PM

Re: Partitioning & Replication

1,407

Rick James

04/12/2015 09:43PM

how to speed up for List partitioning table

3,049

jongse park

12/28/2014 07:59PM

Re: how to speed up for List partitioning table

2,534

Rick James

12/30/2014 03:05PM

wrong output generate while using partitions

3,286

Shivam Patel

12/13/2014 07:56AM

Re: wrong output generate while using partitions

1,887

Rick James

12/14/2014 10:33PM

Re: wrong output generate while using partitions

1,716

Shivam Patel

12/16/2014 01:24AM

Re: wrong output generate while using partitions

1,804

Jonathan Stephens

12/16/2014 02:32AM

Re: wrong output generate while using partitions

1,805

Shivam Patel

12/16/2014 04:00AM

Re: wrong output generate while using partitions

1,643

Rick James

12/16/2014 04:28PM

Re: wrong output generate while using partitions

1,855

Shivam Patel

12/17/2014 07:20AM

Re: wrong output generate while using partitions

1,842

Rick James

12/17/2014 11:27AM

large InnoDB table partitioning without explicit PK

5,546

Miko M

11/12/2014 07:41PM

Re: large InnoDB table partitioning without explicit PK

2,616

Rick James

11/13/2014 06:40PM

Re: large InnoDB table partitioning without explicit PK

2,480

Miko M

11/14/2014 03:02AM

Re: large InnoDB table partitioning without explicit PK

1,900

Rick James

11/15/2014 12:05AM

Re: large InnoDB table partitioning without explicit PK

1,975

Miko M

11/16/2014 07:39PM

Re: large InnoDB table partitioning without explicit PK

1,894

Rick James

11/17/2014 04:21PM

Re: large InnoDB table partitioning without explicit PK

1,935

Rick James

11/17/2014 07:48PM

Re: large InnoDB table partitioning without explicit PK

1,935

Miko M

11/18/2014 02:00AM

Re: large InnoDB table partitioning without explicit PK

2,009

Rick James

11/18/2014 11:35PM

Re: large InnoDB table partitioning without explicit PK

2,016

Miko M

11/22/2014 06:44AM

Re: large InnoDB table partitioning without explicit PK

1,846

Miko M

11/18/2014 01:13AM

(non-unique) index more efficient than partition pruning

2,358

Miko M

11/19/2014 12:27AM

Re: (non-unique) index more efficient than partition pruning

2,114

Rick James

11/19/2014 06:01PM

Re: (non-unique) index more efficient than partition pruning

2,214

Miko M

11/22/2014 08:39AM

Re: large InnoDB table partitioning without explicit PK

2,225

Miko M

11/14/2014 03:04AM

Re: large InnoDB table partitioning without explicit PK

2,211

Miko M

11/14/2014 03:05AM

Re: large InnoDB table partitioning without explicit PK

2,227

Rick James

11/15/2014 12:32AM

Re: large InnoDB table partitioning without explicit PK

2,214

Miko M

11/16/2014 08:31PM

Re: large InnoDB table partitioning without explicit PK

2,098

Rick James

11/19/2014 12:12AM

Re: large InnoDB table partitioning without explicit PK

1,915

Miko M

11/22/2014 09:07AM

Re: large InnoDB table partitioning without explicit PK

1,941

Rick James

11/23/2014 09:00PM

Re: large InnoDB table partitioning without explicit PK

2,076

Miko M

12/01/2014 11:16AM

Online Partition addition use "add partition" clause or "reorganize" clause?

3,505

Tom Song

10/21/2014 03:53AM

Re: Online Partition addition use "add partition" clause or "reorganize" clause?

1,739

Tom Song

10/22/2014 11:58PM

Re: Online Partition addition use "add partition" clause or "reorganize" clause?

1,740

Rick James

10/23/2014 04:36PM

Re: Online Partition addition use "add partition" clause or "reorganize" clause?

1,692

Tom Song

10/24/2014 02:05AM

Re: Online Partition addition use "add partition" clause or "reorganize" clause?

1,673

Mikael Ronström

11/13/2014 06:54AM

Partitioning on account_id

3,722

Ketil Stadskleiv

10/13/2014 02:54PM

Re: Partitioning on account_id

1,912

Rick James

10/14/2014 06:04PM

Range partition and unique key

3,422

09/24/2014 08:42AM

Re: Range partition and unique key

1,813

Rick James

09/25/2014 09:59AM

Re: Range partition and unique key

1,845

09/26/2014 03:40AM

Re: Range partition and unique key

1,880

Rick James

09/27/2014 08:25AM

Horizontal partitioning on a per user basis?

3,085

Peter Sarkozi

09/18/2014 05:40PM

Re: Horizontal partitioning on a per user basis?

1,583

Luke Taylor

09/19/2014 01:12AM

Re: Horizontal partitioning on a per user basis?

1,681

Rick James

09/19/2014 11:18PM

ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)

6,270

Raghavendra K

08/22/2014 12:37AM

Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)

2,223

Rick James

08/24/2014 09:14PM

Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)

2,203

Raghavendra K

08/25/2014 11:38AM

Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)

2,143

Rick James

08/26/2014 02:31PM

Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)

2,032

Raghavendra K

08/30/2014 03:43AM

Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)

2,187

Rick James

09/01/2014 08:28PM

Not Taking Paritioning when using Subquery or Join

3,249

Marc Vettorel

08/27/2014 07:08AM

Re: Not Taking Paritioning when using Subquery or Join

1,668

Marc Vettorel

08/27/2014 07:19AM

Re: Not Taking Paritioning when using Subquery or Join

1,746

Rick James

08/28/2014 10:19AM

EXCHANGE PARTITION and DATA DIRECTORY errors

4,524

Ekundayo Lasode

08/16/2014 09:47AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

2,052

Mattias Jonsson

08/19/2014 03:32AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,912

Ekundayo Lasode

08/19/2014 06:28AM

Storing time series data using partitioning

4,730

Florian Rampp

08/14/2014 05:45AM

Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"

3,289

Jon Jacob

07/20/2014 07:50AM

Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"

1,774

Rick James

07/21/2014 06:50PM

Range partitioning on floor (decimal(14.4)) doesn't work :/

3,203

Max Herman

07/12/2014 12:35PM

Re: Range partitioning on floor (decimal(14.4)) doesn't work :/

1,843

Rick James

07/14/2014 06:45PM

why explain partition shows first partition in every select query?

3,666

Aamir Sohail

05/27/2014 07:18AM

Re: why explain partition shows first partition in every select query?

1,925

Rick James

05/27/2014 03:10PM

Re: why explain partition shows first partition in every select query?

1,766

Aamir Sohail

05/28/2014 12:52AM

Storing, accessing and configuring my partitions in diferent servers

2,932

Victor Bombella

05/23/2014 11:54PM

Re: Storing, accessing and configuring my partitions in diferent servers

1,553

Rick James

05/25/2014 04:57PM

missing data after partitioning - bug?

3,868

rol and

05/23/2014 12:51PM

Re: missing data after partitioning - bug?

1,702

Rick James

05/25/2014 04:27PM

MySql Partitioning problem (bug?)

7,649

K T

05/07/2014 04:39PM

Re: MySql Partitioning problem (bug?)

1,782

Rick James

05/09/2014 11:59PM

Re: MySql Partitioning problem (bug?)

1,740

K T

05/10/2014 03:41PM

Re: MySql Partitioning problem (bug?)

1,647

K T

05/10/2014 03:44PM

Re: MySql Partitioning problem (bug?)

1,805

Mattias Jonsson

05/16/2014 06:15AM

MySQL partition by range on YEAR(date) weird results

4,011

Adelin Feraru

05/12/2014 02:15AM

Re: MySQL partition by range on YEAR(date) weird results

1,830

Rick James

05/15/2014 12:01AM

Re: MySQL partition by range on YEAR(date) weird results

1,730

Adelin Feraru

05/15/2014 03:38AM

Re: MySQL partition by range on YEAR(date) weird results

1,694

Mattias Jonsson

05/15/2014 11:42AM

Pages:

« 1 2 3 4 5

...

14 »

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.