MySQL :: MySQL Forums :: Partitioning

Announcements	Last Post
• MySQL Cluster 7.3.23 has been released	10/23/2018 01:10PM
• MySQL Cluster 7.6.8 has been released	10/23/2018 11:46AM
• MySQL Cluster 7.4.22 has been released	10/23/2018 09:09AM
• MySQL Cluster 8.0.13-dmr has been released	10/23/2018 08:12AM
• MySQL Cluster 7.5.12 has been released	10/23/2018 05:50AM

New Topic

Pages:

« 1 2 3 4 5

...

13 »

Subject

Views

Written By

Posted

Mysql 5.5 Partittioning row field

1,655

Shubham Jain

06/24/2015 10:19PM

Re: Mysql 5.5 Partittioning row field

1,218

Jonathan Stephens

06/25/2015 10:16AM

Re: Mysql 5.5 Partittioning row field

1,031

Rick James

06/26/2015 12:15AM

Re: Mysql 5.5 Partittioning row field

1,219

Jonathan Stephens

06/26/2015 02:40AM

Re: Mysql 5.5 Partittioning row field

1,025

Shubham Jain

06/26/2015 07:02AM

subpartiton by key doesn't evenly distribute data

1,689

jongse park

06/10/2015 11:20PM

Re: subpartiton by key doesn't evenly distribute data

896

Rick James

06/13/2015 08:25AM

Re: subpartiton by key doesn't evenly distribute data

925

jongse park

06/15/2015 12:01AM

Re: subpartiton by key doesn't evenly distribute data

863

Rick James

06/15/2015 07:07PM

Re: subpartiton by key doesn't evenly distribute data

997

jongse park

06/15/2015 10:41PM

Re: subpartiton by key doesn't evenly distribute data

931

Rick James

06/16/2015 07:36PM

Advice on partitioning

2,039

me su

04/24/2015 01:40PM

Re: Advice on partitioning

1,133

Rick James

04/24/2015 05:34PM

Re: Advice on partitioning

1,146

Mehdi Salarkia

04/27/2015 09:05AM

Re: Advice on partitioning

1,163

Rick James

04/27/2015 02:22PM

Re: Advice on partitioning

978

Drew Morris

04/28/2015 11:02AM

Re: Advice on partitioning

1,017

Rick James

04/28/2015 12:32PM

Re: Advice on partitioning

1,035

Mehdi Salarkia

04/28/2015 04:07PM

Re: Advice on partitioning

888

Mehdi Salarkia

06/15/2015 06:39PM

Re: Advice on partitioning

1,061

Rick James

06/15/2015 07:05PM

Re: Advice on partitioning

1,003

Mehdi Salarkia

06/16/2015 06:40PM

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

2,189

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

Rick James

05/17/2015 12:04AM

Select using partition dynamically

2,302

Jose Lima

05/07/2015 06:21PM

Re: Select using partition dynamically

1,147

Rick James

05/11/2015 12:53PM

Partitioning & Replication

1,754

Robert Gunther

04/09/2015 06:30PM

Re: Partitioning & Replication

949

Rick James

04/12/2015 09:43PM

how to speed up for List partitioning table

2,032

jongse park

12/28/2014 07:59PM

Re: how to speed up for List partitioning table

1,119

Rick James

12/30/2014 03:05PM

wrong output generate while using partitions

2,256

Shivam Patel

12/13/2014 07:56AM

Re: wrong output generate while using partitions

1,217

Rick James

12/14/2014 10:33PM

Re: wrong output generate while using partitions

1,105

Shivam Patel

12/16/2014 01:24AM

Re: wrong output generate while using partitions

1,188

Jonathan Stephens

12/16/2014 02:32AM

Re: wrong output generate while using partitions

1,185

Shivam Patel

12/16/2014 04:00AM

Re: wrong output generate while using partitions

1,085

Rick James

12/16/2014 04:28PM

Re: wrong output generate while using partitions

1,225

Shivam Patel

12/17/2014 07:20AM

Re: wrong output generate while using partitions

1,221

Rick James

12/17/2014 11:27AM

large InnoDB table partitioning without explicit PK

3,081

Miko M

11/12/2014 07:41PM

Re: large InnoDB table partitioning without explicit PK

1,721

Rick James

11/13/2014 06:40PM

Re: large InnoDB table partitioning without explicit PK

1,564

Miko M

11/14/2014 03:02AM

Re: large InnoDB table partitioning without explicit PK

1,169

Rick James

11/15/2014 12:05AM

Re: large InnoDB table partitioning without explicit PK

1,214

Miko M

11/16/2014 07:39PM

Re: large InnoDB table partitioning without explicit PK

1,105

Rick James

11/17/2014 04:21PM

Re: large InnoDB table partitioning without explicit PK

1,209

Rick James

11/17/2014 07:48PM

Re: large InnoDB table partitioning without explicit PK

1,183

Miko M

11/18/2014 02:00AM

Re: large InnoDB table partitioning without explicit PK

1,225

Rick James

11/18/2014 11:35PM

Re: large InnoDB table partitioning without explicit PK

1,245

Miko M

11/22/2014 06:44AM

Re: large InnoDB table partitioning without explicit PK

1,141

Miko M

11/18/2014 01:13AM

(non-unique) index more efficient than partition pruning

1,439

Miko M

11/19/2014 12:27AM

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

1,220

Rick James

11/19/2014 06:01PM

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

1,337

Miko M

11/22/2014 08:39AM

Re: large InnoDB table partitioning without explicit PK

1,325

Miko M

11/14/2014 03:04AM

Re: large InnoDB table partitioning without explicit PK

1,392

Miko M

11/14/2014 03:05AM

Re: large InnoDB table partitioning without explicit PK

1,431

Rick James

11/15/2014 12:32AM

Re: large InnoDB table partitioning without explicit PK

1,399

Miko M

11/16/2014 08:31PM

Re: large InnoDB table partitioning without explicit PK

1,181

Rick James

11/19/2014 12:12AM

Re: large InnoDB table partitioning without explicit PK

1,135

Miko M

11/22/2014 09:07AM

Re: large InnoDB table partitioning without explicit PK

1,132

Rick James

11/23/2014 09:00PM

Re: large InnoDB table partitioning without explicit PK

1,245

Miko M

12/01/2014 11:16AM

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

2,461

Tom Song

10/21/2014 03:53AM

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

1,157

Tom Song

10/22/2014 11:58PM

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

1,127

Rick James

10/23/2014 04:36PM

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

1,128

Tom Song

10/24/2014 02:05AM

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

1,098

Mikael Ronström

11/13/2014 06:54AM

Partitioning on account_id

2,631

Ketil Stadskleiv

10/13/2014 02:54PM

Re: Partitioning on account_id

1,314

Rick James

10/14/2014 06:04PM

Range partition and unique key

2,212

Pierrick VODOZ

09/24/2014 08:42AM

Re: Range partition and unique key

1,147

Rick James

09/25/2014 09:59AM

Re: Range partition and unique key

1,271

Pierrick VODOZ

09/26/2014 03:40AM

Re: Range partition and unique key

1,263

Rick James

09/27/2014 08:25AM

Horizontal partitioning on a per user basis?

2,163

Peter Sarkozi

09/18/2014 05:40PM

Re: Horizontal partitioning on a per user basis?

1,121

Luke Taylor

09/19/2014 01:12AM

Re: Horizontal partitioning on a per user basis?

1,191

Rick James

09/19/2014 11:18PM

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

3,971

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

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

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

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

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

Rick James

09/01/2014 08:28PM

Not Taking Paritioning when using Subquery or Join

2,190

Marc Vettorel

08/27/2014 07:08AM

Re: Not Taking Paritioning when using Subquery or Join

1,167

Marc Vettorel

08/27/2014 07:19AM

Re: Not Taking Paritioning when using Subquery or Join

1,203

Rick James

08/28/2014 10:19AM

EXCHANGE PARTITION and DATA DIRECTORY errors

2,714

Ekundayo Lasode

08/16/2014 09:47AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,299

Mattias Jonsson

08/19/2014 03:32AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,223

Ekundayo Lasode

08/19/2014 06:28AM

Storing time series data using partitioning

3,052

Florian Rampp

08/14/2014 05:45AM

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

2,185

Jon Jacob

07/20/2014 07:50AM

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

1,240

Rick James

07/21/2014 06:50PM

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

2,260

Max Herman

07/12/2014 12:35PM

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

1,266

Rick James

07/14/2014 06:45PM

why explain partition shows first partition in every select query?

2,609

Aamir Sohail

05/27/2014 07:18AM

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

1,257

Rick James

05/27/2014 03:10PM

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

1,163

Aamir Sohail

05/28/2014 12:52AM

Storing, accessing and configuring my partitions in diferent servers

2,021

Victor Bombella

05/23/2014 11:54PM

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

1,080

Rick James

05/25/2014 04:57PM

missing data after partitioning - bug?

2,493

rol and

05/23/2014 12:51PM

Re: missing data after partitioning - bug?

1,201

Rick James

05/25/2014 04:27PM

MySql Partitioning problem (bug?)

6,687

K T

05/07/2014 04:39PM

Re: MySql Partitioning problem (bug?)

1,240

Rick James

05/09/2014 11:59PM

Re: MySql Partitioning problem (bug?)

1,199

K T

05/10/2014 03:41PM

Re: MySql Partitioning problem (bug?)

1,160

K T

05/10/2014 03:44PM

Re: MySql Partitioning problem (bug?)

1,193

Mattias Jonsson

05/16/2014 06:15AM

MySQL partition by range on YEAR(date) weird results

2,697

Adelin Feraru

05/12/2014 02:15AM

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

1,261

Rick James

05/15/2014 12:01AM

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

1,127

Adelin Feraru

05/15/2014 03:38AM

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

1,162

Mattias Jonsson

05/15/2014 11:42AM

Storing tables on multiple partitions

2,137

sdgbfdsg fdhgfdhds

04/09/2014 08:04AM

Re: Storing tables on multiple partitions

1,143

Rick James

04/11/2014 04:32PM

Re: Storing tables on multiple partitions

1,148

mi Su

04/29/2014 01:09AM

MySql Horizontal partitioning - Pros-Cons

3,845

Manohar K

04/14/2014 11:43AM

Re: MySql Horizontal partitioning - Pros-Cons

1,901

Rick James

04/17/2014 11:16PM

Re: MySql Horizontal partitioning - Pros-Cons

1,415

Rick James

04/19/2014 03:42PM

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

3,012

Raghavendra K

04/14/2014 01:07AM

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

1,158

Mattias Jonsson

04/14/2014 05:05PM

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

1,133

Raghavendra K

04/16/2014 06:40AM

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

1,136

Mattias Jonsson

04/17/2014 12:55PM

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

1,143

Rick James

04/17/2014 11:36PM

Failed to read from the .par file

8,411

IGG t

04/02/2014 09:49AM

Re: Failed to read from the .par file

4,880

Rick James

04/05/2014 01:13PM

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

2,154

mi Su

01/06/2014 01:21AM

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

1,485

Rick James

01/08/2014 05:22PM

Partitioning or indexing for millions of records

2,501

Aamir Sohail

11/26/2013 05:44AM

Re: Partitioning or indexing for millions of records

1,898

Rick James

11/27/2013 12:39PM

Re: Partitioning or indexing for millions of records

1,435

Aamir Sohail

11/28/2013 12:40AM

Re: Partitioning or indexing for millions of records

1,530

Rick James

11/28/2013 09:07PM

Re: Partitioning or indexing for millions of records

1,417

Aamir Sohail

11/29/2013 04:11AM

Re: Partitioning or indexing for millions of records

1,402

Rick James

11/30/2013 01:30PM

Re: Partitioning or indexing for millions of records

1,246

chris arndt

12/31/2013 11:34AM

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

2,418

Aamir Sohail

12/04/2013 05:57AM

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

1,235

Rick James

12/05/2013 12:15PM

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

1,198

mi Su

12/10/2013 11:46PM

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

1,142

Rick James

12/13/2013 12:51AM

Am I doing this correctly?

2,193

Jim Buckley Barrett

11/29/2013 05:03AM

Re: Am I doing this correctly?

1,243

Jim Buckley Barrett

11/29/2013 06:22AM

Re: Am I doing this correctly?

1,342

Rick James

11/30/2013 02:18PM

Re: Am I doing this correctly?

1,158

mi Su

12/04/2013 12:38AM

Re: Am I doing this correctly?

1,219

Jim Buckley Barrett

12/05/2013 03:48AM

Re: Am I doing this correctly?

1,271

Rick James

12/05/2013 10:21AM

Re: Am I doing this correctly?

1,182

Jim Buckley Barrett

12/10/2013 09:49AM

Re: Am I doing this correctly?

1,226

Jim Buckley Barrett

12/05/2013 03:51AM

error 1503: A primary key must include all columns in the table

9,892

Aamir Sohail

11/28/2013 01:28AM

Re: error 1503: A primary key must include all columns in the table

4,237

Rick James

11/29/2013 01:15AM

Re: error 1503: A primary key must include all columns in the table

2,795

Aamir Sohail

11/29/2013 04:19AM

Partition data backup and restore

7,123

Seungho Nam Nam

10/18/2013 12:48AM

Re: Partition data backup and restore

3,312

Mattias Jonsson

10/18/2013 02:59AM

Re: Partition data backup and restore

2,377

Steven Robinson

11/07/2013 11:29PM

Changing 5.1.61 Enterprise Commerical Build to allow partitioning

2,063

mark silverman

09/19/2013 08:11AM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,210

Rick James

09/24/2013 08:51PM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,237

Mattias Jonsson

10/04/2013 01:02AM

Reorganize Partition Syntax error

2,760

IGG t

09/16/2013 03:13AM

Re: Reorganize Partition Syntax error

1,110

IGG t

09/16/2013 09:39AM

Re: Reorganize Partition Syntax error

1,117

Rick James

09/17/2013 07:19PM

How to do partition for 100GB MySQL existing Table in zero downtime?

3,258

Prabhu Raja Singh

09/13/2013 01:40AM

Re: How to do partition for 100GB MySQL existing Table in zero downtime?

1,976

Rick James

09/15/2013 09:33PM

Re: How to do partition for 100GB MySQL existing Table in zero downtime?

1,725

Prabhu Raja Singh

09/16/2013 03:26AM

Partitioning by date, and maintaining uniqueness

2,681

IGG t

08/13/2013 09:51AM

Re: Partitioning by date, and maintaining uniqueness

1,183

Rick James

08/14/2013 09:20AM

Re: Partitioning by date, and maintaining uniqueness

1,132

IGG t

08/14/2013 10:28AM

Re: Partitioning by date, and maintaining uniqueness

1,136

Rick James

08/31/2013 05:35PM

mysql tables in use 500, locked 500

2,515

bruce.zuo bruce

07/16/2013 03:14AM

Re: mysql tables in use 500, locked 500

1,355

Rick James

07/21/2013 12:26AM

Re: mysql tables in use 500, locked 500

1,262

bruce.zuo bruce

07/24/2013 07:12AM

Re: mysql tables in use 500, locked 500

1,103

Mattias Jonsson

08/13/2013 05:42AM

Create index on partition table (manually and dynamically)

6,030

Vladimir Pivovar

07/05/2013 11:26PM

Re: Create index on parttion table (manually and dynamically)

1,981

Rick James

07/06/2013 10:52PM

Re: Create index on parttion table (manually and dynamically)

1,817

Vladimir Pivovar

07/07/2013 12:20AM

Re: Create index on parttion table (manually and dynamically)

1,660

Vladimir Pivovar

07/07/2013 10:57AM

Re: Create index on parttion table (manually and dynamically)

1,750

Rick James

07/08/2013 09:46AM

Re: Create index on partition table (manually and dynamically)

2,026

Vladimir Pivovar

07/10/2013 02:23PM

how to remove partitiong in mysql version5.6

2,208

heiansan white

06/13/2013 01:41AM

Re: how to remove partitiong in mysql version5.6

1,193

Rick James

06/15/2013 01:50PM

No. of partitions in NDB cluster

1,823

Alax James

05/31/2013 02:14AM

IP vs Date Partition

2,480

Tim Linden

05/13/2013 10:28AM

Re: IP vs Date Partition

1,589

Rick James

05/14/2013 09:59PM

Re: IP vs Date Partition

1,557

Tim Linden

05/15/2013 10:06AM

How should I partition this table?

2,856

Ron Bergin

04/26/2013 09:18AM