MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster 7.3.30 has been released 07/14/2020 12:50PM
•   MySQL Cluster 7.4.29 has been released 07/14/2020 02:18AM
•   MySQL Cluster 7.5.19 has been released 07/14/2020 02:09AM
•   MySQL Cluster 7.6.15 has been released 07/14/2020 01:57AM
•   MySQL Connector/J 8.0.21 has been released 07/13/2020 09:07AM

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

Subject
Views
Written By
Posted
This topic has been moved.:  INSERT AfTER LEFT JOIN creates duplicate records  
10
Brad Liu
09/20/2016 02:09PM
MySQL 8.0: Invisible Indexes  
673
Edwin Desouza
09/20/2016 09:21AM
Preparse Query Rewrite Plugin DLL  
1,560
Francois Haddad
08/12/2016 05:16PM
Re: Preparse Query Rewrite Plugin DLL  
578
Georgi Kodinov
09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL  
764
Francois Haddad
09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL  
617
Tor Didriksen
09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL  
677
Francois Haddad
09/15/2016 11:34AM
Preparse Query Rewrite Plugin DLL  
1,331
Francois Haddad
06/03/2016 12:41PM
Re: Preparse Query Rewrite Plugin DLL  
578
Francois Haddad
06/03/2016 03:13PM
Re: Preparse Query Rewrite Plugin DLL  
539
Georgi Kodinov
06/28/2016 02:12AM
Re: Preparse Query Rewrite Plugin DLL  
536
Francois Haddad
08/12/2016 05:13PM
why the two query has a different execute plan?  
1,260
h h
08/22/2016 02:55AM
Re: why the two query has a different execute plan?  
558
Øystein Grøvlen
08/22/2016 05:08AM
Re: why the two query has a different execute plan?  
514
Rick James
08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL  
465
Francois Haddad
08/15/2016 09:28AM
how to optimize this sql?  
974
h h
07/07/2016 07:38PM
Re: how to optimize this sql?  
647
Peter Brawley
07/08/2016 10:59AM
Re: how to optimize this sql?  
585
h h
07/12/2016 09:01PM
Re: how to optimize this sql?  
610
Rick James
07/09/2016 11:04PM
Re: how to optimize this sql?  
615
h h
07/12/2016 09:08PM
Re: how to optimize this sql?  
634
Rick James
07/14/2016 12:52PM
Indexing for date column for range query  
973
duc minh
07/05/2016 11:04PM
Re: Indexing for date column for range query  
576
Rick James
07/09/2016 10:47PM
Help with partially unique index  
1,122
El T
06/22/2016 04:44AM
Re: Help with partially unique index  
618
Rick James
06/25/2016 10:45PM
Re: Help with partially unique index  
670
El T
07/02/2016 03:33PM
Re: Help with partially unique index  
538
Rick James
07/04/2016 12:50PM
Explain plans for InnoDB and Memory Engines  
1,126
Jagan Kumar
05/02/2016 03:15PM
Re: Explain plans for InnoDB and Memory Engines  
516
Peter Brawley
05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines  
659
Øystein Grøvlen
05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines  
613
Rick James
05/05/2016 10:18PM
MySQL Query Rewrite Plugins  
1,023
Edwin Desouza
02/02/2016 09:48PM
why left join can not use unique index?  
1,922
h h
12/07/2015 08:30PM
Re: why left join can not use unique index?  
801
Rick James
12/08/2015 08:46PM
Re: why left join can not use unique index?  
684
h h
12/11/2015 03:20AM
Re: why left join can not use unique index?  
724
Rick James
12/15/2015 11:08AM
This topic has been moved.:  A stored function to remove diacritics and other chars  
20
Marc Elbet
12/11/2015 03:50AM
prepared statement query takes 3s for a few hundred lines - query issue  
1,211
Michael W.
11/16/2015 11:14AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
731
Rick James
11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
791
Michael W.
12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
716
Rick James
12/07/2015 01:17AM
Why not use index  
1,358
zhang peng
11/08/2015 11:14PM
Re: Why not use index  
655
Peter Brawley
11/09/2015 11:42AM
Re: Why not use index  
676
zhang peng
11/11/2015 12:17AM
Re: Why not use index  
712
Øystein Grøvlen
11/10/2015 10:35AM
Re: Why not use index  
845
zhang peng
11/11/2015 12:15AM
Re: Why not use index  
685
Øystein Grøvlen
11/11/2015 03:40AM
Re: Why not use index  
949
zhang peng
11/11/2015 07:29PM
Re: Why not use index  
667
Peter Brawley
11/11/2015 11:00PM
Re: Why not use index  
736
Øystein Grøvlen
11/12/2015 01:48AM
Re: Why not use index  
711
zhang peng
11/16/2015 12:17AM
Google Update Optimizer system  
1,223
Anik Bhowmik
11/09/2015 09:35PM
Re: Google Update Optimizer system  
671
Peter Brawley
11/09/2015 10:12PM
Re: Google Update Optimizer system  
677
Jonathan Stephens
11/10/2015 01:02AM
Normalize dump table  
1,867
Jose Valle
10/11/2015 08:37PM
Re: Normalize dump table  
663
Jose Valle
10/11/2015 08:42PM
Re: Normalize dump table  
793
Antonio Valle
10/13/2015 01:41PM
Re: Normalize dump table  
741
Rick James
10/17/2015 07:15PM
optimize query for index using between and group by  
2,003
Raghavendra raghu
08/28/2015 03:21AM
Re: optimize query for index using between and group by  
1,189
Rick James
08/29/2015 09:56AM
Re: optimize query for index using between and group by  
740
Raghavendra raghu
08/31/2015 02:34AM
Parsing in MySQL Workbench: the ANTLR age  
1,373
Edwin Desouza
08/14/2015 10:16AM
MySQL Optimizer: Hints  
1,470
Edwin Desouza
07/29/2015 10:07AM
Index not working for date field used in between query  
4,303
Shrinivasa rao
07/22/2015 11:48PM
Re: Index not working for date field used in between query  
1,623
Rick James
07/26/2015 08:28AM
MyISAM using 'wrong' index  
1,537
Danny Stommen
06/08/2015 04:14AM
Re: MyISAM using 'wrong' index  
855
Rick James
06/09/2015 11:53PM
Re: MyISAM using 'wrong' index  
1,365
Danny Stommen
06/30/2015 03:22AM
Re: MyISAM using 'wrong' index  
1,014
Rick James
07/02/2015 09:28PM
Re: MyISAM using 'wrong' index  
837
Danny Stommen
07/03/2015 03:16AM
Re: MyISAM using 'wrong' index  
889
Rick James
07/04/2015 11:10AM
Re: MyISAM using 'wrong' index  
831
Danny Stommen
07/07/2015 01:56AM
Re: MyISAM using 'wrong' index  
791
Edwin Desouza
07/07/2015 09:10AM
Need help understanding optimizer behavior in 5.6  
1,760
Aaron Craven
06/22/2015 08:30AM
Re: Need help understanding optimizer behavior in 5.6  
877
Aaron Craven
06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6  
869
Rick James
06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6  
866
Aaron Craven
06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6  
774
Rick James
06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6  
793
Aaron Craven
06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6  
824
Øystein Grøvlen
06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6  
1,261
Aaron Craven
06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6  
838
Aaron Craven
06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6  
948
Øystein Grøvlen
07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6  
966
Aaron Craven
07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6  
867
Edwin Desouza
07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6  
851
Aaron Craven
07/02/2015 07:48AM
MySQL 5.7: Optimizer Trace and EXPLAIN FORMAT=JSON  
1,753
Edwin Desouza
05/25/2015 10:41AM
foreign key creation in a huge database  
1,720
Raffael Vendrametto
03/05/2015 04:05PM
Please do NOT duplicate posts  
866
Peter Brawley
03/05/2015 05:42PM
Query Taking 2.5hrs on 5.6.20 version  
2,110
ch srinivas
03/04/2015 01:30AM
Re: Query Taking 2.5hrs on 5.6.20 version  
986
Peter Brawley
03/04/2015 12:15PM
Re: Query Taking 2.5hrs on 5.6.20 version  
900
Rick James
03/04/2015 08:18PM
Query optimisation advice  
1,964
Paul Feely
01/08/2015 11:02PM
Re: Query optimisation advice  
1,016
Rick James
01/10/2015 01:22AM
Re: Query optimisation advice  
950
Paul Feely
01/11/2015 05:50PM
Re: Query optimisation advice  
998
Rick James
01/12/2015 10:35PM
actual Size calculation of mysql table (engine innodb)  
1,870
Afaque Ahmad Siddiqui
12/10/2014 09:38AM
Re: actual Size calculation of mysql table (engine innodb)  
998
Rick James
12/12/2014 08:32PM
Re: actual Size calculation of mysql table (engine innodb)  
1,080
Rick James
12/12/2014 08:36PM
MySQL cash optimization  
2,085
Sasha Katsman
11/27/2014 06:33AM
Re: MySQL cash optimization  
1,232
Peter Brawley
11/27/2014 04:34PM
Re: MySQL cash optimization  
916
Sasha Katsman
12/09/2014 04:33AM
Re: MySQL cache optimization  
852
Peter Brawley
12/09/2014 12:28PM
how to tune for optimizer_search_depth?  
2,074
jongse park
12/03/2014 12:13AM
Re: how to tune for optimizer_search_depth?  
1,361
Rick James
12/03/2014 11:33PM
Re: how to tune for optimizer_search_depth?  
1,298
Øystein Grøvlen
12/08/2014 05:32AM
MySQL Optimizer Cost Model  
1,802
Edwin Desouza
10/24/2014 10:37AM
Need help to create index on join statments  
1,941
Neil Sorathia
10/08/2014 06:24PM
Re: Need help to create index on join statments  
919
Neil Sorathia
10/09/2014 09:46AM
Re: Need help to create index on join statments  
1,034
Rick James
10/11/2014 01:37PM
Better Performance for JOINs Not Using Indexes  
1,694
Edwin Desouza
10/03/2014 01:48PM
A Multi-Table Trick to Speed up Single-Table UPDATE/DELETE Statements  
1,961
Edwin Desouza
10/03/2014 01:47PM
MySQL 5.7: Optimizer Hints + Query Rewrite  
1,884
Edwin Desouza
10/01/2014 08:53AM
Intermediate Query Results  
2,769
Ashwini Singh
09/12/2014 08:37AM
Re: Intermediate Query Results  
1,331
Rick James
09/13/2014 09:23PM
Re: Intermediate Query Results  
1,374
Øystein Grøvlen
09/15/2014 05:42AM
All records scanning using "LIKe" and "IN" operaters  
2,197
ch srinivas
06/28/2014 01:43PM
Re: All records scanning using "LIKe" and "IN" operaters  
1,082
Peter Brawley
06/28/2014 02:22PM
Re: All records scanning using "LIKe" and "IN" operaters  
1,040
Øystein Grøvlen
08/28/2014 03:47PM
Help me to optimize my sql query  
2,052
GAURAV JAIN
08/21/2014 07:29AM
Re: Help me to optimize my sql query  
1,020
Rick James
08/22/2014 06:50AM
How could this SQL be optimized?  
2,110
feng guo
05/29/2014 11:26PM
Re: How could this SQL be optimized?  
1,053
Øystein Grøvlen
05/30/2014 02:41AM
Re: How could this SQL be optimized?  
1,128
feng guo
05/30/2014 02:46AM
Re: How could this SQL be optimized?  
979
Marion Gordon
08/21/2014 11:03PM
Re: How could this SQL be optimized?  
1,011
Øystein Grøvlen
08/22/2014 01:54AM
simple uses of order by datetime keep causing 'using filesort'  
2,137
park albert
08/19/2014 05:44PM
Re: simple uses of order by datetime keep causing 'using filesort'  
1,161
Rick James
08/20/2014 07:34PM
Expland and slow-query don't agree  
1,835
Aram Mirzadeh
08/03/2014 06:24AM
Re: Expland and slow-query don't agree  
915
Rick James
08/04/2014 01:23PM
Query not using index sporadically  
2,267
Vinay NP
06/13/2014 07:51AM
Re: Query not using index sporadically  
1,024
Rick James
06/18/2014 02:48PM
[HELP] Subquery Optimization  
2,099
Pinoy Central
05/28/2014 08:56PM
MySQL 5.7: Re-factoring internals of Prepared Statements  
1,633
Edwin Desouza
05/15/2014 12:29PM
BETWEEN a DATE and a hard place  
1,942
Gerald Bayles
04/16/2014 02:07PM
Re: BETWEEN a DATE and a hard place  
1,011
Rick James
04/18/2014 05:19PM
Re: BETWEEN a DATE and a hard place  
1,073
Gerald Bayles
04/21/2014 08:36AM
Re: BETWEEN a DATE and a hard place  
1,048
Rick James
04/24/2014 08:20PM
Re: BETWEEN a DATE and a hard place  
1,196
Gerald Bayles
04/25/2014 06:36AM
Re: BETWEEN a DATE and a hard place  
996
Rick James
04/26/2014 05:46AM
Re: BETWEEN a DATE and a hard place  
1,040
Gerald Bayles
04/28/2014 07:27AM
Re: BETWEEN a DATE and a hard place  
1,097
Gerald Bayles
05/01/2014 09:41AM
Re: BETWEEN a DATE and a hard place  
1,139
Rick James
05/02/2014 11:39AM
MySQL Optimizer: Features in MySQL 5.7  
1,711
Edwin Desouza
04/22/2014 10:03AM
Access mysql blob data from stored procedure  
2,799
Kalpesh g
04/15/2014 04:38AM
Re: Access mysql blob data from stored procedure  
1,145
Peter Brawley
04/15/2014 11:14AM
PARTITION table ADD INDEX ERROR 1041 (HY000) Out of memory  
3,123
Andre Mikulec
03/05/2014 05:38PM
Re: PARTITION table ADD INDEX ERROR 1041 (HY000) Out of memory  
1,373
Rick James
03/06/2014 11:21PM
Re: PARTITION table ADD INDEX ERROR 1041 (HY000) Out of memory  
1,279
Rick James
03/06/2014 11:23PM
Explain estimate completely wrong for range when partitioned by day  
3,043
Blake Harps
02/13/2014 01:23PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,266
Øystein Grøvlen
02/14/2014 01:29AM
Re: Explain estimate completely wrong for range when partitioned by day  
1,329
Mattias Jonsson
02/14/2014 09:44AM
Re: Explain estimate completely wrong for range when partitioned by day  
1,329
Blake Harps
02/14/2014 03:07PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,236
Blake Harps
02/14/2014 02:58PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,130
Edwin Desouza
02/15/2014 12:39PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,212
Rick James
02/15/2014 12:42PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,197
Blake Harps
03/04/2014 12:27PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,300
Mattias Jonsson
02/17/2014 04:29PM
Subquery with range uses filesort  
3,518
David Marcus
11/16/2013 02:42PM
Re: Subquery with range uses filesort  
1,319
Rick James
11/17/2013 07:42PM
Re: Subquery with range uses filesort  
1,316
David Marcus
11/17/2013 08:01PM
Re: Subquery with range uses filesort  
1,286
Rick James
11/18/2013 04:33PM
Re: Subquery with range uses filesort  
1,843
David Marcus
11/18/2013 07:54PM
Re: Subquery with range uses filesort  
1,495
Rick James
11/19/2013 04:10PM
Re: Subquery with range uses filesort  
1,365
David Marcus
11/19/2013 08:36PM
Re: Subquery with range uses filesort  
1,472
Rick James
11/21/2013 02:55PM
Re: Subquery with range uses filesort  
1,685
David Marcus
12/05/2013 03:46PM
Re: Subquery with range uses filesort  
1,297
Rick James
12/07/2013 02:10PM
Re: Subquery with range uses filesort  
1,299
David Marcus
12/09/2013 06:08PM
Re: Subquery with range uses filesort  
1,301
David Marcus
12/14/2013 09:51PM
Re: Subquery with range uses filesort  
1,269
David Marcus
12/14/2013 10:17PM
Re: Subquery with range uses filesort  
1,357
Rick James
12/15/2013 11:29PM
Re: Subquery with range uses filesort  
1,374
David Marcus
12/17/2013 06:58PM
Re: Subquery with range uses filesort  
1,305
Rick James
12/18/2013 05:49PM
Re: Subquery with range uses filesort  
1,334
David Marcus
12/18/2013 08:28PM
Re: Subquery with range uses filesort  
1,405
Rick James
12/19/2013 10:13PM
Re: Subquery with range uses filesort  
1,390
David Marcus
12/19/2013 10:28PM
Re: Subquery with range uses filesort  
1,231
Rick James
12/20/2013 07:06PM
Re: Subquery with range uses filesort  
1,333
David Marcus
12/21/2013 07:36AM
Re: Subquery with range uses filesort  
1,359
Rick James
12/22/2013 10:01AM
Re: Subquery with range uses filesort  
1,410
David Marcus
12/22/2013 10:45AM
Re: Subquery with range uses filesort  
1,277
David Marcus
12/25/2013 09:30PM
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.