MySQL :: MySQL Forums :: Optimizer & Parser

Announcements	Last Post
• Announcing January 2026 Releases featuring MySQL Server 9.6.0 Innovation, 8.4.8 LTS and 8.0.45	01/23/2026 11:56AM

New Topic

Pages:

« 1

...

12 13 14 15 16

...

19 »

Subject

Views

Written By

Posted

Estimating query results quantity

3,224

Andrey M

12/18/2007 08:25AM

Indexes won't work if using DISTINCT

3,457

Andrey M

12/18/2007 08:06AM

How MySQL Handles ORDER BY, GROUP BY, and DISTINCT

4,056

Edwin DeSouza

12/07/2007 04:28PM

Anchor Modeling

4,331

Lars Rönnbäck

12/07/2007 07:35AM

How to optimise a query to avoid filesort on LARGE resultset

5,426

Marek Narkiewicz

11/26/2007 10:54AM

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

2,929

Marek Narkiewicz

11/27/2007 03:47AM

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

4,590

Faury Rodriguez

11/26/2007 03:36PM

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

3,251

KimSeong Loh

11/26/2007 03:36PM

Big tables and dates

4,362

Benjamin Fonze

11/20/2007 06:04PM

Re: Big tables and dates

2,476

KimSeong Loh

11/21/2007 02:02AM

Does MySQL support function based index on datetime column?

13,944

Sailesh Patel

09/06/2007 03:34PM

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

5,553

Benjamin Fonze

11/20/2007 06:07PM

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

6,958

KimSeong Loh

09/06/2007 06:25PM

select won't use index

4,449

damage damage

11/20/2007 02:31AM

Re: select won't use index

2,519

KimSeong Loh

11/20/2007 04:00PM

Want ORDER BY to use indexed portion of long text field

6,676

Bob Fitterman

10/13/2007 07:03AM

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

2,750

KimSeong Loh

11/15/2007 03:51PM

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

2,886

Chris Schneider

10/24/2007 03:06PM

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

3,047

Bob Fitterman

11/15/2007 09:20AM

optimze for a mysql server - my.cnf

5,041

kean galileo

11/06/2007 06:26PM

Making the EXPLAIN EXTENDED query runnable

3,801

Niklas Saers

10/31/2007 07:07AM

closing DB policy

3,396

Danny Jaworski

10/30/2007 02:52AM

inner join on key does full table scan anyway

7,445

Doug Perham

10/26/2007 06:34AM

Re: inner join on key does full table scan anyway

3,505

Chris Schneider

10/26/2007 01:21PM

Priority & Timeout

5,866

Jonathan Isaac

08/20/2007 11:36AM

Re: Priority & Timeout

3,384

Chris Schneider

10/24/2007 03:12PM

Problem with result field list

3,641

Adrian Chapela Cordeiro

10/02/2007 10:40AM

Re: Problem with result field list

2,280

Chris Schneider

10/24/2007 02:54PM

Aggregate function optimization for same column in same record

4,215

Nathan Alden

10/07/2007 10:30PM

ORDER BY ... LIMIT

4,135

Ed Mazur

09/27/2007 11:24AM

Re: ORDER BY ... LIMIT

2,634

KimSeong Loh

09/27/2007 05:07PM

How to speed up my DB

3,276

Venkateswaran Nagarajan

09/21/2007 09:05PM

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

3,626

Venkateswaran Nagarajan

09/21/2007 08:56PM

multiple index is used only partially

4,666

Miguel Balsevich

09/08/2007 03:37PM

Re: multiple index is used only partially

2,720

Miguel Balsevich

09/11/2007 08:04AM

Using FileSort

4,671

Clement Ho

09/10/2007 05:21PM

Help join optimisation

3,534

Catia Lavalle

09/05/2007 05:41AM

Can I speed this up?

5,611

Eljakim Schrijvers

02/17/2007 11:18AM

Re: Can I speed this up?

2,921

Adrian Chapela Cordeiro

08/30/2007 02:55AM

Re: Can I speed this up?

3,042

KimSeong Loh

02/25/2007 11:40PM

Re: Can I speed this up?

3,123

Eljakim Schrijvers

03/10/2007 01:23PM

Re: Can I speed this up?

2,967

KimSeong Loh

03/11/2007 12:59AM

Re: Can I speed this up?

2,962

Dian Kresno

04/26/2007 01:04AM

Re: Can I speed this up?

3,206

Eljakim Schrijvers

02/17/2007 11:23AM

time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables

5,563

Jan Theodore Galkowski

06/27/2007 08:52AM

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

3,297

Adrian Chapela Cordeiro

08/30/2007 02:13AM

LEFT JOIN Optimization

8,069

Ram R

08/21/2007 03:04PM

Re: LEFT JOIN Optimization

3,937

KimSeong Loh

08/21/2007 06:45PM

Re: LEFT JOIN Optimization

3,174

Adrian Chapela Cordeiro

08/29/2007 03:55AM

Re: LEFT JOIN Optimization

3,500

Ram R

08/21/2007 11:32PM

Re: LEFT JOIN Optimization

3,432

KimSeong Loh

08/29/2007 07:19PM

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

7,983

Raman Singh

08/12/2007 12:48AM

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

2,908

Adrian Chapela Cordeiro

08/29/2007 04:50AM

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

2,935

KimSeong Loh

08/12/2007 05:17PM

Optimized query still way too slow

4,072

Brad Douglas

08/13/2007 04:54PM

Speed up query execution with 30Million rows

7,413

Vibhu Bansal

08/09/2007 06:40AM

Re: Speed up query execution with 30Million rows

3,527

Yogesh Salvi

08/13/2007 05:46AM

How to optimize this query?

4,608

Kwang Chin Lee

06/20/2007 07:38AM

Re: How to optimize this query?

2,410

Yogesh Salvi

08/13/2007 05:43AM

How to stop temporary table in this query

4,090

Mike Zupan

08/09/2007 11:19AM

Indexing table takes 4 hours

3,180

Francisco Cha

08/08/2007 03:11PM

Help requested optimising query with subquery

3,410

Christian Seaman

08/08/2007 06:21AM

Re: Help requested optimising query with subquery

2,280

KimSeong Loh

08/08/2007 07:01AM

Need some help to optimize a query with multiple JOIN

6,829

Jean-Baptiste ANNE

07/30/2007 01:42PM

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

3,011

Sergey Belov

07/31/2007 05:55AM

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

2,879

Jean-Baptiste ANNE

07/31/2007 10:20AM

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

2,850

Sergey Belov

08/01/2007 01:12AM

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

3,018

Jean-Baptiste ANNE

08/01/2007 07:58AM

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

3,066

KimSeong Loh

08/05/2007 01:03AM

why does explain plan change?

12,156

charlie w

07/30/2007 10:14AM

Re: why does explain plan change?

3,394

Fabio Sgamo

08/03/2007 05:22AM

Problem with optimization of a WHERE clause

3,896

Giorgio Calderone

08/02/2007 12:41PM

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

3,527

Sergey Belov

07/23/2007 02:03PM

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

2,370

KimSeong Loh

07/23/2007 07:21PM

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

2,447

Sergey Belov

07/24/2007 12:26AM

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

2,257

KimSeong Loh

07/24/2007 02:08AM

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

2,496

Sergey Belov

07/24/2007 02:42AM

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

2,221

KimSeong Loh

07/24/2007 06:02PM

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

2,322

Sergey Belov

07/25/2007 11:10PM

Optimizing a search query

3,071

Staffan S

07/25/2007 03:58AM

Index evaluation

3,551

Drei Bit

07/23/2007 04:51PM

Re: Index evaluation

2,391

KimSeong Loh

07/23/2007 07:27PM

Re: Index evaluation

2,327

Drei Bit

07/24/2007 05:24AM

Re: Index evaluation

2,416

Drei Bit

07/23/2007 05:18PM

Re: Index evaluation

2,362

KimSeong Loh

07/24/2007 02:06AM

Re: Index evaluation

2,374

Drei Bit

07/24/2007 04:33AM

Profiling only works in MySQL 5.0.37?

4,273

Suave Su

07/19/2007 12:22AM

Re: Profiling only works in MySQL 5.0.37?

2,522

KimSeong Loh

07/19/2007 05:02AM

Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

5,805

Drei Bit

07/03/2007 05:37PM

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

2,700

KimSeong Loh

07/04/2007 06:45AM

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

2,580

Drei Bit

07/04/2007 10:49AM

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

2,642

KimSeong Loh

07/05/2007 01:14AM

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

2,538

Drei Bit

07/05/2007 03:22AM

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

2,613

KimSeong Loh

07/05/2007 03:16PM

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

2,547

Drei Bit

07/10/2007 09:37AM

join order when using order by

6,661

Christopher Cudennec

07/09/2007 07:54AM

default order by

5,040

Joel Webb

07/06/2007 08:49AM

Cost Model Information

3,256

Drei Bit

07/05/2007 03:26AM

Optimizer misbehaves

3,537

Drei Bit

07/04/2007 05:16AM

Re: Optimizer misbehaves

2,444

KimSeong Loh

07/04/2007 07:26AM

Re: Optimizer misbehaves

2,452

Drei Bit

07/04/2007 10:37AM

Variable where index optimizing

3,094

alex jordanov

06/29/2007 04:37AM

How to optimize this program? Thanks

2,973

li grewat

06/28/2007 08:31PM

Star joins?

3,517

Seth Grimes

01/17/2006 08:57PM

Re: Star joins?

2,509

Seth Grimes

01/26/2006 11:35AM

Re: Star joins?

2,622

Jay Pipes

01/26/2006 01:00PM

Re: Star joins?

2,461

Seth Grimes

01/21/2006 07:32PM

Re: Star joins?

3,592

Timour Katchaounov

01/23/2006 04:10PM

Re: Star joins?

5,032

Jag Singh

06/28/2007 04:23AM

Re: Star joins?

2,540

Peter Welker

12/09/2006 06:25AM

Re: Star joins?

2,501

Jay Pipes

01/22/2006 03:22PM

Re: Star joins?

2,635

Jay Pipes

01/18/2006 10:39PM

Re: Star joins?

2,521

Jay Pipes

01/18/2006 10:41PM

Re: Star joins?

2,496

Seth Grimes

01/20/2006 03:08PM

Re: Star joins?

2,611

Jay Pipes

01/20/2006 06:42PM

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

4,313

justin jose

05/02/2007 10:39PM

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

3,011

Olexandr Novosad

05/26/2007 03:45AM

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

2,508

Peter Steiner

06/25/2007 07:45AM

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

2,600

KimSeong Loh

05/27/2007 03:00AM

How to optimize this trigger?

4,711

li grewat

06/21/2007 08:18PM

Re: How to optimize this trigger?

2,345

KimSeong Loh

06/22/2007 05:49AM

Re: How to optimize this trigger?

2,320

li grewat

06/24/2007 06:22PM

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

2,922

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.