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
• MySQL Enterprise Monitor 3.4.3 has been released	09/22/2017 02:51PM
• MySQL Enterprise Monitor 3.3.5 has been released	09/22/2017 01:27PM
• MySQL Enterprise Monitor 3.2.9 has been released	09/22/2017 01:05PM
• MySQL Community Server 8.0.3-rc has been released (part 2/2)	09/21/2017 09:10AM
• MySQL Community Server 8.0.3-rc has been released (part 1/2)	09/21/2017 09:08AM

New Topic

Pages:

1 2 3 4 5

...

13 »

Subject

Views

Written By

Posted

Sticky: MySQL 5.7: InnoDB Native Partitioning (1 Posts)

3,155

Edwin Desouza

10/02/2014 09:56AM

Sticky: MySQL Partitioning: Articles, FAQs, Blogs (1 Posts)

18,223

Edwin DeSouza

05/23/2006 04:59PM

Unable to add parition using alter table

37

Samad Ul Haq

09/14/2017 03:43AM

table partitioning AWS MySQL - InnoDB

60

Ra Nala

09/09/2017 05:21AM

Re: table partitioning AWS MySQL - InnoDB

31

Øystein Grøvlen

09/11/2017 01:27AM

Re: table partitioning AWS MySQL - InnoDB

39

Ra Nala

09/11/2017 08:02AM

Partition by range (Every 500,000 records )

82

08/03/2017 02:32AM

myisam engine being deprecated

295

John Mirsberger

05/12/2017 09:02AM

Re: myisam engine being deprecated

155

Edwin Desouza

06/17/2017 01:18PM

Re: myisam engine being deprecated

76

John Mirsberger

06/20/2017 09:00AM

Re: myisam engine being deprecated

90

Peter Brawley

06/20/2017 09:18AM

Re: myisam engine being deprecated

78

John Mirsberger

06/20/2017 09:24AM

Re: myisam engine being deprecated

76

Edwin Desouza

06/20/2017 02:12PM

Re: myisam engine being deprecated

69

John Mirsberger

06/20/2017 02:23PM

Range Partition

159

Sam Mathews

06/17/2017 06:09AM

Re: Range Partition

87

Peter Brawley

06/17/2017 10:41AM

Re: Range Partition

68

Sam Mathews

06/18/2017 01:05AM

Re: Range Partition

76

Peter Brawley

06/18/2017 10:52AM

PARTITION dayofmonth invalid?

157

asd asd

05/09/2017 01:07AM

insert to a partitioned table with a unique key

176

Raghupradeep Aravindakshan

03/15/2017 06:50AM

MySQL 2 Subpartition

190

levent ayan

02/16/2017 12:06PM

Is partitioning likely useful for this application

365

Steve Fatula

01/13/2017 05:02PM

Re: Is partitioning likely useful for this application

282

Peter Brawley

01/13/2017 06:53PM

Re: Is partitioning likely useful for this application

207

Steve Fatula

01/14/2017 05:47PM

Re: Is partitioning likely useful for this application

207

Peter Brawley

01/14/2017 11:32PM

Slow query with a table converted to range partitioned table using timestamp as key

439

Benny Pei

01/10/2017 10:02AM

Re: Slow query with a table converted to range partitioned table using timestamp as key

266

Peter Brawley

01/10/2017 11:51AM

Re: Slow query with a table converted to range partitioned table using timestamp as key

268

Benny Pei

01/10/2017 12:06PM

Re: Slow query with a table converted to range partitioned table using timestamp as key

213

Peter Brawley

01/10/2017 12:12PM

How can i partition this table?

545

spalat palat

12/27/2016 02:27PM

Re: How can i partition this table?

350

Peter Brawley

12/27/2016 04:32PM

Re: How can i partition this table?

280

spalat palat

12/28/2016 06:37AM

Re: How can i partition this table?

261

Peter Brawley

12/28/2016 10:05AM

Re: How can i partition this table?

249

spalat palat

12/29/2016 06:52AM

Re: How can i partition this table?

205

Peter Brawley

01/10/2017 11:47AM

Count(*) query is slower on partitioned table

1,047

Darren Demicoli

12/03/2016 11:53AM

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

355

Rick James

12/10/2016 12:30AM

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

422

Darren Demicoli

12/10/2016 06:48AM

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

326

Rick James

12/12/2016 01:56PM

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

383

Darren Demicoli

12/13/2016 02:50PM

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

285

Rick James

12/21/2016 12:35AM

Performance with partition

591

Luciano Brandão lbrandao

11/18/2016 06:46PM

Re: Performance with partition

331

Rick James

11/19/2016 05:34PM

Query to a partitioned table using all partitions

724

Raghupradeep Aravindakshan

11/06/2016 11:22PM

Re: Query to a partitioned table using all partitions

346

Rick James

11/12/2016 05:55PM

Re: Query to a partitioned table using all partitions

314

Raghupradeep Aravindakshan

11/18/2016 03:16AM

Re: Query to a partitioned table using all partitions

264

Rick James

11/19/2016 03:42PM

Performance com partition

497

Luciano Brandão lbrandao

11/18/2016 06:41PM

Index on partitions

632

Rathi Rao

10/12/2016 06:57AM

Re: Index on partitions

300

Rick James

10/16/2016 03:33PM

Index management in a partitioned table

635

Rathi Rao

09/29/2016 12:14AM

Re: Index management in a partitioned table

418

Rick James

10/02/2016 12:40PM

Re: Index management in a partitioned table

327

Rathi Rao

10/03/2016 11:59PM

subpartition accross disk show error

531

Fei Tian

09/19/2016 05:23PM

Re: subpartition accross disk show error

349

Jon Stephens

09/20/2016 02:00AM

Re: subpartition accross disk show error

306

Fei Tian

09/20/2016 03:06AM

Re: subpartition accross disk show error

354

Jon Stephens

09/20/2016 11:42AM

Re: subpartition accross disk show error

336

Rick James

10/02/2016 12:58PM

what is user-defined partitioning

918

aaron chan

07/04/2016 07:33PM

Re: what is user-defined partitioning

563

Rick James

07/09/2016 10:53PM

Re: what is user-defined partitioning

519

Jon Stephens

07/12/2016 01:02AM

Re: what is user-defined partitioning

415

Rick James

07/15/2016 05:17PM

Re: what is user-defined partitioning

388

Jon Stephens

09/20/2016 03:36AM

Re: what is user-defined partitioning

377

Rick James

09/24/2016 04:40PM

Unable to EXCHANGE PARTITION when partition uses tablespace

868

bob Dave

06/02/2016 03:24AM

Create partition on non key column

753

Kapil Gupta

05/26/2016 05:51AM

Re: Create partition on non key column

457

Rick James

05/29/2016 12:28AM

MySql composite partitioning

1,060

Btissam Ghazi

03/08/2016 05:10PM

Re: MySql composite partitioning

577

Rick James

03/09/2016 06:59PM

MYSQL - CDC Capturing

1,455

Akshath Hegde

01/31/2016 11:48PM

Re: MYSQL - CDC Capturing

766

Rick James

02/01/2016 08:07PM

Re: MYSQL - CDC Capturing

703

Akshath Hegde

02/01/2016 09:43PM

Re: MYSQL - CDC Capturing

646

Rick James

02/02/2016 09:29PM

Re: MYSQL - CDC Capturing

682

Akshath Hegde

02/03/2016 12:23AM

Re: MYSQL - CDC Capturing

595

Rick James

02/04/2016 10:38PM

Partitioning of ndbcluster

1,006

Peter Mueller

01/04/2016 07:29AM

Re: Partitioning of ndbcluster

573

Rick James

01/05/2016 11:00PM

partition by varchar - random behavior?

1,080

mk mkrous

01/02/2016 02:07PM

Re: partition by varchar - random behavior?

542

Rick James

01/05/2016 10:55PM

Licensing requirements

1,137

Damien Kick

12/16/2015 03:18PM

Re: Licensing requirements

636

Damien Kick

12/16/2015 03:39PM

Re: Licensing requirements

614

Rick James

01/05/2016 10:59AM

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

2,121

MONU VERMA

11/20/2015 07:45AM

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

1,350

Rick James

12/17/2015 01:01PM

query optimization

1,240

Srilakshmi Manjunath

10/29/2015 03:08AM

Re: query optimization

683

Rick James

10/30/2015 04:58PM

Dose mysql partitioning support global index ?

1,452

jongse park

09/21/2015 07:31PM

Re: Dose mysql partitioning support global index ?

1,256

Jonathan Stephens

09/21/2015 11:30PM

Re: Dose mysql partitioning support global index ?

801

Rick James

10/02/2015 09:51PM

Should I PARTITION my table?

1,334

Rick James

10/01/2015 09:11PM

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

1,789

Akshath Hegde

08/23/2015 12:18AM

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

936

Rick James

08/23/2015 05:55PM

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

917

Akshath Hegde

08/26/2015 02:53AM

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

940

Rick James

08/27/2015 07:40AM

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

1,407

Sam Young

08/20/2015 08:00PM

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

867

Jonathan Stephens

08/21/2015 02:53AM

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

770

Sam Young

08/23/2015 08:57PM

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

754

Rick James

08/22/2015 03:35PM

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

715

Sam Young

08/23/2015 09:23PM

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

691

Rick James

08/24/2015 12:36PM

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

748

Sam Young

08/26/2015 12:53AM

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

759

Rick James

08/26/2015 10:02AM

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

712

Sam Young

08/26/2015 07:42PM

Dose MySQL support a dynamic pruning in mysql partitioning ?

1,411

jongse park

08/05/2015 08:41PM

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

731

Jonathan Stephens

08/06/2015 03:31AM

How to partition for performance

1,542

Doug Wolfgram

07/29/2015 09:42PM

Re: How to partition for performance

934

Rick James

07/31/2015 01:36PM

Re: How to partition for performance

882

Rick James

07/31/2015 02:23PM

Partition and Subpartition using Unixtime

1,408

Jaineera Naveen

07/09/2015 07:53AM

Re: Partition and Subpartition using Unixtime

739

Rick James

07/09/2015 11:59PM

Optimum partition for a bigger table

1,322

Jaineera Naveen

07/09/2015 12:35AM

Re: Optimum partition for a bigger table

780

Rick James

07/09/2015 11:36PM

Mysql 5.5 Partittioning row field

1,478

Shubham Jain

06/24/2015 10:19PM

Re: Mysql 5.5 Partittioning row field

1,060

Jonathan Stephens

06/25/2015 10:16AM

Re: Mysql 5.5 Partittioning row field

881

Rick James

06/26/2015 12:15AM

Re: Mysql 5.5 Partittioning row field

1,076

Jonathan Stephens

06/26/2015 02:40AM

Re: Mysql 5.5 Partittioning row field

901

Shubham Jain

06/26/2015 07:02AM

subpartiton by key doesn't evenly distribute data

1,437

jongse park

06/10/2015 11:20PM

Re: subpartiton by key doesn't evenly distribute data

752

Rick James

06/13/2015 08:25AM

Re: subpartiton by key doesn't evenly distribute data

797

jongse park

06/15/2015 12:01AM

Re: subpartiton by key doesn't evenly distribute data

744

Rick James

06/15/2015 07:07PM

Re: subpartiton by key doesn't evenly distribute data

849

jongse park

06/15/2015 10:41PM

Re: subpartiton by key doesn't evenly distribute data

791

Rick James

06/16/2015 07:36PM

Advice on partitioning

1,738

me su

04/24/2015 01:40PM

Re: Advice on partitioning

992

Rick James

04/24/2015 05:34PM

Re: Advice on partitioning

955

04/27/2015 09:05AM

Re: Advice on partitioning

989

Rick James

04/27/2015 02:22PM

Re: Advice on partitioning

827

Drew Morris

04/28/2015 11:02AM

Re: Advice on partitioning

860

Rick James

04/28/2015 12:32PM

Re: Advice on partitioning

894

04/28/2015 04:07PM

Re: Advice on partitioning

732

06/15/2015 06:39PM

Re: Advice on partitioning

882

Rick James

06/15/2015 07:05PM

Re: Advice on partitioning

837

06/16/2015 06:40PM

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

1,789

esha sethi

05/15/2015 11:49PM

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

1,077

Rick James

05/17/2015 12:04AM

Select using partition dynamically

1,759

Jose Lima

05/07/2015 06:21PM

Re: Select using partition dynamically

913

Rick James

05/11/2015 12:53PM

Partitioning & Replication

1,515

04/09/2015 06:30PM

Re: Partitioning & Replication

826

Rick James

04/12/2015 09:43PM

how to speed up for List partitioning table

1,801

jongse park

12/28/2014 07:59PM

Re: how to speed up for List partitioning table

986

Rick James

12/30/2014 03:05PM

wrong output generate while using partitions

2,042

Shivam Patel

12/13/2014 07:56AM

Re: wrong output generate while using partitions

1,056

Rick James

12/14/2014 10:33PM

Re: wrong output generate while using partitions

971

Shivam Patel

12/16/2014 01:24AM

Re: wrong output generate while using partitions

1,026

Jonathan Stephens

12/16/2014 02:32AM

Re: wrong output generate while using partitions

1,033

Shivam Patel

12/16/2014 04:00AM

Re: wrong output generate while using partitions

962

Rick James

12/16/2014 04:28PM

Re: wrong output generate while using partitions

1,065

Shivam Patel

12/17/2014 07:20AM

Re: wrong output generate while using partitions

1,080

Rick James

12/17/2014 11:27AM

large InnoDB table partitioning without explicit PK

2,677

Miko M

11/12/2014 07:41PM

Re: large InnoDB table partitioning without explicit PK

1,533

Rick James

11/13/2014 06:40PM

Re: large InnoDB table partitioning without explicit PK

1,372

Miko M

11/14/2014 03:02AM

Re: large InnoDB table partitioning without explicit PK

1,060

Rick James

11/15/2014 12:05AM

Re: large InnoDB table partitioning without explicit PK

1,096

Miko M

11/16/2014 07:39PM

Re: large InnoDB table partitioning without explicit PK

975

Rick James

11/17/2014 04:21PM

Re: large InnoDB table partitioning without explicit PK

1,072

Rick James

11/17/2014 07:48PM

Re: large InnoDB table partitioning without explicit PK

1,044

Miko M

11/18/2014 02:00AM

Re: large InnoDB table partitioning without explicit PK

1,085

Rick James

11/18/2014 11:35PM

Re: large InnoDB table partitioning without explicit PK

1,128

Miko M

11/22/2014 06:44AM

Re: large InnoDB table partitioning without explicit PK

1,026

Miko M

11/18/2014 01:13AM

(non-unique) index more efficient than partition pruning

1,246

Miko M

11/19/2014 12:27AM

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

1,105

Rick James

11/19/2014 06:01PM

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

1,148

Miko M

11/22/2014 08:39AM

Re: large InnoDB table partitioning without explicit PK

1,151

Miko M

11/14/2014 03:04AM

Re: large InnoDB table partitioning without explicit PK

1,212

Miko M

11/14/2014 03:05AM

Re: large InnoDB table partitioning without explicit PK

1,282

Rick James

11/15/2014 12:32AM

Re: large InnoDB table partitioning without explicit PK

1,242

Miko M

11/16/2014 08:31PM

Re: large InnoDB table partitioning without explicit PK

1,039

Rick James

11/19/2014 12:12AM

Re: large InnoDB table partitioning without explicit PK

1,029

Miko M

11/22/2014 09:07AM

Re: large InnoDB table partitioning without explicit PK

1,002

Rick James

11/23/2014 09:00PM

Re: large InnoDB table partitioning without explicit PK

1,093

Miko M

12/01/2014 11:16AM

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

2,271

Tom Song

10/21/2014 03:53AM

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

1,061

Tom Song

10/22/2014 11:58PM

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

1,022

Rick James

10/23/2014 04:36PM

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

1,022

Tom Song

10/24/2014 02:05AM

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

985

Mikael Ronström

11/13/2014 06:54AM

Partitioning on account_id

2,449

Ketil Stadskleiv

10/13/2014 02:54PM

Re: Partitioning on account_id

1,227

Rick James

10/14/2014 06:04PM

Range partition and unique key

2,031

09/24/2014 08:42AM

Re: Range partition and unique key

1,036

Rick James

09/25/2014 09:59AM

Re: Range partition and unique key

1,174

09/26/2014 03:40AM

Re: Range partition and unique key

1,124

Rick James

09/27/2014 08:25AM

Horizontal partitioning on a per user basis?

2,025

Peter Sarkozi

09/18/2014 05:40PM

Re: Horizontal partitioning on a per user basis?

1,050

Luke Taylor

09/19/2014 01:12AM

Re: Horizontal partitioning on a per user basis?

1,089

Rick James

09/19/2014 11:18PM

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

3,236

Raghavendra K

08/22/2014 12:37AM

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

1,237

Rick James

08/24/2014 09:14PM

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

1,213

Raghavendra K

08/25/2014 11:38AM

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

1,206

Rick James

08/26/2014 02:31PM

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

1,075

Raghavendra K

08/30/2014 03:43AM

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

1,197

Rick James

09/01/2014 08:28PM

Pages:

1 2 3 4 5

...

13 »

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.