MySQL :: MySQL Forums :: Optimizer & Parser

Announcements	Last Post
• Announcing a new webcast video that completes a deep dive into how to download and use Enterprise Manager for MySQL	04/04/2024 03:01PM

New Topic

Pages:

« 1

...

12 13 14 15 16

...

19 »

Subject

Views

Written By

Posted

Estimating query results quantity

2,993

Andrey M

12/18/2007 08:25AM

Indexes won't work if using DISTINCT

3,210

Andrey M

12/18/2007 08:06AM

How MySQL Handles ORDER BY, GROUP BY, and DISTINCT

3,807

Edwin DeSouza

12/07/2007 04:28PM

Anchor Modeling

4,020

Lars Rönnbäck

12/07/2007 07:35AM

How to optimise a query to avoid filesort on LARGE resultset

5,200

Marek Narkiewicz

11/26/2007 10:54AM

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

2,807

Marek Narkiewicz

11/27/2007 03:47AM

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

4,467

Faury Rodriguez

11/26/2007 03:36PM

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

3,119

KimSeong Loh

11/26/2007 03:36PM

Big tables and dates

4,091

Benjamin Fonze

11/20/2007 06:04PM

Re: Big tables and dates

2,340

KimSeong Loh

11/21/2007 02:02AM

Does MySQL support function based index on datetime column?

13,613

Sailesh Patel

09/06/2007 03:34PM

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

5,404

Benjamin Fonze

11/20/2007 06:07PM

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

6,839

KimSeong Loh

09/06/2007 06:25PM

select won't use index

4,147

damage damage

11/20/2007 02:31AM

Re: select won't use index

2,380

KimSeong Loh

11/20/2007 04:00PM

Want ORDER BY to use indexed portion of long text field

6,339

Bob Fitterman

10/13/2007 07:03AM

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

2,598

KimSeong Loh

11/15/2007 03:51PM

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

2,746

Chris Schneider

10/24/2007 03:06PM

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

2,878

Bob Fitterman

11/15/2007 09:20AM

optimze for a mysql server - my.cnf

4,793

kean galileo

11/06/2007 06:26PM

Making the EXPLAIN EXTENDED query runnable

3,534

Niklas Saers

10/31/2007 07:07AM

closing DB policy

3,109

Danny Jaworski

10/30/2007 02:52AM

inner join on key does full table scan anyway

6,866

Doug Perham

10/26/2007 06:34AM

Re: inner join on key does full table scan anyway

3,278

Chris Schneider

10/26/2007 01:21PM

Priority & Timeout

5,556

Jonathan Isaac

08/20/2007 11:36AM

Re: Priority & Timeout

3,224

Chris Schneider

10/24/2007 03:12PM

Problem with result field list

3,373

Adrian Chapela Cordeiro

10/02/2007 10:40AM

Re: Problem with result field list

2,144

Chris Schneider

10/24/2007 02:54PM

Aggregate function optimization for same column in same record

3,980

Nathan Alden

10/07/2007 10:30PM

ORDER BY ... LIMIT

3,860

Ed Mazur

09/27/2007 11:24AM

Re: ORDER BY ... LIMIT

2,463

KimSeong Loh

09/27/2007 05:07PM

How to speed up my DB

3,021

Venkateswaran Nagarajan

09/21/2007 09:05PM

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

3,404

Venkateswaran Nagarajan

09/21/2007 08:56PM

multiple index is used only partially

4,407

Miguel Balsevich

09/08/2007 03:37PM

Re: multiple index is used only partially

2,583

Miguel Balsevich

09/11/2007 08:04AM

Using FileSort

4,364

Clement Ho

09/10/2007 05:21PM

Help join optimisation

3,257

Catia Lavalle

09/05/2007 05:41AM

Can I speed this up?

5,331

Eljakim Schrijvers

02/17/2007 11:18AM

Re: Can I speed this up?

2,792

Adrian Chapela Cordeiro

08/30/2007 02:55AM

Re: Can I speed this up?

2,910

KimSeong Loh

02/25/2007 11:40PM

Re: Can I speed this up?

2,988

Eljakim Schrijvers

03/10/2007 01:23PM

Re: Can I speed this up?

2,861

KimSeong Loh

03/11/2007 12:59AM

Re: Can I speed this up?

2,831

Dian Kresno

04/26/2007 01:04AM

Re: Can I speed this up?

3,090

Eljakim Schrijvers

02/17/2007 11:23AM

time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables

5,321

Jan Theodore Galkowski

06/27/2007 08:52AM

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

3,171

Adrian Chapela Cordeiro

08/30/2007 02:13AM

LEFT JOIN Optimization

7,778

Ram R

08/21/2007 03:04PM

Re: LEFT JOIN Optimization

3,811

KimSeong Loh

08/21/2007 06:45PM

Re: LEFT JOIN Optimization

3,071

Adrian Chapela Cordeiro

08/29/2007 03:55AM

Re: LEFT JOIN Optimization

3,360

Ram R

08/21/2007 11:32PM

Re: LEFT JOIN Optimization

3,308

KimSeong Loh

08/29/2007 07:19PM

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

7,697

Raman Singh

08/12/2007 12:48AM

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

2,770

Adrian Chapela Cordeiro

08/29/2007 04:50AM

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

2,811

KimSeong Loh

08/12/2007 05:17PM

Optimized query still way too slow

3,798

Brad Douglas

08/13/2007 04:54PM

Speed up query execution with 30Million rows

7,086

Vibhu Bansal

08/09/2007 06:40AM

Re: Speed up query execution with 30Million rows

3,383

Yogesh Salvi

08/13/2007 05:46AM

How to optimize this query?

4,374

Kwang Chin Lee

06/20/2007 07:38AM

Re: How to optimize this query?

2,279

Yogesh Salvi

08/13/2007 05:43AM

How to stop temporary table in this query

3,844

Mike Zupan

08/09/2007 11:19AM

Indexing table takes 4 hours

2,961

Francisco Cha

08/08/2007 03:11PM

Help requested optimising query with subquery

3,149

Christian Seaman

08/08/2007 06:21AM

Re: Help requested optimising query with subquery

2,163

KimSeong Loh

08/08/2007 07:01AM

Need some help to optimize a query with multiple JOIN

6,565

Jean-Baptiste ANNE

07/30/2007 01:42PM

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

2,877

Sergey Belov

07/31/2007 05:55AM

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

2,771

Jean-Baptiste ANNE

07/31/2007 10:20AM

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

2,753

Sergey Belov

08/01/2007 01:12AM

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

2,899

Jean-Baptiste ANNE

08/01/2007 07:58AM

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

2,956

KimSeong Loh

08/05/2007 01:03AM

why does explain plan change?

11,908

charlie w

07/30/2007 10:14AM

Re: why does explain plan change?

3,258

Fabio Sgamo

08/03/2007 05:22AM

Problem with optimization of a WHERE clause

3,657

Giorgio Calderone

08/02/2007 12:41PM

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

3,286

Sergey Belov

07/23/2007 02:03PM

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

2,249

KimSeong Loh

07/23/2007 07:21PM

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

2,331

Sergey Belov

07/24/2007 12:26AM

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

2,142

KimSeong Loh

07/24/2007 02:08AM

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

2,360

Sergey Belov

07/24/2007 02:42AM

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

2,089

KimSeong Loh

07/24/2007 06:02PM

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

2,206

Sergey Belov

07/25/2007 11:10PM

Optimizing a search query

2,855

Staffan S

07/25/2007 03:58AM

Index evaluation

3,299

Drei Bit

07/23/2007 04:51PM

Re: Index evaluation

2,266

KimSeong Loh

07/23/2007 07:27PM

Re: Index evaluation

2,222

Drei Bit

07/24/2007 05:24AM

Re: Index evaluation

2,282

Drei Bit

07/23/2007 05:18PM

Re: Index evaluation

2,240

KimSeong Loh

07/24/2007 02:06AM

Re: Index evaluation

2,239

Drei Bit

07/24/2007 04:33AM

Profiling only works in MySQL 5.0.37?

4,043

Suave Su

07/19/2007 12:22AM

Re: Profiling only works in MySQL 5.0.37?

2,414

KimSeong Loh

07/19/2007 05:02AM

Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

5,523

Drei Bit

07/03/2007 05:37PM

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

2,544

KimSeong Loh

07/04/2007 06:45AM

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

2,453

Drei Bit

07/04/2007 10:49AM

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

2,500

KimSeong Loh

07/05/2007 01:14AM

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

2,409

Drei Bit

07/05/2007 03:22AM

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

2,487

KimSeong Loh

07/05/2007 03:16PM

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

2,410

Drei Bit

07/10/2007 09:37AM

join order when using order by

6,382

Christopher Cudennec

07/09/2007 07:54AM

default order by

4,744

Joel Webb

07/06/2007 08:49AM

Cost Model Information

3,063

Drei Bit

07/05/2007 03:26AM

Optimizer misbehaves

3,248

Drei Bit

07/04/2007 05:16AM

Re: Optimizer misbehaves

2,304

KimSeong Loh

07/04/2007 07:26AM

Re: Optimizer misbehaves

2,322

Drei Bit

07/04/2007 10:37AM

Variable where index optimizing

2,848

alex jordanov

06/29/2007 04:37AM

How to optimize this program? Thanks

2,690

li grewat

06/28/2007 08:31PM

Star joins?

3,203

Seth Grimes

01/17/2006 08:57PM

Re: Star joins?

2,359

Seth Grimes

01/26/2006 11:35AM

Re: Star joins?

2,435

Jay Pipes

01/26/2006 01:00PM

Re: Star joins?

2,318

Seth Grimes

01/21/2006 07:32PM

Re: Star joins?

3,409

Timour Katchaounov

01/23/2006 04:10PM

Re: Star joins?

4,851

Jag Singh

06/28/2007 04:23AM

Re: Star joins?

2,410

Peter Welker

12/09/2006 06:25AM

Re: Star joins?

2,339

Jay Pipes

01/22/2006 03:22PM

Re: Star joins?

2,475

Jay Pipes

01/18/2006 10:39PM

Re: Star joins?

2,365

Jay Pipes

01/18/2006 10:41PM

Re: Star joins?

2,339

Seth Grimes

01/20/2006 03:08PM

Re: Star joins?

2,458

Jay Pipes

01/20/2006 06:42PM

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

4,015

justin jose

05/02/2007 10:39PM

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

2,861

Olexandr Novosad

05/26/2007 03:45AM

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

2,357

Peter Steiner

06/25/2007 07:45AM

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

2,465

KimSeong Loh

05/27/2007 03:00AM

How to optimize this trigger?

4,460

li grewat

06/21/2007 08:18PM

Re: How to optimize this trigger?

2,209

KimSeong Loh

06/22/2007 05:49AM

Re: How to optimize this trigger?

2,180

li grewat

06/24/2007 06:22PM

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

2,653

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.