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 a new webcast video that completes a deep dive into how to download and use Enterprise Manager for MySQL	04/04/2024 03:01PM

New Topic

Pages:

« 1

...

5 6 7 8 9

...

14 »

Subject

Views

Written By

Posted

PARTITION BY LIST "catch-all" partition

5,239

Egor Ivkin

01/20/2010 03:25AM

Re: PARTITION BY LIST "catch-all" partition

2,295

Mattias Jonsson

01/23/2010 03:55AM

Re: PARTITION BY LIST "catch-all" partition

2,212

Egor Ivkin

01/23/2010 08:20AM

Re: PARTITION BY LIST "catch-all" partition

2,317

Rick James

01/22/2010 11:05PM

Re: PARTITION BY LIST "catch-all" partition

2,258

Egor Ivkin

01/23/2010 12:30AM

Why doesn't partitioning support INSERT DELAYED?

4,739

Ben Vaughn

01/14/2010 06:50PM

Re: Why doesn't partitioning support INSERT DELAYED?

2,416

Mattias Jonsson

01/16/2010 06:48PM

Re: Why doesn't partitioning support INSERT DELAYED?

2,270

Rick James

01/22/2010 11:16PM

Partitioning with range(to_days) issue

10,992

10/29/2009 11:13AM

Re: Partitioning with range(to_days) issue

3,094

Sarah Sproehnle

11/05/2009 07:47PM

Re: Partitioning with range(to_days) issue

2,806

01/13/2010 06:36AM

Re: Partitioning with range(to_days) issue

3,222

Jason Shoulet

11/05/2009 03:12AM

Re: Partitioning with range(to_days) issue

3,129

Rick James

11/05/2009 08:37AM

Re: Partitioning with range(to_days) issue

4,022

Jason Shoulet

11/05/2009 09:51AM

Re: Partitioning with range(to_days) issue

2,954

Mattias Jonsson

11/17/2009 05:51AM

Re: Partitioning with range(to_days) issue

3,609

Rick James

10/31/2009 12:00PM

Re: Partitioning with range(to_days) issue

3,256

11/02/2009 04:07AM

Re: Partitioning with range(to_days) issue

3,107

Rick James

11/02/2009 10:22AM

Re: Partitioning with range(to_days) issue

3,122

11/03/2009 02:18AM

Re: Partitioning with range(to_days) issue

3,801

Rick James

11/03/2009 09:32AM

Re: Partitioning with range(to_days) issue

2,841

01/13/2010 05:17AM

Re: Partitioning with range(to_days) issue

2,716

Rick James

01/22/2010 11:09PM

Partitioned table using two storage engines?

3,237

01/07/2010 03:47PM

Re: Partitioned table using two storage engines?

2,003

Mattias Jonsson

01/13/2010 05:00AM

Sub partitions

4,202

AR Mahdi

01/12/2010 03:09AM

Re: Sub partitions

2,153

Mattias Jonsson

01/13/2010 04:51AM

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

7,138

DevZone Comment System

12/24/2009 01:26PM

Building Indexes across partitioned tables longer each day

4,303

Edward Capriolo

12/21/2009 10:46AM

Re: Building Indexes across partitioned tables longer each day

2,499

Rick James

12/22/2009 10:17PM

Re: Building Indexes across partitioned tables longer each day

2,314

Edward Capriolo

12/23/2009 12:30PM

Re: Building Indexes across partitioned tables longer each day

2,366

Mattias Jonsson

12/22/2009 02:48AM

alter table rebuild partition locks reads

5,873

Chris C

12/18/2009 01:24AM

Re: alter table rebuild partition locks reads

2,842

Chris C

12/18/2009 02:27AM

Re: alter table rebuild partition locks reads

2,452

Rick James

12/19/2009 09:22AM

Re: alter table rebuild partition locks reads

2,472

Chris C

12/20/2009 08:41PM

Re: alter table rebuild partition locks reads

2,573

Chris C

12/21/2009 03:04PM

Re: alter table rebuild partition locks reads

2,374

Mattias Jonsson

12/22/2009 02:37AM

Re: alter table rebuild partition locks reads

2,381

Chris C

12/22/2009 10:17AM

Hash and Linear Hash partition table not performing well

6,185

Neeraj Khandelwal

11/27/2009 03:04AM

Re: Hash and Linear Hash partition table not performing well

2,757

Mattias Jonsson

12/07/2009 04:44AM

Re: Hash and Linear Hash partition table not performing well

2,621

Neeraj Khandelwal

12/08/2009 01:05AM

Re: Hash and Linear Hash partition table not performing well

3,487

Mattias Jonsson

12/22/2009 03:29AM

Re: Hash and Linear Hash partition table not performing well

2,983

Rick James

12/05/2009 11:49PM

Re: Hash and Linear Hash partition table not performing well

3,031

Neeraj Khandelwal

12/08/2009 03:42AM

Re: Hash and Linear Hash partition table not performing well

3,480

Rick James

12/09/2009 08:08PM

Archiving Partition .MYD files

5,613

Dominic Edwards

12/11/2009 05:41AM

Re: Archiving Partition .MYD files

2,730

Dominic Edwards

12/11/2009 05:48AM

Re: Archiving Partition .MYD files

2,672

Rick James

12/12/2009 03:48PM

Re: Archiving Partition .MYD files

2,905

Mattias Jonsson

12/22/2009 03:00AM

partitioning question?

3,760

asmaa atef

12/14/2009 08:34AM

Re: partitioning question?

2,238

Mattias Jonsson

12/22/2009 02:50AM

Re: partitioning question?

2,300

Rick James

12/16/2009 12:33AM

Re: partitioning question?

2,154

asmaa atef

12/16/2009 07:44AM

Re: partitioning question?

2,293

Rick James

12/16/2009 11:53PM

Re: partitioning question?

2,187

asmaa atef

12/17/2009 02:39AM

Re: partitioning question?

2,171

Rick James

12/18/2009 12:40AM

Minimum number of rows for using partitioning

5,208

Ramesh Kumar

12/10/2009 10:57PM

Re: Minimum number of rows for using partitioning

2,360

Rick James

12/12/2009 10:58PM

Re: Minimum number of rows for using partitioning

2,659

Ramesh Kumar

12/13/2009 09:57PM

Re: Minimum number of rows for using partitioning

2,313

Rick James

12/14/2009 12:17AM

Re: Minimum number of rows for using partitioning

2,659

Ramesh Kumar

12/14/2009 12:57AM

Range Partition Pruning on TO_DAYS Problem

4,149

Dominic Edwards

11/12/2009 10:06AM

Re: Range Partition Pruning on TO_DAYS Problem

2,913

Mattias Jonsson

11/17/2009 06:09AM

Re: Range Partition Pruning on TO_DAYS Problem

2,347

Rick James

11/17/2009 08:41PM

Re: Range Partition Pruning on TO_DAYS Problem

2,225

Dominic Edwards

12/11/2009 05:45AM

Create new partition for an existing table?

4,574

hung chu

11/26/2009 10:27PM

Re: Create new partition for an existing table?

2,534

Rick James

12/05/2009 11:55PM

How transaction work with partitioned table?

3,077

hung chu

11/30/2009 04:13AM

Re: How transaction work with partitioned table?

2,094

Rick James

12/05/2009 11:45PM

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

3,823

12/04/2009 11:24AM

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

2,073

Rick James

12/05/2009 03:06PM

partitioning

3,660

gururaj sheth

11/19/2009 12:39AM

Re: partitioning

2,338

Devart Team

11/20/2009 05:01AM

Re: partitioning

2,191

Rick James

11/20/2009 07:47PM

Subpartitioned by LIST

5,852

Praveen TS

11/06/2009 03:57AM

Re: Subpartitioned by LIST

2,697

Mattias Jonsson

11/17/2009 05:56AM

Re: Subpartitioned by LIST

2,462

Praveen TS

11/08/2009 10:36PM

Re: Subpartitioned by LIST

2,522

Rick James

11/09/2009 09:44AM

Re: Subpartitioned by LIST

2,177

Rick James

11/07/2009 04:07PM

Subpartition Pruning

5,122

Mathuvathanan Mounasamy

10/16/2009 04:08AM

Re: Subpartition Pruning

2,407

Mattias Jonsson

11/17/2009 05:40AM

Vertical Partitioning

3,812

Laavanya K

11/10/2009 09:41PM

Re: Vertical Partitioning

2,594

Rick James

11/11/2009 11:57PM

Re: Vertical Partitioning

2,188

Laavanya K

11/12/2009 12:02AM

Re: Vertical Partitioning

2,316

Rick James

11/12/2009 08:47PM

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

3,219

Edwin DeSouza

11/11/2009 11:19AM

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

2,999

Edwin DeSouza

11/10/2009 11:22AM

Partitioning and JOIN

7,469

m z

11/05/2009 02:07PM

Re: Partitioning and JOIN

3,007

Rick James

11/06/2009 08:26PM

Re: Partitioning and JOIN

3,270

m z

11/06/2009 11:15AM

Partitioning on existing table

4,359

Eyrique Wong

11/04/2009 09:33PM

Re: Partitioning on existing table

2,435

Rick James

11/05/2009 11:35PM

Re: Partitioning on existing table

2,299

Eyrique Wong

11/06/2009 01:17AM

Re: Partitioning on existing table

2,621

Rick James

11/06/2009 10:49AM

Re: Partitioning on existing table

2,359

m z

11/05/2009 08:45PM

Backup a partition to archive.

3,761

Shankar R

10/30/2009 11:32PM

Re: Backup a partition to archive.

2,263

Shankar R

11/01/2009 02:39PM

Re: Backup a partition to archive.

2,682

Rick James

11/01/2009 11:26AM

PARTITION or sEPERATE tABLE ISSUE

3,363

hrishi patil

10/29/2009 06:32AM

Re: PARTITION or sEPERATE tABLE ISSUE

2,139

Rick James

10/30/2009 09:35AM

PARTITION or sEPERATE tABLE ISSUE

3,062

hrishi patil

10/29/2009 06:07AM

PARTITION BY HASH

6,029

Sreedevi Iyer

10/27/2009 12:20PM

Re: PARTITION BY HASH

3,562

Hartmut Holzgraefe

10/28/2009 01:00AM

Re: PARTITION BY HASH

2,508

Praveen TS

10/28/2009 04:51AM

Re-organize table not working

4,341

Wane cooper

10/23/2009 06:02AM

Re: Re-organize table not working

2,125

Rick James

10/24/2009 07:42AM

DROP TABLE which has a inverted comma in its name

4,263

Mathuvathanan Mounasamy

10/22/2009 06:02AM

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

2,049

Rick James

10/23/2009 10:25AM

Lock issues with Table Partitioning

4,585

Mustafa Sait Özen

08/31/2009 04:42AM

Re: Lock issues with Table Partitioning

5,870

Mattias Jonsson

09/15/2009 03:26AM

Re: Lock issues with Table Partitioning

2,811

kevin foote

10/08/2009 07:58AM

Re: Lock issues with Table Partitioning

3,070

Mattias Jonsson

10/08/2009 08:28AM

Re: Lock issues with Table Partitioning

2,835

kevin foote

10/08/2009 08:37AM

Re: Lock issues with Table Partitioning

2,604

Mattias Jonsson

10/08/2009 08:44AM

Re: Lock issues with Table Partitioning

3,242

Nanda kishore Toomula

08/31/2009 10:10PM

Re: Lock issues with Table Partitioning

2,970

Mustafa Sait Özen

09/01/2009 12:37AM

Re: Lock issues with Table Partitioning

2,875

Nanda kishore Toomula

09/01/2009 03:28AM

Re: Lock issues with Table Partitioning

3,730

Mustafa Sait Özen

09/01/2009 05:05AM

Re: Lock issues with Table Partitioning

3,043

Nanda kishore Toomula

09/01/2009 11:28PM

Partitioning Limitations

6,279

Premal Shah

09/17/2009 07:50PM

Re: Partitioning Limitations

2,747

Jonathan Stephens

10/03/2009 02:43AM

Re: Partitioning Limitations

2,752

Rick James

10/03/2009 06:03PM

Re: Partitioning Limitations

2,532

Jonathan Stephens

09/27/2009 10:27PM

Re: Partitioning Limitations

2,584

Rick James

09/27/2009 10:47PM

Re: Partitioning Limitations

2,545

Mattias Jonsson

09/21/2009 02:59AM

Re: Partitioning Limitations

2,694

Premal Shah

09/22/2009 08:28AM

Re: Partitioning Limitations

2,748

Rick James

09/18/2009 11:11PM

MySQL Partitioning with Dates

3,353

Edwin DeSouza

09/08/2009 04:18PM

Re: MySQL Partitioning with Dates

2,136

Jonathan Stephens

10/03/2009 02:56AM

MySQL Partition

4,344

Jonathan Valerio

10/01/2009 09:35AM

Re: MySQL Partition

2,162

Matthew Montgomery

10/01/2009 10:15AM

partitioning after and in 5.1.*

3,103

Rabie Sulman

09/23/2009 03:55AM

Re: partitioning after and in 5.1.*

2,115

Rick James

09/24/2009 09:40AM

Bug in LESS THAN combined with TO_DAYS?

3,404

Guillaume Métayer

09/14/2009 03:27PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,227

Mattias Jonsson

09/21/2009 03:44AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,472

Guillaume Métayer

09/22/2009 09:24AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,360

Mattias Jonsson

09/15/2009 02:48AM

Re: Bug in LESS THAN combined with TO_DAYS?

3,314

Guillaume Métayer

09/15/2009 01:17PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,358

Mattias Jonsson

09/16/2009 07:30AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,358

Guillaume Métayer

09/17/2009 02:39PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,233

Guillaume Métayer

09/16/2009 10:53AM

Partitioning by hour

3,533

Alejandro Boldt

09/11/2009 01:32PM

Re: Partitioning by hour

2,525

Rick James

09/12/2009 03:12PM

Re: Partitioning by hour

2,335

Rick James

09/12/2009 09:31PM

Re: Partitioning by hour

3,065

Alejandro Boldt

09/17/2009 06:31AM

Re: Partitioning by hour

2,430

Rick James

09/17/2009 08:45AM

Re: Partitioning by hour

2,584

Alejandro Boldt

09/17/2009 09:50AM

Re: Partitioning by hour

2,409

Mattias Jonsson

09/21/2009 03:55AM

Partitioning by bigint

4,891

Simon Adams 2

09/17/2009 09:34AM

Re: Partitioning by bigint

2,421

Mattias Jonsson

09/21/2009 03:12AM

Re: Partitioning by bigint

2,431

Rick James

09/18/2009 06:56PM

MySQL Partitioning with non integer values using triggers

3,002

Edwin DeSouza

09/15/2009 10:21AM

Re: MySQL Partitioning with non integer values using triggers

2,881

Rick James

09/20/2009 03:47PM

Partition by list syntax error 1064?

6,452

Brian Kelley

09/16/2009 11:49PM

Re: Partition by list syntax error 1064?

2,569

Rick James

09/18/2009 08:39AM

MySQL Partitioning: by Column-list

3,030

Edwin DeSouza

09/15/2009 10:53AM

Select cannot use partitioning correctly?

3,538

w ss12cn

08/31/2009 01:39AM

Re: Select cannot use partitioning correctly?

2,206

Mattias Jonsson

09/15/2009 03:09AM

Re: Select cannot use partitioning correctly?

2,387

Nanda kishore Toomula

08/31/2009 10:22PM

Re: Select cannot use partitioning correctly?

2,265

w ss12cn

09/03/2009 03:09AM

Partition on non key varchar column

5,143

Jay Jarman

09/11/2009 07:52AM

Re: Partition on non key varchar column

3,167

Allan Winston

09/12/2009 07:24PM

Re: Partition on non key varchar column

2,581

Rick James

09/12/2009 09:45AM

Range Partition - behavior not expected

3,438

09/02/2009 12:21PM

Re: Range Partition - behavior not expected

2,437

Nanda kishore Toomula

09/03/2009 04:28AM

Re: Range Partition - behavior not expected

2,372

09/02/2009 03:58PM

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

4,260

fran qina

08/21/2009 12:20PM

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

2,594

Nanda kishore Toomula

08/27/2009 02:49AM

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

2,425

fran qina

08/28/2009 07:16AM

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

2,390

Nanda kishore Toomula

08/29/2009 10:14PM

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

4,039

fran qina

08/26/2009 03:03PM

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

2,316

Rick James

08/27/2009 09:22PM

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

3,125

fran qina

08/21/2009 02:47PM

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

2,312

Rick James

08/22/2009 05:36PM

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

2,984

fran qina

08/21/2009 02:50PM

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

2,203

Rick James

08/22/2009 05:34PM

Select doesn't use the different partitions?

3,717

07/28/2009 01:54AM

Re: Select doesn't use the different partitions?

2,275

Allan Winston

08/15/2009 11:11PM

Re: Select doesn't use the different partitions?

2,128

08/14/2009 09:16AM

Wether is it possible to compress partitioned MyISAM tables?

6,269

Allen Wang

06/02/2009 09:30PM

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

3,419

Allan Winston

08/07/2009 02:38AM

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

3,529

Rick James

06/03/2009 11:30PM

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

3,631

08/14/2009 08:58AM

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

3,043

Allan Winston

08/15/2009 10:50PM

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

3,507

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.