MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster 7.2.32 has been released 01/17/2018 12:45PM
•   MySQL Cluster 7.3.20 has been released 01/17/2018 12:36PM
•   MySQL Cluster 7.5.9 has been released 01/17/2018 12:05PM
•   MySQL Community Server 5.5.59 has been released 01/15/2018 12:30PM
•   MySQL Community Server 5.6.39 has been released 01/15/2018 11:13AM

Subject
Views
Written By
Posted
Re: Explain plans for InnoDB and Memory Engines  
368
05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines  
474
05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines  
417
05/05/2016 10:18PM
805
02/02/2016 09:48PM
1,375
h h
12/07/2015 08:30PM
Re: why left join can not use unique index?  
562
12/08/2015 08:46PM
Re: why left join can not use unique index?  
548
h h
12/11/2015 03:20AM
Re: why left join can not use unique index?  
533
12/15/2015 11:08AM
This topic has been moved.:  A stored function to remove diacritics and other chars  
20
12/11/2015 03:50AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
503
11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
588
12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
517
12/07/2015 01:17AM
1,066
11/08/2015 11:14PM
Re: Why not use index  
512
11/09/2015 11:42AM
Re: Why not use index  
558
11/11/2015 12:17AM
Re: Why not use index  
498
11/10/2015 10:35AM
Re: Why not use index  
604
11/11/2015 12:15AM
Re: Why not use index  
511
11/11/2015 03:40AM
Re: Why not use index  
714
11/11/2015 07:29PM
Re: Why not use index  
536
11/11/2015 11:00PM
Re: Why not use index  
511
11/12/2015 01:48AM
Re: Why not use index  
562
11/16/2015 12:17AM
991
11/09/2015 09:35PM
Re: Google Update Optimizer system  
527
11/09/2015 10:12PM
Re: Google Update Optimizer system  
513
11/10/2015 01:02AM
1,404
10/11/2015 08:37PM
Re: Normalize dump table  
509
10/11/2015 08:42PM
Re: Normalize dump table  
563
10/13/2015 01:41PM
Re: Normalize dump table  
542
10/17/2015 07:15PM
Re: optimize query for index using between and group by  
815
08/29/2015 09:56AM
Re: optimize query for index using between and group by  
582
08/31/2015 02:34AM
1,287
07/29/2015 10:07AM
Re: Index not working for date field used in between query  
846
07/26/2015 08:28AM
1,227
06/08/2015 04:14AM
Re: MyISAM using 'wrong' index  
678
06/09/2015 11:53PM
Re: MyISAM using 'wrong' index  
708
06/30/2015 03:22AM
Re: MyISAM using 'wrong' index  
784
07/02/2015 09:28PM
Re: MyISAM using 'wrong' index  
650
07/03/2015 03:16AM
Re: MyISAM using 'wrong' index  
713
07/04/2015 11:10AM
Re: MyISAM using 'wrong' index  
642
07/07/2015 01:56AM
Re: MyISAM using 'wrong' index  
646
07/07/2015 09:10AM
Re: Need help understanding optimizer behavior in 5.6  
709
06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6  
639
06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6  
626
06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6  
617
06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6  
627
06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6  
617
06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6  
917
06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6  
631
06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6  
661
07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6  
723
07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6  
664
07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6  
663
07/02/2015 07:48AM
Please do NOT duplicate posts  
739
03/05/2015 05:42PM
Re: Query Taking 2.5hrs on 5.6.20 version  
782
03/04/2015 12:15PM
Re: Query Taking 2.5hrs on 5.6.20 version  
721
03/04/2015 08:18PM
1,670
01/08/2015 11:02PM
Re: Query optimisation advice  
874
01/10/2015 01:22AM
Re: Query optimisation advice  
830
01/11/2015 05:50PM
Re: Query optimisation advice  
822
01/12/2015 10:35PM
Re: actual Size calculation of mysql table (engine innodb)  
831
12/12/2014 08:32PM
Re: actual Size calculation of mysql table (engine innodb)  
857
12/12/2014 08:36PM
1,796
11/27/2014 06:33AM
Re: MySQL cash optimization  
1,037
11/27/2014 04:34PM
Re: MySQL cash optimization  
755
12/09/2014 04:33AM
Re: MySQL cache optimization  
742
12/09/2014 12:28PM
Re: how to tune for optimizer_search_depth?  
1,061
12/03/2014 11:33PM
Re: how to tune for optimizer_search_depth?  
1,038
12/08/2014 05:32AM
1,631
10/24/2014 10:37AM
Re: Need help to create index on join statments  
809
10/09/2014 09:46AM
Re: Need help to create index on join statments  
880
10/11/2014 01:37PM
2,123
09/12/2014 08:37AM
Re: Intermediate Query Results  
1,019
09/13/2014 09:23PM
Re: Intermediate Query Results  
1,151
09/15/2014 05:42AM
Re: All records scanning using "LIKe" and "IN" operaters  
935
06/28/2014 02:22PM
Re: All records scanning using "LIKe" and "IN" operaters  
860
08/28/2014 03:47PM
1,795
08/21/2014 07:29AM
Re: Help me to optimize my sql query  
868
08/22/2014 06:50AM
1,840
05/29/2014 11:26PM
Re: How could this SQL be optimized?  
911
05/30/2014 02:41AM
Re: How could this SQL be optimized?  
977
05/30/2014 02:46AM
Re: How could this SQL be optimized?  
825
08/21/2014 11:03PM
Re: How could this SQL be optimized?  
810
08/22/2014 01:54AM
Re: simple uses of order by datetime keep causing 'using filesort'  
961
08/20/2014 07:34PM
Re: Expland and slow-query don't agree  
796
08/04/2014 01:23PM
1,922
06/13/2014 07:51AM
Re: Query not using index sporadically  
902
06/18/2014 02:48PM
1,856
05/28/2014 08:56PM
1,746
04/16/2014 02:07PM
Re: BETWEEN a DATE and a hard place  
866
04/18/2014 05:19PM
Re: BETWEEN a DATE and a hard place  
917
04/21/2014 08:36AM
Re: BETWEEN a DATE and a hard place  
928
04/24/2014 08:20PM
Re: BETWEEN a DATE and a hard place  
1,041
04/25/2014 06:36AM
Re: BETWEEN a DATE and a hard place  
847
04/26/2014 05:46AM
Re: BETWEEN a DATE and a hard place  
888
04/28/2014 07:27AM
Re: BETWEEN a DATE and a hard place  
917
05/01/2014 09:41AM
Re: BETWEEN a DATE and a hard place  
970
05/02/2014 11:39AM
Re: Access mysql blob data from stored procedure  
920
04/15/2014 11:14AM
Re: PARTITION table ADD INDEX ERROR 1041 (HY000) Out of memory  
1,184
03/06/2014 11:21PM
Re: PARTITION table ADD INDEX ERROR 1041 (HY000) Out of memory  
1,100
03/06/2014 11:23PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,046
02/14/2014 01:29AM
Re: Explain estimate completely wrong for range when partitioned by day  
1,136
02/14/2014 09:44AM
Re: Explain estimate completely wrong for range when partitioned by day  
1,076
02/14/2014 03:07PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,014
02/14/2014 02:58PM
Re: Explain estimate completely wrong for range when partitioned by day  
994
02/15/2014 12:39PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,056
02/15/2014 12:42PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,028
03/04/2014 12:27PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,125
02/17/2014 04:29PM
2,936
11/16/2013 02:42PM
Re: Subquery with range uses filesort  
1,149
11/17/2013 07:42PM
Re: Subquery with range uses filesort  
1,094
11/17/2013 08:01PM
Re: Subquery with range uses filesort  
1,098
11/18/2013 04:33PM
Re: Subquery with range uses filesort  
1,575
11/18/2013 07:54PM
Re: Subquery with range uses filesort  
1,192
11/19/2013 04:10PM
Re: Subquery with range uses filesort  
1,180
11/19/2013 08:36PM
Re: Subquery with range uses filesort  
1,249
11/21/2013 02:55PM
Re: Subquery with range uses filesort  
1,452
12/05/2013 03:46PM
Re: Subquery with range uses filesort  
1,081
12/07/2013 02:10PM
Re: Subquery with range uses filesort  
1,091
12/09/2013 06:08PM
Re: Subquery with range uses filesort  
1,112
12/14/2013 09:51PM
Re: Subquery with range uses filesort  
1,060
12/14/2013 10:17PM
Re: Subquery with range uses filesort  
1,152
12/15/2013 11:29PM
Re: Subquery with range uses filesort  
1,156
12/17/2013 06:58PM
Re: Subquery with range uses filesort  
1,087
12/18/2013 05:49PM
Re: Subquery with range uses filesort  
1,111
12/18/2013 08:28PM
Re: Subquery with range uses filesort  
1,184
12/19/2013 10:13PM
Re: Subquery with range uses filesort  
1,117
12/19/2013 10:28PM
Re: Subquery with range uses filesort  
1,022
12/20/2013 07:06PM
Re: Subquery with range uses filesort  
1,113
12/21/2013 07:36AM
Re: Subquery with range uses filesort  
1,143
12/22/2013 10:01AM
Re: Subquery with range uses filesort  
1,190
12/22/2013 10:45AM
Re: Subquery with range uses filesort  
1,057
12/25/2013 09:30PM
Re: Optimizer executes inperformant subquery first  
1,021
12/07/2013 02:30PM
Re: Optimizer executes inperformant subquery first  
1,285
12/07/2013 03:49PM
Re: Optimizer executes inperformant subquery first  
1,419
12/09/2013 09:48AM
Re: Optimizer executes inperformant subquery first  
1,154
12/18/2013 03:04AM
Re: Optimizer executes inperformant subquery first  
1,148
12/19/2013 02:45AM
Re: Optimizer executes inperformant subquery first  
1,033
12/20/2013 02:24AM
Re: Optimizer executes inperformant subquery first  
994
12/23/2013 08:07AM
Re: Optimizer executes inperformant subquery first  
1,025
12/23/2013 01:11PM
Re: Optimizer executes inperformant subquery first  
1,140
12/18/2013 05:16AM
Re: Optimizer executes inperformant subquery first  
1,121
12/18/2013 06:49PM
Re: Optimizer executes inperformant subquery first  
1,058
12/19/2013 02:49AM
my.cnf  
1,942
10/27/2013 02:08PM
Re: my.cnf  
953
10/29/2013 07:12PM
2,876
10/28/2013 03:39AM
Re: my.cnf optimization please help  
1,079
10/29/2013 07:10PM
Re: I need help in optimzing a order by clause in a join query  
986
10/10/2013 09:34PM
Re: I need help in optimzing a order by clause in a join query  
979
10/12/2013 02:07PM
Re: I need help in optimzing a order by clause in a join query  
974
10/16/2013 08:36PM
1,989
10/03/2013 09:32PM
2,153
09/18/2013 03:06AM
Re: Very slow dependent subquery  
1,248
09/18/2013 07:06AM
Re: Very slow dependent subquery  
1,171
09/18/2013 07:51AM
Re: Very slow dependent subquery  
1,149
09/18/2013 02:57PM
Re: Very slow dependent subquery  
1,052
09/18/2013 02:13PM
Re: Very slow dependent subquery  
1,046
09/18/2013 03:10PM
Re: Very slow dependent subquery  
1,047
09/24/2013 10:04PM
Re: Very slow dependent subquery  
1,262
09/25/2013 12:53AM
Re: big database +1 million rows/days  
1,021
09/12/2013 01:37AM
Re: big database +1 million rows/days  
1,016
09/13/2013 10:59PM
Re: Optimize query join with 25,000 records  
970
08/31/2013 04:19PM
Pages:
« 1 2 3 4 5
...
18 »

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.