MySQL Forums
Forum List  »  Optimizer & Parser
Pages:
« 1
...
5 6 7 8 9
...
19 »

Subject
Views
Written By
Posted
Re: Urgent. Optimize crash. DB increased the size  
896
03/21/2011 01:20AM
3,528
03/10/2011 07:44PM
Re: Optimize sub query with large group by  
1,967
03/13/2011 03:52PM
Re: Optimize sub query with large group by  
1,724
03/13/2011 04:59PM
Re: Optimize sub query with large group by  
2,685
03/13/2011 11:32PM
Re: Optimize sub query with large group by  
2,001
03/14/2011 02:39AM
Re: Optimize sub query with large group by  
1,471
03/14/2011 06:31PM
Re: Optimize sub query with large group by  
1,356
03/14/2011 07:15PM
Re: Optimize sub query with large group by  
1,613
03/15/2011 04:32AM
Re: Optimize sub query with large group by  
1,378
03/15/2011 08:46PM
Re: Optimize sub query with large group by  
2,066
03/16/2011 02:02AM
Re: Optimize sub query with large group by  
2,076
03/16/2011 08:57AM
Re: Optimize sub query with large group by  
1,390
03/17/2011 12:40AM
Re: Optimize sub query with large group by  
3,201
03/18/2011 10:58AM
3,021
03/09/2011 07:07AM
Re: explain a prepared statement  
1,307
03/13/2011 02:13PM
Re: explain a prepared statement  
3,058
03/14/2011 07:11AM
Re: explain a prepared statement  
1,751
03/14/2011 06:22PM
Re: same query takes more time for different tables  
1,070
02/25/2011 11:32AM
2,414
02/19/2011 05:48AM
Re: profiler doesn't show me a query  
1,247
02/19/2011 07:29AM
Re: make mysql server use more cpu power  
2,424
02/12/2011 06:44PM
Re: make mysql server use more cpu power  
1,962
02/18/2011 07:59AM
3,261
02/13/2011 10:07AM
Re: Long query execution, about 1 hr  
1,097
02/14/2011 07:00PM
Re: Long query execution, about 1 hr  
1,078
02/15/2011 03:04PM
Re: Long query execution, about 1 hr  
1,120
02/16/2011 12:17AM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,439
02/12/2011 06:42PM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,438
02/14/2011 07:06PM
2,673
02/10/2011 05:14AM
Re: select query optimize  
1,184
02/12/2011 06:56PM
Re: select query optimize  
1,154
02/14/2011 06:26AM
7,586
01/19/2011 08:56AM
Re: GROUP BY Not Using Index  
3,691
01/20/2011 10:02PM
Re: GROUP BY Not Using Index  
2,655
01/21/2011 05:04PM
Re: GROUP BY Not Using Index  
2,247
01/21/2011 11:07PM
Re: GROUP BY Not Using Index  
2,276
02/08/2011 11:03AM
5,725
01/26/2011 02:07PM
Re: Max Number of Indexes?  
1,900
01/27/2011 11:13AM
Re: Max Number of Indexes?  
1,485
01/29/2011 10:38PM
Re: Max Number of Indexes?  
2,272
02/02/2011 09:46AM
Re: Max Number of Indexes?  
1,381
02/08/2011 10:41AM
Re: Help with a very slow select query  
1,236
02/02/2011 06:02AM
Re: Help with a very slow select query  
1,068
02/02/2011 06:51AM
Re: Help with a very slow select query  
1,086
02/02/2011 10:24AM
Re: Help with a very slow select query  
1,046
02/02/2011 06:17AM
3,356
01/20/2011 01:00AM
Re: 500,000 rows - Slow when maintaining  
1,087
01/20/2011 10:55PM
Re: 500,000 rows - Slow when maintaining  
1,174
01/20/2011 04:58AM
Re: 500,000 rows - Slow when maintaining  
1,135
01/20/2011 12:17PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,241
01/19/2011 11:33AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,121
10/26/2010 10:40PM
Re: Query Tuning for NOT EQUAL TO <> operator  
1,828
10/31/2010 01:50PM
Re: Query Tuning for NOT EQUAL TO <> operator  
3,218
11/02/2010 02:21PM
2,629
01/13/2011 03:22PM
Re: Field calculated using the WHERE  
1,102
01/15/2011 12:42AM
5,391
12/27/2010 10:31PM
Re: identifying unused databases  
2,059
01/12/2011 10:31PM
Re: identifying unused databases  
1,661
01/15/2011 12:08AM
Re: identifying unused databases  
2,297
12/31/2010 08:26PM
Re: Explain shows different results on two servers  
1,542
01/14/2011 08:50AM
Re: same query sometimes very slow (punbb forum)  
1,744
01/07/2011 11:03PM
2,777
12/30/2010 10:59AM
Re: optimize select query  
1,162
12/31/2010 08:22PM
Re: optimize select query  
1,208
01/04/2011 04:07AM
Re: optimize select query  
1,424
01/06/2011 09:37PM
Re: optimize select query  
1,346
01/03/2011 01:02PM
Re: Please help optimizing a long running query (left outer join, with 2 subqueries)  
1,285
01/01/2011 07:21PM
3,785
12/21/2010 02:28PM
Re: SQL SELECT COUNT(*) TO SLOW  
1,737
12/26/2010 11:15AM
1,864
12/10/2010 04:02AM
Re: How to Optimize these sql?  
883
12/11/2010 02:17PM
2,374
12/01/2010 02:55PM
Re: basic 2 table query slow - where, index?  
1,123
12/05/2010 12:56PM
2,648
12/01/2010 10:42PM
Re: "Optimizing sub queries with joins"  
1,320
12/05/2010 12:45PM
Re: Optimized Indexing for a Schedule Table  
1,095
11/25/2010 02:35PM
Re: Optimized Indexing for a Schedule Table  
1,676
11/25/2010 10:47PM
Re: Optimized Indexing for a Schedule Table  
1,147
11/25/2010 11:05PM
Re: Optimized Indexing for a Schedule Table  
1,592
11/26/2010 01:42PM
Re: Optimized Indexing for a Schedule Table  
1,201
11/26/2010 11:36PM
Re: Optimized Indexing for a Schedule Table  
1,308
11/27/2010 01:31PM
Re: Optimized Indexing for a Schedule Table  
1,222
11/27/2010 02:44PM
Re: slow query sorting on group maximum  
1,284
11/19/2010 04:30PM
Re: slow query sorting on group maximum  
1,146
11/19/2010 07:14PM
Re: slow query sorting on group maximum  
1,421
11/22/2010 03:35AM
Re: slow query sorting on group maximum  
1,768
11/19/2010 07:05PM
Re: slow query sorting on group maximum  
1,158
11/19/2010 07:20PM
Re: slow query sorting on group maximum  
1,076
11/22/2010 03:33AM
Re: slow query sorting on group maximum  
1,224
11/06/2010 10:56AM
Re: slow query sorting on group maximum  
1,152
11/07/2010 07:24AM
Re: slow query sorting on group maximum  
1,228
11/07/2010 01:05PM
3,335
11/19/2010 08:54AM
Re: Optimizing queries with Wildcards  
1,101
11/20/2010 11:23AM
1,816
11/18/2010 10:18PM
Re: many databases or many tables  
1,125
11/20/2010 09:28AM
Re: 'not in' query is very slow how to change it?  
3,347
11/18/2010 12:59AM
Re: 'not in' query is very slow how to change it?  
2,088
11/18/2010 10:19PM
2,714
11/14/2010 11:41AM
Re: High Mysql Load - CPU 360%  
1,118
11/18/2010 01:22AM
2,255
11/15/2010 01:51PM
Re: Dynamic Queries Optimization  
1,319
11/18/2010 12:46AM
1,875
11/14/2010 09:40AM
Re: Can MySQL use index in a RANGE QUERY with ORDER BY?  
1,308
11/03/2010 09:17PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,278
10/26/2010 10:37PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,916
10/30/2010 03:42PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,295
11/02/2010 12:23PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,601
10/26/2010 10:32PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,265
10/30/2010 03:29PM
2,183
10/27/2010 08:27PM
Re: Normalise and optimise- Urgent  
987
10/28/2010 09:44PM
2,082
10/23/2010 03:27AM
Re: Slow query  
981
10/26/2010 10:42PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,325
10/05/2010 02:21PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,774
10/06/2010 09:11PM
Re: Database error : too many connectons  
1,447
09/14/2010 07:58AM
3,682
09/05/2010 08:16PM
Re: NOP optimises Group By?  
1,218
09/11/2010 01:22PM
Re: NOP optimises Group By? -solved  
1,448
09/12/2010 11:09PM
Re: NOP optimises Group By? -solved  
1,274
09/13/2010 08:15PM
Re: NOP optimises Group By? -solved  
1,213
09/13/2010 10:46PM
Re: NOP optimises Group By? -solved  
1,236
09/13/2010 10:56AM
Re: how to avoir filesort and temporary with theses 2 little tables ?  
957
09/09/2010 11:49PM
20,681
08/18/2010 05:46AM
Re: left join with sum and group by  
7,767
08/20/2010 11:40PM
Re: left join with sum and group by  
4,158
08/23/2010 04:26AM
Re: left join with sum and group by  
6,126
08/27/2010 08:01PM
Re: left join with sum and group by  
3,650
09/07/2010 05:08AM
3,333
08/28/2010 09:58AM
Re: Query cache was never filled up  
1,355
08/29/2010 09:25PM
2,418
08/25/2010 03:33AM
Re: Speed problem  
1,146
08/27/2010 08:03AM
Re: SQL CACHE Not used. When it should be?  
1,838
08/17/2010 08:34AM
Re: Optimize: most recent N items with join  
1,252
08/08/2010 10:35AM
Re: Query Optimization on time-based data  
2,113
08/05/2010 10:35PM
Re: Advice on indexing a datetime column  
9,855
07/24/2010 09:58PM
Re: Advice on indexing a datetime column  
7,489
07/25/2010 02:01AM
Re: Advice on indexing a datetime column  
6,599
07/27/2010 10:29PM
Re: Estimating Index Size on Innodb Tables  
4,000
07/27/2010 08:08PM
6,598
07/22/2010 11:20AM
Re: Optimize my my.ini  
2,074
07/25/2010 10:26PM
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.