MySQL :: MySQL Forums :: Optimizer & Parser

New Topic

Pages:

« 1

...

7 8 9 10 11

...

19 »

Subject

Views

Written By

Posted

Question on bad execution plan

4,693

Zw Zhu

06/16/2010 07:36AM

Re: Question on bad execution plan

1,924

Rick James

06/17/2010 09:29AM

Re: Question on bad execution plan

1,663

noicy seal

06/21/2010 09:24AM

Re: Question on bad execution plan

1,816

Rick James

06/21/2010 06:47PM

Re: Question on bad execution plan

1,870

noicy seal

06/22/2010 07:33AM

Re: Question on bad execution plan

1,906

Rick James

06/22/2010 09:09AM

Re: Question on bad execution plan

1,765

noicy seal

06/23/2010 07:44AM

Re: Question on bad execution plan

1,888

Zw Zhu

06/24/2010 12:17AM

Re: Question on bad execution plan

1,888

Rick James

06/24/2010 09:17PM

Re: Question on bad execution plan

1,730

Zw Zhu

06/28/2010 02:39AM

Re: Question on bad execution plan

1,870

Rick James

06/28/2010 08:50PM

Union of two binary Strings

4,464

Amir Manzour

06/18/2010 10:43AM

Re: Union of two binary Strings

2,169

Rick James

06/21/2010 06:49PM

Re: Union of two binary Strings

1,691

Amir Manzour

06/26/2010 11:15AM

Re: Union of two binary Strings

1,607

Rick James

06/26/2010 12:50PM

Re: Union of two binary Strings

1,594

Amir Manzour

06/26/2010 05:40PM

Re: Union of two binary Strings

1,510

Amir Manzour

06/26/2010 05:20PM

Re: Union of two binary Strings

1,708

Amir Manzour

06/22/2010 09:30AM

Help

2,663

Ami Panchal

06/24/2010 04:27AM

AUTO_INCREMENT does not work the way I want it to

1,479

Rick James

06/26/2010 02:15PM

optimizar mysql innodb

4,065

juan sanchez

06/24/2010 01:21AM

lock for update in Innodb

3,551

noicy seal

06/23/2010 07:07AM

indices not used

2,941

Martin Luy

05/25/2010 04:13AM

Re: indices not used

1,736

Martin Luy

05/25/2010 12:07PM

Re: indices not used

1,590

Rick James

05/27/2010 08:35PM

Re: indices not used

1,527

Martin Luy

06/19/2010 03:35AM

Re: indices not used

1,474

Rick James

06/21/2010 06:25PM

Re: indices not used

1,417

Martin Luy

06/22/2010 01:15AM

Recurring expressions

2,568

Johannes Gerer

05/27/2010 03:37PM

Re: Recurring expressions

1,456

Rick James

05/28/2010 08:32PM

Execution plan changes back and forth

3,136

John Scott

05/26/2010 02:46PM

Re: Execution plan changes back and forth

1,741

Rick James

05/27/2010 08:26PM

COUNT(1) very slow why?

3,459

fabio rossi

05/18/2010 02:56AM

Re: COUNT(1) very slow why?

1,671

Rick James

05/20/2010 09:21PM

Query Optimization

3,246

Alessandro De Lorenzi

05/18/2010 07:43AM

Re: Query Optimization

1,593

Rick James

05/20/2010 09:19PM

ORDER BY and join: include columns that don't matter?

2,744

Chris Hennick

05/11/2010 02:54AM

Re: ORDER BY and join: include columns that don't matter?

1,685

Rick James

05/12/2010 08:04AM

Help with ORDER BY with LIMIT

5,391

Lukas Pilny

05/09/2010 02:24PM

Re: Help with ORDER BY with LIMIT

2,587

Rick James

05/10/2010 10:59PM

Re: Help with ORDER BY with LIMIT

2,123

Lukas Pilny

05/11/2010 06:05AM

table_cache not getting read

2,824

Douglas Ferguson

05/07/2010 01:08AM

Re: table_cache not getting read

1,735

Rick James

05/10/2010 11:19PM

UDF is no longer optimal

2,429

Chris Canipe

05/10/2010 02:07PM

Re: UDF is no longer optimal

1,564

Chris Canipe

05/10/2010 03:15PM

Composite Primary Key

4,743

Gaurav Sharma

04/27/2010 05:30AM

Re: Composite Primary Key

1,950

Rick James

04/29/2010 11:19PM

Help with Explain Plan

2,930

Corey Samuels

04/20/2010 10:02AM

Re: Help with Explain Plan

1,695

Rick James

04/24/2010 02:36PM

Re: Help with Explain Plan

1,784

Corey Samuels

04/27/2010 12:44PM

Re: Help with Explain Plan

1,426

Rick James

04/29/2010 09:17PM

Re: Help with Explain Plan

1,838

Corey Samuels

04/22/2010 09:53AM

help, optmization... 6 tables... 1 select!

2,729

John Aust

04/27/2010 06:59AM

URGENT: MySQL don't get enough CPU

2,488

Robert Garrido

04/21/2010 03:38AM

Re: URGENT: MySQL don't get enough CPU

1,505

Rick James

04/24/2010 03:14PM

partition question

2,764

h ch

04/14/2010 02:15AM

Re: partition question

1,603

Rick James

04/18/2010 01:36AM

why can character set of string literal cause different optimazation?

2,217

Jerry Roletter

04/15/2010 04:27PM

How can I optimize this query?

5,522

Martin Schiff

03/12/2010 02:40PM

Re: How can I optimize this query?

1,942

Martin Schiff

03/16/2010 01:59PM

Re: How can I optimize this query?

1,949

Rick James

03/27/2010 03:36PM

Re: How can I optimize this query?

1,701

Martin Schiff

04/14/2010 07:21AM

Re: How can I optimize this query?

2,419

Rick James

03/13/2010 04:07PM

Re: How can I optimize this query?

1,917

Martin Schiff

03/16/2010 09:40AM

Re: How can I optimize this query?

1,916

Martin Schiff

03/16/2010 08:21AM

Re: How can I optimize this query?

1,914

Martin Schiff

03/16/2010 08:16AM

Re: How can I optimize this query?

1,919

Martin Schiff

03/16/2010 08:16AM

Re: How can I optimize this query?

1,996

Martin Schiff

03/16/2010 07:58AM

Re: IP range optimization

1,840

Rick James

03/13/2010 04:17PM

Re: IP range optimization

1,997

Martin Schiff

03/16/2010 08:22AM

Re: IP range optimization

2,485

pavel iliev

04/14/2010 02:27AM

still the trigger problem

3,346

h ch

04/07/2010 03:11AM

Re: still the trigger problem

1,524

h ch

04/07/2010 06:43PM

Re: still the trigger problem

1,547

Rick James

04/10/2010 01:10AM

Re: still the trigger problem

1,687

h ch

04/09/2010 06:39PM

Really slow query with dependent subquery

3,867

Ivo H

04/07/2010 04:12AM

Re: Really slow query with dependent subquery

1,936

Ivo H

04/07/2010 05:53AM

Not equal operation can benefit from hash index?

4,621

h ch

04/05/2010 08:45PM

Re: Not equal operation can benefit from hash index?

2,034

Rick James

04/06/2010 09:53PM

Optimizer struggling with smaller dataset

2,590

Damian Harvey

03/31/2010 09:09PM

Re: Optimizer struggling with smaller dataset

1,513

Rick James

04/02/2010 11:19PM

how can i get the query execute time ?

2,389

h ch

04/01/2010 02:01AM

group by date(indexed datetime) hard to optimize

8,034

Lee Marshall

03/30/2010 12:37AM

Re: group by date(indexed datetime) hard to optimize

2,803

Rick James

03/31/2010 10:58PM

Why filtering, ordering and limiting does not use index?

3,159

Marc Canaleta

03/30/2010 07:26AM

Re: Why filtering, ordering and limiting does not use index?

1,625

Rick James

03/31/2010 10:44PM

slave low speed in replication

3,221

h ch

03/29/2010 01:02AM

Re: slave low speed in replication

1,876

Rick James

03/30/2010 08:28AM

Re: slave low speed in replication

1,804

h ch

03/30/2010 06:43PM

Re: slave low speed in replication

1,509

Rick James

03/30/2010 09:48PM

Re: slave low speed in replication

1,695

h ch

03/31/2010 01:05AM

Error when using Indexing hint

3,171

Susi P

03/28/2010 04:11AM

Re: Error when using Indexing hint

1,601

Rick James

03/28/2010 10:53PM

execute select took 8 min

2,737

h ch

03/26/2010 12:31AM

Re: execute select took 8 min

1,497

h ch

03/26/2010 01:51AM

Re: execute select took 8 min

1,486

h ch

03/26/2010 02:24AM

Projection of a WHERE attribute

7,335

brice chardin

03/16/2010 12:03PM

Re: Projection of a WHERE attribute

2,268

brice chardin

03/18/2010 04:15AM

Re: Projection of a WHERE attribute

1,864

Rick James

03/19/2010 07:37AM

Re: Projection of a WHERE attribute

2,162

brice chardin

03/19/2010 10:06AM

Problems with query not using expeced indexes

4,553

Lars Olesen

03/09/2010 07:12AM

Re: Problems with query not using expeced indexes

1,872

Rick James

03/10/2010 10:28PM

Re: Problems with query not using expeced indexes

1,704

Lars Olesen

03/11/2010 06:08AM

Re: Problems with query not using expeced indexes

1,705

Rick James

03/11/2010 11:00PM

Re: Problems with query not using expeced indexes

1,763

Lars Olesen

03/17/2010 12:16PM

Re: Problems with query not using expeced indexes

1,854

Rick James

03/17/2010 09:57PM

Re: Problems with query not using expeced indexes

1,580

Lars Olesen

03/18/2010 01:06AM

Re: Problems with query not using expeced indexes

1,958

Rick James

03/18/2010 07:41AM

Re: Problems with query not using expeced indexes

1,688

Lars Olesen

03/09/2010 07:13AM

union, where and indices

9,580

Mattia Belletti

03/12/2010 09:21AM

Re: union, where and indices

2,304

Rick James

03/13/2010 11:46AM

query optimization

2,585

amol deshpande

03/12/2010 06:12AM

Re: query optimization

1,628

Rick James

03/13/2010 09:11AM

Close to a million records & query too slow

6,392

sabelo simelane

03/03/2010 01:49PM

Re: Close to a million records & query too slow

2,518

Rick James

03/04/2010 10:09PM

Re: Close to a million records & query too slow

2,310

sabelo simelane

03/08/2010 03:36PM

Re: Close to a million records & query too slow

1,966

sabelo simelane

03/08/2010 04:12PM

Re: Close to a million records & query too slow

2,353

Rick James

03/09/2010 09:20PM

Re: Close to a million records & query too slow

1,986

sabelo simelane

03/11/2010 01:47AM

table/query help

3,450

a g

03/03/2010 12:36PM

Re: table/query help

1,768

Rick James

03/04/2010 10:22PM

How to get rid of 'filesort'?

3,965

Ruslan Osmanov

02/28/2010 08:51AM

Re: How to get rid of 'filesort'?

1,934

Rick James

03/01/2010 04:51PM

Re: How to get rid of 'filesort'?

1,776

Ruslan Osmanov

03/01/2010 10:03PM

Re: How to get rid of 'filesort'?

2,071

Rick James

03/01/2010 11:27PM

Re: How to get rid of 'filesort'?

1,886

Ruslan Osmanov

03/02/2010 02:34AM

Re: How to get rid of 'filesort'?

1,747

Rick James

03/02/2010 04:56PM

Is it possible to avoid "Using temporary" when distinct is used with join?

3,822

Wai Yip Lau

02/25/2010 06:33PM

Re: Is it possible to avoid "Using temporary" when distinct is used with join?

1,833

Rick James

02/26/2010 09:03PM

Re: Is it possible to avoid "Using temporary" when distinct is used with join?

2,208

Wai Yip Lau

03/02/2010 09:50AM

Re: Is it possible to avoid "Using temporary" when distinct is used with join?

1,960

Rick James

03/02/2010 02:36PM

Slow search on one table, many where, order by and limit

4,281

Yair P

02/07/2010 07:34AM

Re: Slow search on one table, many where, order by and limit

2,111

Rick James

02/11/2010 01:30AM

Re: Slow search on one table, many where, order by and limit

2,069

Yair P

02/26/2010 11:27AM

Re: Slow search on one table, many where, order by and limit

1,987

Rick James

02/26/2010 12:40PM

Re: Slow search on one table, many where, order by and limit

2,211

Yair P

02/26/2010 02:02PM

Re: Slow search on one table, many where, order by and limit

1,867

Rick James

02/26/2010 07:40PM

Re: Slow search on one table, many where, order by and limit

2,991

Yair P

03/01/2010 03:33AM

Re: Slow search on one table, many where, order by and limit

2,098

Rick James

03/01/2010 01:50PM

Query that returns indexed fields involves FILESORT, why?

4,629

Yurij Zagrebnoy

02/26/2010 12:36PM

Re: Query that returns indexed fields involves FILESORT, why?

2,320

Rick James

02/28/2010 01:36PM

Re: Query that returns indexed fields involves FILESORT, why?

2,052

Yurij Zagrebnoy

03/01/2010 08:28AM

Re: Query that returns indexed fields involves FILESORT, why?

2,164

Rick James

03/01/2010 01:16PM

aggregation in mysql

2,993

luca ghionna

02/27/2010 11:05AM

Re: aggregation in mysql

1,751

Rick James

02/28/2010 01:48PM

Re: aggregation in mysql

2,220

luca ghionna

02/28/2010 02:21PM

INNER JOIN optimization

13,321

Irfan Ali

02/22/2010 12:52AM

Re: INNER JOIN optimization

3,935

Rick James

02/23/2010 11:44PM

Re: INNER JOIN optimization

3,574

Irfan Ali

02/27/2010 01:36PM

Re: INNER JOIN optimization

3,135

Rick James

02/28/2010 11:20AM

aggregation in mysql

3,211

luca ghionna

02/27/2010 11:03AM

How to improve mysql when the table is larger than 4G

3,730

Zhiyi Zhao

02/25/2010 08:19PM

Re: How to improve mysql when the table is larger than 4G

1,780

Rick James

02/26/2010 11:37AM

Distinct/group by, order by and filesort

5,973

Tolan Blundell

02/23/2010 01:20PM

Re: Distinct/group by, order by and filesort

2,781

Tolan Blundell

02/24/2010 04:50AM

Re: Distinct/group by, order by and filesort

2,533

Rick James

02/25/2010 10:39AM

Re: Distinct/group by, order by and filesort

2,401

Tolan Blundell

02/25/2010 11:54AM

Re: Distinct/group by, order by and filesort

2,333

Rick James

02/25/2010 01:34PM

Can this be optimized any futher?

2,694

Rob Strong

02/16/2010 02:44PM

Re: Can this be optimized any futher?

1,498

Rick James

02/20/2010 11:26PM

Major MySQL problems

5,156

Paul Coulter

02/10/2010 04:26AM

Re: Major MySQL problems

2,654

Rick James

02/11/2010 10:45PM

Re: Major MySQL problems

2,474

Paul Coulter

02/12/2010 07:17AM

Re: Major MySQL problems

2,001

Rick James

02/12/2010 11:04AM

How to list data effectively

2,983

sricharan vemuri

02/10/2010 09:55AM

Re: How to list data effectively

1,547

Rick James

02/11/2010 10:56PM

Re: How to list data effectively

1,556

sricharan vemuri

02/12/2010 08:21AM

query optimisation

2,364

Daniel Kirk

02/10/2010 08:08AM

Re: query optimisation

1,497

Rick James

02/11/2010 10:46PM

Pages:

« 1

...

7 8 9 10 11

...

19 »

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.