MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing August 2026 Releases featuring MySQL Server, MySQL NDB Cluster, Shell and Connector/ODBC 08/25/2026 01:01AM

Advanced Search
New Topic
Pages:
1 2 3 4 5
...
19 »

Subject
Views
Written By
Posted
Sticky:  MySQL: New JSON format for EXPLAIN (1 Posts)  
565
Edwin Desouza
11/04/2024 10:22AM
Sticky:  MySQL: EXPLAIN INTO and EXPLAIN FOR SCHEMA (1 Posts)  
777
Edwin Desouza
11/24/2023 12:34PM
Sticky:  MySQL 8.0: Hash Join and EXPLAIN ANALYZE (1 Posts)  
2,085
Edwin Desouza
10/01/2019 05:40PM
Sticky:  MySQL 8.0: One Giant Leap For SQL (1 Posts)  
1,793
Edwin Desouza
04/25/2018 10:16AM
Sticky:  Unofficial MySQL 8.0 Optimizer Guide (1 Posts)  
2,175
Edwin Desouza
02/13/2017 04:16PM
Sticky:  MySQL 8.0: Window Functions (1 Posts)  
2,318
Edwin Desouza
02/04/2017 08:57PM
Sticky:  MySQL 8.0: CTEs (1 Posts)  
4,544
Edwin Desouza
10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)  
3,005
Edwin Desouza
09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)  
3,222
Edwin Desouza
07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)  
4,156
Edwin Desouza
04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)  
5,308
Edwin Desouza
12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)  
5,721
Edwin Desouza
07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)  
11,643
Edwin DeSouza
04/28/2007 06:20PM
MySQL EXPLAIN ANALYZE  
857
Edwin Desouza
08/09/2023 05:43PM
MySQL Deferred Join: A Deep Dive  
926
Edwin Desouza
08/09/2023 05:28PM
Why multi-valued index is not in possible keys in a dependent subquery  
933
ELON ZHOU
02/02/2023 10:01PM
MySQL Hypergraph Optimizer for HeatWave  
935
Edwin Desouza
01/17/2023 09:20AM
what does explain ref const, const means ?  
1,119
jongse park
11/23/2022 12:00AM
Set Theory in MySQL 8.0: UNION and Now INTERSECT and EXCEPT  
1,003
Edwin Desouza
11/02/2022 10:25AM
Plugin For Obtaining Tokenized Query  
950
JustADude Tester
10/19/2022 08:23AM
Startup was very slow  
1,723
Charles Rodrigues Rimiru
01/27/2022 07:53AM
Re: Startup was very slow  
704
Peter Brawley
02/28/2022 11:14AM
Re: Startup was very slow  
801
Charles Rodrigues Rimiru
03/02/2022 08:58AM
Re: Startup was very slow  
804
Peter Brawley
03/02/2022 10:58AM
Re: Startup was very slow  
803
Charles Rodrigues Rimiru
03/02/2022 01:57PM
Re: Startup was very slow  
574
Charles Rodrigues
10/09/2022 09:24AM
Why MySQL adding 1 when calculating the records per key?  
839
ffc ddd
09/24/2022 07:16PM
Why MySQL adding 1 when calculating the records per key?  
865
ffc ddd
09/24/2022 07:10PM
MYSQL5.7:OPTIMIZER Contradict Explain  
1,119
yijie fu
09/07/2022 05:02AM
Re: MYSQL5.7:OPTIMIZER Contradict Explain  
655
yijie fu
09/07/2022 05:26AM
Need help with getting rid of filesort  
1,509
Marvin Herbold
06/23/2022 01:53PM
Re: Need help with getting rid of filesort  
656
Peter Brawley
06/24/2022 09:59AM
MySQL 8.0 EXPLAIN ANALYZE  
2,062
Edwin Desouza
02/27/2022 10:37PM
Optimizer in 8.0 in some cases not materializing subquery  
3,202
Benjamin Peikes
01/24/2022 03:37PM
Re: Optimizer in 8.0 in some cases not materializing subquery  
679
Peter Brawley
01/24/2022 04:45PM
Running sql in server is too much slower then laptop  
1,458
Shanxiang MAO
10/25/2021 02:49AM
Re: Running sql in server is too much slower then laptop  
710
Peter Brawley
10/25/2021 09:50AM
Re: Running sql in server is too much slower then laptop  
653
Herems Jing
11/13/2021 07:59PM
Re: Running sql in server is too much slower then laptop  
704
Peter Brawley
11/13/2021 09:21PM
Query optimization on LIKE  
1,325
Sing Lau
10/04/2021 12:08PM
Re: Query optimization on LIKE  
737
Peter Brawley
10/04/2021 01:08PM
Multi-valued index is not in possible keys when there is a subquery  
1,698
Jinlin Yang
07/22/2021 07:18PM
Re: Multi-valued index is not in possible keys when there is a subquery  
733
Peter Brawley
10/04/2021 12:55PM
Run ANALYZE TABLE — Do Not Rely on InnoDB's Automatic Recalculation of Statistics  
1,305
Edwin Desouza
09/08/2021 09:52AM
MySQL: EXPLAINing the Different EXPLAINS  
1,201
Edwin Desouza
08/19/2021 02:57PM
Disable caching in MYSQL for True performance testings?  
2,619
Sing Lau
07/11/2021 02:47PM
Re: Disable caching in MYSQL for True performance testings?  
963
Peter Brawley
07/11/2021 05:21PM
Documentation regarding operator precedence incorrect for LIKE, REGEXP, IN?  
1,620
Justin Ng
06/12/2021 01:29PM
How to optimizate COUNT query with multiple LEFT JOIN  
2,338
Ivan Stoqnov
06/01/2021 01:19AM
Re: How to optimizate COUNT query with multiple LEFT JOIN  
748
Ivan Stoqnov
06/01/2021 01:31AM
Re: How to optimizate COUNT query with multiple LEFT JOIN  
817
Peter Brawley
06/01/2021 12:19PM
Need help with tracing how identifiers are parsed; dot-reserved vs dot-space-reserved  
1,427
Justin Ng
05/25/2021 05:28AM
Re: Need help with tracing how identifiers are parsed; dot-reserved vs dot-space-reserved  
751
Justin Ng
05/25/2021 06:21AM
MySQL Invisible Column  
1,362
Edwin Desouza
01/22/2021 01:48PM
mySQL 8 - view query not using outer predicate  
1,818
Jack Crawford
01/11/2021 10:49AM
Re: mySQL 8 - view query not using outer predicate  
764
Peter Brawley
01/11/2021 12:07PM
Re: mySQL 8 - view query not using outer predicate  
807
Jack Crawford
01/11/2021 12:18PM
Re: mySQL 8 - view query not using outer predicate  
825
Peter Brawley
01/11/2021 01:38PM
Re: mySQL 8 - view query not using outer predicate  
813
Jack Crawford
01/11/2021 02:06PM
Re: mySQL 8 - view query not using outer predicate  
723
Peter Brawley
01/11/2021 03:02PM
Re: mySQL 8 - view query not using outer predicate  
810
Jack Crawford
01/11/2021 04:04PM
Re: mySQL 8 - view query not using outer predicate  
772
Peter Brawley
01/11/2021 10:34PM
MySQL Comparing INTs and CHARs  
1,280
Edwin Desouza
08/24/2020 02:56PM
MySQL 8.0 Indexes, Histograms, and Other Ways to Speed Up Your Queries  
1,313
Edwin Desouza
08/04/2020 07:57PM
MySQL: Using SKIP LOCK For Queue Processing  
1,588
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,388
Saverio Miroddi
06/16/2020 10:00AM
MySQL 8.0.20: Index-Level Optimizer Hints  
1,390
Edwin Desouza
04/28/2020 09:04AM
Explain features  
1,480
Michael Bialik
03/29/2020 01:29PM
Re: Explain features  
882
Peter Brawley
03/29/2020 02:01PM
MySQL 8.0: using CTEs to generate Sequences/Ranges  
1,290
Edwin Desouza
03/09/2020 01:23PM
MySQL 8.0: A must-know about NOT IN in SQL – more antijoin optimization  
1,495
Edwin Desouza
02/28/2020 11:12AM
msqldump only one row per minute from a 5 row/minute database  
1,529
Adrian C
02/22/2020 12:38PM
Re: msqldump only one row per minute from a 5 row/minute database  
838
Peter Brawley
02/22/2020 01:46PM
MySQL 8.0: EXPLAIN ANALYZE  
1,385
Edwin Desouza
02/14/2020 11:29PM
Explain command type "All" issue  
1,558
Vipin PA
02/14/2020 03:20AM
Re: Explain command type "All" issue  
934
Peter Brawley
02/14/2020 10:28AM
Re: Explain command type "All" issue  
887
Edwin Desouza
02/14/2020 05:52PM
Introduction to MySQL 8.0 CTEs (Part 1+2)  
1,470
Edwin Desouza
02/13/2020 12:02PM
MySQL 8.0: Hash Join  
2,113
Edwin Desouza
02/09/2020 05:09PM
MySQL 8.0: Simple way to figure out why your recursive CTE is running away  
1,384
Edwin Desouza
01/15/2020 06:06AM
optimizer seems to skip stored function call in where clause?  
1,639
John LeSueur
01/08/2020 11:07AM
Re: optimizer seems to skip stored function call in where clause?  
1,057
John LeSueur
01/08/2020 11:21AM
Re: optimizer seems to skip stored function call in where clause?  
832
John LeSueur
01/08/2020 11:44AM
Re: optimizer seems to skip stored function call in where clause?  
951
Peter Brawley
01/08/2020 01:11PM
MySQL 8.0: AntiJoin  
1,624
Edwin Desouza
12/18/2019 07:54AM
MySQL 8.0: Hash Join  
1,533
Edwin Desouza
11/13/2019 12:36PM
MySQL 8.0: Understanding Hash Joins  
1,321
Edwin Desouza
10/30/2019 11:06AM
Explain Analyze in MySQL 8  
1,343
Edwin Desouza
10/28/2019 05:00PM
optimizing searches using aggregate data in join  
1,739
Matthew Lenz
10/21/2019 09:05AM
Re: optimizing searches using aggregate data in join  
894
Peter Brawley
10/21/2019 11:37AM
MySQL 8.0: EXPLAIN ANALYZE  
1,525
Edwin Desouza
10/17/2019 07:15AM
MySQL 8.0.18 Maintenance Release is Generally Available  
1,881
Edwin Desouza
10/14/2019 01:06PM
Slow Query  
1,989
Deepak Nirmul
06/21/2019 04:47AM
Re: Slow Query  
1,057
Peter Brawley
06/21/2019 10:17AM
Re: Slow Query  
1,103
Deepak Nirmul
06/24/2019 02:18AM
Re: Slow Query  
949
Peter Brawley
06/24/2019 09:56AM
Re: Slow Query  
946
Deepak Nirmul
06/24/2019 10:15AM
Re: Slow Query  
1,052
Peter Brawley
06/24/2019 10:45AM
Re: Slow Query  
1,063
Gopal venkat
09/04/2019 11:47AM
Gopal, please don't hijack threads  
974
Peter Brawley
09/04/2019 02:32PM
Re: Slow Query  
891
marimuthu B
09/06/2019 05:59AM
Re: Slow Query  
951
Peter Brawley
09/06/2019 09:57AM
MySQL 8.0: Supporting all kinds of outer references in derived tables (lateral, or not)  
1,570
Edwin Desouza
07/12/2019 11:13AM
setting an index for speed  
1,622
Michael Peters
07/02/2019 04:56AM
Re: setting an index for speed  
905
Peter Brawley
07/02/2019 12:29PM
This topic has been moved.:  optimizing searches using aggregate data in join  
0
Matthew Lenz
10/21/2019 11:06AM
This topic has been moved.:  setting an index for speed  
9
Michael Peters
07/02/2019 12:26PM
This topic has been moved.:  Slow Query  
0
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.