MySQL :: MySQL Forums :: Partitioning

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Pages:

« 1

...

5 6 7 8 9

...

14 »

Subject

Views

Written By

Posted

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

24,589

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

Mattias Jonsson

02/19/2010 04:22AM

PARTITION BY LIST "catch-all" partition

5,497

Egor Ivkin

01/20/2010 03:25AM

Re: PARTITION BY LIST "catch-all" partition

2,389

Mattias Jonsson

01/23/2010 03:55AM

Re: PARTITION BY LIST "catch-all" partition

2,322

Egor Ivkin

01/23/2010 08:20AM

Re: PARTITION BY LIST "catch-all" partition

2,404

Rick James

01/22/2010 11:05PM

Re: PARTITION BY LIST "catch-all" partition

2,358

Egor Ivkin

01/23/2010 12:30AM

Why doesn't partitioning support INSERT DELAYED?

4,947

Ben Vaughn

01/14/2010 06:50PM

Re: Why doesn't partitioning support INSERT DELAYED?

2,514

Mattias Jonsson

01/16/2010 06:48PM

Re: Why doesn't partitioning support INSERT DELAYED?

2,373

Rick James

01/22/2010 11:16PM

Partitioning with range(to_days) issue

11,461

10/29/2009 11:13AM

Re: Partitioning with range(to_days) issue

3,218

Sarah Sproehnle

11/05/2009 07:47PM

Re: Partitioning with range(to_days) issue

2,915

01/13/2010 06:36AM

Re: Partitioning with range(to_days) issue

3,359

Jason Shoulet

11/05/2009 03:12AM

Re: Partitioning with range(to_days) issue

3,242

Rick James

11/05/2009 08:37AM

Re: Partitioning with range(to_days) issue

4,162

Jason Shoulet

11/05/2009 09:51AM

Re: Partitioning with range(to_days) issue

3,050

Mattias Jonsson

11/17/2009 05:51AM

Re: Partitioning with range(to_days) issue

3,700

Rick James

10/31/2009 12:00PM

Re: Partitioning with range(to_days) issue

3,376

11/02/2009 04:07AM

Re: Partitioning with range(to_days) issue

3,219

Rick James

11/02/2009 10:22AM

Re: Partitioning with range(to_days) issue

3,209

11/03/2009 02:18AM

Re: Partitioning with range(to_days) issue

3,929

Rick James

11/03/2009 09:32AM

Re: Partitioning with range(to_days) issue

2,937

01/13/2010 05:17AM

Re: Partitioning with range(to_days) issue

2,847

Rick James

01/22/2010 11:09PM

Partitioned table using two storage engines?

3,420

01/07/2010 03:47PM

Re: Partitioned table using two storage engines?

2,097

Mattias Jonsson

01/13/2010 05:00AM

Sub partitions

4,363

AR Mahdi

01/12/2010 03:09AM

Re: Sub partitions

2,233

Mattias Jonsson

01/13/2010 04:51AM

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

7,300

DevZone Comment System

12/24/2009 01:26PM

Building Indexes across partitioned tables longer each day

4,462

Edward Capriolo

12/21/2009 10:46AM

Re: Building Indexes across partitioned tables longer each day

2,579

Rick James

12/22/2009 10:17PM

Re: Building Indexes across partitioned tables longer each day

2,392

Edward Capriolo

12/23/2009 12:30PM

Re: Building Indexes across partitioned tables longer each day

2,438

Mattias Jonsson

12/22/2009 02:48AM

alter table rebuild partition locks reads

6,075

Chris C

12/18/2009 01:24AM

Re: alter table rebuild partition locks reads

2,929

Chris C

12/18/2009 02:27AM

Re: alter table rebuild partition locks reads

2,532

Rick James

12/19/2009 09:22AM

Re: alter table rebuild partition locks reads

2,569

Chris C

12/20/2009 08:41PM

Re: alter table rebuild partition locks reads

2,667

Chris C

12/21/2009 03:04PM

Re: alter table rebuild partition locks reads

2,458

Mattias Jonsson

12/22/2009 02:37AM

Re: alter table rebuild partition locks reads

2,459

Chris C

12/22/2009 10:17AM

Hash and Linear Hash partition table not performing well

6,349

Neeraj Khandelwal

11/27/2009 03:04AM

Re: Hash and Linear Hash partition table not performing well

2,861

Mattias Jonsson

12/07/2009 04:44AM

Re: Hash and Linear Hash partition table not performing well

2,708

Neeraj Khandelwal

12/08/2009 01:05AM

Re: Hash and Linear Hash partition table not performing well

3,563

Mattias Jonsson

12/22/2009 03:29AM

Re: Hash and Linear Hash partition table not performing well

3,070

Rick James

12/05/2009 11:49PM

Re: Hash and Linear Hash partition table not performing well

3,121

Neeraj Khandelwal

12/08/2009 03:42AM

Re: Hash and Linear Hash partition table not performing well

3,609

Rick James

12/09/2009 08:08PM

Archiving Partition .MYD files

5,788

Dominic Edwards

12/11/2009 05:41AM

Re: Archiving Partition .MYD files

2,810

Dominic Edwards

12/11/2009 05:48AM

Re: Archiving Partition .MYD files

2,735

Rick James

12/12/2009 03:48PM

Re: Archiving Partition .MYD files

2,995

Mattias Jonsson

12/22/2009 03:00AM

partitioning question?

3,930

asmaa atef

12/14/2009 08:34AM

Re: partitioning question?

2,304

Mattias Jonsson

12/22/2009 02:50AM

Re: partitioning question?

2,421

Rick James

12/16/2009 12:33AM

Re: partitioning question?

2,222

asmaa atef

12/16/2009 07:44AM

Re: partitioning question?

2,372

Rick James

12/16/2009 11:53PM

Re: partitioning question?

2,319

asmaa atef

12/17/2009 02:39AM

Re: partitioning question?

2,233

Rick James

12/18/2009 12:40AM

Minimum number of rows for using partitioning

5,327

Ramesh Kumar

12/10/2009 10:57PM

Re: Minimum number of rows for using partitioning

2,431

Rick James

12/12/2009 10:58PM

Re: Minimum number of rows for using partitioning

2,738

Ramesh Kumar

12/13/2009 09:57PM

Re: Minimum number of rows for using partitioning

2,377

Rick James

12/14/2009 12:17AM

Re: Minimum number of rows for using partitioning

2,724

Ramesh Kumar

12/14/2009 12:57AM

Range Partition Pruning on TO_DAYS Problem

4,286

Dominic Edwards

11/12/2009 10:06AM

Re: Range Partition Pruning on TO_DAYS Problem

2,978

Mattias Jonsson

11/17/2009 06:09AM

Re: Range Partition Pruning on TO_DAYS Problem

2,420

Rick James

11/17/2009 08:41PM

Re: Range Partition Pruning on TO_DAYS Problem

2,307

Dominic Edwards

12/11/2009 05:45AM

Create new partition for an existing table?

4,725

hung chu

11/26/2009 10:27PM

Re: Create new partition for an existing table?

2,590

Rick James

12/05/2009 11:55PM

How transaction work with partitioned table?

3,223

hung chu

11/30/2009 04:13AM

Re: How transaction work with partitioned table?

2,158

Rick James

12/05/2009 11:45PM

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

3,957

12/04/2009 11:24AM

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

2,130

Rick James

12/05/2009 03:06PM

partitioning

3,801

gururaj sheth

11/19/2009 12:39AM

Re: partitioning

2,397

Devart Team

11/20/2009 05:01AM

Re: partitioning

2,249

Rick James

11/20/2009 07:47PM

Subpartitioned by LIST

5,969

Praveen TS

11/06/2009 03:57AM

Re: Subpartitioned by LIST

2,770

Mattias Jonsson

11/17/2009 05:56AM

Re: Subpartitioned by LIST

2,536

Praveen TS

11/08/2009 10:36PM

Re: Subpartitioned by LIST

2,601

Rick James

11/09/2009 09:44AM

Re: Subpartitioned by LIST

2,241

Rick James

11/07/2009 04:07PM

Subpartition Pruning

5,260

Mathuvathanan Mounasamy

10/16/2009 04:08AM

Re: Subpartition Pruning

2,474

Mattias Jonsson

11/17/2009 05:40AM

Vertical Partitioning

3,921

Laavanya K

11/10/2009 09:41PM

Re: Vertical Partitioning

2,676

Rick James

11/11/2009 11:57PM

Re: Vertical Partitioning

2,248

Laavanya K

11/12/2009 12:02AM

Re: Vertical Partitioning

2,383

Rick James

11/12/2009 08:47PM

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

3,325

Edwin DeSouza

11/11/2009 11:19AM

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

3,106

Edwin DeSouza

11/10/2009 11:22AM

Partitioning and JOIN

7,660

m z

11/05/2009 02:07PM

Re: Partitioning and JOIN

3,078

Rick James

11/06/2009 08:26PM

Re: Partitioning and JOIN

3,346

m z

11/06/2009 11:15AM

Partitioning on existing table

4,527

Eyrique Wong

11/04/2009 09:33PM

Re: Partitioning on existing table

2,508

Rick James

11/05/2009 11:35PM

Re: Partitioning on existing table

2,365

Eyrique Wong

11/06/2009 01:17AM

Re: Partitioning on existing table

2,708

Rick James

11/06/2009 10:49AM

Re: Partitioning on existing table

2,423

m z

11/05/2009 08:45PM

Backup a partition to archive.

3,895

Shankar R

10/30/2009 11:32PM

Re: Backup a partition to archive.

2,324

Shankar R

11/01/2009 02:39PM

Re: Backup a partition to archive.

2,747

Rick James

11/01/2009 11:26AM

PARTITION or sEPERATE tABLE ISSUE

3,476

hrishi patil

10/29/2009 06:32AM

Re: PARTITION or sEPERATE tABLE ISSUE

2,197

Rick James

10/30/2009 09:35AM

PARTITION or sEPERATE tABLE ISSUE

3,207

hrishi patil

10/29/2009 06:07AM

PARTITION BY HASH

6,495

Sreedevi Iyer

10/27/2009 12:20PM

Re: PARTITION BY HASH

3,629

Hartmut Holzgraefe

10/28/2009 01:00AM

Re: PARTITION BY HASH

2,564

Praveen TS

10/28/2009 04:51AM

Re-organize table not working

4,460

Wane cooper

10/23/2009 06:02AM

Re: Re-organize table not working

2,188

Rick James

10/24/2009 07:42AM

DROP TABLE which has a inverted comma in its name

4,439

Mathuvathanan Mounasamy

10/22/2009 06:02AM

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

2,113

Rick James

10/23/2009 10:25AM

Lock issues with Table Partitioning

4,765

Mustafa Sait Özen

08/31/2009 04:42AM

Re: Lock issues with Table Partitioning

6,013

Mattias Jonsson

09/15/2009 03:26AM

Re: Lock issues with Table Partitioning

2,916

kevin foote

10/08/2009 07:58AM

Re: Lock issues with Table Partitioning

3,177

Mattias Jonsson

10/08/2009 08:28AM

Re: Lock issues with Table Partitioning

2,916

kevin foote

10/08/2009 08:37AM

Re: Lock issues with Table Partitioning

2,684

Mattias Jonsson

10/08/2009 08:44AM

Re: Lock issues with Table Partitioning

3,326

Nanda kishore Toomula

08/31/2009 10:10PM

Re: Lock issues with Table Partitioning

3,052

Mustafa Sait Özen

09/01/2009 12:37AM

Re: Lock issues with Table Partitioning

2,976

Nanda kishore Toomula

09/01/2009 03:28AM

Re: Lock issues with Table Partitioning

3,810

Mustafa Sait Özen

09/01/2009 05:05AM

Re: Lock issues with Table Partitioning

3,119

Nanda kishore Toomula

09/01/2009 11:28PM

Partitioning Limitations

6,449

Premal Shah

09/17/2009 07:50PM

Re: Partitioning Limitations

2,836

Jonathan Stephens

10/03/2009 02:43AM

Re: Partitioning Limitations

2,829

Rick James

10/03/2009 06:03PM

Re: Partitioning Limitations

2,613

Jonathan Stephens

09/27/2009 10:27PM

Re: Partitioning Limitations

2,660

Rick James

09/27/2009 10:47PM

Re: Partitioning Limitations

2,611

Mattias Jonsson

09/21/2009 02:59AM

Re: Partitioning Limitations

2,753

Premal Shah

09/22/2009 08:28AM

Re: Partitioning Limitations

2,842

Rick James

09/18/2009 11:11PM

MySQL Partitioning with Dates

3,483

Edwin DeSouza

09/08/2009 04:18PM

Re: MySQL Partitioning with Dates

2,204

Jonathan Stephens

10/03/2009 02:56AM

MySQL Partition

4,461

Jonathan Valerio

10/01/2009 09:35AM

Re: MySQL Partition

2,222

Matthew Montgomery

10/01/2009 10:15AM

partitioning after and in 5.1.*

3,207

Rabie Sulman

09/23/2009 03:55AM

Re: partitioning after and in 5.1.*

2,176

Rick James

09/24/2009 09:40AM

Bug in LESS THAN combined with TO_DAYS?

3,539

Guillaume Métayer

09/14/2009 03:27PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,290

Mattias Jonsson

09/21/2009 03:44AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,545

Guillaume Métayer

09/22/2009 09:24AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,425

Mattias Jonsson

09/15/2009 02:48AM

Re: Bug in LESS THAN combined with TO_DAYS?

3,392

Guillaume Métayer

09/15/2009 01:17PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,422

Mattias Jonsson

09/16/2009 07:30AM

Re: Bug in LESS THAN combined with TO_DAYS?

2,425

Guillaume Métayer

09/17/2009 02:39PM

Re: Bug in LESS THAN combined with TO_DAYS?

2,307

Guillaume Métayer

09/16/2009 10:53AM

Partitioning by hour

3,663

Alejandro Boldt

09/11/2009 01:32PM

Re: Partitioning by hour

2,594

Rick James

09/12/2009 03:12PM

Re: Partitioning by hour

2,404

Rick James

09/12/2009 09:31PM

Re: Partitioning by hour

3,155

Alejandro Boldt

09/17/2009 06:31AM

Re: Partitioning by hour

2,511

Rick James

09/17/2009 08:45AM

Re: Partitioning by hour

2,666

Alejandro Boldt

09/17/2009 09:50AM

Re: Partitioning by hour

2,479

Mattias Jonsson

09/21/2009 03:55AM

Partitioning by bigint

5,047

Simon Adams 2

09/17/2009 09:34AM

Re: Partitioning by bigint

2,505

Mattias Jonsson

09/21/2009 03:12AM

Re: Partitioning by bigint

2,507

Rick James

09/18/2009 06:56PM

MySQL Partitioning with non integer values using triggers

3,123

Edwin DeSouza

09/15/2009 10:21AM

Re: MySQL Partitioning with non integer values using triggers

2,954

Rick James

09/20/2009 03:47PM

Partition by list syntax error 1064?

6,666

Brian Kelley

09/16/2009 11:49PM

Re: Partition by list syntax error 1064?

2,635

Rick James

09/18/2009 08:39AM

MySQL Partitioning: by Column-list

3,147

Edwin DeSouza

09/15/2009 10:53AM

Select cannot use partitioning correctly?

3,657

w ss12cn

08/31/2009 01:39AM

Re: Select cannot use partitioning correctly?

2,267

Mattias Jonsson

09/15/2009 03:09AM

Re: Select cannot use partitioning correctly?

2,462

Nanda kishore Toomula

08/31/2009 10:22PM

Re: Select cannot use partitioning correctly?

2,327

w ss12cn

09/03/2009 03:09AM

Partition on non key varchar column

5,284

Jay Jarman

09/11/2009 07:52AM

Re: Partition on non key varchar column

3,254

Allan Winston

09/12/2009 07:24PM

Re: Partition on non key varchar column

2,634

Rick James

09/12/2009 09:45AM

Range Partition - behavior not expected

3,548

09/02/2009 12:21PM

Re: Range Partition - behavior not expected

2,510

Nanda kishore Toomula

09/03/2009 04:28AM

Re: Range Partition - behavior not expected

2,436

09/02/2009 03:58PM

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

4,402

fran qina

08/21/2009 12:20PM

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

2,652

Nanda kishore Toomula

08/27/2009 02:49AM

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

2,491

fran qina

08/28/2009 07:16AM

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

2,447

Nanda kishore Toomula

08/29/2009 10:14PM

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

4,158

fran qina

08/26/2009 03:03PM

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

2,395

Rick James

08/27/2009 09:22PM

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

3,232

fran qina

08/21/2009 02:47PM

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

2,364

Rick James

08/22/2009 05:36PM

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

3,088

fran qina

08/21/2009 02:50PM

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

2,258

Rick James

08/22/2009 05:34PM

Select doesn't use the different partitions?

3,868

07/28/2009 01:54AM

Re: Select doesn't use the different partitions?

2,341

Allan Winston

08/15/2009 11:11PM

Re: Select doesn't use the different partitions?

2,198

08/14/2009 09:16AM

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.