MySQL Forums
Forum List  »  Optimizer & Parser

Subject
Views
Written By
Posted
Re: Two nearly equal querys, but very different performance  
1,827
09/12/2006 09:34AM
Re: sometimes, mysql don't use an existing index  
2,782
09/11/2006 06:29AM
Re: slow corelated subquery, not sure how to rewrite  
1,998
09/03/2006 12:00AM
Re: slow corelated subquery, not sure how to rewrite  
1,828
09/10/2006 10:18PM
Re: best way to create 'next' and 'previous' text  
1,587
09/10/2006 09:01AM
3,177
09/09/2006 01:01AM
Re: Best index for my table  
1,781
09/09/2006 02:01PM
Re: Best index for my table  
1,734
09/10/2006 12:37AM
Re: Why do mysql use temporary and filesort here?  
2,161
09/08/2006 06:36AM
2,706
08/31/2006 08:02AM
Re: slow selects  
1,853
08/31/2006 08:43AM
Re: slow selects  
1,855
08/31/2006 09:06AM
Re: slow selects  
1,868
09/01/2006 03:04AM
Re: slow selects  
1,815
09/01/2006 04:17AM
Re: slow selects  
2,082
09/01/2006 04:50AM
Re: slow selects  
1,827
09/01/2006 07:24AM
Re: slow selects  
1,866
09/01/2006 08:16AM
Re: slow selects  
1,863
09/02/2006 12:52PM
2,662
08/21/2006 11:05AM
Re: Query Optimization  
1,688
08/21/2006 06:44PM
Re: Query Optimization  
1,701
08/27/2006 11:50PM
Re: Query Optimization  
1,817
08/28/2006 07:33AM
6,168
08/23/2006 08:16PM
Re: Optimizing a UNION Query  
2,650
08/24/2006 05:28AM
Re: Optimizing a UNION Query  
2,701
08/24/2006 12:12PM
Re: Optimizing a UNION Query  
5,370
08/25/2006 06:14AM
Re: Optimizing a UNION Query  
2,634
08/24/2006 04:59AM
Re: Really need help with optimization  
1,781
08/23/2006 12:50AM
Re: Really need help with optimization  
1,872
08/23/2006 01:24PM
Re: Really need help with optimization  
1,792
08/24/2006 04:53AM
Re: Really need help with optimization  
1,837
08/22/2006 01:46PM
2,563
08/22/2006 11:30PM
Re: Left Join Problem  
1,756
08/23/2006 09:00AM
Re: Left Join Problem  
1,754
08/23/2006 06:53PM
Re: Left Join Problem  
1,683
08/23/2006 07:12PM
Re: Left Join Problem  
1,876
08/23/2006 11:01PM
2,548
07/26/2006 07:13AM
Re: optimizing the query.  
1,827
08/22/2006 12:37PM
Re: optimizing the query.  
1,802
08/04/2006 04:50AM
Re: optimizing the query.  
1,731
07/27/2006 12:13AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
1,627
08/22/2006 03:26AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
8,412
08/21/2006 07:25AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
4,045
08/21/2006 07:55AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
2,961
08/22/2006 03:25AM
Re: Force Table Selection Order in JOIN Statement?  
9,663
08/21/2006 06:24AM
10,186
04/29/2006 05:30AM
Re: ORDER BY RAND() taking too much time  
3,810
06/08/2006 10:38AM
Re: ORDER BY RAND() taking too much time  
2,591
05/11/2006 04:25AM
Re: ORDER BY RAND() taking too much time  
3,123
05/03/2006 01:51AM
Re: ORDER BY RAND() taking too much time  
3,412
08/15/2006 05:13PM
Re: ORDER BY RAND() taking too much time  
2,917
05/03/2006 02:11AM
Re: ORDER BY RAND() taking too much time  
4,080
05/02/2006 08:44AM
Re: ORDER BY RAND() taking too much time  
3,530
05/02/2006 02:24PM
Re: ORDER BY RAND() taking too much time  
3,793
05/01/2006 08:49AM
Re: How to create on-the-fly index on derived table?  
7,287
08/12/2006 03:04PM
19,605
06/07/2006 10:00AM
Re: EXISTS() optimization  
6,578
07/25/2006 07:54AM
Re: EXISTS() optimization  
5,604
07/25/2006 01:13PM
Re: EXISTS() optimization  
5,237
08/04/2006 04:45AM
2,867
08/02/2006 02:02PM
Re: Too many rows being read  
1,717
08/02/2006 02:18PM
2,723
07/27/2006 12:05PM
Re: Why does this query filesort?  
1,810
08/01/2006 11:14PM
3,487
07/28/2006 03:33AM
2,506
06/23/2006 11:44AM
Re: query of tables with a longblob  
1,710
07/25/2006 01:26PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,752
07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,727
07/20/2006 10:09PM
Re: With vs Without Primary Key in a particular case  
2,835
07/20/2006 05:35PM
10,252
07/19/2006 06:11AM
3,382
07/17/2006 07:13AM
Re: LEFT JOIN problem  
1,809
07/17/2006 08:07AM
Re: LEFT JOIN problem  
1,759
07/17/2006 09:30AM
Re: LEFT JOIN problem  
1,766
07/17/2006 12:03PM
Re: LEFT JOIN problem  
1,691
07/17/2006 10:23PM
Re: (How) are subqueries optimized involving the same table?  
1,927
07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?  
1,773
07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?  
1,969
07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?  
1,784
07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?  
1,712
07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?  
1,941
07/13/2006 08:12AM
Re: How to get some documents or articles on the query optimization of MySQL????  
1,785
07/10/2006 05:12PM
5,491
07/02/2006 05:34PM
Re: min() vs limit optimization  
2,205
07/02/2006 08:26PM
Re: min() vs limit optimization  
2,144
07/03/2006 05:22PM
Re: min() vs limit optimization  
2,303
07/04/2006 06:51AM
Re: Slow Union Query Opimization. Need help.  
2,560
06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.  
2,922
06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.  
3,173
06/29/2006 08:24AM
2,853
06/27/2006 07:31AM
Re: querying time is too high  
1,901
06/29/2006 08:52AM
Re: querying time is too high  
1,895
06/29/2006 12:48AM
Re: querying time is too high  
1,940
06/28/2006 10:00AM
2,380
06/27/2006 07:17AM
Re: Joining several multi-to-multi tables  
2,027
06/23/2006 06:58AM
Re: Joining several multi-to-multi tables  
1,961
06/20/2006 12:21PM
Re: Joining several multi-to-multi tables  
1,927
06/20/2006 01:44PM
Re: Joining several multi-to-multi tables  
1,906
06/20/2006 04:23PM
Re: Joining several multi-to-multi tables  
1,874
06/20/2006 06:02PM
Re: Joining several multi-to-multi tables  
1,881
06/20/2006 01:02PM
Re: Joining several multi-to-multi tables  
1,865
06/20/2006 12:14PM
2,482
Uwe
05/22/2006 05:47AM
Re: no optimization?  
1,839
06/18/2006 08:50PM
Re: no optimization?  
1,801
Uwe
06/21/2006 10:40AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?  
1,751
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,157
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,279
06/20/2006 07:18AM
Re: Why does this delete statement take so long?  
2,066
06/15/2006 03:56PM
Re: Why does this delete statement take so long?  
1,993
06/15/2006 04:16PM
3,324
06/12/2006 06:11PM
Re: Why isn't the index being used?  
1,942
06/13/2006 04:03PM
Re: Why isn't the index being used?  
1,937
06/13/2006 09:54AM
Re: Why isn't the index being used?  
1,890
06/13/2006 10:34AM
Re: Why isn't the index being used?  
1,920
06/13/2006 09:11AM
Re: Why isn't the index being used?  
2,144
06/13/2006 08:41AM
Re: Why isn't the index being used?  
1,882
06/12/2006 06:41PM
5,902
06/13/2006 08:49AM
Re: How to avoid temporary and filesort?  
3,168
06/13/2006 09:06AM
Re: How to avoid temporary and filesort?  
3,343
06/13/2006 09:39AM
Re: How to avoid temporary and filesort?  
2,751
06/13/2006 10:31AM
12,571
06/11/2006 06:50PM
Re: How to avoid filesort  
6,180
06/12/2006 01:30PM
Re: How to avoid filesort  
6,907
06/12/2006 08:40AM
Re: How to avoid filesort  
6,139
06/12/2006 09:10AM
5,040
06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query  
2,534
06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query  
2,437
06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query  
2,448
06/12/2006 01:01PM
Re: Why is FULLTEXT index not used with a LEFT JOIN?  
2,155
06/11/2006 03:39PM
14,186
ylu
05/23/2006 03:35PM
Re: fast way to delete records?  
6,118
05/24/2006 06:43PM
Re: fast way to delete records?  
4,474
06/08/2006 12:30PM
Re: fast way to delete records?  
6,704
05/24/2006 07:29AM
2,826
06/08/2006 11:27AM
28,124
11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows  
5,610
06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows  
8,057
06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows  
9,093
11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows  
7,447
11/24/2005 09:18AM
3,186
06/07/2006 04:07AM
Re: Selecting a proper table stucture  
1,975
06/07/2006 09:47AM
9,156
05/31/2006 11:29AM
Re: Slow Database  
3,387
06/01/2006 04:14AM
Re: Slow Database  
2,556
06/01/2006 06:40PM
Re: Slow Database  
2,956
06/02/2006 02:17AM
Re: Slow Database  
2,784
06/05/2006 10:37AM
Re: Slow Database  
2,651
05/31/2006 07:43PM
Re: Slow Database  
2,604
06/01/2006 12:19AM
Re: Slow Database  
3,526
05/31/2006 12:06PM
Re: Slow Database  
2,820
05/31/2006 12:43PM
2,311
06/04/2006 09:34AM
4,820
05/29/2006 05:07AM
Re: Optimizing query with multiple joins  
2,271
05/30/2006 07:15AM
Re: Optimizing query with multiple joins  
2,406
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.