MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster 7.6.9 has been released 01/23/2019 12:57AM
•   MySQL Enterprise Monitor 8.0.14 has been released 01/22/2019 05:00PM
•   MySQL Cluster 7.4.23 has been released 01/22/2019 10:37AM
•   MySQL Cluster 7.5.13 has been released 01/22/2019 07:19AM
•   MySQL Cluster 7.3.24 has been released 01/22/2019 04:08AM
Pages:
« 1
...
3 4 5 6 7
...
18 »

Subject
Views
Written By
Posted
Re: Simple 1-table query taking WAY to long.....  
901
01/24/2012 01:09AM
Re: want to make this query faster, but not sure how  
982
01/19/2012 05:39PM
Re: want to make this query faster, but not sure how  
1,164
01/20/2012 10:51AM
Re: want to make this query faster, but not sure how  
743
01/19/2012 10:12AM
Re: want to make this query faster, but not sure how  
750
01/19/2012 10:29AM
1,184
01/19/2012 12:07PM
Re: Query no longer uses index, takes much longer to run  
776
01/10/2012 01:43PM
Re: Query no longer uses index, takes much longer to run  
794
01/10/2012 03:54PM
Re: Weird issue with join buffer (Performance suffers)  
1,152
01/10/2012 01:37PM
2,427
01/04/2012 01:43PM
Re: Problem with a query performance  
1,031
01/05/2012 10:41AM
Re: Problem with a query performance  
973
01/06/2012 12:36PM
Re: Problem with a query performance  
970
01/07/2012 10:52AM
Re: index not used when join condition added  
1,022
01/03/2012 08:42PM
Re: index not used when join condition added  
1,004
01/03/2012 09:49PM
Re: index not used when join condition added  
1,237
01/04/2012 06:26PM
Re: index not used when join condition added  
938
01/04/2012 07:21PM
Re: index not used when join condition added  
888
01/04/2012 06:28PM
Re: Primary key index with a DATETIME as first part of the compound key is never used  
1,347
01/02/2012 09:06PM
2,545
10/25/2011 12:00AM
Re: help me, optimize a long running query  
982
10/26/2011 06:48AM
Re: help me, optimize a long running query  
959
10/27/2011 12:39AM
Re: help me, optimize a long running query  
996
10/27/2011 09:04PM
Re: help me, optimize a long running query  
1,272
12/26/2011 11:52PM
Re: help me, optimize a long running query  
832
12/27/2011 10:00PM
1,884
12/17/2011 01:24PM
Re: SELECT counter  
842
12/19/2011 06:57AM
Re: Strange behavior with a strange request  
837
12/10/2011 11:37PM
Re: Strange behavior with a strange request  
891
12/12/2011 09:01AM
3,237
11/28/2011 09:58PM
Re: left outer join performance  
1,178
11/28/2011 11:10PM
Re: left outer join performance  
1,079
11/29/2011 09:27PM
3,366
11/28/2011 11:22AM
Re: Join without duplicates  
962
11/28/2011 02:39PM
Re: Join without duplicates  
1,255
11/29/2011 04:19AM
Re: Join without duplicates  
1,452
11/29/2011 02:58PM
Re: Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?  
831
11/29/2011 03:19AM
Re: Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?  
753
11/28/2011 11:06AM
Re: Need to increase packet size in MySQL  
1,019
11/26/2011 08:53AM
2,033
11/19/2011 09:27AM
Re: Executing same query in 1 moment  
856
11/20/2011 04:42PM
Re: Executing same query in 1 moment  
885
11/21/2011 12:42AM
Re: Executing same query in 1 moment  
892
11/20/2011 10:31PM
Re: Executing same query in 1 moment  
794
11/22/2011 12:05AM
2,659
11/18/2011 04:18AM
Re: Slow LEFT JOIN!  
893
11/19/2011 12:42AM
1,580
11/14/2011 01:10AM
Re: table join optimize help!  
752
11/14/2011 09:24PM
Re: table join optimize help!  
838
11/16/2011 01:20AM
Re: table join optimize help!  
774
11/16/2011 09:41PM
Re: table join optimize help!  
824
11/18/2011 01:18AM
1,804
11/08/2011 01:54AM
Re: help~the statement don't use index  
1,079
11/08/2011 09:31AM
Re: help~the statement don't use index  
788
11/08/2011 09:11PM
1,701
11/06/2011 01:36AM
Re: How to optimize group by and where  
833
11/07/2011 07:06AM
Re: Optimize Query for ndb 7.2.1....  
898
10/26/2011 08:40AM
Re: Optimize Query for ndb 7.2.1....  
801
10/26/2011 06:46AM
Re: Optimize Query for ndb 7.2.1....  
747
10/26/2011 03:35AM
Re: not optimizing the table after index is created  
1,277
10/16/2011 11:02AM
Re: not optimizing the table after index is created  
922
10/18/2011 04:24AM
Re: not optimizing the table after index is created  
804
10/18/2011 09:31PM
Re: not optimizing the table after index is created  
837
10/20/2011 12:10AM
Re: not optimizing the table after index is created  
994
10/20/2011 09:30PM
1,383
10/18/2011 01:25AM
Re: Optimize Query  
766
10/20/2011 12:46AM
Re: optimize query -- need help  
730
10/16/2011 10:58AM
Re: optimize query -- need help  
752
10/17/2011 11:33PM
Re: optimize query -- need help  
723
10/18/2011 10:42PM
1,104
10/15/2011 01:13AM
Re: GROUP BY ,ORDER BY optimization help  
1,184
10/07/2011 11:54AM
Re: GROUP BY ,ORDER BY optimization help  
1,076
10/08/2011 03:41AM
Re: GROUP BY ,ORDER BY optimization help  
1,303
10/09/2011 08:58PM
Re: GROUP BY ,ORDER BY optimization help  
962
10/10/2011 09:22AM
Re: GROUP BY ,ORDER BY optimization help  
1,469
10/11/2011 05:36PM
Re: GROUP BY ,ORDER BY optimization help  
847
10/12/2011 10:43AM
2,192
10/05/2011 11:10PM
Re: Explain plan--join type  
913
10/07/2011 12:41AM
2,793
07/21/2011 08:57AM
Re: Mysql using 95% of cpu  
850
09/22/2011 06:11AM
Re: Mysql using 95% of cpu  
1,101
09/23/2011 09:14AM
Re: Mysql using 95% of cpu  
920
07/22/2011 07:33PM
Re: not able to use index, seems optimizer forces not to use index,  
821
09/22/2011 03:30PM
Re: not able to use index, seems optimizer forces not to use index,  
766
09/22/2011 01:24AM
Re: Query Optimisation of a slow query  
1,147
09/16/2011 10:21PM
Re: Query Optimisation of a slow query  
935
09/20/2011 01:51AM
Re: Query Optimisation of a slow query  
1,047
09/19/2011 01:01AM
Re: Query Optimisation of a slow query  
971
09/20/2011 09:20PM
Re: Query Optimisation of a slow query  
947
09/21/2011 02:38AM
Re: Query Optimisation of a slow query  
917
09/22/2011 12:03AM
Re: Query Optimisation of a slow query  
879
09/21/2011 12:21AM
2,933
07/31/2011 10:16AM
Re: Close conections  
1,408
08/08/2011 08:51AM
Re: Close conections  
903
09/17/2011 02:18PM
Re: Close conections  
923
09/18/2011 12:54PM
Re: Close conections  
971
09/18/2011 02:48PM
Re: Close conections  
898
09/19/2011 07:23PM
Re: Close conections  
849
09/20/2011 05:40AM
Re: Close conections  
998
09/21/2011 11:37PM
Re: combine this 2 simple querys into 1 query for performance.  
738
09/15/2011 01:50AM
Re: Strategy needed for picking random rows  
844
09/08/2011 07:51AM
Re: Strategy needed for picking random rows  
930
09/08/2011 08:05AM
Re: Strategy needed for picking random rows  
877
09/09/2011 08:51AM
Re: Strategy needed for picking random rows  
1,086
09/08/2011 01:08AM
Re: Strategy needed for picking random rows  
875
09/08/2011 01:17AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,073
09/05/2011 12:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
978
09/05/2011 01:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,024
09/06/2011 07:03PM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,067
09/01/2011 05:32AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
881
09/01/2011 05:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,222
09/01/2011 06:12AM
1,812
08/22/2011 11:04AM
Re: Optimizing a query with a NULL  
804
08/23/2011 08:18AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,137
08/05/2011 01:29AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,315
08/05/2011 06:12AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
1,433
08/08/2011 07:52PM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
1,961
08/08/2011 05:01AM
Re: Avoiding "Using temporary; Using filesort"  
1,279
07/17/2011 09:45PM
Re: Avoiding "Using temporary; Using filesort"  
1,045
07/26/2011 02:35AM
Re: Avoiding "Using temporary; Using filesort"  
1,333
07/18/2011 12:35PM
Don't dread "Using temporary; Using filesort"  
1,644
07/18/2011 08:08PM
Re: Don't dread "Using temporary; Using filesort"  
1,492
07/20/2011 07:27AM
Re: Avoiding "Using temporary; Using filesort"  
1,224
07/17/2011 04:01AM
Re: Avoiding "Using temporary; Using filesort"  
1,261
07/15/2011 07:45AM
Re: Optimize two queries on same table with group by and order by  
1,052
07/23/2011 12:25PM
1,851
07/14/2011 08:16AM
Re: Optimal Mysql Configuration (my.cnf)  
2,341
07/07/2011 10:06PM
Re: Optimal Mysql Configuration (my.cnf)  
2,924
07/08/2011 10:28AM
Re: Optimal Mysql Configuration (my.cnf)  
2,650
07/08/2011 08:33PM
1,928
07/06/2011 08:39AM
Re: another problem with index  
998
07/07/2011 09:53PM
Re: another problem with index  
828
07/08/2011 02:42AM
Re: two column int index not used correctly  
1,518
06/06/2011 03:15AM
Re: two column int index not used correctly  
920
06/16/2011 08:58AM
Re: two column int index not used correctly  
1,067
06/17/2011 01:00AM
Re: two column int index not used correctly  
1,235
06/15/2011 06:18AM
Re: two column int index not used correctly  
875
06/15/2011 07:14AM
Re: two column int index not used correctly  
896
06/15/2011 08:07PM
Re: two column int index not used correctly  
1,046
06/15/2011 11:30PM
Re: two column int index not used correctly  
814
06/16/2011 06:23AM
Re: two column int index not used correctly  
1,450
06/17/2011 01:20AM
Re: two column int index not used correctly  
899
06/17/2011 01:34AM
Re: two column int index not used correctly  
855
06/20/2011 12:20AM
Re: two column int index not used correctly  
900
06/20/2011 11:49PM
Re: two column int index not used correctly  
919
06/22/2011 12:05AM
Re: MySQL Configuration for : HostingMontevideo.com  
928
06/01/2011 07:17PM
2,744
05/23/2011 04:12PM
Re: Optimizing query  
914
05/24/2011 12:49AM
Re: Optimizing query  
885
05/27/2011 08:55AM
Re: Optimizing query  
897
05/28/2011 12:30AM
Re: Optimizing query  
933
05/28/2011 10:40PM
Re: Optimizing query  
833
05/29/2011 12:54PM
Re: Fails to use range index in outer joined table  
983
05/27/2011 06:14AM
Re: Fails to use range index in outer joined table  
854
05/26/2011 09:27PM
Re: Fails to use range index in outer joined table  
845
05/27/2011 01:51AM
Pages:
« 1
...
3 4 5 6 7
...
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.