MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL for Excel 1.3.8 has been released 06/10/2019 10:21PM

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

Subject
Views
Written By
Posted
Strategy needed for picking random rows  
2,694
Joachim Berger
09/07/2011 11:27AM
Re: Strategy needed for picking random rows  
878
Rick James
09/08/2011 07:51AM
Re: Strategy needed for picking random rows  
950
Joachim Berger
09/08/2011 08:05AM
Re: Strategy needed for picking random rows  
916
Rick James
09/09/2011 08:51AM
Re: Strategy needed for picking random rows  
1,121
Øystein Grøvlen
09/08/2011 01:08AM
Re: Strategy needed for picking random rows  
891
Joachim Berger
09/08/2011 01:17AM
Desperate: BETWEEN and ORDER BY on different columns  
4,293
Joachim Berger
09/01/2011 02:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,106
Rick James
09/05/2011 12:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
996
Joachim Berger
09/05/2011 01:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,070
Rick James
09/06/2011 07:03PM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,110
Jørgen Løland
09/01/2011 05:32AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
904
Joachim Berger
09/01/2011 05:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,244
Jørgen Løland
09/01/2011 06:12AM
Optimizing a query with a NULL  
1,868
Ben Holness
08/22/2011 11:04AM
Re: Optimizing a query with a NULL  
816
Rick James
08/23/2011 08:18AM
What is meaning of "func" in "ref" column of EXPLAIN plan  
5,720
Leo Hopkins
08/04/2011 07:36AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,205
Jørgen Løland
08/05/2011 01:29AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,400
Leo Hopkins
08/05/2011 06:12AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
1,487
Rick James
08/08/2011 07:52PM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,054
Jørgen Løland
08/08/2011 05:01AM
Avoiding "Using temporary; Using filesort"  
4,067
Danny Ó Cuív
07/15/2011 07:34AM
Re: Avoiding "Using temporary; Using filesort"  
1,303
Rick James
07/17/2011 09:45PM
Re: Avoiding "Using temporary; Using filesort"  
1,063
hamid arshad
07/26/2011 02:35AM
Re: Avoiding "Using temporary; Using filesort"  
1,412
Danny Ó Cuív
07/18/2011 12:35PM
Don't dread "Using temporary; Using filesort"  
1,680
Rick James
07/18/2011 08:08PM
Re: Don't dread "Using temporary; Using filesort"  
1,539
Danny Ó Cuív
07/20/2011 07:27AM
Re: Avoiding "Using temporary; Using filesort"  
1,259
Irfan Ali
07/17/2011 04:01AM
Re: Avoiding "Using temporary; Using filesort"  
1,307
Danny Ó Cuív
07/15/2011 07:45AM
Optimize two queries on same table with group by and order by  
2,689
Jan D
07/22/2011 09:10AM
Re: Optimize two queries on same table with group by and order by  
1,076
Rick James
07/23/2011 12:25PM
Tree subtreewalk optimice  
1,902
Jonas Fischer
07/14/2011 08:16AM
Optimal Mysql Configuration (my.cnf)  
15,451
Luiz Cláudio Pinheiro
07/04/2011 12:53PM
Re: Optimal Mysql Configuration (my.cnf)  
2,416
Rick James
07/07/2011 10:06PM
Re: Optimal Mysql Configuration (my.cnf)  
2,986
Luiz Cláudio Pinheiro
07/08/2011 10:28AM
Re: Optimal Mysql Configuration (my.cnf)  
2,708
Rick James
07/08/2011 08:33PM
another problem with index  
1,969
Daniel Silva
07/06/2011 08:39AM
Re: another problem with index  
1,023
Rick James
07/07/2011 09:53PM
Re: another problem with index  
841
Daniel Silva
07/08/2011 02:42AM
two column int index not used correctly  
3,510
Alexander Berl
05/27/2011 10:06AM
Re: two column int index not used correctly  
1,530
Jørgen Løland
06/06/2011 03:15AM
Re: two column int index not used correctly  
937
Alexander Berl
06/16/2011 08:58AM
Re: two column int index not used correctly  
1,101
Jørgen Løland
06/17/2011 01:00AM
Re: two column int index not used correctly  
1,252
Ming Lu
06/15/2011 06:18AM
Re: two column int index not used correctly  
899
Jørgen Løland
06/15/2011 07:14AM
Re: two column int index not used correctly  
905
Ming Lu
06/15/2011 08:07PM
Re: two column int index not used correctly  
1,070
Jørgen Løland
06/15/2011 11:30PM
Re: two column int index not used correctly  
822
Ming Lu
06/16/2011 06:23AM
Re: two column int index not used correctly  
1,460
Jørgen Løland
06/17/2011 01:20AM
Re: two column int index not used correctly  
913
Jørgen Løland
06/17/2011 01:34AM
Re: two column int index not used correctly  
870
Ming Lu
06/20/2011 12:20AM
Re: two column int index not used correctly  
911
Jørgen Løland
06/20/2011 11:49PM
Re: two column int index not used correctly  
926
Ming Lu
06/22/2011 12:05AM
MySQL Configuration for : HostingMontevideo.com  
2,852
Pablo Lewkowitz
05/31/2011 12:52PM
Re: MySQL Configuration for : HostingMontevideo.com  
940
Rick James
06/01/2011 07:17PM
Optimizing query  
2,799
jr wakabayashi
05/23/2011 04:12PM
Re: Optimizing query  
933
Jørgen Løland
05/24/2011 12:49AM
Re: Optimizing query  
915
Rick James
05/27/2011 08:55AM
Re: Optimizing query  
916
Jørgen Løland
05/28/2011 12:30AM
Re: Optimizing query  
951
Rick James
05/28/2011 10:40PM
Re: Optimizing query  
862
Jørgen Løland
05/29/2011 12:54PM
Fails to use range index in outer joined table  
3,044
Fredrik Andersson
05/25/2011 10:01AM
Re: Fails to use range index in outer joined table  
990
Øystein Grøvlen
05/27/2011 06:14AM
Re: Fails to use range index in outer joined table  
863
Rick James
05/26/2011 09:27PM
Re: Fails to use range index in outer joined table  
867
Fredrik Andersson
05/27/2011 01:51AM
Help with handlersocket  
3,022
Srinivasan T
05/16/2011 05:41AM
Re: Help with handlersocket  
1,280
Rick James
05/18/2011 10:32PM
Not using index optimal  
3,668
Per Steffensen
05/14/2011 01:02PM
Re: Not using index optimal  
1,088
Øystein Grøvlen
05/18/2011 04:53AM
Re: Not using index optimal  
967
Rick James
05/15/2011 11:25PM
Re: Not using index optimal  
923
Per Steffensen
05/16/2011 03:18AM
Re: Not using index optimal  
1,069
Jørgen Løland
05/15/2011 01:57PM
Re: Not using index optimal  
953
Per Steffensen
05/16/2011 03:23AM
Re: Not using index optimal  
1,043
Jørgen Løland
05/16/2011 06:41AM
Re: Not using index optimal  
966
Per Steffensen
05/14/2011 01:33PM
Stop using filesort  
4,957
Mark Duffy
05/06/2011 02:14PM
Re: Stop using filesort  
2,173
Jørgen Løland
05/08/2011 01:28PM
Re: Stop using filesort  
1,499
Mark Duffy
05/09/2011 10:57AM
Re: Stop using filesort  
3,274
Jørgen Løland
05/10/2011 04:40AM
Re: Stop using filesort  
1,446
Mark Duffy
05/10/2011 11:41AM
Re: Stop using filesort  
2,154
Jørgen Løland
05/10/2011 12:54PM
Re: Stop using filesort  
1,541
Mark Duffy
05/12/2011 08:04AM
Re: Stop using filesort  
1,207
Jørgen Løland
05/12/2011 08:52AM
Why is temp table and filesort being used here?  
1,797
Ben Sebborn
05/03/2011 01:32PM
Further Optimize my.cnf  
2,806
Chirag Patel
04/26/2011 03:18PM
Re: Further Optimize my.cnf  
861
Rick James
05/01/2011 06:55PM
Re: Further Optimize my.cnf  
931
Jørgen Løland
04/29/2011 01:41PM
Query that allows for missing rows  
3,541
Eric Kinney
04/15/2011 10:49AM
Re: Query that allows for missing rows  
1,009
Eric Kinney
04/16/2011 11:04PM
Re: Query that allows for missing rows  
1,016
Rick James
04/17/2011 10:04AM
Re: Query that allows for missing rows  
1,217
Eric Kinney
04/22/2011 02:40PM
Re: Query that allows for missing rows  
859
Rick James
04/16/2011 01:52PM
insert multiple values from array in mysql database using c#  
8,993
Oliver Danilov
04/21/2011 12:55AM
Re: insert multiple values from array in mysql database using c#  
2,250
Rick James
04/22/2011 09:44AM
Optimize - Using Temp, Using Filesort, Group By Having  
5,094
Lenny Dunn
04/08/2011 10:40AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,837
Rick James
04/09/2011 11:37PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,421
Lenny Dunn
04/12/2011 01:38PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,035
Rick James
04/13/2011 07:56AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,376
Lenny Dunn
04/13/2011 09:44AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,953
Rick James
04/14/2011 12:08AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,933
Lenny Dunn
04/19/2011 12:18PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,409
Rick James
04/19/2011 10:40PM
Affiliate Program Dating site....  
1,895
Jake Smith
04/19/2011 03:52AM
Insert multiple values within a transaction with LAST_INSERT_ID  
5,690
Matthias Bendewald
04/15/2011 02:14AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
2,598
Rick James
04/16/2011 08:12AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
1,813
Matthias Bendewald
04/18/2011 04:46AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
1,398
Rick James
04/18/2011 07:34PM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
2,167
Matthias Bendewald
04/19/2011 01:18AM
optimize query?  
2,881
sam s
04/16/2011 09:41PM
Re: optimize query?  
877
Rick James
04/17/2011 10:59PM
Optimizing MySQL filesort with small limit.  
2,141
Edwin DeSouza
04/15/2011 09:41AM
More Stable Query Execution Times by Improving InnoDB Statistics  
2,076
Edwin DeSouza
04/14/2011 10:04AM
Different Servers Using Different Index for Same Query on Same Data  
4,161
Shane Cruz
03/29/2011 08:58AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,590
Jørgen Løland
03/30/2011 01:42AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,170
Shane Cruz
03/30/2011 10:05AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,317
Øystein Grøvlen
04/12/2011 03:49AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,112
Jørgen Løland
03/31/2011 11:52PM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,113
Rick James
04/01/2011 08:41AM
Re: Different Servers Using Different Index for Same Query on Same Data  
895
Jørgen Løland
04/03/2011 12:27PM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,223
Rick James
03/31/2011 11:06PM
MySQL 5.6: Index Condition Pushdown  
2,210
Edwin DeSouza
04/11/2011 08:49AM
MySQL 5.1.31 -- Same query scans widely different # of rows  
2,920
Blake Harps
04/07/2011 02:54PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,220
Jørgen Løland
04/08/2011 08:04AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
943
Blake Harps
04/08/2011 10:45AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
880
Rick James
04/08/2011 09:57PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,079
Jørgen Løland
04/09/2011 06:35AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
941
Rick James
04/09/2011 01:13PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
964
Jørgen Løland
04/11/2011 01:23AM
what does Collapse condition mean?  
3,561
jongse park
04/10/2011 07:25PM
Re: what does Collapse condition mean?  
1,812
Jørgen Løland
04/11/2011 12:02AM
How to Tuning Apache and Mysql  
2,735
atans chiu
04/08/2011 01:10AM
Re: How to Tuning Apache and Mysql  
915
Rick James
04/09/2011 11:58PM
MySQL 5.1 does not seem to be using the index that I expect it to.  
2,882
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,079
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,147
Tom Muldoon
04/03/2011 07:46AM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
975
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,032
Tom Muldoon
04/03/2011 05:40PM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
952
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,035
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,383
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,071
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,067
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,057
Tom Muldoon
04/05/2011 05:07AM
how to raise page rank?  
2,068
seo Boxuuih
01/21/2011 01:53PM
Re: how to raise page rank?  
872
Anna Hussie
04/04/2011 10:58PM
Local Domain Name Question  
2,156
Jerry Pinkney
03/30/2011 12:46AM
Re: Local Domain Name Question  
867
Rick James
04/01/2011 07:56PM
Optimize Query with multiple joins  
7,759
Angel Lacustre
03/24/2011 06:22AM
Re: Optimize Query with multiple joins  
2,929
Jørgen Løland
03/24/2011 06:53AM
Re: Optimize Query with multiple joins  
1,624
Angel Lacustre
03/24/2011 07:02AM
Re: Optimize Query with multiple joins  
2,144
Rick James
03/25/2011 07:46AM
Re: Optimize Query with multiple joins  
1,553
Angel Lacustre
03/28/2011 04:28AM
Re: Optimize Query with multiple joins  
1,581
Rick James
03/28/2011 11:05PM
Re: Optimize Query with multiple joins  
1,466
Angel Lacustre
03/29/2011 12:49AM
Re: Optimize Query with multiple joins  
1,713
Rick James
03/29/2011 08:28AM
Optimize a query  
2,469
Linus Pettersson
03/10/2011 08:59AM
Re: Optimize a query  
1,169
Rick James
03/13/2011 03:48PM
Re: Optimize a query  
1,263
Linus Pettersson
03/14/2011 03:35PM
Re: Optimize a query  
1,240
Rick James
03/14/2011 06:26PM
Re: Optimize a query  
1,085
Linus Pettersson
03/15/2011 02:20PM
Re: Optimize a query  
1,169
Rick James
03/15/2011 09:12PM
Re: Optimize a query  
1,087
Linus Pettersson
03/28/2011 06:20AM
Need help for creating MySQL maintenance script  
2,061
Ramesh V Siva
03/28/2011 03:59AM
ORDER BY Optimization depends on LIMIT  
5,070
Goran Prijic
03/24/2011 04:38AM
Re: ORDER BY Optimization depends on LIMIT  
920
Rick James
03/25/2011 08:03AM
Optimizing a query with group by and order by count  
7,771
mansup kulel
03/20/2011 01:32AM
Re: Optimizing a query with group by and order by count  
2,493
Rick James
03/21/2011 10:08AM
Re: Optimizing a query with group by and order by count  
2,842
mansup kulel
03/21/2011 10:32PM
Re: Optimizing a query with group by and order by count  
2,342
Rick James
03/22/2011 07:41PM
Two columns indexes  
1,779
Roy Chan
03/20/2011 10:37PM
Re: Two columns indexes  
948
Rick James
03/22/2011 07:54AM
optimising query with group by order by count  
2,865
mansup kulel
03/20/2011 01:22AM
Re: optimising query with group by order by count  
1,066
Rick James
03/21/2011 10:14AM
Urgent. Optimize crash. DB increased the size  
1,985
Jose Molina
03/20/2011 04:48AM
Re: Urgent. Optimize crash. DB increased the size  
869
Rick James
03/21/2011 01:20AM
Optimize sub query with large group by  
3,470
Alex K
03/10/2011 07:44PM
Re: Optimize sub query with large group by  
1,909
Rick James
03/13/2011 03:52PM
Re: Optimize sub query with large group by  
1,669
Alex K
03/13/2011 04:59PM
Re: Optimize sub query with large group by  
2,624
Rick James
03/13/2011 11:32PM
Re: Optimize sub query with large group by  
1,948
Alex K
03/14/2011 02:39AM
Re: Optimize sub query with large group by  
1,422
Rick James
03/14/2011 06:31PM
Re: Optimize sub query with large group by  
1,312
Alex K
03/14/2011 07:15PM
Re: Optimize sub query with large group by  
1,570
Øystein Grøvlen
03/15/2011 04:32AM
Re: Optimize sub query with large group by  
1,337
Alex K
03/15/2011 08:46PM
Re: Optimize sub query with large group by  
2,021
Øystein Grøvlen
03/16/2011 02:02AM
Re: Optimize sub query with large group by  
2,026
Rick James
03/16/2011 08:57AM
Re: Optimize sub query with large group by  
1,329
Alex K
03/17/2011 12:40AM
Re: Optimize sub query with large group by  
3,077
Øystein Grøvlen
03/18/2011 10:58AM
explain a prepared statement  
2,975
Dorian Kuroki
03/09/2011 07:07AM
Re: explain a prepared statement  
1,277
Rick James
03/13/2011 02:13PM
Re: explain a prepared statement  
2,984
Dorian Kuroki
03/14/2011 07:11AM
Re: explain a prepared statement  
1,703
Rick James
03/14/2011 06:22PM
same query takes more time for different tables  
2,230
Radhakant Samal
02/24/2011 05:09AM
Re: same query takes more time for different tables  
1,040
Rick James
02/25/2011 11:32AM
profiler doesn't show me a query  
2,344
nick rulez
02/19/2011 05:48AM
Re: profiler doesn't show me a query  
1,221
nick rulez
02/19/2011 07:29AM
make mysql server use more cpu power  
4,078
Fred nolastname
02/10/2011 06:16AM
Re: make mysql server use more cpu power  
2,376
Rick James
02/12/2011 06:44PM
Re: make mysql server use more cpu power  
1,909
Fred nolastname
02/18/2011 07:59AM
Long query execution, about 1 hr  
3,170
eloe lelo
02/13/2011 10:07AM
Re: Long query execution, about 1 hr  
1,066
Rick James
02/14/2011 07:00PM
Re: Long query execution, about 1 hr  
1,052
eloe lelo
02/15/2011 03:04PM
Re: Long query execution, about 1 hr  
1,095
Rick James
02/16/2011 12:17AM
Queries using WHERE IN and ORDER BY LIMIT  
4,739
Nikita Dubrovsky
02/10/2011 10:55AM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,389
Rick James
02/12/2011 06:42PM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,383
Nikita Dubrovsky
02/14/2011 07:06PM
select query optimize  
2,573
Robert Koziol
02/10/2011 05:14AM
Re: select query optimize  
1,142
Rick James
02/12/2011 06:56PM
Re: select query optimize  
1,106
Robert Koziol
02/14/2011 06:26AM
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.