MySQL :: MySQL Forums :: Partitioning

Announcements	Last Post
• MySQL Cluster 7.6.9 has been released	01/23/2019 12:57AM
• MySQL Enterprise Monitor 8.0.14 has been released	01/22/2019 05:00PM
• MySQL Cluster 7.4.23 has been released	01/22/2019 10:37AM
• MySQL Cluster 7.5.13 has been released	01/22/2019 07:19AM
• MySQL Cluster 7.3.24 has been released	01/22/2019 04:08AM

New Topic

Pages:

« 1 2 3 4 5

...

13 »

Subject

Views

Written By

Posted

Mysql 5.5 Partittioning row field

1,677

Shubham Jain

06/24/2015 10:19PM

Re: Mysql 5.5 Partittioning row field

1,247

Jonathan Stephens

06/25/2015 10:16AM

Re: Mysql 5.5 Partittioning row field

1,049

Rick James

06/26/2015 12:15AM

Re: Mysql 5.5 Partittioning row field

1,236

Jonathan Stephens

06/26/2015 02:40AM

Re: Mysql 5.5 Partittioning row field

1,041

Shubham Jain

06/26/2015 07:02AM

subpartiton by key doesn't evenly distribute data

1,722

jongse park

06/10/2015 11:20PM

Re: subpartiton by key doesn't evenly distribute data

903

Rick James

06/13/2015 08:25AM

Re: subpartiton by key doesn't evenly distribute data

934

jongse park

06/15/2015 12:01AM

Re: subpartiton by key doesn't evenly distribute data

875

Rick James

06/15/2015 07:07PM

Re: subpartiton by key doesn't evenly distribute data

1,026

jongse park

06/15/2015 10:41PM

Re: subpartiton by key doesn't evenly distribute data

948

Rick James

06/16/2015 07:36PM

Advice on partitioning

2,073

me su

04/24/2015 01:40PM

Re: Advice on partitioning

1,151

Rick James

04/24/2015 05:34PM

Re: Advice on partitioning

1,171

Mehdi Salarkia

04/27/2015 09:05AM

Re: Advice on partitioning

1,189

Rick James

04/27/2015 02:22PM

Re: Advice on partitioning

1,011

Drew Morris

04/28/2015 11:02AM

Re: Advice on partitioning

1,035

Rick James

04/28/2015 12:32PM

Re: Advice on partitioning

1,061

Mehdi Salarkia

04/28/2015 04:07PM

Re: Advice on partitioning

913

Mehdi Salarkia

06/15/2015 06:39PM

Re: Advice on partitioning

1,078

Rick James

06/15/2015 07:05PM

Re: Advice on partitioning

1,026

Mehdi Salarkia

06/16/2015 06:40PM

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

2,229

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

Rick James

05/17/2015 12:04AM

Select using partition dynamically

2,371

Jose Lima

05/07/2015 06:21PM

Re: Select using partition dynamically

1,180

Rick James

05/11/2015 12:53PM

Partitioning & Replication

1,779

Robert Gunther

04/09/2015 06:30PM

Re: Partitioning & Replication

962

Rick James

04/12/2015 09:43PM

how to speed up for List partitioning table

2,055

jongse park

12/28/2014 07:59PM

Re: how to speed up for List partitioning table

1,139

Rick James

12/30/2014 03:05PM

wrong output generate while using partitions

2,279

Shivam Patel

12/13/2014 07:56AM

Re: wrong output generate while using partitions

1,240

Rick James

12/14/2014 10:33PM

Re: wrong output generate while using partitions

1,129

Shivam Patel

12/16/2014 01:24AM

Re: wrong output generate while using partitions

1,219

Jonathan Stephens

12/16/2014 02:32AM

Re: wrong output generate while using partitions

1,201

Shivam Patel

12/16/2014 04:00AM

Re: wrong output generate while using partitions

1,112

Rick James

12/16/2014 04:28PM

Re: wrong output generate while using partitions

1,253

Shivam Patel

12/17/2014 07:20AM

Re: wrong output generate while using partitions

1,247

Rick James

12/17/2014 11:27AM

large InnoDB table partitioning without explicit PK

3,143

Miko M

11/12/2014 07:41PM

Re: large InnoDB table partitioning without explicit PK

1,751

Rick James

11/13/2014 06:40PM

Re: large InnoDB table partitioning without explicit PK

1,596

Miko M

11/14/2014 03:02AM

Re: large InnoDB table partitioning without explicit PK

1,183

Rick James

11/15/2014 12:05AM

Re: large InnoDB table partitioning without explicit PK

1,236

Miko M

11/16/2014 07:39PM

Re: large InnoDB table partitioning without explicit PK

1,135

Rick James

11/17/2014 04:21PM

Re: large InnoDB table partitioning without explicit PK

1,234

Rick James

11/17/2014 07:48PM

Re: large InnoDB table partitioning without explicit PK

1,205

Miko M

11/18/2014 02:00AM

Re: large InnoDB table partitioning without explicit PK

1,253

Rick James

11/18/2014 11:35PM

Re: large InnoDB table partitioning without explicit PK

1,270

Miko M

11/22/2014 06:44AM

Re: large InnoDB table partitioning without explicit PK

1,158

Miko M

11/18/2014 01:13AM

(non-unique) index more efficient than partition pruning

1,468

Miko M

11/19/2014 12:27AM

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

1,242

Rick James

11/19/2014 06:01PM

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

1,354

Miko M

11/22/2014 08:39AM

Re: large InnoDB table partitioning without explicit PK

1,363

Miko M

11/14/2014 03:04AM

Re: large InnoDB table partitioning without explicit PK

1,421

Miko M

11/14/2014 03:05AM

Re: large InnoDB table partitioning without explicit PK

1,456

Rick James

11/15/2014 12:32AM

Re: large InnoDB table partitioning without explicit PK

1,429

Miko M

11/16/2014 08:31PM

Re: large InnoDB table partitioning without explicit PK

1,211

Rick James

11/19/2014 12:12AM

Re: large InnoDB table partitioning without explicit PK

1,159

Miko M

11/22/2014 09:07AM

Re: large InnoDB table partitioning without explicit PK

1,161

Rick James

11/23/2014 09:00PM

Re: large InnoDB table partitioning without explicit PK

1,269

Miko M

12/01/2014 11:16AM

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

2,493

Tom Song

10/21/2014 03:53AM

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

1,179

Tom Song

10/22/2014 11:58PM

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

1,150

Rick James

10/23/2014 04:36PM

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

1,136

Tom Song

10/24/2014 02:05AM

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

1,117

Mikael Ronström

11/13/2014 06:54AM

Partitioning on account_id

2,657

Ketil Stadskleiv

10/13/2014 02:54PM

Re: Partitioning on account_id

1,335

Rick James

10/14/2014 06:04PM

Range partition and unique key

2,245

Pierrick VODOZ

09/24/2014 08:42AM

Re: Range partition and unique key

1,169

Rick James

09/25/2014 09:59AM

Re: Range partition and unique key

1,291

Pierrick VODOZ

09/26/2014 03:40AM

Re: Range partition and unique key

1,283

Rick James

09/27/2014 08:25AM

Horizontal partitioning on a per user basis?

2,178

Peter Sarkozi

09/18/2014 05:40PM

Re: Horizontal partitioning on a per user basis?

1,141

Luke Taylor

09/19/2014 01:12AM

Re: Horizontal partitioning on a per user basis?

1,204

Rick James

09/19/2014 11:18PM

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

4,068

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

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

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

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

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

Rick James

09/01/2014 08:28PM

Not Taking Paritioning when using Subquery or Join

2,232

Marc Vettorel

08/27/2014 07:08AM

Re: Not Taking Paritioning when using Subquery or Join

1,178

Marc Vettorel

08/27/2014 07:19AM

Re: Not Taking Paritioning when using Subquery or Join

1,222

Rick James

08/28/2014 10:19AM

EXCHANGE PARTITION and DATA DIRECTORY errors

2,776

Ekundayo Lasode

08/16/2014 09:47AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,333

Mattias Jonsson

08/19/2014 03:32AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,244

Ekundayo Lasode

08/19/2014 06:28AM

Storing time series data using partitioning

3,087

Florian Rampp

08/14/2014 05:45AM

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

2,200

Jon Jacob

07/20/2014 07:50AM

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

1,259

Rick James

07/21/2014 06:50PM

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

2,283

Max Herman

07/12/2014 12:35PM

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

1,278

Rick James

07/14/2014 06:45PM

why explain partition shows first partition in every select query?

2,655

Aamir Sohail

05/27/2014 07:18AM

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

1,281

Rick James

05/27/2014 03:10PM

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

1,173

Aamir Sohail

05/28/2014 12:52AM

Storing, accessing and configuring my partitions in diferent servers

2,031

Victor Bombella

05/23/2014 11:54PM

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

1,092

Rick James

05/25/2014 04:57PM

missing data after partitioning - bug?

2,517

rol and

05/23/2014 12:51PM

Re: missing data after partitioning - bug?

1,221

Rick James

05/25/2014 04:27PM

MySql Partitioning problem (bug?)

6,723

K T

05/07/2014 04:39PM

Re: MySql Partitioning problem (bug?)

1,258

Rick James

05/09/2014 11:59PM

Re: MySql Partitioning problem (bug?)

1,216

K T

05/10/2014 03:41PM

Re: MySql Partitioning problem (bug?)

1,172

K T

05/10/2014 03:44PM

Re: MySql Partitioning problem (bug?)

1,205

Mattias Jonsson

05/16/2014 06:15AM

MySQL partition by range on YEAR(date) weird results

2,728

Adelin Feraru

05/12/2014 02:15AM

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

1,277

Rick James

05/15/2014 12:01AM

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

1,144

Adelin Feraru

05/15/2014 03:38AM

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

1,180

Mattias Jonsson

05/15/2014 11:42AM

Storing tables on multiple partitions

2,170

sdgbfdsg fdhgfdhds

04/09/2014 08:04AM

Re: Storing tables on multiple partitions

1,163

Rick James

04/11/2014 04:32PM

Re: Storing tables on multiple partitions

1,160

mi Su

04/29/2014 01:09AM

MySql Horizontal partitioning - Pros-Cons

3,895

Manohar K

04/14/2014 11:43AM

Re: MySql Horizontal partitioning - Pros-Cons

1,928

Rick James

04/17/2014 11:16PM

Re: MySql Horizontal partitioning - Pros-Cons

1,442

Rick James

04/19/2014 03:42PM

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

3,042

Raghavendra K

04/14/2014 01:07AM

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

1,177

Mattias Jonsson

04/14/2014 05:05PM

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

1,147

Raghavendra K

04/16/2014 06:40AM

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

1,157

Mattias Jonsson

04/17/2014 12:55PM

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

1,157

Rick James

04/17/2014 11:36PM

Failed to read from the .par file

8,793

IGG t

04/02/2014 09:49AM

Re: Failed to read from the .par file

5,084

Rick James

04/05/2014 01:13PM

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

2,172

mi Su

01/06/2014 01:21AM

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

1,507

Rick James

01/08/2014 05:22PM

Partitioning or indexing for millions of records

2,521

Aamir Sohail

11/26/2013 05:44AM

Re: Partitioning or indexing for millions of records

1,922

Rick James

11/27/2013 12:39PM

Re: Partitioning or indexing for millions of records

1,454

Aamir Sohail

11/28/2013 12:40AM

Re: Partitioning or indexing for millions of records

1,550

Rick James

11/28/2013 09:07PM

Re: Partitioning or indexing for millions of records

1,432

Aamir Sohail

11/29/2013 04:11AM

Re: Partitioning or indexing for millions of records

1,416

Rick James

11/30/2013 01:30PM

Re: Partitioning or indexing for millions of records

1,267

chris arndt

12/31/2013 11:34AM

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

2,441

Aamir Sohail

12/04/2013 05:57AM

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

1,247

Rick James

12/05/2013 12:15PM

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

1,206

mi Su

12/10/2013 11:46PM

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

1,152

Rick James

12/13/2013 12:51AM

Am I doing this correctly?

2,215

Jim Buckley Barrett

11/29/2013 05:03AM

Re: Am I doing this correctly?

1,253

Jim Buckley Barrett

11/29/2013 06:22AM

Re: Am I doing this correctly?

1,359

Rick James

11/30/2013 02:18PM

Re: Am I doing this correctly?

1,176

mi Su

12/04/2013 12:38AM

Re: Am I doing this correctly?

1,228

Jim Buckley Barrett

12/05/2013 03:48AM

Re: Am I doing this correctly?

1,279

Rick James

12/05/2013 10:21AM

Re: Am I doing this correctly?

1,198

Jim Buckley Barrett

12/10/2013 09:49AM

Re: Am I doing this correctly?

1,244

Jim Buckley Barrett

12/05/2013 03:51AM

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

10,333

Aamir Sohail

11/28/2013 01:28AM

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

4,410

Rick James

11/29/2013 01:15AM

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

2,899

Aamir Sohail

11/29/2013 04:19AM

Partition data backup and restore

7,318

Seungho Nam Nam

10/18/2013 12:48AM

Re: Partition data backup and restore

3,406

Mattias Jonsson

10/18/2013 02:59AM

Re: Partition data backup and restore

2,445

Steven Robinson

11/07/2013 11:29PM

Changing 5.1.61 Enterprise Commerical Build to allow partitioning

2,093

mark silverman

09/19/2013 08:11AM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,223

Rick James

09/24/2013 08:51PM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,253

Mattias Jonsson

10/04/2013 01:02AM

Reorganize Partition Syntax error

2,785

IGG t

09/16/2013 03:13AM

Re: Reorganize Partition Syntax error

1,122

IGG t

09/16/2013 09:39AM

Re: Reorganize Partition Syntax error

1,132

Rick James

09/17/2013 07:19PM

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

3,310

Prabhu Raja Singh

09/13/2013 01:40AM

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

2,001

Rick James

09/15/2013 09:33PM

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

1,756

Prabhu Raja Singh

09/16/2013 03:26AM

Partitioning by date, and maintaining uniqueness

2,699

IGG t

08/13/2013 09:51AM

Re: Partitioning by date, and maintaining uniqueness

1,195

Rick James

08/14/2013 09:20AM

Re: Partitioning by date, and maintaining uniqueness

1,142

IGG t

08/14/2013 10:28AM

Re: Partitioning by date, and maintaining uniqueness

1,143

Rick James

08/31/2013 05:35PM

mysql tables in use 500, locked 500

2,528

bruce.zuo bruce

07/16/2013 03:14AM

Re: mysql tables in use 500, locked 500

1,372

Rick James

07/21/2013 12:26AM

Re: mysql tables in use 500, locked 500

1,275

bruce.zuo bruce

07/24/2013 07:12AM

Re: mysql tables in use 500, locked 500

1,115

Mattias Jonsson

08/13/2013 05:42AM

Create index on partition table (manually and dynamically)

6,194

Vladimir Pivovar

07/05/2013 11:26PM

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

2,031

Rick James

07/06/2013 10:52PM

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

1,858

Vladimir Pivovar

07/07/2013 12:20AM

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

1,689

Vladimir Pivovar

07/07/2013 10:57AM

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

1,786

Rick James

07/08/2013 09:46AM

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

2,058

Vladimir Pivovar

07/10/2013 02:23PM

how to remove partitiong in mysql version5.6

2,224

heiansan white

06/13/2013 01:41AM

Re: how to remove partitiong in mysql version5.6

1,208

Rick James

06/15/2013 01:50PM

No. of partitions in NDB cluster

1,846

Alax James

05/31/2013 02:14AM

IP vs Date Partition

2,500

Tim Linden

05/13/2013 10:28AM

Re: IP vs Date Partition

1,598

Rick James

05/14/2013 09:59PM

Re: IP vs Date Partition

1,568

Tim Linden

05/15/2013 10:06AM

How should I partition this table?

2,889

Ron Bergin

04/26/2013 09:18AM