MySQL :: MySQL Forums :: Optimizer & Parser

New Topic

Pages:

« 1

...

12 13 14 15 16

...

19 »

Subject

Views

Written By

Posted

Estimating query results quantity

3,022

Andrey M

12/18/2007 08:25AM

Indexes won't work if using DISTINCT

3,244

Andrey M

12/18/2007 08:06AM

How MySQL Handles ORDER BY, GROUP BY, and DISTINCT

3,842

Edwin DeSouza

12/07/2007 04:28PM

Anchor Modeling

4,067

Lars Rönnbäck

12/07/2007 07:35AM

How to optimise a query to avoid filesort on LARGE resultset

5,235

Marek Narkiewicz

11/26/2007 10:54AM

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

2,824

Marek Narkiewicz

11/27/2007 03:47AM

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

4,480

Faury Rodriguez

11/26/2007 03:36PM

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

3,143

KimSeong Loh

11/26/2007 03:36PM

Big tables and dates

4,123

Benjamin Fonze

11/20/2007 06:04PM

Re: Big tables and dates

2,351

KimSeong Loh

11/21/2007 02:02AM

Does MySQL support function based index on datetime column?

13,661

Sailesh Patel

09/06/2007 03:34PM

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

5,419

Benjamin Fonze

11/20/2007 06:07PM

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

6,854

KimSeong Loh

09/06/2007 06:25PM

select won't use index

4,195

damage damage

11/20/2007 02:31AM

Re: select won't use index

2,397

KimSeong Loh

11/20/2007 04:00PM

Want ORDER BY to use indexed portion of long text field

6,382

Bob Fitterman

10/13/2007 07:03AM

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

2,618

KimSeong Loh

11/15/2007 03:51PM

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

2,763

Chris Schneider

10/24/2007 03:06PM

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

2,893

Bob Fitterman

11/15/2007 09:20AM

optimze for a mysql server - my.cnf

4,837

kean galileo

11/06/2007 06:26PM

Making the EXPLAIN EXTENDED query runnable

3,589

Niklas Saers

10/31/2007 07:07AM

closing DB policy

3,161

Danny Jaworski

10/30/2007 02:52AM

inner join on key does full table scan anyway

7,018

Doug Perham

10/26/2007 06:34AM

Re: inner join on key does full table scan anyway

3,320

Chris Schneider

10/26/2007 01:21PM

Priority & Timeout

5,611

Jonathan Isaac

08/20/2007 11:36AM

Re: Priority & Timeout

3,245

Chris Schneider

10/24/2007 03:12PM

Problem with result field list

3,410

Adrian Chapela Cordeiro

10/02/2007 10:40AM

Re: Problem with result field list

2,165

Chris Schneider

10/24/2007 02:54PM

Aggregate function optimization for same column in same record

4,012

Nathan Alden

10/07/2007 10:30PM

ORDER BY ... LIMIT

3,901

Ed Mazur

09/27/2007 11:24AM

Re: ORDER BY ... LIMIT

2,487

KimSeong Loh

09/27/2007 05:07PM

How to speed up my DB

3,060

Venkateswaran Nagarajan

09/21/2007 09:05PM

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

3,439

Venkateswaran Nagarajan

09/21/2007 08:56PM

multiple index is used only partially

4,448

Miguel Balsevich

09/08/2007 03:37PM

Re: multiple index is used only partially

2,605

Miguel Balsevich

09/11/2007 08:04AM

Using FileSort

4,413

Clement Ho

09/10/2007 05:21PM

Help join optimisation

3,307

Catia Lavalle

09/05/2007 05:41AM

Can I speed this up?

5,372

Eljakim Schrijvers

02/17/2007 11:18AM

Re: Can I speed this up?

2,802

Adrian Chapela Cordeiro

08/30/2007 02:55AM

Re: Can I speed this up?

2,921

KimSeong Loh

02/25/2007 11:40PM

Re: Can I speed this up?

3,001

Eljakim Schrijvers

03/10/2007 01:23PM

Re: Can I speed this up?

2,874

KimSeong Loh

03/11/2007 12:59AM

Re: Can I speed this up?

2,846

Dian Kresno

04/26/2007 01:04AM

Re: Can I speed this up?

3,106

Eljakim Schrijvers

02/17/2007 11:23AM

time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables

5,359

Jan Theodore Galkowski

06/27/2007 08:52AM

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

3,180

Adrian Chapela Cordeiro

08/30/2007 02:13AM

LEFT JOIN Optimization

7,814

Ram R

08/21/2007 03:04PM

Re: LEFT JOIN Optimization

3,824

KimSeong Loh

08/21/2007 06:45PM

Re: LEFT JOIN Optimization

3,083

Adrian Chapela Cordeiro

08/29/2007 03:55AM

Re: LEFT JOIN Optimization

3,380

Ram R

08/21/2007 11:32PM

Re: LEFT JOIN Optimization

3,324

KimSeong Loh

08/29/2007 07:19PM

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

7,743

Raman Singh

08/12/2007 12:48AM

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

2,792

Adrian Chapela Cordeiro

08/29/2007 04:50AM

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

2,826

KimSeong Loh

08/12/2007 05:17PM

Optimized query still way too slow

3,840

Brad Douglas

08/13/2007 04:54PM

Speed up query execution with 30Million rows

7,133

Vibhu Bansal

08/09/2007 06:40AM

Re: Speed up query execution with 30Million rows

3,400

Yogesh Salvi

08/13/2007 05:46AM

How to optimize this query?

4,407

Kwang Chin Lee

06/20/2007 07:38AM

Re: How to optimize this query?

2,296

Yogesh Salvi

08/13/2007 05:43AM

How to stop temporary table in this query

3,880

Mike Zupan

08/09/2007 11:19AM

Indexing table takes 4 hours

2,986

Francisco Cha

08/08/2007 03:11PM

Help requested optimising query with subquery

3,180

Christian Seaman

08/08/2007 06:21AM

Re: Help requested optimising query with subquery

2,178

KimSeong Loh

08/08/2007 07:01AM

Need some help to optimize a query with multiple JOIN

6,602

Jean-Baptiste ANNE

07/30/2007 01:42PM

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

2,892

Sergey Belov

07/31/2007 05:55AM

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

2,783

Jean-Baptiste ANNE

07/31/2007 10:20AM

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

2,766

Sergey Belov

08/01/2007 01:12AM

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

2,913

Jean-Baptiste ANNE

08/01/2007 07:58AM

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

2,971

KimSeong Loh

08/05/2007 01:03AM

why does explain plan change?

11,931

charlie w

07/30/2007 10:14AM

Re: why does explain plan change?

3,270

Fabio Sgamo

08/03/2007 05:22AM

Problem with optimization of a WHERE clause

3,688

Giorgio Calderone

08/02/2007 12:41PM

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

3,308

Sergey Belov

07/23/2007 02:03PM

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

2,260

KimSeong Loh

07/23/2007 07:21PM

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

2,341

Sergey Belov

07/24/2007 12:26AM

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

2,155

KimSeong Loh

07/24/2007 02:08AM

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

2,371

Sergey Belov

07/24/2007 02:42AM

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

2,107

KimSeong Loh

07/24/2007 06:02PM

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

2,218

Sergey Belov

07/25/2007 11:10PM

Optimizing a search query

2,884

Staffan S

07/25/2007 03:58AM

Index evaluation

3,336

Drei Bit

07/23/2007 04:51PM

Re: Index evaluation

2,280

KimSeong Loh

07/23/2007 07:27PM

Re: Index evaluation

2,240

Drei Bit

07/24/2007 05:24AM

Re: Index evaluation

2,306

Drei Bit

07/23/2007 05:18PM

Re: Index evaluation

2,255

KimSeong Loh

07/24/2007 02:06AM

Re: Index evaluation

2,252

Drei Bit

07/24/2007 04:33AM

Profiling only works in MySQL 5.0.37?

4,073

Suave Su

07/19/2007 12:22AM

Re: Profiling only works in MySQL 5.0.37?

2,427

KimSeong Loh

07/19/2007 05:02AM

Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]

5,557

Drei Bit

07/03/2007 05:37PM

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

2,556

KimSeong Loh

07/04/2007 06:45AM

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

2,464

Drei Bit

07/04/2007 10:49AM

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

2,512

KimSeong Loh

07/05/2007 01:14AM

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

2,420

Drei Bit

07/05/2007 03:22AM

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

2,501

KimSeong Loh

07/05/2007 03:16PM

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

2,433

Drei Bit

07/10/2007 09:37AM

join order when using order by

6,420

Christopher Cudennec

07/09/2007 07:54AM

default order by

4,780

Joel Webb

07/06/2007 08:49AM

Cost Model Information

3,089

Drei Bit

07/05/2007 03:26AM

Optimizer misbehaves

3,291

Drei Bit

07/04/2007 05:16AM

Re: Optimizer misbehaves

2,321

KimSeong Loh

07/04/2007 07:26AM

Re: Optimizer misbehaves

2,339

Drei Bit

07/04/2007 10:37AM

Variable where index optimizing

2,887

alex jordanov

06/29/2007 04:37AM

How to optimize this program? Thanks

2,740

li grewat

06/28/2007 08:31PM

Star joins?

3,247

Seth Grimes

01/17/2006 08:57PM

Re: Star joins?

2,383

Seth Grimes

01/26/2006 11:35AM

Re: Star joins?

2,468

Jay Pipes

01/26/2006 01:00PM

Re: Star joins?

2,338

Seth Grimes

01/21/2006 07:32PM

Re: Star joins?

3,442

Timour Katchaounov

01/23/2006 04:10PM

Re: Star joins?

4,879

Jag Singh

06/28/2007 04:23AM

Re: Star joins?

2,425

Peter Welker

12/09/2006 06:25AM

Re: Star joins?

2,361

Jay Pipes

01/22/2006 03:22PM

Re: Star joins?

2,510

Jay Pipes

01/18/2006 10:39PM

Re: Star joins?

2,385

Jay Pipes

01/18/2006 10:41PM

Re: Star joins?

2,360

Seth Grimes

01/20/2006 03:08PM

Re: Star joins?

2,473

Jay Pipes

01/20/2006 06:42PM

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

4,059

justin jose

05/02/2007 10:39PM

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

2,887

Olexandr Novosad

05/26/2007 03:45AM

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

2,376

Peter Steiner

06/25/2007 07:45AM

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

2,481

KimSeong Loh

05/27/2007 03:00AM

How to optimize this trigger?

4,499

li grewat

06/21/2007 08:18PM

Re: How to optimize this trigger?

2,225

KimSeong Loh

06/22/2007 05:49AM

Re: How to optimize this trigger?

2,197

li grewat

06/24/2007 06:22PM

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

2,690

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.