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

...

5 6 7 8 9

...

14 »

Subject

Views

Written By

Posted

Partition by Key

6,225

Vanco Josifovski

03/09/2010 02:28AM

Re: Partition by Key

2,434

Mattias Jonsson

03/12/2010 02:17AM

ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed

25,488

Chaya Shindhe

02/18/2010 04:21AM

Re: ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed

16,435

Mattias Jonsson

02/19/2010 04:22AM

PARTITION BY LIST "catch-all" partition

5,703

Egor Ivkin

01/20/2010 03:25AM

Re: PARTITION BY LIST "catch-all" partition

2,485

Mattias Jonsson

01/23/2010 03:55AM

Re: PARTITION BY LIST "catch-all" partition

2,408

Egor Ivkin

01/23/2010 08:20AM

Re: PARTITION BY LIST "catch-all" partition

2,493

Rick James

01/22/2010 11:05PM

Re: PARTITION BY LIST "catch-all" partition

2,452

Egor Ivkin

01/23/2010 12:30AM

Why doesn't partitioning support INSERT DELAYED?

5,159

Ben Vaughn

01/14/2010 06:50PM

Re: Why doesn't partitioning support INSERT DELAYED?

2,614

Mattias Jonsson

01/16/2010 06:48PM

Re: Why doesn't partitioning support INSERT DELAYED?

2,488

Rick James

01/22/2010 11:16PM

Partitioning with range(to_days) issue

12,464

10/29/2009 11:13AM

Re: Partitioning with range(to_days) issue

3,333

Sarah Sproehnle

11/05/2009 07:47PM

Re: Partitioning with range(to_days) issue

3,010

01/13/2010 06:36AM

Re: Partitioning with range(to_days) issue

3,489

Jason Shoulet

11/05/2009 03:12AM

Re: Partitioning with range(to_days) issue

3,345

Rick James

11/05/2009 08:37AM

Re: Partitioning with range(to_days) issue

4,267

Jason Shoulet

11/05/2009 09:51AM

Re: Partitioning with range(to_days) issue

3,150

Mattias Jonsson

11/17/2009 05:51AM

Re: Partitioning with range(to_days) issue

3,792

Rick James

10/31/2009 12:00PM

Re: Partitioning with range(to_days) issue

3,481

11/02/2009 04:07AM

Re: Partitioning with range(to_days) issue

3,334

Rick James

11/02/2009 10:22AM

Re: Partitioning with range(to_days) issue

3,294

11/03/2009 02:18AM

Re: Partitioning with range(to_days) issue

4,097

Rick James

11/03/2009 09:32AM

Re: Partitioning with range(to_days) issue

3,041

01/13/2010 05:17AM

Re: Partitioning with range(to_days) issue

2,981

Rick James

01/22/2010 11:09PM

Partitioned table using two storage engines?

3,607

01/07/2010 03:47PM

Re: Partitioned table using two storage engines?

2,180

Mattias Jonsson

01/13/2010 05:00AM

Sub partitions

4,514

AR Mahdi

01/12/2010 03:09AM

Re: Sub partitions

2,311

Mattias Jonsson

01/13/2010 04:51AM

Comments: Giuseppe Maxia - A deep look at MySQL 5.5 partitioning enhancements

7,494

DevZone Comment System

12/24/2009 01:26PM

Building Indexes across partitioned tables longer each day

4,647

Edward Capriolo

12/21/2009 10:46AM

Re: Building Indexes across partitioned tables longer each day

2,652

Rick James

12/22/2009 10:17PM

Re: Building Indexes across partitioned tables longer each day

2,468

Edward Capriolo

12/23/2009 12:30PM

Re: Building Indexes across partitioned tables longer each day

2,549

Mattias Jonsson

12/22/2009 02:48AM

alter table rebuild partition locks reads

6,666

Chris C

12/18/2009 01:24AM

Re: alter table rebuild partition locks reads

3,029

Chris C

12/18/2009 02:27AM

Re: alter table rebuild partition locks reads

2,615

Rick James

12/19/2009 09:22AM

Re: alter table rebuild partition locks reads

2,667

Chris C

12/20/2009 08:41PM

Re: alter table rebuild partition locks reads

2,755

Chris C

12/21/2009 03:04PM

Re: alter table rebuild partition locks reads

2,559

Mattias Jonsson

12/22/2009 02:37AM

Re: alter table rebuild partition locks reads

2,559

Chris C

12/22/2009 10:17AM

Hash and Linear Hash partition table not performing well

6,596

Neeraj Khandelwal

11/27/2009 03:04AM

Re: Hash and Linear Hash partition table not performing well

2,989

Mattias Jonsson

12/07/2009 04:44AM

Re: Hash and Linear Hash partition table not performing well

2,796

Neeraj Khandelwal

12/08/2009 01:05AM

Re: Hash and Linear Hash partition table not performing well

3,660

Mattias Jonsson

12/22/2009 03:29AM

Re: Hash and Linear Hash partition table not performing well

3,151

Rick James

12/05/2009 11:49PM

Re: Hash and Linear Hash partition table not performing well

3,206

Neeraj Khandelwal

12/08/2009 03:42AM

Re: Hash and Linear Hash partition table not performing well

3,694

Rick James

12/09/2009 08:08PM

Archiving Partition .MYD files

6,187

Dominic Edwards

12/11/2009 05:41AM

Re: Archiving Partition .MYD files

2,888

Dominic Edwards

12/11/2009 05:48AM

Re: Archiving Partition .MYD files

2,806

Rick James

12/12/2009 03:48PM

Re: Archiving Partition .MYD files

3,079

Mattias Jonsson

12/22/2009 03:00AM

partitioning question?

4,107

asmaa atef

12/14/2009 08:34AM

Re: partitioning question?

2,374

Mattias Jonsson

12/22/2009 02:50AM

Re: partitioning question?

2,502

Rick James

12/16/2009 12:33AM

Re: partitioning question?

2,296

asmaa atef

12/16/2009 07:44AM

Re: partitioning question?

2,451

Rick James

12/16/2009 11:53PM

Re: partitioning question?

2,390

asmaa atef

12/17/2009 02:39AM

Re: partitioning question?

2,303

Rick James

12/18/2009 12:40AM

Minimum number of rows for using partitioning

5,498

Ramesh Kumar

12/10/2009 10:57PM

Re: Minimum number of rows for using partitioning

2,511

Rick James

12/12/2009 10:58PM

Re: Minimum number of rows for using partitioning

2,816

Ramesh Kumar

12/13/2009 09:57PM

Re: Minimum number of rows for using partitioning

2,467

Rick James

12/14/2009 12:17AM

Re: Minimum number of rows for using partitioning

2,812

Ramesh Kumar

12/14/2009 12:57AM

Range Partition Pruning on TO_DAYS Problem

4,469

Dominic Edwards

11/12/2009 10:06AM

Re: Range Partition Pruning on TO_DAYS Problem

3,046

Mattias Jonsson

11/17/2009 06:09AM

Re: Range Partition Pruning on TO_DAYS Problem

2,496

Rick James

11/17/2009 08:41PM

Re: Range Partition Pruning on TO_DAYS Problem

2,379

Dominic Edwards

12/11/2009 05:45AM

Create new partition for an existing table?

4,882

hung chu

11/26/2009 10:27PM

Re: Create new partition for an existing table?

2,670

Rick James

12/05/2009 11:55PM

How transaction work with partitioned table?

3,382

hung chu

11/30/2009 04:13AM

Re: How transaction work with partitioned table?

2,222

Rick James

12/05/2009 11:45PM

I have a partitioned data set; how to best migrate to MySQL's Partioning?

4,126

12/04/2009 11:24AM

Re: I have a partitioned data set; how to best migrate to MySQL's Partioning?

2,208

Rick James

12/05/2009 03:06PM

partitioning

3,987

gururaj sheth

11/19/2009 12:39AM

Re: partitioning

2,469

Devart Team

11/20/2009 05:01AM

Re: partitioning

2,316

Rick James

11/20/2009 07:47PM

Subpartitioned by LIST

6,124

Praveen TS

11/06/2009 03:57AM

Re: Subpartitioned by LIST

2,875

Mattias Jonsson

11/17/2009 05:56AM

Re: Subpartitioned by LIST

2,603

Praveen TS

11/08/2009 10:36PM

Re: Subpartitioned by LIST

2,708

Rick James

11/09/2009 09:44AM

Re: Subpartitioned by LIST

2,315

Rick James

11/07/2009 04:07PM

Subpartition Pruning

5,413

Mathuvathanan Mounasamy

10/16/2009 04:08AM

Re: Subpartition Pruning

2,563

Mattias Jonsson

11/17/2009 05:40AM

Vertical Partitioning

4,126

Laavanya K

11/10/2009 09:41PM

Re: Vertical Partitioning

2,756

Rick James

11/11/2009 11:57PM

Re: Vertical Partitioning

2,324

Laavanya K

11/12/2009 12:02AM

Re: Vertical Partitioning

2,449

Rick James

11/12/2009 08:47PM

MySQL Partitioning (WL#4444, WL#4571): New partitioning SQL syntax added

3,476

Edwin DeSouza

11/11/2009 11:19AM

MySQL Partitioning (WL#3352): Extending Partitioning Types, New Partition function

3,282

Edwin DeSouza

11/10/2009 11:22AM

Partitioning and JOIN

7,847

m z

11/05/2009 02:07PM

Re: Partitioning and JOIN

3,155

Rick James

11/06/2009 08:26PM

Re: Partitioning and JOIN

3,437

m z

11/06/2009 11:15AM

Partitioning on existing table

4,726

Eyrique Wong

11/04/2009 09:33PM

Re: Partitioning on existing table

2,578

Rick James

11/05/2009 11:35PM

Re: Partitioning on existing table

2,452

Eyrique Wong

11/06/2009 01:17AM

Re: Partitioning on existing table

2,812

Rick James

11/06/2009 10:49AM

Re: Partitioning on existing table

2,492

m z

11/05/2009 08:45PM

Backup a partition to archive.

4,084

Shankar R

10/30/2009 11:32PM

Re: Backup a partition to archive.

2,394

Shankar R

11/01/2009 02:39PM

Re: Backup a partition to archive.

2,825

Rick James

11/01/2009 11:26AM

PARTITION or sEPERATE tABLE ISSUE

3,637

hrishi patil

10/29/2009 06:32AM

Re: PARTITION or sEPERATE tABLE ISSUE

2,273

Rick James

10/30/2009 09:35AM

PARTITION or sEPERATE tABLE ISSUE

3,342

hrishi patil

10/29/2009 06:07AM

PARTITION BY HASH

6,864

Sreedevi Iyer

10/27/2009 12:20PM

Re: PARTITION BY HASH

3,705

Hartmut Holzgraefe

10/28/2009 01:00AM

Re: PARTITION BY HASH

2,640

Praveen TS

10/28/2009 04:51AM

Re-organize table not working

4,622

Wane cooper

10/23/2009 06:02AM

Re: Re-organize table not working

2,258

Rick James

10/24/2009 07:42AM

DROP TABLE which has a inverted comma in its name

4,594

Mathuvathanan Mounasamy

10/22/2009 06:02AM

Re: DROP TABLE which has a inverted comma in its name

2,193

Rick James

10/23/2009 10:25AM

Lock issues with Table Partitioning

5,001

Mustafa Sait Özen

08/31/2009 04:42AM

Re: Lock issues with Table Partitioning

6,142

Mattias Jonsson

09/15/2009 03:26AM

Re: Lock issues with Table Partitioning

3,066

kevin foote

10/08/2009 07:58AM

Re: Lock issues with Table Partitioning

3,362

Mattias Jonsson

10/08/2009 08:28AM

Re: Lock issues with Table Partitioning

3,020

kevin foote

10/08/2009 08:37AM

Re: Lock issues with Table Partitioning

2,765

Mattias Jonsson

10/08/2009 08:44AM

Re: Lock issues with Table Partitioning

3,445

Nanda kishore Toomula

08/31/2009 10:10PM

Re: Lock issues with Table Partitioning

3,196

Mustafa Sait Özen

09/01/2009 12:37AM

Re: Lock issues with Table Partitioning

3,046

Nanda kishore Toomula

09/01/2009 03:28AM

Re: Lock issues with Table Partitioning

3,970

Mustafa Sait Özen

09/01/2009 05:05AM

Re: Lock issues with Table Partitioning

3,198

Nanda kishore Toomula

09/01/2009 11:28PM

Partitioning Limitations

6,700

Premal Shah

09/17/2009 07:50PM

Re: Partitioning Limitations

2,912

Jonathan Stephens

10/03/2009 02:43AM

Re: Partitioning Limitations

2,925

Rick James

10/03/2009 06:03PM

Re: Partitioning Limitations

2,688

Jonathan Stephens

09/27/2009 10:27PM

Re: Partitioning Limitations

2,733

Rick James

09/27/2009 10:47PM

Re: Partitioning Limitations

2,692

Mattias Jonsson

09/21/2009 02:59AM

Re: Partitioning Limitations

2,844

Premal Shah

09/22/2009 08:28AM

Re: Partitioning Limitations

2,924

Rick James

09/18/2009 11:11PM

MySQL Partitioning with Dates

3,618

Edwin DeSouza

09/08/2009 04:18PM

Re: MySQL Partitioning with Dates

2,276

Jonathan Stephens

10/03/2009 02:56AM

MySQL Partition

4,618

Jonathan Valerio

10/01/2009 09:35AM

Re: MySQL Partition

2,300

Matthew Montgomery

10/01/2009 10:15AM

partitioning after and in 5.1.*

3,337

Rabie Sulman

09/23/2009 03:55AM

Re: partitioning after and in 5.1.*

2,267

Rick James

09/24/2009 09:40AM

Bug in LESS THAN combined with TO_DAYS?

3,741

Guillaume Métayer

09/14/2009 03:27PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,393

Mattias Jonsson

09/21/2009 03:44AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,639

Guillaume Métayer

09/22/2009 09:24AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,495

Mattias Jonsson

09/15/2009 02:48AM

Re: Bug in LESS THAN combined with TO_DAYS?

3,466

Guillaume Métayer

09/15/2009 01:17PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,508

Mattias Jonsson

09/16/2009 07:30AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,516

Guillaume Métayer

09/17/2009 02:39PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,391

Guillaume Métayer

09/16/2009 10:53AM

Partitioning by hour

3,835

Alejandro Boldt

09/11/2009 01:32PM

Re: Partitioning by hour

2,673

Rick James

09/12/2009 03:12PM

Re: Partitioning by hour

2,486

Rick James

09/12/2009 09:31PM

Re: Partitioning by hour

3,251

Alejandro Boldt

09/17/2009 06:31AM

Re: Partitioning by hour

2,603

Rick James

09/17/2009 08:45AM

Re: Partitioning by hour

2,763

Alejandro Boldt

09/17/2009 09:50AM

Re: Partitioning by hour

2,562

Mattias Jonsson

09/21/2009 03:55AM

Partitioning by bigint

5,204

Simon Adams 2

09/17/2009 09:34AM

Re: Partitioning by bigint

2,647

Mattias Jonsson

09/21/2009 03:12AM

Re: Partitioning by bigint

2,582

Rick James

09/18/2009 06:56PM

MySQL Partitioning with non integer values using triggers

3,306

Edwin DeSouza

09/15/2009 10:21AM

Re: MySQL Partitioning with non integer values using triggers

3,019

Rick James

09/20/2009 03:47PM

Partition by list syntax error 1064?

6,938

Brian Kelley

09/16/2009 11:49PM

Re: Partition by list syntax error 1064?

2,717

Rick James

09/18/2009 08:39AM

MySQL Partitioning: by Column-list

3,303

Edwin DeSouza

09/15/2009 10:53AM

Select cannot use partitioning correctly?

3,804

w ss12cn

08/31/2009 01:39AM

Re: Select cannot use partitioning correctly?

2,344

Mattias Jonsson

09/15/2009 03:09AM

Re: Select cannot use partitioning correctly?

2,545

Nanda kishore Toomula

08/31/2009 10:22PM

Re: Select cannot use partitioning correctly?

2,384

w ss12cn

09/03/2009 03:09AM

Partition on non key varchar column

5,452

Jay Jarman

09/11/2009 07:52AM

Re: Partition on non key varchar column

3,350

Allan Winston

09/12/2009 07:24PM

Re: Partition on non key varchar column

2,703

Rick James

09/12/2009 09:45AM

Range Partition - behavior not expected

3,714

09/02/2009 12:21PM

Re: Range Partition - behavior not expected

2,601

Nanda kishore Toomula

09/03/2009 04:28AM

Re: Range Partition - behavior not expected

2,505

09/02/2009 03:58PM

Can I use MySQL as a production database to implement an huge partitioned table?

4,571

fran qina

08/21/2009 12:20PM

Re: Can I use MySQL as a production database to implement an huge partitioned table?

2,719

Nanda kishore Toomula

08/27/2009 02:49AM

Re: Can I use MySQL as a production database to implement an huge partitioned table?

2,567

fran qina

08/28/2009 07:16AM

Re: Can I use MySQL as a production database to implement an huge partitioned table?

2,517

Nanda kishore Toomula

08/29/2009 10:14PM

Help me to design this Mysql production database (with very large tables).

4,316

fran qina

08/26/2009 03:03PM

Re: Help me to design this Mysql production database (with very large tables).

2,469

Rick James

08/27/2009 09:22PM

Can partitioned table benefit from multi-thread and multi-disk I/O in Mysql database?

3,380

fran qina

08/21/2009 02:47PM

Re: Can partitioned table benefit from multi-thread and multi-disk I/O in Mysql database?

2,433

Rick James

08/22/2009 05:36PM

Can a Mysql partitioned table benefit from the STRIPE feature of disk device?

3,248

fran qina

08/21/2009 02:50PM

Re: Can a Mysql partitioned table benefit from the STRIPE feature of disk device?

2,341

Rick James

08/22/2009 05:34PM

This topic has been moved.: partitioning

0

gururaj sheth

11/20/2009 06:52AM

Pages:

« 1

...

5 6 7 8 9

...

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.