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:

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

...

8 9 10 11 12

...

19 »

Subject

Views

Written By

Posted

Query/table structure optimization CHALLENGE!

3,272

Olli S

02/06/2010 06:53PM

Re: Query/table structure optimization CHALLENGE!

1,662

Rick James

02/07/2010 09:34PM

View Optimization using Aggregation Functions

3,567

Kevin Harms

02/03/2010 05:00PM

Re: View Optimization using Aggregation Functions

1,406

Rick James

02/05/2010 11:50PM

Optimizer slow on large number of sub-queries

3,106

Tim Brody

01/29/2010 08:42AM

Re: Optimizer slow on large number of sub-queries

1,550

Rick James

01/30/2010 07:26PM

Re: Optimizer slow on large number of sub-queries

1,691

Tim Brody

01/31/2010 05:43AM

Re: Optimizer slow on large number of sub-queries

1,427

Rick James

01/31/2010 06:04PM

Query optimizer - cost estimation

4,544

John Edwards

01/28/2010 01:38PM

Re: Query optimizer - cost estimation

1,899

Rick James

01/30/2010 07:37PM

Trying to use EXPLAIN to optimize this small example

4,934

Steven Mac

01/28/2010 10:15AM

Re: Trying to use EXPLAIN to optimize this small example

1,759

Rick James

01/30/2010 07:36PM

Simple join uses temptables and filesort, why?

6,168

Reine n/a

01/25/2010 04:52AM

Re: Simple join uses temptables and filesort, why?

2,585

Rick James

01/26/2010 10:13PM

'check table' changes indexes used in query?

3,941

01/20/2010 09:49PM

Re: 'check table' changes indexes used in query?

1,760

Rick James

01/24/2010 11:16PM

Re: 'check table' changes indexes used in query?

1,890

01/25/2010 09:06AM

Re: 'check table' changes indexes used in query?

1,770

Rick James

01/25/2010 11:15AM

Efficient way to get list of first letter of fields?

11,071

Scott Mueller

01/01/2010 06:17AM

Re: Efficient way to get list of first letter of fields?

3,846

Rick James

01/02/2010 10:42PM

Re: Efficient way to get list of first letter of fields?

3,723

Scott Mueller

01/03/2010 02:28AM

Re: Efficient way to get list of first letter of fields?

3,576

Rick James

01/03/2010 11:07AM

Re: Efficient way to get list of first letter of fields?

2,940

Scott Mueller

01/09/2010 03:31AM

Re: Efficient way to get list of first letter of fields?

2,766

Rick James

01/10/2010 03:36PM

Simple query, but slow one.

3,427

Laurent Thoulon

12/01/2009 04:30AM

Re: Simple query, but slow one.

2,045

Rick James

12/05/2009 11:37PM

Re: Simple query, but slow one.

2,027

Laurent Thoulon

12/09/2009 09:33AM

Re: Simple query, but slow one.

1,880

Rick James

12/10/2009 11:13PM

Re: Simple query, but slow one.

1,889

Laurent Thoulon

12/14/2009 07:17AM

Re: Simple query, but slow one.

1,861

Rick James

12/22/2009 11:47AM

Re: Simple query, but slow one.

1,848

Laurent Thoulon

01/04/2010 05:25AM

Re: Simple query, but slow one.

1,841

Rick James

01/04/2010 10:39AM

Re: Simple query, but slow one.

1,786

Laurent Thoulon

01/04/2010 11:01AM

Re: Simple query, but slow one.

1,848

Rick James

01/04/2010 11:47PM

Re: Simple query, but slow one.

1,782

Laurent Thoulon

01/05/2010 03:11AM

Re: Simple query, but slow one.

1,902

Rick James

01/05/2010 09:23AM

calculating total products in each category

4,528

tep .

12/16/2009 04:26AM

Re: calculating total products in each category

1,980

tep .

12/17/2009 09:58AM

Re: calculating total products in each category

2,131

12/18/2009 07:46AM

Re: calculating total products in each category

2,216

tep .

12/18/2009 07:50AM

Re: calculating total products in each category

1,973

Rick James

12/29/2009 09:54PM

Re: calculating total products in each category

2,219

tep .

12/30/2009 02:35AM

Re: calculating total products in each category

2,069

Rick James

12/30/2009 08:09PM

Re: calculating total products in each category

2,414

tep .

12/31/2009 12:39AM

Re: calculating total products in each category

4,950

tep .

12/31/2009 01:42AM

Re: calculating total products in each category

3,329

tep .

01/04/2010 08:13AM

Re: calculating total products in each category

1,979

tep .

12/23/2009 08:15AM

Web Speed ???

2,737

Frank Regufluid

01/03/2010 12:15AM

Re: Web Speed ???

1,761

David Lee

01/04/2010 08:00AM

Re: Web Speed ???

1,654

Rick James

01/03/2010 05:34PM

Query optimization issue

3,245

dhiraj kumar

12/29/2009 07:54AM

Re: Query optimization issue

1,757

Jonathon Coombes

12/29/2009 09:46PM

Re: Query optimization issue

1,598

Rick James

12/30/2009 12:21AM

General Question: Multi Query Optimization in MySql

3,871

Martin Dürre

11/30/2009 07:34AM

Re: General Question: Multi Query Optimization in MySql

2,067

Rick James

12/05/2009 11:42PM

Re: General Question: Multi Query Optimization in MySql

2,046

abdelrahman ellithy

12/27/2009 05:45AM

Re: General Question: Multi Query Optimization in MySql

2,092

Martin Dürre

12/07/2009 06:11AM

Re: General Question: Multi Query Optimization in MySql

1,880

Rick James

12/11/2009 12:04AM

problem about slow_query in log

3,532

h ch

12/25/2009 02:59AM

Re: problem about slow_query in log

1,699

Rick James

12/26/2009 12:02PM

Query optimisation help

2,499

Paul Smith

12/18/2009 08:30AM

Re: Query optimisation help

1,652

Rick James

12/22/2009 10:03PM

Re: Query optimisation help

1,666

12/23/2009 02:46AM

question about DATE,TIME,and DATETIME

2,866

h ch

12/16/2009 08:22PM

Re: question about DATE,TIME,and DATETIME

1,703

Rick James

12/22/2009 10:04PM

full table scan for limit??

5,523

h ch

12/15/2009 01:49AM

Re: full table scan for limit??

2,686

Rick James

12/22/2009 12:04PM

Get 200K x PR0 Backlinks (Permanent) on 200K Different Domains & Different IPs.

4,927

tirtha roy

12/08/2009 12:35AM

query hangs in 'statistics' state

4,930

jan koum

11/29/2009 02:16AM

Re: query hangs in 'statistics' state

2,464

Rick James

12/05/2009 11:46PM

Configuration of open_files_limit

7,426

Paul Rosier

12/02/2009 03:33AM

Re: Configuration of open_files_limit

3,247

Rick James

12/05/2009 04:33PM

Query giving slow performance.

2,849

Lokesh Kumar

11/24/2009 05:13AM

Re: Query giving slow performance.

1,464

Rick James

11/25/2009 11:19PM

Unexpected behavior of the optimizer

2,832

11/20/2009 10:02AM

Re: Unexpected behavior of the optimizer

1,423

Rick James

11/24/2009 11:58PM

Simple select very slow

4,018

thierry fournier

11/15/2009 07:37AM

Re: Simple select very slow

1,984

Rick James

11/18/2009 07:37PM

Configure MySQL For Largest Data

2,647

ali mokhlesi

11/11/2009 09:01AM

Re: Configure MySQL For Largest Data

1,635

Rick James

11/18/2009 07:03PM

optimizing query

3,128

kavitha L

11/10/2009 01:19AM

Re: optimizing query

1,970

Rick James

11/18/2009 04:42PM

Re: optimizing query

1,763

kavitha L

11/10/2009 01:24AM

Search Engine Optimization Services

3,184

Arber Technologies

11/09/2009 03:31AM

Update table slower in trigger than in procedure. Is this possible?

3,410

Emilio NicolÃ¡s

10/28/2009 12:31PM

Re: Update table slower in trigger than in procedure. Is this possible?

2,279

Emilio NicolÃ¡s

11/02/2009 07:14AM

Re: Update table slower in trigger than in procedure. Is this possible?

1,878

Rick James

11/03/2009 10:15AM

Query is so slow

3,905

Fitsum Tesfagiorgis

10/30/2009 08:45AM

Re: Query is so slow

1,986

Rick James

10/31/2009 10:19AM

Re: Query is so slow

1,973

Fitsum Tesfagiorgis

11/01/2009 09:49PM

Re: Query is so slow

1,970

Rick James

11/02/2009 10:45AM

Re: Query is so slow

1,912

Fitsum Tesfagiorgis

11/02/2009 02:22PM

Re: Query is so slow

1,997

Fitsum Tesfagiorgis

10/31/2009 03:49PM

SELECT on indexed key is slow

3,322

Francois Mazerolle

10/28/2009 08:39AM

Re: SELECT on indexed key is slow

1,834

Rick James

10/29/2009 10:08PM

i have a big table,how can i reduce it's size?

4,890

h ch

10/27/2009 02:50AM

Re: i have a big table,how can i reduce it's size?

2,944

Rick James

10/28/2009 10:12PM

Very Large Non-Dynamic Table for Lookups

3,884

Eidetic Hans

10/23/2009 05:46PM

Re: Very Large Non-Dynamic Table for Lookups

1,911

Rick James

10/24/2009 08:02PM

Re: Very Large Non-Dynamic Table for Lookups

1,979

Eidetic Hans

10/24/2009 08:55PM

Re: Very Large Non-Dynamic Table for Lookups

2,082

Rick James

10/24/2009 10:50PM

Re: Very Large Non-Dynamic Table for Lookups

1,986

Eidetic Hans

10/25/2009 11:23AM

Re: Very Large Non-Dynamic Table for Lookups

2,093

Rick James

10/25/2009 12:32PM

Re: Very Large Non-Dynamic Table for Lookups

2,133

Eidetic Hans

10/26/2009 12:19PM

Re: Very Large Non-Dynamic Table for Lookups

2,208

Rick James

10/26/2009 08:03PM

Optimizer doesn't use PRIMARY key

3,784

Michal Kozusznik

10/24/2009 07:51AM

Re: Optimizer doesn't use PRIMARY key

1,957

Rick James

10/25/2009 10:11AM

Re: Optimizer doesn't use PRIMARY key

2,015

Michal Kozusznik

10/25/2009 06:04PM

Re: Optimizer doesn't use PRIMARY key

2,019

Rick James

10/25/2009 07:08PM

Re: Optimizer doesn't use PRIMARY key

2,202

Michal Kozusznik

10/26/2009 06:51PM

My.ini performance

5,849

Dozer Redoz

10/22/2009 02:52AM

Re: My.ini performance

2,282

Rick James

10/23/2009 10:05PM

simple JOIN with sub SELECT strangeness

4,456

Fabien Fab

10/19/2009 03:19AM

Re: simple JOIN with sub SELECT strangeness

2,029

Rick James

10/20/2009 08:46AM

Re: simple JOIN with sub SELECT strangeness

2,106

Fab Ien

10/21/2009 01:56AM

Re: simple JOIN with sub SELECT strangeness

2,019

Rick James

10/21/2009 08:52PM

query en grandes tablas

2,994

leonardo sandoval

10/20/2009 12:57PM

Simple query vs. large table

4,024

10/07/2009 04:00AM

Re: Simple query vs. large table

2,024

leonardo sandoval

10/20/2009 12:56PM

Re: Simple query vs. large table

2,015

Rick James

10/08/2009 07:05PM

My.cnf optimizer

5,861

alissonx alisson

10/13/2009 08:19AM

Re: My.cnf optimizer

2,309

Rick James

10/14/2009 06:29PM

Re: My.cnf optimizer

2,541

alissonx alisson

10/15/2009 06:45AM

Re: My.cnf optimizer

2,315

Rick James

10/15/2009 07:10AM

Re: My.cnf optimizer

2,080

alissonx alisson

10/15/2009 07:36AM

Re: My.cnf optimizer

2,742

alissonx alisson

10/15/2009 07:40AM

Re: My.cnf optimizer

2,214

Rick James

10/15/2009 10:53AM

LEFT JOIN, GROUP BY, ORDER BY

5,723

Dmitry Piramidin

10/13/2009 12:44AM

Re: LEFT JOIN, GROUP BY, ORDER BY

3,537

Rick James

10/14/2009 06:40PM

Need help for query optimization

2,726

shripad kulkarni

10/08/2009 04:59AM

Re: Need help for query optimization

1,772

Rick James

10/10/2009 10:16PM

how to increase delete speed?

3,699

shinichi son

10/09/2009 02:25AM

Re: how to increase delete speed?

2,577

Rick James

10/10/2009 11:31AM

Deadlock on different Tables without recycled tables reference

2,599

wenew zhang

10/01/2009 10:06PM

Help for query optimization

3,370

Vladimir Goncharov

09/23/2009 10:53AM

Re: Help for query optimization

1,940

Rick James

09/25/2009 11:54PM

Re: Help for query optimization

1,862

Vladimir Goncharov

09/24/2009 01:54PM

Cardinality Estimation in Joins

3,452

Rakshit Trivedi

09/16/2009 12:48AM

PRIMARY key not used on join

4,560

Joao Assad

09/10/2009 09:14AM

Re: PRIMARY key not used on join

2,172

Rick James

09/11/2009 06:45PM

Re: PRIMARY key not used on join

2,149

Joao Assad

09/15/2009 02:58PM

Query taking long time to execute.

3,417

09/14/2009 02:32AM

Re: Query taking long time to execute.

2,747

Rick James

09/15/2009 08:42AM

ORDER BY. Cannot get rid of 'filesort' in EXPLAIN

4,697

09/13/2009 04:16AM

Re: ORDER BY. Cannot get rid of 'filesort' in EXPLAIN

2,393

Rick James

09/14/2009 10:00AM

Classic join w/ criteria on multi tables and correct key selection

3,576

Keith Humm

09/09/2009 07:04PM

Re: Classic join w/ criteria on multi tables and correct key selection

2,136

Rick James

09/10/2009 10:29PM

Statistics used by optimizer.

6,366

Rakshit Trivedi

08/28/2009 07:32AM

Re: Statistics used by optimizer.

2,647

Rick James

08/29/2009 01:11PM

Re: Statistics used by optimizer.

2,501

Rakshit Trivedi

09/01/2009 06:30AM

Re: Statistics used by optimizer.

2,451

Rick James

09/01/2009 07:44AM

Re: Statistics used by optimizer.

2,479

Rakshit Trivedi

09/01/2009 02:51PM

Re: Statistics used by optimizer.

2,280

Rick James

09/01/2009 09:59PM

Re: Statistics used by optimizer.

2,410

Rakshit Trivedi

09/04/2009 11:00AM

Re: Statistics used by optimizer.

2,407

Rick James

09/04/2009 07:37PM

query takes too much time

3,429

alev mutlu

08/31/2009 09:26AM

Re: query takes too much time

2,005

Rick James

09/01/2009 10:34PM

Query is taking lot of time with not in clause

3,765

shahbaz khan

08/16/2009 05:06AM

Re: Query is taking lot of time with not in clause

2,476

Rick James

08/17/2009 09:56AM

Re: Query is taking lot of time with not in clause

2,611

shahbaz khan

08/18/2009 02:06AM

Re: Query is taking lot of time with not in clause

2,560

shahbaz khan

08/18/2009 02:09AM

Re: Query is taking lot of time with not in clause

2,823

Rick James

08/18/2009 06:20PM

Re: Query is taking lot of time with not in clause

2,546

shahbaz khan

08/19/2009 01:54AM

Re: Query is taking lot of time with not in clause

2,318

shahbaz khan

08/19/2009 04:54AM

Re: Query is taking lot of time with not in clause

2,514

shahbaz khan

08/19/2009 05:01AM

Re: Query is taking lot of time with not in clause

2,311

shahbaz khan

08/19/2009 05:57AM

Re: Query is taking lot of time with not in clause

2,451

Rick James

08/19/2009 09:25AM

Re: Query is taking lot of time with not in clause

2,481

shahbaz khan

08/20/2009 12:32AM

Re: Query is taking lot of time with not in clause

2,390

Rick James

08/20/2009 09:57AM

Re: Query is taking lot of time with not in clause

2,434

shahbaz khan

08/22/2009 05:32AM

Re: Query is taking lot of time with not in clause

2,415

Rick James

08/22/2009 05:25PM

Re: Query is taking lot of time with not in clause

2,486

shahbaz khan

08/23/2009 01:19AM

Re: Query is taking lot of time with not in clause

2,737

Rick James

08/23/2009 09:43AM

Re: Query is taking lot of time with not in clause

2,176

shahbaz khan

08/23/2009 11:56PM

Re: Query is taking lot of time with not in clause

2,368

Rick James

08/24/2009 09:05AM

Re: Query is taking lot of time with not in clause

2,334

shahbaz khan

08/24/2009 12:12PM

Re: Query is taking lot of time with not in clause

2,153

Rick James

08/24/2009 05:20PM

Pages:

« 1

...

8 9 10 11 12

...

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.