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

...

8 9 10 11 12

...

19 »

Subject

Views

Written By

Posted

Query/table structure optimization CHALLENGE!

3,308

Olli S

02/06/2010 06:53PM

Re: Query/table structure optimization CHALLENGE!

1,685

Rick James

02/07/2010 09:34PM

View Optimization using Aggregation Functions

3,599

Kevin Harms

02/03/2010 05:00PM

Re: View Optimization using Aggregation Functions

1,424

Rick James

02/05/2010 11:50PM

Optimizer slow on large number of sub-queries

3,137

Tim Brody

01/29/2010 08:42AM

Re: Optimizer slow on large number of sub-queries

1,578

Rick James

01/30/2010 07:26PM

Re: Optimizer slow on large number of sub-queries

1,710

Tim Brody

01/31/2010 05:43AM

Re: Optimizer slow on large number of sub-queries

1,444

Rick James

01/31/2010 06:04PM

Query optimizer - cost estimation

4,568

John Edwards

01/28/2010 01:38PM

Re: Query optimizer - cost estimation

1,918

Rick James

01/30/2010 07:37PM

Trying to use EXPLAIN to optimize this small example

4,969

Steven Mac

01/28/2010 10:15AM

Re: Trying to use EXPLAIN to optimize this small example

1,784

Rick James

01/30/2010 07:36PM

Simple join uses temptables and filesort, why?

6,229

Reine n/a

01/25/2010 04:52AM

Re: Simple join uses temptables and filesort, why?

2,622

Rick James

01/26/2010 10:13PM

'check table' changes indexes used in query?

3,979

01/20/2010 09:49PM

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

1,790

Rick James

01/24/2010 11:16PM

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

1,918

01/25/2010 09:06AM

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

1,801

Rick James

01/25/2010 11:15AM

Efficient way to get list of first letter of fields?

11,149

Scott Mueller

01/01/2010 06:17AM

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

3,884

Rick James

01/02/2010 10:42PM

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

3,758

Scott Mueller

01/03/2010 02:28AM

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

3,607

Rick James

01/03/2010 11:07AM

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

2,974

Scott Mueller

01/09/2010 03:31AM

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

2,796

Rick James

01/10/2010 03:36PM

Simple query, but slow one.

3,472

Laurent Thoulon

12/01/2009 04:30AM

Re: Simple query, but slow one.

2,070

Rick James

12/05/2009 11:37PM

Re: Simple query, but slow one.

2,064

Laurent Thoulon

12/09/2009 09:33AM

Re: Simple query, but slow one.

1,901

Rick James

12/10/2009 11:13PM

Re: Simple query, but slow one.

1,918

Laurent Thoulon

12/14/2009 07:17AM

Re: Simple query, but slow one.

1,892

Rick James

12/22/2009 11:47AM

Re: Simple query, but slow one.

1,872

Laurent Thoulon

01/04/2010 05:25AM

Re: Simple query, but slow one.

1,870

Rick James

01/04/2010 10:39AM

Re: Simple query, but slow one.

1,810

Laurent Thoulon

01/04/2010 11:01AM

Re: Simple query, but slow one.

1,895

Rick James

01/04/2010 11:47PM

Re: Simple query, but slow one.

1,804

Laurent Thoulon

01/05/2010 03:11AM

Re: Simple query, but slow one.

1,925

Rick James

01/05/2010 09:23AM

calculating total products in each category

4,622

tep .

12/16/2009 04:26AM

Re: calculating total products in each category

2,010

tep .

12/17/2009 09:58AM

Re: calculating total products in each category

2,161

12/18/2009 07:46AM

Re: calculating total products in each category

2,244

tep .

12/18/2009 07:50AM

Re: calculating total products in each category

2,000

Rick James

12/29/2009 09:54PM

Re: calculating total products in each category

2,255

tep .

12/30/2009 02:35AM

Re: calculating total products in each category

2,097

Rick James

12/30/2009 08:09PM

Re: calculating total products in each category

2,445

tep .

12/31/2009 12:39AM

Re: calculating total products in each category

5,016

tep .

12/31/2009 01:42AM

Re: calculating total products in each category

3,362

tep .

01/04/2010 08:13AM

Re: calculating total products in each category

2,014

tep .

12/23/2009 08:15AM

Web Speed ???

2,791

Frank Regufluid

01/03/2010 12:15AM

Re: Web Speed ???

1,787

David Lee

01/04/2010 08:00AM

Re: Web Speed ???

1,679

Rick James

01/03/2010 05:34PM

Query optimization issue

3,290

dhiraj kumar

12/29/2009 07:54AM

Re: Query optimization issue

1,780

Jonathon Coombes

12/29/2009 09:46PM

Re: Query optimization issue

1,622

Rick James

12/30/2009 12:21AM

General Question: Multi Query Optimization in MySql

3,927

Martin Dürre

11/30/2009 07:34AM

Re: General Question: Multi Query Optimization in MySql

2,095

Rick James

12/05/2009 11:42PM

Re: General Question: Multi Query Optimization in MySql

2,066

abdelrahman ellithy

12/27/2009 05:45AM

Re: General Question: Multi Query Optimization in MySql

2,121

Martin Dürre

12/07/2009 06:11AM

Re: General Question: Multi Query Optimization in MySql

1,901

Rick James

12/11/2009 12:04AM

problem about slow_query in log

3,636

h ch

12/25/2009 02:59AM

Re: problem about slow_query in log

1,729

Rick James

12/26/2009 12:02PM

Query optimisation help

2,535

Paul Smith

12/18/2009 08:30AM

Re: Query optimisation help

1,677

Rick James

12/22/2009 10:03PM

Re: Query optimisation help

1,689

12/23/2009 02:46AM

question about DATE,TIME,and DATETIME

2,914

h ch

12/16/2009 08:22PM

Re: question about DATE,TIME,and DATETIME

1,737

Rick James

12/22/2009 10:04PM

full table scan for limit??

5,621

h ch

12/15/2009 01:49AM

Re: full table scan for limit??

2,732

Rick James

12/22/2009 12:04PM

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

4,999

tirtha roy

12/08/2009 12:35AM

query hangs in 'statistics' state

5,000

jan koum

11/29/2009 02:16AM

Re: query hangs in 'statistics' state

2,489

Rick James

12/05/2009 11:46PM

Configuration of open_files_limit

7,474

Paul Rosier

12/02/2009 03:33AM

Re: Configuration of open_files_limit

3,273

Rick James

12/05/2009 04:33PM

Query giving slow performance.

2,890

Lokesh Kumar

11/24/2009 05:13AM

Re: Query giving slow performance.

1,493

Rick James

11/25/2009 11:19PM

Unexpected behavior of the optimizer

2,872

11/20/2009 10:02AM

Re: Unexpected behavior of the optimizer

1,437

Rick James

11/24/2009 11:58PM

Simple select very slow

4,069

thierry fournier

11/15/2009 07:37AM

Re: Simple select very slow

2,001

Rick James

11/18/2009 07:37PM

Configure MySQL For Largest Data

2,687

ali mokhlesi

11/11/2009 09:01AM

Re: Configure MySQL For Largest Data

1,650

Rick James

11/18/2009 07:03PM

optimizing query

3,171

kavitha L

11/10/2009 01:19AM

Re: optimizing query

1,988

Rick James

11/18/2009 04:42PM

Re: optimizing query

1,785

kavitha L

11/10/2009 01:24AM

Search Engine Optimization Services

3,223

Arber Technologies

11/09/2009 03:31AM

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

3,444

Emilio NicolÃ¡s

10/28/2009 12:31PM

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

2,305

Emilio NicolÃ¡s

11/02/2009 07:14AM

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

1,904

Rick James

11/03/2009 10:15AM

Query is so slow

3,968

Fitsum Tesfagiorgis

10/30/2009 08:45AM

Re: Query is so slow

2,022

Rick James

10/31/2009 10:19AM

Re: Query is so slow

2,005

Fitsum Tesfagiorgis

11/01/2009 09:49PM

Re: Query is so slow

1,995

Rick James

11/02/2009 10:45AM

Re: Query is so slow

1,933

Fitsum Tesfagiorgis

11/02/2009 02:22PM

Re: Query is so slow

2,013

Fitsum Tesfagiorgis

10/31/2009 03:49PM

SELECT on indexed key is slow

3,368

Francois Mazerolle

10/28/2009 08:39AM

Re: SELECT on indexed key is slow

1,859

Rick James

10/29/2009 10:08PM

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

4,950

h ch

10/27/2009 02:50AM

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

2,978

Rick James

10/28/2009 10:12PM

Very Large Non-Dynamic Table for Lookups

3,960

Eidetic Hans

10/23/2009 05:46PM

Re: Very Large Non-Dynamic Table for Lookups

1,939

Rick James

10/24/2009 08:02PM

Re: Very Large Non-Dynamic Table for Lookups

2,017

Eidetic Hans

10/24/2009 08:55PM

Re: Very Large Non-Dynamic Table for Lookups

2,110

Rick James

10/24/2009 10:50PM

Re: Very Large Non-Dynamic Table for Lookups

2,014

Eidetic Hans

10/25/2009 11:23AM

Re: Very Large Non-Dynamic Table for Lookups

2,125

Rick James

10/25/2009 12:32PM

Re: Very Large Non-Dynamic Table for Lookups

2,161

Eidetic Hans

10/26/2009 12:19PM

Re: Very Large Non-Dynamic Table for Lookups

2,245

Rick James

10/26/2009 08:03PM

Optimizer doesn't use PRIMARY key

3,836

Michal Kozusznik

10/24/2009 07:51AM

Re: Optimizer doesn't use PRIMARY key

1,982

Rick James

10/25/2009 10:11AM

Re: Optimizer doesn't use PRIMARY key

2,048

Michal Kozusznik

10/25/2009 06:04PM

Re: Optimizer doesn't use PRIMARY key

2,049

Rick James

10/25/2009 07:08PM

Re: Optimizer doesn't use PRIMARY key

2,230

Michal Kozusznik

10/26/2009 06:51PM

My.ini performance

5,903

Dozer Redoz

10/22/2009 02:52AM

Re: My.ini performance

2,304

Rick James

10/23/2009 10:05PM

simple JOIN with sub SELECT strangeness

4,492

Fabien Fab

10/19/2009 03:19AM

Re: simple JOIN with sub SELECT strangeness

2,047

Rick James

10/20/2009 08:46AM

Re: simple JOIN with sub SELECT strangeness

2,124

Fab Ien

10/21/2009 01:56AM

Re: simple JOIN with sub SELECT strangeness

2,036

Rick James

10/21/2009 08:52PM

query en grandes tablas

3,039

leonardo sandoval

10/20/2009 12:57PM

Simple query vs. large table

4,075

10/07/2009 04:00AM

Re: Simple query vs. large table

2,041

leonardo sandoval

10/20/2009 12:56PM

Re: Simple query vs. large table

2,033

Rick James

10/08/2009 07:05PM

My.cnf optimizer

5,916

alissonx alisson

10/13/2009 08:19AM

Re: My.cnf optimizer

2,326

Rick James

10/14/2009 06:29PM

Re: My.cnf optimizer

2,557

alissonx alisson

10/15/2009 06:45AM

Re: My.cnf optimizer

2,331

Rick James

10/15/2009 07:10AM

Re: My.cnf optimizer

2,095

alissonx alisson

10/15/2009 07:36AM

Re: My.cnf optimizer

2,758

alissonx alisson

10/15/2009 07:40AM

Re: My.cnf optimizer

2,231

Rick James

10/15/2009 10:53AM

LEFT JOIN, GROUP BY, ORDER BY

5,775

Dmitry Piramidin

10/13/2009 12:44AM

Re: LEFT JOIN, GROUP BY, ORDER BY

3,562

Rick James

10/14/2009 06:40PM

Need help for query optimization

2,770

shripad kulkarni

10/08/2009 04:59AM

Re: Need help for query optimization

1,800

Rick James

10/10/2009 10:16PM

how to increase delete speed?

3,752

shinichi son

10/09/2009 02:25AM

Re: how to increase delete speed?

2,605

Rick James

10/10/2009 11:31AM

Deadlock on different Tables without recycled tables reference

2,633

wenew zhang

10/01/2009 10:06PM

Help for query optimization

3,408

Vladimir Goncharov

09/23/2009 10:53AM

Re: Help for query optimization

1,962

Rick James

09/25/2009 11:54PM

Re: Help for query optimization

1,884

Vladimir Goncharov

09/24/2009 01:54PM

Cardinality Estimation in Joins

3,492

Rakshit Trivedi

09/16/2009 12:48AM

PRIMARY key not used on join

4,596

Joao Assad

09/10/2009 09:14AM

Re: PRIMARY key not used on join

2,190

Rick James

09/11/2009 06:45PM

Re: PRIMARY key not used on join

2,169

Joao Assad

09/15/2009 02:58PM

Query taking long time to execute.

3,456

09/14/2009 02:32AM

Re: Query taking long time to execute.

2,769

Rick James

09/15/2009 08:42AM

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

4,747

09/13/2009 04:16AM

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

2,413

Rick James

09/14/2009 10:00AM

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

3,627

Keith Humm

09/09/2009 07:04PM

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

2,161

Rick James

09/10/2009 10:29PM

Statistics used by optimizer.

6,444

Rakshit Trivedi

08/28/2009 07:32AM

Re: Statistics used by optimizer.

2,669

Rick James

08/29/2009 01:11PM

Re: Statistics used by optimizer.

2,529

Rakshit Trivedi

09/01/2009 06:30AM

Re: Statistics used by optimizer.

2,487

Rick James

09/01/2009 07:44AM

Re: Statistics used by optimizer.

2,508

Rakshit Trivedi

09/01/2009 02:51PM

Re: Statistics used by optimizer.

2,331

Rick James

09/01/2009 09:59PM

Re: Statistics used by optimizer.

2,461

Rakshit Trivedi

09/04/2009 11:00AM

Re: Statistics used by optimizer.

2,437

Rick James

09/04/2009 07:37PM

query takes too much time

3,480

alev mutlu

08/31/2009 09:26AM

Re: query takes too much time

2,026

Rick James

09/01/2009 10:34PM

Query is taking lot of time with not in clause

3,818

shahbaz khan

08/16/2009 05:06AM

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

2,504

Rick James

08/17/2009 09:56AM

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

2,632

shahbaz khan

08/18/2009 02:06AM

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

2,588

shahbaz khan

08/18/2009 02:09AM

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

2,858

Rick James

08/18/2009 06:20PM

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

2,591

shahbaz khan

08/19/2009 01:54AM

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

2,351

shahbaz khan

08/19/2009 04:54AM

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

2,546

shahbaz khan

08/19/2009 05:01AM

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

2,345

shahbaz khan

08/19/2009 05:57AM

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

2,472

Rick James

08/19/2009 09:25AM

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

2,502

shahbaz khan

08/20/2009 12:32AM

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

2,413

Rick James

08/20/2009 09:57AM

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

2,461

shahbaz khan

08/22/2009 05:32AM

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

2,451

Rick James

08/22/2009 05:25PM

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

2,513

shahbaz khan

08/23/2009 01:19AM

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

2,760

Rick James

08/23/2009 09:43AM

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

2,202

shahbaz khan

08/23/2009 11:56PM

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

2,394

Rick James

08/24/2009 09:05AM

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

2,385

shahbaz khan

08/24/2009 12:12PM

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

2,180

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.