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 Connector/C 6.1.11 GA has been released	07/24/2017 10:19AM
• MySQL Router 2.1.4 GA has been released	07/24/2017 09:15AM
• MySQL Connector/ODBC 5.3.9 has been released	07/24/2017 08:59AM
• MySQL Connector/J 5.1.43 has been released	07/21/2017 02:07PM
• MySQL Cluster 7.5.7 has been released	07/19/2017 04:43AM

New Topic

Pages:

1 2 3 4 5

...

13 »

Subject

Views

Written By

Posted

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

3,023

Edwin Desouza

10/02/2014 09:56AM

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

18,151

Edwin DeSouza

05/23/2006 04:59PM

myisam engine being deprecated

162

John Mirsberger

05/12/2017 09:02AM

Re: myisam engine being deprecated

80

Edwin Desouza

06/17/2017 01:18PM

Re: myisam engine being deprecated

37

John Mirsberger

06/20/2017 09:00AM

Re: myisam engine being deprecated

47

Peter Brawley

06/20/2017 09:18AM

Re: myisam engine being deprecated

31

John Mirsberger

06/20/2017 09:24AM

Re: myisam engine being deprecated

35

Edwin Desouza

06/20/2017 02:12PM

Re: myisam engine being deprecated

27

John Mirsberger

06/20/2017 02:23PM

Range Partition

100

Sam Mathews

06/17/2017 06:09AM

Re: Range Partition

46

Peter Brawley

06/17/2017 10:41AM

Re: Range Partition

37

Sam Mathews

06/18/2017 01:05AM

Re: Range Partition

42

Peter Brawley

06/18/2017 10:52AM

PARTITION dayofmonth invalid?

97

asd asd

05/09/2017 01:07AM

insert to a partitioned table with a unique key

137

Raghupradeep Aravindakshan

03/15/2017 06:50AM

MySQL 2 Subpartition

157

levent ayan

02/16/2017 12:06PM

Is partitioning likely useful for this application

325

Steve Fatula

01/13/2017 05:02PM

Re: Is partitioning likely useful for this application

249

Peter Brawley

01/13/2017 06:53PM

Re: Is partitioning likely useful for this application

182

Steve Fatula

01/14/2017 05:47PM

Re: Is partitioning likely useful for this application

180

Peter Brawley

01/14/2017 11:32PM

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

371

Benny Pei

01/10/2017 10:02AM

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

231

Peter Brawley

01/10/2017 11:51AM

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

231

Benny Pei

01/10/2017 12:06PM

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

175

Peter Brawley

01/10/2017 12:12PM

How can i partition this table?

488

spalat palat

12/27/2016 02:27PM

Re: How can i partition this table?

314

Peter Brawley

12/27/2016 04:32PM

Re: How can i partition this table?

246

spalat palat

12/28/2016 06:37AM

Re: How can i partition this table?

227

Peter Brawley

12/28/2016 10:05AM

Re: How can i partition this table?

217

spalat palat

12/29/2016 06:52AM

Re: How can i partition this table?

180

Peter Brawley

01/10/2017 11:47AM

Count(*) query is slower on partitioned table

901

Darren Demicoli

12/03/2016 11:53AM

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

304

Rick James

12/10/2016 12:30AM

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

378

Darren Demicoli

12/10/2016 06:48AM

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

293

Rick James

12/12/2016 01:56PM

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

331

Darren Demicoli

12/13/2016 02:50PM

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

248

Rick James

12/21/2016 12:35AM

Performance with partition

530

Luciano Brandão lbrandao

11/18/2016 06:46PM

Re: Performance with partition

294

Rick James

11/19/2016 05:34PM

Query to a partitioned table using all partitions

541

Raghupradeep Aravindakshan

11/06/2016 11:22PM

Re: Query to a partitioned table using all partitions

311

Rick James

11/12/2016 05:55PM

Re: Query to a partitioned table using all partitions

286

Raghupradeep Aravindakshan

11/18/2016 03:16AM

Re: Query to a partitioned table using all partitions

241

Rick James

11/19/2016 03:42PM

Performance com partition

465

Luciano Brandão lbrandao

11/18/2016 06:41PM

Index on partitions

577

Rathi Rao

10/12/2016 06:57AM

Re: Index on partitions

272

Rick James

10/16/2016 03:33PM

Index management in a partitioned table

574

Rathi Rao

09/29/2016 12:14AM

Re: Index management in a partitioned table

375

Rick James

10/02/2016 12:40PM

Re: Index management in a partitioned table

292

Rathi Rao

10/03/2016 11:59PM

subpartition accross disk show error

486

Fei Tian

09/19/2016 05:23PM

Re: subpartition accross disk show error

307

Jon Stephens

09/20/2016 02:00AM

Re: subpartition accross disk show error

280

Fei Tian

09/20/2016 03:06AM

Re: subpartition accross disk show error

317

Jon Stephens

09/20/2016 11:42AM

Re: subpartition accross disk show error

304

Rick James

10/02/2016 12:58PM

what is user-defined partitioning

827

aaron chan

07/04/2016 07:33PM

Re: what is user-defined partitioning

533

Rick James

07/09/2016 10:53PM

Re: what is user-defined partitioning

426

Jon Stephens

07/12/2016 01:02AM

Re: what is user-defined partitioning

393

Rick James

07/15/2016 05:17PM

Re: what is user-defined partitioning

344

Jon Stephens

09/20/2016 03:36AM

Re: what is user-defined partitioning

351

Rick James

09/24/2016 04:40PM

Unable to EXCHANGE PARTITION when partition uses tablespace

816

bob Dave

06/02/2016 03:24AM

Create partition on non key column

722

Kapil Gupta

05/26/2016 05:51AM

Re: Create partition on non key column

442

Rick James

05/29/2016 12:28AM

MySql composite partitioning

1,002

Btissam Ghazi

03/08/2016 05:10PM

Re: MySql composite partitioning

543

Rick James

03/09/2016 06:59PM

MYSQL - CDC Capturing

1,391

Akshath Hegde

01/31/2016 11:48PM

Re: MYSQL - CDC Capturing

710

Rick James

02/01/2016 08:07PM

Re: MYSQL - CDC Capturing

681

Akshath Hegde

02/01/2016 09:43PM

Re: MYSQL - CDC Capturing

620

Rick James

02/02/2016 09:29PM

Re: MYSQL - CDC Capturing

652

Akshath Hegde

02/03/2016 12:23AM

Re: MYSQL - CDC Capturing

565

Rick James

02/04/2016 10:38PM

Partitioning of ndbcluster

968

Peter Mueller

01/04/2016 07:29AM

Re: Partitioning of ndbcluster

552

Rick James

01/05/2016 11:00PM

partition by varchar - random behavior?

1,041

mk mkrous

01/02/2016 02:07PM

Re: partition by varchar - random behavior?

524

Rick James

01/05/2016 10:55PM

Licensing requirements

1,111

Damien Kick

12/16/2015 03:18PM

Re: Licensing requirements

615

Damien Kick

12/16/2015 03:39PM

Re: Licensing requirements

584

Rick James

01/05/2016 10:59AM

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

2,040

MONU VERMA

11/20/2015 07:45AM

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

1,261

Rick James

12/17/2015 01:01PM

query optimization

1,209

Srilakshmi Manjunath

10/29/2015 03:08AM

Re: query optimization

660

Rick James

10/30/2015 04:58PM

Dose mysql partitioning support global index ?

1,416

jongse park

09/21/2015 07:31PM

Re: Dose mysql partitioning support global index ?

1,236

Jonathan Stephens

09/21/2015 11:30PM

Re: Dose mysql partitioning support global index ?

780

Rick James

10/02/2015 09:51PM

Should I PARTITION my table?

1,298

Rick James

10/01/2015 09:11PM

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

1,689

Akshath Hegde

08/23/2015 12:18AM

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

888

Rick James

08/23/2015 05:55PM

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

876

Akshath Hegde

08/26/2015 02:53AM

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

827

Rick James

08/27/2015 07:40AM

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

1,368

Sam Young

08/20/2015 08:00PM

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

837

Jonathan Stephens

08/21/2015 02:53AM

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

748

Sam Young

08/23/2015 08:57PM

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

732

Rick James

08/22/2015 03:35PM

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

686

Sam Young

08/23/2015 09:23PM

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

667

Rick James

08/24/2015 12:36PM

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

727

Sam Young

08/26/2015 12:53AM

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

736

Rick James

08/26/2015 10:02AM

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

691

Sam Young

08/26/2015 07:42PM

Dose MySQL support a dynamic pruning in mysql partitioning ?

1,384

jongse park

08/05/2015 08:41PM

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

707

Jonathan Stephens

08/06/2015 03:31AM

How to partition for performance

1,515

Doug Wolfgram

07/29/2015 09:42PM

Re: How to partition for performance

911

Rick James

07/31/2015 01:36PM

Re: How to partition for performance

858

Rick James

07/31/2015 02:23PM

Partition and Subpartition using Unixtime

1,384

Jaineera Naveen

07/09/2015 07:53AM

Re: Partition and Subpartition using Unixtime

717

Rick James

07/09/2015 11:59PM

Optimum partition for a bigger table

1,292

Jaineera Naveen

07/09/2015 12:35AM

Re: Optimum partition for a bigger table

760

Rick James

07/09/2015 11:36PM

Mysql 5.5 Partittioning row field

1,452

Shubham Jain

06/24/2015 10:19PM

Re: Mysql 5.5 Partittioning row field

1,036

Jonathan Stephens

06/25/2015 10:16AM

Re: Mysql 5.5 Partittioning row field

859

Rick James

06/26/2015 12:15AM

Re: Mysql 5.5 Partittioning row field

1,019

Jonathan Stephens

06/26/2015 02:40AM

Re: Mysql 5.5 Partittioning row field

884

Shubham Jain

06/26/2015 07:02AM

subpartiton by key doesn't evenly distribute data

1,409

jongse park

06/10/2015 11:20PM

Re: subpartiton by key doesn't evenly distribute data

731

Rick James

06/13/2015 08:25AM

Re: subpartiton by key doesn't evenly distribute data

779

jongse park

06/15/2015 12:01AM

Re: subpartiton by key doesn't evenly distribute data

721

Rick James

06/15/2015 07:07PM

Re: subpartiton by key doesn't evenly distribute data

827

jongse park

06/15/2015 10:41PM

Re: subpartiton by key doesn't evenly distribute data

775

Rick James

06/16/2015 07:36PM

Advice on partitioning

1,707

me su

04/24/2015 01:40PM

Re: Advice on partitioning

974

Rick James

04/24/2015 05:34PM

Re: Advice on partitioning

927

04/27/2015 09:05AM

Re: Advice on partitioning

959

Rick James

04/27/2015 02:22PM

Re: Advice on partitioning

803

Drew Morris

04/28/2015 11:02AM

Re: Advice on partitioning

840

Rick James

04/28/2015 12:32PM

Re: Advice on partitioning

866

04/28/2015 04:07PM

Re: Advice on partitioning

711

06/15/2015 06:39PM

Re: Advice on partitioning

859

Rick James

06/15/2015 07:05PM

Re: Advice on partitioning

812

06/16/2015 06:40PM

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

1,749

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,042

Rick James

05/17/2015 12:04AM

Select using partition dynamically

1,703

Jose Lima

05/07/2015 06:21PM

Re: Select using partition dynamically

877

Rick James

05/11/2015 12:53PM

Partitioning & Replication

1,486

04/09/2015 06:30PM

Re: Partitioning & Replication

805

Rick James

04/12/2015 09:43PM

how to speed up for List partitioning table

1,763

jongse park

12/28/2014 07:59PM

Re: how to speed up for List partitioning table

968

Rick James

12/30/2014 03:05PM

wrong output generate while using partitions

2,000

Shivam Patel

12/13/2014 07:56AM

Re: wrong output generate while using partitions

965

Rick James

12/14/2014 10:33PM

Re: wrong output generate while using partitions

946

Shivam Patel

12/16/2014 01:24AM

Re: wrong output generate while using partitions

994

Jonathan Stephens

12/16/2014 02:32AM

Re: wrong output generate while using partitions

1,016

Shivam Patel

12/16/2014 04:00AM

Re: wrong output generate while using partitions

923

Rick James

12/16/2014 04:28PM

Re: wrong output generate while using partitions

1,042

Shivam Patel

12/17/2014 07:20AM

Re: wrong output generate while using partitions

1,052

Rick James

12/17/2014 11:27AM

large InnoDB table partitioning without explicit PK

2,607

Miko M

11/12/2014 07:41PM

Re: large InnoDB table partitioning without explicit PK

1,484

Rick James

11/13/2014 06:40PM

Re: large InnoDB table partitioning without explicit PK

1,299

Miko M

11/14/2014 03:02AM

Re: large InnoDB table partitioning without explicit PK

1,039

Rick James

11/15/2014 12:05AM

Re: large InnoDB table partitioning without explicit PK

1,063

Miko M

11/16/2014 07:39PM

Re: large InnoDB table partitioning without explicit PK

944

Rick James

11/17/2014 04:21PM

Re: large InnoDB table partitioning without explicit PK

1,050

Rick James

11/17/2014 07:48PM

Re: large InnoDB table partitioning without explicit PK

1,015

Miko M

11/18/2014 02:00AM

Re: large InnoDB table partitioning without explicit PK

1,053

Rick James

11/18/2014 11:35PM

Re: large InnoDB table partitioning without explicit PK

1,095

Miko M

11/22/2014 06:44AM

Re: large InnoDB table partitioning without explicit PK

1,000

Miko M

11/18/2014 01:13AM

(non-unique) index more efficient than partition pruning

1,219

Miko M

11/19/2014 12:27AM

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

1,080

Rick James

11/19/2014 06:01PM

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

1,116

Miko M

11/22/2014 08:39AM

Re: large InnoDB table partitioning without explicit PK

1,120

Miko M

11/14/2014 03:04AM

Re: large InnoDB table partitioning without explicit PK

1,177

Miko M

11/14/2014 03:05AM

Re: large InnoDB table partitioning without explicit PK

1,250

Rick James

11/15/2014 12:32AM

Re: large InnoDB table partitioning without explicit PK

1,191

Miko M

11/16/2014 08:31PM

Re: large InnoDB table partitioning without explicit PK

1,015

Rick James

11/19/2014 12:12AM

Re: large InnoDB table partitioning without explicit PK

981

Miko M

11/22/2014 09:07AM

Re: large InnoDB table partitioning without explicit PK

972

Rick James

11/23/2014 09:00PM

Re: large InnoDB table partitioning without explicit PK

1,068

Miko M

12/01/2014 11:16AM

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

2,224

Tom Song

10/21/2014 03:53AM

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

1,036

Tom Song

10/22/2014 11:58PM

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

1,000

Rick James

10/23/2014 04:36PM

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

1,007

Tom Song

10/24/2014 02:05AM

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

965

Mikael Ronström

11/13/2014 06:54AM

Partitioning on account_id

2,415

Ketil Stadskleiv

10/13/2014 02:54PM

Re: Partitioning on account_id

1,210

Rick James

10/14/2014 06:04PM

Range partition and unique key

1,980

09/24/2014 08:42AM

Re: Range partition and unique key

1,014

Rick James

09/25/2014 09:59AM

Re: Range partition and unique key

1,045

09/26/2014 03:40AM

Re: Range partition and unique key

1,099

Rick James

09/27/2014 08:25AM

Horizontal partitioning on a per user basis?

1,987

Peter Sarkozi

09/18/2014 05:40PM

Re: Horizontal partitioning on a per user basis?

1,036

Luke Taylor

09/19/2014 01:12AM

Re: Horizontal partitioning on a per user basis?

1,074

Rick James

09/19/2014 11:18PM

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

3,136

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,204

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,189

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,184

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,055

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,175

Rick James

09/01/2014 08:28PM

Not Taking Paritioning when using Subquery or Join

1,992

Marc Vettorel

08/27/2014 07:08AM

Re: Not Taking Paritioning when using Subquery or Join

1,081

Marc Vettorel

08/27/2014 07:19AM

Re: Not Taking Paritioning when using Subquery or Join

1,066

Rick James

08/28/2014 10:19AM

EXCHANGE PARTITION and DATA DIRECTORY errors

2,313

Ekundayo Lasode

08/16/2014 09:47AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,109

Mattias Jonsson

08/19/2014 03:32AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,106

Ekundayo Lasode

08/19/2014 06:28AM

Storing time series data using partitioning

2,657

Florian Rampp

08/14/2014 05:45AM

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.