MySQL :: MySQL Forums :: Partitioning

New Topic

Pages:

« 1 2 3 4 5

...

14 »

Subject

Views

Written By

Posted

how to partition a table with string type unique column .

4,536

qufu dai

08/14/2012 01:40AM

Re: how to partition a table with string type unique column .

2,282

Mattias Jonsson

08/16/2012 02:16AM

Partition or not ?

2,841

Srikanth Mamidi

08/07/2012 12:58AM

Re: Partition or not ?

1,723

Rick James

08/09/2012 08:04PM

Partitioning with timestamp column

12,542

dileep ch

08/01/2012 10:25PM

Re: Partitioning with timestamp column

4,205

Rick James

08/02/2012 09:26PM

Re: Partitioning with timestamp column

3,910

dileep ch

08/02/2012 11:44PM

Re: Partitioning with timestamp column

4,870

Rick James

08/03/2012 07:30PM

Accessing more partitions than needed

2,644

dileep ch

07/19/2012 01:12AM

Re: Accessing more partitions than needed

1,461

Mattias Jonsson

07/19/2012 05:23AM

Upgrading 5.1 to 5.5

1,514

dileep ch

08/02/2012 12:18AM

Re: Upgrading 5.1 to 5.5

1,390

Mattias Jonsson

08/02/2012 02:44AM

Re: Accessing more partitions than needed

1,161

dileep ch

07/19/2012 06:01AM

Partition and subpartition are different column

2,605

Toeh Boot

07/23/2012 10:54AM

Re: Partition and subpartition are different column

1,666

Rick James

07/28/2012 12:42PM

Re: Partition and subpartition are different column

1,767

Mattias Jonsson

07/24/2012 04:57AM

MySQL 5.5.24 Server Crash

3,281

Bryce Byrd

07/13/2012 08:48AM

Re: MySQL 5.5.24 Server Crash

1,395

Mattias Jonsson

07/17/2012 02:30PM

Size of partition table space

7,219

gustavo guido

06/29/2012 02:46PM

Re: Size of partition table space

2,083

Aftab Khan

07/02/2012 07:46AM

Re: Size of partition table space

2,213

Rick James

07/03/2012 12:56PM

Re: Size of partition table space

2,510

Rick James

07/01/2012 12:32PM

Re: Size of partition table space

2,191

gustavo guido

07/02/2012 07:41AM

Exchange All Partitions

9,495

Rob Dukes

06/13/2012 05:36AM

Re: Exchange All Partitions

1,314

Mattias Jonsson

06/18/2012 04:01AM

Re: Exchange All Partitions

1,341

Rick James

06/15/2012 08:52PM

Re: Exchange All Partitions

1,292

Rob Dukes

06/17/2012 12:32AM

Re: Exchange All Partitions

1,387

Rick James

06/17/2012 07:51PM

Re: Exchange All Partitions

1,254

Rob Dukes

06/17/2012 10:34PM

Re: Exchange All Partitions

1,384

Rick James

06/19/2012 08:32AM

Fetching data from a particular partion in a table

7,664

Senthilnathan Thiyagarajan

05/17/2012 05:19AM

Re: Fetching data from a particular partion in a table

1,434

Mattias Jonsson

05/18/2012 11:29AM

Help in Paritioning the Table

2,365

Amar Sheth

05/07/2012 05:02AM

Re: Help in Paritioning the Table

1,673

Rick James

05/08/2012 09:29AM

Help to optimize subpartition

3,230

Paki Paki

04/19/2012 05:28AM

Re: Help to optimize subpartition

2,059

Rick James

04/20/2012 06:54PM

Re: Help to optimize subpartition

1,928

Paki Paki

04/21/2012 04:15PM

Re: Help to optimize subpartition

1,863

Mattias Jonsson

05/02/2012 07:59AM

Re: Help to optimize subpartition

1,434

Mattias Jonsson

05/02/2012 01:41PM

Partition problem (Data striping)

3,047

Randy Roadax

04/10/2012 07:09PM

Re: Partition problem (Data striping)

2,081

Mattias Jonsson

04/13/2012 08:08AM

Re: Partition problem (Data striping)

2,045

Randy Roadax

04/13/2012 03:20PM

Re: Partition problem (Data striping)

2,059

Mattias Jonsson

04/13/2012 04:17PM

Re: Partition problem (Data striping)

1,847

Randy Roadax

04/13/2012 04:36PM

Re: Partition problem (Data striping)

1,804

Mattias Jonsson

04/14/2012 05:25PM

Re: Partition problem (Data striping)

1,789

Rick James

04/12/2012 07:02PM

Re: Partition problem (Data striping)

1,770

Randy Roadax

04/12/2012 08:30PM

Re: Partition problem (Data striping)

1,780

Rick James

04/13/2012 04:49PM

Re: Partition problem (Data striping)

1,844

Randy Roadax

04/13/2012 06:18PM

key partition

2,485

jongse park

04/12/2012 06:28AM

Re: key partition

1,731

Rick James

04/13/2012 04:12PM

Re: key partition

1,842

Mattias Jonsson

04/13/2012 08:16AM

Partition using non primary key

3,585

dileep ch

04/04/2012 10:57PM

Re: Partition using non primary key

2,140

Rick James

04/05/2012 07:57PM

Rolling partitions

3,008

Piyush Maheshwari

03/29/2012 02:19AM

Re: Rolling partitions

1,818

Rick James

03/31/2012 11:22AM

When partition a table

2,996

David Simal González

03/28/2012 11:15AM

Re: When partition a table

1,904

Rick James

03/31/2012 06:53AM

partitions to quickly drop lots of data each month

3,075

Darren White

03/22/2012 02:20AM

Re: partitions to quickly drop lots of data each month

1,590

Rick James

03/22/2012 09:56PM

Move from unpartitioned database to partitioned database

3,800

Piyush Maheshwari

03/19/2012 07:43AM

Re: Move from unpartitioned database to partitioned database

2,126

Mattias Jonsson

03/20/2012 01:21AM

Re: Move from unpartitioned database to partitioned database

2,030

Piyush Maheshwari

03/20/2012 03:39AM

Re: Move from unpartitioned database to partitioned database

1,766

Mattias Jonsson

03/20/2012 03:56AM

Re: Move from unpartitioned database to partitioned database

2,745

Rick James

03/22/2012 07:48PM

list partitioning and range subpartitioning

2,078

jongse park

03/12/2012 02:35AM

Re: list partitioning and range subpartitioning

1,510

Mattias Jonsson

03/13/2012 07:23AM

I searched table on one partiton, but MySQL scanning two partitons

3,537

Yang Bingle

03/03/2012 04:01AM

Re: I searched table on one partiton, but MySQL scanning two partitons

1,780

Rick James

03/04/2012 02:28PM

I divided table on two parts, but MySQL scanning full table

3,563

oto shavadze

02/07/2012 11:27PM

Re: I divided table on two parts, but MySQL scanning full table

1,912

Rick James

02/08/2012 05:45PM

Re: I divided table on two parts, but MySQL scanning full table

1,894

oto shavadze

02/09/2012 11:12AM

Re: I divided table on two parts, but MySQL scanning full table

1,995

Rick James

02/11/2012 12:04AM

Re: I divided table on two parts, but MySQL scanning full table

1,836

oto shavadze

02/11/2012 01:10PM

KEY vs RANGE partitioning

3,581

Basilis Papadopoulos

02/08/2012 07:38AM

Re: KEY vs RANGE partitioning

2,055

Mattias Jonsson

02/09/2012 07:35AM

Re: KEY vs RANGE partitioning

1,773

Basilis Papadopoulos

02/09/2012 01:45AM

Re: KEY vs RANGE partitioning

2,128

Mattias Jonsson

02/09/2012 10:50AM

Re: KEY vs RANGE partitioning

1,941

Rick James

02/09/2012 04:22AM

How to divide the table into 1000 part

3,189

oto shavadze

02/06/2012 01:07AM

Re: How to divide the table into 1000 part

1,474

Rick James

02/07/2012 07:02PM

Re: How to divide the table into 1000 part

1,510

oto shavadze

02/08/2012 04:12AM

Suggestion for optimization - reg

3,181

suvendu mohapatra

01/23/2012 05:09AM

Re: Suggestion for optimization - reg

1,816

Rick James

01/24/2012 02:18AM

Re: Suggestion for optimization - reg

1,773

suvendu mohapatra

01/24/2012 06:50AM

Re: Suggestion for optimization - reg

1,654

Rick James

01/25/2012 09:09PM

Re: Suggestion for optimization - reg

1,635

suvendu mohapatra

01/26/2012 06:49AM

Re: Suggestion for optimization - reg

1,576

Rick James

01/26/2012 02:48PM

Re: Suggestion for optimization - reg

2,018

suvendu mohapatra

01/26/2012 04:32PM

Re: Suggestion for optimization - reg

1,736

Rick James

01/27/2012 08:41PM

Re: Suggestion for optimization - reg

1,715

suvendu mohapatra

01/25/2012 11:04PM

truncate partition not happening

3,614

samir devaliya

01/09/2012 08:06AM

Re: truncate partition not happening

2,083

Mattias Jonsson

01/12/2012 05:02AM

Re: truncate partition not happening

1,563

samir devaliya

01/13/2012 10:37PM

Re: truncate partition not happening

1,818

samir devaliya

01/16/2012 12:41AM

Re: truncate partition not happening

1,598

Mattias Jonsson

01/16/2012 04:22AM

Re: truncate partition not happening

1,650

Rick James

01/13/2012 09:58AM

Re: truncate partition not happening

2,111

Mattias Jonsson

01/13/2012 10:13AM

reorganize syntax / procedure

4,289

kevin foote

01/12/2012 03:36PM

Re: reorganize syntax / procedure

2,397

Rick James

01/13/2012 07:34PM

Re: reorganize syntax / procedure

4,962

Mattias Jonsson

01/13/2012 10:35AM

Re: reorganize syntax / procedure

1,870

kevin foote

01/13/2012 03:57PM

Best partitioning strategy VS shortest primary key

4,648

Jérémy Cohen Solal

12/19/2011 06:12AM

Re: Best partitioning strategy VS shortest primary key

2,326

Rick James

12/20/2011 10:31AM

Re: Best partitioning strategy VS shortest primary key

2,164

Jérémy Cohen Solal

12/21/2011 07:37AM

Re: Best partitioning strategy VS shortest primary key

2,489

Rick James

12/24/2011 03:03PM

partition with non primary key column

2,813

deva clementraj

12/09/2011 01:23AM

Re: partition with non primary key column

1,649

Rick James

12/13/2011 06:22PM

Re: partition with non primary key column

1,819

Mattias Jonsson

12/12/2011 06:34AM

Attaching a single partition to MySql on another server

2,763

Mirek K

11/29/2011 11:41AM

Re: Attaching a single partition to MySql on another server

1,828

Shantanu Oak

11/30/2011 05:00AM

Re: Attaching a single partition to MySql on another server

1,570

Mirek K

12/07/2011 03:48AM

Re: Attaching a single partition to MySql on another server

1,736

Mattias Jonsson

11/30/2011 02:24AM

Re: Attaching a single partition to MySql on another server

1,614

Mirek K

11/30/2011 06:02AM

Re: Attaching a single partition to MySql on another server

1,662

Mattias Jonsson

11/30/2011 06:12AM

Re: Attaching a single partition to MySql on another server

1,827

Rick James

11/30/2011 08:07PM

Partitioning Table - GPS Data

3,624

Daniel Alves

11/30/2011 01:53PM

Re: Partitioning Table - GPS Data

1,720

Daniel Alves

11/30/2011 03:15PM

Re: Partitioning Table - GPS Data

2,038

Rick James

12/01/2011 09:57PM

Re: Partitioning Table - GPS Data

1,656

Daniel Alves

12/02/2011 08:52AM

Re: Partitioning Table - GPS Data

1,677

Daniel Alves

12/02/2011 08:51AM

Re: Partitioning Table - GPS Data

1,800

Rick James

12/03/2011 10:26AM

Re: Partitioning Table - GPS Data

1,745

Daniel Alves

12/05/2011 05:43AM

Re: Partitioning Table - GPS Data

1,989

Rick James

12/06/2011 08:46PM

Multiple handlers per partition

2,301

Rolf Martin-Hoster

11/23/2011 10:26AM

Re: Multiple handlers per partition

1,558

Mattias Jonsson

11/30/2011 02:14AM

Data not balanced in partitions

2,907

Evan P

11/26/2011 05:41AM

Re: Data not balanced in partitions

1,669

Rick James

11/28/2011 11:25AM

Re: Data not balanced in partitions

1,437

Evan P

11/26/2011 12:34PM

Re: Data not balanced in partitions

1,781

Evan P

11/26/2011 12:51PM

can't create partitioning table

2,847

Jacky Shu

11/22/2011 10:26AM

Re: can't create partitioning table

1,284

Jacky Shu

11/24/2011 07:41AM

Re: can't create partitioning table

1,398

Rick James

11/24/2011 12:32AM

Partition Pruning

2,612

Scott Watson

11/14/2011 04:19PM

Re: Partition Pruning

1,473

Mattias Jonsson

11/21/2011 05:46AM

MyIsam partition by string

4,389

Chris XX

11/03/2011 09:32AM

Re: MyIsam partition by string

1,649

Mattias Jonsson

11/07/2011 03:12PM

Re: MyIsam partition by string

1,667

Rick James

11/05/2011 10:29PM

MySQl partitioning query issue

3,513

Madhu Venkatesh

11/02/2011 10:34AM

Re: MySQl partitioning query issue

1,587

Rick James

11/05/2011 08:42PM

Re: MySQl partitioning query issue

1,449

Madhu Venkatesh

11/02/2011 12:33PM

Partition Pruning Issue while using Day() function in Range

4,375

Battu Praveen Kumar

09/21/2011 04:00AM

Re: Partition Pruning Issue while using Day() function in Range

1,832

Rick James

09/23/2011 09:22AM

Re: Partition Pruning Issue while using Day() function in Range

2,426

Battu Praveen Kumar

10/02/2011 11:10PM

Re: Partition Pruning Issue while using Day() function in Range

1,991

Rick James

10/09/2011 01:44PM

Re: Partition Pruning Issue while using Day() function in Range

2,007

Mattias Jonsson

09/22/2011 03:36AM

Partition by State

4,155

Dustin Teter

07/11/2011 01:23PM

Re: Partition by State

1,614

nugik wibowo

09/24/2011 10:45AM

Re: Partition by State

1,874

Rick James

07/14/2011 01:16AM

Constant, random or timezone-dependent expressions in (sub)partitioning

7,391

Carlo Rossetti

09/18/2011 02:39AM

Re: Constant, random or timezone-dependent expressions in (sub)partitioning

3,089

Mattias Jonsson

09/19/2011 09:17AM

Re: Constant, random or timezone-dependent expressions in (sub)partitioning

2,107

Carlo Rossetti

09/19/2011 10:40AM

ALTER TABLE t_test ADD PARTITION BY LIST(field)?

5,806

Carlo Rossetti

09/18/2011 03:27AM

Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?

19,086

Mattias Jonsson

09/19/2011 09:10AM

Re: ALTER TABLE t_test ADD PARTITION BY LIST(field)?

3,162

Carlo Rossetti

09/19/2011 10:38AM

Question regarding Partitioning by key

3,193

kuku kuku

08/28/2011 03:47PM

Re: Question regarding Partitioning by key

1,636

Rick James

08/30/2011 09:35AM

Does my database server support partioning and Sharding

4,018

David Usherwood

08/26/2011 06:29AM

Re: Does my database server support partioning and Sharding

1,634

Rick James

08/27/2011 09:01AM

Re: Does my database server support partioning and Sharding

1,571

Liran Zelkha

08/29/2011 08:30AM

Can I add/change the number of hash subpartition?

4,228

Osamu Shibata

08/22/2011 12:11PM

Re: Can I add/change the number of hash subpartition?

2,555

Mattias Jonsson

08/26/2011 04:13AM

Re: Can I add/change the number of hash subpartition?

1,683

Rick James

08/25/2011 05:42PM

innodb_data_file_path and innodb_file_per_table

3,662

Rama Surendra Babu Gudimetla

08/25/2011 03:22AM

Re: innodb_data_file_path and innodb_file_per_table

1,778

Rick James

08/25/2011 10:27PM

ENUM partitioning options?

4,174

Nicholas Semenkovich

08/15/2011 10:48AM

Re: ENUM partitioning options?

1,793

Rick James

08/16/2011 09:50AM

Tablespace

3,385

katie c

08/05/2011 12:03AM

Re: Tablespace

1,400

Rick James

08/09/2011 07:29PM

500 mil. rows table partitioning

3,643

Misha Krassovski

06/27/2011 09:15AM