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

qufu dai

08/14/2012 01:40AM

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

2,253

Mattias Jonsson

08/16/2012 02:16AM

Partition or not ?

2,795

Srikanth Mamidi

08/07/2012 12:58AM

Re: Partition or not ?

1,702

Rick James

08/09/2012 08:04PM

Partitioning with timestamp column

12,435

dileep ch

08/01/2012 10:25PM

Re: Partitioning with timestamp column

4,167

Rick James

08/02/2012 09:26PM

Re: Partitioning with timestamp column

3,862

dileep ch

08/02/2012 11:44PM

Re: Partitioning with timestamp column

4,782

Rick James

08/03/2012 07:30PM

Accessing more partitions than needed

2,609

dileep ch

07/19/2012 01:12AM

Re: Accessing more partitions than needed

1,440

Mattias Jonsson

07/19/2012 05:23AM

Upgrading 5.1 to 5.5

1,498

dileep ch

08/02/2012 12:18AM

Re: Upgrading 5.1 to 5.5

1,377

Mattias Jonsson

08/02/2012 02:44AM

Re: Accessing more partitions than needed

1,147

dileep ch

07/19/2012 06:01AM

Partition and subpartition are different column

2,568

Toeh Boot

07/23/2012 10:54AM

Re: Partition and subpartition are different column

1,637

Rick James

07/28/2012 12:42PM

Re: Partition and subpartition are different column

1,739

Mattias Jonsson

07/24/2012 04:57AM

MySQL 5.5.24 Server Crash

3,248

Bryce Byrd

07/13/2012 08:48AM

Re: MySQL 5.5.24 Server Crash

1,382

Mattias Jonsson

07/17/2012 02:30PM

Size of partition table space

7,018

gustavo guido

06/29/2012 02:46PM

Re: Size of partition table space

2,058

Aftab Khan

07/02/2012 07:46AM

Re: Size of partition table space

2,177

Rick James

07/03/2012 12:56PM

Re: Size of partition table space

2,469

Rick James

07/01/2012 12:32PM

Re: Size of partition table space

2,152

gustavo guido

07/02/2012 07:41AM

Exchange All Partitions

9,469

Rob Dukes

06/13/2012 05:36AM

Re: Exchange All Partitions

1,301

Mattias Jonsson

06/18/2012 04:01AM

Re: Exchange All Partitions

1,329

Rick James

06/15/2012 08:52PM

Re: Exchange All Partitions

1,277

Rob Dukes

06/17/2012 12:32AM

Re: Exchange All Partitions

1,367

Rick James

06/17/2012 07:51PM

Re: Exchange All Partitions

1,241

Rob Dukes

06/17/2012 10:34PM

Re: Exchange All Partitions

1,368

Rick James

06/19/2012 08:32AM

Fetching data from a particular partion in a table

7,638

Senthilnathan Thiyagarajan

05/17/2012 05:19AM

Re: Fetching data from a particular partion in a table

1,421

Mattias Jonsson

05/18/2012 11:29AM

Help in Paritioning the Table

2,341

Amar Sheth

05/07/2012 05:02AM

Re: Help in Paritioning the Table

1,646

Rick James

05/08/2012 09:29AM

Help to optimize subpartition

3,197

Paki Paki

04/19/2012 05:28AM

Re: Help to optimize subpartition

2,041

Rick James

04/20/2012 06:54PM

Re: Help to optimize subpartition

1,911

Paki Paki

04/21/2012 04:15PM

Re: Help to optimize subpartition

1,840

Mattias Jonsson

05/02/2012 07:59AM

Re: Help to optimize subpartition

1,422

Mattias Jonsson

05/02/2012 01:41PM

Partition problem (Data striping)

3,015

Randy Roadax

04/10/2012 07:09PM

Re: Partition problem (Data striping)

2,021

Mattias Jonsson

04/13/2012 08:08AM

Re: Partition problem (Data striping)

2,019

Randy Roadax

04/13/2012 03:20PM

Re: Partition problem (Data striping)

2,029

Mattias Jonsson

04/13/2012 04:17PM

Re: Partition problem (Data striping)

1,814

Randy Roadax

04/13/2012 04:36PM

Re: Partition problem (Data striping)

1,790

Mattias Jonsson

04/14/2012 05:25PM

Re: Partition problem (Data striping)

1,772

Rick James

04/12/2012 07:02PM

Re: Partition problem (Data striping)

1,746

Randy Roadax

04/12/2012 08:30PM

Re: Partition problem (Data striping)

1,731

Rick James

04/13/2012 04:49PM

Re: Partition problem (Data striping)

1,818

Randy Roadax

04/13/2012 06:18PM

key partition

2,455

jongse park

04/12/2012 06:28AM

Re: key partition

1,715

Rick James

04/13/2012 04:12PM

Re: key partition

1,821

Mattias Jonsson

04/13/2012 08:16AM

Partition using non primary key

3,549

dileep ch

04/04/2012 10:57PM

Re: Partition using non primary key

2,114

Rick James

04/05/2012 07:57PM

Rolling partitions

2,986

Piyush Maheshwari

03/29/2012 02:19AM

Re: Rolling partitions

1,785

Rick James

03/31/2012 11:22AM

When partition a table

2,945

David Simal González

03/28/2012 11:15AM

Re: When partition a table

1,875

Rick James

03/31/2012 06:53AM

partitions to quickly drop lots of data each month

3,030

Darren White

03/22/2012 02:20AM

Re: partitions to quickly drop lots of data each month

1,568

Rick James

03/22/2012 09:56PM

Move from unpartitioned database to partitioned database

3,753

Piyush Maheshwari

03/19/2012 07:43AM

Re: Move from unpartitioned database to partitioned database

2,097

Mattias Jonsson

03/20/2012 01:21AM

Re: Move from unpartitioned database to partitioned database

2,002

Piyush Maheshwari

03/20/2012 03:39AM

Re: Move from unpartitioned database to partitioned database

1,751

Mattias Jonsson

03/20/2012 03:56AM

Re: Move from unpartitioned database to partitioned database

2,704

Rick James

03/22/2012 07:48PM

list partitioning and range subpartitioning

2,054

jongse park

03/12/2012 02:35AM

Re: list partitioning and range subpartitioning

1,498

Mattias Jonsson

03/13/2012 07:23AM

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

3,475

Yang Bingle

03/03/2012 04:01AM

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

1,755

Rick James

03/04/2012 02:28PM

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

3,515

oto shavadze

02/07/2012 11:27PM

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

1,891

Rick James

02/08/2012 05:45PM

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

1,877

oto shavadze

02/09/2012 11:12AM

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

1,979

Rick James

02/11/2012 12:04AM

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

1,819

oto shavadze

02/11/2012 01:10PM

KEY vs RANGE partitioning

3,519

Basilis Papadopoulos

02/08/2012 07:38AM

Re: KEY vs RANGE partitioning

2,035

Mattias Jonsson

02/09/2012 07:35AM

Re: KEY vs RANGE partitioning

1,736

Basilis Papadopoulos

02/09/2012 01:45AM

Re: KEY vs RANGE partitioning

2,095

Mattias Jonsson

02/09/2012 10:50AM

Re: KEY vs RANGE partitioning

1,911

Rick James

02/09/2012 04:22AM

How to divide the table into 1000 part

3,158

oto shavadze

02/06/2012 01:07AM

Re: How to divide the table into 1000 part

1,460

Rick James

02/07/2012 07:02PM

Re: How to divide the table into 1000 part

1,494

oto shavadze

02/08/2012 04:12AM

Suggestion for optimization - reg

3,150

suvendu mohapatra

01/23/2012 05:09AM

Re: Suggestion for optimization - reg

1,794

Rick James

01/24/2012 02:18AM

Re: Suggestion for optimization - reg

1,751

suvendu mohapatra

01/24/2012 06:50AM

Re: Suggestion for optimization - reg

1,630

Rick James

01/25/2012 09:09PM

Re: Suggestion for optimization - reg

1,604

suvendu mohapatra

01/26/2012 06:49AM

Re: Suggestion for optimization - reg

1,555

Rick James

01/26/2012 02:48PM

Re: Suggestion for optimization - reg

1,997

suvendu mohapatra

01/26/2012 04:32PM

Re: Suggestion for optimization - reg

1,720

Rick James

01/27/2012 08:41PM

Re: Suggestion for optimization - reg

1,690

suvendu mohapatra

01/25/2012 11:04PM

truncate partition not happening

3,578

samir devaliya

01/09/2012 08:06AM

Re: truncate partition not happening

2,066

Mattias Jonsson

01/12/2012 05:02AM

Re: truncate partition not happening

1,553

samir devaliya

01/13/2012 10:37PM

Re: truncate partition not happening

1,799

samir devaliya

01/16/2012 12:41AM

Re: truncate partition not happening

1,586

Mattias Jonsson

01/16/2012 04:22AM

Re: truncate partition not happening

1,635

Rick James

01/13/2012 09:58AM

Re: truncate partition not happening

2,092

Mattias Jonsson

01/13/2012 10:13AM

reorganize syntax / procedure

4,224

kevin foote

01/12/2012 03:36PM

Re: reorganize syntax / procedure

2,353

Rick James

01/13/2012 07:34PM

Re: reorganize syntax / procedure

4,777

Mattias Jonsson

01/13/2012 10:35AM

Re: reorganize syntax / procedure

1,842

kevin foote

01/13/2012 03:57PM

Best partitioning strategy VS shortest primary key

4,611

Jérémy Cohen Solal

12/19/2011 06:12AM

Re: Best partitioning strategy VS shortest primary key

2,311

Rick James

12/20/2011 10:31AM

Re: Best partitioning strategy VS shortest primary key

2,143

Jérémy Cohen Solal

12/21/2011 07:37AM

Re: Best partitioning strategy VS shortest primary key

2,471

Rick James

12/24/2011 03:03PM

partition with non primary key column

2,784

deva clementraj

12/09/2011 01:23AM

Re: partition with non primary key column

1,640

Rick James

12/13/2011 06:22PM

Re: partition with non primary key column

1,807

Mattias Jonsson

12/12/2011 06:34AM

Attaching a single partition to MySql on another server

2,739

Mirek K

11/29/2011 11:41AM

Re: Attaching a single partition to MySql on another server

1,797

Shantanu Oak

11/30/2011 05:00AM

Re: Attaching a single partition to MySql on another server

1,552

Mirek K

12/07/2011 03:48AM

Re: Attaching a single partition to MySql on another server

1,696

Mattias Jonsson

11/30/2011 02:24AM

Re: Attaching a single partition to MySql on another server

1,601

Mirek K

11/30/2011 06:02AM

Re: Attaching a single partition to MySql on another server

1,649

Mattias Jonsson

11/30/2011 06:12AM

Re: Attaching a single partition to MySql on another server

1,811

Rick James

11/30/2011 08:07PM

Partitioning Table - GPS Data

3,579

Daniel Alves

11/30/2011 01:53PM

Re: Partitioning Table - GPS Data

1,707

Daniel Alves

11/30/2011 03:15PM

Re: Partitioning Table - GPS Data

2,025

Rick James

12/01/2011 09:57PM

Re: Partitioning Table - GPS Data

1,639

Daniel Alves

12/02/2011 08:52AM

Re: Partitioning Table - GPS Data

1,655

Daniel Alves

12/02/2011 08:51AM

Re: Partitioning Table - GPS Data

1,781

Rick James

12/03/2011 10:26AM

Re: Partitioning Table - GPS Data

1,729

Daniel Alves

12/05/2011 05:43AM

Re: Partitioning Table - GPS Data

1,973

Rick James

12/06/2011 08:46PM

Multiple handlers per partition

2,279

Rolf Martin-Hoster

11/23/2011 10:26AM

Re: Multiple handlers per partition

1,540

Mattias Jonsson

11/30/2011 02:14AM

Data not balanced in partitions

2,880

Evan P

11/26/2011 05:41AM

Re: Data not balanced in partitions

1,647

Rick James

11/28/2011 11:25AM

Re: Data not balanced in partitions

1,426

Evan P

11/26/2011 12:34PM

Re: Data not balanced in partitions

1,766

Evan P

11/26/2011 12:51PM

can't create partitioning table

2,831

Jacky Shu

11/22/2011 10:26AM

Re: can't create partitioning table

1,272

Jacky Shu

11/24/2011 07:41AM

Re: can't create partitioning table

1,382

Rick James

11/24/2011 12:32AM

Partition Pruning

2,587

Scott Watson

11/14/2011 04:19PM

Re: Partition Pruning

1,460

Mattias Jonsson

11/21/2011 05:46AM

MyIsam partition by string

4,362

Chris XX

11/03/2011 09:32AM

Re: MyIsam partition by string

1,636

Mattias Jonsson

11/07/2011 03:12PM

Re: MyIsam partition by string

1,657

Rick James

11/05/2011 10:29PM

MySQl partitioning query issue

3,487

Madhu Venkatesh

11/02/2011 10:34AM

Re: MySQl partitioning query issue

1,573

Rick James

11/05/2011 08:42PM

Re: MySQl partitioning query issue

1,434

Madhu Venkatesh

11/02/2011 12:33PM

Partition Pruning Issue while using Day() function in Range

4,331

Battu Praveen Kumar

09/21/2011 04:00AM

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

1,807

Rick James

09/23/2011 09:22AM

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

2,400

Battu Praveen Kumar

10/02/2011 11:10PM

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

1,951

Rick James

10/09/2011 01:44PM

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

1,966

Mattias Jonsson

09/22/2011 03:36AM

Partition by State

4,120

Dustin Teter

07/11/2011 01:23PM

Re: Partition by State

1,601

nugik wibowo

09/24/2011 10:45AM

Re: Partition by State

1,858

Rick James

07/14/2011 01:16AM

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

6,956

Carlo Rossetti

09/18/2011 02:39AM

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

3,040

Mattias Jonsson

09/19/2011 09:17AM

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

2,066

Carlo Rossetti

09/19/2011 10:40AM

ALTER TABLE t_test ADD PARTITION BY LIST(field)?

5,736

Carlo Rossetti

09/18/2011 03:27AM

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

18,586

Mattias Jonsson

09/19/2011 09:10AM

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

3,105

Carlo Rossetti

09/19/2011 10:38AM

Question regarding Partitioning by key

3,160

kuku kuku

08/28/2011 03:47PM

Re: Question regarding Partitioning by key

1,626

Rick James

08/30/2011 09:35AM

Does my database server support partioning and Sharding

3,986

David Usherwood

08/26/2011 06:29AM

Re: Does my database server support partioning and Sharding

1,621

Rick James

08/27/2011 09:01AM

Re: Does my database server support partioning and Sharding

1,559

Liran Zelkha

08/29/2011 08:30AM

Can I add/change the number of hash subpartition?

4,189

Osamu Shibata

08/22/2011 12:11PM

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

2,516

Mattias Jonsson

08/26/2011 04:13AM

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

1,666

Rick James

08/25/2011 05:42PM

innodb_data_file_path and innodb_file_per_table

3,636

Rama Surendra Babu Gudimetla

08/25/2011 03:22AM

Re: innodb_data_file_path and innodb_file_per_table

1,763

Rick James

08/25/2011 10:27PM

ENUM partitioning options?

4,146

Nicholas Semenkovich

08/15/2011 10:48AM

Re: ENUM partitioning options?

1,781

Rick James

08/16/2011 09:50AM

Tablespace

3,359

katie c

08/05/2011 12:03AM

Re: Tablespace

1,388

Rick James

08/09/2011 07:29PM

500 mil. rows table partitioning

3,610

Misha Krassovski

06/27/2011 09:15AM