MySQL :: MySQL Forums :: Optimizer & Parser

Announcements	Last Post
• Announcing July 2026 Releases featuring MySQL Server 26.7.0, 9.7.2 and 8.4.11	08/01/2026 04:40AM

New Topic

Pages:

« 1

...

12 13 14 15 16

...

19 »

Subject

Views

Written By

Posted

Estimating query results quantity

3,289

Andrey M

12/18/2007 08:25AM

Indexes won't work if using DISTINCT

3,531

Andrey M

12/18/2007 08:06AM

How MySQL Handles ORDER BY, GROUP BY, and DISTINCT

4,135

Edwin DeSouza

12/07/2007 04:28PM

Anchor Modeling

4,437

Lars Rönnbäck

12/07/2007 07:35AM

How to optimise a query to avoid filesort on LARGE resultset

5,536

Marek Narkiewicz

11/26/2007 10:54AM

Re: How to optimise a query to avoid filesort on LARGE resultset

2,974

Marek Narkiewicz

11/27/2007 03:47AM

Re: How to optimise a query to avoid filesort on LARGE resultset

4,624

Faury Rodriguez

11/26/2007 03:36PM

Re: How to optimise a query to avoid filesort on LARGE resultset

3,284

KimSeong Loh

11/26/2007 03:36PM

Big tables and dates

4,427

Benjamin Fonze

11/20/2007 06:04PM

Re: Big tables and dates

2,511

KimSeong Loh

11/21/2007 02:02AM

Does MySQL support function based index on datetime column?

14,132

Sailesh Patel

09/06/2007 03:34PM

Re: Does MySQL support function based index on datetime column?

5,591

Benjamin Fonze

11/20/2007 06:07PM

Re: Does MySQL support function based index on datetime column?

7,034

KimSeong Loh

09/06/2007 06:25PM

select won't use index

4,509

damage damage

11/20/2007 02:31AM

Re: select won't use index

2,551

KimSeong Loh

11/20/2007 04:00PM

Want ORDER BY to use indexed portion of long text field

6,745

Bob Fitterman

10/13/2007 07:03AM

Re: Want ORDER BY to use indexed portion of long text field

2,784

KimSeong Loh

11/15/2007 03:51PM

Re: Want ORDER BY to use indexed portion of long text field

2,918

Chris Schneider

10/24/2007 03:06PM

Re: Want ORDER BY to use indexed portion of long text field

3,080

Bob Fitterman

11/15/2007 09:20AM

optimze for a mysql server - my.cnf

5,107

kean galileo

11/06/2007 06:26PM

Making the EXPLAIN EXTENDED query runnable

3,880

Niklas Saers

10/31/2007 07:07AM

closing DB policy

3,446

Danny Jaworski

10/30/2007 02:52AM

inner join on key does full table scan anyway

7,618

Doug Perham

10/26/2007 06:34AM

Re: inner join on key does full table scan anyway

3,558

Chris Schneider

10/26/2007 01:21PM

Priority & Timeout

5,947

Jonathan Isaac

08/20/2007 11:36AM

Re: Priority & Timeout

3,409

Chris Schneider

10/24/2007 03:12PM

Problem with result field list

3,708

Adrian Chapela Cordeiro

10/02/2007 10:40AM

Re: Problem with result field list

2,315

Chris Schneider

10/24/2007 02:54PM

Aggregate function optimization for same column in same record

4,282

Nathan Alden

10/07/2007 10:30PM

ORDER BY ... LIMIT

4,248

Ed Mazur

09/27/2007 11:24AM

Re: ORDER BY ... LIMIT

2,678

KimSeong Loh

09/27/2007 05:07PM

How to speed up my DB

3,324

Venkateswaran Nagarajan

09/21/2007 09:05PM

Query execution time depends on the size of the tables????????????

3,673

Venkateswaran Nagarajan

09/21/2007 08:56PM

multiple index is used only partially

4,724

Miguel Balsevich

09/08/2007 03:37PM

Re: multiple index is used only partially

2,758

Miguel Balsevich

09/11/2007 08:04AM

Using FileSort

4,751

Clement Ho

09/10/2007 05:21PM

Help join optimisation

3,598

Catia Lavalle

09/05/2007 05:41AM

Can I speed this up?

5,735

Eljakim Schrijvers

02/17/2007 11:18AM

Re: Can I speed this up?

2,962

Adrian Chapela Cordeiro

08/30/2007 02:55AM

Re: Can I speed this up?

3,083

KimSeong Loh

02/25/2007 11:40PM

Re: Can I speed this up?

3,157

Eljakim Schrijvers

03/10/2007 01:23PM

Re: Can I speed this up?

2,996

KimSeong Loh

03/11/2007 12:59AM

Re: Can I speed this up?

3,009

Dian Kresno

04/26/2007 01:04AM

Re: Can I speed this up?

3,248

Eljakim Schrijvers

02/17/2007 11:23AM

time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables

5,651

Jan Theodore Galkowski

06/27/2007 08:52AM

Re: time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables

3,334

Adrian Chapela Cordeiro

08/30/2007 02:13AM

LEFT JOIN Optimization

8,134

Ram R

08/21/2007 03:04PM

Re: LEFT JOIN Optimization

3,970

KimSeong Loh

08/21/2007 06:45PM

Re: LEFT JOIN Optimization

3,213

Adrian Chapela Cordeiro

08/29/2007 03:55AM

Re: LEFT JOIN Optimization

3,551

Ram R

08/21/2007 11:32PM

Re: LEFT JOIN Optimization

3,465

KimSeong Loh

08/29/2007 07:19PM

A popular forum not able to take load.. my.cnf optimization needed

8,059

Raman Singh

08/12/2007 12:48AM

Re: A popular forum not able to take load.. my.cnf optimization needed

2,942

Adrian Chapela Cordeiro

08/29/2007 04:50AM

Re: A popular forum not able to take load.. my.cnf optimization needed

2,980

KimSeong Loh

08/12/2007 05:17PM

Optimized query still way too slow

4,148

Brad Douglas

08/13/2007 04:54PM

Speed up query execution with 30Million rows

7,491

Vibhu Bansal

08/09/2007 06:40AM

Re: Speed up query execution with 30Million rows

3,559

Yogesh Salvi

08/13/2007 05:46AM

How to optimize this query?

4,675

Kwang Chin Lee

06/20/2007 07:38AM

Re: How to optimize this query?

2,439

Yogesh Salvi

08/13/2007 05:43AM

How to stop temporary table in this query

4,155

Mike Zupan

08/09/2007 11:19AM

Indexing table takes 4 hours

3,235

Francisco Cha

08/08/2007 03:11PM

Help requested optimising query with subquery

3,475

Christian Seaman

08/08/2007 06:21AM

Re: Help requested optimising query with subquery

2,320

KimSeong Loh

08/08/2007 07:01AM

Need some help to optimize a query with multiple JOIN

6,906

Jean-Baptiste ANNE

07/30/2007 01:42PM

Re: Need some help to optimize a query with multiple JOIN

3,050

Sergey Belov

07/31/2007 05:55AM

Re: Need some help to optimize a query with multiple JOIN

2,905

Jean-Baptiste ANNE

07/31/2007 10:20AM

Re: Need some help to optimize a query with multiple JOIN

2,879

Sergey Belov

08/01/2007 01:12AM

Re: Need some help to optimize a query with multiple JOIN

3,071

Jean-Baptiste ANNE

08/01/2007 07:58AM

Re: Need some help to optimize a query with multiple JOIN

3,102

KimSeong Loh

08/05/2007 01:03AM

why does explain plan change?

12,228

charlie w

07/30/2007 10:14AM

Re: why does explain plan change?

3,433

Fabio Sgamo

08/03/2007 05:22AM

Problem with optimization of a WHERE clause

3,961

Giorgio Calderone

08/02/2007 12:41PM

Can't understand why optimizer doesn't work properly :(

3,645

Sergey Belov

07/23/2007 02:03PM

Re: Can't understand why optimizer doesn't work properly :(

2,409

KimSeong Loh

07/23/2007 07:21PM

Re: Can't understand why optimizer doesn't work properly :(

2,481

Sergey Belov

07/24/2007 12:26AM

Re: Can't understand why optimizer doesn't work properly :(

2,290

KimSeong Loh

07/24/2007 02:08AM

Re: Can't understand why optimizer doesn't work properly :(

2,528

Sergey Belov

07/24/2007 02:42AM

Re: Can't understand why optimizer doesn't work properly :(

2,248

KimSeong Loh

07/24/2007 06:02PM

Re: Can't understand why optimizer doesn't work properly :(

2,366

Sergey Belov

07/25/2007 11:10PM

Optimizing a search query

3,134

Staffan S

07/25/2007 03:58AM

Index evaluation

3,620

Drei Bit

07/23/2007 04:51PM

Re: Index evaluation

2,426

KimSeong Loh

07/23/2007 07:27PM

Re: Index evaluation

2,363

Drei Bit

07/24/2007 05:24AM

Re: Index evaluation

2,446

Drei Bit

07/23/2007 05:18PM

Re: Index evaluation

2,394

KimSeong Loh

07/24/2007 02:06AM

Re: Index evaluation

2,409

Drei Bit

07/24/2007 04:33AM

Profiling only works in MySQL 5.0.37?

4,331

Suave Su

07/19/2007 12:22AM

Re: Profiling only works in MySQL 5.0.37?

2,561

KimSeong Loh

07/19/2007 05:02AM

Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

5,884

Drei Bit

07/03/2007 05:37PM

Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

2,736

KimSeong Loh

07/04/2007 06:45AM

Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

2,619

Drei Bit

07/04/2007 10:49AM

Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

2,677

KimSeong Loh

07/05/2007 01:14AM

Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

2,577

Drei Bit

07/05/2007 03:22AM

Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

2,647

KimSeong Loh

07/05/2007 03:16PM

Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

2,584

Drei Bit

07/10/2007 09:37AM

join order when using order by

6,901

Christopher Cudennec

07/09/2007 07:54AM

default order by

5,186

Joel Webb

07/06/2007 08:49AM

Cost Model Information

3,319

Drei Bit

07/05/2007 03:26AM

Optimizer misbehaves

3,646

Drei Bit

07/04/2007 05:16AM

Re: Optimizer misbehaves

2,484

KimSeong Loh

07/04/2007 07:26AM

Re: Optimizer misbehaves

2,486

Drei Bit

07/04/2007 10:37AM

Variable where index optimizing

3,148

alex jordanov

06/29/2007 04:37AM

How to optimize this program? Thanks

3,051

li grewat

06/28/2007 08:31PM

Star joins?

3,588

Seth Grimes

01/17/2006 08:57PM

Re: Star joins?

2,560

Seth Grimes

01/26/2006 11:35AM

Re: Star joins?

2,670

Jay Pipes

01/26/2006 01:00PM

Re: Star joins?

2,503

Seth Grimes

01/21/2006 07:32PM

Re: Star joins?

3,629

Timour Katchaounov

01/23/2006 04:10PM

Re: Star joins?

5,086

Jag Singh

06/28/2007 04:23AM

Re: Star joins?

2,572

Peter Welker

12/09/2006 06:25AM

Re: Star joins?

2,551

Jay Pipes

01/22/2006 03:22PM

Re: Star joins?

2,672

Jay Pipes

01/18/2006 10:39PM

Re: Star joins?

2,576

Jay Pipes

01/18/2006 10:41PM

Re: Star joins?

2,526

Seth Grimes

01/20/2006 03:08PM

Re: Star joins?

2,652

Jay Pipes

01/20/2006 06:42PM

how to store 10GB data in a table(using mysql 5.0.24).

4,383

justin jose

05/02/2007 10:39PM

Re: how to store 10GB data in a table(using mysql 5.0.24).

3,045

Olexandr Novosad

05/26/2007 03:45AM

Re: how to store 10GB data in a table(using mysql 5.0.24).

2,549

Peter Steiner

06/25/2007 07:45AM

Re: how to store 10GB data in a table(using mysql 5.0.24).

2,627

KimSeong Loh

05/27/2007 03:00AM

How to optimize this trigger?

4,776

li grewat

06/21/2007 08:18PM

Re: How to optimize this trigger?

2,379

KimSeong Loh

06/22/2007 05:49AM

Re: How to optimize this trigger?

2,348

li grewat

06/24/2007 06:22PM

Please help:The performance of before insert trigger and after insert trigger?

2,987

li grewat

06/23/2007 06:40AM

Pages:

« 1

...

12 13 14 15 16

...

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.