MySQL :: MySQL Forums :: Optimizer & Parser

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 2 3 4 5

...

19 »

Subject

Views

Written By

Posted

Sticky: MySQL: New JSON format for EXPLAIN (1 Posts)

532

Edwin Desouza

11/04/2024 10:22AM

Sticky: MySQL: EXPLAIN INTO and EXPLAIN FOR SCHEMA (1 Posts)

737

Edwin Desouza

11/24/2023 12:34PM

Sticky: MySQL 8.0: Hash Join and EXPLAIN ANALYZE (1 Posts)

2,029

Edwin Desouza

10/01/2019 05:40PM

Sticky: MySQL 8.0: One Giant Leap For SQL (1 Posts)

1,733

Edwin Desouza

04/25/2018 10:16AM

Sticky: Unofficial MySQL 8.0 Optimizer Guide (1 Posts)

2,121

Edwin Desouza

02/13/2017 04:16PM

Sticky: MySQL 8.0: Window Functions (1 Posts)

2,272

Edwin Desouza

02/04/2017 08:57PM

Sticky: MySQL 8.0: CTEs (1 Posts)

4,497

Edwin Desouza

10/18/2016 09:38AM

Sticky: MySQL 8.0: Optimizer & Parser (1 Posts)

2,946

Edwin Desouza

09/13/2016 10:54AM

Sticky: MySQL Performance Tuning (1 Posts)

3,182

Edwin Desouza

07/06/2015 10:37AM

Sticky: MySQL Parser (1 Posts)

4,118

Edwin Desouza

04/03/2014 03:31PM

Sticky: MySQL Optimizer: Features in MySQL 5.7 (1 Posts)

5,257

Edwin Desouza

12/18/2012 11:38AM

Sticky: MySQL EXPLAIN (1 Posts)

5,666

Edwin Desouza

07/10/2012 10:32AM

Sticky: MySQL Optimizer: Blogs (1 Posts)

11,603

Edwin DeSouza

04/28/2007 06:20PM

MySQL EXPLAIN ANALYZE

811

Edwin Desouza

08/09/2023 05:43PM

MySQL Deferred Join: A Deep Dive

886

Edwin Desouza

08/09/2023 05:28PM

Why multi-valued index is not in possible keys in a dependent subquery

874

ELON ZHOU

02/02/2023 10:01PM

MySQL Hypergraph Optimizer for HeatWave

881

Edwin Desouza

01/17/2023 09:20AM

what does explain ref const, const means ?

1,070

jongse park

11/23/2022 12:00AM

Set Theory in MySQL 8.0: UNION and Now INTERSECT and EXCEPT

954

Edwin Desouza

11/02/2022 10:25AM

Plugin For Obtaining Tokenized Query

908

JustADude Tester

10/19/2022 08:23AM

Startup was very slow

1,668

Charles Rodrigues Rimiru

01/27/2022 07:53AM

Re: Startup was very slow

676

Peter Brawley

02/28/2022 11:14AM

Re: Startup was very slow

768

Charles Rodrigues Rimiru

03/02/2022 08:58AM

Re: Startup was very slow

776

Peter Brawley

03/02/2022 10:58AM

Re: Startup was very slow

776

Charles Rodrigues Rimiru

03/02/2022 01:57PM

Re: Startup was very slow

540

Charles Rodrigues

10/09/2022 09:24AM

Why MySQL adding 1 when calculating the records per key?

789

ffc ddd

09/24/2022 07:16PM

Why MySQL adding 1 when calculating the records per key?

813

ffc ddd

09/24/2022 07:10PM

MYSQL5.7:OPTIMIZER Contradict Explain

1,074

yijie fu

09/07/2022 05:02AM

Re: MYSQL5.7:OPTIMIZER Contradict Explain

619

yijie fu

09/07/2022 05:26AM

Need help with getting rid of filesort

1,456

Marvin Herbold

06/23/2022 01:53PM

Re: Need help with getting rid of filesort

627

Peter Brawley

06/24/2022 09:59AM

MySQL 8.0 EXPLAIN ANALYZE

2,006

Edwin Desouza

02/27/2022 10:37PM

Optimizer in 8.0 in some cases not materializing subquery

3,146

Benjamin Peikes

01/24/2022 03:37PM

Re: Optimizer in 8.0 in some cases not materializing subquery

652

Peter Brawley

01/24/2022 04:45PM

Running sql in server is too much slower then laptop

1,409

Shanxiang MAO

10/25/2021 02:49AM

Re: Running sql in server is too much slower then laptop

679

Peter Brawley

10/25/2021 09:50AM

Re: Running sql in server is too much slower then laptop

622

Herems Jing

11/13/2021 07:59PM

Re: Running sql in server is too much slower then laptop

662

Peter Brawley

11/13/2021 09:21PM

Query optimization on LIKE

1,276

Sing Lau

10/04/2021 12:08PM

Re: Query optimization on LIKE

719

Peter Brawley

10/04/2021 01:08PM

Multi-valued index is not in possible keys when there is a subquery

1,641

Jinlin Yang

07/22/2021 07:18PM

Re: Multi-valued index is not in possible keys when there is a subquery

693

Peter Brawley

10/04/2021 12:55PM

Run ANALYZE TABLE — Do Not Rely on InnoDB's Automatic Recalculation of Statistics

1,257

Edwin Desouza

09/08/2021 09:52AM

MySQL: EXPLAINing the Different EXPLAINS

1,160

Edwin Desouza

08/19/2021 02:57PM

Disable caching in MYSQL for True performance testings?

2,575

Sing Lau

07/11/2021 02:47PM

Re: Disable caching in MYSQL for True performance testings?

929

Peter Brawley

07/11/2021 05:21PM

Documentation regarding operator precedence incorrect for LIKE, REGEXP, IN?

1,577

Justin Ng

06/12/2021 01:29PM

How to optimizate COUNT query with multiple LEFT JOIN

2,274

Ivan Stoqnov

06/01/2021 01:19AM

Re: How to optimizate COUNT query with multiple LEFT JOIN

721

Ivan Stoqnov

06/01/2021 01:31AM

Re: How to optimizate COUNT query with multiple LEFT JOIN

788

Peter Brawley

06/01/2021 12:19PM

Need help with tracing how identifiers are parsed; dot-reserved vs dot-space-reserved

1,363

Justin Ng

05/25/2021 05:28AM

Re: Need help with tracing how identifiers are parsed; dot-reserved vs dot-space-reserved

730

Justin Ng

05/25/2021 06:21AM

MySQL Invisible Column

1,302

Edwin Desouza

01/22/2021 01:48PM

mySQL 8 - view query not using outer predicate

1,764

Jack Crawford

01/11/2021 10:49AM

Re: mySQL 8 - view query not using outer predicate

735

Peter Brawley

01/11/2021 12:07PM

Re: mySQL 8 - view query not using outer predicate

781

Jack Crawford

01/11/2021 12:18PM

Re: mySQL 8 - view query not using outer predicate

791

Peter Brawley

01/11/2021 01:38PM

Re: mySQL 8 - view query not using outer predicate

782

Jack Crawford

01/11/2021 02:06PM

Re: mySQL 8 - view query not using outer predicate

689

Peter Brawley

01/11/2021 03:02PM

Re: mySQL 8 - view query not using outer predicate

782

Jack Crawford

01/11/2021 04:04PM

Re: mySQL 8 - view query not using outer predicate

744

Peter Brawley

01/11/2021 10:34PM

MySQL Comparing INTs and CHARs

1,221

Edwin Desouza

08/24/2020 02:56PM

MySQL 8.0 Indexes, Histograms, and Other Ways to Speed Up Your Queries

1,263

Edwin Desouza

08/04/2020 07:57PM

MySQL: Using SKIP LOCK For Queue Processing

1,541

Edwin Desouza

08/03/2020 10:00AM

MySQL 8.0: Modern approaches to replacing accumulation user-defined variable hacks, via Window functions and CTEs

1,350

Saverio Miroddi

06/16/2020 10:00AM

MySQL 8.0.20: Index-Level Optimizer Hints

1,357

Edwin Desouza

04/28/2020 09:04AM

Explain features

1,436

Michael Bialik

03/29/2020 01:29PM

Re: Explain features

840

Peter Brawley

03/29/2020 02:01PM

MySQL 8.0: using CTEs to generate Sequences/Ranges

1,253

Edwin Desouza

03/09/2020 01:23PM

MySQL 8.0: A must-know about NOT IN in SQL – more antijoin optimization

1,457

Edwin Desouza

02/28/2020 11:12AM

msqldump only one row per minute from a 5 row/minute database

1,477

Adrian C

02/22/2020 12:38PM

Re: msqldump only one row per minute from a 5 row/minute database

811

Peter Brawley

02/22/2020 01:46PM

MySQL 8.0: EXPLAIN ANALYZE

1,325

Edwin Desouza

02/14/2020 11:29PM

Explain command type "All" issue

1,487

Vipin PA

02/14/2020 03:20AM

Re: Explain command type "All" issue

894

Peter Brawley

02/14/2020 10:28AM

Re: Explain command type "All" issue

847

Edwin Desouza

02/14/2020 05:52PM

Introduction to MySQL 8.0 CTEs (Part 1+2)

1,410

Edwin Desouza

02/13/2020 12:02PM

MySQL 8.0: Hash Join

2,066

Edwin Desouza

02/09/2020 05:09PM

MySQL 8.0: Simple way to figure out why your recursive CTE is running away

1,331

Edwin Desouza

01/15/2020 06:06AM

optimizer seems to skip stored function call in where clause?

1,583

John LeSueur

01/08/2020 11:07AM

Re: optimizer seems to skip stored function call in where clause?

1,024

John LeSueur

01/08/2020 11:21AM

Re: optimizer seems to skip stored function call in where clause?

805

John LeSueur

01/08/2020 11:44AM

Re: optimizer seems to skip stored function call in where clause?

927

Peter Brawley

01/08/2020 01:11PM

MySQL 8.0: AntiJoin

1,564

Edwin Desouza

12/18/2019 07:54AM

MySQL 8.0: Hash Join

1,479

Edwin Desouza

11/13/2019 12:36PM

MySQL 8.0: Understanding Hash Joins

1,258

Edwin Desouza

10/30/2019 11:06AM

Explain Analyze in MySQL 8

1,288

Edwin Desouza

10/28/2019 05:00PM

optimizing searches using aggregate data in join

1,679

Matthew Lenz

10/21/2019 09:05AM

Re: optimizing searches using aggregate data in join

868

Peter Brawley

10/21/2019 11:37AM

MySQL 8.0: EXPLAIN ANALYZE

1,466

Edwin Desouza

10/17/2019 07:15AM

MySQL 8.0.18 Maintenance Release is Generally Available

1,822

Edwin Desouza

10/14/2019 01:06PM

Slow Query

1,932

Deepak Nirmul

06/21/2019 04:47AM

Re: Slow Query

1,031

Peter Brawley

06/21/2019 10:17AM

Re: Slow Query

1,070

Deepak Nirmul

06/24/2019 02:18AM

Re: Slow Query

911

Peter Brawley

06/24/2019 09:56AM

Re: Slow Query

906

Deepak Nirmul

06/24/2019 10:15AM

Re: Slow Query

1,021

Peter Brawley

06/24/2019 10:45AM

Re: Slow Query

1,018

Gopal venkat

09/04/2019 11:47AM

Gopal, please don't hijack threads

952

Peter Brawley

09/04/2019 02:32PM

Re: Slow Query

857

marimuthu B

09/06/2019 05:59AM

Re: Slow Query

927

Peter Brawley

09/06/2019 09:57AM

MySQL 8.0: Supporting all kinds of outer references in derived tables (lateral, or not)

1,522

Edwin Desouza

07/12/2019 11:13AM

setting an index for speed

1,568

Michael Peters

07/02/2019 04:56AM

Re: setting an index for speed

885

Peter Brawley

07/02/2019 12:29PM

This topic has been moved.: optimizing searches using aggregate data in join

Matthew Lenz

10/21/2019 11:06AM

This topic has been moved.: setting an index for speed

Michael Peters

07/02/2019 12:26PM

This topic has been moved.: Slow Query

Deepak Nirmul

06/21/2019 10:18AM

Pages:

1 2 3 4 5

...

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.