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

...

15 16 17 18 19 »

Subject

Views

Written By

Posted

Great masses of files on database.

2,635

Tronks

05/26/2006 01:06PM

Re: Great masses of files on database.

1,609

Bill Karwin

05/26/2006 04:00PM

Re: Great masses of files on database.

1,739

Peter Brawley

05/26/2006 08:59PM

Re: Great masses of files on database.

2,029

Anthony Willard

05/26/2006 01:37PM

JOIN with GROUP BY, without PRIMARY KEY

6,670

05/12/2006 10:57AM

Re: JOIN with GROUP BY, without PRIMARY KEY

3,690

05/25/2006 12:31PM

Re: JOIN with GROUP BY, without PRIMARY KEY

2,447

05/17/2006 10:30AM

Re: JOIN with GROUP BY, without PRIMARY KEY

2,235

KimSeong Loh

05/17/2006 09:44PM

Re: JOIN with GROUP BY, without PRIMARY KEY

2,293

05/23/2006 09:39AM

Re: JOIN with GROUP BY, without PRIMARY KEY

2,430

KimSeong Loh

05/14/2006 06:58PM

Optimization advise needed

2,514

Jerry Tian

05/18/2006 12:51AM

Re: Optimization advise needed

1,858

Jerry Tian

05/18/2006 12:57PM

Re: Optimization advise needed

1,797

Björn Steinbrink

05/18/2006 01:51AM

index ignored

2,312

Lauren Bradford

05/18/2006 12:00PM

mySQL performance problem on subqueries

2,717

Falcon Meriva

05/15/2006 05:14AM

Re: mySQL performance problem on subqueries

1,873

KimSeong Loh

05/15/2006 06:17PM

Re: mySQL performance problem on subqueries

1,863

Peter Brawley

05/15/2006 12:31PM

How to optimize this query

2,491

Yogesh Salvi

05/13/2006 04:36AM

Re: How to optimize this query

1,910

Apachez

05/13/2006 08:22AM

Problem with index and left join

4,368

Erland Isaksson

05/05/2006 03:04PM

Re: Problem with index and left join

2,395

KimSeong Loh

05/09/2006 06:17PM

Re: Problem with index and left join

2,475

Erland Isaksson

05/09/2006 10:44PM

Re: Problem with index and left join

2,209

Apachez

05/09/2006 11:48PM

Re: Problem with index and left join

2,219

Erland Isaksson

05/10/2006 10:52AM

Optimize Query with SUM() and CASE... statements

33,099

Jacob Drew

05/05/2006 11:21PM

Re: Optimize Query with SUM() and CASE... statements

6,048

Anthony Willard

05/08/2006 07:57AM

HELPPPPPPPPPPPPPPP PLEASE

2,806

Odimar Tomazeli

05/04/2006 12:21PM

Make optimized LEFT JOIN with GROUP BY

12,711

Jerry Potokar

05/03/2006 08:30AM

Re: Make optimized LEFT JOIN with GROUP BY

2,502

Jerry Potokar

05/03/2006 05:09PM

Re: Make optimized LEFT JOIN with GROUP BY

2,579

Jerry Potokar

05/03/2006 05:45PM

Re: Make optimized LEFT JOIN with GROUP BY

2,393

Jerry Potokar

05/04/2006 06:05AM

Re: Make optimized LEFT JOIN with GROUP BY

3,925

Jerry Potokar

05/04/2006 08:10AM

Re: Make optimized LEFT JOIN with GROUP BY

2,600

Björn Steinbrink

05/03/2006 06:41PM

Re: Make optimized LEFT JOIN with GROUP BY

2,365

Jerry Potokar

05/03/2006 04:03PM

Re: Make optimized LEFT JOIN with GROUP BY

4,369

Beat Vontobel

05/03/2006 04:29PM

Re: Make optimized LEFT JOIN with GROUP BY

2,237

Jerry Potokar

05/03/2006 04:17PM

Re: Make optimized LEFT JOIN with GROUP BY

2,507

Jerry Potokar

05/03/2006 01:17PM

Re: Make optimized LEFT JOIN with GROUP BY

2,459

Beat Vontobel

05/03/2006 01:23PM

Re: Make optimized LEFT JOIN with GROUP BY

4,264

Jerry Potokar

05/03/2006 09:20AM

Re: Make optimized LEFT JOIN with GROUP BY

3,641

Beat Vontobel

05/03/2006 12:58PM

Re: Make optimized LEFT JOIN with GROUP BY

3,782

Jerry Potokar

05/03/2006 09:21AM

Re: Make optimized LEFT JOIN with GROUP BY

6,052

Beat Vontobel

05/03/2006 01:19PM

Re: Make optimized LEFT JOIN with GROUP BY

4,176

Jerry Potokar

05/03/2006 02:38PM

Re: Make optimized LEFT JOIN with GROUP BY

2,653

Jerry Potokar

05/03/2006 02:43PM

Re: Make optimized LEFT JOIN with GROUP BY

3,697

Beat Vontobel

05/03/2006 03:35PM

Re: Make optimized LEFT JOIN with GROUP BY

5,360

Beat Vontobel

05/03/2006 09:11AM

Query Optimization

3,817

Joe Taylor

04/26/2006 01:57PM

Re: Query Optimization

1,930

Björn Steinbrink

05/03/2006 03:31PM

Re: Query Optimization

2,081

Bill Karwin

04/26/2006 04:46PM

Re: Query Optimization

1,962

Apachez

04/26/2006 04:56PM

Re: Query Optimization

2,167

Bill Karwin

04/26/2006 05:29PM

Re: Query Optimization

1,928

Joe Taylor

05/03/2006 03:11PM

Optimizing Substring Query

6,199

spicedh

05/02/2006 01:01PM

Re: Optimizing Substring Query

2,049

Peter Brawley

05/02/2006 02:39PM

Re: Optimizing Substring Query

2,686

spicedh

05/02/2006 02:45PM

Re: Optimizing Substring Query

1,817

Peter Brawley

05/02/2006 03:00PM

Re: Optimizing Substring Query

2,473

Björn Steinbrink

05/02/2006 02:59PM

Performance impact of filtering in ON vs WHERE clause

15,364

John McNally

04/28/2006 12:17PM

Re: Performance impact of filtering in ON vs WHERE clause

5,492

Apachez

04/28/2006 12:26PM

Re: Performance impact of filtering in ON vs WHERE clause

4,464

Sebastien Caisse

05/01/2006 08:40AM

Re: Performance impact of filtering in ON vs WHERE clause

4,477

Apachez

05/01/2006 12:54PM

Re: Performance impact of filtering in ON vs WHERE clause

4,599

Sebastien Caisse

05/02/2006 01:06PM

Re: Performance impact of filtering in ON vs WHERE clause

4,529

Apachez

05/02/2006 01:15PM

Re: Performance impact of filtering in ON vs WHERE clause

5,369

Björn Steinbrink

05/02/2006 02:21PM

INDEX on DATE field and MONTH() YEAR() functions

21,469

Tristan Crombez

04/30/2006 01:14PM

Re: INDEX on DATE field and MONTH() YEAR() functions

8,525

Bill Karwin

04/30/2006 03:55PM

table design and query opimization

2,852

prasanna

04/19/2006 02:11AM

Re: table design and query opimization

2,001

Sebastien Caisse

04/27/2006 11:27AM

Re: table design and query opimization

1,625

prasanna

04/19/2006 10:25PM

Re: table design and query opimization

2,004

moraless92

04/19/2006 10:29AM

Optimizer not working adequately

2,585

emilio.ayllon

04/25/2006 07:41PM

Re: Optimizer not working adequately

1,837

EM Ayllon

04/26/2006 09:43AM

Re: Optimizer not working adequately

1,884

Björn Steinbrink

04/26/2006 03:36AM

UNION/UNION ALL queries and parallel processing

7,319

Dominique PRUNIER

04/20/2006 09:39AM

Re: UNION/UNION ALL queries and parallel processing

3,232

James Day

04/23/2006 02:11PM

Re: UNION/UNION ALL queries and parallel processing

3,478

Dominique PRUNIER

04/23/2006 08:04PM

Using "optimize table"

2,609

Bozhidar Bozhanov

04/21/2006 04:02AM

Re: Using "optimize table"

1,769

Apachez

04/21/2006 04:26AM

where condition optimization

3,009

Srivats Chandrasekaran

02/27/2006 03:57AM

Re: where condition optimization

1,815

Bob Field

04/19/2006 09:51AM

Re: where condition optimization

1,809

prasanna

04/19/2006 02:26AM

Database structure question

2,712

Bozhidar Bozhanov

04/17/2006 10:29AM

Re: Database structure question

1,812

Bill Karwin

04/17/2006 10:54AM

High RAM usage

3,658

04/12/2006 08:25AM

Re: High RAM usage

2,310

Bill Karwin

04/12/2006 11:33AM

LEFT JOIN Issue in 5.0

3,754

Martin Dubuc

04/10/2006 10:28AM

Re: LEFT JOIN Issue in 5.0

1,883

Roman Kolcun

04/10/2006 03:24PM

Re: LEFT JOIN Issue in 5.0

1,877

Martin Dubuc

04/11/2006 07:34AM

Re: LEFT JOIN Issue in 5.0

1,965

Martin Dubuc

04/11/2006 07:34AM

Re: LEFT JOIN Issue in 5.0

2,044

Bob Field

04/10/2006 12:50PM

Re: LEFT JOIN Issue in 5.0

2,068

Martin Dubuc

04/10/2006 03:11PM

Re: LEFT JOIN Issue in 5.0

2,001

Bob Field

04/10/2006 10:37AM

Re: LEFT JOIN Issue in 5.0

1,940

Martin Dubuc

04/10/2006 11:38AM

Index merge optimization (with OR) and table joins

2,509

Stuart Brooks

04/07/2006 06:56AM

data design optimization

2,857

BattleMan BattleClan

03/30/2006 07:44AM

Re: data design optimization

2,101

BattleMan BattleClan

04/01/2006 06:38AM

Re: data design optimization

1,839

Peter Brawley

03/31/2006 04:59PM

Re: data design optimization

1,963

BattleMan BattleClan

03/31/2006 01:42PM

Re: data design optimization

1,966

Peter Brawley

03/30/2006 04:03PM

Re: data design optimization

2,026

BattleMan BattleClan

03/30/2006 01:41PM

Query Statement

2,458

BattleMan BattleClan

03/30/2006 01:43PM

Re: data design optimization

1,856

Peter Brawley

03/30/2006 09:02AM

refashion MySQL parse engine problem(bison, flex)

2,650

feeling wu

03/28/2006 09:26AM

Defragmentation and Database Optimizing Tool in the Background

2,653

Mathias Bischoff

01/26/2006 10:53AM

Re: Defragmentation and Database Optimizing Tool in the Background

1,863

Ulrich Schmid

03/28/2006 04:01AM

Question regarding 5.0 LEFT JOIN

2,425

03/27/2006 04:59PM

Re: Question regarding 5.0 LEFT JOIN

2,350

Peter Brawley

03/27/2006 06:23PM

Problem with LEF OUTER JOIN

3,318

wdeveloper

03/19/2006 04:01PM

Re: Problem with LEF OUTER JOIN

2,183

wdeveloper

03/26/2006 11:40PM

Re: Problem with LEF OUTER JOIN

2,142

wdeveloper

03/24/2006 02:01PM

Re: Problem with LEF OUTER JOIN

2,220

KimSeong Loh

03/26/2006 08:05PM

Re: Problem with LEF OUTER JOIN

2,034

KimSeong Loh

03/22/2006 07:06PM

Re: Problem with LEF OUTER JOIN

1,971

wdeveloper

03/22/2006 05:10PM

Re: Problem with LEF OUTER JOIN

1,989

Sebastien Caisse

03/23/2006 08:06AM

Re: Problem with LEF OUTER JOIN

1,982

KimSeong Loh

03/21/2006 06:35PM

Re: Problem with LEF OUTER JOIN

1,888

Bob Field

03/19/2006 05:48PM

Re: Problem with LEF OUTER JOIN

2,512

wdeveloper

03/20/2006 04:04AM

Re: Problem with LEF OUTER JOIN

2,284

Bob Field

03/20/2006 10:31AM

Re: Problem with LEF OUTER JOIN

2,054

wdeveloper

03/20/2006 03:02PM

Re: Problem with LEF OUTER JOIN

1,910

Bob Field

03/20/2006 03:34PM

Dependent subquery stupidity: Is it me or the optimizer? ;-)

3,922

Beat Vontobel

03/08/2006 03:30PM

Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)

2,309

KimSeong Loh

03/09/2006 02:50AM

Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)

2,382

Beat Vontobel

03/09/2006 03:09AM

Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)

3,920

Björn Steinbrink

03/24/2006 12:02PM

Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)

2,316

Jay Pipes

03/08/2006 10:03PM

Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)

2,200

Beat Vontobel

03/23/2006 02:41PM

Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)

2,234

Beat Vontobel

03/09/2006 02:16AM

suggestion for optimizing with non-matching compound indexes

4,824

Nathan Cheng

03/08/2006 12:39PM

Re: suggestion for optimizing with non-matching compound indexes

2,236

Harrison Fisk

03/16/2006 11:40AM

Re: suggestion for optimizing with non-matching compound indexes

2,145

Nathan Cheng

03/16/2006 12:15PM

Re: suggestion for optimizing with non-matching compound indexes

2,902

Björn Steinbrink

03/22/2006 09:48AM

Re: suggestion for optimizing with non-matching compound indexes

2,071

Björn Steinbrink

03/22/2006 09:12PM

Re: suggestion for optimizing with non-matching compound indexes

2,078

Björn Steinbrink

03/24/2006 11:02AM

Query Optimization

2,697

Jorden Dunne

03/21/2006 06:10AM

Re: Query Optimization

1,780

Peter Brawley

03/21/2006 08:24AM

Re: Query Optimization

1,735

Jorden Dunne

03/21/2006 09:19AM

Re: Query Optimization

1,899

Peter Brawley

03/21/2006 11:24AM

Mysql high cpu usage problem

2,772

vikki saggu

01/07/2006 02:29PM

Re: Mysql high cpu usage problem

2,088

Bruno B.

01/31/2006 07:13AM

Re: Mysql high cpu usage problem

2,460

Tobias Marx

03/20/2006 05:26PM

Query

2,655

03/15/2006 11:08AM

Re: Query

1,936

03/15/2006 11:17AM

Re: Query

1,906

Jay Pipes

03/15/2006 11:37AM

Re: Query

1,807

03/17/2006 08:38AM

my.cnf option file , which one to use ?

3,291

Ilan Goldman

03/07/2006 02:48PM

UP , JUMP , PLEASE HELP

1,910

Ilan Goldman

03/10/2006 04:19PM

How do I avoid "Using file sort" and "Using temporary"

32,933

Solon Barns

03/03/2006 03:20PM

Re: How do I avoid "Using file sort" and "Using temporary"

19,789

Solon Barns

03/10/2006 03:01PM

Re: How do I avoid "Using file sort" and "Using temporary"

18,293

Jay Pipes

03/06/2006 10:16AM

Re: How do I avoid "Using file sort" and "Using temporary"

16,547

Solon Barns

03/06/2006 12:51PM

Re: How do I avoid "Using file sort" and "Using temporary"

18,059

Jay Pipes

03/07/2006 11:42AM

Re: How do I avoid "Using file sort" and "Using temporary"

19,891

Jay Pipes

03/04/2006 11:46AM

Re: How do I avoid "Using file sort" and "Using temporary"

18,440

Solon Barns

03/06/2006 08:27AM

MIN on an indexed field too slow

4,241

Camelia Ticau

03/01/2006 01:58PM

Re: MIN on an indexed field too slow

2,430

Björn Steinbrink

03/09/2006 06:04AM

Re: MIN on an indexed field too slow

2,017

Apachez

03/02/2006 03:28PM

Re: MIN on an indexed field too slow

2,085

Camelia Ticau

03/02/2006 11:38AM

Re: MIN on an indexed field too slow

2,196

Apachez

03/01/2006 05:19PM

Re: MIN on an indexed field too slow

2,217

Camelia Ticau

03/01/2006 04:54PM

Re: MIN on an indexed field too slow

2,333

Apachez

03/01/2006 03:25PM

is HASH index being ignored

3,810

Michal Carson

03/07/2006 10:17PM

Re: is HASH index being ignored

2,117

Michal Carson

03/08/2006 10:59AM

Re: is HASH index being ignored

2,198

Felix Geerinckx

03/08/2006 04:32AM

Re: is HASH index being ignored

1,995

KimSeong Loh

03/08/2006 07:50PM

Urgent Optimized QUERY needed::

3,263

Mohammed Abdullah All Marbin

03/04/2006 03:27PM

Re: Urgent Optimized QUERY needed::

1,889

Bob Field

03/04/2006 04:33PM

Big MyISAM table with 3500 insertions per second behaviour

4,608

Victor Perez Roche

02/20/2006 07:55AM

Re: Big MyISAM table with 3500 insertions per second behaviour

2,146

Edwin DeSouza

02/22/2006 01:39PM

Re: Big MyISAM table with 3500 insertions per second behaviour

2,085

Victor Perez Roche

02/28/2006 07:33AM

Re: Big MyISAM table with 3500 insertions per second behaviour

2,023

Edwin DeSouza

03/03/2006 04:14PM

Re: Big MyISAM table with 3500 insertions per second behaviour

2,364

Victor Perez Roche

02/20/2006 12:05PM

Re: Big MyISAM table with 3500 insertions per second behaviour

2,196

Olaf van der Spek

02/20/2006 09:20AM

Range query performance question

6,634

Camelia Ticau

02/27/2006 01:52PM

Re: Range query performance question

2,600

Jay Pipes

02/27/2006 02:50PM

TINYINT(1) or ENUM( 'true' , 'false')

30,094

yoderek

02/23/2006 01:56PM

Re: TINYINT(1) or ENUM( 'true' , 'false')

12,731

Jay Pipes

02/23/2006 11:12PM

Need recommendation regarding IN expression

3,254

Solon Barns

02/22/2006 12:52PM

Re: Need recommendation regarding IN expression

2,183

Jay Pipes

02/22/2006 01:29PM

Re: Need recommendation regarding IN expression

1,922

Solon Barns

02/23/2006 12:59AM

Re: Need recommendation regarding IN expression

2,199

Jay Pipes

02/23/2006 10:55AM

slow subquery

6,562

Michael Schnell

12/01/2005 03:33AM

Re: slow subquery

5,192

Olaf van der Spek

02/23/2006 08:04AM

Re: slow subquery

2,590

mysql.com

02/22/2006 01:06PM

Re: slow subquery

2,634

Igor Babaev

12/19/2005 11:58PM

Re: slow subquery

3,135

Matthias Horn

12/30/2005 12:43PM

Re: slow subquery (query is fast)

3,375

Matthias Horn

12/30/2005 02:25PM

Re: slow subquery

2,697

Michael Schnell

12/09/2005 02:32PM

Re: slow subquery

2,882

Brian Moon

12/07/2005 08:18AM

possible_keys exist but key is NULL

10,496

David McLaughlin

02/22/2006 11:29AM

Re: possible_keys exist but key is NULL

4,439

Thomas CORBIERE

02/22/2006 02:12PM

"id IN (x,y)" versus "id=x OR id=y" with ORDER BY

2,676

Robert Bergs

02/21/2006 07:00AM

what is sql.exe doing?

3,875

Zilan Ciftci

02/19/2006 11:45AM

SUBQUERY PROBLEM AGAIN

2,300

Odimar Tomazeli

02/17/2006 01:37PM

Subquery performance improvements: When?

5,346

Olaf van der Spek

02/08/2006 10:07AM

Re: Subquery performance improvements: When?

2,475

Olaf van der Spek

02/14/2006 08:31AM

Re: Subquery performance improvements: When?

2,464

Robin Schumacher

02/09/2006 10:43AM

subquery workaround in MySQL 4.0.24

2,778

Robert van Twillert

02/13/2006 12:47PM

SUBQUERY PROBLEM

3,397

Odimar Tomazeli

02/07/2006 04:21PM

Re: SUBQUERY PROBLEM

2,100

Odimar Tomazeli

02/13/2006 12:16PM

Re: SUBQUERY PROBLEM

2,307

Odimar Tomazeli

02/13/2006 11:17AM

Re: SUBQUERY PROBLEM

2,239

Jay Pipes

02/13/2006 11:22AM

Re: SUBQUERY PROBLEM

2,399

Odimar Tomazeli

02/13/2006 11:06AM

Re: SUBQUERY PROBLEM

2,163

Odimar Tomazeli

02/08/2006 08:37AM

Re: SUBQUERY PROBLEM - Optimizer Team

2,191

Odimar Tomazeli

02/08/2006 10:26AM

Re: SUBQUERY PROBLEM

2,304

Robin Schumacher

02/08/2006 04:57AM

Re: SUBQUERY PROBLEM

2,142

Jay Pipes

02/08/2006 03:59PM

Re: SUBQUERY PROBLEM

2,288

Jay Pipes

02/07/2006 04:45PM

Re: SUBQUERY PROBLEM

2,165

Jay Pipes

02/07/2006 04:52PM

Pages:

« 1

...

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.