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 Community Governance Model	06/25/2026 12:24PM
• Announcing June 2026 Releases featuring MySQL Server 9.7.1 and 8.4.10	06/24/2026 06:41AM

New Topic

Pages:

« 1

...

4 5 6 7 8

...

19 »

Subject

Views

Written By

Posted

Queries using JOIN and ORDER BY LIMIT

20,640

Nikita Dubrovsky

03/10/2012 01:11PM

Re: Queries using JOIN and ORDER BY LIMIT

2,945

irek kordirko

03/12/2012 06:18PM

Re: Queries using JOIN and ORDER BY LIMIT

2,836

Rick James

03/13/2012 11:07PM

Re: Queries using JOIN and ORDER BY LIMIT

3,001

Nikita Dubrovsky

03/14/2012 08:45AM

Re: Queries using JOIN and ORDER BY LIMIT

2,897

Rick James

03/15/2012 10:50AM

Obfuscate Functions and Procedures

2,465

Tremal Naik

03/12/2012 05:00AM

Re: Obfuscate Functions and Procedures

1,673

Rick James

03/13/2012 10:46PM

Group by not using index

2,795

Matthew Moles

03/02/2012 10:06AM

Re: Group by not using index

1,429

Rick James

03/04/2012 10:59PM

Re: Group by not using index

1,324

Matthew Moles

03/05/2012 03:57AM

Re: Group by not using index

1,281

irek kordirko

03/03/2012 05:22PM

Optimizing query

2,543

Marko Kupusic

02/24/2012 06:07AM

Re: Optimizing query

1,340

Rick James

02/25/2012 05:54PM

Re: Optimizing query

1,270

Marko Kupusic

02/27/2012 06:04AM

Re: Optimizing query

1,380

Rick James

02/28/2012 07:57PM

Re: Optimizing query

1,265

Ole John Aske

02/25/2012 03:49AM

Re: Optimizing query

1,621

Marko Kupusic

02/27/2012 05:57AM

Re: Optimizing query

1,413

Scott Nemes

02/24/2012 01:16PM

how to optimise query for 10+ millions records

3,357

Azhar Rahi

02/09/2012 03:30AM

Re: how to optimise query for 10+ millions records

1,863

irek kordirko

02/09/2012 05:31AM

Re: how to optimise query for 10+ millions records

1,554

Azhar Rahi

02/09/2012 05:38AM

Re: how to optimise query for 10+ millions records

1,436

irek kordirko

02/09/2012 05:58PM

Re: how to optimise query for 10+ millions records

1,408

Rick James

02/11/2012 11:26PM

Re: how to optimise query for 10+ millions records

1,674

Azhar Rahi

02/12/2012 10:12PM

Re: how to optimise query for 10+ millions records

1,534

irek kordirko

02/13/2012 02:18PM

Re: how to optimise query for 10+ millions records

1,733

Azhar Rahi

02/14/2012 02:33AM

Re: how to optimise query for 10+ millions records

1,553

irek kordirko

02/14/2012 07:24AM

Re: how to optimise query for 10+ millions records

1,551

Rick James

02/15/2012 07:30AM

Re: how to optimise query for 10+ millions records

2,046

Azhar Rahi

02/16/2012 03:54AM

Re: how to optimise query for 10+ millions records

1,438

Rick James

02/17/2012 01:20AM

Re: how to optimise query for 10+ millions records

1,409

Azhar Rahi

02/17/2012 03:57PM

Re: how to optimise query for 10+ millions records

1,690

irek kordirko

02/17/2012 05:12PM

Re: how to optimise query for 10+ millions records

1,503

Azhar Rahi

02/20/2012 02:21AM

Re: how to optimise query for 10+ millions records

1,514

Rick James

02/18/2012 07:18AM

Re: how to optimise query for 10+ millions records

1,524

Azhar Rahi

02/21/2012 03:25AM

Re: how to optimise query for 10+ millions records

1,563

Rick James

02/24/2012 10:45AM

Join

2,457

johne doe

02/01/2012 06:51AM

Re: Join Query Performance Problme

1,316

Rick James

02/03/2012 10:18AM

Re: Join Query Performance Problme

1,338

irek kordirko

02/01/2012 11:14AM

Re: Join Query Performance Problme

1,342

johne doe

02/02/2012 12:39AM

Re: Join Query Performance Problme

1,323

johne doe

02/02/2012 06:47AM

Re: Join Query Performance Problme

1,384

irek kordirko

02/02/2012 07:02PM

Re: Join Query Performance Problme

1,288

johne doe

02/03/2012 12:29AM

Re: Join Query Performance Problme

1,552

irek kordirko

02/03/2012 11:27AM

Re: Join Query Performance Problme

1,375

Rick James

02/04/2012 10:39AM

Re: Join Query Performance Problme

1,506

johne doe

02/14/2012 06:08PM

Re: Join Query Performance Problme

1,366

johne doe

02/06/2012 06:13AM

query cost calculations

4,335

Silpa Majeti

02/11/2012 04:01AM

Re: query cost calculations

1,610

Øystein Grøvlen

02/13/2012 07:13PM

Re: query cost calculations

1,764

Rick James

02/12/2012 01:03PM

Strange performance results with JOIN/COUNT

2,703

Tomas Pluskal

02/08/2012 06:25PM

Re: Strange performance results with JOIN/COUNT

1,266

Øystein Grøvlen

02/09/2012 03:01AM

Re: Strange performance results with JOIN/COUNT

1,659

Tomas Pluskal

02/09/2012 03:13AM

Re: Strange performance results with JOIN/COUNT

1,589

irek kordirko

02/11/2012 02:53AM

Re: Strange performance results with JOIN/COUNT

1,243

Tomas Pluskal

02/12/2012 06:44PM

Strange performance with JOIN/COUNT

3,211

Tomas Pluskal

02/09/2012 12:30AM

Re: Strange performance with JOIN/COUNT

1,358

Rick James

02/11/2012 11:11PM

Why MySQL does not use an index?

3,318

Panayotis Matsinopoulos

01/16/2012 02:50AM

Re: Why MySQL does not use an index?

1,483

Rick James

01/19/2012 12:25AM

Re: Why MySQL does not use an index?

1,586

Panayotis Matsinopoulos

02/10/2012 01:21AM

Re: Why MySQL does not use an index?

1,497

Rick James

02/11/2012 10:48PM

Re: Why MySQL does not use an index?

1,353

irek kordirko

02/10/2012 09:50AM

MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)

3,320

Chris Ricks

02/02/2012 01:17AM

Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)

1,455

Chris Ricks

02/01/2012 07:33PM

Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)

1,326

Øystein Grøvlen

02/02/2012 03:58AM

Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)

1,395

Chris Ricks

02/02/2012 04:43AM

Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)

1,311

Rick James

02/03/2012 11:57PM

Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)

1,440

Chris Ricks

02/02/2012 03:06AM

running running running

2,654

paolo tome

01/30/2012 03:16AM

Re: running running running

1,432

Øystein Grøvlen

01/30/2012 02:39AM

Re: running running running

1,177

paolo tome

01/30/2012 09:13AM

Re: running running running

1,188

paolo tome

01/31/2012 05:44AM

Re: running running running

1,292

Øystein Grøvlen

01/31/2012 07:54AM

Re: running running running

1,471

paolo tome

01/31/2012 03:10AM

Re: running running running

1,372

Ole John Aske

01/31/2012 05:00PM

How to avoid filesort in ORDER BY?

5,506

Andy S

01/26/2012 10:58PM

Re: How to avoid filesort in ORDER BY?

2,174

irek kordirko

01/27/2012 08:20AM

avoid filesort

2,213

01/22/2012 01:08PM

Re: avoid filesort

1,356

Rick James

01/24/2012 01:17AM

Re: avoid filesort

1,499

01/24/2012 04:36PM

Re: avoid filesort

1,385

Rick James

01/25/2012 08:26PM

Re: avoid filesort

1,362

01/26/2012 04:56AM

Re: avoid filesort

1,593

irek kordirko

01/25/2012 07:24PM

Re: avoid filesort

1,404

01/26/2012 04:57AM

Simple 1-table query taking WAY to long.....

2,065

Jason Moore

01/23/2012 02:31AM

Re: Simple 1-table query taking WAY to long.....

1,295

Rick James

01/24/2012 01:09AM

want to make this query faster, but not sure how

2,795

Luc Foisy

01/19/2012 09:55AM

Re: want to make this query faster, but not sure how

1,437

irek kordirko

01/19/2012 05:39PM

Re: want to make this query faster, but not sure how

1,541

Luc Foisy

01/20/2012 10:51AM

Re: want to make this query faster, but not sure how

1,148

Luc Foisy

01/19/2012 10:12AM

Re: want to make this query faster, but not sure how

1,148

Luc Foisy

01/19/2012 10:29AM

MySQL 5.6: Optimizer Tracing

1,810

Edwin DeSouza

01/19/2012 12:07PM

Query no longer uses index, takes much longer to run

2,553

Richard Cunningham

01/09/2012 12:36PM

Re: Query no longer uses index, takes much longer to run

1,154

Jørgen Løland

01/10/2012 01:43PM

Re: Query no longer uses index, takes much longer to run

1,195

Richard Cunningham

01/10/2012 03:54PM

Weird issue with join buffer (Performance suffers)

2,346

Ozgur Orhan

01/10/2012 01:54AM

Re: Weird issue with join buffer (Performance suffers)

1,753

Jørgen Løland

01/10/2012 01:37PM

Problem with a query performance

3,532

V Pode

01/04/2012 01:43PM

Re: Problem with a query performance

1,471

Rick James

01/05/2012 10:41AM

Re: Problem with a query performance

1,386

V Pode

01/06/2012 12:36PM

Re: Problem with a query performance

1,422

Rick James

01/07/2012 10:52AM

index not used when join condition added

3,147

Daniel Walter

01/02/2012 11:55AM

Re: index not used when join condition added

1,464

Rick James

01/03/2012 08:42PM

Re: index not used when join condition added

1,488

Daniel Walter

01/03/2012 09:49PM

Re: index not used when join condition added

1,954

Rick James

01/04/2012 06:26PM

Re: index not used when join condition added

1,430

Daniel Walter

01/04/2012 07:21PM

Re: index not used when join condition added

1,298

Rick James

01/04/2012 06:28PM

Primary key index with a DATETIME as first part of the compound key is never used

5,912

jeremy cohen solal

12/30/2011 08:10AM

Re: Primary key index with a DATETIME as first part of the compound key is never used

2,138

Rick James

01/02/2012 09:06PM

help me, optimize a long running query

3,421

h ch

10/25/2011 12:00AM

Re: help me, optimize a long running query

1,392

Massimo Brignoli

10/26/2011 06:48AM

Re: help me, optimize a long running query

1,377

h ch

10/27/2011 12:39AM

Re: help me, optimize a long running query

1,467

Rick James

10/27/2011 09:04PM

Re: help me, optimize a long running query

1,770

h ch

12/26/2011 11:52PM

Re: help me, optimize a long running query

1,268

Rick James

12/27/2011 10:00PM

SELECT counter

2,536

Root Tr

12/17/2011 01:24PM

Re: SELECT counter

1,214

Jørgen Løland

12/19/2011 06:57AM

Strange behavior with a strange request

2,526

Julien Palard

12/08/2011 05:03AM

Re: Strange behavior with a strange request

1,239

Rick James

12/10/2011 11:37PM

Re: Strange behavior with a strange request

1,277

Julien Palard

12/12/2011 09:01AM

left outer join performance

4,324

Michael Shavlovsky

11/28/2011 09:58PM

Re: left outer join performance

1,639

Michael Shavlovsky

11/28/2011 11:10PM

Re: left outer join performance

1,534

Rick James

11/29/2011 09:27PM

Join without duplicates

4,382

Jamie M

11/28/2011 11:22AM

Re: Join without duplicates

1,424

Jørgen Løland

11/28/2011 02:39PM

Re: Join without duplicates

1,789

Jamie M

11/29/2011 04:19AM

Re: Join without duplicates

1,936

Jørgen Løland

11/29/2011 02:58PM

Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?

2,673

WeiQi Huang

11/27/2011 05:18AM

Re: Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?

1,288

Øystein Grøvlen

11/29/2011 03:19AM

Re: Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?

1,200

Rick James

11/28/2011 11:06AM

Need to increase packet size in MySQL

2,906

Ashvin Ravi Shankar

11/25/2011 12:08AM

Re: Need to increase packet size in MySQL

1,471

Rick James

11/26/2011 08:53AM

Executing same query in 1 moment

2,818

Brano Gerzo

11/19/2011 09:27AM

Re: Executing same query in 1 moment

1,368

Rick James

11/20/2011 04:42PM

Re: Executing same query in 1 moment

1,295

Brano Gerzo

11/21/2011 12:42AM

Re: Executing same query in 1 moment

1,410

Brano Gerzo

11/20/2011 10:31PM

Re: Executing same query in 1 moment

1,245

Rick James

11/22/2011 12:05AM

Slow LEFT JOIN!

3,595

Sasha Mitich

11/18/2011 04:18AM

Re: Slow LEFT JOIN!

1,253

Rick James

11/19/2011 12:42AM

table join optimize help!

2,471

kelvin chou

11/14/2011 01:10AM

Re: table join optimize help!

1,114

Rick James

11/14/2011 09:24PM

Re: table join optimize help!

1,405

kelvin chou

11/16/2011 01:20AM

Re: table join optimize help!

1,156

Rick James

11/16/2011 09:41PM

Re: table join optimize help!

1,265

kelvin chou

11/18/2011 01:18AM

help~the statement don't use index

2,568

kelvin chou

11/08/2011 01:54AM

Re: help~the statement don't use index

1,524

Øystein Grøvlen

11/08/2011 09:31AM

Re: help~the statement don't use index

1,224

kelvin chou

11/08/2011 09:11PM

How to optimize group by and where

2,408

Eric Colson

11/06/2011 01:36AM

Re: How to optimize group by and where

1,292

Jørgen Løland

11/07/2011 07:06AM

Optimize Query for ndb 7.2.1....

3,034

Mohammed Munazir Ul Hasan

10/18/2011 01:21AM

Re: Optimize Query for ndb 7.2.1....

1,266

Ole John Aske

10/26/2011 08:40AM

Re: Optimize Query for ndb 7.2.1....

1,226

Massimo Brignoli

10/26/2011 06:46AM

Re: Optimize Query for ndb 7.2.1....

1,075

Mat Keep

10/26/2011 03:35AM

not optimizing the table after index is created

3,344

ragen sol

10/15/2011 04:04AM

Re: not optimizing the table after index is created

1,731

Rick James

10/16/2011 11:02AM

Re: not optimizing the table after index is created

1,341

ragen sol

10/18/2011 04:24AM

Re: not optimizing the table after index is created

1,212

Rick James

10/18/2011 09:31PM

Re: not optimizing the table after index is created

1,222

ragen sol

10/20/2011 12:10AM

Re: not optimizing the table after index is created

1,376

Rick James

10/20/2011 09:30PM

Optimize Query

2,016

Mohammed Munazir Ul Hasan

10/18/2011 01:25AM

Re: Optimize Query

1,179

Øystein Grøvlen

10/20/2011 12:46AM

optimize query -- need help

2,545

Mohammed Munazir Ul Hasan

10/15/2011 04:44AM

Re: optimize query -- need help

1,124

Rick James

10/16/2011 10:58AM

Re: optimize query -- need help

1,136

Mohammed Munazir Ul Hasan

10/17/2011 11:33PM

Re: optimize query -- need help

1,160

Rick James

10/18/2011 10:42PM

Query optimization for slow query

2,053

Mohammed Munazir Ul Hasan

10/15/2011 03:03AM

optimize query

1,702

Mohammed Munazir Ul Hasan

10/15/2011 01:13AM

GROUP BY ,ORDER BY optimization help

4,000

10/06/2011 09:31AM

Re: GROUP BY ,ORDER BY optimization help

1,678

Rick James

10/07/2011 11:54AM

Re: GROUP BY ,ORDER BY optimization help

1,605

10/08/2011 03:41AM

Re: GROUP BY ,ORDER BY optimization help

1,784

Rick James

10/09/2011 08:58PM

Re: GROUP BY ,ORDER BY optimization help

1,412

10/10/2011 09:22AM

Re: GROUP BY ,ORDER BY optimization help

2,031

Rick James

10/11/2011 05:36PM

Re: GROUP BY ,ORDER BY optimization help

1,231

10/12/2011 10:43AM

Explain plan--join type

3,089

Amy Ng

10/05/2011 11:10PM

Re: Explain plan--join type

1,380

Jørgen Løland

10/07/2011 12:41AM

MySQL Optimizer: new EXPLAIN for data-modifiers

2,264

Edwin DeSouza

10/04/2011 12:54PM

MySQL Batched Key Access Speeds Up Disk-Bound Join Queries

2,158

Edwin DeSouza

10/04/2011 10:52AM

MySQL Optimizer tracing: Query Execution Plan descriptions beyond EXPLAIN

2,081

Edwin DeSouza

10/04/2011 08:54AM

MySQL: Killer response time for non-overlapping intervals

1,906

Edwin DeSouza

09/27/2011 01:55PM

Mysql using 95% of cpu

3,812

Hitesh Rank

07/21/2011 08:57AM

Re: Mysql using 95% of cpu

1,251

Duncan Cox

09/22/2011 06:11AM

Re: Mysql using 95% of cpu

1,558

Rick James

09/23/2011 09:14AM

Re: Mysql using 95% of cpu

1,288

Rick James

07/22/2011 07:33PM

not able to use index, seems optimizer forces not to use index,

2,951

yi li

09/21/2011 08:08AM

Re: not able to use index, seems optimizer forces not to use index,

1,269

Rick James

09/22/2011 03:30PM

Re: not able to use index, seems optimizer forces not to use index,

1,194

Øystein Grøvlen

09/22/2011 01:24AM

Query Optimisation of a slow query

4,227

Gaurav Bhuyan

09/13/2011 03:26AM

Re: Query Optimisation of a slow query

1,635

Rick James

09/16/2011 10:21PM

Re: Query Optimisation of a slow query

1,315

Gaurav Bhuyan

09/20/2011 01:51AM

Re: Query Optimisation of a slow query

1,531

Gaurav Bhuyan

09/19/2011 01:01AM

Re: Query Optimisation of a slow query

1,436

Rick James

09/20/2011 09:20PM

Re: Query Optimisation of a slow query

1,389

Gaurav Bhuyan

09/21/2011 02:38AM

Re: Query Optimisation of a slow query

1,338

Rick James

09/22/2011 12:03AM

Re: Query Optimisation of a slow query

1,336

Gaurav Bhuyan

09/21/2011 12:21AM

Close conections

4,241

Mihai Claudiu

07/31/2011 10:16AM

Re: Close conections

1,926

Rick James

08/08/2011 08:51AM

Re: Close conections

1,473

Mihai Claudiu

09/17/2011 02:18PM

Re: Close conections

1,436

Rick James

09/18/2011 12:54PM

Re: Close conections

1,435

Mihai Claudiu

09/18/2011 02:48PM

Re: Close conections

1,490

Rick James

09/19/2011 07:23PM

Re: Close conections

1,354

Mihai Claudiu

09/20/2011 05:40AM

Re: Close conections

1,660

Rick James

09/21/2011 11:37PM

Pages:

« 1

...

4 5 6 7 8

...

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.