MySQL :: MySQL Forums :: Partitioning

New Topic

Pages:

« 1 2 3 4 5

...

13 »

Subject

Views

Written By

Posted

Dose MySQL support a dynamic pruning in mysql partitioning ?

1,766

jongse park

08/05/2015 08:41PM

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

1,015

Jonathan Stephens

08/06/2015 03:31AM

How to partition for performance

1,989

Doug Wolfgram

07/29/2015 09:42PM

Re: How to partition for performance

1,184

Rick James

07/31/2015 01:36PM

Re: How to partition for performance

1,169

Rick James

07/31/2015 02:23PM

Partition and Subpartition using Unixtime

1,741

Jaineera Naveen

07/09/2015 07:53AM

Re: Partition and Subpartition using Unixtime

1,020

Rick James

07/09/2015 11:59PM

Optimum partition for a bigger table

1,663

Jaineera Naveen

07/09/2015 12:35AM

Re: Optimum partition for a bigger table

1,009

Rick James

07/09/2015 11:36PM

Mysql 5.5 Partittioning row field

1,742

Shubham Jain

06/24/2015 10:19PM

Re: Mysql 5.5 Partittioning row field

1,304

Jonathan Stephens

06/25/2015 10:16AM

Re: Mysql 5.5 Partittioning row field

1,102

Rick James

06/26/2015 12:15AM

Re: Mysql 5.5 Partittioning row field

1,284

Jonathan Stephens

06/26/2015 02:40AM

Re: Mysql 5.5 Partittioning row field

1,087

Shubham Jain

06/26/2015 07:02AM

subpartiton by key doesn't evenly distribute data

1,802

jongse park

06/10/2015 11:20PM

Re: subpartiton by key doesn't evenly distribute data

940

Rick James

06/13/2015 08:25AM

Re: subpartiton by key doesn't evenly distribute data

980

jongse park

06/15/2015 12:01AM

Re: subpartiton by key doesn't evenly distribute data

913

Rick James

06/15/2015 07:07PM

Re: subpartiton by key doesn't evenly distribute data

1,091

jongse park

06/15/2015 10:41PM

Re: subpartiton by key doesn't evenly distribute data

979

Rick James

06/16/2015 07:36PM

Advice on partitioning

2,169

me su

04/24/2015 01:40PM

Re: Advice on partitioning

1,205

Rick James

04/24/2015 05:34PM

Re: Advice on partitioning

1,224

Mehdi Salarkia

04/27/2015 09:05AM

Re: Advice on partitioning

1,245

Rick James

04/27/2015 02:22PM

Re: Advice on partitioning

1,063

Drew Morris

04/28/2015 11:02AM

Re: Advice on partitioning

1,099

Rick James

04/28/2015 12:32PM

Re: Advice on partitioning

1,117

Mehdi Salarkia

04/28/2015 04:07PM

Re: Advice on partitioning

959

Mehdi Salarkia

06/15/2015 06:39PM

Re: Advice on partitioning

1,139

Rick James

06/15/2015 07:05PM

Re: Advice on partitioning

1,075

Mehdi Salarkia

06/16/2015 06:40PM

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

2,347

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

Rick James

05/17/2015 12:04AM

Select using partition dynamically

2,606

Jose Lima

05/07/2015 06:21PM

Re: Select using partition dynamically

1,273

Rick James

05/11/2015 12:53PM

Partitioning & Replication

1,857

Robert Gunther

04/09/2015 06:30PM

Re: Partitioning & Replication

993

Rick James

04/12/2015 09:43PM

how to speed up for List partitioning table

2,122

jongse park

12/28/2014 07:59PM

Re: how to speed up for List partitioning table

1,207

Rick James

12/30/2014 03:05PM

wrong output generate while using partitions

2,360

Shivam Patel

12/13/2014 07:56AM

Re: wrong output generate while using partitions

1,298

Rick James

12/14/2014 10:33PM

Re: wrong output generate while using partitions

1,194

Shivam Patel

12/16/2014 01:24AM

Re: wrong output generate while using partitions

1,287

Jonathan Stephens

12/16/2014 02:32AM

Re: wrong output generate while using partitions

1,268

Shivam Patel

12/16/2014 04:00AM

Re: wrong output generate while using partitions

1,166

Rick James

12/16/2014 04:28PM

Re: wrong output generate while using partitions

1,317

Shivam Patel

12/17/2014 07:20AM

Re: wrong output generate while using partitions

1,307

Rick James

12/17/2014 11:27AM

large InnoDB table partitioning without explicit PK

3,310

Miko M

11/12/2014 07:41PM

Re: large InnoDB table partitioning without explicit PK

1,828

Rick James

11/13/2014 06:40PM

Re: large InnoDB table partitioning without explicit PK

1,677

Miko M

11/14/2014 03:02AM

Re: large InnoDB table partitioning without explicit PK

1,239

Rick James

11/15/2014 12:05AM

Re: large InnoDB table partitioning without explicit PK

1,302

Miko M

11/16/2014 07:39PM

Re: large InnoDB table partitioning without explicit PK

1,205

Rick James

11/17/2014 04:21PM

Re: large InnoDB table partitioning without explicit PK

1,283

Rick James

11/17/2014 07:48PM

Re: large InnoDB table partitioning without explicit PK

1,280

Miko M

11/18/2014 02:00AM

Re: large InnoDB table partitioning without explicit PK

1,318

Rick James

11/18/2014 11:35PM

Re: large InnoDB table partitioning without explicit PK

1,332

Miko M

11/22/2014 06:44AM

Re: large InnoDB table partitioning without explicit PK

1,206

Miko M

11/18/2014 01:13AM

(non-unique) index more efficient than partition pruning

1,549

Miko M

11/19/2014 12:27AM

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

1,306

Rick James

11/19/2014 06:01PM

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

1,422

Miko M

11/22/2014 08:39AM

Re: large InnoDB table partitioning without explicit PK

1,454

Miko M

11/14/2014 03:04AM

Re: large InnoDB table partitioning without explicit PK

1,489

Miko M

11/14/2014 03:05AM

Re: large InnoDB table partitioning without explicit PK

1,525

Rick James

11/15/2014 12:32AM

Re: large InnoDB table partitioning without explicit PK

1,516

Miko M

11/16/2014 08:31PM

Re: large InnoDB table partitioning without explicit PK

1,277

Rick James

11/19/2014 12:12AM

Re: large InnoDB table partitioning without explicit PK

1,231

Miko M

11/22/2014 09:07AM

Re: large InnoDB table partitioning without explicit PK

1,229

Rick James

11/23/2014 09:00PM

Re: large InnoDB table partitioning without explicit PK

1,347

Miko M

12/01/2014 11:16AM

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

2,551

Tom Song

10/21/2014 03:53AM

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

1,211

Tom Song

10/22/2014 11:58PM

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

1,207

Rick James

10/23/2014 04:36PM

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

1,170

Tom Song

10/24/2014 02:05AM

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

1,181

Mikael Ronström

11/13/2014 06:54AM

Partitioning on account_id

2,729

Ketil Stadskleiv

10/13/2014 02:54PM

Re: Partitioning on account_id

1,373

Rick James

10/14/2014 06:04PM

Range partition and unique key

2,331

Pierrick VODOZ

09/24/2014 08:42AM

Re: Range partition and unique key

1,221

Rick James

09/25/2014 09:59AM

Re: Range partition and unique key

1,341

Pierrick VODOZ

09/26/2014 03:40AM

Re: Range partition and unique key

1,339

Rick James

09/27/2014 08:25AM

Horizontal partitioning on a per user basis?

2,238

Peter Sarkozi

09/18/2014 05:40PM

Re: Horizontal partitioning on a per user basis?

1,183

Luke Taylor

09/19/2014 01:12AM

Re: Horizontal partitioning on a per user basis?

1,243

Rick James

09/19/2014 11:18PM

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

4,323

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

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

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

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

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

Rick James

09/01/2014 08:28PM

Not Taking Paritioning when using Subquery or Join

2,317

Marc Vettorel

08/27/2014 07:08AM

Re: Not Taking Paritioning when using Subquery or Join

1,221

Marc Vettorel

08/27/2014 07:19AM

Re: Not Taking Paritioning when using Subquery or Join

1,280

Rick James

08/28/2014 10:19AM

EXCHANGE PARTITION and DATA DIRECTORY errors

2,925

Ekundayo Lasode

08/16/2014 09:47AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,408

Mattias Jonsson

08/19/2014 03:32AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,312

Ekundayo Lasode

08/19/2014 06:28AM

Storing time series data using partitioning

3,179

Florian Rampp

08/14/2014 05:45AM

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

2,254

Jon Jacob

07/20/2014 07:50AM

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

1,308

Rick James

07/21/2014 06:50PM

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

2,350

Max Herman

07/12/2014 12:35PM

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

1,321

Rick James

07/14/2014 06:45PM

why explain partition shows first partition in every select query?

2,753

Aamir Sohail

05/27/2014 07:18AM

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

1,345

Rick James

05/27/2014 03:10PM

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

1,208

Aamir Sohail

05/28/2014 12:52AM

Storing, accessing and configuring my partitions in diferent servers

2,079

Victor Bombella

05/23/2014 11:54PM

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

1,127

Rick James

05/25/2014 04:57PM

missing data after partitioning - bug?

2,607

rol and

05/23/2014 12:51PM

Re: missing data after partitioning - bug?

1,258

Rick James

05/25/2014 04:27PM

MySql Partitioning problem (bug?)

6,799

K T

05/07/2014 04:39PM

Re: MySql Partitioning problem (bug?)

1,302

Rick James

05/09/2014 11:59PM

Re: MySql Partitioning problem (bug?)

1,256

K T

05/10/2014 03:41PM

Re: MySql Partitioning problem (bug?)

1,213

K T

05/10/2014 03:44PM

Re: MySql Partitioning problem (bug?)

1,246

Mattias Jonsson

05/16/2014 06:15AM

MySQL partition by range on YEAR(date) weird results

2,816

Adelin Feraru

05/12/2014 02:15AM

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

1,321

Rick James

05/15/2014 12:01AM

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

1,198

Adelin Feraru

05/15/2014 03:38AM

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

1,225

Mattias Jonsson

05/15/2014 11:42AM

Storing tables on multiple partitions

2,255

sdgbfdsg fdhgfdhds

04/09/2014 08:04AM

Re: Storing tables on multiple partitions

1,211

Rick James

04/11/2014 04:32PM

Re: Storing tables on multiple partitions

1,196

mi Su

04/29/2014 01:09AM

MySql Horizontal partitioning - Pros-Cons

4,038

Manohar K

04/14/2014 11:43AM

Re: MySql Horizontal partitioning - Pros-Cons

2,005

Rick James

04/17/2014 11:16PM

Re: MySql Horizontal partitioning - Pros-Cons

1,489

Rick James

04/19/2014 03:42PM

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

3,135

Raghavendra K

04/14/2014 01:07AM

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

1,223

Mattias Jonsson

04/14/2014 05:05PM

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

1,195

Raghavendra K

04/16/2014 06:40AM

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

1,205

Mattias Jonsson

04/17/2014 12:55PM

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

1,200

Rick James

04/17/2014 11:36PM

Failed to read from the .par file

9,627

IGG t

04/02/2014 09:49AM

Re: Failed to read from the .par file

5,525

Rick James

04/05/2014 01:13PM

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

2,223

mi Su

01/06/2014 01:21AM

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

1,562

Rick James

01/08/2014 05:22PM

Partitioning or indexing for millions of records

2,583

Aamir Sohail

11/26/2013 05:44AM

Re: Partitioning or indexing for millions of records

1,973

Rick James

11/27/2013 12:39PM

Re: Partitioning or indexing for millions of records

1,508

Aamir Sohail

11/28/2013 12:40AM

Re: Partitioning or indexing for millions of records

1,599

Rick James

11/28/2013 09:07PM

Re: Partitioning or indexing for millions of records

1,479

Aamir Sohail

11/29/2013 04:11AM

Re: Partitioning or indexing for millions of records

1,465

Rick James

11/30/2013 01:30PM

Re: Partitioning or indexing for millions of records

1,310

chris arndt

12/31/2013 11:34AM

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

2,492

Aamir Sohail

12/04/2013 05:57AM

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

1,270

Rick James

12/05/2013 12:15PM

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

1,237

mi Su

12/10/2013 11:46PM

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

1,177

Rick James

12/13/2013 12:51AM

Am I doing this correctly?

2,265

Jim Buckley Barrett

11/29/2013 05:03AM

Re: Am I doing this correctly?

1,290

Jim Buckley Barrett

11/29/2013 06:22AM

Re: Am I doing this correctly?

1,401

Rick James

11/30/2013 02:18PM

Re: Am I doing this correctly?

1,203

mi Su

12/04/2013 12:38AM

Re: Am I doing this correctly?

1,253

Jim Buckley Barrett

12/05/2013 03:48AM

Re: Am I doing this correctly?

1,305

Rick James

12/05/2013 10:21AM

Re: Am I doing this correctly?

1,235

Jim Buckley Barrett

12/10/2013 09:49AM

Re: Am I doing this correctly?

1,276

Jim Buckley Barrett

12/05/2013 03:51AM

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

11,520

Aamir Sohail

11/28/2013 01:28AM

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

4,917

Rick James

11/29/2013 01:15AM

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

3,226

Aamir Sohail

11/29/2013 04:19AM

Partition data backup and restore

7,830

Seungho Nam Nam

10/18/2013 12:48AM

Re: Partition data backup and restore

3,616

Mattias Jonsson

10/18/2013 02:59AM

Re: Partition data backup and restore

2,567

Steven Robinson

11/07/2013 11:29PM

Changing 5.1.61 Enterprise Commerical Build to allow partitioning

2,176

mark silverman

09/19/2013 08:11AM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,249

Rick James

09/24/2013 08:51PM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,289

Mattias Jonsson

10/04/2013 01:02AM

Reorganize Partition Syntax error

2,867

IGG t

09/16/2013 03:13AM

Re: Reorganize Partition Syntax error

1,154

IGG t

09/16/2013 09:39AM

Re: Reorganize Partition Syntax error

1,173

Rick James

09/17/2013 07:19PM

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

3,444

Prabhu Raja Singh

09/13/2013 01:40AM

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

2,067

Rick James

09/15/2013 09:33PM

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

1,822

Prabhu Raja Singh

09/16/2013 03:26AM

Partitioning by date, and maintaining uniqueness

2,778

IGG t

08/13/2013 09:51AM

Re: Partitioning by date, and maintaining uniqueness

1,227

Rick James

08/14/2013 09:20AM

Re: Partitioning by date, and maintaining uniqueness

1,167

IGG t

08/14/2013 10:28AM

Re: Partitioning by date, and maintaining uniqueness

1,171

Rick James

08/31/2013 05:35PM

mysql tables in use 500, locked 500

2,575

bruce.zuo bruce

07/16/2013 03:14AM

Re: mysql tables in use 500, locked 500

1,417

Rick James

07/21/2013 12:26AM

Re: mysql tables in use 500, locked 500

1,314

bruce.zuo bruce

07/24/2013 07:12AM

Re: mysql tables in use 500, locked 500

1,153

Mattias Jonsson

08/13/2013 05:42AM

Create index on partition table (manually and dynamically)

6,534

Vladimir Pivovar

07/05/2013 11:26PM

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

2,156

Rick James

07/06/2013 10:52PM

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

1,977

Vladimir Pivovar

07/07/2013 12:20AM

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

1,778

Vladimir Pivovar

07/07/2013 10:57AM

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

1,881

Rick James

07/08/2013 09:46AM

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

2,171

Vladimir Pivovar

07/10/2013 02:23PM

how to remove partitiong in mysql version5.6

2,278

heiansan white

06/13/2013 01:41AM

Re: how to remove partitiong in mysql version5.6

1,236

Rick James

06/15/2013 01:50PM

No. of partitions in NDB cluster

1,886

Alax James

05/31/2013 02:14AM

IP vs Date Partition

2,550

Tim Linden

05/13/2013 10:28AM

Re: IP vs Date Partition

1,622

Rick James

05/14/2013 09:59PM

Re: IP vs Date Partition

1,598

Tim Linden

05/15/2013 10:06AM

How should I partition this table?

2,955

Ron Bergin

04/26/2013 09:18AM