MySQL :: MySQL Forums :: Optimizer & Parser

New Topic

Pages:

« 1

...

3 4 5 6 7

...

18 »

Subject

Views

Written By

Posted

query cost calculations

3,340

Silpa Majeti

02/11/2012 04:01AM

Re: query cost calculations

1,187

Øystein Grøvlen

02/13/2012 07:13PM

Re: query cost calculations

1,328

Rick James

02/12/2012 01:03PM

Strange performance results with JOIN/COUNT

1,852

Tomas Pluskal

02/08/2012 06:25PM

Re: Strange performance results with JOIN/COUNT

897

Øystein Grøvlen

02/09/2012 03:01AM

Re: Strange performance results with JOIN/COUNT

1,243

Tomas Pluskal

02/09/2012 03:13AM

Re: Strange performance results with JOIN/COUNT

1,139

irek kordirko

02/11/2012 02:53AM

Re: Strange performance results with JOIN/COUNT

851

Tomas Pluskal

02/12/2012 06:44PM

Strange performance with JOIN/COUNT

1,956

Tomas Pluskal

02/09/2012 12:30AM

Re: Strange performance with JOIN/COUNT

897

Rick James

02/11/2012 11:11PM

Why MySQL does not use an index?

2,304

Panayotis Matsinopoulos

01/16/2012 02:50AM

Re: Why MySQL does not use an index?

1,033

Rick James

01/19/2012 12:25AM

Re: Why MySQL does not use an index?

1,119

Panayotis Matsinopoulos

02/10/2012 01:21AM

Re: Why MySQL does not use an index?

1,046

Rick James

02/11/2012 10:48PM

Re: Why MySQL does not use an index?

929

irek kordirko

02/10/2012 09:50AM

MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)

2,432

Chris Ricks

02/02/2012 01:17AM

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

953

Chris Ricks

02/01/2012 07:33PM

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

911

Øystein Grøvlen

02/02/2012 03:58AM

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

925

Chris Ricks

02/02/2012 04:43AM

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

886

Rick James

02/03/2012 11:57PM

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

1,022

Chris Ricks

02/02/2012 03:06AM

running running running

1,746

paolo tome

01/30/2012 03:16AM

Re: running running running

909

Øystein Grøvlen

01/30/2012 02:39AM

Re: running running running

806

paolo tome

01/30/2012 09:13AM

Re: running running running

741

paolo tome

01/31/2012 05:44AM

Re: running running running

859

Øystein Grøvlen

01/31/2012 07:54AM

Re: running running running

911

paolo tome

01/31/2012 03:10AM

Re: running running running

879

Ole John Aske

01/31/2012 05:00PM

How to avoid filesort in ORDER BY?

3,087

Andy S

01/26/2012 10:58PM

Re: How to avoid filesort in ORDER BY?

1,409

irek kordirko

01/27/2012 08:20AM

avoid filesort

1,558

Magnus Larsson

01/22/2012 01:08PM

Re: avoid filesort

921

Rick James

01/24/2012 01:17AM

Re: avoid filesort

1,031

Magnus Larsson

01/24/2012 04:36PM

Re: avoid filesort

961

Rick James

01/25/2012 08:26PM

Re: avoid filesort

942

Magnus Larsson

01/26/2012 04:56AM

Re: avoid filesort

1,131

irek kordirko

01/25/2012 07:24PM

Re: avoid filesort

984

Magnus Larsson

01/26/2012 04:57AM

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

1,405

Jason Moore

01/23/2012 02:31AM

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

908

Rick James

01/24/2012 01:09AM

want to make this query faster, but not sure how

1,995

Luc Foisy

01/19/2012 09:55AM

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

996

irek kordirko

01/19/2012 05:39PM

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

1,170

Luc Foisy

01/20/2012 10:51AM

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

756

Luc Foisy

01/19/2012 10:12AM

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

755

Luc Foisy

01/19/2012 10:29AM

MySQL 5.6: Optimizer Tracing

1,189

Edwin DeSouza

01/19/2012 12:07PM

Query no longer uses index, takes much longer to run

1,779

Richard Cunningham

01/09/2012 12:36PM

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

784

Jørgen Løland

01/10/2012 01:43PM

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

805

Richard Cunningham

01/10/2012 03:54PM

Weird issue with join buffer (Performance suffers)

1,640

Ozgur Orhan

01/10/2012 01:54AM

Re: Weird issue with join buffer (Performance suffers)

1,160

Jørgen Løland

01/10/2012 01:37PM

Problem with a query performance

2,443

V Pode

01/04/2012 01:43PM

Re: Problem with a query performance

1,042

Rick James

01/05/2012 10:41AM

Re: Problem with a query performance

980

V Pode

01/06/2012 12:36PM

Re: Problem with a query performance

974

Rick James

01/07/2012 10:52AM

index not used when join condition added

2,304

Daniel Walter

01/02/2012 11:55AM

Re: index not used when join condition added

1,026

Rick James

01/03/2012 08:42PM

Re: index not used when join condition added

1,018

Daniel Walter

01/03/2012 09:49PM

Re: index not used when join condition added

1,251

Rick James

01/04/2012 06:26PM

Re: index not used when join condition added

945

Daniel Walter

01/04/2012 07:21PM

Re: index not used when join condition added

895

Rick James

01/04/2012 06:28PM

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

4,084

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

1,373

Rick James

01/02/2012 09:06PM

help me, optimize a long running query

2,577

h ch

10/25/2011 12:00AM

Re: help me, optimize a long running query

990

Massimo Brignoli

10/26/2011 06:48AM

Re: help me, optimize a long running query

968

h ch

10/27/2011 12:39AM

Re: help me, optimize a long running query

1,012

Rick James

10/27/2011 09:04PM

Re: help me, optimize a long running query

1,290

h ch

12/26/2011 11:52PM

Re: help me, optimize a long running query

841

Rick James

12/27/2011 10:00PM

SELECT counter

1,895

Root Tr

12/17/2011 01:24PM

Re: SELECT counter

851

Jørgen Løland

12/19/2011 06:57AM

Strange behavior with a strange request

1,793

Julien Palard

12/08/2011 05:03AM

Re: Strange behavior with a strange request

841

Rick James

12/10/2011 11:37PM

Re: Strange behavior with a strange request

902

Julien Palard

12/12/2011 09:01AM

left outer join performance

3,289

Michael Shavlovsky

11/28/2011 09:58PM

Re: left outer join performance

1,203

Michael Shavlovsky

11/28/2011 11:10PM

Re: left outer join performance

1,098

Rick James

11/29/2011 09:27PM

Join without duplicates

3,398

Jamie M

11/28/2011 11:22AM

Re: Join without duplicates

969

Jørgen Løland

11/28/2011 02:39PM

Re: Join without duplicates

1,265

Jamie M

11/29/2011 04:19AM

Re: Join without duplicates

1,463

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?

1,754

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?

835

Ø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?

757

Rick James

11/28/2011 11:06AM

Need to increase packet size in MySQL

2,166

Ashvin Ravi Shankar

11/25/2011 12:08AM

Re: Need to increase packet size in MySQL

1,030

Rick James

11/26/2011 08:53AM

Executing same query in 1 moment

2,050

Brano Gerzo

11/19/2011 09:27AM

Re: Executing same query in 1 moment

864

Rick James

11/20/2011 04:42PM

Re: Executing same query in 1 moment

892

Brano Gerzo

11/21/2011 12:42AM

Re: Executing same query in 1 moment

899

Brano Gerzo

11/20/2011 10:31PM

Re: Executing same query in 1 moment

800

Rick James

11/22/2011 12:05AM

Slow LEFT JOIN!

2,678

Sasha Mitich

11/18/2011 04:18AM

Re: Slow LEFT JOIN!

900

Rick James

11/19/2011 12:42AM

table join optimize help!

1,594

kelvin chou

11/14/2011 01:10AM

Re: table join optimize help!

757

Rick James

11/14/2011 09:24PM

Re: table join optimize help!

854

kelvin chou

11/16/2011 01:20AM

Re: table join optimize help!

779

Rick James

11/16/2011 09:41PM

Re: table join optimize help!

829

kelvin chou

11/18/2011 01:18AM

help~the statement don't use index

1,810

kelvin chou

11/08/2011 01:54AM

Re: help~the statement don't use index

1,086

Øystein Grøvlen

11/08/2011 09:31AM

Re: help~the statement don't use index

795

kelvin chou

11/08/2011 09:11PM

How to optimize group by and where

1,708

Eric Colson

11/06/2011 01:36AM

Re: How to optimize group by and where

836

Jørgen Løland

11/07/2011 07:06AM

Optimize Query for ndb 7.2.1....

2,355

Mohammed Munazir Ul Hasan

10/18/2011 01:21AM

Re: Optimize Query for ndb 7.2.1....

905

Ole John Aske

10/26/2011 08:40AM

Re: Optimize Query for ndb 7.2.1....

811

Massimo Brignoli

10/26/2011 06:46AM

Re: Optimize Query for ndb 7.2.1....

752

Mat Keep

10/26/2011 03:35AM

not optimizing the table after index is created

2,611

ragen sol

10/15/2011 04:04AM

Re: not optimizing the table after index is created

1,281

Rick James

10/16/2011 11:02AM

Re: not optimizing the table after index is created

930

ragen sol

10/18/2011 04:24AM

Re: not optimizing the table after index is created

810

Rick James

10/18/2011 09:31PM

Re: not optimizing the table after index is created

841

ragen sol

10/20/2011 12:10AM

Re: not optimizing the table after index is created

999

Rick James

10/20/2011 09:30PM

Optimize Query

1,388

Mohammed Munazir Ul Hasan

10/18/2011 01:25AM

Re: Optimize Query

773

Øystein Grøvlen

10/20/2011 12:46AM

optimize query -- need help

1,838

Mohammed Munazir Ul Hasan

10/15/2011 04:44AM

Re: optimize query -- need help

735

Rick James

10/16/2011 10:58AM

Re: optimize query -- need help

756

Mohammed Munazir Ul Hasan

10/17/2011 11:33PM

Re: optimize query -- need help

727

Rick James

10/18/2011 10:42PM

Query optimization for slow query

1,356

Mohammed Munazir Ul Hasan

10/15/2011 03:03AM

optimize query

1,111

Mohammed Munazir Ul Hasan

10/15/2011 01:13AM

GROUP BY ,ORDER BY optimization help

2,915

Ciobanu MArius

10/06/2011 09:31AM

Re: GROUP BY ,ORDER BY optimization help

1,192

Rick James

10/07/2011 11:54AM

Re: GROUP BY ,ORDER BY optimization help

1,091

Ciobanu MArius

10/08/2011 03:41AM

Re: GROUP BY ,ORDER BY optimization help

1,316

Rick James

10/09/2011 08:58PM

Re: GROUP BY ,ORDER BY optimization help

970

Ciobanu MArius

10/10/2011 09:22AM

Re: GROUP BY ,ORDER BY optimization help

1,480

Rick James

10/11/2011 05:36PM

Re: GROUP BY ,ORDER BY optimization help

850

Ciobanu MArius

10/12/2011 10:43AM

Explain plan--join type

2,202

Amy Ng

10/05/2011 11:10PM

Re: Explain plan--join type

928

Jørgen Løland

10/07/2011 12:41AM

MySQL Optimizer: new EXPLAIN for data-modifiers

1,633

Edwin DeSouza

10/04/2011 12:54PM

MySQL Batched Key Access Speeds Up Disk-Bound Join Queries

1,512

Edwin DeSouza

10/04/2011 10:52AM

MySQL Optimizer tracing: Query Execution Plan descriptions beyond EXPLAIN

1,503

Edwin DeSouza

10/04/2011 08:54AM

MySQL: Killer response time for non-overlapping intervals

1,343

Edwin DeSouza

09/27/2011 01:55PM

Mysql using 95% of cpu

2,816

Hitesh Rank

07/21/2011 08:57AM

Re: Mysql using 95% of cpu

856

Duncan Cox

09/22/2011 06:11AM

Re: Mysql using 95% of cpu

1,108

Rick James

09/23/2011 09:14AM

Re: Mysql using 95% of cpu

927

Rick James

07/22/2011 07:33PM

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

2,047

yi li

09/21/2011 08:08AM

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

829

Rick James

09/22/2011 03:30PM

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

773

Øystein Grøvlen

09/22/2011 01:24AM

Query Optimisation of a slow query

3,275

Gaurav Bhuyan

09/13/2011 03:26AM