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

Advanced Search
New Topic
Pages:
« 1
...
3 4 5 6 7
...
18 »

Subject
Views
Written By
Posted
Simple 1-table query taking WAY to long.....  
1,392
Jason Moore
01/23/2012 02:31AM
Re: Simple 1-table query taking WAY to long.....  
901
Rick James
01/24/2012 01:09AM
want to make this query faster, but not sure how  
1,970
Luc Foisy
01/19/2012 09:55AM
Re: want to make this query faster, but not sure how  
982
irek kordirko
01/19/2012 05:39PM
Re: want to make this query faster, but not sure how  
1,164
Luc Foisy
01/20/2012 10:51AM
Re: want to make this query faster, but not sure how  
743
Luc Foisy
01/19/2012 10:12AM
Re: want to make this query faster, but not sure how  
750
Luc Foisy
01/19/2012 10:29AM
MySQL 5.6: Optimizer Tracing  
1,184
Edwin DeSouza
01/19/2012 12:07PM
Query no longer uses index, takes much longer to run  
1,770
Richard Cunningham
01/09/2012 12:36PM
Re: Query no longer uses index, takes much longer to run  
776
Jørgen Løland
01/10/2012 01:43PM
Re: Query no longer uses index, takes much longer to run  
794
Richard Cunningham
01/10/2012 03:54PM
Weird issue with join buffer (Performance suffers)  
1,630
Ozgur Orhan
01/10/2012 01:54AM
Re: Weird issue with join buffer (Performance suffers)  
1,152
Jørgen Løland
01/10/2012 01:37PM
Problem with a query performance  
2,427
V Pode
01/04/2012 01:43PM
Re: Problem with a query performance  
1,031
Rick James
01/05/2012 10:41AM
Re: Problem with a query performance  
973
V Pode
01/06/2012 12:36PM
Re: Problem with a query performance  
970
Rick James
01/07/2012 10:52AM
index not used when join condition added  
2,292
Daniel Walter
01/02/2012 11:55AM
Re: index not used when join condition added  
1,022
Rick James
01/03/2012 08:42PM
Re: index not used when join condition added  
1,004
Daniel Walter
01/03/2012 09:49PM
Re: index not used when join condition added  
1,237
Rick James
01/04/2012 06:26PM
Re: index not used when join condition added  
938
Daniel Walter
01/04/2012 07:21PM
Re: index not used when join condition added  
888
Rick James
01/04/2012 06:28PM
Primary key index with a DATETIME as first part of the compound key is never used  
3,995
jeremy cohen solal
12/30/2011 08:10AM
Re: Primary key index with a DATETIME as first part of the compound key is never used  
1,347
Rick James
01/02/2012 09:06PM
help me, optimize a long running query  
2,545
h ch
10/25/2011 12:00AM
Re: help me, optimize a long running query  
982
Massimo Brignoli
10/26/2011 06:48AM
Re: help me, optimize a long running query  
959
h ch
10/27/2011 12:39AM
Re: help me, optimize a long running query  
996
Rick James
10/27/2011 09:04PM
Re: help me, optimize a long running query  
1,272
h ch
12/26/2011 11:52PM
Re: help me, optimize a long running query  
832
Rick James
12/27/2011 10:00PM
SELECT counter  
1,884
Root Tr
12/17/2011 01:24PM
Re: SELECT counter  
842
Jørgen Løland
12/19/2011 06:57AM
Strange behavior with a strange request  
1,774
Julien Palard
12/08/2011 05:03AM
Re: Strange behavior with a strange request  
837
Rick James
12/10/2011 11:37PM
Re: Strange behavior with a strange request  
891
Julien Palard
12/12/2011 09:01AM
left outer join performance  
3,237
Michael Shavlovsky
11/28/2011 09:58PM
Re: left outer join performance  
1,178
Michael Shavlovsky
11/28/2011 11:10PM
Re: left outer join performance  
1,079
Rick James
11/29/2011 09:27PM
Join without duplicates  
3,366
Jamie M
11/28/2011 11:22AM
Re: Join without duplicates  
962
Jørgen Løland
11/28/2011 02:39PM
Re: Join without duplicates  
1,255
Jamie M
11/29/2011 04:19AM
Re: Join without duplicates  
1,452
Jørgen Løland
11/29/2011 02:58PM
Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?  
1,735
WeiQi Huang
11/27/2011 05:18AM
Re: Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?  
831
Øystein Grøvlen
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
Rick James
11/28/2011 11:06AM
Need to increase packet size in MySQL  
2,152
Ashvin Ravi Shankar
11/25/2011 12:08AM
Re: Need to increase packet size in MySQL  
1,019
Rick James
11/26/2011 08:53AM
Executing same query in 1 moment  
2,033
Brano Gerzo
11/19/2011 09:27AM
Re: Executing same query in 1 moment  
856
Rick James
11/20/2011 04:42PM
Re: Executing same query in 1 moment  
885
Brano Gerzo
11/21/2011 12:42AM
Re: Executing same query in 1 moment  
892
Brano Gerzo
11/20/2011 10:31PM
Re: Executing same query in 1 moment  
794
Rick James
11/22/2011 12:05AM
Slow LEFT JOIN!  
2,659
Sasha Mitich
11/18/2011 04:18AM
Re: Slow LEFT JOIN!  
893
Rick James
11/19/2011 12:42AM
table join optimize help!  
1,580
kelvin chou
11/14/2011 01:10AM
Re: table join optimize help!  
752
Rick James
11/14/2011 09:24PM
Re: table join optimize help!  
838
kelvin chou
11/16/2011 01:20AM
Re: table join optimize help!  
774
Rick James
11/16/2011 09:41PM
Re: table join optimize help!  
824
kelvin chou
11/18/2011 01:18AM
help~the statement don't use index  
1,804
kelvin chou
11/08/2011 01:54AM
Re: help~the statement don't use index  
1,079
Øystein Grøvlen
11/08/2011 09:31AM
Re: help~the statement don't use index  
788
kelvin chou
11/08/2011 09:11PM
How to optimize group by and where  
1,701
Eric Colson
11/06/2011 01:36AM
Re: How to optimize group by and where  
833
Jørgen Løland
11/07/2011 07:06AM
Optimize Query for ndb 7.2.1....  
2,347
Mohammed Munazir Ul Hasan
10/18/2011 01:21AM
Re: Optimize Query for ndb 7.2.1....  
898
Ole John Aske
10/26/2011 08:40AM
Re: Optimize Query for ndb 7.2.1....  
801
Massimo Brignoli
10/26/2011 06:46AM
Re: Optimize Query for ndb 7.2.1....  
747
Mat Keep
10/26/2011 03:35AM
not optimizing the table after index is created  
2,602
ragen sol
10/15/2011 04:04AM
Re: not optimizing the table after index is created  
1,277
Rick James
10/16/2011 11:02AM
Re: not optimizing the table after index is created  
922
ragen sol
10/18/2011 04:24AM
Re: not optimizing the table after index is created  
804
Rick James
10/18/2011 09:31PM
Re: not optimizing the table after index is created  
837
ragen sol
10/20/2011 12:10AM
Re: not optimizing the table after index is created  
994
Rick James
10/20/2011 09:30PM
Optimize Query  
1,383
Mohammed Munazir Ul Hasan
10/18/2011 01:25AM
Re: Optimize Query  
766
Øystein Grøvlen
10/20/2011 12:46AM
optimize query -- need help  
1,833
Mohammed Munazir Ul Hasan
10/15/2011 04:44AM
Re: optimize query -- need help  
730
Rick James
10/16/2011 10:58AM
Re: optimize query -- need help  
752
Mohammed Munazir Ul Hasan
10/17/2011 11:33PM
Re: optimize query -- need help  
723
Rick James
10/18/2011 10:42PM
Query optimization for slow query  
1,346
Mohammed Munazir Ul Hasan
10/15/2011 03:03AM
optimize query  
1,104
Mohammed Munazir Ul Hasan
10/15/2011 01:13AM
GROUP BY ,ORDER BY optimization help  
2,890
Ciobanu MArius
10/06/2011 09:31AM
Re: GROUP BY ,ORDER BY optimization help  
1,184
Rick James
10/07/2011 11:54AM
Re: GROUP BY ,ORDER BY optimization help  
1,076
Ciobanu MArius
10/08/2011 03:41AM
Re: GROUP BY ,ORDER BY optimization help  
1,303
Rick James
10/09/2011 08:58PM
Re: GROUP BY ,ORDER BY optimization help  
962
Ciobanu MArius
10/10/2011 09:22AM
Re: GROUP BY ,ORDER BY optimization help  
1,469
Rick James
10/11/2011 05:36PM
Re: GROUP BY ,ORDER BY optimization help  
847
Ciobanu MArius
10/12/2011 10:43AM
Explain plan--join type  
2,192
Amy Ng
10/05/2011 11:10PM
Re: Explain plan--join type  
913
Jørgen Løland
10/07/2011 12:41AM
MySQL Optimizer: new EXPLAIN for data-modifiers  
1,625
Edwin DeSouza
10/04/2011 12:54PM
MySQL Batched Key Access Speeds Up Disk-Bound Join Queries  
1,503
Edwin DeSouza
10/04/2011 10:52AM
MySQL Optimizer tracing: Query Execution Plan descriptions beyond EXPLAIN  
1,498
Edwin DeSouza
10/04/2011 08:54AM
MySQL: Killer response time for non-overlapping intervals  
1,333
Edwin DeSouza
09/27/2011 01:55PM
Mysql using 95% of cpu  
2,793
Hitesh Rank
07/21/2011 08:57AM
Re: Mysql using 95% of cpu  
850
Duncan Cox
09/22/2011 06:11AM
Re: Mysql using 95% of cpu  
1,101
Rick James
09/23/2011 09:14AM
Re: Mysql using 95% of cpu  
920
Rick James
07/22/2011 07:33PM
not able to use index, seems optimizer forces not to use index,  
2,036
yi li
09/21/2011 08:08AM
Re: not able to use index, seems optimizer forces not to use index,  
821
Rick James
09/22/2011 03:30PM
Re: not able to use index, seems optimizer forces not to use index,  
766
Øystein Grøvlen
09/22/2011 01:24AM
Query Optimisation of a slow query  
3,251
Gaurav Bhuyan
09/13/2011 03:26AM
Re: Query Optimisation of a slow query  
1,147
Rick James
09/16/2011 10:21PM
Re: Query Optimisation of a slow query  
935
Gaurav Bhuyan
09/20/2011 01:51AM
Re: Query Optimisation of a slow query  
1,047
Gaurav Bhuyan
09/19/2011 01:01AM
Re: Query Optimisation of a slow query  
971
Rick James
09/20/2011 09:20PM
Re: Query Optimisation of a slow query  
947
Gaurav Bhuyan
09/21/2011 02:38AM
Re: Query Optimisation of a slow query  
917
Rick James
09/22/2011 12:03AM
Re: Query Optimisation of a slow query  
879
Gaurav Bhuyan
09/21/2011 12:21AM
Close conections  
2,933
Mihai Claudiu
07/31/2011 10:16AM
Re: Close conections  
1,408
Rick James
08/08/2011 08:51AM
Re: Close conections  
903
Mihai Claudiu
09/17/2011 02:18PM
Re: Close conections  
923
Rick James
09/18/2011 12:54PM
Re: Close conections  
971
Mihai Claudiu
09/18/2011 02:48PM
Re: Close conections  
898
Rick James
09/19/2011 07:23PM
Re: Close conections  
849
Mihai Claudiu
09/20/2011 05:40AM
Re: Close conections  
998
Rick James
09/21/2011 11:37PM
combine this 2 simple querys into 1 query for performance.  
2,090
oshri cohen
09/13/2011 06:12AM
Re: combine this 2 simple querys into 1 query for performance.  
738
Jørgen Løland
09/15/2011 01:50AM
Strategy needed for picking random rows  
2,637
Joachim Berger
09/07/2011 11:27AM
Re: Strategy needed for picking random rows  
844
Rick James
09/08/2011 07:51AM
Re: Strategy needed for picking random rows  
930
Joachim Berger
09/08/2011 08:05AM
Re: Strategy needed for picking random rows  
877
Rick James
09/09/2011 08:51AM
Re: Strategy needed for picking random rows  
1,086
Øystein Grøvlen
09/08/2011 01:08AM
Re: Strategy needed for picking random rows  
875
Joachim Berger
09/08/2011 01:17AM
Desperate: BETWEEN and ORDER BY on different columns  
4,105
Joachim Berger
09/01/2011 02:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,073
Rick James
09/05/2011 12:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
978
Joachim Berger
09/05/2011 01:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,024
Rick James
09/06/2011 07:03PM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,067
Jørgen Løland
09/01/2011 05:32AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
881
Joachim Berger
09/01/2011 05:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,222
Jørgen Løland
09/01/2011 06:12AM
Optimizing a query with a NULL  
1,812
Ben Holness
08/22/2011 11:04AM
Re: Optimizing a query with a NULL  
804
Rick James
08/23/2011 08:18AM
What is meaning of "func" in "ref" column of EXPLAIN plan  
5,563
Leo Hopkins
08/04/2011 07:36AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,137
Jørgen Løland
08/05/2011 01:29AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,315
Leo Hopkins
08/05/2011 06:12AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
1,433
Rick James
08/08/2011 07:52PM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
1,961
Jørgen Løland
08/08/2011 05:01AM
Avoiding "Using temporary; Using filesort"  
4,008
Danny Ó Cuív
07/15/2011 07:34AM
Re: Avoiding "Using temporary; Using filesort"  
1,279
Rick James
07/17/2011 09:45PM
Re: Avoiding "Using temporary; Using filesort"  
1,045
hamid arshad
07/26/2011 02:35AM
Re: Avoiding "Using temporary; Using filesort"  
1,333
Danny Ó Cuív
07/18/2011 12:35PM
Don't dread "Using temporary; Using filesort"  
1,644
Rick James
07/18/2011 08:08PM
Re: Don't dread "Using temporary; Using filesort"  
1,492
Danny Ó Cuív
07/20/2011 07:27AM
Re: Avoiding "Using temporary; Using filesort"  
1,224
Irfan Ali
07/17/2011 04:01AM
Re: Avoiding "Using temporary; Using filesort"  
1,261
Danny Ó Cuív
07/15/2011 07:45AM
Optimize two queries on same table with group by and order by  
2,649
Jan D
07/22/2011 09:10AM
Re: Optimize two queries on same table with group by and order by  
1,052
Rick James
07/23/2011 12:25PM
Tree subtreewalk optimice  
1,851
Jonas Fischer
07/14/2011 08:16AM
Optimal Mysql Configuration (my.cnf)  
14,800
Luiz Cláudio Pinheiro
07/04/2011 12:53PM
Re: Optimal Mysql Configuration (my.cnf)  
2,341
Rick James
07/07/2011 10:06PM
Re: Optimal Mysql Configuration (my.cnf)  
2,924
Luiz Cláudio Pinheiro
07/08/2011 10:28AM
Re: Optimal Mysql Configuration (my.cnf)  
2,650
Rick James
07/08/2011 08:33PM
another problem with index  
1,928
Daniel Silva
07/06/2011 08:39AM
Re: another problem with index  
998
Rick James
07/07/2011 09:53PM
Re: another problem with index  
828
Daniel Silva
07/08/2011 02:42AM
two column int index not used correctly  
3,465
Alexander Berl
05/27/2011 10:06AM
Re: two column int index not used correctly  
1,518
Jørgen Løland
06/06/2011 03:15AM
Re: two column int index not used correctly  
920
Alexander Berl
06/16/2011 08:58AM
Re: two column int index not used correctly  
1,067
Jørgen Løland
06/17/2011 01:00AM
Re: two column int index not used correctly  
1,235
Ming Lu
06/15/2011 06:18AM
Re: two column int index not used correctly  
875
Jørgen Løland
06/15/2011 07:14AM
Re: two column int index not used correctly  
896
Ming Lu
06/15/2011 08:07PM
Re: two column int index not used correctly  
1,046
Jørgen Løland
06/15/2011 11:30PM
Re: two column int index not used correctly  
814
Ming Lu
06/16/2011 06:23AM
Re: two column int index not used correctly  
1,450
Jørgen Løland
06/17/2011 01:20AM
Re: two column int index not used correctly  
899
Jørgen Løland
06/17/2011 01:34AM
Re: two column int index not used correctly  
855
Ming Lu
06/20/2011 12:20AM
Re: two column int index not used correctly  
900
Jørgen Løland
06/20/2011 11:49PM
Re: two column int index not used correctly  
919
Ming Lu
06/22/2011 12:05AM
MySQL Configuration for : HostingMontevideo.com  
2,826
Pablo Lewkowitz
05/31/2011 12:52PM
Re: MySQL Configuration for : HostingMontevideo.com  
928
Rick James
06/01/2011 07:17PM
Optimizing query  
2,744
jr wakabayashi
05/23/2011 04:12PM
Re: Optimizing query  
914
Jørgen Løland
05/24/2011 12:49AM
Re: Optimizing query  
885
Rick James
05/27/2011 08:55AM
Re: Optimizing query  
897
Jørgen Løland
05/28/2011 12:30AM
Re: Optimizing query  
933
Rick James
05/28/2011 10:40PM
Re: Optimizing query  
833
Jørgen Løland
05/29/2011 12:54PM
Fails to use range index in outer joined table  
3,003
Fredrik Andersson
05/25/2011 10:01AM
Re: Fails to use range index in outer joined table  
983
Øystein Grøvlen
05/27/2011 06:14AM
Re: Fails to use range index in outer joined table  
854
Rick James
05/26/2011 09:27PM
Re: Fails to use range index in outer joined table  
845
Fredrik Andersson
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.