MySQL Forums
Forum List  »  Optimizer & Parser

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,835
oshri cohen
09/13/2011 06:12AM
Re: combine this 2 simple querys into 1 query for performance.  
1,078
Jørgen Løland
09/15/2011 01:50AM
Strategy needed for picking random rows  
3,441
Joachim Berger
09/07/2011 11:27AM
Re: Strategy needed for picking random rows  
1,177
Rick James
09/08/2011 07:51AM
Re: Strategy needed for picking random rows  
1,254
Joachim Berger
09/08/2011 08:05AM
Re: Strategy needed for picking random rows  
1,214
Rick James
09/09/2011 08:51AM
Re: Strategy needed for picking random rows  
1,428
Øystein Grøvlen
09/08/2011 01:08AM
Re: Strategy needed for picking random rows  
1,203
Joachim Berger
09/08/2011 01:17AM
Desperate: BETWEEN and ORDER BY on different columns  
5,879
Joachim Berger
09/01/2011 02:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,504
Rick James
09/05/2011 12:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,343
Joachim Berger
09/05/2011 01:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,513
Rick James
09/06/2011 07:03PM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,515
Jørgen Løland
09/01/2011 05:32AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,241
Joachim Berger
09/01/2011 05:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns  
1,595
Jørgen Løland
09/01/2011 06:12AM
Optimizing a query with a NULL  
2,447
Ben Holness
08/22/2011 11:04AM
Re: Optimizing a query with a NULL  
1,051
Rick James
08/23/2011 08:18AM
What is meaning of "func" in "ref" column of EXPLAIN plan  
8,476
Leo Hopkins
08/04/2011 07:36AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
3,324
Jørgen Løland
08/05/2011 01:29AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
3,414
Leo Hopkins
08/05/2011 06:12AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
2,320
Rick James
08/08/2011 07:52PM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan  
3,134
Jørgen Løland
08/08/2011 05:01AM
Avoiding "Using temporary; Using filesort"  
4,922
Danny Ó Cuív
07/15/2011 07:34AM
Re: Avoiding "Using temporary; Using filesort"  
1,599
Rick James
07/17/2011 09:45PM
Re: Avoiding "Using temporary; Using filesort"  
1,291
hamid arshad
07/26/2011 02:35AM
Re: Avoiding "Using temporary; Using filesort"  
1,849
Danny Ó Cuív
07/18/2011 12:35PM
Don't dread "Using temporary; Using filesort"  
1,965
Rick James
07/18/2011 08:08PM
Re: Don't dread "Using temporary; Using filesort"  
1,917
Danny Ó Cuív
07/20/2011 07:27AM
Re: Avoiding "Using temporary; Using filesort"  
1,541
Irfan Ali
07/17/2011 04:01AM
Re: Avoiding "Using temporary; Using filesort"  
1,634
Danny Ó Cuív
07/15/2011 07:45AM
Optimize two queries on same table with group by and order by  
3,195
Jan D
07/22/2011 09:10AM
Re: Optimize two queries on same table with group by and order by  
1,348
Rick James
07/23/2011 12:25PM
Tree subtreewalk optimice  
2,424
Jonas Fischer
07/14/2011 08:16AM
Optimal Mysql Configuration (my.cnf)  
18,217
Luiz Cláudio Pinheiro
07/04/2011 12:53PM
Re: Optimal Mysql Configuration (my.cnf)  
2,904
Rick James
07/07/2011 10:06PM
Re: Optimal Mysql Configuration (my.cnf)  
3,449
Luiz Cláudio Pinheiro
07/08/2011 10:28AM
Re: Optimal Mysql Configuration (my.cnf)  
3,165
Rick James
07/08/2011 08:33PM
another problem with index  
2,488
Daniel Silva
07/06/2011 08:39AM
Re: another problem with index  
1,283
Rick James
07/07/2011 09:53PM
Re: another problem with index  
1,081
Daniel Silva
07/08/2011 02:42AM
two column int index not used correctly  
4,182
Alexander Berl
05/27/2011 10:06AM
Re: two column int index not used correctly  
1,848
Jørgen Løland
06/06/2011 03:15AM
Re: two column int index not used correctly  
1,252
Alexander Berl
06/16/2011 08:58AM
Re: two column int index not used correctly  
1,512
Jørgen Løland
06/17/2011 01:00AM
Re: two column int index not used correctly  
1,570
Ming Lu
06/15/2011 06:18AM
Re: two column int index not used correctly  
1,190
Jørgen Løland
06/15/2011 07:14AM
Re: two column int index not used correctly  
1,189
Ming Lu
06/15/2011 08:07PM
Re: two column int index not used correctly  
1,415
Jørgen Løland
06/15/2011 11:30PM
Re: two column int index not used correctly  
1,112
Ming Lu
06/16/2011 06:23AM
Re: two column int index not used correctly  
1,789
Jørgen Løland
06/17/2011 01:20AM
Re: two column int index not used correctly  
1,215
Jørgen Løland
06/17/2011 01:34AM
Re: two column int index not used correctly  
1,123
Ming Lu
06/20/2011 12:20AM
Re: two column int index not used correctly  
1,213
Jørgen Løland
06/20/2011 11:49PM
Re: two column int index not used correctly  
1,184
Ming Lu
06/22/2011 12:05AM
MySQL Configuration for : HostingMontevideo.com  
3,289
Pablo Lewkowitz
05/31/2011 12:52PM
Re: MySQL Configuration for : HostingMontevideo.com  
1,178
Rick James
06/01/2011 07:17PM
Optimizing query  
3,819
jr wakabayashi
05/23/2011 04:12PM
Re: Optimizing query  
1,213
Jørgen Løland
05/24/2011 12:49AM
Re: Optimizing query  
1,187
Rick James
05/27/2011 08:55AM
Re: Optimizing query  
1,229
Jørgen Løland
05/28/2011 12:30AM
Re: Optimizing query  
1,196
Rick James
05/28/2011 10:40PM
Re: Optimizing query  
1,169
Jørgen Løland
05/29/2011 12:54PM
Fails to use range index in outer joined table  
3,585
Fredrik Andersson
05/25/2011 10:01AM
Re: Fails to use range index in outer joined table  
1,233
Øystein Grøvlen
05/27/2011 06:14AM
Re: Fails to use range index in outer joined table  
1,157
Rick James
05/26/2011 09:27PM
Re: Fails to use range index in outer joined table  
1,168
Fredrik Andersson
05/27/2011 01:51AM
Help with handlersocket  
3,505
Srinivasan T
05/16/2011 05:41AM
Re: Help with handlersocket  
1,530
Rick James
05/18/2011 10:32PM
Not using index optimal  
4,241
Per Steffensen
05/14/2011 01:02PM
Re: Not using index optimal  
1,332
Øystein Grøvlen
05/18/2011 04:53AM
Re: Not using index optimal  
1,248
Rick James
05/15/2011 11:25PM
Re: Not using index optimal  
1,207
Per Steffensen
05/16/2011 03:18AM
Re: Not using index optimal  
1,332
Jørgen Løland
05/15/2011 01:57PM
Re: Not using index optimal  
1,214
Per Steffensen
05/16/2011 03:23AM
Re: Not using index optimal  
1,342
Jørgen Løland
05/16/2011 06:41AM
Re: Not using index optimal  
1,178
Per Steffensen
05/14/2011 01:33PM
Stop using filesort  
6,105
Mark Duffy
05/06/2011 02:14PM
Re: Stop using filesort  
2,738
Jørgen Løland
05/08/2011 01:28PM
Re: Stop using filesort  
1,873
Mark Duffy
05/09/2011 10:57AM
Re: Stop using filesort  
3,771
Jørgen Løland
05/10/2011 04:40AM
Re: Stop using filesort  
1,810
Mark Duffy
05/10/2011 11:41AM
Re: Stop using filesort  
2,747
Jørgen Løland
05/10/2011 12:54PM
Re: Stop using filesort  
1,895
Mark Duffy
05/12/2011 08:04AM
Re: Stop using filesort  
1,498
Jørgen Løland
05/12/2011 08:52AM
Why is temp table and filesort being used here?  
2,253
Ben Sebborn
05/03/2011 01:32PM
Further Optimize my.cnf  
3,273
Chirag Patel
04/26/2011 03:18PM
Re: Further Optimize my.cnf  
1,096
Rick James
05/01/2011 06:55PM
Re: Further Optimize my.cnf  
1,160
Jørgen Løland
04/29/2011 01:41PM
Query that allows for missing rows  
4,096
Eric Kinney
04/15/2011 10:49AM
Re: Query that allows for missing rows  
1,321
Eric Kinney
04/16/2011 11:04PM
Re: Query that allows for missing rows  
1,306
Rick James
04/17/2011 10:04AM
Re: Query that allows for missing rows  
1,517
Eric Kinney
04/22/2011 02:40PM
Re: Query that allows for missing rows  
1,103
Rick James
04/16/2011 01:52PM
insert multiple values from array in mysql database using c#  
10,267
Oliver Danilov
04/21/2011 12:55AM
Re: insert multiple values from array in mysql database using c#  
2,597
Rick James
04/22/2011 09:44AM
Optimize - Using Temp, Using Filesort, Group By Having  
5,953
Lenny Dunn
04/08/2011 10:40AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,278
Rick James
04/09/2011 11:37PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,728
Lenny Dunn
04/12/2011 01:38PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,402
Rick James
04/13/2011 07:56AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,805
Lenny Dunn
04/13/2011 09:44AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,306
Rick James
04/14/2011 12:08AM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
2,351
Lenny Dunn
04/19/2011 12:18PM
Re: Optimize - Using Temp, Using Filesort, Group By Having  
1,769
Rick James
04/19/2011 10:40PM
Affiliate Program Dating site....  
2,301
Jake Smith
04/19/2011 03:52AM
Insert multiple values within a transaction with LAST_INSERT_ID  
6,833
Matthias Bendewald
04/15/2011 02:14AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
3,159
Rick James
04/16/2011 08:12AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
2,312
Matthias Bendewald
04/18/2011 04:46AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
1,841
Rick James
04/18/2011 07:34PM
Re: Insert multiple values within a transaction with LAST_INSERT_ID  
2,681
Matthias Bendewald
04/19/2011 01:18AM
optimize query?  
3,294
sam s
04/16/2011 09:41PM
Re: optimize query?  
1,113
Rick James
04/17/2011 10:59PM
Optimizing MySQL filesort with small limit.  
2,772
Edwin DeSouza
04/15/2011 09:41AM
More Stable Query Execution Times by Improving InnoDB Statistics  
2,703
Edwin DeSouza
04/14/2011 10:04AM
Different Servers Using Different Index for Same Query on Same Data  
5,911
Shane Cruz
03/29/2011 08:58AM
Re: Different Servers Using Different Index for Same Query on Same Data  
2,002
Jørgen Løland
03/30/2011 01:42AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,547
Shane Cruz
03/30/2011 10:05AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,598
Øystein Grøvlen
04/12/2011 03:49AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,434
Jørgen Løland
03/31/2011 11:52PM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,460
Rick James
04/01/2011 08:41AM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,169
Jørgen Løland
04/03/2011 12:27PM
Re: Different Servers Using Different Index for Same Query on Same Data  
1,548
Rick James
03/31/2011 11:06PM
MySQL 5.6: Index Condition Pushdown  
2,700
Edwin DeSouza
04/11/2011 08:49AM
MySQL 5.1.31 -- Same query scans widely different # of rows  
3,794
Blake Harps
04/07/2011 02:54PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,572
Jørgen Løland
04/08/2011 08:04AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,211
Blake Harps
04/08/2011 10:45AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,152
Rick James
04/08/2011 09:57PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,390
Jørgen Løland
04/09/2011 06:35AM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,265
Rick James
04/09/2011 01:13PM
Re: MySQL 5.1.31 -- Same query scans widely different # of rows  
1,283
Jørgen Løland
04/11/2011 01:23AM
what does Collapse condition mean?  
4,079
jongse park
04/10/2011 07:25PM
Re: what does Collapse condition mean?  
3,153
Jørgen Løland
04/11/2011 12:02AM
How to Tuning Apache and Mysql  
3,315
atans chiu
04/08/2011 01:10AM
Re: How to Tuning Apache and Mysql  
1,124
Rick James
04/09/2011 11:58PM
MySQL 5.1 does not seem to be using the index that I expect it to.  
3,451
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,334
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,420
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,266
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,263
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,205
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,308
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,640
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,359
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,388
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,353
Tom Muldoon
04/05/2011 05:07AM
how to raise page rank?  
2,548
seo Boxuuih
01/21/2011 01:53PM
Re: how to raise page rank?  
1,108
Anna Hussie
04/04/2011 10:58PM
Local Domain Name Question  
2,622
Jerry Pinkney
03/30/2011 12:46AM
Re: Local Domain Name Question  
1,063
Rick James
04/01/2011 07:56PM
Optimize Query with multiple joins  
10,227
Angel Lacustre
03/24/2011 06:22AM
Re: Optimize Query with multiple joins  
3,569
Jørgen Løland
03/24/2011 06:53AM
Re: Optimize Query with multiple joins  
2,044
Angel Lacustre
03/24/2011 07:02AM
Re: Optimize Query with multiple joins  
2,581
Rick James
03/25/2011 07:46AM
Re: Optimize Query with multiple joins  
2,040
Angel Lacustre
03/28/2011 04:28AM
Re: Optimize Query with multiple joins  
2,018
Rick James
03/28/2011 11:05PM
Re: Optimize Query with multiple joins  
1,901
Angel Lacustre
03/29/2011 12:49AM
Re: Optimize Query with multiple joins  
2,097
Rick James
03/29/2011 08:28AM
Optimize a query  
3,070
Linus Pettersson
03/10/2011 08:59AM
Re: Optimize a query  
1,482
Rick James
03/13/2011 03:48PM
Re: Optimize a query  
1,557
Linus Pettersson
03/14/2011 03:35PM
Re: Optimize a query  
1,554
Rick James
03/14/2011 06:26PM
Re: Optimize a query  
1,420
Linus Pettersson
03/15/2011 02:20PM
Re: Optimize a query  
1,456
Rick James
03/15/2011 09:12PM
Re: Optimize a query  
1,361
Linus Pettersson
03/28/2011 06:20AM
Need help for creating MySQL maintenance script  
2,478
Ramesh V Siva
03/28/2011 03:59AM
ORDER BY Optimization depends on LIMIT  
5,508
Goran Prijic
03/24/2011 04:38AM
Re: ORDER BY Optimization depends on LIMIT  
1,221
Rick James
03/25/2011 08:03AM
Optimizing a query with group by and order by count  
9,105
mansup kulel
03/20/2011 01:32AM
Re: Optimizing a query with group by and order by count  
2,903
Rick James
03/21/2011 10:08AM
Re: Optimizing a query with group by and order by count  
3,267
mansup kulel
03/21/2011 10:32PM
Re: Optimizing a query with group by and order by count  
2,777
Rick James
03/22/2011 07:41PM
Two columns indexes  
2,156
Roy Chan
03/20/2011 10:37PM
Re: Two columns indexes  
1,240
Rick James
03/22/2011 07:54AM
optimising query with group by order by count  
3,276
mansup kulel
03/20/2011 01:22AM
Re: optimising query with group by order by count  
1,310
Rick James
03/21/2011 10:14AM
Urgent. Optimize crash. DB increased the size  
2,342
Jose Molina
03/20/2011 04:48AM
Re: Urgent. Optimize crash. DB increased the size  
1,082
Rick James
03/21/2011 01:20AM
Optimize sub query with large group by  
4,051
Alex K
03/10/2011 07:44PM
Re: Optimize sub query with large group by  
2,239
Rick James
03/13/2011 03:52PM
Re: Optimize sub query with large group by  
1,964
Alex K
03/13/2011 04:59PM
Re: Optimize sub query with large group by  
2,944
Rick James
03/13/2011 11:32PM
Re: Optimize sub query with large group by  
2,241
Alex K
03/14/2011 02:39AM
Re: Optimize sub query with large group by  
1,700
Rick James
03/14/2011 06:31PM
Re: Optimize sub query with large group by  
1,595
Alex K
03/14/2011 07:15PM
Re: Optimize sub query with large group by  
1,871
Øystein Grøvlen
03/15/2011 04:32AM
Re: Optimize sub query with large group by  
1,659
Alex K
03/15/2011 08:46PM
Re: Optimize sub query with large group by  
2,410
Øystein Grøvlen
03/16/2011 02:02AM
Re: Optimize sub query with large group by  
2,318
Rick James
03/16/2011 08:57AM
Re: Optimize sub query with large group by  
1,681
Alex K
03/17/2011 12:40AM
Re: Optimize sub query with large group by  
3,672
Øystein Grøvlen
03/18/2011 10:58AM
explain a prepared statement  
3,464
Dorian Kuroki
03/09/2011 07:07AM
Re: explain a prepared statement  
1,593
Rick James
03/13/2011 02:13PM
Re: explain a prepared statement  
3,554
Dorian Kuroki
03/14/2011 07:11AM
Re: explain a prepared statement  
2,052
Rick James
03/14/2011 06:22PM
same query takes more time for different tables  
2,626
Radhakant Samal
02/24/2011 05:09AM
Re: same query takes more time for different tables  
1,253
Rick James
02/25/2011 11:32AM
profiler doesn't show me a query  
2,822
nick rulez
02/19/2011 05:48AM
Re: profiler doesn't show me a query  
1,445
nick rulez
02/19/2011 07:29AM
make mysql server use more cpu power  
4,617
Fred nolastname
02/10/2011 06:16AM
Re: make mysql server use more cpu power  
2,711
Rick James
02/12/2011 06:44PM
Re: make mysql server use more cpu power  
2,241
Fred nolastname
02/18/2011 07:59AM
Long query execution, about 1 hr  
3,725
eloe lelo
02/13/2011 10:07AM
Re: Long query execution, about 1 hr  
1,316
Rick James
02/14/2011 07:00PM
Re: Long query execution, about 1 hr  
1,331
eloe lelo
02/15/2011 03:04PM
Re: Long query execution, about 1 hr  
1,374
Rick James
02/16/2011 12:17AM
Queries using WHERE IN and ORDER BY LIMIT  
5,632
Nikita Dubrovsky
02/10/2011 10:55AM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,732
Rick James
02/12/2011 06:42PM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,692
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.