MySQL :: MySQL Forums :: Partitioning

New Topic

Pages:

« 1 2 3 4 5

...

13 »

Subject

Views

Written By

Posted

Partition and Subpartition using Unixtime

1,691

Jaineera Naveen

07/09/2015 07:53AM

Re: Partition and Subpartition using Unixtime

984

Rick James

07/09/2015 11:59PM

Optimum partition for a bigger table

1,600

Jaineera Naveen

07/09/2015 12:35AM

Re: Optimum partition for a bigger table

978

Rick James

07/09/2015 11:36PM

Mysql 5.5 Partittioning row field

1,700

Shubham Jain

06/24/2015 10:19PM

Re: Mysql 5.5 Partittioning row field

1,265

Jonathan Stephens

06/25/2015 10:16AM

Re: Mysql 5.5 Partittioning row field

1,064

Rick James

06/26/2015 12:15AM

Re: Mysql 5.5 Partittioning row field

1,249

Jonathan Stephens

06/26/2015 02:40AM

Re: Mysql 5.5 Partittioning row field

1,055

Shubham Jain

06/26/2015 07:02AM

subpartiton by key doesn't evenly distribute data

1,748

jongse park

06/10/2015 11:20PM

Re: subpartiton by key doesn't evenly distribute data

912

Rick James

06/13/2015 08:25AM

Re: subpartiton by key doesn't evenly distribute data

942

jongse park

06/15/2015 12:01AM

Re: subpartiton by key doesn't evenly distribute data

885

Rick James

06/15/2015 07:07PM

Re: subpartiton by key doesn't evenly distribute data

1,049

jongse park

06/15/2015 10:41PM

Re: subpartiton by key doesn't evenly distribute data

958

Rick James

06/16/2015 07:36PM

Advice on partitioning

2,102

me su

04/24/2015 01:40PM

Re: Advice on partitioning

1,168

Rick James

04/24/2015 05:34PM

Re: Advice on partitioning

1,185

Mehdi Salarkia

04/27/2015 09:05AM

Re: Advice on partitioning

1,210

Rick James

04/27/2015 02:22PM

Re: Advice on partitioning

1,027

Drew Morris

04/28/2015 11:02AM

Re: Advice on partitioning

1,053

Rick James

04/28/2015 12:32PM

Re: Advice on partitioning

1,075

Mehdi Salarkia

04/28/2015 04:07PM

Re: Advice on partitioning

924

Mehdi Salarkia

06/15/2015 06:39PM

Re: Advice on partitioning

1,091

Rick James

06/15/2015 07:05PM

Re: Advice on partitioning

1,040

Mehdi Salarkia

06/16/2015 06:40PM

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

2,263

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

Rick James

05/17/2015 12:04AM

Select using partition dynamically

2,455

Jose Lima

05/07/2015 06:21PM

Re: Select using partition dynamically

1,221

Rick James

05/11/2015 12:53PM

Partitioning & Replication

1,801

Robert Gunther

04/09/2015 06:30PM

Re: Partitioning & Replication

972

Rick James

04/12/2015 09:43PM

how to speed up for List partitioning table

2,074

jongse park

12/28/2014 07:59PM

Re: how to speed up for List partitioning table

1,159

Rick James

12/30/2014 03:05PM

wrong output generate while using partitions

2,303

Shivam Patel

12/13/2014 07:56AM

Re: wrong output generate while using partitions

1,262

Rick James

12/14/2014 10:33PM

Re: wrong output generate while using partitions

1,149

Shivam Patel

12/16/2014 01:24AM

Re: wrong output generate while using partitions

1,237

Jonathan Stephens

12/16/2014 02:32AM

Re: wrong output generate while using partitions

1,222

Shivam Patel

12/16/2014 04:00AM

Re: wrong output generate while using partitions

1,130

Rick James

12/16/2014 04:28PM

Re: wrong output generate while using partitions

1,270

Shivam Patel

12/17/2014 07:20AM

Re: wrong output generate while using partitions

1,266

Rick James

12/17/2014 11:27AM

large InnoDB table partitioning without explicit PK

3,194

Miko M

11/12/2014 07:41PM

Re: large InnoDB table partitioning without explicit PK

1,775

Rick James

11/13/2014 06:40PM

Re: large InnoDB table partitioning without explicit PK

1,624

Miko M

11/14/2014 03:02AM

Re: large InnoDB table partitioning without explicit PK

1,200

Rick James

11/15/2014 12:05AM

Re: large InnoDB table partitioning without explicit PK

1,253

Miko M

11/16/2014 07:39PM

Re: large InnoDB table partitioning without explicit PK

1,156

Rick James

11/17/2014 04:21PM

Re: large InnoDB table partitioning without explicit PK

1,248

Rick James

11/17/2014 07:48PM

Re: large InnoDB table partitioning without explicit PK

1,229

Miko M

11/18/2014 02:00AM

Re: large InnoDB table partitioning without explicit PK

1,270

Rick James

11/18/2014 11:35PM

Re: large InnoDB table partitioning without explicit PK

1,285

Miko M

11/22/2014 06:44AM

Re: large InnoDB table partitioning without explicit PK

1,171

Miko M

11/18/2014 01:13AM

(non-unique) index more efficient than partition pruning

1,496

Miko M

11/19/2014 12:27AM

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

1,260

Rick James

11/19/2014 06:01PM

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

1,373

Miko M

11/22/2014 08:39AM

Re: large InnoDB table partitioning without explicit PK

1,391

Miko M

11/14/2014 03:04AM

Re: large InnoDB table partitioning without explicit PK

1,439

Miko M

11/14/2014 03:05AM

Re: large InnoDB table partitioning without explicit PK

1,473

Rick James

11/15/2014 12:32AM

Re: large InnoDB table partitioning without explicit PK

1,458

Miko M

11/16/2014 08:31PM

Re: large InnoDB table partitioning without explicit PK

1,228

Rick James

11/19/2014 12:12AM

Re: large InnoDB table partitioning without explicit PK

1,177

Miko M

11/22/2014 09:07AM

Re: large InnoDB table partitioning without explicit PK

1,184

Rick James

11/23/2014 09:00PM

Re: large InnoDB table partitioning without explicit PK

1,296

Miko M

12/01/2014 11:16AM

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

2,514

Tom Song

10/21/2014 03:53AM

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

1,186

Tom Song

10/22/2014 11:58PM

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

1,163

Rick James

10/23/2014 04:36PM

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

1,146

Tom Song

10/24/2014 02:05AM

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

1,139

Mikael Ronström

11/13/2014 06:54AM

Partitioning on account_id

2,677

Ketil Stadskleiv

10/13/2014 02:54PM

Re: Partitioning on account_id

1,347

Rick James

10/14/2014 06:04PM

Range partition and unique key

2,276

Pierrick VODOZ

09/24/2014 08:42AM

Re: Range partition and unique key

1,185

Rick James

09/25/2014 09:59AM

Re: Range partition and unique key

1,313

Pierrick VODOZ

09/26/2014 03:40AM

Re: Range partition and unique key

1,301

Rick James

09/27/2014 08:25AM

Horizontal partitioning on a per user basis?

2,197

Peter Sarkozi

09/18/2014 05:40PM

Re: Horizontal partitioning on a per user basis?

1,158

Luke Taylor

09/19/2014 01:12AM

Re: Horizontal partitioning on a per user basis?

1,217

Rick James

09/19/2014 11:18PM

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

4,135

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

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

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

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

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

Rick James

09/01/2014 08:28PM

Not Taking Paritioning when using Subquery or Join

2,260

Marc Vettorel

08/27/2014 07:08AM

Re: Not Taking Paritioning when using Subquery or Join

1,190

Marc Vettorel

08/27/2014 07:19AM

Re: Not Taking Paritioning when using Subquery or Join

1,238

Rick James

08/28/2014 10:19AM

EXCHANGE PARTITION and DATA DIRECTORY errors

2,815

Ekundayo Lasode

08/16/2014 09:47AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,354

Mattias Jonsson

08/19/2014 03:32AM

Re: EXCHANGE PARTITION and DATA DIRECTORY errors

1,262

Ekundayo Lasode

08/19/2014 06:28AM

Storing time series data using partitioning

3,119

Florian Rampp

08/14/2014 05:45AM

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

2,217

Jon Jacob

07/20/2014 07:50AM

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

1,275

Rick James

07/21/2014 06:50PM

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

2,302

Max Herman

07/12/2014 12:35PM

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

1,288

Rick James

07/14/2014 06:45PM

why explain partition shows first partition in every select query?

2,691

Aamir Sohail

05/27/2014 07:18AM

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

1,300

Rick James

05/27/2014 03:10PM

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

1,179

Aamir Sohail

05/28/2014 12:52AM

Storing, accessing and configuring my partitions in diferent servers

2,038

Victor Bombella

05/23/2014 11:54PM

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

1,100

Rick James

05/25/2014 04:57PM

missing data after partitioning - bug?

2,548

rol and

05/23/2014 12:51PM

Re: missing data after partitioning - bug?

1,231

Rick James

05/25/2014 04:27PM

MySql Partitioning problem (bug?)

6,752

K T

05/07/2014 04:39PM

Re: MySql Partitioning problem (bug?)

1,266

Rick James

05/09/2014 11:59PM

Re: MySql Partitioning problem (bug?)

1,228

K T

05/10/2014 03:41PM

Re: MySql Partitioning problem (bug?)

1,181

K T

05/10/2014 03:44PM

Re: MySql Partitioning problem (bug?)

1,213

Mattias Jonsson

05/16/2014 06:15AM

MySQL partition by range on YEAR(date) weird results

2,755

Adelin Feraru

05/12/2014 02:15AM

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

1,287

Rick James

05/15/2014 12:01AM

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

1,160

Adelin Feraru

05/15/2014 03:38AM

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

1,192

Mattias Jonsson

05/15/2014 11:42AM

Storing tables on multiple partitions

2,193

sdgbfdsg fdhgfdhds

04/09/2014 08:04AM

Re: Storing tables on multiple partitions

1,177

Rick James

04/11/2014 04:32PM

Re: Storing tables on multiple partitions

1,172

mi Su

04/29/2014 01:09AM

MySql Horizontal partitioning - Pros-Cons

3,947

Manohar K

04/14/2014 11:43AM

Re: MySql Horizontal partitioning - Pros-Cons

1,960

Rick James

04/17/2014 11:16PM

Re: MySql Horizontal partitioning - Pros-Cons

1,458

Rick James

04/19/2014 03:42PM

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

3,075

Raghavendra K

04/14/2014 01:07AM

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

1,191

Mattias Jonsson

04/14/2014 05:05PM

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

1,165

Raghavendra K

04/16/2014 06:40AM

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

1,173

Mattias Jonsson

04/17/2014 12:55PM

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

1,167

Rick James

04/17/2014 11:36PM

Failed to read from the .par file

9,082

IGG t

04/02/2014 09:49AM

Re: Failed to read from the .par file

5,235

Rick James

04/05/2014 01:13PM

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

2,188

mi Su

01/06/2014 01:21AM

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

1,525

Rick James

01/08/2014 05:22PM

Partitioning or indexing for millions of records

2,541

Aamir Sohail

11/26/2013 05:44AM

Re: Partitioning or indexing for millions of records

1,936

Rick James

11/27/2013 12:39PM

Re: Partitioning or indexing for millions of records

1,468

Aamir Sohail

11/28/2013 12:40AM

Re: Partitioning or indexing for millions of records

1,567

Rick James

11/28/2013 09:07PM

Re: Partitioning or indexing for millions of records

1,443

Aamir Sohail

11/29/2013 04:11AM

Re: Partitioning or indexing for millions of records

1,433

Rick James

11/30/2013 01:30PM

Re: Partitioning or indexing for millions of records

1,280

chris arndt

12/31/2013 11:34AM

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

2,449

Aamir Sohail

12/04/2013 05:57AM

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

1,252

Rick James

12/05/2013 12:15PM

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

1,210

mi Su

12/10/2013 11:46PM

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

1,156

Rick James

12/13/2013 12:51AM

Am I doing this correctly?

2,229

Jim Buckley Barrett

11/29/2013 05:03AM

Re: Am I doing this correctly?

1,262

Jim Buckley Barrett

11/29/2013 06:22AM

Re: Am I doing this correctly?

1,372

Rick James

11/30/2013 02:18PM

Re: Am I doing this correctly?

1,185

mi Su

12/04/2013 12:38AM

Re: Am I doing this correctly?

1,234

Jim Buckley Barrett

12/05/2013 03:48AM

Re: Am I doing this correctly?

1,285

Rick James

12/05/2013 10:21AM

Re: Am I doing this correctly?

1,209

Jim Buckley Barrett

12/10/2013 09:49AM

Re: Am I doing this correctly?

1,255

Jim Buckley Barrett

12/05/2013 03:51AM

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

10,730

Aamir Sohail

11/28/2013 01:28AM

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

4,583

Rick James

11/29/2013 01:15AM

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

3,049

Aamir Sohail

11/29/2013 04:19AM

Partition data backup and restore

7,506

Seungho Nam Nam

10/18/2013 12:48AM

Re: Partition data backup and restore

3,486

Mattias Jonsson

10/18/2013 02:59AM

Re: Partition data backup and restore

2,488

Steven Robinson

11/07/2013 11:29PM

Changing 5.1.61 Enterprise Commerical Build to allow partitioning

2,115

mark silverman

09/19/2013 08:11AM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,230

Rick James

09/24/2013 08:51PM

Re: Changing 5.1.61 Enterprise Commerical Build to allow partitioning

1,264

Mattias Jonsson

10/04/2013 01:02AM

Reorganize Partition Syntax error

2,802

IGG t

09/16/2013 03:13AM

Re: Reorganize Partition Syntax error

1,130

IGG t

09/16/2013 09:39AM

Re: Reorganize Partition Syntax error

1,144

Rick James

09/17/2013 07:19PM

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

3,357

Prabhu Raja Singh

09/13/2013 01:40AM

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

2,024

Rick James

09/15/2013 09:33PM

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

1,775

Prabhu Raja Singh

09/16/2013 03:26AM

Partitioning by date, and maintaining uniqueness

2,718

IGG t

08/13/2013 09:51AM

Re: Partitioning by date, and maintaining uniqueness

1,201

Rick James

08/14/2013 09:20AM

Re: Partitioning by date, and maintaining uniqueness

1,146

IGG t

08/14/2013 10:28AM

Re: Partitioning by date, and maintaining uniqueness

1,151

Rick James

08/31/2013 05:35PM

mysql tables in use 500, locked 500

2,541

bruce.zuo bruce

07/16/2013 03:14AM

Re: mysql tables in use 500, locked 500

1,385

Rick James

07/21/2013 12:26AM

Re: mysql tables in use 500, locked 500

1,287

bruce.zuo bruce

07/24/2013 07:12AM

Re: mysql tables in use 500, locked 500

1,128

Mattias Jonsson

08/13/2013 05:42AM

Create index on partition table (manually and dynamically)

6,312

Vladimir Pivovar

07/05/2013 11:26PM

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

2,071

Rick James

07/06/2013 10:52PM

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

1,898

Vladimir Pivovar

07/07/2013 12:20AM

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

1,719

Vladimir Pivovar

07/07/2013 10:57AM

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

1,815

Rick James

07/08/2013 09:46AM

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

2,092

Vladimir Pivovar

07/10/2013 02:23PM

how to remove partitiong in mysql version5.6

2,234

heiansan white

06/13/2013 01:41AM

Re: how to remove partitiong in mysql version5.6

1,214

Rick James

06/15/2013 01:50PM

No. of partitions in NDB cluster

1,852

Alax James

05/31/2013 02:14AM

IP vs Date Partition

2,516

Tim Linden

05/13/2013 10:28AM

Re: IP vs Date Partition

1,605

Rick James

05/14/2013 09:59PM

Re: IP vs Date Partition

1,576

Tim Linden

05/15/2013 10:06AM

How should I partition this table?

2,907

Ron Bergin

04/26/2013 09:18AM