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 2023 Releases featuring MySQL 8.0.32	01/17/2023 10:40PM

New Topic

Pages:

« 1

...

5 6 7 8 9

...

14 »

Subject

Views

Written By

Posted

PARTITION BY LIST "catch-all" partition

5,123

Egor Ivkin

01/20/2010 03:25AM

Re: PARTITION BY LIST "catch-all" partition

2,257

Mattias Jonsson

01/23/2010 03:55AM

Re: PARTITION BY LIST "catch-all" partition

2,179

Egor Ivkin

01/23/2010 08:20AM

Re: PARTITION BY LIST "catch-all" partition

2,290

Rick James

01/22/2010 11:05PM

Re: PARTITION BY LIST "catch-all" partition

2,214

Egor Ivkin

01/23/2010 12:30AM

Why doesn't partitioning support INSERT DELAYED?

4,659

Ben Vaughn

01/14/2010 06:50PM

Re: Why doesn't partitioning support INSERT DELAYED?

2,369

Mattias Jonsson

01/16/2010 06:48PM

Re: Why doesn't partitioning support INSERT DELAYED?

2,223

Rick James

01/22/2010 11:16PM

Partitioning with range(to_days) issue

10,696

10/29/2009 11:13AM

Re: Partitioning with range(to_days) issue

3,046

Sarah Sproehnle

11/05/2009 07:47PM

Re: Partitioning with range(to_days) issue

2,757

01/13/2010 06:36AM

Re: Partitioning with range(to_days) issue

3,140

Jason Shoulet

11/05/2009 03:12AM

Re: Partitioning with range(to_days) issue

3,083

Rick James

11/05/2009 08:37AM

Re: Partitioning with range(to_days) issue

3,936

Jason Shoulet

11/05/2009 09:51AM

Re: Partitioning with range(to_days) issue

2,903

Mattias Jonsson

11/17/2009 05:51AM

Re: Partitioning with range(to_days) issue

3,535

Rick James

10/31/2009 12:00PM

Re: Partitioning with range(to_days) issue

3,202

11/02/2009 04:07AM

Re: Partitioning with range(to_days) issue

3,043

Rick James

11/02/2009 10:22AM

Re: Partitioning with range(to_days) issue

3,060

11/03/2009 02:18AM

Re: Partitioning with range(to_days) issue

3,746

Rick James

11/03/2009 09:32AM

Re: Partitioning with range(to_days) issue

2,787

01/13/2010 05:17AM

Re: Partitioning with range(to_days) issue

2,671

Rick James

01/22/2010 11:09PM

Partitioned table using two storage engines?

3,148

01/07/2010 03:47PM

Re: Partitioned table using two storage engines?

1,959

Mattias Jonsson

01/13/2010 05:00AM

Sub partitions

4,124

AR Mahdi

01/12/2010 03:09AM

Re: Sub partitions

2,125

Mattias Jonsson

01/13/2010 04:51AM

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

7,057

DevZone Comment System

12/24/2009 01:26PM

Building Indexes across partitioned tables longer each day

4,235

Edward Capriolo

12/21/2009 10:46AM

Re: Building Indexes across partitioned tables longer each day

2,449

Rick James

12/22/2009 10:17PM

Re: Building Indexes across partitioned tables longer each day

2,266

Edward Capriolo

12/23/2009 12:30PM

Re: Building Indexes across partitioned tables longer each day

2,327

Mattias Jonsson

12/22/2009 02:48AM

alter table rebuild partition locks reads

5,767

Chris C

12/18/2009 01:24AM

Re: alter table rebuild partition locks reads

2,809

Chris C

12/18/2009 02:27AM

Re: alter table rebuild partition locks reads

2,420

Rick James

12/19/2009 09:22AM

Re: alter table rebuild partition locks reads

2,415

Chris C

12/20/2009 08:41PM

Re: alter table rebuild partition locks reads

2,536

Chris C

12/21/2009 03:04PM

Re: alter table rebuild partition locks reads

2,334

Mattias Jonsson

12/22/2009 02:37AM

Re: alter table rebuild partition locks reads

2,333

Chris C

12/22/2009 10:17AM

Hash and Linear Hash partition table not performing well

6,113

Neeraj Khandelwal

11/27/2009 03:04AM

Re: Hash and Linear Hash partition table not performing well

2,722

Mattias Jonsson

12/07/2009 04:44AM

Re: Hash and Linear Hash partition table not performing well

2,583

Neeraj Khandelwal

12/08/2009 01:05AM

Re: Hash and Linear Hash partition table not performing well

3,456

Mattias Jonsson

12/22/2009 03:29AM

Re: Hash and Linear Hash partition table not performing well

2,946

Rick James

12/05/2009 11:49PM

Re: Hash and Linear Hash partition table not performing well

2,995

Neeraj Khandelwal

12/08/2009 03:42AM

Re: Hash and Linear Hash partition table not performing well

3,439

Rick James

12/09/2009 08:08PM

Archiving Partition .MYD files

5,527

Dominic Edwards

12/11/2009 05:41AM

Re: Archiving Partition .MYD files

2,692

Dominic Edwards

12/11/2009 05:48AM

Re: Archiving Partition .MYD files

2,637

Rick James

12/12/2009 03:48PM

Re: Archiving Partition .MYD files

2,862

Mattias Jonsson

12/22/2009 03:00AM

partitioning question?

3,684

asmaa atef

12/14/2009 08:34AM

Re: partitioning question?

2,206

Mattias Jonsson

12/22/2009 02:50AM

Re: partitioning question?

2,271

Rick James

12/16/2009 12:33AM

Re: partitioning question?

2,113

asmaa atef

12/16/2009 07:44AM

Re: partitioning question?

2,254

Rick James

12/16/2009 11:53PM

Re: partitioning question?

2,151

asmaa atef

12/17/2009 02:39AM

Re: partitioning question?

2,130

Rick James

12/18/2009 12:40AM

Minimum number of rows for using partitioning

5,125

Ramesh Kumar

12/10/2009 10:57PM

Re: Minimum number of rows for using partitioning

2,314

Rick James

12/12/2009 10:58PM

Re: Minimum number of rows for using partitioning

2,618

Ramesh Kumar

12/13/2009 09:57PM

Re: Minimum number of rows for using partitioning

2,271

Rick James

12/14/2009 12:17AM

Re: Minimum number of rows for using partitioning

2,626

Ramesh Kumar

12/14/2009 12:57AM

Range Partition Pruning on TO_DAYS Problem

4,076

Dominic Edwards

11/12/2009 10:06AM

Re: Range Partition Pruning on TO_DAYS Problem

2,874

Mattias Jonsson

11/17/2009 06:09AM

Re: Range Partition Pruning on TO_DAYS Problem

2,315

Rick James

11/17/2009 08:41PM

Re: Range Partition Pruning on TO_DAYS Problem

2,192

Dominic Edwards

12/11/2009 05:45AM

Create new partition for an existing table?

4,517

hung chu

11/26/2009 10:27PM

Re: Create new partition for an existing table?

2,503

Rick James

12/05/2009 11:55PM

How transaction work with partitioned table?

3,014

hung chu

11/30/2009 04:13AM

Re: How transaction work with partitioned table?

2,070

Rick James

12/05/2009 11:45PM

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

3,722

12/04/2009 11:24AM

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

2,039

Rick James

12/05/2009 03:06PM

partitioning

3,591

gururaj sheth

11/19/2009 12:39AM

Re: partitioning

2,311

Devart Team

11/20/2009 05:01AM

Re: partitioning

2,155

Rick James

11/20/2009 07:47PM

Subpartitioned by LIST

5,790

Praveen TS

11/06/2009 03:57AM

Re: Subpartitioned by LIST

2,662

Mattias Jonsson

11/17/2009 05:56AM

Re: Subpartitioned by LIST

2,432

Praveen TS

11/08/2009 10:36PM

Re: Subpartitioned by LIST

2,495

Rick James

11/09/2009 09:44AM

Re: Subpartitioned by LIST

2,149

Rick James

11/07/2009 04:07PM

Subpartition Pruning

5,065

Mathuvathanan Mounasamy

10/16/2009 04:08AM

Re: Subpartition Pruning

2,372

Mattias Jonsson

11/17/2009 05:40AM

Vertical Partitioning

3,763

Laavanya K

11/10/2009 09:41PM

Re: Vertical Partitioning

2,554

Rick James

11/11/2009 11:57PM

Re: Vertical Partitioning

2,161

Laavanya K

11/12/2009 12:02AM

Re: Vertical Partitioning

2,285

Rick James

11/12/2009 08:47PM

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

3,145

Edwin DeSouza

11/11/2009 11:19AM

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

2,940

Edwin DeSouza

11/10/2009 11:22AM

Partitioning and JOIN

7,284

m z

11/05/2009 02:07PM

Re: Partitioning and JOIN

2,957

Rick James

11/06/2009 08:26PM

Re: Partitioning and JOIN

3,218

m z

11/06/2009 11:15AM

Partitioning on existing table

4,240

Eyrique Wong

11/04/2009 09:33PM

Re: Partitioning on existing table

2,401

Rick James

11/05/2009 11:35PM

Re: Partitioning on existing table

2,257

Eyrique Wong

11/06/2009 01:17AM

Re: Partitioning on existing table

2,558

Rick James

11/06/2009 10:49AM

Re: Partitioning on existing table

2,325

m z

11/05/2009 08:45PM

Backup a partition to archive.

3,679

Shankar R

10/30/2009 11:32PM

Re: Backup a partition to archive.

2,185

Shankar R

11/01/2009 02:39PM

Re: Backup a partition to archive.

2,636

Rick James

11/01/2009 11:26AM

PARTITION or sEPERATE tABLE ISSUE

3,285

hrishi patil

10/29/2009 06:32AM

Re: PARTITION or sEPERATE tABLE ISSUE

2,087

Rick James

10/30/2009 09:35AM

PARTITION or sEPERATE tABLE ISSUE

2,991

hrishi patil

10/29/2009 06:07AM

PARTITION BY HASH

5,752

Sreedevi Iyer

10/27/2009 12:20PM

Re: PARTITION BY HASH

3,528

Hartmut Holzgraefe

10/28/2009 01:00AM

Re: PARTITION BY HASH

2,456

Praveen TS

10/28/2009 04:51AM

Re-organize table not working

4,255

Wane cooper

10/23/2009 06:02AM

Re: Re-organize table not working

2,091

Rick James

10/24/2009 07:42AM

DROP TABLE which has a inverted comma in its name

4,180

Mathuvathanan Mounasamy

10/22/2009 06:02AM

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

2,011

Rick James

10/23/2009 10:25AM

Lock issues with Table Partitioning

4,454

Mustafa Sait Özen

08/31/2009 04:42AM

Re: Lock issues with Table Partitioning

5,787

Mattias Jonsson

09/15/2009 03:26AM

Re: Lock issues with Table Partitioning

2,773

kevin foote

10/08/2009 07:58AM

Re: Lock issues with Table Partitioning

2,993

Mattias Jonsson

10/08/2009 08:28AM

Re: Lock issues with Table Partitioning

2,785

kevin foote

10/08/2009 08:37AM

Re: Lock issues with Table Partitioning

2,569

Mattias Jonsson

10/08/2009 08:44AM

Re: Lock issues with Table Partitioning

3,196

Nanda kishore Toomula

08/31/2009 10:10PM

Re: Lock issues with Table Partitioning

2,923

Mustafa Sait Özen

09/01/2009 12:37AM

Re: Lock issues with Table Partitioning

2,829

Nanda kishore Toomula

09/01/2009 03:28AM

Re: Lock issues with Table Partitioning

3,689

Mustafa Sait Özen

09/01/2009 05:05AM

Re: Lock issues with Table Partitioning

3,004

Nanda kishore Toomula

09/01/2009 11:28PM

Partitioning Limitations

6,194

Premal Shah

09/17/2009 07:50PM

Re: Partitioning Limitations

2,706

Jonathan Stephens

10/03/2009 02:43AM

Re: Partitioning Limitations

2,718

Rick James

10/03/2009 06:03PM

Re: Partitioning Limitations

2,501

Jonathan Stephens

09/27/2009 10:27PM

Re: Partitioning Limitations

2,544

Rick James

09/27/2009 10:47PM

Re: Partitioning Limitations

2,511

Mattias Jonsson

09/21/2009 02:59AM

Re: Partitioning Limitations

2,658

Premal Shah

09/22/2009 08:28AM

Re: Partitioning Limitations

2,708

Rick James

09/18/2009 11:11PM

MySQL Partitioning with Dates

3,293

Edwin DeSouza

09/08/2009 04:18PM

Re: MySQL Partitioning with Dates

2,102

Jonathan Stephens

10/03/2009 02:56AM

MySQL Partition

4,272

Jonathan Valerio

10/01/2009 09:35AM

Re: MySQL Partition

2,127

Matthew Montgomery

10/01/2009 10:15AM

partitioning after and in 5.1.*

3,039

Rabie Sulman

09/23/2009 03:55AM

Re: partitioning after and in 5.1.*

2,088

Rick James

09/24/2009 09:40AM

Bug in LESS THAN combined with TO_DAYS?

3,336

Guillaume Métayer

09/14/2009 03:27PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,197

Mattias Jonsson

09/21/2009 03:44AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,390

Guillaume Métayer

09/22/2009 09:24AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,319

Mattias Jonsson

09/15/2009 02:48AM

Re: Bug in LESS THAN combined with TO_DAYS?

3,272

Guillaume Métayer

09/15/2009 01:17PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,316

Mattias Jonsson

09/16/2009 07:30AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,320

Guillaume Métayer

09/17/2009 02:39PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,198

Guillaume Métayer

09/16/2009 10:53AM

Partitioning by hour

3,440

Alejandro Boldt

09/11/2009 01:32PM

Re: Partitioning by hour

2,487

Rick James

09/12/2009 03:12PM

Re: Partitioning by hour

2,303

Rick James

09/12/2009 09:31PM

Re: Partitioning by hour

2,997

Alejandro Boldt

09/17/2009 06:31AM

Re: Partitioning by hour

2,396

Rick James

09/17/2009 08:45AM

Re: Partitioning by hour

2,535

Alejandro Boldt

09/17/2009 09:50AM

Re: Partitioning by hour

2,372

Mattias Jonsson

09/21/2009 03:55AM

Partitioning by bigint

4,775

Simon Adams 2

09/17/2009 09:34AM

Re: Partitioning by bigint

2,377

Mattias Jonsson

09/21/2009 03:12AM

Re: Partitioning by bigint

2,384

Rick James

09/18/2009 06:56PM

MySQL Partitioning with non integer values using triggers

2,940

Edwin DeSouza

09/15/2009 10:21AM

Re: MySQL Partitioning with non integer values using triggers

2,839

Rick James

09/20/2009 03:47PM

Partition by list syntax error 1064?

6,322

Brian Kelley

09/16/2009 11:49PM

Re: Partition by list syntax error 1064?

2,521

Rick James

09/18/2009 08:39AM

MySQL Partitioning: by Column-list

2,974

Edwin DeSouza

09/15/2009 10:53AM

Select cannot use partitioning correctly?

3,477

w ss12cn

08/31/2009 01:39AM

Re: Select cannot use partitioning correctly?

2,175

Mattias Jonsson

09/15/2009 03:09AM

Re: Select cannot use partitioning correctly?

2,346

Nanda kishore Toomula

08/31/2009 10:22PM

Re: Select cannot use partitioning correctly?

2,235

w ss12cn

09/03/2009 03:09AM

Partition on non key varchar column

5,041

Jay Jarman

09/11/2009 07:52AM

Re: Partition on non key varchar column

3,108

Allan Winston

09/12/2009 07:24PM

Re: Partition on non key varchar column

2,549

Rick James

09/12/2009 09:45AM

Range Partition - behavior not expected

3,359

09/02/2009 12:21PM

Re: Range Partition - behavior not expected

2,398

Nanda kishore Toomula

09/03/2009 04:28AM

Re: Range Partition - behavior not expected

2,338

09/02/2009 03:58PM

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

4,133

fran qina

08/21/2009 12:20PM

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

2,554

Nanda kishore Toomula

08/27/2009 02:49AM

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

2,396

fran qina

08/28/2009 07:16AM

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

2,361

Nanda kishore Toomula

08/29/2009 10:14PM

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

3,974

fran qina

08/26/2009 03:03PM

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

2,277

Rick James

08/27/2009 09:22PM

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

3,068

fran qina

08/21/2009 02:47PM

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

2,284

Rick James

08/22/2009 05:36PM

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

2,932

fran qina

08/21/2009 02:50PM

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

2,177

Rick James

08/22/2009 05:34PM

Select doesn't use the different partitions?

3,620

07/28/2009 01:54AM

Re: Select doesn't use the different partitions?

2,243

Allan Winston

08/15/2009 11:11PM

Re: Select doesn't use the different partitions?

2,092

08/14/2009 09:16AM

Wether is it possible to compress partitioned MyISAM tables?

6,128

Allen Wang

06/02/2009 09:30PM

Re: Wether is it possible to compress partitioned MyISAM tables?

3,374

Allan Winston

08/07/2009 02:38AM

Re: Wether is it possible to compress partitioned MyISAM tables?

3,478

Rick James

06/03/2009 11:30PM

Re: Wether is it possible to compress partitioned MyISAM tables?

3,583

08/14/2009 08:58AM

Re: Wether is it possible to compress partitioned MyISAM tables?

3,000

Allan Winston

08/15/2009 10:50PM

Re: Wether is it possible to compress partitioned MyISAM tables?

3,459

Allen Wang

06/04/2009 12:09AM

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.