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 2 3 4 5

...

14 »

Subject

Views

Written By

Posted

subpartition accross disk show error

1,912

Fei Tian

09/19/2016 05:23PM

Re: subpartition accross disk show error

945

Jon Stephens

09/20/2016 02:00AM

Re: subpartition accross disk show error

788

Fei Tian

09/20/2016 03:06AM

Re: subpartition accross disk show error

847

Jon Stephens

09/20/2016 11:42AM

Re: subpartition accross disk show error

888

Rick James

10/02/2016 12:58PM

what is user-defined partitioning

2,253

aaron chan

07/04/2016 07:33PM

Re: what is user-defined partitioning

1,263

Rick James

07/09/2016 10:53PM

Re: what is user-defined partitioning

1,177

Jon Stephens

07/12/2016 01:02AM

Re: what is user-defined partitioning

916

Rick James

07/15/2016 05:17PM

Re: what is user-defined partitioning

1,036

Jon Stephens

09/20/2016 03:36AM

Re: what is user-defined partitioning

883

Rick James

09/24/2016 04:40PM

Unable to EXCHANGE PARTITION when partition uses tablespace

1,753

bob Dave

06/02/2016 03:24AM

Create partition on non key column

1,745

Kapil Gupta

05/26/2016 05:51AM

Re: Create partition on non key column

955

Rick James

05/29/2016 12:28AM

MySql composite partitioning

2,300

Btissam Ghazi

03/08/2016 05:10PM

Re: MySql composite partitioning

1,148

Rick James

03/09/2016 06:59PM

MYSQL - CDC Capturing

4,409

Akshath Hegde

01/31/2016 11:48PM

Re: MYSQL - CDC Capturing

1,535

Rick James

02/01/2016 08:07PM

Re: MYSQL - CDC Capturing

1,350

Akshath Hegde

02/01/2016 09:43PM

Re: MYSQL - CDC Capturing

1,268

Rick James

02/02/2016 09:29PM

Re: MYSQL - CDC Capturing

1,394

Akshath Hegde

02/03/2016 12:23AM

Re: MYSQL - CDC Capturing

1,330

Rick James

02/04/2016 10:38PM

Partitioning of ndbcluster

1,990

Peter Mueller

01/04/2016 07:29AM

Re: Partitioning of ndbcluster

1,068

Rick James

01/05/2016 11:00PM

partition by varchar - random behavior?

2,368

mk mkrous

01/02/2016 02:07PM

Re: partition by varchar - random behavior?

1,101

Rick James

01/05/2016 10:55PM

Licensing requirements

2,051

Damien Kick

12/16/2015 03:18PM

Re: Licensing requirements

1,174

Damien Kick

12/16/2015 03:39PM

Re: Licensing requirements

1,060

Rick James

01/05/2016 10:59AM

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

6,264

MONU VERMA

11/20/2015 07:45AM

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

4,530

Rick James

12/17/2015 01:01PM

query optimization

2,159

Srilakshmi Manjunath

10/29/2015 03:08AM

Re: query optimization

1,171

Rick James

10/30/2015 04:58PM

Dose mysql partitioning support global index ?

3,083

jongse park

09/21/2015 07:31PM

Re: Dose mysql partitioning support global index ?

2,125

Jonathan Stephens

09/21/2015 11:30PM

Re: Dose mysql partitioning support global index ?

1,471

Rick James

10/02/2015 09:51PM

Should I PARTITION my table?

2,052

Rick James

10/01/2015 09:11PM

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

3,816

Akshath Hegde

08/23/2015 12:18AM

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

1,777

Rick James

08/23/2015 05:55PM

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

1,985

Akshath Hegde

08/26/2015 02:53AM

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

1,693

Rick James

08/27/2015 07:40AM

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

2,126

Sam Young

08/20/2015 08:00PM

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

1,349

Jonathan Stephens

08/21/2015 02:53AM

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

1,214

Sam Young

08/23/2015 08:57PM

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

1,247

Rick James

08/22/2015 03:35PM

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

1,222

Sam Young

08/23/2015 09:23PM

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

1,249

Rick James

08/24/2015 12:36PM

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

1,286

Sam Young

08/26/2015 12:53AM

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

1,213

Rick James

08/26/2015 10:02AM

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

1,176

Sam Young

08/26/2015 07:42PM

Dose MySQL support a dynamic pruning in mysql partitioning ?

1,937

jongse park

08/05/2015 08:41PM

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

1,134

Jonathan Stephens

08/06/2015 03:31AM

How to partition for performance

2,186

Doug Wolfgram

07/29/2015 09:42PM

Re: How to partition for performance

1,315

Rick James

07/31/2015 01:36PM

Re: How to partition for performance

1,287

Rick James

07/31/2015 02:23PM

Partition and Subpartition using Unixtime

1,904

Jaineera Naveen

07/09/2015 07:53AM

Re: Partition and Subpartition using Unixtime

1,143

Rick James

07/09/2015 11:59PM

Optimum partition for a bigger table

1,867

Jaineera Naveen

07/09/2015 12:35AM

Re: Optimum partition for a bigger table

1,124

Rick James

07/09/2015 11:36PM

Mysql 5.5 Partittioning row field

1,930

Shubham Jain

06/24/2015 10:19PM

Re: Mysql 5.5 Partittioning row field

1,438

Jonathan Stephens

06/25/2015 10:16AM

Re: Mysql 5.5 Partittioning row field

1,222

Rick James

06/26/2015 12:15AM

Re: Mysql 5.5 Partittioning row field

1,398

Jonathan Stephens

06/26/2015 02:40AM

Re: Mysql 5.5 Partittioning row field

1,180

Shubham Jain

06/26/2015 07:02AM

subpartiton by key doesn't evenly distribute data

1,973

jongse park

06/10/2015 11:20PM

Re: subpartiton by key doesn't evenly distribute data

1,040

Rick James

06/13/2015 08:25AM

Re: subpartiton by key doesn't evenly distribute data

1,082

jongse park

06/15/2015 12:01AM

Re: subpartiton by key doesn't evenly distribute data

1,011

Rick James

06/15/2015 07:07PM

Re: subpartiton by key doesn't evenly distribute data

1,231

jongse park

06/15/2015 10:41PM

Re: subpartiton by key doesn't evenly distribute data

1,063

Rick James

06/16/2015 07:36PM

Advice on partitioning

2,396

me su

04/24/2015 01:40PM

Re: Advice on partitioning

1,345

Rick James

04/24/2015 05:34PM

Re: Advice on partitioning

1,385

04/27/2015 09:05AM

Re: Advice on partitioning

1,364

Rick James

04/27/2015 02:22PM

Re: Advice on partitioning

1,188

Drew Morris

04/28/2015 11:02AM

Re: Advice on partitioning

1,214

Rick James

04/28/2015 12:32PM

Re: Advice on partitioning

1,228

04/28/2015 04:07PM

Re: Advice on partitioning

1,068

06/15/2015 06:39PM

Re: Advice on partitioning

1,262

Rick James

06/15/2015 07:05PM

Re: Advice on partitioning

1,201

06/16/2015 06:40PM

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

2,665

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

Rick James

05/17/2015 12:04AM

Select using partition dynamically

3,120

Jose Lima

05/07/2015 06:21PM

Re: Select using partition dynamically

1,484

Rick James

05/11/2015 12:53PM

Partitioning & Replication

2,018

04/09/2015 06:30PM

Re: Partitioning & Replication

1,076

Rick James

04/12/2015 09:43PM

how to speed up for List partitioning table

2,289

jongse park

12/28/2014 07:59PM

Re: how to speed up for List partitioning table

1,323

Rick James

12/30/2014 03:05PM

wrong output generate while using partitions

2,560

Shivam Patel

12/13/2014 07:56AM

Re: wrong output generate while using partitions

1,449

Rick James

12/14/2014 10:33PM

Re: wrong output generate while using partitions

1,336

Shivam Patel

12/16/2014 01:24AM

Re: wrong output generate while using partitions

1,415

Jonathan Stephens

12/16/2014 02:32AM

Re: wrong output generate while using partitions

1,384

Shivam Patel

12/16/2014 04:00AM

Re: wrong output generate while using partitions

1,274

Rick James

12/16/2014 04:28PM

Re: wrong output generate while using partitions

1,457

Shivam Patel

12/17/2014 07:20AM

Re: wrong output generate while using partitions

1,435

Rick James

12/17/2014 11:27AM

large InnoDB table partitioning without explicit PK

3,748

Miko M

11/12/2014 07:41PM

Re: large InnoDB table partitioning without explicit PK

2,040

Rick James

11/13/2014 06:40PM

Re: large InnoDB table partitioning without explicit PK

1,859

Miko M

11/14/2014 03:02AM

Re: large InnoDB table partitioning without explicit PK

1,374

Rick James

11/15/2014 12:05AM

Re: large InnoDB table partitioning without explicit PK

1,438

Miko M

11/16/2014 07:39PM

Re: large InnoDB table partitioning without explicit PK

1,357

Rick James

11/17/2014 04:21PM

Re: large InnoDB table partitioning without explicit PK

1,425

Rick James

11/17/2014 07:48PM

Re: large InnoDB table partitioning without explicit PK

1,451

Miko M

11/18/2014 02:00AM

Re: large InnoDB table partitioning without explicit PK

1,456

Rick James

11/18/2014 11:35PM

Re: large InnoDB table partitioning without explicit PK

1,473

Miko M

11/22/2014 06:44AM

Re: large InnoDB table partitioning without explicit PK

1,365

Miko M

11/18/2014 01:13AM

(non-unique) index more efficient than partition pruning

1,708

Miko M

11/19/2014 12:27AM

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

1,455

Rick James

11/19/2014 06:01PM

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

1,582

Miko M

11/22/2014 08:39AM

Re: large InnoDB table partitioning without explicit PK

1,629

Miko M

11/14/2014 03:04AM

Re: large InnoDB table partitioning without explicit PK

1,664

Miko M

11/14/2014 03:05AM

Re: large InnoDB table partitioning without explicit PK

1,697

Rick James

11/15/2014 12:32AM

Re: large InnoDB table partitioning without explicit PK

1,706

Miko M

11/16/2014 08:31PM

Re: large InnoDB table partitioning without explicit PK

1,449

Rick James

11/19/2014 12:12AM

Re: large InnoDB table partitioning without explicit PK

1,371

Miko M

11/22/2014 09:07AM

Re: large InnoDB table partitioning without explicit PK

1,387

Rick James

11/23/2014 09:00PM

Re: large InnoDB table partitioning without explicit PK

1,518

Miko M

12/01/2014 11:16AM

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

2,762

Tom Song

10/21/2014 03:53AM

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

1,314

Tom Song

10/22/2014 11:58PM

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

1,335

Rick James

10/23/2014 04:36PM

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

1,276

Tom Song

10/24/2014 02:05AM

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

1,321

Mikael Ronström

11/13/2014 06:54AM

Partitioning on account_id

2,909

Ketil Stadskleiv

10/13/2014 02:54PM

Re: Partitioning on account_id

1,481

Rick James

10/14/2014 06:04PM

Range partition and unique key

2,525

09/24/2014 08:42AM

Re: Range partition and unique key

1,318

Rick James

09/25/2014 09:59AM

Re: Range partition and unique key

1,428

09/26/2014 03:40AM

Re: Range partition and unique key

1,438

Rick James

09/27/2014 08:25AM

Horizontal partitioning on a per user basis?

2,392

Peter Sarkozi

09/18/2014 05:40PM

Re: Horizontal partitioning on a per user basis?

1,261

Luke Taylor

09/19/2014 01:12AM

Re: Horizontal partitioning on a per user basis?

1,315

Rick James

09/19/2014 11:18PM

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

4,935

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

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

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

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

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

Rick James

09/01/2014 08:28PM

Not Taking Paritioning when using Subquery or Join

2,502

Marc Vettorel

08/27/2014 07:08AM

Re: Not Taking Paritioning when using Subquery or Join

1,318

Marc Vettorel

08/27/2014 07:19AM

Re: Not Taking Paritioning when using Subquery or Join

1,378

Rick James

08/28/2014 10:19AM

EXCHANGE PARTITION and DATA DIRECTORY errors

3,440

Ekundayo Lasode

08/16/2014 09:47AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,590

Mattias Jonsson

08/19/2014 03:32AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,455

Ekundayo Lasode

08/19/2014 06:28AM

Storing time series data using partitioning

3,562

Florian Rampp

08/14/2014 05:45AM

Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"

2,406

Jon Jacob

07/20/2014 07:50AM

Re: Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"

1,405

Rick James

07/21/2014 06:50PM

Range partitioning on floor (decimal(14.4)) doesn't work :/

2,504

Max Herman

07/12/2014 12:35PM

Re: Range partitioning on floor (decimal(14.4)) doesn't work :/

1,429

Rick James

07/14/2014 06:45PM

why explain partition shows first partition in every select query?

2,923

Aamir Sohail

05/27/2014 07:18AM

Re: why explain partition shows first partition in every select query?

1,471

Rick James

05/27/2014 03:10PM

Re: why explain partition shows first partition in every select query?

1,332

Aamir Sohail

05/28/2014 12:52AM

Storing, accessing and configuring my partitions in diferent servers

2,224

Victor Bombella

05/23/2014 11:54PM

Re: Storing, accessing and configuring my partitions in diferent servers

1,209

Rick James

05/25/2014 04:57PM

missing data after partitioning - bug?

2,818

rol and

05/23/2014 12:51PM

Re: missing data after partitioning - bug?

1,354

Rick James

05/25/2014 04:27PM

MySql Partitioning problem (bug?)

6,945

K T

05/07/2014 04:39PM

Re: MySql Partitioning problem (bug?)

1,393

Rick James

05/09/2014 11:59PM

Re: MySql Partitioning problem (bug?)

1,350

K T

05/10/2014 03:41PM

Re: MySql Partitioning problem (bug?)

1,299

K T

05/10/2014 03:44PM

Re: MySql Partitioning problem (bug?)

1,356

Mattias Jonsson

05/16/2014 06:15AM

MySQL partition by range on YEAR(date) weird results

3,088

Adelin Feraru

05/12/2014 02:15AM

Re: MySQL partition by range on YEAR(date) weird results

1,420

Rick James

05/15/2014 12:01AM

Re: MySQL partition by range on YEAR(date) weird results

1,293

Adelin Feraru

05/15/2014 03:38AM

Re: MySQL partition by range on YEAR(date) weird results

1,325

Mattias Jonsson

05/15/2014 11:42AM

Storing tables on multiple partitions

2,422

sdgbfdsg fdhgfdhds

04/09/2014 08:04AM

Re: Storing tables on multiple partitions

1,301

Rick James

04/11/2014 04:32PM

Re: Storing tables on multiple partitions

1,274

mi Su

04/29/2014 01:09AM

MySql Horizontal partitioning - Pros-Cons

4,371

Manohar K

04/14/2014 11:43AM

Re: MySql Horizontal partitioning - Pros-Cons

2,161

Rick James

04/17/2014 11:16PM

Re: MySql Horizontal partitioning - Pros-Cons

1,606

Rick James

04/19/2014 03:42PM

Consumption of more hard disk space in "Copying to tmp table" phase

3,379

Raghavendra K

04/14/2014 01:07AM

Re: Consumption of more hard disk space in "Copying to tmp table" phase

1,331

Mattias Jonsson

04/14/2014 05:05PM

Re: Consumption of more hard disk space in "Copying to tmp table" phase

1,290

Raghavendra K

04/16/2014 06:40AM

Re: Consumption of more hard disk space in "Copying to tmp table" phase

1,310

Mattias Jonsson

04/17/2014 12:55PM

Re: Consumption of more hard disk space in "Copying to tmp table" phase

1,307

Rick James

04/17/2014 11:36PM

Failed to read from the .par file

12,155

IGG t

04/02/2014 09:49AM

Re: Failed to read from the .par file

6,630

Rick James

04/05/2014 01:13PM

How to extend partition when there is no unallocated space in hard disk?

2,378

mi Su

01/06/2014 01:21AM

Re: How to extend partition when there is no unallocated space in hard disk?

1,712

Rick James

01/08/2014 05:22PM

Partitioning or indexing for millions of records

2,741

Aamir Sohail

11/26/2013 05:44AM

Re: Partitioning or indexing for millions of records

2,070

Rick James

11/27/2013 12:39PM

Re: Partitioning or indexing for millions of records

1,640

Aamir Sohail

11/28/2013 12:40AM

Re: Partitioning or indexing for millions of records

1,709

Rick James

11/28/2013 09:07PM

Re: Partitioning or indexing for millions of records

1,595

Aamir Sohail

11/29/2013 04:11AM

Re: Partitioning or indexing for millions of records

1,576

Rick James

11/30/2013 01:30PM

Re: Partitioning or indexing for millions of records

1,412

chris arndt

12/31/2013 11:34AM

best way to take backup for old partition and create new one?

2,645

Aamir Sohail

12/04/2013 05:57AM

Re: best way to take backup for old partition and create new one?

1,351

Rick James

12/05/2013 12:15PM

Re: best way to take backup for old partition and create new one?

1,327

mi Su

12/10/2013 11:46PM

Re: best way to take backup for old partition and create new one?

1,273

Rick James

12/13/2013 12:51AM

Pages:

« 1 2 3 4 5

...

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.