MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
Re: Two nearly equal querys, but very different performance  
1,932
09/12/2006 09:34AM
Re: sometimes, mysql don't use an existing index  
2,882
09/11/2006 06:29AM
Re: slow corelated subquery, not sure how to rewrite  
2,088
09/03/2006 12:00AM
Re: slow corelated subquery, not sure how to rewrite  
1,938
09/10/2006 10:18PM
Re: best way to create 'next' and 'previous' text  
1,684
09/10/2006 09:01AM
3,354
09/09/2006 01:01AM
Re: Best index for my table  
1,881
09/09/2006 02:01PM
Re: Best index for my table  
1,830
09/10/2006 12:37AM
Re: Why do mysql use temporary and filesort here?  
2,274
09/08/2006 06:36AM
2,916
08/31/2006 08:02AM
Re: slow selects  
1,955
08/31/2006 08:43AM
Re: slow selects  
1,949
08/31/2006 09:06AM
Re: slow selects  
1,955
09/01/2006 03:04AM
Re: slow selects  
1,920
09/01/2006 04:17AM
Re: slow selects  
2,190
09/01/2006 04:50AM
Re: slow selects  
1,919
09/01/2006 07:24AM
Re: slow selects  
1,961
09/01/2006 08:16AM
Re: slow selects  
1,957
09/02/2006 12:52PM
2,825
08/21/2006 11:05AM
Re: Query Optimization  
1,779
08/21/2006 06:44PM
Re: Query Optimization  
1,789
08/27/2006 11:50PM
Re: Query Optimization  
1,928
08/28/2006 07:33AM
6,356
08/23/2006 08:16PM
Re: Optimizing a UNION Query  
2,758
08/24/2006 05:28AM
Re: Optimizing a UNION Query  
2,802
08/24/2006 12:12PM
Re: Optimizing a UNION Query  
5,501
08/25/2006 06:14AM
Re: Optimizing a UNION Query  
2,747
08/24/2006 04:59AM
Re: Really need help with optimization  
1,883
08/23/2006 12:50AM
Re: Really need help with optimization  
1,960
08/23/2006 01:24PM
Re: Really need help with optimization  
1,904
08/24/2006 04:53AM
Re: Really need help with optimization  
1,928
08/22/2006 01:46PM
2,750
08/22/2006 11:30PM
Re: Left Join Problem  
1,852
08/23/2006 09:00AM
Re: Left Join Problem  
1,888
08/23/2006 06:53PM
Re: Left Join Problem  
1,776
08/23/2006 07:12PM
Re: Left Join Problem  
1,967
08/23/2006 11:01PM
2,758
07/26/2006 07:13AM
Re: optimizing the query.  
1,933
08/22/2006 12:37PM
Re: optimizing the query.  
1,903
08/04/2006 04:50AM
Re: optimizing the query.  
1,838
07/27/2006 12:13AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
1,733
08/22/2006 03:26AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
8,534
08/21/2006 07:25AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
4,158
08/21/2006 07:55AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
3,061
08/22/2006 03:25AM
Re: Force Table Selection Order in JOIN Statement?  
9,802
08/21/2006 06:24AM
10,433
04/29/2006 05:30AM
Re: ORDER BY RAND() taking too much time  
3,906
06/08/2006 10:38AM
Re: ORDER BY RAND() taking too much time  
2,706
05/11/2006 04:25AM
Re: ORDER BY RAND() taking too much time  
3,214
05/03/2006 01:51AM
Re: ORDER BY RAND() taking too much time  
3,514
08/15/2006 05:13PM
Re: ORDER BY RAND() taking too much time  
3,038
05/03/2006 02:11AM
Re: ORDER BY RAND() taking too much time  
4,200
05/02/2006 08:44AM
Re: ORDER BY RAND() taking too much time  
3,637
05/02/2006 02:24PM
Re: ORDER BY RAND() taking too much time  
3,890
05/01/2006 08:49AM
Re: How to create on-the-fly index on derived table?  
7,498
08/12/2006 03:04PM
19,856
06/07/2006 10:00AM
Re: EXISTS() optimization  
6,740
07/25/2006 07:54AM
Re: EXISTS() optimization  
5,718
07/25/2006 01:13PM
Re: EXISTS() optimization  
5,353
08/04/2006 04:45AM
3,074
08/02/2006 02:02PM
Re: Too many rows being read  
1,849
08/02/2006 02:18PM
2,912
07/27/2006 12:05PM
Re: Why does this query filesort?  
1,905
08/01/2006 11:14PM
3,691
07/28/2006 03:33AM
2,677
06/23/2006 11:44AM
Re: query of tables with a longblob  
1,810
07/25/2006 01:26PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,870
07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,831
07/20/2006 10:09PM
Re: With vs Without Primary Key in a particular case  
2,936
07/20/2006 05:35PM
10,506
07/19/2006 06:11AM
3,571
07/17/2006 07:13AM
Re: LEFT JOIN problem  
1,899
07/17/2006 08:07AM
Re: LEFT JOIN problem  
1,853
07/17/2006 09:30AM
Re: LEFT JOIN problem  
1,863
07/17/2006 12:03PM
Re: LEFT JOIN problem  
1,785
07/17/2006 10:23PM
Re: (How) are subqueries optimized involving the same table?  
2,042
07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?  
1,869
07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?  
2,065
07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?  
1,886
07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?  
1,826
07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?  
2,046
07/13/2006 08:12AM
Re: How to get some documents or articles on the query optimization of MySQL????  
1,879
07/10/2006 05:12PM
5,721
07/02/2006 05:34PM
Re: min() vs limit optimization  
2,292
07/02/2006 08:26PM
Re: min() vs limit optimization  
2,240
07/03/2006 05:22PM
Re: min() vs limit optimization  
2,403
07/04/2006 06:51AM
Re: Slow Union Query Opimization. Need help.  
2,662
06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.  
3,043
06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.  
3,294
06/29/2006 08:24AM
3,044
06/27/2006 07:31AM
Re: querying time is too high  
1,995
06/29/2006 08:52AM
Re: querying time is too high  
2,013
06/29/2006 12:48AM
Re: querying time is too high  
2,055
06/28/2006 10:00AM
2,607
06/27/2006 07:17AM
Re: Joining several multi-to-multi tables  
2,145
06/23/2006 06:58AM
Re: Joining several multi-to-multi tables  
2,054
06/20/2006 12:21PM
Re: Joining several multi-to-multi tables  
2,025
06/20/2006 01:44PM
Re: Joining several multi-to-multi tables  
2,008
06/20/2006 04:23PM
Re: Joining several multi-to-multi tables  
1,998
06/20/2006 06:02PM
Re: Joining several multi-to-multi tables  
1,991
06/20/2006 01:02PM
Re: Joining several multi-to-multi tables  
1,985
06/20/2006 12:14PM
2,698
Uwe
05/22/2006 05:47AM
Re: no optimization?  
1,960
06/18/2006 08:50PM
Re: no optimization?  
1,933
Uwe
06/21/2006 10:40AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?  
1,898
06/21/2006 12:36AM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min  
2,278
06/20/2006 12:18PM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min  
2,407
06/20/2006 07:18AM
Re: Why does this delete statement take so long?  
2,188
06/15/2006 03:56PM
Re: Why does this delete statement take so long?  
2,113
06/15/2006 04:16PM
3,548
06/12/2006 06:11PM
Re: Why isn't the index being used?  
2,069
06/13/2006 04:03PM
Re: Why isn't the index being used?  
2,069
06/13/2006 09:54AM
Re: Why isn't the index being used?  
1,997
06/13/2006 10:34AM
Re: Why isn't the index being used?  
2,045
06/13/2006 09:11AM
Re: Why isn't the index being used?  
2,286
06/13/2006 08:41AM
Re: Why isn't the index being used?  
2,008
06/12/2006 06:41PM
6,152
06/13/2006 08:49AM
Re: How to avoid temporary and filesort?  
3,289
06/13/2006 09:06AM
Re: How to avoid temporary and filesort?  
3,491
06/13/2006 09:39AM
Re: How to avoid temporary and filesort?  
2,876
06/13/2006 10:31AM
12,793
06/11/2006 06:50PM
Re: How to avoid filesort  
6,310
06/12/2006 01:30PM
Re: How to avoid filesort  
7,032
06/12/2006 08:40AM
Re: How to avoid filesort  
6,284
06/12/2006 09:10AM
5,247
06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query  
2,656
06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query  
2,554
06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query  
2,566
06/12/2006 01:01PM
Re: Why is FULLTEXT index not used with a LEFT JOIN?  
2,296
06/11/2006 03:39PM
14,436
ylu
05/23/2006 03:35PM
Re: fast way to delete records?  
6,274
05/24/2006 06:43PM
Re: fast way to delete records?  
4,613
06/08/2006 12:30PM
Re: fast way to delete records?  
6,874
05/24/2006 07:29AM
3,044
06/08/2006 11:27AM
28,491
11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows  
5,762
06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows  
8,220
06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows  
9,245
11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows  
7,606
11/24/2005 09:18AM
3,442
06/07/2006 04:07AM
Re: Selecting a proper table stucture  
2,100
06/07/2006 09:47AM
9,403
05/31/2006 11:29AM
Re: Slow Database  
3,516
06/01/2006 04:14AM
Re: Slow Database  
2,676
06/01/2006 06:40PM
Re: Slow Database  
3,088
06/02/2006 02:17AM
Re: Slow Database  
2,914
06/05/2006 10:37AM
Re: Slow Database  
2,762
05/31/2006 07:43PM
Re: Slow Database  
2,748
06/01/2006 12:19AM
Re: Slow Database  
3,628
05/31/2006 12:06PM
Re: Slow Database  
2,936
05/31/2006 12:43PM
2,507
06/04/2006 09:34AM
5,029
05/29/2006 05:07AM
Re: Optimizing query with multiple joins  
2,397
05/30/2006 07:15AM
Re: Optimizing query with multiple joins  
2,506
05/29/2006 08:36AM
Pages:
« 1
...
15 16 17 18 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.