MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/NET 6.10.9 has been released 07/29/2019 10:27PM
•   MySQL Connector/J 5.1.48 GA has been released 07/29/2019 01:52PM
•   MySQL Cluster 7.3.26 has been released 07/23/2019 08:40AM
•   MySQL Cluster 7.4.25 has been released 07/23/2019 01:56AM
•   MySQL Cluster 7.5.15 has been released 07/23/2019 01:40AM

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

Subject
Views
Written By
Posted
Query Optimisation of a slow query  
3,364
Gaurav Bhuyan
09/13/2011 03:26AM
Re: Query Optimisation of a slow query  
1,197
Rick James
09/16/2011 10:21PM
Re: Query Optimisation of a slow query  
964
Gaurav Bhuyan
09/20/2011 01:51AM
Re: Query Optimisation of a slow query  
1,120
Gaurav Bhuyan
09/19/2011 01:01AM
Re: Query Optimisation of a slow query  
1,020
Rick James
09/20/2011 09:20PM
Re: Query Optimisation of a slow query  
986
Gaurav Bhuyan
09/21/2011 02:38AM
Re: Query Optimisation of a slow query  
956
Rick James
09/22/2011 12:03AM
Re: Query Optimisation of a slow query  
927
Gaurav Bhuyan
09/21/2011 12:21AM
Close conections  
3,033
Mihai Claudiu
07/31/2011 10:16AM
Re: Close conections  
1,446
Rick James
08/08/2011 08:51AM
Re: Close conections  
963
Mihai Claudiu
09/17/2011 02:18PM
Re: Close conections  
976
Rick James
09/18/2011 12:54PM
Re: Close conections  
1,016
Mihai Claudiu
09/18/2011 02:48PM
Re: Close conections  
964
Rick James
09/19/2011 07:23PM
Re: Close conections  
896
Mihai Claudiu
09/20/2011 05:40AM
Re: Close conections  
1,068
Rick James
09/21/2011 11:37PM
combine this 2 simple querys into 1 query for performance.  
2,167
oshri cohen
09/13/2011 06:12AM
Re: combine this 2 simple querys into 1 query for performance.  
784
Jørgen Løland
09/15/2011 01:50AM
Strategy needed for picking random rows  
2,719
Joachim Berger
09/07/2011 11:27AM
Re: Strategy needed for picking random rows  
895
Rick James
09/08/2011 07:51AM
Re: Strategy needed for picking random rows  
958
Joachim Berger
09/08/2011 08:05AM
Re: Strategy needed for picking random rows  
930
Rick James
09/09/2011 08:51AM
Re: Strategy needed for picking random rows  
1,140
Øystein Grøvlen
09/08/2011 01:08AM
Re: Strategy needed for picking random rows  
905
Joachim Berger
09/08/2011 01:17AM
Desperate: BETWEEN and ORDER BY on different columns  
4,368
Joachim Berger
09/01/2011 02:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,123
Rick James
09/05/2011 12:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,002
Joachim Berger
09/05/2011 01:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,091
Rick James
09/06/2011 07:03PM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,125
Jørgen Løland
09/01/2011 05:32AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
912
Joachim Berger
09/01/2011 05:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,253
Jørgen Løland
09/01/2011 06:12AM
Optimizing a query with a NULL  
1,904
Ben Holness
08/22/2011 11:04AM
Re: Optimizing a query with a NULL  
829
Rick James
08/23/2011 08:18AM
What is meaning of "func" in "ref" column of EXPLAIN plan  
5,804
Leo Hopkins
08/04/2011 07:36AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,250
Jørgen Løland
08/05/2011 01:29AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,437
Leo Hopkins
08/05/2011 06:12AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
1,511
Rick James
08/08/2011 07:52PM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,101
Jørgen Løland
08/08/2011 05:01AM
Avoiding "Using temporary; Using filesort"  
4,101
Danny Ó Cuív
07/15/2011 07:34AM
Re: Avoiding "Using temporary; Using filesort"  
1,320
Rick James
07/17/2011 09:45PM
Re: Avoiding "Using temporary; Using filesort"  
1,072
hamid arshad
07/26/2011 02:35AM
Re: Avoiding "Using temporary; Using filesort"  
1,445
Danny Ó Cuív
07/18/2011 12:35PM
Don't dread "Using temporary; Using filesort"  
1,697
Rick James
07/18/2011 08:08PM
Re: Don't dread "Using temporary; Using filesort"  
1,565
Danny Ó Cuív
07/20/2011 07:27AM
Re: Avoiding "Using temporary; Using filesort"  
1,276
Irfan Ali
07/17/2011 04:01AM
Re: Avoiding "Using temporary; Using filesort"  
1,326
Danny Ó Cuív
07/15/2011 07:45AM
Optimize two queries on same table with group by and order by  
2,714
Jan D
07/22/2011 09:10AM
Re: Optimize two queries on same table with group by and order by  
1,091
Rick James
07/23/2011 12:25PM
Tree subtreewalk optimice  
1,928
Jonas Fischer
07/14/2011 08:16AM
Optimal Mysql Configuration (my.cnf)  
15,718
Luiz Cláudio Pinheiro
07/04/2011 12:53PM
Re: Optimal Mysql Configuration (my.cnf)  
2,440
Rick James
07/07/2011 10:06PM
Re: Optimal Mysql Configuration (my.cnf)  
3,004
Luiz Cláudio Pinheiro
07/08/2011 10:28AM
Re: Optimal Mysql Configuration (my.cnf)  
2,735
Rick James
07/08/2011 08:33PM
another problem with index  
1,992
Daniel Silva
07/06/2011 08:39AM
Re: another problem with index  
1,035
Rick James
07/07/2011 09:53PM
Re: another problem with index  
856
Daniel Silva
07/08/2011 02:42AM
two column int index not used correctly  
3,538
Alexander Berl
05/27/2011 10:06AM
Re: two column int index not used correctly  
1,542
Jørgen Løland
06/06/2011 03:15AM
Re: two column int index not used correctly  
954
Alexander Berl
06/16/2011 08:58AM
Re: two column int index not used correctly  
1,120
Jørgen Løland
06/17/2011 01:00AM
Re: two column int index not used correctly  
1,262
Ming Lu
06/15/2011 06:18AM
Re: two column int index not used correctly  
918
Jørgen Løland
06/15/2011 07:14AM
Re: two column int index not used correctly  
918
Ming Lu
06/15/2011 08:07PM
Re: two column int index not used correctly  
1,088
Jørgen Løland
06/15/2011 11:30PM
Re: two column int index not used correctly  
835
Ming Lu
06/16/2011 06:23AM
Re: two column int index not used correctly  
1,470
Jørgen Løland
06/17/2011 01:20AM
Re: two column int index not used correctly  
924
Jørgen Løland
06/17/2011 01:34AM
Re: two column int index not used correctly  
881
Ming Lu
06/20/2011 12:20AM
Re: two column int index not used correctly  
923
Jørgen Løland
06/20/2011 11:49PM
Re: two column int index not used correctly  
948
Ming Lu
06/22/2011 12:05AM
MySQL Configuration for : HostingMontevideo.com  
2,875
Pablo Lewkowitz
05/31/2011 12:52PM
Re: MySQL Configuration for : HostingMontevideo.com  
951
Rick James
06/01/2011 07:17PM
Optimizing query  
2,839
jr wakabayashi
05/23/2011 04:12PM
Re: Optimizing query  
947
Jørgen Løland
05/24/2011 12:49AM
Re: Optimizing query  
928
Rick James
05/27/2011 08:55AM
Re: Optimizing query  
926
Jørgen Løland
05/28/2011 12:30AM
Re: Optimizing query  
960
Rick James
05/28/2011 10:40PM
Re: Optimizing query  
879
Jørgen Løland
05/29/2011 12:54PM
Fails to use range index in outer joined table  
3,071
Fredrik Andersson
05/25/2011 10:01AM
Re: Fails to use range index in outer joined table  
1,005
Øystein Grøvlen
05/27/2011 06:14AM
Re: Fails to use range index in outer joined table  
872
Rick James
05/26/2011 09:27PM
Re: Fails to use range index in outer joined table  
884
Fredrik Andersson
05/27/2011 01:51AM
Help with handlersocket  
3,041
Srinivasan T
05/16/2011 05:41AM
Re: Help with handlersocket  
1,293
Rick James
05/18/2011 10:32PM
Not using index optimal  
3,697
Per Steffensen
05/14/2011 01:02PM
Re: Not using index optimal  
1,104
Øystein Grøvlen
05/18/2011 04:53AM
Re: Not using index optimal  
975
Rick James
05/15/2011 11:25PM
Re: Not using index optimal  
940
Per Steffensen
05/16/2011 03:18AM
Re: Not using index optimal  
1,081
Jørgen Løland
05/15/2011 01:57PM
Re: Not using index optimal  
964
Per Steffensen
05/16/2011 03:23AM
Re: Not using index optimal  
1,057
Jørgen Løland
05/16/2011 06:41AM
Re: Not using index optimal  
978
Per Steffensen
05/14/2011 01:33PM
Stop using filesort  
5,003
Mark Duffy
05/06/2011 02:14PM
Re: Stop using filesort  
2,192
Jørgen Løland
05/08/2011 01:28PM
Re: Stop using filesort  
1,522
Mark Duffy
05/09/2011 10:57AM
Re: Stop using filesort  
3,303
Jørgen Løland
05/10/2011 04:40AM
Re: Stop using filesort  
1,463
Mark Duffy
05/10/2011 11:41AM
Re: Stop using filesort  
2,178
Jørgen Løland
05/10/2011 12:54PM
Re: Stop using filesort  
1,560
Mark Duffy
05/12/2011 08:04AM
Re: Stop using filesort  
1,222
Jørgen Løland
05/12/2011 08:52AM
Why is temp table and filesort being used here?  
1,813
Ben Sebborn
05/03/2011 01:32PM
Further Optimize my.cnf  
2,825
Chirag Patel
04/26/2011 03:18PM
Re: Further Optimize my.cnf  
871
Rick James
05/01/2011 06:55PM
Re: Further Optimize my.cnf  
945
Jørgen Løland
04/29/2011 01:41PM
Query that allows for missing rows  
3,571
Eric Kinney
04/15/2011 10:49AM
Re: Query that allows for missing rows  
1,037
Eric Kinney
04/16/2011 11:04PM
Re: Query that allows for missing rows  
1,033
Rick James
04/17/2011 10:04AM
Re: Query that allows for missing rows  
1,235
Eric Kinney
04/22/2011 02:40PM
Re: Query that allows for missing rows  
868
Rick James
04/16/2011 01:52PM
insert multiple values from array in mysql database using c#  
9,112
Oliver Danilov
04/21/2011 12:55AM
Re: insert multiple values from array in mysql database using c#  
2,264
Rick James
04/22/2011 09:44AM
Optimize - Using Temp, Using Filesort, Group By Having  
5,133
Lenny Dunn
04/08/2011 10:40AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,859
Rick James
04/09/2011 11:37PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,437
Lenny Dunn
04/12/2011 01:38PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,051
Rick James
04/13/2011 07:56AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,399
Lenny Dunn
04/13/2011 09:44AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,975
Rick James
04/14/2011 12:08AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,967
Lenny Dunn
04/19/2011 12:18PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,431
Rick James
04/19/2011 10:40PM
Affiliate Program Dating site....  
1,911
Jake Smith
04/19/2011 03:52AM
Insert multiple values within a transaction with LAST_INSERT_ID  
5,738
Matthias Bendewald
04/15/2011 02:14AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
2,616
Rick James
04/16/2011 08:12AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
1,836
Matthias Bendewald
04/18/2011 04:46AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
1,407
Rick James
04/18/2011 07:34PM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
2,188
Matthias Bendewald
04/19/2011 01:18AM
optimize query?  
2,901
sam s
04/16/2011 09:41PM
Re: optimize query?  
889
Rick James
04/17/2011 10:59PM
Optimizing MySQL filesort with small limit.  
2,156
Edwin DeSouza
04/15/2011 09:41AM
More Stable Query Execution Times by Improving InnoDB Statistics  
2,096
Edwin DeSouza
04/14/2011 10:04AM
Different Servers Using Different Index for Same Query on Same Data  
4,189
Shane Cruz
03/29/2011 08:58AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,613
Jørgen Løland
03/30/2011 01:42AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,186
Shane Cruz
03/30/2011 10:05AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,326
Øystein Grøvlen
04/12/2011 03:49AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,128
Jørgen Løland
03/31/2011 11:52PM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,129
Rick James
04/01/2011 08:41AM
Re: Different Servers Using Different Index for Same Query on Same Data  
906
Jørgen Løland
04/03/2011 12:27PM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,238
Rick James
03/31/2011 11:06PM
MySQL 5.6: Index Condition Pushdown  
2,224
Edwin DeSouza
04/11/2011 08:49AM
MySQL 5.1.31 -- Same query scans widely different # of rows  
2,950
Blake Harps
04/07/2011 02:54PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,236
Jørgen Løland
04/08/2011 08:04AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
955
Blake Harps
04/08/2011 10:45AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
898
Rick James
04/08/2011 09:57PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,097
Jørgen Løland
04/09/2011 06:35AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
953
Rick James
04/09/2011 01:13PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
977
Jørgen Løland
04/11/2011 01:23AM
what does Collapse condition mean?  
3,572
jongse park
04/10/2011 07:25PM
Re: what does Collapse condition mean?  
1,859
Jørgen Løland
04/11/2011 12:02AM
How to Tuning Apache and Mysql  
2,760
atans chiu
04/08/2011 01:10AM
Re: How to Tuning Apache and Mysql  
921
Rick James
04/09/2011 11:58PM
MySQL 5.1 does not seem to be using the index that I expect it to.  
2,905
Tom Muldoon
04/01/2011 09:34AM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,089
Rick James
04/02/2011 11:56AM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,163
Tom Muldoon
04/03/2011 07:46AM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
990
Rick James
04/03/2011 05:01PM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,042
Tom Muldoon
04/03/2011 05:40PM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
961
Rick James
04/03/2011 06:42PM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,045
Tom Muldoon
04/03/2011 08:11PM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,393
Rick James
04/04/2011 10:02PM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,085
Tom Muldoon
04/05/2011 02:22PM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,081
Rick James
04/05/2011 09:34PM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,067
Tom Muldoon
04/05/2011 05:07AM
how to raise page rank?  
2,086
seo Boxuuih
01/21/2011 01:53PM
Re: how to raise page rank?  
886
Anna Hussie
04/04/2011 10:58PM
Local Domain Name Question  
2,175
Jerry Pinkney
03/30/2011 12:46AM
Re: Local Domain Name Question  
878
Rick James
04/01/2011 07:56PM
Optimize Query with multiple joins  
7,889
Angel Lacustre
03/24/2011 06:22AM
Re: Optimize Query with multiple joins  
2,967
Jørgen Løland
03/24/2011 06:53AM
Re: Optimize Query with multiple joins  
1,646
Angel Lacustre
03/24/2011 07:02AM
Re: Optimize Query with multiple joins  
2,167
Rick James
03/25/2011 07:46AM
Re: Optimize Query with multiple joins  
1,574
Angel Lacustre
03/28/2011 04:28AM
Re: Optimize Query with multiple joins  
1,606
Rick James
03/28/2011 11:05PM
Re: Optimize Query with multiple joins  
1,486
Angel Lacustre
03/29/2011 12:49AM
Re: Optimize Query with multiple joins  
1,732
Rick James
03/29/2011 08:28AM
Optimize a query  
2,501
Linus Pettersson
03/10/2011 08:59AM
Re: Optimize a query  
1,186
Rick James
03/13/2011 03:48PM
Re: Optimize a query  
1,280
Linus Pettersson
03/14/2011 03:35PM
Re: Optimize a query  
1,265
Rick James
03/14/2011 06:26PM
Re: Optimize a query  
1,104
Linus Pettersson
03/15/2011 02:20PM
Re: Optimize a query  
1,186
Rick James
03/15/2011 09:12PM
Re: Optimize a query  
1,110
Linus Pettersson
03/28/2011 06:20AM
Need help for creating MySQL maintenance script  
2,079
Ramesh V Siva
03/28/2011 03:59AM
ORDER BY Optimization depends on LIMIT  
5,088
Goran Prijic
03/24/2011 04:38AM
Re: ORDER BY Optimization depends on LIMIT  
935
Rick James
03/25/2011 08:03AM
Optimizing a query with group by and order by count  
7,850
mansup kulel
03/20/2011 01:32AM
Re: Optimizing a query with group by and order by count  
2,519
Rick James
03/21/2011 10:08AM
Re: Optimizing a query with group by and order by count  
2,865
mansup kulel
03/21/2011 10:32PM
Re: Optimizing a query with group by and order by count  
2,362
Rick James
03/22/2011 07:41PM
Two columns indexes  
1,800
Roy Chan
03/20/2011 10:37PM
Re: Two columns indexes  
968
Rick James
03/22/2011 07:54AM
optimising query with group by order by count  
2,881
mansup kulel
03/20/2011 01:22AM
Re: optimising query with group by order by count  
1,077
Rick James
03/21/2011 10:14AM
Urgent. Optimize crash. DB increased the size  
1,998
Jose Molina
03/20/2011 04:48AM
Re: Urgent. Optimize crash. DB increased the size  
880
Rick James
03/21/2011 01:20AM
Optimize sub query with large group by  
3,495
Alex K
03/10/2011 07:44PM
Re: Optimize sub query with large group by  
1,936
Rick James
03/13/2011 03:52PM
Re: Optimize sub query with large group by  
1,695
Alex K
03/13/2011 04:59PM
Re: Optimize sub query with large group by  
2,650
Rick James
03/13/2011 11:32PM
Re: Optimize sub query with large group by  
1,973
Alex K
03/14/2011 02:39AM
Re: Optimize sub query with large group by  
1,445
Rick James
03/14/2011 06:31PM
Re: Optimize sub query with large group by  
1,332
Alex K
03/14/2011 07:15PM
Re: Optimize sub query with large group by  
1,590
Øystein Grøvlen
03/15/2011 04:32AM
Re: Optimize sub query with large group by  
1,357
Alex K
03/15/2011 08:46PM
Re: Optimize sub query with large group by  
2,040
Øystein Grøvlen
03/16/2011 02:02AM
Re: Optimize sub query with large group by  
2,046
Rick James
03/16/2011 08:57AM
Re: Optimize sub query with large group by  
1,358
Alex K
03/17/2011 12:40AM
Re: Optimize sub query with large group by  
3,127
Øystein Grøvlen
03/18/2011 10:58AM
explain a prepared statement  
3,000
Dorian Kuroki
03/09/2011 07:07AM
Re: explain a prepared statement  
1,290
Rick James
03/13/2011 02:13PM
Re: explain a prepared statement  
3,013
Dorian Kuroki
03/14/2011 07:11AM
Re: explain a prepared statement  
1,721
Rick James
03/14/2011 06:22PM
same query takes more time for different tables  
2,257
Radhakant Samal
02/24/2011 05:09AM
Re: same query takes more time for different tables  
1,056
Rick James
02/25/2011 11:32AM
profiler doesn't show me a query  
2,368
nick rulez
02/19/2011 05:48AM
Re: profiler doesn't show me a query  
1,231
nick rulez
02/19/2011 07:29AM
make mysql server use more cpu power  
4,113
Fred nolastname
02/10/2011 06:16AM
Re: make mysql server use more cpu power  
2,400
Rick James
02/12/2011 06:44PM
Re: make mysql server use more cpu power  
1,932
Fred nolastname
02/18/2011 07:59AM
Pages:
« 1
...
4 5 6 7 8
...
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.