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

...

4 5 6 7 8

...

19 »

Subject

Views

Written By

Posted

Queries using JOIN and ORDER BY LIMIT

20,263

Nikita Dubrovsky

03/10/2012 01:11PM

Re: Queries using JOIN and ORDER BY LIMIT

2,852

irek kordirko

03/12/2012 06:18PM

Re: Queries using JOIN and ORDER BY LIMIT

2,709

Rick James

03/13/2012 11:07PM

Re: Queries using JOIN and ORDER BY LIMIT

2,764

Nikita Dubrovsky

03/14/2012 08:45AM

Re: Queries using JOIN and ORDER BY LIMIT

2,684

Rick James

03/15/2012 10:50AM

Obfuscate Functions and Procedures

2,298

Tremal Naik

03/12/2012 05:00AM

Re: Obfuscate Functions and Procedures

1,574

Rick James

03/13/2012 10:46PM

Group by not using index

2,614

Matthew Moles

03/02/2012 10:06AM

Re: Group by not using index

1,340

Rick James

03/04/2012 10:59PM

Re: Group by not using index

1,249

Matthew Moles

03/05/2012 03:57AM

Re: Group by not using index

1,197

irek kordirko

03/03/2012 05:22PM

Optimizing query

2,322

Marko Kupusic

02/24/2012 06:07AM

Re: Optimizing query

1,254

Rick James

02/25/2012 05:54PM

Re: Optimizing query

1,181

Marko Kupusic

02/27/2012 06:04AM

Re: Optimizing query

1,267

Rick James

02/28/2012 07:57PM

Re: Optimizing query

1,169

Ole John Aske

02/25/2012 03:49AM

Re: Optimizing query

1,523

Marko Kupusic

02/27/2012 05:57AM

Re: Optimizing query

1,302

Scott Nemes

02/24/2012 01:16PM

how to optimise query for 10+ millions records

3,085

Azhar Rahi

02/09/2012 03:30AM

Re: how to optimise query for 10+ millions records

1,762

irek kordirko

02/09/2012 05:31AM

Re: how to optimise query for 10+ millions records

1,430

Azhar Rahi

02/09/2012 05:38AM

Re: how to optimise query for 10+ millions records

1,348

irek kordirko

02/09/2012 05:58PM

Re: how to optimise query for 10+ millions records

1,307

Rick James

02/11/2012 11:26PM

Re: how to optimise query for 10+ millions records

1,565

Azhar Rahi

02/12/2012 10:12PM

Re: how to optimise query for 10+ millions records

1,420

irek kordirko

02/13/2012 02:18PM

Re: how to optimise query for 10+ millions records

1,638

Azhar Rahi

02/14/2012 02:33AM

Re: how to optimise query for 10+ millions records

1,443

irek kordirko

02/14/2012 07:24AM

Re: how to optimise query for 10+ millions records

1,449

Rick James

02/15/2012 07:30AM

Re: how to optimise query for 10+ millions records

1,891

Azhar Rahi

02/16/2012 03:54AM

Re: how to optimise query for 10+ millions records

1,332

Rick James

02/17/2012 01:20AM

Re: how to optimise query for 10+ millions records

1,279

Azhar Rahi

02/17/2012 03:57PM

Re: how to optimise query for 10+ millions records

1,577

irek kordirko

02/17/2012 05:12PM

Re: how to optimise query for 10+ millions records

1,373

Azhar Rahi

02/20/2012 02:21AM

Re: how to optimise query for 10+ millions records

1,387

Rick James

02/18/2012 07:18AM

Re: how to optimise query for 10+ millions records

1,428

Azhar Rahi

02/21/2012 03:25AM

Re: how to optimise query for 10+ millions records

1,438

Rick James

02/24/2012 10:45AM

Join

2,289

johne doe

02/01/2012 06:51AM

Re: Join Query Performance Problme

1,225

Rick James

02/03/2012 10:18AM

Re: Join Query Performance Problme

1,263

irek kordirko

02/01/2012 11:14AM

Re: Join Query Performance Problme

1,257

johne doe

02/02/2012 12:39AM

Re: Join Query Performance Problme

1,236

johne doe

02/02/2012 06:47AM

Re: Join Query Performance Problme

1,285

irek kordirko

02/02/2012 07:02PM

Re: Join Query Performance Problme

1,216

johne doe

02/03/2012 12:29AM

Re: Join Query Performance Problme

1,475

irek kordirko

02/03/2012 11:27AM

Re: Join Query Performance Problme

1,289

Rick James

02/04/2012 10:39AM

Re: Join Query Performance Problme

1,423

johne doe

02/14/2012 06:08PM

Re: Join Query Performance Problme

1,247

johne doe

02/06/2012 06:13AM

query cost calculations

4,171

Silpa Majeti

02/11/2012 04:01AM

Re: query cost calculations

1,517

Øystein Grøvlen

02/13/2012 07:13PM

Re: query cost calculations

1,675

Rick James

02/12/2012 01:03PM

Strange performance results with JOIN/COUNT

2,517

Tomas Pluskal

02/08/2012 06:25PM

Re: Strange performance results with JOIN/COUNT

1,194

Øystein Grøvlen

02/09/2012 03:01AM

Re: Strange performance results with JOIN/COUNT

1,583

Tomas Pluskal

02/09/2012 03:13AM

Re: Strange performance results with JOIN/COUNT

1,508

irek kordirko

02/11/2012 02:53AM

Re: Strange performance results with JOIN/COUNT

1,169

Tomas Pluskal

02/12/2012 06:44PM

Strange performance with JOIN/COUNT

3,001

Tomas Pluskal

02/09/2012 12:30AM

Re: Strange performance with JOIN/COUNT

1,252

Rick James

02/11/2012 11:11PM

Why MySQL does not use an index?

3,083

Panayotis Matsinopoulos

01/16/2012 02:50AM

Re: Why MySQL does not use an index?

1,406

Rick James

01/19/2012 12:25AM

Re: Why MySQL does not use an index?

1,496

Panayotis Matsinopoulos

02/10/2012 01:21AM

Re: Why MySQL does not use an index?

1,414

Rick James

02/11/2012 10:48PM

Re: Why MySQL does not use an index?

1,272

irek kordirko

02/10/2012 09:50AM

MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)

3,108

Chris Ricks

02/02/2012 01:17AM

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

1,323

Chris Ricks

02/01/2012 07:33PM

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

1,243

Øystein Grøvlen

02/02/2012 03:58AM

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

1,284

Chris Ricks

02/02/2012 04:43AM

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

1,229

Rick James

02/03/2012 11:57PM

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

1,342

Chris Ricks

02/02/2012 03:06AM

running running running

2,369

paolo tome

01/30/2012 03:16AM

Re: running running running

1,315

Øystein Grøvlen

01/30/2012 02:39AM

Re: running running running

1,099

paolo tome

01/30/2012 09:13AM

Re: running running running

1,078

paolo tome

01/31/2012 05:44AM

Re: running running running

1,190

Øystein Grøvlen

01/31/2012 07:54AM

Re: running running running

1,331

paolo tome

01/31/2012 03:10AM

Re: running running running

1,278

Ole John Aske

01/31/2012 05:00PM

How to avoid filesort in ORDER BY?

4,558

Andy S

01/26/2012 10:58PM

Re: How to avoid filesort in ORDER BY?

2,016

irek kordirko

01/27/2012 08:20AM

avoid filesort

2,035

01/22/2012 01:08PM

Re: avoid filesort

1,282

Rick James

01/24/2012 01:17AM

Re: avoid filesort

1,399

01/24/2012 04:36PM

Re: avoid filesort

1,298

Rick James

01/25/2012 08:26PM

Re: avoid filesort

1,273

01/26/2012 04:56AM

Re: avoid filesort

1,517

irek kordirko

01/25/2012 07:24PM

Re: avoid filesort

1,321

01/26/2012 04:57AM

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

1,903

Jason Moore

01/23/2012 02:31AM

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

1,197

Rick James

01/24/2012 01:09AM

want to make this query faster, but not sure how

2,611

Luc Foisy

01/19/2012 09:55AM

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

1,350

irek kordirko

01/19/2012 05:39PM

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

1,461

Luc Foisy

01/20/2012 10:51AM

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

1,052

Luc Foisy

01/19/2012 10:12AM

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

1,046

Luc Foisy

01/19/2012 10:29AM

MySQL 5.6: Optimizer Tracing

1,660

Edwin DeSouza

01/19/2012 12:07PM

Query no longer uses index, takes much longer to run

2,404

Richard Cunningham

01/09/2012 12:36PM

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

1,060

Jørgen Løland

01/10/2012 01:43PM

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

1,124

Richard Cunningham

01/10/2012 03:54PM

Weird issue with join buffer (Performance suffers)

2,188

Ozgur Orhan

01/10/2012 01:54AM

Re: Weird issue with join buffer (Performance suffers)

1,642

Jørgen Løland

01/10/2012 01:37PM

Problem with a query performance

3,320

V Pode

01/04/2012 01:43PM

Re: Problem with a query performance

1,396

Rick James

01/05/2012 10:41AM

Re: Problem with a query performance

1,307

V Pode

01/06/2012 12:36PM

Re: Problem with a query performance

1,337

Rick James

01/07/2012 10:52AM

index not used when join condition added

2,912

Daniel Walter

01/02/2012 11:55AM

Re: index not used when join condition added

1,376

Rick James

01/03/2012 08:42PM

Re: index not used when join condition added

1,395

Daniel Walter

01/03/2012 09:49PM

Re: index not used when join condition added

1,816

Rick James

01/04/2012 06:26PM

Re: index not used when join condition added

1,343

Daniel Walter

01/04/2012 07:21PM

Re: index not used when join condition added

1,218

Rick James

01/04/2012 06:28PM

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

5,691

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

Rick James

01/02/2012 09:06PM

help me, optimize a long running query

3,211

h ch

10/25/2011 12:00AM

Re: help me, optimize a long running query

1,300

Massimo Brignoli

10/26/2011 06:48AM

Re: help me, optimize a long running query

1,285

h ch

10/27/2011 12:39AM

Re: help me, optimize a long running query

1,383

Rick James

10/27/2011 09:04PM

Re: help me, optimize a long running query

1,664

h ch

12/26/2011 11:52PM

Re: help me, optimize a long running query

1,159

Rick James

12/27/2011 10:00PM

SELECT counter

2,369

Root Tr

12/17/2011 01:24PM

Re: SELECT counter

1,146

Jørgen Løland

12/19/2011 06:57AM

Strange behavior with a strange request

2,329

Julien Palard

12/08/2011 05:03AM

Re: Strange behavior with a strange request

1,165

Rick James

12/10/2011 11:37PM

Re: Strange behavior with a strange request

1,208

Julien Palard

12/12/2011 09:01AM

left outer join performance

4,086

Michael Shavlovsky

11/28/2011 09:58PM

Re: left outer join performance

1,539

Michael Shavlovsky

11/28/2011 11:10PM

Re: left outer join performance

1,448

Rick James

11/29/2011 09:27PM

Join without duplicates

4,193

Jamie M

11/28/2011 11:22AM

Re: Join without duplicates

1,338

Jørgen Løland

11/28/2011 02:39PM

Re: Join without duplicates

1,661

Jamie M

11/29/2011 04:19AM

Re: Join without duplicates

1,851

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

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

Ø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,109

Rick James

11/28/2011 11:06AM

Need to increase packet size in MySQL

2,752

Ashvin Ravi Shankar

11/25/2011 12:08AM

Re: Need to increase packet size in MySQL

1,385

Rick James

11/26/2011 08:53AM

Executing same query in 1 moment

2,643

Brano Gerzo

11/19/2011 09:27AM

Re: Executing same query in 1 moment

1,263

Rick James

11/20/2011 04:42PM

Re: Executing same query in 1 moment

1,209

Brano Gerzo

11/21/2011 12:42AM

Re: Executing same query in 1 moment

1,281

Brano Gerzo

11/20/2011 10:31PM

Re: Executing same query in 1 moment

1,116

Rick James

11/22/2011 12:05AM

Slow LEFT JOIN!

3,379

Sasha Mitich

11/18/2011 04:18AM

Re: Slow LEFT JOIN!

1,191

Rick James

11/19/2011 12:42AM

table join optimize help!

2,269

kelvin chou

11/14/2011 01:10AM

Re: table join optimize help!

1,046

Rick James

11/14/2011 09:24PM

Re: table join optimize help!

1,332

kelvin chou

11/16/2011 01:20AM

Re: table join optimize help!

1,082

Rick James

11/16/2011 09:41PM

Re: table join optimize help!

1,168

kelvin chou

11/18/2011 01:18AM

help~the statement don't use index

2,389

kelvin chou

11/08/2011 01:54AM

Re: help~the statement don't use index

1,413

Øystein Grøvlen

11/08/2011 09:31AM

Re: help~the statement don't use index

1,132

kelvin chou

11/08/2011 09:11PM

How to optimize group by and where

2,256

Eric Colson

11/06/2011 01:36AM

Re: How to optimize group by and where

1,186

Jørgen Løland

11/07/2011 07:06AM

Optimize Query for ndb 7.2.1....

2,844

Mohammed Munazir Ul Hasan

10/18/2011 01:21AM

Re: Optimize Query for ndb 7.2.1....

1,194

Ole John Aske

10/26/2011 08:40AM

Re: Optimize Query for ndb 7.2.1....

1,136

Massimo Brignoli

10/26/2011 06:46AM

Re: Optimize Query for ndb 7.2.1....

1,019

Mat Keep

10/26/2011 03:35AM

not optimizing the table after index is created

3,144

ragen sol

10/15/2011 04:04AM

Re: not optimizing the table after index is created

1,633

Rick James

10/16/2011 11:02AM

Re: not optimizing the table after index is created

1,250

ragen sol

10/18/2011 04:24AM

Re: not optimizing the table after index is created

1,110

Rick James

10/18/2011 09:31PM

Re: not optimizing the table after index is created

1,117

ragen sol

10/20/2011 12:10AM

Re: not optimizing the table after index is created

1,282

Rick James

10/20/2011 09:30PM

Optimize Query

1,874

Mohammed Munazir Ul Hasan

10/18/2011 01:25AM

Re: Optimize Query

1,096

Øystein Grøvlen

10/20/2011 12:46AM

optimize query -- need help

2,372

Mohammed Munazir Ul Hasan

10/15/2011 04:44AM

Re: optimize query -- need help

1,046

Rick James

10/16/2011 10:58AM

Re: optimize query -- need help

1,065

Mohammed Munazir Ul Hasan

10/17/2011 11:33PM

Re: optimize query -- need help

1,058

Rick James

10/18/2011 10:42PM

Query optimization for slow query

1,911

Mohammed Munazir Ul Hasan

10/15/2011 03:03AM

optimize query

1,566

Mohammed Munazir Ul Hasan

10/15/2011 01:13AM

GROUP BY ,ORDER BY optimization help

3,771

10/06/2011 09:31AM

Re: GROUP BY ,ORDER BY optimization help

1,534

Rick James

10/07/2011 11:54AM

Re: GROUP BY ,ORDER BY optimization help

1,516

10/08/2011 03:41AM

Re: GROUP BY ,ORDER BY optimization help

1,696

Rick James

10/09/2011 08:58PM

Re: GROUP BY ,ORDER BY optimization help

1,321

10/10/2011 09:22AM

Re: GROUP BY ,ORDER BY optimization help

1,883

Rick James

10/11/2011 05:36PM

Re: GROUP BY ,ORDER BY optimization help

1,138

10/12/2011 10:43AM

Explain plan--join type

2,728

Amy Ng

10/05/2011 11:10PM

Re: Explain plan--join type

1,291

Jørgen Løland

10/07/2011 12:41AM

MySQL Optimizer: new EXPLAIN for data-modifiers

2,141

Edwin DeSouza

10/04/2011 12:54PM

MySQL Batched Key Access Speeds Up Disk-Bound Join Queries

2,020

Edwin DeSouza

10/04/2011 10:52AM

MySQL Optimizer tracing: Query Execution Plan descriptions beyond EXPLAIN

1,936

Edwin DeSouza

10/04/2011 08:54AM

MySQL: Killer response time for non-overlapping intervals

1,759

Edwin DeSouza

09/27/2011 01:55PM

Mysql using 95% of cpu

3,601

Hitesh Rank

07/21/2011 08:57AM

Re: Mysql using 95% of cpu

1,154

Duncan Cox

09/22/2011 06:11AM

Re: Mysql using 95% of cpu

1,436

Rick James

09/23/2011 09:14AM

Re: Mysql using 95% of cpu

1,220

Rick James

07/22/2011 07:33PM

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

2,669

yi li

09/21/2011 08:08AM

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

1,139

Rick James

09/22/2011 03:30PM

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

1,089

Øystein Grøvlen

09/22/2011 01:24AM

Query Optimisation of a slow query

4,025

Gaurav Bhuyan

09/13/2011 03:26AM

Re: Query Optimisation of a slow query

1,528

Rick James

09/16/2011 10:21PM

Re: Query Optimisation of a slow query

1,227

Gaurav Bhuyan

09/20/2011 01:51AM

Re: Query Optimisation of a slow query

1,427

Gaurav Bhuyan

09/19/2011 01:01AM

Re: Query Optimisation of a slow query

1,321

Rick James

09/20/2011 09:20PM

Re: Query Optimisation of a slow query

1,291

Gaurav Bhuyan

09/21/2011 02:38AM

Re: Query Optimisation of a slow query

1,235

Rick James

09/22/2011 12:03AM

Re: Query Optimisation of a slow query

1,233

Gaurav Bhuyan

09/21/2011 12:21AM

Close conections

3,894

Mihai Claudiu

07/31/2011 10:16AM

Re: Close conections

1,800

Rick James

08/08/2011 08:51AM

Re: Close conections

1,386

Mihai Claudiu

09/17/2011 02:18PM

Re: Close conections

1,317

Rick James

09/18/2011 12:54PM

Re: Close conections

1,334

Mihai Claudiu

09/18/2011 02:48PM

Re: Close conections

1,376

Rick James

09/19/2011 07:23PM

Re: Close conections

1,218

Mihai Claudiu

09/20/2011 05:40AM

Re: Close conections

1,499

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.