MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing October 2025 Releases featuring MySQL Server 9.5.0 Innovation, 8.4.7 LTS and 8.0.44 10/25/2025 05:45AM

Advanced Search
New Topic
Pages:
« 1
...
5 6 7 8 9
...
19 »

Subject
Views
Written By
Posted
combine this 2 simple querys into 1 query for performance.  
2,951
oshri cohen
09/13/2011 06:12AM
Re: combine this 2 simple querys into 1 query for performance.  
1,130
Jørgen Løland
09/15/2011 01:50AM
Strategy needed for picking random rows  
3,575
Joachim Berger
09/07/2011 11:27AM
Re: Strategy needed for picking random rows  
1,240
Rick James
09/08/2011 07:51AM
Re: Strategy needed for picking random rows  
1,326
Joachim Berger
09/08/2011 08:05AM
Re: Strategy needed for picking random rows  
1,272
Rick James
09/09/2011 08:51AM
Re: Strategy needed for picking random rows  
1,485
Øystein Grøvlen
09/08/2011 01:08AM
Re: Strategy needed for picking random rows  
1,256
Joachim Berger
09/08/2011 01:17AM
Desperate: BETWEEN and ORDER BY on different columns  
5,977
Joachim Berger
09/01/2011 02:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,565
Rick James
09/05/2011 12:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,399
Joachim Berger
09/05/2011 01:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,570
Rick James
09/06/2011 07:03PM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,567
Jørgen Løland
09/01/2011 05:32AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,288
Joachim Berger
09/01/2011 05:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,650
Jørgen Løland
09/01/2011 06:12AM
Optimizing a query with a NULL  
2,539
Ben Holness
08/22/2011 11:04AM
Re: Optimizing a query with a NULL  
1,094
Rick James
08/23/2011 08:18AM
What is meaning of "func" in "ref" column of EXPLAIN plan  
8,631
Leo Hopkins
08/04/2011 07:36AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
3,394
Jørgen Løland
08/05/2011 01:29AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
3,483
Leo Hopkins
08/05/2011 06:12AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,394
Rick James
08/08/2011 07:52PM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
3,225
Jørgen Løland
08/08/2011 05:01AM
Avoiding "Using temporary; Using filesort"  
5,118
Danny Ó Cuív
07/15/2011 07:34AM
Re: Avoiding "Using temporary; Using filesort"  
1,657
Rick James
07/17/2011 09:45PM
Re: Avoiding "Using temporary; Using filesort"  
1,350
hamid arshad
07/26/2011 02:35AM
Re: Avoiding "Using temporary; Using filesort"  
1,946
Danny Ó Cuív
07/18/2011 12:35PM
Don't dread "Using temporary; Using filesort"  
2,031
Rick James
07/18/2011 08:08PM
Re: Don't dread "Using temporary; Using filesort"  
1,982
Danny Ó Cuív
07/20/2011 07:27AM
Re: Avoiding "Using temporary; Using filesort"  
1,588
Irfan Ali
07/17/2011 04:01AM
Re: Avoiding "Using temporary; Using filesort"  
1,696
Danny Ó Cuív
07/15/2011 07:45AM
Optimize two queries on same table with group by and order by  
3,306
Jan D
07/22/2011 09:10AM
Re: Optimize two queries on same table with group by and order by  
1,420
Rick James
07/23/2011 12:25PM
Tree subtreewalk optimice  
2,528
Jonas Fischer
07/14/2011 08:16AM
Optimal Mysql Configuration (my.cnf)  
18,389
Luiz Cláudio Pinheiro
07/04/2011 12:53PM
Re: Optimal Mysql Configuration (my.cnf)  
2,950
Rick James
07/07/2011 10:06PM
Re: Optimal Mysql Configuration (my.cnf)  
3,507
Luiz Cláudio Pinheiro
07/08/2011 10:28AM
Re: Optimal Mysql Configuration (my.cnf)  
3,231
Rick James
07/08/2011 08:33PM
another problem with index  
2,601
Daniel Silva
07/06/2011 08:39AM
Re: another problem with index  
1,341
Rick James
07/07/2011 09:53PM
Re: another problem with index  
1,127
Daniel Silva
07/08/2011 02:42AM
two column int index not used correctly  
4,301
Alexander Berl
05/27/2011 10:06AM
Re: two column int index not used correctly  
1,923
Jørgen Løland
06/06/2011 03:15AM
Re: two column int index not used correctly  
1,329
Alexander Berl
06/16/2011 08:58AM
Re: two column int index not used correctly  
1,577
Jørgen Løland
06/17/2011 01:00AM
Re: two column int index not used correctly  
1,633
Ming Lu
06/15/2011 06:18AM
Re: two column int index not used correctly  
1,250
Jørgen Løland
06/15/2011 07:14AM
Re: two column int index not used correctly  
1,260
Ming Lu
06/15/2011 08:07PM
Re: two column int index not used correctly  
1,479
Jørgen Løland
06/15/2011 11:30PM
Re: two column int index not used correctly  
1,168
Ming Lu
06/16/2011 06:23AM
Re: two column int index not used correctly  
1,874
Jørgen Løland
06/17/2011 01:20AM
Re: two column int index not used correctly  
1,282
Jørgen Løland
06/17/2011 01:34AM
Re: two column int index not used correctly  
1,174
Ming Lu
06/20/2011 12:20AM
Re: two column int index not used correctly  
1,263
Jørgen Løland
06/20/2011 11:49PM
Re: two column int index not used correctly  
1,243
Ming Lu
06/22/2011 12:05AM
MySQL Configuration for : HostingMontevideo.com  
3,370
Pablo Lewkowitz
05/31/2011 12:52PM
Re: MySQL Configuration for : HostingMontevideo.com  
1,219
Rick James
06/01/2011 07:17PM
Optimizing query  
3,976
jr wakabayashi
05/23/2011 04:12PM
Re: Optimizing query  
1,285
Jørgen Løland
05/24/2011 12:49AM
Re: Optimizing query  
1,239
Rick James
05/27/2011 08:55AM
Re: Optimizing query  
1,286
Jørgen Løland
05/28/2011 12:30AM
Re: Optimizing query  
1,243
Rick James
05/28/2011 10:40PM
Re: Optimizing query  
1,235
Jørgen Løland
05/29/2011 12:54PM
Fails to use range index in outer joined table  
3,679
Fredrik Andersson
05/25/2011 10:01AM
Re: Fails to use range index in outer joined table  
1,283
Øystein Grøvlen
05/27/2011 06:14AM
Re: Fails to use range index in outer joined table  
1,206
Rick James
05/26/2011 09:27PM
Re: Fails to use range index in outer joined table  
1,208
Fredrik Andersson
05/27/2011 01:51AM
Help with handlersocket  
3,582
Srinivasan T
05/16/2011 05:41AM
Re: Help with handlersocket  
1,586
Rick James
05/18/2011 10:32PM
Not using index optimal  
4,345
Per Steffensen
05/14/2011 01:02PM
Re: Not using index optimal  
1,386
Øystein Grøvlen
05/18/2011 04:53AM
Re: Not using index optimal  
1,295
Rick James
05/15/2011 11:25PM
Re: Not using index optimal  
1,260
Per Steffensen
05/16/2011 03:18AM
Re: Not using index optimal  
1,381
Jørgen Løland
05/15/2011 01:57PM
Re: Not using index optimal  
1,248
Per Steffensen
05/16/2011 03:23AM
Re: Not using index optimal  
1,391
Jørgen Løland
05/16/2011 06:41AM
Re: Not using index optimal  
1,256
Per Steffensen
05/14/2011 01:33PM
Stop using filesort  
6,908
Mark Duffy
05/06/2011 02:14PM
Re: Stop using filesort  
2,872
Jørgen Løland
05/08/2011 01:28PM
Re: Stop using filesort  
1,926
Mark Duffy
05/09/2011 10:57AM
Re: Stop using filesort  
3,823
Jørgen Løland
05/10/2011 04:40AM
Re: Stop using filesort  
1,869
Mark Duffy
05/10/2011 11:41AM
Re: Stop using filesort  
2,822
Jørgen Løland
05/10/2011 12:54PM
Re: Stop using filesort  
1,946
Mark Duffy
05/12/2011 08:04AM
Re: Stop using filesort  
1,568
Jørgen Løland
05/12/2011 08:52AM
Why is temp table and filesort being used here?  
2,340
Ben Sebborn
05/03/2011 01:32PM
Further Optimize my.cnf  
3,378
Chirag Patel
04/26/2011 03:18PM
Re: Further Optimize my.cnf  
1,154
Rick James
05/01/2011 06:55PM
Re: Further Optimize my.cnf  
1,208
Jørgen Løland
04/29/2011 01:41PM
Query that allows for missing rows  
4,229
Eric Kinney
04/15/2011 10:49AM
Re: Query that allows for missing rows  
1,373
Eric Kinney
04/16/2011 11:04PM
Re: Query that allows for missing rows  
1,358
Rick James
04/17/2011 10:04AM
Re: Query that allows for missing rows  
1,560
Eric Kinney
04/22/2011 02:40PM
Re: Query that allows for missing rows  
1,157
Rick James
04/16/2011 01:52PM
insert multiple values from array in mysql database using c#  
10,385
Oliver Danilov
04/21/2011 12:55AM
Re: insert multiple values from array in mysql database using c#  
2,656
Rick James
04/22/2011 09:44AM
Optimize - Using Temp, Using Filesort, Group By Having  
6,102
Lenny Dunn
04/08/2011 10:40AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,335
Rick James
04/09/2011 11:37PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,811
Lenny Dunn
04/12/2011 01:38PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,476
Rick James
04/13/2011 07:56AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,878
Lenny Dunn
04/13/2011 09:44AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,372
Rick James
04/14/2011 12:08AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,405
Lenny Dunn
04/19/2011 12:18PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,822
Rick James
04/19/2011 10:40PM
Affiliate Program Dating site....  
2,396
Jake Smith
04/19/2011 03:52AM
Insert multiple values within a transaction with LAST_INSERT_ID  
6,949
Matthias Bendewald
04/15/2011 02:14AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
3,197
Rick James
04/16/2011 08:12AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
2,366
Matthias Bendewald
04/18/2011 04:46AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
1,887
Rick James
04/18/2011 07:34PM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
2,798
Matthias Bendewald
04/19/2011 01:18AM
optimize query?  
3,405
sam s
04/16/2011 09:41PM
Re: optimize query?  
1,159
Rick James
04/17/2011 10:59PM
Optimizing MySQL filesort with small limit.  
2,888
Edwin DeSouza
04/15/2011 09:41AM
More Stable Query Execution Times by Improving InnoDB Statistics  
2,813
Edwin DeSouza
04/14/2011 10:04AM
Different Servers Using Different Index for Same Query on Same Data  
6,206
Shane Cruz
03/29/2011 08:58AM
Re: Different Servers Using Different Index for Same Query on Same Data  
2,058
Jørgen Løland
03/30/2011 01:42AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,609
Shane Cruz
03/30/2011 10:05AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,640
Øystein Grøvlen
04/12/2011 03:49AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,486
Jørgen Løland
03/31/2011 11:52PM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,521
Rick James
04/01/2011 08:41AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,232
Jørgen Løland
04/03/2011 12:27PM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,591
Rick James
03/31/2011 11:06PM
MySQL 5.6: Index Condition Pushdown  
2,802
Edwin DeSouza
04/11/2011 08:49AM
MySQL 5.1.31 -- Same query scans widely different # of rows  
3,935
Blake Harps
04/07/2011 02:54PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,639
Jørgen Løland
04/08/2011 08:04AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,294
Blake Harps
04/08/2011 10:45AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,197
Rick James
04/08/2011 09:57PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,435
Jørgen Løland
04/09/2011 06:35AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,311
Rick James
04/09/2011 01:13PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,336
Jørgen Løland
04/11/2011 01:23AM
what does Collapse condition mean?  
4,205
jongse park
04/10/2011 07:25PM
Re: what does Collapse condition mean?  
3,237
Jørgen Løland
04/11/2011 12:02AM
How to Tuning Apache and Mysql  
3,405
atans chiu
04/08/2011 01:10AM
Re: How to Tuning Apache and Mysql  
1,163
Rick James
04/09/2011 11:58PM
MySQL 5.1 does not seem to be using the index that I expect it to.  
3,544
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,384
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,469
Tom Muldoon
04/03/2011 07:46AM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,318
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,318
Tom Muldoon
04/03/2011 05:40PM
Re: MySQL 5.1 does not seem to be using the index that I expect it to.  
1,256
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,363
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,695
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,410
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,447
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,408
Tom Muldoon
04/05/2011 05:07AM
how to raise page rank?  
2,644
seo Boxuuih
01/21/2011 01:53PM
Re: how to raise page rank?  
1,153
Anna Hussie
04/04/2011 10:58PM
Local Domain Name Question  
2,712
Jerry Pinkney
03/30/2011 12:46AM
Re: Local Domain Name Question  
1,115
Rick James
04/01/2011 07:56PM
Optimize Query with multiple joins  
10,434
Angel Lacustre
03/24/2011 06:22AM
Re: Optimize Query with multiple joins  
3,616
Jørgen Løland
03/24/2011 06:53AM
Re: Optimize Query with multiple joins  
2,099
Angel Lacustre
03/24/2011 07:02AM
Re: Optimize Query with multiple joins  
2,645
Rick James
03/25/2011 07:46AM
Re: Optimize Query with multiple joins  
2,133
Angel Lacustre
03/28/2011 04:28AM
Re: Optimize Query with multiple joins  
2,083
Rick James
03/28/2011 11:05PM
Re: Optimize Query with multiple joins  
1,957
Angel Lacustre
03/29/2011 12:49AM
Re: Optimize Query with multiple joins  
2,160
Rick James
03/29/2011 08:28AM
Optimize a query  
3,181
Linus Pettersson
03/10/2011 08:59AM
Re: Optimize a query  
1,540
Rick James
03/13/2011 03:48PM
Re: Optimize a query  
1,616
Linus Pettersson
03/14/2011 03:35PM
Re: Optimize a query  
1,602
Rick James
03/14/2011 06:26PM
Re: Optimize a query  
1,472
Linus Pettersson
03/15/2011 02:20PM
Re: Optimize a query  
1,507
Rick James
03/15/2011 09:12PM
Re: Optimize a query  
1,410
Linus Pettersson
03/28/2011 06:20AM
Need help for creating MySQL maintenance script  
2,552
Ramesh V Siva
03/28/2011 03:59AM
ORDER BY Optimization depends on LIMIT  
5,617
Goran Prijic
03/24/2011 04:38AM
Re: ORDER BY Optimization depends on LIMIT  
1,256
Rick James
03/25/2011 08:03AM
Optimizing a query with group by and order by count  
9,216
mansup kulel
03/20/2011 01:32AM
Re: Optimizing a query with group by and order by count  
2,940
Rick James
03/21/2011 10:08AM
Re: Optimizing a query with group by and order by count  
3,311
mansup kulel
03/21/2011 10:32PM
Re: Optimizing a query with group by and order by count  
2,821
Rick James
03/22/2011 07:41PM
Two columns indexes  
2,259
Roy Chan
03/20/2011 10:37PM
Re: Two columns indexes  
1,290
Rick James
03/22/2011 07:54AM
optimising query with group by order by count  
3,365
mansup kulel
03/20/2011 01:22AM
Re: optimising query with group by order by count  
1,352
Rick James
03/21/2011 10:14AM
Urgent. Optimize crash. DB increased the size  
2,425
Jose Molina
03/20/2011 04:48AM
Re: Urgent. Optimize crash. DB increased the size  
1,134
Rick James
03/21/2011 01:20AM
Optimize sub query with large group by  
4,141
Alex K
03/10/2011 07:44PM
Re: Optimize sub query with large group by  
2,305
Rick James
03/13/2011 03:52PM
Re: Optimize sub query with large group by  
2,020
Alex K
03/13/2011 04:59PM
Re: Optimize sub query with large group by  
2,996
Rick James
03/13/2011 11:32PM
Re: Optimize sub query with large group by  
2,298
Alex K
03/14/2011 02:39AM
Re: Optimize sub query with large group by  
1,755
Rick James
03/14/2011 06:31PM
Re: Optimize sub query with large group by  
1,652
Alex K
03/14/2011 07:15PM
Re: Optimize sub query with large group by  
1,955
Øystein Grøvlen
03/15/2011 04:32AM
Re: Optimize sub query with large group by  
1,715
Alex K
03/15/2011 08:46PM
Re: Optimize sub query with large group by  
2,475
Øystein Grøvlen
03/16/2011 02:02AM
Re: Optimize sub query with large group by  
2,395
Rick James
03/16/2011 08:57AM
Re: Optimize sub query with large group by  
1,737
Alex K
03/17/2011 12:40AM
Re: Optimize sub query with large group by  
3,732
Øystein Grøvlen
03/18/2011 10:58AM
explain a prepared statement  
3,563
Dorian Kuroki
03/09/2011 07:07AM
Re: explain a prepared statement  
1,639
Rick James
03/13/2011 02:13PM
Re: explain a prepared statement  
3,606
Dorian Kuroki
03/14/2011 07:11AM
Re: explain a prepared statement  
2,108
Rick James
03/14/2011 06:22PM
same query takes more time for different tables  
2,699
Radhakant Samal
02/24/2011 05:09AM
Re: same query takes more time for different tables  
1,309
Rick James
02/25/2011 11:32AM
profiler doesn't show me a query  
2,907
nick rulez
02/19/2011 05:48AM
Re: profiler doesn't show me a query  
1,481
nick rulez
02/19/2011 07:29AM
make mysql server use more cpu power  
4,708
Fred nolastname
02/10/2011 06:16AM
Re: make mysql server use more cpu power  
2,755
Rick James
02/12/2011 06:44PM
Re: make mysql server use more cpu power  
2,287
Fred nolastname
02/18/2011 07:59AM
Long query execution, about 1 hr  
3,827
eloe lelo
02/13/2011 10:07AM
Re: Long query execution, about 1 hr  
1,364
Rick James
02/14/2011 07:00PM
Re: Long query execution, about 1 hr  
1,389
eloe lelo
02/15/2011 03:04PM
Re: Long query execution, about 1 hr  
1,421
Rick James
02/16/2011 12:17AM
Queries using WHERE IN and ORDER BY LIMIT  
5,762
Nikita Dubrovsky
02/10/2011 10:55AM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,778
Rick James
02/12/2011 06:42PM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,751
Nikita Dubrovsky
02/14/2011 07:06PM
Pages:
« 1
...
5 6 7 8 9
...
19 »

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.