MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Workbench 8.0.14 has been released 01/21/2019 09:57AM
•   MySQL Connector/NET 8.0.14 has been released 01/21/2019 09:35AM
•   MySQL Community Server 5.7.25 has been released 01/21/2019 08:56AM
•   MySQL Connector/J 8.0.14 has been released 01/21/2019 08:51AM
•   MySQL Connector/Python 8.0.14 has been released 01/21/2019 07:23AM

Subject
Views
Written By
Posted
1,912
05/29/2014 11:26PM
Re: How could this SQL be optimized?  
954
05/30/2014 02:41AM
Re: How could this SQL be optimized?  
1,023
05/30/2014 02:46AM
Re: How could this SQL be optimized?  
880
08/21/2014 11:03PM
Re: How could this SQL be optimized?  
885
08/22/2014 01:54AM
Re: simple uses of order by datetime keep causing 'using filesort'  
1,035
08/20/2014 07:34PM
Re: Expland and slow-query don't agree  
840
08/04/2014 01:23PM
2,036
06/13/2014 07:51AM
Re: Query not using index sporadically  
937
06/18/2014 02:48PM
1,972
05/28/2014 08:56PM
1,795
04/16/2014 02:07PM
Re: BETWEEN a DATE and a hard place  
905
04/18/2014 05:19PM
Re: BETWEEN a DATE and a hard place  
967
04/21/2014 08:36AM
Re: BETWEEN a DATE and a hard place  
971
04/24/2014 08:20PM
Re: BETWEEN a DATE and a hard place  
1,084
04/25/2014 06:36AM
Re: BETWEEN a DATE and a hard place  
894
04/26/2014 05:46AM
Re: BETWEEN a DATE and a hard place  
931
04/28/2014 07:27AM
Re: BETWEEN a DATE and a hard place  
982
05/01/2014 09:41AM
Re: BETWEEN a DATE and a hard place  
1,031
05/02/2014 11:39AM
Re: Access mysql blob data from stored procedure  
1,017
04/15/2014 11:14AM
Re: PARTITION table ADD INDEX ERROR 1041 (HY000) Out of memory  
1,248
03/06/2014 11:21PM
Re: PARTITION table ADD INDEX ERROR 1041 (HY000) Out of memory  
1,143
03/06/2014 11:23PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,124
02/14/2014 01:29AM
Re: Explain estimate completely wrong for range when partitioned by day  
1,213
02/14/2014 09:44AM
Re: Explain estimate completely wrong for range when partitioned by day  
1,180
02/14/2014 03:07PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,091
02/14/2014 02:58PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,054
02/15/2014 12:39PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,119
02/15/2014 12:42PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,085
03/04/2014 12:27PM
Re: Explain estimate completely wrong for range when partitioned by day  
1,172
02/17/2014 04:29PM
3,144
11/16/2013 02:42PM
Re: Subquery with range uses filesort  
1,207
11/17/2013 07:42PM
Re: Subquery with range uses filesort  
1,176
11/17/2013 08:01PM
Re: Subquery with range uses filesort  
1,166
11/18/2013 04:33PM
Re: Subquery with range uses filesort  
1,676
11/18/2013 07:54PM
Re: Subquery with range uses filesort  
1,330
11/19/2013 04:10PM
Re: Subquery with range uses filesort  
1,242
11/19/2013 08:36PM
Re: Subquery with range uses filesort  
1,336
11/21/2013 02:55PM
Re: Subquery with range uses filesort  
1,534
12/05/2013 03:46PM
Re: Subquery with range uses filesort  
1,152
12/07/2013 02:10PM
Re: Subquery with range uses filesort  
1,174
12/09/2013 06:08PM
Re: Subquery with range uses filesort  
1,173
12/14/2013 09:51PM
Re: Subquery with range uses filesort  
1,153
12/14/2013 10:17PM
Re: Subquery with range uses filesort  
1,232
12/15/2013 11:29PM
Re: Subquery with range uses filesort  
1,224
12/17/2013 06:58PM
Re: Subquery with range uses filesort  
1,165
12/18/2013 05:49PM
Re: Subquery with range uses filesort  
1,190
12/18/2013 08:28PM
Re: Subquery with range uses filesort  
1,270
12/19/2013 10:13PM
Re: Subquery with range uses filesort  
1,222
12/19/2013 10:28PM
Re: Subquery with range uses filesort  
1,108
12/20/2013 07:06PM
Re: Subquery with range uses filesort  
1,208
12/21/2013 07:36AM
Re: Subquery with range uses filesort  
1,229
12/22/2013 10:01AM
Re: Subquery with range uses filesort  
1,280
12/22/2013 10:45AM
Re: Subquery with range uses filesort  
1,135
12/25/2013 09:30PM
Re: Optimizer executes inperformant subquery first  
1,096
12/07/2013 02:30PM
Re: Optimizer executes inperformant subquery first  
1,364
12/07/2013 03:49PM
Re: Optimizer executes inperformant subquery first  
1,487
12/09/2013 09:48AM
Re: Optimizer executes inperformant subquery first  
1,270
12/18/2013 03:04AM
Re: Optimizer executes inperformant subquery first  
1,200
12/19/2013 02:45AM
Re: Optimizer executes inperformant subquery first  
1,086
12/20/2013 02:24AM
Re: Optimizer executes inperformant subquery first  
1,037
12/23/2013 08:07AM
Re: Optimizer executes inperformant subquery first  
1,065
12/23/2013 01:11PM
Re: Optimizer executes inperformant subquery first  
1,179
12/18/2013 05:16AM
Re: Optimizer executes inperformant subquery first  
1,183
12/18/2013 06:49PM
Re: Optimizer executes inperformant subquery first  
1,103
12/19/2013 02:49AM
my.cnf  
2,016
10/27/2013 02:08PM
Re: my.cnf  
993
10/29/2013 07:12PM
3,180
10/28/2013 03:39AM
Re: my.cnf optimization please help  
1,138
10/29/2013 07:10PM
Re: I need help in optimzing a order by clause in a join query  
1,039
10/10/2013 09:34PM
Re: I need help in optimzing a order by clause in a join query  
1,014
10/12/2013 02:07PM
Re: I need help in optimzing a order by clause in a join query  
1,029
10/16/2013 08:36PM
2,116
10/03/2013 09:32PM
2,223
09/18/2013 03:06AM
Re: Very slow dependent subquery  
1,313
09/18/2013 07:06AM
Re: Very slow dependent subquery  
1,244
09/18/2013 07:51AM
Re: Very slow dependent subquery  
1,208
09/18/2013 02:57PM
Re: Very slow dependent subquery  
1,112
09/18/2013 02:13PM
Re: Very slow dependent subquery  
1,091
09/18/2013 03:10PM
Re: Very slow dependent subquery  
1,089
09/24/2013 10:04PM
Re: Very slow dependent subquery  
1,345
09/25/2013 12:53AM
Re: big database +1 million rows/days  
1,063
09/12/2013 01:37AM
Re: big database +1 million rows/days  
1,053
09/13/2013 10:59PM
Re: Optimize query join with 25,000 records  
1,030
08/31/2013 04:19PM
Re: Index not used for JOIN on compound key plus WHERE range filter  
1,484
08/15/2013 10:44AM
Re: Index not used for JOIN on compound key plus WHERE range filter  
1,225
08/31/2013 04:13PM
1,666
08/15/2013 05:23AM
Re: query index not used  
931
08/31/2013 03:41PM
Re: optimize request with order by and limit  
1,213
07/20/2013 10:25PM
Re: optimize request with order by and limit  
1,036
07/22/2013 09:46AM
Re: optimize request with order by and limit  
958
07/23/2013 08:58AM
Re: optimize request with order by and limit  
1,012
07/26/2013 04:07AM
Re: optimize request with order by and limit  
1,023
07/26/2013 11:53PM
Re: optimize request with order by and limit  
1,097
07/29/2013 04:40AM
Re: optimize request with order by and limit  
1,017
08/01/2013 10:39PM
Re: providing a single line for multiple records from a table  
920
07/24/2013 09:08AM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,392
05/22/2013 06:41PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,313
05/24/2013 12:40PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,243
05/25/2013 11:43AM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,147
05/30/2013 05:30PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,198
06/02/2013 01:15PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,320
06/03/2013 05:02PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
2,451
06/04/2013 11:49PM
2,292
05/10/2013 05:35AM
Re: Query optimization  
1,133
05/12/2013 08:42PM
Re: Query optimization  
1,087
05/15/2013 06:45AM
Re: Query optimization  
1,104
05/15/2013 08:35AM
Re: Query optimization  
1,173
05/16/2013 08:18AM
Re: Query optimization  
1,104
05/17/2013 03:52AM
Re: Query optimization  
1,110
05/17/2013 11:47PM
Re: Query optimization  
1,006
05/21/2013 08:51AM
Re: Query optimization  
1,100
05/22/2013 08:08AM
Re: Index optimized left join with group by  
1,107
03/12/2013 04:16AM
Re: Select last row that is less than or equal to a date  
1,518
01/24/2013 10:27PM
Re: Select last row that is less than or equal to a date  
1,536
01/26/2013 09:35AM
Re: Select last row that is less than or equal to a date  
1,338
01/27/2013 10:19AM
Re: Select last row that is less than or equal to a date  
1,426
01/27/2013 12:00PM
Re: Select last row that is less than or equal to a date  
1,268
01/29/2013 12:51AM
Re: Select last row that is less than or equal to a date  
1,259
01/29/2013 06:28PM
Re: Select last row that is less than or equal to a date  
1,692
01/30/2013 04:50AM
Re: Select last row that is less than or equal to a date  
1,358
01/30/2013 05:50PM
Re: Select last row that is less than or equal to a date  
1,288
02/01/2013 06:03AM
Re: Select last row that is less than or equal to a date  
1,359
02/02/2013 07:14AM
Re: Select last row that is less than or equal to a date  
1,322
02/02/2013 01:49PM
Re: Select last row that is less than or equal to a date  
1,345
02/02/2013 02:25PM
Re: Select last row that is less than or equal to a date  
1,232
02/03/2013 05:58AM
Re: Select last row that is less than or equal to a date  
1,263
02/03/2013 10:04AM
Re: Select last row that is less than or equal to a date  
1,338
02/03/2013 10:43AM
Re: Select last row that is less than or equal to a date  
1,821
02/03/2013 12:33PM
Re: Select last row that is less than or equal to a date  
1,326
02/03/2013 02:59PM
Re: Select last row that is less than or equal to a date  
1,400
02/03/2013 03:35PM
Re: Select last row that is less than or equal to a date  
1,360
02/03/2013 04:02PM
Re: Select last row that is less than or equal to a date  
1,368
02/03/2013 04:15PM
2,357
01/29/2013 10:18AM
Re: Very slow query, help please  
1,272
01/30/2013 05:12AM
Re: Very slow query, help please  
1,257
01/30/2013 08:38AM
Re: Very slow query, help please  
1,331
01/30/2013 09:05AM
Re: CPU load very very high !!!!, Please assist !!  
2,625
01/22/2013 11:32PM
Re: Can we expect an enhancement for derived table merge optimization?  
1,314
01/07/2013 10:50PM
Re: Can we expect an enhancement for derived table merge optimization?  
1,716
01/11/2013 09:18AM
Re: Can we expect an enhancement for derived table merge optimization?  
1,175
01/13/2013 12:24PM
Re: Can we expect an enhancement for derived table merge optimization?  
1,311
01/14/2013 08:43AM
Re: Can we expect an enhancement for derived table merge optimization?  
1,155
01/14/2013 09:54AM
Re: Can we expect an enhancement for derived table merge optimization?  
1,243
01/15/2013 06:15AM
Re: Can we expect an enhancement for derived table merge optimization?  
1,172
01/11/2013 08:51AM
Re: How to best optimize MYSQL Database  
1,170
12/21/2012 12:49PM
Re: mysql subquery query optimization question  
1,107
01/13/2013 11:30AM
2,094
01/06/2013 01:00AM
Re: Create a New Datatype  
1,043
01/07/2013 11:01PM
Re: Optimizer for innodb does not reduce "data_free"  
1,485
12/08/2012 01:33PM
2,434
11/03/2012 04:16PM
Re: Complex query - need advise  
1,207
11/03/2012 04:24PM
Re: Complex query - need advise  
1,154
11/04/2012 10:05AM
Re: Complex query - need advise  
1,490
11/05/2012 11:12AM
Re: Follow up on "Query Execution Plan"  
1,122
10/25/2012 11:14AM
Re: Follow up on "Query Execution Plan"  
975
10/25/2012 06:15AM
2,144
10/13/2012 11:52AM
Re: JOIN query too slow  
1,041
10/14/2012 10:26AM
Re: JOIN query too slow  
1,078
10/16/2012 07:48PM
4,417
09/25/2012 02:51PM
Re: bulk update very slow  
1,634
09/26/2012 02:58PM
Re: bulk update very slow  
1,606
09/27/2012 08:19PM
Re: bulk update very slow  
2,012
09/27/2012 12:01PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,276
09/23/2012 03:46PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,299
09/23/2012 08:24PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,027
09/24/2012 11:43PM
1,996
09/17/2012 09:09AM
Re: Join? Union? I am so lost.  
1,037
09/18/2012 07:48AM
Re: How make indexes work with group by statement  
1,070
09/15/2012 10:34PM
Re: How make indexes work with group by statement  
1,110
09/13/2012 01:50AM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
1,021
09/06/2012 10:42PM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
1,110
09/06/2012 04:32AM
2,107
08/27/2012 10:47PM
Re: optimize the query  
1,076
08/28/2012 01:43AM
Re: optimize the query  
963
08/29/2012 04:15AM
Re: optimize the query  
1,029
08/29/2012 04:39AM
Re: optimize the query  
941
08/29/2012 05:38AM
Re: optimize the query  
1,009
08/30/2012 07:20AM
2,449
08/14/2012 01:06PM
Re: Query with GROUP BY not using Index  
1,143
08/15/2012 02:46AM
Re: Query with GROUP BY not using Index  
1,092
08/16/2012 10:30AM
Re: Query with GROUP BY not using Index  
1,243
08/17/2012 02:58AM
Re: Query with GROUP BY not using Index  
1,101
08/18/2012 10:30PM
Re: Query with GROUP BY not using Index  
1,039
08/24/2012 12:41PM
Re: Query with GROUP BY not using Index  
1,124
08/28/2012 03:11AM
Re: Query with GROUP BY not using Index  
1,146
08/28/2012 06:21PM
Re: Query with GROUP BY not using Index  
1,460
08/29/2012 01:28AM
Re: Query with GROUP BY not using Index  
1,046
08/29/2012 10:36AM
Pages:
« 1 2 3 4 5
...
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.