MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
Re: Two nearly equal querys, but very different performance  
1,835
09/12/2006 09:34AM
Re: sometimes, mysql don't use an existing index  
2,785
09/11/2006 06:29AM
Re: slow corelated subquery, not sure how to rewrite  
2,002
09/03/2006 12:00AM
Re: slow corelated subquery, not sure how to rewrite  
1,833
09/10/2006 10:18PM
Re: best way to create 'next' and 'previous' text  
1,591
09/10/2006 09:01AM
3,189
09/09/2006 01:01AM
Re: Best index for my table  
1,787
09/09/2006 02:01PM
Re: Best index for my table  
1,739
09/10/2006 12:37AM
Re: Why do mysql use temporary and filesort here?  
2,167
09/08/2006 06:36AM
2,716
08/31/2006 08:02AM
Re: slow selects  
1,857
08/31/2006 08:43AM
Re: slow selects  
1,860
08/31/2006 09:06AM
Re: slow selects  
1,873
09/01/2006 03:04AM
Re: slow selects  
1,822
09/01/2006 04:17AM
Re: slow selects  
2,088
09/01/2006 04:50AM
Re: slow selects  
1,832
09/01/2006 07:24AM
Re: slow selects  
1,872
09/01/2006 08:16AM
Re: slow selects  
1,867
09/02/2006 12:52PM
2,669
08/21/2006 11:05AM
Re: Query Optimization  
1,692
08/21/2006 06:44PM
Re: Query Optimization  
1,707
08/27/2006 11:50PM
Re: Query Optimization  
1,823
08/28/2006 07:33AM
6,176
08/23/2006 08:16PM
Re: Optimizing a UNION Query  
2,655
08/24/2006 05:28AM
Re: Optimizing a UNION Query  
2,705
08/24/2006 12:12PM
Re: Optimizing a UNION Query  
5,376
08/25/2006 06:14AM
Re: Optimizing a UNION Query  
2,637
08/24/2006 04:59AM
Re: Really need help with optimization  
1,786
08/23/2006 12:50AM
Re: Really need help with optimization  
1,876
08/23/2006 01:24PM
Re: Really need help with optimization  
1,796
08/24/2006 04:53AM
Re: Really need help with optimization  
1,841
08/22/2006 01:46PM
2,572
08/22/2006 11:30PM
Re: Left Join Problem  
1,766
08/23/2006 09:00AM
Re: Left Join Problem  
1,759
08/23/2006 06:53PM
Re: Left Join Problem  
1,689
08/23/2006 07:12PM
Re: Left Join Problem  
1,881
08/23/2006 11:01PM
2,563
07/26/2006 07:13AM
Re: optimizing the query.  
1,836
08/22/2006 12:37PM
Re: optimizing the query.  
1,811
08/04/2006 04:50AM
Re: optimizing the query.  
1,738
07/27/2006 12:13AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
1,633
08/22/2006 03:26AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
8,421
08/21/2006 07:25AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
4,049
08/21/2006 07:55AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
2,965
08/22/2006 03:25AM
Re: Force Table Selection Order in JOIN Statement?  
9,670
08/21/2006 06:24AM
10,198
04/29/2006 05:30AM
Re: ORDER BY RAND() taking too much time  
3,813
06/08/2006 10:38AM
Re: ORDER BY RAND() taking too much time  
2,596
05/11/2006 04:25AM
Re: ORDER BY RAND() taking too much time  
3,129
05/03/2006 01:51AM
Re: ORDER BY RAND() taking too much time  
3,415
08/15/2006 05:13PM
Re: ORDER BY RAND() taking too much time  
2,923
05/03/2006 02:11AM
Re: ORDER BY RAND() taking too much time  
4,084
05/02/2006 08:44AM
Re: ORDER BY RAND() taking too much time  
3,535
05/02/2006 02:24PM
Re: ORDER BY RAND() taking too much time  
3,799
05/01/2006 08:49AM
Re: How to create on-the-fly index on derived table?  
7,304
08/12/2006 03:04PM
19,616
06/07/2006 10:00AM
Re: EXISTS() optimization  
6,586
07/25/2006 07:54AM
Re: EXISTS() optimization  
5,608
07/25/2006 01:13PM
Re: EXISTS() optimization  
5,245
08/04/2006 04:45AM
2,877
08/02/2006 02:02PM
Re: Too many rows being read  
1,723
08/02/2006 02:18PM
2,734
07/27/2006 12:05PM
Re: Why does this query filesort?  
1,816
08/01/2006 11:14PM
3,501
07/28/2006 03:33AM
2,518
06/23/2006 11:44AM
Re: query of tables with a longblob  
1,715
07/25/2006 01:26PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,758
07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,734
07/20/2006 10:09PM
Re: With vs Without Primary Key in a particular case  
2,841
07/20/2006 05:35PM
10,267
07/19/2006 06:11AM
3,392
07/17/2006 07:13AM
Re: LEFT JOIN problem  
1,817
07/17/2006 08:07AM
Re: LEFT JOIN problem  
1,764
07/17/2006 09:30AM
Re: LEFT JOIN problem  
1,771
07/17/2006 12:03PM
Re: LEFT JOIN problem  
1,698
07/17/2006 10:23PM
Re: (How) are subqueries optimized involving the same table?  
1,933
07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?  
1,778
07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?  
1,977
07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?  
1,791
07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?  
1,720
07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?  
1,949
07/13/2006 08:12AM
Re: How to get some documents or articles on the query optimization of MySQL????  
1,791
07/10/2006 05:12PM
5,505
07/02/2006 05:34PM
Re: min() vs limit optimization  
2,209
07/02/2006 08:26PM
Re: min() vs limit optimization  
2,151
07/03/2006 05:22PM
Re: min() vs limit optimization  
2,307
07/04/2006 06:51AM
Re: Slow Union Query Opimization. Need help.  
2,566
06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.  
2,930
06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.  
3,183
06/29/2006 08:24AM
2,866
06/27/2006 07:31AM
Re: querying time is too high  
1,907
06/29/2006 08:52AM
Re: querying time is too high  
1,903
06/29/2006 12:48AM
Re: querying time is too high  
1,946
06/28/2006 10:00AM
2,394
06/27/2006 07:17AM
Re: Joining several multi-to-multi tables  
2,031
06/23/2006 06:58AM
Re: Joining several multi-to-multi tables  
1,965
06/20/2006 12:21PM
Re: Joining several multi-to-multi tables  
1,934
06/20/2006 01:44PM
Re: Joining several multi-to-multi tables  
1,909
06/20/2006 04:23PM
Re: Joining several multi-to-multi tables  
1,879
06/20/2006 06:02PM
Re: Joining several multi-to-multi tables  
1,884
06/20/2006 01:02PM
Re: Joining several multi-to-multi tables  
1,870
06/20/2006 12:14PM
2,490
Uwe
05/22/2006 05:47AM
Re: no optimization?  
1,842
06/18/2006 08:50PM
Re: no optimization?  
1,808
Uwe
06/21/2006 10:40AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?  
1,755
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,161
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,284
06/20/2006 07:18AM
Re: Why does this delete statement take so long?  
2,071
06/15/2006 03:56PM
Re: Why does this delete statement take so long?  
2,000
06/15/2006 04:16PM
3,333
06/12/2006 06:11PM
Re: Why isn't the index being used?  
1,949
06/13/2006 04:03PM
Re: Why isn't the index being used?  
1,942
06/13/2006 09:54AM
Re: Why isn't the index being used?  
1,898
06/13/2006 10:34AM
Re: Why isn't the index being used?  
1,927
06/13/2006 09:11AM
Re: Why isn't the index being used?  
2,148
06/13/2006 08:41AM
Re: Why isn't the index being used?  
1,888
06/12/2006 06:41PM
5,912
06/13/2006 08:49AM
Re: How to avoid temporary and filesort?  
3,175
06/13/2006 09:06AM
Re: How to avoid temporary and filesort?  
3,349
06/13/2006 09:39AM
Re: How to avoid temporary and filesort?  
2,758
06/13/2006 10:31AM
12,579
06/11/2006 06:50PM
Re: How to avoid filesort  
6,185
06/12/2006 01:30PM
Re: How to avoid filesort  
6,912
06/12/2006 08:40AM
Re: How to avoid filesort  
6,145
06/12/2006 09:10AM
5,054
06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query  
2,538
06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query  
2,443
06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query  
2,454
06/12/2006 01:01PM
Re: Why is FULLTEXT index not used with a LEFT JOIN?  
2,162
06/11/2006 03:39PM
14,197
ylu
05/23/2006 03:35PM
Re: fast way to delete records?  
6,122
05/24/2006 06:43PM
Re: fast way to delete records?  
4,478
06/08/2006 12:30PM
Re: fast way to delete records?  
6,708
05/24/2006 07:29AM
2,837
06/08/2006 11:27AM
28,138
11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows  
5,617
06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows  
8,065
06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows  
9,099
11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows  
7,453
11/24/2005 09:18AM
3,201
06/07/2006 04:07AM
Re: Selecting a proper table stucture  
1,982
06/07/2006 09:47AM
9,168
05/31/2006 11:29AM
Re: Slow Database  
3,393
06/01/2006 04:14AM
Re: Slow Database  
2,563
06/01/2006 06:40PM
Re: Slow Database  
2,962
06/02/2006 02:17AM
Re: Slow Database  
2,796
06/05/2006 10:37AM
Re: Slow Database  
2,658
05/31/2006 07:43PM
Re: Slow Database  
2,610
06/01/2006 12:19AM
Re: Slow Database  
3,532
05/31/2006 12:06PM
Re: Slow Database  
2,826
05/31/2006 12:43PM
2,320
06/04/2006 09:34AM
4,826
05/29/2006 05:07AM
Re: Optimizing query with multiple joins  
2,276
05/30/2006 07:15AM
Re: Optimizing query with multiple joins  
2,410
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.