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
• MySQL Connector/ODBC 5.3.13 has been released	04/29/2019 05:44PM
• MySQL Cluster 7.6.10 has been released	04/27/2019 03:25AM
• MySQL Cluster 7.5.14 has been released	04/26/2019 12:12PM
• MySQL Cluster 7.3.25 has been released	04/26/2019 11:34AM
• MySQL Cluster 7.4.24 has been released	04/26/2019 11:00AM

New Topic

Pages:

« 1 2 3 4 5

...

18 »

Subject

Views

Written By

Posted

Optimizer for innodb does not reduce "data_free"

3,890

Sebastian Schött

12/06/2012 03:39AM

Re: Optimizer for innodb does not reduce "data_free"

1,520

Rick James

12/08/2012 01:33PM

Complex query - need advise

2,460

chris boer

11/03/2012 04:16PM

Re: Complex query - need advise

1,219

chris boer

11/03/2012 04:24PM

Re: Complex query - need advise

1,176

chris boer

11/04/2012 10:05AM

Re: Complex query - need advise

1,502

Rick James

11/05/2012 11:12AM

Follow up on "Query Execution Plan"

2,073

Chris Slominski

10/24/2012 11:59AM

Re: Follow up on "Query Execution Plan"

1,147

Chris Slominski

10/25/2012 11:14AM

Re: Follow up on "Query Execution Plan"

994

Chris Slominski

10/25/2012 06:15AM

JOIN query too slow

2,160

N. Kovac

10/13/2012 11:52AM

Re: JOIN query too slow

1,052

Peter Brawley

10/14/2012 10:26AM

Re: JOIN query too slow

1,099

Rick James

10/16/2012 07:48PM

bulk update very slow

4,474

james che

09/25/2012 02:51PM

Re: bulk update very slow

1,673

james che

09/26/2012 02:58PM

Re: bulk update very slow

1,669

Rick James

09/27/2012 08:19PM

Re: bulk update very slow

2,205

Jørgen Løland

09/27/2012 12:01PM

Why Query Cache Actived Returns Wrong Results?

2,418

09/22/2012 08:57PM

Re: Why Query Cache Actived Returns Wrong Results?

1,300

Rick James

09/23/2012 03:46PM

Re: Why Query Cache Actived Returns Wrong Results?

1,313

09/23/2012 08:24PM

Re: Why Query Cache Actived Returns Wrong Results?

1,043

Rick James

09/24/2012 11:43PM

Join? Union? I am so lost.

2,009

Hank Reardon

09/17/2012 09:09AM

Re: Join? Union? I am so lost.

1,046

Rick James

09/18/2012 07:48AM

How make indexes work with group by statement

1,954

Adnan Raza

09/13/2012 12:48AM

Re: How make indexes work with group by statement

1,087

Rick James

09/15/2012 10:34PM

Re: How make indexes work with group by statement

1,133

Jørgen Løland

09/13/2012 01:50AM

Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27

2,344

Dominik Bieringer

09/05/2012 02:57AM

Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27

1,035

Rick James

09/06/2012 10:42PM

Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27

1,131

Øystein Grøvlen

09/06/2012 04:32AM

optimize the query

2,123

ch srinivas

08/27/2012 10:47PM

Re: optimize the query

1,088

Øystein Grøvlen

08/28/2012 01:43AM

Re: optimize the query

978

ch srinivas

08/29/2012 04:15AM

Re: optimize the query

1,048

Øystein Grøvlen

08/29/2012 04:39AM

Re: optimize the query

953

ch srinivas

08/29/2012 05:38AM

Re: optimize the query

1,018

Rick James

08/30/2012 07:20AM

Query with GROUP BY not using Index

2,484

Imran Akbar

08/14/2012 01:06PM

Re: Query with GROUP BY not using Index

1,167

Øystein Grøvlen

08/15/2012 02:46AM

Re: Query with GROUP BY not using Index

1,115

Imran Akbar

08/16/2012 10:30AM

Re: Query with GROUP BY not using Index

1,287

Øystein Grøvlen

08/17/2012 02:58AM

Re: Query with GROUP BY not using Index

1,123

Rick James

08/18/2012 10:30PM

Re: Query with GROUP BY not using Index

1,065

Imran Akbar

08/24/2012 12:41PM

Re: Query with GROUP BY not using Index

1,146

Øystein Grøvlen

08/28/2012 03:11AM

Re: Query with GROUP BY not using Index

1,177

Imran Akbar

08/28/2012 06:21PM

Re: Query with GROUP BY not using Index

1,492

Øystein Grøvlen

08/29/2012 01:28AM

Re: Query with GROUP BY not using Index

1,058

Imran Akbar

08/29/2012 10:36AM

CONCAT and Index in where clause

12,152

Aurelien PANIZZA

08/22/2012 08:45AM

Re: CONCAT and Index in where clause

4,339

Øystein Grøvlen

08/23/2012 01:15AM

Re: CONCAT and Index in where clause

3,402

Rick James

08/23/2012 09:13PM

Re: CONCAT and Index in where clause

3,376

Aurelien PANIZZA

08/27/2012 09:53AM

Re: CONCAT and Index in where clause

3,380

Øystein Grøvlen

08/28/2012 02:50AM

Simple query spending too much time in 'statistics' state without reason

11,015

Vincent B.

08/21/2012 06:19AM

Re: Simple query spending too much time in 'statistics' state without reason

5,973

Jørgen Løland

08/24/2012 06:24AM

Re: Simple query spending too much time in 'statistics' state without reason

4,320

Vincent B.

08/28/2012 01:53AM

Re: Simple query spending too much time in 'statistics' state without reason

5,598

Rick James

08/22/2012 07:44PM

Order By Slows down Joins

3,231

Sami BH

08/22/2012 09:12AM

Re: Order By Slows down Joins

953

Rick James

08/23/2012 08:56PM

always uses filesort even after adding indexes

2,179

Pranav Gore

08/22/2012 02:49AM

Re: always uses filesort even after adding indexes

1,053

Rick James

08/22/2012 10:52PM

STRAIGHT_JOIN for OUTER JOINGS

3,097

Paul Tsui

08/19/2012 08:28PM

Re: STRAIGHT_JOIN for OUTER JOINGS

1,379

Øystein Grøvlen

08/20/2012 05:16AM

CPU usage 99% - and query very slow - help

4,134

irox ferenc

08/03/2012 10:49AM

Re: CPU usage 99% - and query very slow - help

1,667

Rick James

08/04/2012 01:36PM

Re: CPU usage 99% - and query very slow - help

2,337

robert eeeeee

08/06/2012 01:04PM

Re: CPU usage 99% - and query very slow - help

1,640

Øystein Grøvlen

08/15/2012 03:09AM

Execution plan: wrong index selected, very poor performance.

3,532

Andrej Andrejevic

07/18/2012 10:31AM

Re: Execution plan: wrong index selected, very poor performance.

1,440

Rick James

07/19/2012 10:07PM

Re: Execution plan: wrong index selected, very poor performance.

1,309

Andrej Andrejevic

07/20/2012 01:38AM

Re: Execution plan: wrong index selected, very poor performance.

1,132

Andrej Andrejevic

07/24/2012 04:27AM

Re: Execution plan: wrong index selected, very poor performance.

1,155

Rick James

07/25/2012 12:21AM

Index for Query

2,263

dileep ch

07/17/2012 12:41AM

Re: Index for Query

1,105

Rick James

07/17/2012 10:36PM

Re: Index for Query

1,161

dileep ch

07/18/2012 11:52PM

Re: Index for Query

1,770

Rick James

07/19/2012 09:49PM

best way to optimize this query

2,397

Jap bn

07/14/2012 09:54AM

Re: best way to optimize this query

1,410

Rick James

07/15/2012 10:11PM

Optimizer being overly aggressive

2,274

07/06/2012 08:18PM

Re: Optimizer being overly aggressive

1,159

Rick James

07/10/2012 12:49PM

Re: Optimizer being overly aggressive

1,178

07/10/2012 08:54PM

multiple-column index and order by

2,513

Raphael Hoffmann

07/06/2012 05:59PM

Re: multiple-column index and order by

1,181

Rick James

07/10/2012 12:55PM

From Months to Seconds with Subquery Materialization

1,768

Edwin DeSouza

07/09/2012 11:15AM

performing mysqldump corrected query issue?

2,123

Peter Sylvester

06/26/2012 01:12PM

Re: performing mysqldump corrected query issue?

1,159

Rick James

07/01/2012 06:43PM

Re: performing mysqldump corrected query issue?

990

Peter Sylvester

06/26/2012 02:08PM

difference between READ and SCAN

1,859

Linhai Song

06/20/2012 04:05PM

Re: difference between READ and SCAN

921

Rick James

06/20/2012 08:23PM

Re: difference between READ and SCAN

1,225

Linhai Song

06/21/2012 12:19PM

to optimize a self join request

1,723

Oracleuser user

06/14/2012 08:23AM

Re: to optimize a self join request

1,182

Rick James

06/15/2012 08:19AM

Call out for FULL JOIN - bug #18003

1,921

ted strauss

06/14/2012 10:23AM

Re: Call out for FULL JOIN - bug #18003

854

ted strauss

06/14/2012 12:13PM

index cannot be used when passing 'int' to 'varchar'

2,413

liao zhifeng

06/10/2012 11:16PM

Re: index cannot be used when passing 'int' to 'varchar'

1,009

Rick James

06/11/2012 11:27PM

Re: index cannot be used when passing 'int' to 'varchar'

1,053

liao zhifeng

06/12/2012 12:48AM

Re: index cannot be used when passing 'int' to 'varchar'

1,071

Rick James

06/12/2012 09:23PM

Re: index cannot be used when passing 'int' to 'varchar'

1,210

liao zhifeng

06/12/2012 11:16PM

Re: index cannot be used when passing 'int' to 'varchar'

1,044

Rick James

06/13/2012 07:15PM

Re: index cannot be used when passing 'int' to 'varchar'

1,010

liao zhifeng

06/13/2012 10:35PM

Table does not support optimize...

2,881

Piotr Ch

06/02/2012 12:58AM

Querying a fast subquery never returns

1,775

Eric Coll

05/22/2012 05:15PM

Re: Querying a fast subquery never returns

998

Eric Coll

05/22/2012 05:19PM

Re: Querying a fast subquery never returns

1,248

Rick James

05/24/2012 12:40AM

Re: Querying a fast subquery never returns

1,233

Eric Coll

05/25/2012 11:15AM

Re: Querying a fast subquery never returns

1,077

Rick James

05/26/2012 10:59AM

table index optimization

2,040

Matus Zeman

05/01/2012 10:55AM

Re: table index optimization

995

Rick James

05/02/2012 07:08PM

Re: table index optimization

1,153

Rick James

05/05/2012 09:07AM

Re: table index optimization

985

Matus Zeman

05/17/2012 09:25AM

Re: table index optimization

1,231

Matus Zeman

05/04/2012 08:20AM

Query execution plan

2,511

Chris Slominski

05/08/2012 12:38PM

Re: Query execution plan

1,075

Rick James

05/09/2012 09:35PM

Re: Query execution plan

1,167

Chris Slominski

05/10/2012 08:29AM

Re: Query execution plan

1,165

Rick James

05/11/2012 07:16PM

Re: Query execution plan

1,244

Chris Slominski

05/14/2012 05:27AM

Re: Query execution plan

1,006

Rick James

05/15/2012 07:22PM

Re: Query execution plan

1,002

Chris Slominski

05/09/2012 11:08AM

limit & scala subquery

1,950

jongse park

05/08/2012 10:33PM

Re: limit & scala subquery

937

Rick James

05/09/2012 09:21PM

Mysql slow upadte

1,505

krishna krishna

04/30/2012 06:09AM

1000 Columns, 1000 Tables, or what?

2,472

Fernando Oliveira

04/19/2012 08:09AM

Re: 1000 Columns, 1000 Tables, or what?

1,218

Rick James

04/20/2012 06:50PM

Re: 1000 Columns, 1000 Tables, or what?

1,014

Fernando Oliveira

04/23/2012 08:10AM

Re: 1000 Columns, 1000 Tables, or what?

1,276

Rick James

04/26/2012 07:59AM

Help with query/tables optimization

1,849

Oleg Ivanov

04/14/2012 05:20AM

Re: Help with query/tables optimization

1,110

Rick James

04/16/2012 12:05AM

Re: Help with query/tables optimization

1,171

Oleg Ivanov

04/16/2012 11:53AM

Re: Help with query/tables optimization

1,479

Oleg Ivanov

04/16/2012 12:04PM

Identical servers different plan for the same query

2,641

Eric Coll

04/07/2012 01:20AM

Re: Identical servers different plan for the same query

1,107

Eric Coll

04/10/2012 03:28PM

Re: Identical servers different plan for the same query

1,153

Rick James

04/10/2012 10:29PM

Re: Identical servers different plan for the same query

1,064

Eric Coll

04/11/2012 10:05AM

Re: Identical servers different plan for the same query

1,152

Rick James

04/12/2012 08:56AM

Re: Identical servers different plan for the same query

1,105

Eric Coll

04/12/2012 03:23PM

Re: Identical servers different plan for the same query

2,262

Rick James

04/13/2012 03:49PM

Re: Identical servers different plan for the same query

1,145

Eric Coll

04/07/2012 09:55AM

Re: Identical servers different plan for the same query

1,116

irek kordirko

04/07/2012 02:54PM

Re: Identical servers different plan for the same query

1,378

Rick James

04/08/2012 12:20PM

Re: Identical servers different plan for the same query

1,455

Eric Coll

04/09/2012 10:24AM

Re: Identical servers different plan for the same query

1,123

Eric Coll

04/09/2012 10:35AM

Re: Identical servers different plan for the same query

1,080

Eric Coll

04/09/2012 10:37AM

Re: Identical servers different plan for the same query

1,151

Eric Coll

04/09/2012 10:42AM

MySQL Optimizer: Improved DBT-3 Results with MySQL 5.6.5

1,532

Edwin DeSouza

04/10/2012 05:31PM

MySQL Optimizer: Improvements for many-table joins

1,539

Edwin DeSouza

04/10/2012 02:54PM

MySQL Optimizer Team Blog

1,833

Edwin DeSouza

04/10/2012 01:58PM

MySQL Optimizer: Index Condition Pushdown to the rescue!

1,604

Edwin DeSouza

04/10/2012 01:56PM

MySQL Optimizer: Semi-join in MySQL 5.6

1,255

Edwin DeSouza

04/10/2012 01:56PM

MySQL Optimizer: On queries with many values in the IN clause

1,499

Edwin DeSouza

04/10/2012 01:55PM

MySQL Optimizer: Faster subqueries with materialization

1,289

Edwin DeSouza

04/10/2012 01:54PM

MySQL Optimizer: Structured EXPLAIN (JSON)

1,725

Edwin DeSouza

04/10/2012 01:54PM

LEFT JOIN WHERE GROUP BY

2,382

Daniel Flöijer

04/02/2012 02:51AM

Re: LEFT JOIN WHERE GROUP BY

1,239

Rick James

04/05/2012 08:01PM

Re: LEFT JOIN WHERE GROUP BY

966

irek kordirko

04/02/2012 12:04PM

Re: LEFT JOIN WHERE GROUP BY

1,018

Daniel Flöijer

04/02/2012 01:24PM

Re: LEFT JOIN WHERE GROUP BY

1,057

irek kordirko

04/02/2012 04:29PM

Re: LEFT JOIN WHERE GROUP BY

1,562

Daniel Flöijer

04/03/2012 12:50AM

Re: LEFT JOIN WHERE GROUP BY

1,025

irek kordirko

04/03/2012 05:40PM

Re: LEFT JOIN WHERE GROUP BY

1,122

Daniel Flöijer

04/03/2012 11:22PM

Re: LEFT JOIN WHERE GROUP BY

990

irek kordirko

04/04/2012 05:12PM

Re: LEFT JOIN WHERE GROUP BY

798

Daniel Flöijer

04/04/2012 11:10PM

Explain the order of query

1,905

jongse park

03/19/2012 01:49AM

Re: Explain the order of query

986

Rick James

03/19/2012 10:38PM

Re: Explain the order of query

997

jongse park

03/21/2012 07:06PM

Re: Explain the order of query

1,278

Jørgen Løland

03/28/2012 05:06AM

Re: Explain the order of query

798

Rick James

03/22/2012 06:01PM

Re: Explain the order of query

844

jongse park

03/22/2012 08:13PM

Re: Explain the order of query

833

Rick James

03/23/2012 07:57PM

Queries using JOIN and ORDER BY LIMIT

12,632

Nikita Dubrovsky

03/10/2012 01:11PM

Re: Queries using JOIN and ORDER BY LIMIT

1,972

irek kordirko

03/12/2012 06:18PM

Re: Queries using JOIN and ORDER BY LIMIT

1,689

Rick James

03/13/2012 11:07PM

Re: Queries using JOIN and ORDER BY LIMIT

1,512

Nikita Dubrovsky

03/14/2012 08:45AM

Re: Queries using JOIN and ORDER BY LIMIT

1,873

Rick James

03/15/2012 10:50AM

Obfuscate Functions and Procedures

1,759

Tremal Naik

03/12/2012 05:00AM

Re: Obfuscate Functions and Procedures

1,227

Rick James

03/13/2012 10:46PM

Group by not using index

2,035

Matthew Moles

03/02/2012 10:06AM

Re: Group by not using index

1,015

Rick James

03/04/2012 10:59PM

Re: Group by not using index

970

Matthew Moles

03/05/2012 03:57AM

Re: Group by not using index

907

irek kordirko

03/03/2012 05:22PM

This topic has been moved.: difference between READ and SCAN

0

Linhai Song

06/20/2012 05:47PM

Pages:

« 1 2 3 4 5

...

18 »

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.