MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/NET 6.10.9 has been released 07/29/2019 10:27PM
•   MySQL Connector/J 5.1.48 GA has been released 07/29/2019 01:52PM
•   MySQL Cluster 7.3.26 has been released 07/23/2019 08:40AM
•   MySQL Cluster 7.4.25 has been released 07/23/2019 01:56AM
•   MySQL Cluster 7.5.15 has been released 07/23/2019 01:40AM
Pages:
« 1
...
5 6 7 8 9
...
18 »

Subject
Views
Written By
Posted
3,202
02/13/2011 10:07AM
Re: Long query execution, about 1 hr  
1,081
02/14/2011 07:00PM
Re: Long query execution, about 1 hr  
1,062
02/15/2011 03:04PM
Re: Long query execution, about 1 hr  
1,105
02/16/2011 12:17AM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,405
02/12/2011 06:42PM
Re: Queries using WHERE IN and ORDER BY LIMIT  
1,407
02/14/2011 07:06PM
2,617
02/10/2011 05:14AM
Re: select query optimize  
1,163
02/12/2011 06:56PM
Re: select query optimize  
1,126
02/14/2011 06:26AM
7,506
01/19/2011 08:56AM
Re: GROUP BY Not Using Index  
3,659
01/20/2011 10:02PM
Re: GROUP BY Not Using Index  
2,622
01/21/2011 05:04PM
Re: GROUP BY Not Using Index  
2,216
01/21/2011 11:07PM
Re: GROUP BY Not Using Index  
2,242
02/08/2011 11:03AM
5,622
01/26/2011 02:07PM
Re: Max Number of Indexes?  
1,865
01/27/2011 11:13AM
Re: Max Number of Indexes?  
1,452
01/29/2011 10:38PM
Re: Max Number of Indexes?  
2,234
02/02/2011 09:46AM
Re: Max Number of Indexes?  
1,346
02/08/2011 10:41AM
Re: Help with a very slow select query  
1,214
02/02/2011 06:02AM
Re: Help with a very slow select query  
1,036
02/02/2011 06:51AM
Re: Help with a very slow select query  
1,066
02/02/2011 10:24AM
Re: Help with a very slow select query  
1,026
02/02/2011 06:17AM
3,325
01/20/2011 01:00AM
Re: 500,000 rows - Slow when maintaining  
1,070
01/20/2011 10:55PM
Re: 500,000 rows - Slow when maintaining  
1,157
01/20/2011 04:58AM
Re: 500,000 rows - Slow when maintaining  
1,118
01/20/2011 12:17PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,213
01/19/2011 11:33AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,084
10/26/2010 10:40PM
Re: Query Tuning for NOT EQUAL TO <> operator  
1,798
10/31/2010 01:50PM
Re: Query Tuning for NOT EQUAL TO <> operator  
3,166
11/02/2010 02:21PM
2,594
01/13/2011 03:22PM
Re: Field calculated using the WHERE  
1,079
01/15/2011 12:42AM
5,309
12/27/2010 10:31PM
Re: identifying unused databases  
2,033
01/12/2011 10:31PM
Re: identifying unused databases  
1,638
01/15/2011 12:08AM
Re: identifying unused databases  
2,258
12/31/2010 08:26PM
Re: Explain shows different results on two servers  
1,508
01/14/2011 08:50AM
Re: same query sometimes very slow (punbb forum)  
1,726
01/07/2011 11:03PM
2,747
12/30/2010 10:59AM
Re: optimize select query  
1,136
12/31/2010 08:22PM
Re: optimize select query  
1,175
01/04/2011 04:07AM
Re: optimize select query  
1,394
01/06/2011 09:37PM
Re: optimize select query  
1,319
01/03/2011 01:02PM
Re: Please help optimizing a long running query (left outer join, with 2 subqueries)  
1,263
01/01/2011 07:21PM
3,749
12/21/2010 02:28PM
Re: SQL SELECT COUNT(*) TO SLOW  
1,713
12/26/2010 11:15AM
1,823
12/10/2010 04:02AM
Re: How to Optimize these sql?  
860
12/11/2010 02:17PM
2,329
12/01/2010 02:55PM
Re: basic 2 table query slow - where, index?  
1,098
12/05/2010 12:56PM
2,593
12/01/2010 10:42PM
Re: "Optimizing sub queries with joins"  
1,298
12/05/2010 12:45PM
Re: Optimized Indexing for a Schedule Table  
1,076
11/25/2010 02:35PM
Re: Optimized Indexing for a Schedule Table  
1,652
11/25/2010 10:47PM
Re: Optimized Indexing for a Schedule Table  
1,129
11/25/2010 11:05PM
Re: Optimized Indexing for a Schedule Table  
1,576
11/26/2010 01:42PM
Re: Optimized Indexing for a Schedule Table  
1,177
11/26/2010 11:36PM
Re: Optimized Indexing for a Schedule Table  
1,292
11/27/2010 01:31PM
Re: Optimized Indexing for a Schedule Table  
1,203
11/27/2010 02:44PM
Re: slow query sorting on group maximum  
1,262
11/19/2010 04:30PM
Re: slow query sorting on group maximum  
1,129
11/19/2010 07:14PM
Re: slow query sorting on group maximum  
1,407
11/22/2010 03:35AM
Re: slow query sorting on group maximum  
1,753
11/19/2010 07:05PM
Re: slow query sorting on group maximum  
1,141
11/19/2010 07:20PM
Re: slow query sorting on group maximum  
1,061
11/22/2010 03:33AM
Re: slow query sorting on group maximum  
1,208
11/06/2010 10:56AM
Re: slow query sorting on group maximum  
1,136
11/07/2010 07:24AM
Re: slow query sorting on group maximum  
1,210
11/07/2010 01:05PM
3,306
11/19/2010 08:54AM
Re: Optimizing queries with Wildcards  
1,085
11/20/2010 11:23AM
1,795
11/18/2010 10:18PM
Re: many databases or many tables  
1,104
11/20/2010 09:28AM
Re: 'not in' query is very slow how to change it?  
3,315
11/18/2010 12:59AM
Re: 'not in' query is very slow how to change it?  
2,070
11/18/2010 10:19PM
2,673
11/14/2010 11:41AM
Re: High Mysql Load - CPU 360%  
1,096
11/18/2010 01:22AM
2,228
11/15/2010 01:51PM
Re: Dynamic Queries Optimization  
1,297
11/18/2010 12:46AM
1,852
11/14/2010 09:40AM
Re: Can MySQL use index in a RANGE QUERY with ORDER BY?  
1,287
11/03/2010 09:17PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,254
10/26/2010 10:37PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,889
10/30/2010 03:42PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,269
11/02/2010 12:23PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,579
10/26/2010 10:32PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,242
10/30/2010 03:29PM
2,154
10/27/2010 08:27PM
Re: Normalise and optimise- Urgent  
970
10/28/2010 09:44PM
2,049
10/23/2010 03:27AM
Re: Slow query  
965
10/26/2010 10:42PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,306
10/05/2010 02:21PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,741
10/06/2010 09:11PM
Re: Database error : too many connectons  
1,431
09/14/2010 07:58AM
3,642
09/05/2010 08:16PM
Re: NOP optimises Group By?  
1,185
09/11/2010 01:22PM
Re: NOP optimises Group By? -solved  
1,413
09/12/2010 11:09PM
Re: NOP optimises Group By? -solved  
1,250
09/13/2010 08:15PM
Re: NOP optimises Group By? -solved  
1,185
09/13/2010 10:46PM
Re: NOP optimises Group By? -solved  
1,213
09/13/2010 10:56AM
Re: how to avoir filesort and temporary with theses 2 little tables ?  
945
09/09/2010 11:49PM
20,006
08/18/2010 05:46AM
Re: left join with sum and group by  
7,648
08/20/2010 11:40PM
Re: left join with sum and group by  
4,101
08/23/2010 04:26AM
Re: left join with sum and group by  
6,040
08/27/2010 08:01PM
Re: left join with sum and group by  
3,593
09/07/2010 05:08AM
3,282
08/28/2010 09:58AM
Re: Query cache was never filled up  
1,336
08/29/2010 09:25PM
2,376
08/25/2010 03:33AM
Re: Speed problem  
1,138
08/27/2010 08:03AM
Re: SQL CACHE Not used. When it should be?  
1,814
08/17/2010 08:34AM
Re: Optimize: most recent N items with join  
1,230
08/08/2010 10:35AM
Re: Query Optimization on time-based data  
2,094
08/05/2010 10:35PM
Re: Advice on indexing a datetime column  
9,549
07/24/2010 09:58PM
Re: Advice on indexing a datetime column  
7,292
07/25/2010 02:01AM
Re: Advice on indexing a datetime column  
6,429
07/27/2010 10:29PM
Re: Estimating Index Size on Innodb Tables  
3,965
07/27/2010 08:08PM
6,378
07/22/2010 11:20AM
Re: Optimize my my.ini  
2,015
07/25/2010 10:26PM
2,442
07/19/2010 12:54PM
Re: Help Optimizing My SELECT Query  
1,170
07/21/2010 01:06PM
4,294
07/13/2010 03:30PM
Re: Analyze question  
1,385
07/14/2010 10:48PM
Re: Analyze question  
1,581
07/15/2010 11:26AM
Re: Analyze question  
1,389
07/15/2010 08:54PM
Re: query executes slowly in a table with 2m records  
1,328
07/14/2010 11:12PM
3,418
07/14/2010 10:50AM
Re: Can we write one query instead of following three query?  
1,162
07/11/2010 11:47PM
Re: multicolumn index & forcing index to avoid filesort  
1,588
07/05/2010 11:58PM
This topic has been moved.:  Analyze question  
0
07/14/2010 10:18PM
Pages:
« 1
...
5 6 7 8 9
...
18 »

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.