MySQL :: MySQL Forums :: Optimizer & Parser

Announcements	Last Post
• MySQL Connector/NET 6.10.9 has been released	07/29/2019 10:27PM
• MySQL Connector/J 5.1.48 GA has been released	07/29/2019 01:52PM
• MySQL Cluster 7.3.26 has been released	07/23/2019 08:40AM
• MySQL Cluster 7.4.25 has been released	07/23/2019 01:56AM
• MySQL Cluster 7.5.15 has been released	07/23/2019 01:40AM

New Topic

Pages:

« 1

...

13 14 15 16 17

...

18 »

Subject

Views

Written By

Posted

Simple queries take a lot some times

2,372

Paolo Ragone

01/30/2007 01:04PM

ORDER BY + LIMIT

4,446

Markus Doppelbauer

11/12/2006 04:45AM

Re: ORDER BY + LIMIT

3,147

Toa Sty

11/12/2006 08:27AM

Re: ORDER BY + LIMIT

2,928

Markus Doppelbauer

11/12/2006 12:09PM

Re: ORDER BY + LIMIT

30,161

Toa Sty

11/13/2006 04:40AM

Re: ORDER BY + LIMIT

3,489

Markus Doppelbauer

01/30/2007 12:06PM

bug?? partial index gives wrong results with IN subquery

2,721

Paul Davies

01/29/2007 08:44AM

File Sort

2,670

aftab khan

01/25/2007 08:49AM

Re: File Sort

1,873

KimSeong Loh

01/26/2007 07:50AM

SQL Newbie needs urgently help! [optimizing query]

3,283

Toxic Head

01/24/2007 05:31AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,169

Toxic Head

01/24/2007 05:52AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,077

Toa Sty

01/24/2007 06:07AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,134

Toxic Head

01/24/2007 06:18AM

Re: SQL Newbie needs urgently help! [optimizing query]

1,990

Toa Sty

01/24/2007 07:16AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,174

Toxic Head

01/24/2007 07:32AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,009

Toxic Head

01/24/2007 06:41AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,004

Toxic Head

01/24/2007 07:16AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,084

Toa Sty

01/24/2007 08:16AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,172

Toxic Head

01/24/2007 08:50AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,095

Toxic Head

01/24/2007 09:24AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,035

Björn Steinbrink

01/24/2007 03:19PM

Re: SQL Newbie needs urgently help! [optimizing query]

1,954

Toxic Head

01/25/2007 07:27AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,203

Toa Sty

01/24/2007 10:29AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,092

Toxic Head

01/24/2007 10:40AM

Re: SQL Newbie needs urgently help! [optimizing query]

2,047

Toa Sty

01/24/2007 09:10AM

need solution for ORDER BY and COUNT

2,861

Konstantin S.

01/25/2007 05:46AM

Need help optmizing query

2,400

Pascual Angulo

01/16/2007 03:58PM

Re: Need help optmizing query

1,913

KimSeong Loh

01/16/2007 06:42PM

How to optimize a derived table required for re-ordering.

3,634

Vikash Bucha

11/25/2006 05:58AM

Re: How to optimize a derived table required for re-ordering.

2,866

Toa Sty

01/15/2007 08:41AM

Help optimizing a slow query entry

2,776

Patrick

01/12/2007 10:28AM

Re: Help optimizing a slow query entry

1,838

Toa Sty

01/15/2007 08:30AM

Having problems with ORDER BY COUNT

13,920

steed coptang

04/29/2006 08:56AM

Re: Having problems with ORDER BY COUNT

4,981

Omar Khan

01/15/2007 03:35AM

Re: Having problems with ORDER BY COUNT

4,531

Toa Sty

01/15/2007 08:28AM

Problems optimize query

3,614

Rafal Kedziorski

01/08/2007 05:14PM

Make this faster?

3,394

Levi Tedder

01/04/2007 07:38AM

Re: Make this faster?

2,171

Björn Steinbrink

01/04/2007 03:34PM

Re: Make this faster?

2,123

Levi Tedder

01/05/2007 02:40AM

Re: Make this faster?

2,072

Björn Steinbrink

01/05/2007 05:07AM

Re: Make this faster?

2,066

Levi Tedder

01/05/2007 08:31AM

Re: Make this faster?

2,098

Toa Sty

01/05/2007 08:45AM

Re: Make this faster?

2,099

Levi Tedder

01/08/2007 02:44AM

Re: Make this faster?

2,053

Toa Sty

01/08/2007 04:28AM

Re: Make this faster?

2,082

Levi Tedder

01/08/2007 04:41AM

Re: Make this faster?

2,195

Levi Tedder

01/05/2007 03:11PM

Re: Make this faster?

2,073

Felix Geerinckx

01/05/2007 06:55AM

Re: Make this faster?

2,101

Toa Sty

01/05/2007 08:31AM

Re: Make this faster?

2,124

Levi Tedder

01/05/2007 08:33AM

Re: Make this faster?

2,228

Toa Sty

01/05/2007 08:45AM

Re: Make this faster?

2,109

Toa Sty

01/04/2007 10:21AM

Re: Make this faster?

2,069

Levi Tedder

01/04/2007 11:51AM

REGEXP is not optimized?

3,133

Maarten Oosten

12/15/2006 07:54AM

Re: REGEXP is not optimized?

2,318

Toa Sty

01/05/2007 08:57AM

Two general MySQL questions

4,091

Joost

01/02/2007 09:24AM

Re: Two general MySQL questions

2,046

KimSeong Loh

01/02/2007 08:11PM

Re: Two general MySQL questions

2,002

Joost

01/03/2007 05:35PM

Re: Two general MySQL questions

2,035

KimSeong Loh

01/03/2007 06:10PM

Re: Two general MySQL questions

2,010

Joost

01/04/2007 05:49AM

Re: Two general MySQL questions

2,014

Toa Sty

01/04/2007 10:53AM

i've got the query optimization blues ... stumped

2,744

Joe Simone

12/15/2006 02:48PM

Re: i've got the query optimization blues ... stumped

1,951

Toa Sty

01/04/2007 10:32AM

How to optimize the "order by" & "limit" query?

3,051

Jiangyubao Jiangyubao

12/18/2006 09:48AM

Re: How to optimize the "order by" & "limit" query?

2,090

Toa Sty

01/04/2007 10:25AM

parallelizing queries

2,445

Niklas Saers

01/02/2007 05:59AM

Query with GROUP BY (Using index for group-by -> Using index)

9,173

mnf

11/30/2006 05:20AM

Re: Query with GROUP BY (Using index for group-by -> Using index)

3,145

mnf

12/06/2006 02:03AM

Re: Query with GROUP BY (Using index for group-by -> Using index)

2,959

KimSeong Loh

12/07/2006 12:19AM

Re: Query with GROUP BY (Using index for group-by -> Using index)

3,027

mnf

12/25/2006 06:35AM

Re: Query with GROUP BY (Using index for group-by -> Using index)

3,461

KimSeong Loh

11/30/2006 08:18PM

Re: Query with GROUP BY (Using index for group-by -> Using index)

3,438

mnf

12/01/2006 12:21AM

optimization with table_cache

49,781

rei

09/05/2006 09:17PM

Re: optimization with table_cache

19,694

Björn Steinbrink

12/20/2006 02:45AM

Re: optimization with table_cache

20,255

sneakyimp

12/18/2006 10:40PM

Re: optimization with table_cache

20,065

Björn Steinbrink

12/20/2006 02:37AM

Optimizer Tool

2,945

Danie Van der Walt

09/04/2006 03:10AM

Re: Optimizer Tool

2,106

Yogesh Salvi

12/13/2006 04:57AM

Re: Optimizer Tool

3,221

KimSeong Loh

12/13/2006 07:39PM

Creating an index to include ORDER BY

2,896

Angus

11/02/2006 08:28AM

Re: Creating an index to include ORDER BY

1,829

KimSeong Loh

11/02/2006 05:31PM

Re: Creating an index to include ORDER BY

1,925

Angus

11/03/2006 09:24AM

Re: Creating an index to include ORDER BY

1,876

Yogesh Salvi

12/13/2006 05:02AM

Bad performance caused by DISTINCT?

8,204

Heist TheAlmighty

11/13/2006 02:02PM

Re: Bad performance caused by DISTINCT?

3,245

Yogesh Salvi

12/13/2006 04:46AM

Re: Bad performance caused by DISTINCT?

4,197

KimSeong Loh

11/19/2006 09:29PM

Two possible indexes in simple select but none is used

3,044

Ozkan Mehmedali

11/28/2006 10:40AM

Re: Two possible indexes in simple select but none is used

1,802

Yogesh Salvi

12/13/2006 04:41AM

Re: Two possible indexes in simple select but none is used

1,833

KimSeong Loh

11/28/2006 06:27PM

how turn off optimizer?

2,870

krix asdasd

11/28/2006 11:40AM

Re: how turn off optimizer?

2,633

KimSeong Loh

11/28/2006 06:25PM

Re: how turn off optimizer?

2,521

krix asdasd

11/30/2006 02:04AM

Re: how turn off optimizer?

2,128

Dewey Gaedcke

12/12/2006 06:24PM

Re: how turn off optimizer?

2,148

Dewey Gaedcke

11/28/2006 11:24PM

Golden Rules of writting efficient query

7,800

Yogesh Salvi

11/23/2006 01:37AM

Re: Golden Rules of writting efficient query

2,325

Satya Prakash

12/08/2006 08:28AM

Re: Golden Rules of writting efficient query

3,048

KimSeong Loh

11/23/2006 02:17AM

Liberating Dependent Subqueries

13,708

Shlomo Swidler

11/27/2006 05:50PM

A more general way to do it

3,802

Shlomo Swidler

12/05/2006 08:43AM

Improvements to "constify"

3,603

Shlomo Swidler

12/07/2006 06:26AM

Re: Liberating Dependent Subqueries

2,914

mnf

12/01/2006 09:35AM

Re: Liberating Dependent Subqueries

2,613

KimSeong Loh

12/03/2006 06:21PM

Re: Liberating Dependent Subqueries

2,651

mnf

12/03/2006 08:18PM

Re: Liberating Dependent Subqueries

2,686

Shlomo Swidler

12/05/2006 06:11AM

Re: Liberating Dependent Subqueries

3,238

KimSeong Loh

11/28/2006 06:29PM

Re: Liberating Dependent Subqueries

4,003

Shlomo Swidler

11/30/2006 05:39PM

Re: Liberating Dependent Subqueries

3,634

Vikash Bucha

11/28/2006 12:57AM

Re: Liberating Dependent Subqueries

3,301

Shlomo Swidler

11/28/2006 03:09AM

Update with dependent subquery needs optimization!

3,911

Lon B

12/06/2006 05:23PM

Re: Update with dependent subquery needs optimization!

2,031

Björn Steinbrink

12/07/2006 02:04AM

optimizer using sql_no_cache

3,735

alan langridge

12/06/2006 07:56AM

Re: optimizer using sql_no_cache

1,883

alan langridge

12/06/2006 11:07AM

Optimizing a query

2,608

Ryan Smith

11/28/2006 10:37AM

Re: Optimizing a query

1,777

KimSeong Loh

11/28/2006 06:28PM

Join with more strict condition shows the record which is not visible without it

2,980

Michal Jaskolski

11/24/2006 06:08AM

Multiple join and Where clause

41,670

michele terlizzi

11/15/2006 05:13AM

Re: Multiple join and Where clause

6,614

Björn Steinbrink

11/22/2006 04:20PM

Including set type in index

3,893

Angus

11/10/2006 01:56PM

Re: Including set type in index

2,286

KimSeong Loh

11/12/2006 06:55PM

Re: Including set type in index

2,098

Angus

11/13/2006 09:36AM

to save as text block? or to save as rows?

2,713

ryan morris

11/10/2006 06:09PM

ignore

2,402

chris bagnall

11/10/2006 03:44AM

deleting approx. 180m records a month

2,720

Nolan Rumble

11/06/2006 03:09PM

Re: deleting approx. 180m records a month

1,852

KimSeong Loh

11/06/2006 07:04PM

Query cache

2,585

Markus Doppelbauer

10/31/2006 01:32PM

Re: Query cache

1,888

Toa Sty

10/31/2006 04:12PM

Re: Query cache

1,858

Markus Doppelbauer

11/01/2006 06:27AM

Re: Query cache

1,883

Michael Dar

11/01/2006 12:25PM

Re: Query cache

1,941

Toa Sty

11/02/2006 03:11AM

optimizing abs()

2,975

Michiel Betel

10/25/2006 04:31AM

Re: optimizing abs()

2,121

Toa Sty

10/25/2006 05:37AM

Re: optimizing abs()

1,865

Michiel Betel

10/29/2006 07:31AM

Optimizer ignores datetime index

4,960

Angus

10/27/2006 09:51AM

Re: Optimizer ignores datetime index

3,303

Toa Sty

10/27/2006 12:48PM

Re: Optimizer ignores datetime index

2,673

Angus

10/27/2006 01:09PM

Derived tables optimized differently than when directly queried?

3,708

Tom Callahan

10/25/2006 02:38PM

Re: Derived tables optimized differently than when directly queried?

1,982

Björn Steinbrink

10/26/2006 05:33PM

Simple Query - No Join - But Temp. Table and file Sort :(

3,751

Heiko G.

10/21/2006 09:06AM

Re: Simple Query - No Join - But Temp. Table and file Sort :(

2,355

Toa Sty

10/21/2006 10:55AM

Re: Simple Query - No Join - But Temp. Table and file Sort :(

2,738

Heiko G.

10/22/2006 04:56AM

Re: Simple Query - No Join - But Temp. Table and file Sort :(

2,158

Heiko G.

10/21/2006 11:17AM

Re: Simple Query - No Join - But Temp. Table and file Sort :(

2,686

Toa Sty

10/23/2006 06:41AM

Re: Simple Query - No Join - But Temp. Table and file Sort :(

2,472

Heiko G.

10/23/2006 11:02AM

Re: Simple Query - No Join - But Temp. Table and file Sort :(

2,134

Toa Sty

10/23/2006 01:01PM

Re: Simple Query - No Join - But Temp. Table and file Sort :(

2,483

Ravenous Bugblatter Beast

10/21/2006 05:20PM

Optimizer ignores number of records

2,543

Lite Wait

09/15/2006 06:28AM

Re: Optimizer ignores number of records

1,796

Ravenous Bugblatter Beast

10/21/2006 05:05AM

Performance of two similar Selects

2,660

Jay Klein

10/12/2006 06:34PM

Re: Performance of two similar Selects

1,796

Toa Sty

10/17/2006 02:07PM

How to speed up query of indexed column with 5M rows?

23,778

ryan zheng

10/09/2006 06:34AM

Re: How to speed up query of indexed column with 5M rows?

4,887

KimSeong Loh

10/09/2006 07:54PM

Re: How to speed up query of indexed column with 5M rows?

6,293

Toa Sty

10/09/2006 09:40AM

Re: How to speed up query of indexed column with 5M rows?

5,897

ryan zheng

10/09/2006 08:39PM

Re: How to speed up query of indexed column with 5M rows?

8,775

Larry Kagan

10/09/2006 08:11AM

Re: How to speed up query of indexed column with 5M rows?

7,302

ryan zheng

10/10/2006 12:23AM

Re: How to speed up query of indexed column with 5M rows?

6,384

Björn Steinbrink

10/12/2006 07:57PM

Re: How to speed up query of indexed column with 5M rows?

6,652

Larry Kagan

10/10/2006 08:45AM

Deactivate an activate Database

9,338

Sudipta Ghosh

10/06/2006 06:37AM

Re: Deactivate an activate Database

3,426

Bob Field

10/06/2006 09:35AM

Re: Deactivate an activate Database

2,959

Sudipta Ghosh

10/06/2006 11:12PM

Re: Deactivate an activate Database

2,797

Bob Field

10/06/2006 11:48PM

improving speed of mysql distance filter

9,052

aubrey falconer

05/19/2006 05:27PM

Re: improving speed of mysql distance filter

3,438

Peter Brawley

06/29/2006 07:54PM

Re: improving speed of mysql distance filter

2,990

Joost

06/28/2006 11:27AM

Re: improving speed of mysql distance filter

3,170

Bob Field

06/17/2006 03:12PM

Re: improving speed of mysql distance filter

4,480

Joost

06/28/2006 01:40AM

Re: improving speed of mysql distance filter

5,154

John Campbell

10/05/2006 09:56AM

Re: improving speed of mysql distance filter

3,215

aubrey falconer

06/17/2006 02:52PM

strange query performance

2,696

Eugene G

10/01/2006 08:56AM

Re: strange query performance

1,777

Eugene G

10/01/2006 11:56AM

Re: strange query performance

1,797

Toa Sty

10/03/2006 02:43AM

ORDER BY doesn't use index

11,716

Frederic Giudicelli

09/13/2006 12:32AM

Re: ORDER BY doesn't use index

3,690

KimSeong Loh

09/13/2006 02:36AM

Re: ORDER BY doesn't use index

3,335

Frederic Giudicelli

09/27/2006 03:39AM

Re: ORDER BY doesn't use index

3,181

Toa Sty

09/27/2006 05:02AM

Re: ORDER BY doesn't use index

3,090

Frederic Giudicelli

09/30/2006 05:53PM

Re: ORDER BY doesn't use index

3,073

Toa Sty

10/03/2006 02:38AM

Re: ORDER BY doesn't use index

5,179

Toa Sty

09/13/2006 02:00AM

Optimizing left outer join query

13,729

Muhammad Imran Khalid

09/24/2006 11:40PM