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,398

Olli S

02/06/2010 06:53PM

Re: Query/table structure optimization CHALLENGE!

1,736

Rick James

02/07/2010 09:34PM

View Optimization using Aggregation Functions

3,683

Kevin Harms

02/03/2010 05:00PM

Re: View Optimization using Aggregation Functions

1,467

Rick James

02/05/2010 11:50PM

Optimizer slow on large number of sub-queries

3,230

Tim Brody

01/29/2010 08:42AM

Re: Optimizer slow on large number of sub-queries

1,622

Rick James

01/30/2010 07:26PM

Re: Optimizer slow on large number of sub-queries

1,758

Tim Brody

01/31/2010 05:43AM

Re: Optimizer slow on large number of sub-queries

1,481

Rick James

01/31/2010 06:04PM

Query optimizer - cost estimation

4,645

John Edwards

01/28/2010 01:38PM

Re: Query optimizer - cost estimation

1,957

Rick James

01/30/2010 07:37PM

Trying to use EXPLAIN to optimize this small example

5,060

Steven Mac

01/28/2010 10:15AM

Re: Trying to use EXPLAIN to optimize this small example

1,827

Rick James

01/30/2010 07:36PM

Simple join uses temptables and filesort, why?

6,359

Reine n/a

01/25/2010 04:52AM

Re: Simple join uses temptables and filesort, why?

2,665

Rick James

01/26/2010 10:13PM

'check table' changes indexes used in query?

4,088

01/20/2010 09:49PM

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

1,841

Rick James

01/24/2010 11:16PM

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

1,959

01/25/2010 09:06AM

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

1,849

Rick James

01/25/2010 11:15AM

Efficient way to get list of first letter of fields?

11,294

Scott Mueller

01/01/2010 06:17AM

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

3,929

Rick James

01/02/2010 10:42PM

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

3,799

Scott Mueller

01/03/2010 02:28AM

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

3,647

Rick James

01/03/2010 11:07AM

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

3,021

Scott Mueller

01/09/2010 03:31AM

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

2,839

Rick James

01/10/2010 03:36PM

Simple query, but slow one.

3,562

Laurent Thoulon

12/01/2009 04:30AM

Re: Simple query, but slow one.

2,110

Rick James

12/05/2009 11:37PM

Re: Simple query, but slow one.

2,106

Laurent Thoulon

12/09/2009 09:33AM

Re: Simple query, but slow one.

1,946

Rick James

12/10/2009 11:13PM

Re: Simple query, but slow one.

1,959

Laurent Thoulon

12/14/2009 07:17AM

Re: Simple query, but slow one.

1,933

Rick James

12/22/2009 11:47AM

Re: Simple query, but slow one.

1,919

Laurent Thoulon

01/04/2010 05:25AM

Re: Simple query, but slow one.

1,914

Rick James

01/04/2010 10:39AM

Re: Simple query, but slow one.

1,853

Laurent Thoulon

01/04/2010 11:01AM

Re: Simple query, but slow one.

1,937

Rick James

01/04/2010 11:47PM

Re: Simple query, but slow one.

1,846

Laurent Thoulon

01/05/2010 03:11AM

Re: Simple query, but slow one.

1,962

Rick James

01/05/2010 09:23AM

calculating total products in each category

4,829

tep .

12/16/2009 04:26AM

Re: calculating total products in each category

2,052

tep .

12/17/2009 09:58AM

Re: calculating total products in each category

2,221

12/18/2009 07:46AM

Re: calculating total products in each category

2,312

tep .

12/18/2009 07:50AM

Re: calculating total products in each category

2,054

Rick James

12/29/2009 09:54PM

Re: calculating total products in each category

2,306

tep .

12/30/2009 02:35AM

Re: calculating total products in each category

2,140

Rick James

12/30/2009 08:09PM

Re: calculating total products in each category

2,515

tep .

12/31/2009 12:39AM

Re: calculating total products in each category

5,099

tep .

12/31/2009 01:42AM

Re: calculating total products in each category

3,409

tep .

01/04/2010 08:13AM

Re: calculating total products in each category

2,064

tep .

12/23/2009 08:15AM

Web Speed ???

2,879

Frank Regufluid

01/03/2010 12:15AM

Re: Web Speed ???

1,828

David Lee

01/04/2010 08:00AM

Re: Web Speed ???

1,725

Rick James

01/03/2010 05:34PM

Query optimization issue

3,372

dhiraj kumar

12/29/2009 07:54AM

Re: Query optimization issue

1,822

Jonathon Coombes

12/29/2009 09:46PM

Re: Query optimization issue

1,669

Rick James

12/30/2009 12:21AM

General Question: Multi Query Optimization in MySql

4,022

Martin Dürre

11/30/2009 07:34AM

Re: General Question: Multi Query Optimization in MySql

2,146

Rick James

12/05/2009 11:42PM

Re: General Question: Multi Query Optimization in MySql

2,116

abdelrahman ellithy

12/27/2009 05:45AM

Re: General Question: Multi Query Optimization in MySql

2,171

Martin Dürre

12/07/2009 06:11AM

Re: General Question: Multi Query Optimization in MySql

1,941

Rick James

12/11/2009 12:04AM

problem about slow_query in log

3,786

h ch

12/25/2009 02:59AM

Re: problem about slow_query in log

1,784

Rick James

12/26/2009 12:02PM

Query optimisation help

2,622

Paul Smith

12/18/2009 08:30AM

Re: Query optimisation help

1,723

Rick James

12/22/2009 10:03PM

Re: Query optimisation help

1,737

12/23/2009 02:46AM

question about DATE,TIME,and DATETIME

3,000

h ch

12/16/2009 08:22PM

Re: question about DATE,TIME,and DATETIME

1,780

Rick James

12/22/2009 10:04PM

full table scan for limit??

5,778

h ch

12/15/2009 01:49AM

Re: full table scan for limit??

2,815

Rick James

12/22/2009 12:04PM

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

5,112

tirtha roy

12/08/2009 12:35AM

query hangs in 'statistics' state

5,147

jan koum

11/29/2009 02:16AM

Re: query hangs in 'statistics' state

2,554

Rick James

12/05/2009 11:46PM

Configuration of open_files_limit

7,590

Paul Rosier

12/02/2009 03:33AM

Re: Configuration of open_files_limit

3,333

Rick James

12/05/2009 04:33PM

Query giving slow performance.

2,988

Lokesh Kumar

11/24/2009 05:13AM

Re: Query giving slow performance.

1,552

Rick James

11/25/2009 11:19PM

Unexpected behavior of the optimizer

2,967

11/20/2009 10:02AM

Re: Unexpected behavior of the optimizer

1,494

Rick James

11/24/2009 11:58PM

Simple select very slow

4,176

thierry fournier

11/15/2009 07:37AM

Re: Simple select very slow

2,054

Rick James

11/18/2009 07:37PM

Configure MySQL For Largest Data

2,769

ali mokhlesi

11/11/2009 09:01AM

Re: Configure MySQL For Largest Data

1,698

Rick James

11/18/2009 07:03PM

optimizing query

3,265

kavitha L

11/10/2009 01:19AM

Re: optimizing query

2,038

Rick James

11/18/2009 04:42PM

Re: optimizing query

1,835

kavitha L

11/10/2009 01:24AM

Search Engine Optimization Services

3,314

Arber Technologies

11/09/2009 03:31AM

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

3,536

Emilio NicolÃ¡s

10/28/2009 12:31PM

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

2,366

Emilio NicolÃ¡s

11/02/2009 07:14AM

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

1,950

Rick James

11/03/2009 10:15AM

Query is so slow

4,109

Fitsum Tesfagiorgis

10/30/2009 08:45AM

Re: Query is so slow

2,077

Rick James

10/31/2009 10:19AM

Re: Query is so slow

2,062

Fitsum Tesfagiorgis

11/01/2009 09:49PM

Re: Query is so slow

2,052

Rick James

11/02/2009 10:45AM

Re: Query is so slow

1,980

Fitsum Tesfagiorgis

11/02/2009 02:22PM

Re: Query is so slow

2,059

Fitsum Tesfagiorgis

10/31/2009 03:49PM

SELECT on indexed key is slow

3,471

Francois Mazerolle

10/28/2009 08:39AM

Re: SELECT on indexed key is slow

1,921

Rick James

10/29/2009 10:08PM

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

5,052

h ch

10/27/2009 02:50AM

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

3,031

Rick James

10/28/2009 10:12PM

Very Large Non-Dynamic Table for Lookups

4,080

Eidetic Hans

10/23/2009 05:46PM

Re: Very Large Non-Dynamic Table for Lookups

1,981

Rick James

10/24/2009 08:02PM

Re: Very Large Non-Dynamic Table for Lookups

2,066

Eidetic Hans

10/24/2009 08:55PM

Re: Very Large Non-Dynamic Table for Lookups

2,161

Rick James

10/24/2009 10:50PM

Re: Very Large Non-Dynamic Table for Lookups

2,057

Eidetic Hans

10/25/2009 11:23AM

Re: Very Large Non-Dynamic Table for Lookups

2,177

Rick James

10/25/2009 12:32PM

Re: Very Large Non-Dynamic Table for Lookups

2,219

Eidetic Hans

10/26/2009 12:19PM

Re: Very Large Non-Dynamic Table for Lookups

2,306

Rick James

10/26/2009 08:03PM

Optimizer doesn't use PRIMARY key

3,938

Michal Kozusznik

10/24/2009 07:51AM

Re: Optimizer doesn't use PRIMARY key

2,028

Rick James

10/25/2009 10:11AM

Re: Optimizer doesn't use PRIMARY key

2,098

Michal Kozusznik

10/25/2009 06:04PM

Re: Optimizer doesn't use PRIMARY key

2,100

Rick James

10/25/2009 07:08PM

Re: Optimizer doesn't use PRIMARY key

2,277

Michal Kozusznik

10/26/2009 06:51PM

My.ini performance

6,011

Dozer Redoz

10/22/2009 02:52AM

Re: My.ini performance

2,356

Rick James

10/23/2009 10:05PM

simple JOIN with sub SELECT strangeness

4,586

Fabien Fab

10/19/2009 03:19AM

Re: simple JOIN with sub SELECT strangeness

2,093

Rick James

10/20/2009 08:46AM

Re: simple JOIN with sub SELECT strangeness

2,166

Fab Ien

10/21/2009 01:56AM

Re: simple JOIN with sub SELECT strangeness

2,090

Rick James

10/21/2009 08:52PM

query en grandes tablas

3,116

leonardo sandoval

10/20/2009 12:57PM

Simple query vs. large table

4,170

10/07/2009 04:00AM

Re: Simple query vs. large table

2,084

leonardo sandoval

10/20/2009 12:56PM

Re: Simple query vs. large table

2,086

Rick James

10/08/2009 07:05PM

My.cnf optimizer

6,034

alissonx alisson

10/13/2009 08:19AM

Re: My.cnf optimizer

2,364

Rick James

10/14/2009 06:29PM

Re: My.cnf optimizer

2,603

alissonx alisson

10/15/2009 06:45AM

Re: My.cnf optimizer

2,376

Rick James

10/15/2009 07:10AM

Re: My.cnf optimizer

2,155

alissonx alisson

10/15/2009 07:36AM

Re: My.cnf optimizer

2,801

alissonx alisson

10/15/2009 07:40AM

Re: My.cnf optimizer

2,271

Rick James

10/15/2009 10:53AM

LEFT JOIN, GROUP BY, ORDER BY

5,875

Dmitry Piramidin

10/13/2009 12:44AM

Re: LEFT JOIN, GROUP BY, ORDER BY

3,609

Rick James

10/14/2009 06:40PM

Need help for query optimization

2,850

shripad kulkarni

10/08/2009 04:59AM

Re: Need help for query optimization

1,840

Rick James

10/10/2009 10:16PM

how to increase delete speed?

3,846

shinichi son

10/09/2009 02:25AM

Re: how to increase delete speed?

2,665

Rick James

10/10/2009 11:31AM

Deadlock on different Tables without recycled tables reference

2,714

wenew zhang

10/01/2009 10:06PM

Help for query optimization

3,512

Vladimir Goncharov

09/23/2009 10:53AM

Re: Help for query optimization

2,001

Rick James

09/25/2009 11:54PM

Re: Help for query optimization

1,939

Vladimir Goncharov

09/24/2009 01:54PM

Cardinality Estimation in Joins

3,597

Rakshit Trivedi

09/16/2009 12:48AM

PRIMARY key not used on join

4,685

Joao Assad

09/10/2009 09:14AM

Re: PRIMARY key not used on join

2,236

Rick James

09/11/2009 06:45PM

Re: PRIMARY key not used on join

2,215

Joao Assad

09/15/2009 02:58PM

Query taking long time to execute.

3,566

09/14/2009 02:32AM

Re: Query taking long time to execute.

2,828

Rick James

09/15/2009 08:42AM

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

4,865

09/13/2009 04:16AM

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

2,468

Rick James

09/14/2009 10:00AM

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

3,727

Keith Humm

09/09/2009 07:04PM

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

2,213

Rick James

09/10/2009 10:29PM

Statistics used by optimizer.

6,614

Rakshit Trivedi

08/28/2009 07:32AM

Re: Statistics used by optimizer.

2,721

Rick James

08/29/2009 01:11PM

Re: Statistics used by optimizer.

2,577

Rakshit Trivedi

09/01/2009 06:30AM

Re: Statistics used by optimizer.

2,537

Rick James

09/01/2009 07:44AM

Re: Statistics used by optimizer.

2,563

Rakshit Trivedi

09/01/2009 02:51PM

Re: Statistics used by optimizer.

2,394

Rick James

09/01/2009 09:59PM

Re: Statistics used by optimizer.

2,510

Rakshit Trivedi

09/04/2009 11:00AM

Re: Statistics used by optimizer.

2,481

Rick James

09/04/2009 07:37PM

query takes too much time

3,568

alev mutlu

08/31/2009 09:26AM

Re: query takes too much time

2,070

Rick James

09/01/2009 10:34PM

Query is taking lot of time with not in clause

3,945

shahbaz khan

08/16/2009 05:06AM

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

2,563

Rick James

08/17/2009 09:56AM

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

2,683

shahbaz khan

08/18/2009 02:06AM

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

2,644

shahbaz khan

08/18/2009 02:09AM

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

2,927

Rick James

08/18/2009 06:20PM

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

2,678

shahbaz khan

08/19/2009 01:54AM

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

2,404

shahbaz khan

08/19/2009 04:54AM

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

2,605

shahbaz khan

08/19/2009 05:01AM

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

2,399

shahbaz khan

08/19/2009 05:57AM

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

2,521

Rick James

08/19/2009 09:25AM

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

2,561

shahbaz khan

08/20/2009 12:32AM

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

2,468

Rick James

08/20/2009 09:57AM

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

2,519

shahbaz khan

08/22/2009 05:32AM

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

2,505

Rick James

08/22/2009 05:25PM

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

2,578

shahbaz khan

08/23/2009 01:19AM

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

2,812

Rick James

08/23/2009 09:43AM

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

2,253

shahbaz khan

08/23/2009 11:56PM

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

2,444

Rick James

08/24/2009 09:05AM

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

2,479

shahbaz khan

08/24/2009 12:12PM

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

2,237

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.