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

jongse park

08/05/2015 08:41PM

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

1,040

Jonathan Stephens

08/06/2015 03:31AM

How to partition for performance

2,022

Doug Wolfgram

07/29/2015 09:42PM

Re: How to partition for performance

1,214

Rick James

07/31/2015 01:36PM

Re: How to partition for performance

1,189

Rick James

07/31/2015 02:23PM

Partition and Subpartition using Unixtime

1,769

Jaineera Naveen

07/09/2015 07:53AM

Re: Partition and Subpartition using Unixtime

1,042

Rick James

07/09/2015 11:59PM

Optimum partition for a bigger table

1,698

Jaineera Naveen

07/09/2015 12:35AM

Re: Optimum partition for a bigger table

1,029

Rick James

07/09/2015 11:36PM

Mysql 5.5 Partittioning row field

1,766

Shubham Jain

06/24/2015 10:19PM

Re: Mysql 5.5 Partittioning row field

1,331

Jonathan Stephens

06/25/2015 10:16AM

Re: Mysql 5.5 Partittioning row field

1,119

Rick James

06/26/2015 12:15AM

Re: Mysql 5.5 Partittioning row field

1,299

Jonathan Stephens

06/26/2015 02:40AM

Re: Mysql 5.5 Partittioning row field

1,100

Shubham Jain

06/26/2015 07:02AM

subpartiton by key doesn't evenly distribute data

1,827

jongse park

06/10/2015 11:20PM

Re: subpartiton by key doesn't evenly distribute data

960

Rick James

06/13/2015 08:25AM

Re: subpartiton by key doesn't evenly distribute data

995

jongse park

06/15/2015 12:01AM

Re: subpartiton by key doesn't evenly distribute data

927

Rick James

06/15/2015 07:07PM

Re: subpartiton by key doesn't evenly distribute data

1,121

jongse park

06/15/2015 10:41PM

Re: subpartiton by key doesn't evenly distribute data

992

Rick James

06/16/2015 07:36PM

Advice on partitioning

2,199

me su

04/24/2015 01:40PM

Re: Advice on partitioning

1,225

Rick James

04/24/2015 05:34PM

Re: Advice on partitioning

1,245

Mehdi Salarkia

04/27/2015 09:05AM

Re: Advice on partitioning

1,261

Rick James

04/27/2015 02:22PM

Re: Advice on partitioning

1,078

Drew Morris

04/28/2015 11:02AM

Re: Advice on partitioning

1,122

Rick James

04/28/2015 12:32PM

Re: Advice on partitioning

1,129

Mehdi Salarkia

04/28/2015 04:07PM

Re: Advice on partitioning

974

Mehdi Salarkia

06/15/2015 06:39PM

Re: Advice on partitioning

1,160

Rick James

06/15/2015 07:05PM

Re: Advice on partitioning

1,097

Mehdi Salarkia

06/16/2015 06:40PM

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

2,399

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

Rick James

05/17/2015 12:04AM

Select using partition dynamically

2,681

Jose Lima

05/07/2015 06:21PM

Re: Select using partition dynamically

1,304

Rick James

05/11/2015 12:53PM

Partitioning & Replication

1,888

Robert Gunther

04/09/2015 06:30PM

Re: Partitioning & Replication

1,010

Rick James

04/12/2015 09:43PM

how to speed up for List partitioning table

2,158

jongse park

12/28/2014 07:59PM

Re: how to speed up for List partitioning table

1,231

Rick James

12/30/2014 03:05PM

wrong output generate while using partitions

2,401

Shivam Patel

12/13/2014 07:56AM

Re: wrong output generate while using partitions

1,328

Rick James

12/14/2014 10:33PM

Re: wrong output generate while using partitions

1,215

Shivam Patel

12/16/2014 01:24AM

Re: wrong output generate while using partitions

1,314

Jonathan Stephens

12/16/2014 02:32AM

Re: wrong output generate while using partitions

1,293

Shivam Patel

12/16/2014 04:00AM

Re: wrong output generate while using partitions

1,184

Rick James

12/16/2014 04:28PM

Re: wrong output generate while using partitions

1,345

Shivam Patel

12/17/2014 07:20AM

Re: wrong output generate while using partitions

1,336

Rick James

12/17/2014 11:27AM

large InnoDB table partitioning without explicit PK

3,384

Miko M

11/12/2014 07:41PM

Re: large InnoDB table partitioning without explicit PK

1,855

Rick James

11/13/2014 06:40PM

Re: large InnoDB table partitioning without explicit PK

1,710

Miko M

11/14/2014 03:02AM

Re: large InnoDB table partitioning without explicit PK

1,261

Rick James

11/15/2014 12:05AM

Re: large InnoDB table partitioning without explicit PK

1,328

Miko M

11/16/2014 07:39PM

Re: large InnoDB table partitioning without explicit PK

1,233

Rick James

11/17/2014 04:21PM

Re: large InnoDB table partitioning without explicit PK

1,308

Rick James

11/17/2014 07:48PM

Re: large InnoDB table partitioning without explicit PK

1,311

Miko M

11/18/2014 02:00AM

Re: large InnoDB table partitioning without explicit PK

1,339

Rick James

11/18/2014 11:35PM

Re: large InnoDB table partitioning without explicit PK

1,354

Miko M

11/22/2014 06:44AM

Re: large InnoDB table partitioning without explicit PK

1,230

Miko M

11/18/2014 01:13AM

(non-unique) index more efficient than partition pruning

1,578

Miko M

11/19/2014 12:27AM

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

1,326

Rick James

11/19/2014 06:01PM

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

1,445

Miko M

11/22/2014 08:39AM

Re: large InnoDB table partitioning without explicit PK

1,487

Miko M

11/14/2014 03:04AM

Re: large InnoDB table partitioning without explicit PK

1,521

Miko M

11/14/2014 03:05AM

Re: large InnoDB table partitioning without explicit PK

1,550

Rick James

11/15/2014 12:32AM

Re: large InnoDB table partitioning without explicit PK

1,553

Miko M

11/16/2014 08:31PM

Re: large InnoDB table partitioning without explicit PK

1,313

Rick James

11/19/2014 12:12AM

Re: large InnoDB table partitioning without explicit PK

1,250

Miko M

11/22/2014 09:07AM

Re: large InnoDB table partitioning without explicit PK

1,258

Rick James

11/23/2014 09:00PM

Re: large InnoDB table partitioning without explicit PK

1,378

Miko M

12/01/2014 11:16AM

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

2,579

Tom Song

10/21/2014 03:53AM

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

1,226

Tom Song

10/22/2014 11:58PM

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

1,236

Rick James

10/23/2014 04:36PM

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

1,192

Tom Song

10/24/2014 02:05AM

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

1,208

Mikael Ronström

11/13/2014 06:54AM

Partitioning on account_id

2,758

Ketil Stadskleiv

10/13/2014 02:54PM

Re: Partitioning on account_id

1,393

Rick James

10/14/2014 06:04PM

Range partition and unique key

2,361

Pierrick VODOZ

09/24/2014 08:42AM

Re: Range partition and unique key

1,238

Rick James

09/25/2014 09:59AM

Re: Range partition and unique key

1,354

Pierrick VODOZ

09/26/2014 03:40AM

Re: Range partition and unique key

1,354

Rick James

09/27/2014 08:25AM

Horizontal partitioning on a per user basis?

2,263

Peter Sarkozi

09/18/2014 05:40PM

Re: Horizontal partitioning on a per user basis?

1,194

Luke Taylor

09/19/2014 01:12AM

Re: Horizontal partitioning on a per user basis?

1,255

Rick James

09/19/2014 11:18PM

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

4,422

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

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

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

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

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

Rick James

09/01/2014 08:28PM

Not Taking Paritioning when using Subquery or Join

2,356

Marc Vettorel

08/27/2014 07:08AM

Re: Not Taking Paritioning when using Subquery or Join

1,238

Marc Vettorel

08/27/2014 07:19AM

Re: Not Taking Paritioning when using Subquery or Join

1,297

Rick James

08/28/2014 10:19AM

EXCHANGE PARTITION and DATA DIRECTORY errors

3,046

Ekundayo Lasode

08/16/2014 09:47AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,436

Mattias Jonsson

08/19/2014 03:32AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,335

Ekundayo Lasode

08/19/2014 06:28AM

Storing time series data using partitioning

3,222

Florian Rampp

08/14/2014 05:45AM

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

2,283

Jon Jacob

07/20/2014 07:50AM

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

1,324

Rick James

07/21/2014 06:50PM

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

2,370

Max Herman

07/12/2014 12:35PM

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

1,336

Rick James

07/14/2014 06:45PM

why explain partition shows first partition in every select query?

2,780

Aamir Sohail

05/27/2014 07:18AM

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

1,366

Rick James

05/27/2014 03:10PM

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

1,228

Aamir Sohail

05/28/2014 12:52AM

Storing, accessing and configuring my partitions in diferent servers

2,101

Victor Bombella

05/23/2014 11:54PM

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

1,139

Rick James

05/25/2014 04:57PM

missing data after partitioning - bug?

2,646

rol and

05/23/2014 12:51PM

Re: missing data after partitioning - bug?

1,276

Rick James

05/25/2014 04:27PM

MySql Partitioning problem (bug?)

6,830

K T

05/07/2014 04:39PM

Re: MySql Partitioning problem (bug?)

1,316

Rick James

05/09/2014 11:59PM

Re: MySql Partitioning problem (bug?)

1,270

K T

05/10/2014 03:41PM

Re: MySql Partitioning problem (bug?)

1,225

K T

05/10/2014 03:44PM

Re: MySql Partitioning problem (bug?)

1,264

Mattias Jonsson

05/16/2014 06:15AM

MySQL partition by range on YEAR(date) weird results

2,851

Adelin Feraru

05/12/2014 02:15AM

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

1,337

Rick James

05/15/2014 12:01AM

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

1,216

Adelin Feraru

05/15/2014 03:38AM

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

1,243

Mattias Jonsson

05/15/2014 11:42AM

Storing tables on multiple partitions

2,282

sdgbfdsg fdhgfdhds

04/09/2014 08:04AM

Re: Storing tables on multiple partitions

1,222

Rick James

04/11/2014 04:32PM

Re: Storing tables on multiple partitions

1,209

mi Su

04/29/2014 01:09AM

MySql Horizontal partitioning - Pros-Cons

4,099

Manohar K

04/14/2014 11:43AM

Re: MySql Horizontal partitioning - Pros-Cons

2,031

Rick James

04/17/2014 11:16PM

Re: MySql Horizontal partitioning - Pros-Cons

1,503

Rick James

04/19/2014 03:42PM

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

3,177

Raghavendra K

04/14/2014 01:07AM

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

1,240

Mattias Jonsson

04/14/2014 05:05PM

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

1,208

Raghavendra K

04/16/2014 06:40AM

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

1,225

Mattias Jonsson

04/17/2014 12:55PM

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

1,220

Rick James

04/17/2014 11:36PM

Failed to read from the .par file

9,945

IGG t

04/02/2014 09:49AM

Re: Failed to read from the .par file

5,674

Rick James

04/05/2014 01:13PM

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

2,253

mi Su

01/06/2014 01:21AM

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

1,581

Rick James

01/08/2014 05:22PM

Partitioning or indexing for millions of records

2,608

Aamir Sohail

11/26/2013 05:44AM

Re: Partitioning or indexing for millions of records

1,988

Rick James

11/27/2013 12:39PM

Re: Partitioning or indexing for millions of records

1,532

Aamir Sohail

11/28/2013 12:40AM

Re: Partitioning or indexing for millions of records

1,617

Rick James

11/28/2013 09:07PM

Re: Partitioning or indexing for millions of records

1,498

Aamir Sohail

11/29/2013 04:11AM

Re: Partitioning or indexing for millions of records

1,487

Rick James

11/30/2013 01:30PM

Re: Partitioning or indexing for millions of records

1,328

chris arndt

12/31/2013 11:34AM

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

2,523

Aamir Sohail

12/04/2013 05:57AM

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

1,282

Rick James

12/05/2013 12:15PM

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

1,253

mi Su

12/10/2013 11:46PM

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

1,195

Rick James

12/13/2013 12:51AM

Am I doing this correctly?

2,286

Jim Buckley Barrett

11/29/2013 05:03AM

Re: Am I doing this correctly?

1,310

Jim Buckley Barrett

11/29/2013 06:22AM

Re: Am I doing this correctly?

1,421

Rick James

11/30/2013 02:18PM

Re: Am I doing this correctly?

1,219

mi Su

12/04/2013 12:38AM

Re: Am I doing this correctly?

1,264

Jim Buckley Barrett

12/05/2013 03:48AM

Re: Am I doing this correctly?

1,319

Rick James

12/05/2013 10:21AM

Re: Am I doing this correctly?

1,246

Jim Buckley Barrett

12/10/2013 09:49AM

Re: Am I doing this correctly?

1,290

Jim Buckley Barrett

12/05/2013 03:51AM

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

11,869

Aamir Sohail

11/28/2013 01:28AM

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

5,075

Rick James

11/29/2013 01:15AM

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

3,293

Aamir Sohail

11/29/2013 04:19AM

Partition data backup and restore

7,994

Seungho Nam Nam

10/18/2013 12:48AM

Re: Partition data backup and restore

3,691

Mattias Jonsson

10/18/2013 02:59AM

Re: Partition data backup and restore

2,610

Steven Robinson

11/07/2013 11:29PM

Changing 5.1.61 Enterprise Commerical Build to allow partitioning

2,228

mark silverman

09/19/2013 08:11AM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,259

Rick James

09/24/2013 08:51PM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,303

Mattias Jonsson

10/04/2013 01:02AM

Reorganize Partition Syntax error

2,900

IGG t

09/16/2013 03:13AM

Re: Reorganize Partition Syntax error

1,166

IGG t

09/16/2013 09:39AM

Re: Reorganize Partition Syntax error

1,197

Rick James

09/17/2013 07:19PM

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

3,488

Prabhu Raja Singh

09/13/2013 01:40AM

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

2,083

Rick James

09/15/2013 09:33PM

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

1,835

Prabhu Raja Singh

09/16/2013 03:26AM

Partitioning by date, and maintaining uniqueness

2,829

IGG t

08/13/2013 09:51AM

Re: Partitioning by date, and maintaining uniqueness

1,245

Rick James

08/14/2013 09:20AM

Re: Partitioning by date, and maintaining uniqueness

1,182

IGG t

08/14/2013 10:28AM

Re: Partitioning by date, and maintaining uniqueness

1,186

Rick James

08/31/2013 05:35PM

mysql tables in use 500, locked 500

2,606

bruce.zuo bruce

07/16/2013 03:14AM

Re: mysql tables in use 500, locked 500

1,434

Rick James

07/21/2013 12:26AM

Re: mysql tables in use 500, locked 500

1,326

bruce.zuo bruce

07/24/2013 07:12AM

Re: mysql tables in use 500, locked 500

1,170

Mattias Jonsson

08/13/2013 05:42AM

Create index on partition table (manually and dynamically)

6,673

Vladimir Pivovar

07/05/2013 11:26PM

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

2,200

Rick James

07/06/2013 10:52PM

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

2,020

Vladimir Pivovar

07/07/2013 12:20AM

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

1,811

Vladimir Pivovar

07/07/2013 10:57AM

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

1,921

Rick James

07/08/2013 09:46AM

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

2,220

Vladimir Pivovar

07/10/2013 02:23PM

how to remove partitiong in mysql version5.6

2,300

heiansan white

06/13/2013 01:41AM

Re: how to remove partitiong in mysql version5.6

1,249

Rick James

06/15/2013 01:50PM

No. of partitions in NDB cluster

1,906

Alax James

05/31/2013 02:14AM

IP vs Date Partition

2,576

Tim Linden

05/13/2013 10:28AM

Re: IP vs Date Partition

1,634

Rick James

05/14/2013 09:59PM

Re: IP vs Date Partition

1,611

Tim Linden

05/15/2013 10:06AM

How should I partition this table?

2,995

Ron Bergin

04/26/2013 09:18AM