MySQL :: MySQL Forums :: Optimizer & Parser

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Pages:

« 1

...

14 15 16 17 18

...

19 »

Subject

Views

Written By

Posted

improving speed of mysql distance filter

9,086

aubrey falconer

05/19/2006 05:27PM

Re: improving speed of mysql distance filter

3,463

Peter Brawley

06/29/2006 07:54PM

Re: improving speed of mysql distance filter

3,003

Joost

06/28/2006 11:27AM

Re: improving speed of mysql distance filter

3,185

Bob Field

06/17/2006 03:12PM

Re: improving speed of mysql distance filter

4,511

Joost

06/28/2006 01:40AM

Re: improving speed of mysql distance filter

5,179

John Campbell

10/05/2006 09:56AM

Re: improving speed of mysql distance filter

3,229

aubrey falconer

06/17/2006 02:52PM

strange query performance

2,715

Eugene G

10/01/2006 08:56AM

Re: strange query performance

1,791

Eugene G

10/01/2006 11:56AM

Re: strange query performance

1,810

Toa Sty

10/03/2006 02:43AM

ORDER BY doesn't use index

11,752

Frederic Giudicelli

09/13/2006 12:32AM

Re: ORDER BY doesn't use index

3,716

KimSeong Loh

09/13/2006 02:36AM

Re: ORDER BY doesn't use index

3,350

Frederic Giudicelli

09/27/2006 03:39AM

Re: ORDER BY doesn't use index

3,204

Toa Sty

09/27/2006 05:02AM

Re: ORDER BY doesn't use index

3,110

Frederic Giudicelli

09/30/2006 05:53PM

Re: ORDER BY doesn't use index

3,107

Toa Sty

10/03/2006 02:38AM

Re: ORDER BY doesn't use index

5,203

Toa Sty

09/13/2006 02:00AM

Optimizing left outer join query

13,783

Muhammad Imran Khalid

09/24/2006 11:40PM

Re: Optimizing left outer join query

4,566

Toa Sty

09/25/2006 03:00AM

Re: Optimizing left outer join query

4,037

Muhammad Imran Khalid

09/25/2006 04:54AM

Re: Optimizing left outer join query

4,230

Toa Sty

09/25/2006 08:09AM

Re: Optimizing left outer join query

3,567

KimSeong Loh

09/25/2006 09:55PM

Re: Optimizing left outer join query

3,393

Toa Sty

09/26/2006 03:35AM

Re: Optimizing left outer join query

2,950

KimSeong Loh

09/26/2006 06:31PM

Re: Optimizing left outer join query

3,063

Muhammad Imran Khalid

09/26/2006 03:46AM

Re: Optimizing left outer join query

4,790

Toa Sty

09/26/2006 04:06AM

Optimizer discssion - sequence of tables VS Straight_Join?

2,451

J Jorgenson

09/26/2006 03:24PM

MySQL can't find index = really slow query...

3,748

Alessio Pianigiani

09/25/2006 05:53AM

Re: MySQL can't find index = really slow query...

1,717

Bob Field

09/25/2006 08:49AM

Re: MySQL can't find index = really slow query...

1,736

Alessio Pianigiani

09/25/2006 09:06AM

Re: MySQL can't find index = really slow query...

2,101

Bob Field

09/25/2006 09:23AM

Re: MySQL can't find index = really slow query...

1,882

Alessio Pianigiani

09/25/2006 09:47AM

Re: MySQL can't find index = really slow query...

1,669

Bob Field

09/25/2006 09:55AM

Re: MySQL can't find index = really slow query...

1,811

Alessio Pianigiani

09/25/2006 10:14AM

Re: MySQL can't find index = really slow query...

1,909

Bob Field

09/25/2006 12:47PM

Re: MySQL can't find index = really slow query...

1,687

Alessio Pianigiani

09/26/2006 04:31AM

does MySQL support function index?

4,674

lei liang

09/21/2006 06:56PM

Re: does MySQL support function index?

4,686

KimSeong Loh

09/21/2006 10:14PM

index choose and analyze table

3,023

Jens Schanz

09/11/2006 04:37AM

Re: index choose and analyze table

2,380

Toa Sty

09/14/2006 08:25AM

Re: index choose and analyze table

10,396

Toa Sty

09/14/2006 10:38AM

Re: index choose and analyze table

3,075

Jens Schanz

09/19/2006 04:34AM

Two nearly equal querys, but very different performance

2,652

Sven Markwart

09/12/2006 08:54AM

Re: Two nearly equal querys, but very different performance

1,686

Toa Sty

09/12/2006 09:34AM

sometimes, mysql don't use an existing index

5,922

Bart Peeters

09/04/2006 12:17PM

Re: sometimes, mysql don't use an existing index

2,655

Toa Sty

09/11/2006 06:29AM

slow corelated subquery, not sure how to rewrite

3,273

Tait Larson

09/01/2006 06:42PM

Re: slow corelated subquery, not sure how to rewrite

1,879

Tait Larson

09/03/2006 12:00AM

Re: slow corelated subquery, not sure how to rewrite

1,737

KimSeong Loh

09/10/2006 10:18PM

best way to create 'next' and 'previous' text

2,405

Johannes Fosseus

09/10/2006 01:53AM

Re: best way to create 'next' and 'previous' text

1,480

Bob Field

09/10/2006 09:01AM

Best index for my table

2,983

Johannes Fosseus

09/09/2006 01:01AM

Re: Best index for my table

1,692

Bob Field

09/09/2006 02:01PM

Re: Best index for my table

1,635

Johannes Fosseus

09/10/2006 12:37AM

Why do mysql use temporary and filesort here?

3,083

Johannes Fosseus

09/08/2006 04:50AM

Re: Why do mysql use temporary and filesort here?

2,049

Björn Steinbrink

09/08/2006 06:36AM

slow selects

2,538

Danie Van der Walt

08/31/2006 08:02AM

Re: slow selects

1,756

Toa Sty

08/31/2006 08:43AM

Re: slow selects

1,757

Danie Van der Walt

08/31/2006 09:06AM

Re: slow selects

1,758

Toa Sty

09/01/2006 03:04AM

Re: slow selects

1,719

Danie Van der Walt

09/01/2006 04:17AM

Re: slow selects

1,937

Toa Sty

09/01/2006 04:50AM

Re: slow selects

1,728

Danie Van der Walt

09/01/2006 07:24AM

Re: slow selects

1,752

Toa Sty

09/01/2006 08:16AM

Re: slow selects

1,761

Danie Van der Walt

09/02/2006 12:52PM

Query Optimization

2,483

Will Buckner

08/21/2006 11:05AM

Re: Query Optimization

1,578

Bill Karwin

08/21/2006 06:44PM

Re: Query Optimization

1,611

Will Buckner

08/27/2006 11:50PM

Re: Query Optimization

1,705

Anthony Willard

08/28/2006 07:33AM

Optimizing a UNION Query

5,899

08/23/2006 08:16PM

Re: Optimizing a UNION Query

2,544

Toa Sty

08/24/2006 05:28AM

Re: Optimizing a UNION Query

2,596

08/24/2006 12:12PM

Re: Optimizing a UNION Query

5,128

Toa Sty

08/25/2006 06:14AM

Re: Optimizing a UNION Query

2,533

Toa Sty

08/24/2006 04:59AM

Really need help with optimization

2,738

08/22/2006 01:43PM

Re: Really need help with optimization

1,678

Toa Sty

08/23/2006 12:50AM

Re: Really need help with optimization

1,777

08/23/2006 01:24PM

Re: Really need help with optimization

1,688

Toa Sty

08/24/2006 04:53AM

Re: Really need help with optimization

1,662

08/22/2006 01:46PM

Left Join Problem

2,419

Clodelio Delfino

08/22/2006 11:30PM

Re: Left Join Problem

1,665

Bob Field

08/23/2006 09:00AM

Re: Left Join Problem

1,670

Clodelio Delfino

08/23/2006 06:53PM

Re: Left Join Problem

1,612

Bob Field

08/23/2006 07:12PM

Re: Left Join Problem

1,783

Clodelio Delfino

08/23/2006 11:01PM

optimizing the query.

2,379

ronak desai

07/26/2006 07:13AM

Re: optimizing the query.

1,718

Yogesh Salvi

08/22/2006 12:37PM

Re: optimizing the query.

1,714

Toa Sty

08/04/2006 04:50AM

Re: optimizing the query.

1,654

KimSeong Loh

07/27/2006 12:13AM

cant get LEFT JOIN to work properly when ORDER'ing BY

2,086

Liutauras

08/20/2006 02:11AM

Re: cant get LEFT JOIN to work properly when ORDER'ing BY

1,542

Liutauras

08/22/2006 03:26AM

cant get LEFT JOIN to work properly when ORDER'ing BY

6,140

Liutauras

08/20/2006 01:36AM

Re: cant get LEFT JOIN to work properly when ORDER'ing BY

8,235

Toa Sty

08/21/2006 07:25AM

Re: cant get LEFT JOIN to work properly when ORDER'ing BY

3,936

Toa Sty

08/21/2006 07:55AM

Re: cant get LEFT JOIN to work properly when ORDER'ing BY

2,878

Liutauras

08/22/2006 03:25AM

Force Table Selection Order in JOIN Statement?

9,878

Frank Osterberg

08/21/2006 02:39AM

Re: Force Table Selection Order in JOIN Statement?

9,404

Toa Sty

08/21/2006 06:24AM

ORDER BY RAND() taking too much time

9,747

Yogesh Salvi

04/29/2006 05:30AM

Re: ORDER BY RAND() taking too much time

3,632

Erin ONeill

06/08/2006 10:38AM

Re: ORDER BY RAND() taking too much time

2,463

Yogesh Salvi

05/11/2006 04:25AM

Re: ORDER BY RAND() taking too much time

2,962

Yogesh Salvi

05/03/2006 01:51AM

Re: ORDER BY RAND() taking too much time

3,237

Ravenous Bugblatter Beast

08/15/2006 05:13PM

Re: ORDER BY RAND() taking too much time

2,774

Yogesh Salvi

05/03/2006 02:11AM

Re: ORDER BY RAND() taking too much time

3,932

Yogesh Salvi

05/02/2006 08:44AM

Re: ORDER BY RAND() taking too much time

3,370

Björn Steinbrink

05/02/2006 02:24PM

Re: ORDER BY RAND() taking too much time

3,630

Sebastien Caisse

05/01/2006 08:49AM

How to create on-the-fly index on derived table?

11,225

Nathan Cheng

07/25/2006 01:05PM

Re: How to create on-the-fly index on derived table?

6,629

Nathan Cheng

08/12/2006 03:04PM

difference performance of simple SELECT (on large tables) between MySql running on Windows XP and on Ubuntu

2,613

Ed Stone

08/09/2006 03:48PM

EXISTS() optimization

19,254

Rob Blick

06/07/2006 10:00AM

Re: EXISTS() optimization

6,316

bill stamp

07/25/2006 07:54AM

Re: EXISTS() optimization

5,505

Nathan Cheng

07/25/2006 01:13PM

Re: EXISTS() optimization

5,058

Toa Sty

08/04/2006 04:45AM

Too many rows being read

2,670

preston

08/02/2006 02:02PM

Re: Too many rows being read

1,636

Bob Field

08/02/2006 02:18PM

Why does this query filesort?

2,553

Jim Daemon

07/27/2006 12:05PM

Re: Why does this query filesort?

1,709

KimSeong Loh

08/01/2006 11:14PM

optimize dynamic sql

3,222

Bhupesh Tripathi

07/28/2006 03:33AM

query of tables with a longblob

2,297

paul obyrne

06/23/2006 11:44AM

Re: query of tables with a longblob

1,593

Nathan Cheng

07/25/2006 01:26PM

Optimizing (a=b and c=d) OR (e=f and g=h)

2,457

a.h.s. boy

07/20/2006 12:07PM

Re: Optimizing (a=b and c=d) OR (e=f and g=h)

1,638

KimSeong Loh

07/20/2006 05:29PM

Re: Optimizing (a=b and c=d) OR (e=f and g=h)

1,639

a.h.s. boy

07/20/2006 10:09PM

With vs Without Primary Key in a particular case

6,673

Martin Feng

07/19/2006 11:02PM

Re: With vs Without Primary Key in a particular case

2,699

KimSeong Loh

07/20/2006 05:35PM

SELECT DISTINCT vs UNIQUE KEY

9,700

Martin Feng

07/19/2006 06:11AM

LEFT JOIN problem

3,183

Steve Jordi

07/17/2006 07:13AM

Re: LEFT JOIN problem

1,698

Peter Brawley

07/17/2006 08:07AM

Re: LEFT JOIN problem

1,655

Steve Jordi

07/17/2006 09:30AM

Re: LEFT JOIN problem

1,662

Peter Brawley

07/17/2006 12:03PM

Re: LEFT JOIN problem

1,602

Steve Jordi

07/17/2006 10:23PM

(How) are subqueries optimized involving the same table?

2,490

Jakobus Dornier

07/13/2006 08:02AM

Re: (How) are subqueries optimized involving the same table?

1,794

Jakobus Dornier

07/13/2006 08:20AM

Re: (How) are subqueries optimized involving the same table?

1,683

Bob Field

07/13/2006 08:33AM

Re: (How) are subqueries optimized involving the same table?

1,862

Jakobus Dornier

07/13/2006 08:40AM

Re: (How) are subqueries optimized involving the same table?

1,686

Bob Field

07/13/2006 08:53AM

Re: (How) are subqueries optimized involving the same table?

1,592

Jakobus Dornier

07/13/2006 08:57AM

Re: (How) are subqueries optimized involving the same table?

1,825

Bob Field

07/13/2006 08:12AM

How to get some documents or articles on the query optimization of MySQL????

2,285

Hui Sun

07/10/2006 07:10AM

Re: How to get some documents or articles on the query optimization of MySQL????

1,687

KimSeong Loh

07/10/2006 05:12PM

min() vs limit optimization

5,224

Paul Medynski

07/02/2006 05:34PM

Re: min() vs limit optimization

2,083

Apachez

07/02/2006 08:26PM

Re: min() vs limit optimization

2,037

Paul Medynski

07/03/2006 05:22PM

Re: min() vs limit optimization

2,203

Apachez

07/04/2006 06:51AM

Slow Union Query Opimization. Need help.

6,029

Roland Meier

06/29/2006 12:50AM

Re: Slow Union Query Opimization. Need help.

2,453

Jay Pipes

06/29/2006 04:53PM

Re: Slow Union Query Opimization. Need help.

2,751

Roland Meier

06/30/2006 02:30AM

Re: Slow Union Query Opimization. Need help.

2,998

Anthony Willard

06/29/2006 08:24AM

querying time is too high

2,679

trinath somanchi

06/27/2006 07:31AM

Re: querying time is too high

1,790

Anthony Willard

06/29/2006 08:52AM

Re: querying time is too high

1,722

trinath somanchi

06/29/2006 12:48AM

Re: querying time is too high

1,825

Jim Daemon

06/28/2006 10:00AM

Boolean search and 99% cpu

2,183

Taiyo Rai

06/27/2006 07:17AM

Joining several multi-to-multi tables

3,359

adambrill1986

06/20/2006 11:59AM

Re: Joining several multi-to-multi tables

1,909

adambrill1986

06/23/2006 06:58AM

Re: Joining several multi-to-multi tables

1,763

adambrill1986

06/20/2006 12:21PM

Re: Joining several multi-to-multi tables

1,804

adambrill1986

06/20/2006 01:44PM

Re: Joining several multi-to-multi tables

1,750

Bill Karwin

06/20/2006 04:23PM

Re: Joining several multi-to-multi tables

1,725

KimSeong Loh

06/20/2006 06:02PM

Re: Joining several multi-to-multi tables

1,771

Bill Karwin

06/20/2006 01:02PM

Re: Joining several multi-to-multi tables

1,747

Bill Karwin

06/20/2006 12:14PM

no optimization?

2,282

Uwe

05/22/2006 05:47AM

Re: no optimization?

1,741

Apachez

06/18/2006 08:50PM

Re: no optimization?

1,690

Uwe

06/21/2006 10:40AM

Regression: Query optimized in 4.1, not at all in 5.0, why?

2,298

William Shubert

06/21/2006 12:35AM

Re: Regression: Query optimized in 4.1, not at all in 5.0, why?

1,643

William Shubert

06/21/2006 12:36AM

RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min

4,429

Ijaz Rashid

06/20/2006 07:06AM

Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min

2,018

Bill Karwin

06/20/2006 12:18PM

Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min

2,114

Ijaz Rashid

06/20/2006 07:18AM

Why does this delete statement take so long?

4,801

Jim Daemon

06/15/2006 02:11PM

Re: Why does this delete statement take so long?

1,938

Bob Field

06/15/2006 03:56PM

Re: Why does this delete statement take so long?

1,868

Jim Daemon

06/15/2006 04:16PM

Why isn't the index being used?

3,109

Jim Daemon

06/12/2006 06:11PM

Re: Why isn't the index being used?

1,844

Jim Daemon

06/13/2006 04:03PM

Re: Why isn't the index being used?

1,843

Jim Daemon

06/13/2006 09:54AM

Re: Why isn't the index being used?

1,814

KimSeong Loh

06/13/2006 10:34AM

Re: Why isn't the index being used?

1,812

Bob Field

06/13/2006 09:11AM

Re: Why isn't the index being used?

2,030

Jim Daemon

06/13/2006 08:41AM

Re: Why isn't the index being used?

1,782

Bob Field

06/12/2006 06:41PM

How to avoid temporary and filesort?

5,652

Jim Daemon

06/13/2006 08:49AM

Re: How to avoid temporary and filesort?

3,060

KimSeong Loh

06/13/2006 09:06AM

Re: How to avoid temporary and filesort?

3,208

Jim Daemon

06/13/2006 09:39AM

Re: How to avoid temporary and filesort?

2,640

KimSeong Loh

06/13/2006 10:31AM

How to avoid filesort

12,298

Jim Daemon

06/11/2006 06:50PM

Re: How to avoid filesort

6,033

Jim Daemon

06/12/2006 01:30PM

Re: How to avoid filesort

6,780

KimSeong Loh

06/12/2006 08:40AM

Re: How to avoid filesort

6,018

Jim Daemon

06/12/2006 09:10AM

Help with optimizing GROUP BY query

4,788

lasse

06/12/2006 07:16AM

Re: Help with optimizing GROUP BY query

2,421

KimSeong Loh

06/12/2006 08:37AM

Re: Help with optimizing GROUP BY query

2,318

lasse

06/12/2006 10:54AM

Re: Help with optimizing GROUP BY query

2,327

KimSeong Loh

06/12/2006 01:01PM

Pages:

« 1

...

14 15 16 17 18

...

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.