MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.27 has been released 08/22/2016 12:00PM
MySQL Connector/NET 7.0.4 m3 development has been released 08/22/2016 08:36AM
MySQL Utilities 1.6.4 GA has been released 08/05/2016 10:44AM
MySQL Enterprise Backup 4.0.3 has been released 08/05/2016 09:28AM
MySQL Notifier 1.1.7 has been released 08/01/2016 04:37PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 17
Subject Views Written By Posted
MySQL My.cnf Config Help   1,726 Mathieu Louis 10/03/2013 09:32PM
Very slow dependent subquery   1,869 patrick canarelli 09/18/2013 03:06AM
Re: Very slow dependent subquery   1,034 Øystein Grøvlen 09/18/2013 07:06AM
Re: Very slow dependent subquery   1,000 patrick canarelli 09/18/2013 07:51AM
Re: Very slow dependent subquery   1,012 Øystein Grøvlen 09/18/2013 02:57PM
Re: Very slow dependent subquery   919 Peter Brawley 09/18/2013 02:13PM
Re: Very slow dependent subquery   963 patrick canarelli 09/18/2013 03:10PM
Re: Very slow dependent subquery   954 Rick James 09/24/2013 10:04PM
Re: Very slow dependent subquery   1,063 patrick canarelli 09/25/2013 12:53AM
big database +1 million rows/days   1,958 khaoula el hammoumi 09/11/2013 04:06AM
Re: big database +1 million rows/days   944 khaoula el hammoumi 09/12/2013 01:37AM
Re: big database +1 million rows/days   937 Rick James 09/13/2013 10:59PM
Optimize query join with 25,000 records   1,652 Andrea Presazzi 08/26/2013 02:27AM
Re: Optimize query join with 25,000 records   871 Rick James 08/31/2013 04:19PM
Index not used for JOIN on compound key plus WHERE range filter   2,449 Chad B 08/15/2013 09:24AM
Re: Index not used for JOIN on compound key plus WHERE range filter   1,142 Chad B 08/15/2013 10:44AM
Re: Index not used for JOIN on compound key plus WHERE range filter   1,005 Rick James 08/31/2013 04:13PM
query index not used   1,399 Adrian Petre 08/15/2013 05:23AM
Re: query index not used   799 Rick James 08/31/2013 03:41PM
optimize request with order by and limit   1,919 yassine laouija 07/18/2013 05:26AM
Re: optimize request with order by and limit   998 Rick James 07/20/2013 10:25PM
Re: optimize request with order by and limit   913 yassine laouija 07/22/2013 09:46AM
Re: optimize request with order by and limit   800 Rick James 07/23/2013 08:58AM
Re: optimize request with order by and limit   887 yassine laouija 07/26/2013 04:07AM
Re: optimize request with order by and limit   906 Rick James 07/26/2013 11:53PM
Re: optimize request with order by and limit   905 yassine laouija 07/29/2013 04:40AM
Re: optimize request with order by and limit   907 Rick James 08/01/2013 10:39PM
providing a single line for multiple records from a table   1,535 raja chacham 07/23/2013 09:56AM
Re: providing a single line for multiple records from a table   785 Rick James 07/24/2013 09:08AM
Optimize Inner Join With WHERE BETWEEN dates   2,521 Anthony Galano 05/21/2013 07:32PM
Re: Optimize Inner Join With WHERE BETWEEN dates   1,189 Rick James 05/22/2013 06:41PM
Re: Optimize Inner Join With WHERE BETWEEN dates   1,092 Anthony Galano 05/24/2013 12:40PM
Re: Optimize Inner Join With WHERE BETWEEN dates   1,073 Rick James 05/25/2013 11:43AM
Re: Optimize Inner Join With WHERE BETWEEN dates   980 Anthony Galano 05/30/2013 05:30PM
Re: Optimize Inner Join With WHERE BETWEEN dates   1,021 Rick James 06/02/2013 01:15PM
Re: Optimize Inner Join With WHERE BETWEEN dates   1,023 Anthony Galano 06/03/2013 05:02PM
Re: Optimize Inner Join With WHERE BETWEEN dates   1,826 Rick James 06/04/2013 11:49PM
Query optimization   1,986 Jan Kowalski 05/10/2013 05:35AM
Re: Query optimization   1,013 Rick James 05/12/2013 08:42PM
Re: Query optimization   973 Jan Kowalski 05/15/2013 06:45AM
Re: Query optimization   922 Jan Kowalski 05/15/2013 08:35AM
Re: Query optimization   954 Rick James 05/16/2013 08:18AM
Re: Query optimization   939 Jan Kowalski 05/17/2013 03:52AM
Re: Query optimization   950 Rick James 05/17/2013 11:47PM
Re: Query optimization   878 Jan Kowalski 05/21/2013 08:51AM
Re: Query optimization   949 Jan Kowalski 05/22/2013 08:08AM
MySQL Optimizer: When is a Subquery Executed?   1,458 Edwin Desouza 05/02/2013 10:05AM
Index optimized left join with group by   2,324 Michal Kurgan 03/11/2013 05:41PM
Re: Index optimized left join with group by   975 Øystein Grøvlen 03/12/2013 04:16AM
Select last row that is less than or equal to a date   4,888 David Marcus 01/23/2013 06:35PM
Re: Select last row that is less than or equal to a date   1,330 Rick James 01/24/2013 10:27PM
Re: Select last row that is less than or equal to a date   1,290 David Marcus 01/26/2013 09:35AM
Re: Select last row that is less than or equal to a date   1,190 Rick James 01/27/2013 10:19AM
Re: Select last row that is less than or equal to a date   1,188 David Marcus 01/27/2013 12:00PM
Re: Select last row that is less than or equal to a date   1,087 Rick James 01/29/2013 12:51AM
Re: Select last row that is less than or equal to a date   1,079 David Marcus 01/29/2013 06:28PM
Re: Select last row that is less than or equal to a date   1,387 Øystein Grøvlen 01/30/2013 04:50AM
Re: Select last row that is less than or equal to a date   1,189 David Marcus 01/30/2013 05:50PM
Re: Select last row that is less than or equal to a date   1,090 Øystein Grøvlen 02/01/2013 06:03AM
Re: Select last row that is less than or equal to a date   1,125 David Marcus 02/02/2013 07:14AM
Re: Select last row that is less than or equal to a date   1,135 Øystein Grøvlen 02/02/2013 01:49PM
Re: Select last row that is less than or equal to a date   1,098 David Marcus 02/02/2013 02:25PM
Re: Select last row that is less than or equal to a date   1,062 Øystein Grøvlen 02/03/2013 05:58AM
Re: Select last row that is less than or equal to a date   1,104 David Marcus 02/03/2013 10:04AM
Re: Select last row that is less than or equal to a date   1,172 Rick James 02/03/2013 10:43AM
Re: Select last row that is less than or equal to a date   1,545 David Marcus 02/03/2013 12:33PM
Re: Select last row that is less than or equal to a date   1,159 Rick James 02/03/2013 02:59PM
Re: Select last row that is less than or equal to a date   1,157 David Marcus 02/03/2013 03:35PM
Re: Select last row that is less than or equal to a date   1,180 Rick James 02/03/2013 04:02PM
Re: Select last row that is less than or equal to a date   1,221 David Marcus 02/03/2013 04:15PM
Very slow query, help please   1,873 Jaume Roca 01/29/2013 10:18AM
Re: Very slow query, help please   1,062 Øystein Grøvlen 01/30/2013 05:12AM
Re: Very slow query, help please   1,062 Rick James 01/30/2013 08:38AM
Re: Very slow query, help please   1,135 Jaume Roca 01/30/2013 09:05AM
MySQL 5.6: IN Subqueries Are Optimized away   1,543 Edwin Desouza 01/29/2013 01:08PM
CPU load very very high !!!!, Please assist !!   5,872 Sayed Ali 01/22/2013 06:49AM
Re: CPU load very very high !!!!, Please assist !!   2,118 Rick James 01/22/2013 11:32PM
New EXPLAIN Features in MySQL 5.6 – FORMAT=JSON actually adds more information!   1,652 Edwin Desouza 01/22/2013 05:58PM
Can we expect an enhancement for derived table merge optimization?   2,652 Michael Hogue 01/04/2013 12:04PM
Re: Can we expect an enhancement for derived table merge optimization?   1,093 Rick James 01/07/2013 10:50PM
Re: Can we expect an enhancement for derived table merge optimization?   1,365 Roy Lyseng 01/11/2013 09:18AM
Re: Can we expect an enhancement for derived table merge optimization?   1,020 Rick James 01/13/2013 12:24PM
Re: Can we expect an enhancement for derived table merge optimization?   1,089 Roy Lyseng 01/14/2013 08:43AM
Re: Can we expect an enhancement for derived table merge optimization?   938 Rick James 01/14/2013 09:54AM
Re: Can we expect an enhancement for derived table merge optimization?   1,048 Roy Lyseng 01/15/2013 06:15AM
Re: Can we expect an enhancement for derived table merge optimization?   1,014 Roy Lyseng 01/11/2013 08:51AM
How to best optimize MYSQL Database   1,868 Muhammad Usman 12/10/2012 03:45AM
Re: How to best optimize MYSQL Database   964 Rick James 12/21/2012 12:49PM
mysql subquery query optimization question   1,998 Yong Yim 01/12/2013 09:24AM
Re: mysql subquery query optimization question   934 Rick James 01/13/2013 11:30AM
Create a New Datatype   1,778 Andy Gurzynski 01/06/2013 01:00AM
Re: Create a New Datatype   888 Rick James 01/07/2013 11:01PM
MySQL Optimizer: InnoDB extended secondary keys   1,701 Edwin Desouza 12/21/2012 12:12PM
Optimizer for innodb does not reduce "data_free"   3,058 Sebastian Schött 12/06/2012 03:39AM
Re: Optimizer for innodb does not reduce "data_free"   1,249 Rick James 12/08/2012 01:33PM
Complex query - need advise   1,974 chris boer 11/03/2012 04:16PM
Re: Complex query - need advise   1,013 chris boer 11/03/2012 04:24PM
Re: Complex query - need advise   969 chris boer 11/04/2012 10:05AM
Re: Complex query - need advise   1,299 Rick James 11/05/2012 11:12AM
Follow up on "Query Execution Plan"   1,756 Chris Slominski 10/24/2012 11:59AM
Re: Follow up on "Query Execution Plan"   936 Chris Slominski 10/25/2012 11:14AM
Re: Follow up on "Query Execution Plan"   819 Chris Slominski 10/25/2012 06:15AM
JOIN query too slow   1,835 N. Kovac 10/13/2012 11:52AM
Re: JOIN query too slow   861 Peter Brawley 10/14/2012 10:26AM
Re: JOIN query too slow   879 Rick James 10/16/2012 07:48PM
bulk update very slow   3,868 james che 09/25/2012 02:51PM
Re: bulk update very slow   1,403 james che 09/26/2012 02:58PM
Re: bulk update very slow   1,330 Rick James 09/27/2012 08:19PM
Re: bulk update very slow   1,467 Jørgen Løland 09/27/2012 12:01PM
Why Query Cache Actived Returns Wrong Results?   1,892 Daniel Estrada 09/22/2012 08:57PM
Re: Why Query Cache Actived Returns Wrong Results?   1,025 Rick James 09/23/2012 03:46PM
Re: Why Query Cache Actived Returns Wrong Results?   1,116 Daniel Estrada 09/23/2012 08:24PM
Re: Why Query Cache Actived Returns Wrong Results?   896 Rick James 09/24/2012 11:43PM
Join? Union? I am so lost.   1,741 Hank Reardon 09/17/2012 09:09AM
Re: Join? Union? I am so lost.   857 Rick James 09/18/2012 07:48AM
How make indexes work with group by statement   1,659 Adnan Raza 09/13/2012 12:48AM
Re: How make indexes work with group by statement   885 Rick James 09/15/2012 10:34PM
Re: How make indexes work with group by statement   939 Jørgen Løland 09/13/2012 01:50AM
Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27   1,927 Dominik Bieringer 09/05/2012 02:57AM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27   890 Rick James 09/06/2012 10:42PM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27   900 Øystein Grøvlen 09/06/2012 04:32AM
optimize the query   1,756 ch srinivas 08/27/2012 10:47PM
Re: optimize the query   959 Øystein Grøvlen 08/28/2012 01:43AM
Re: optimize the query   842 ch srinivas 08/29/2012 04:15AM
Re: optimize the query   837 Øystein Grøvlen 08/29/2012 04:39AM
Re: optimize the query   818 ch srinivas 08/29/2012 05:38AM
Re: optimize the query   882 Rick James 08/30/2012 07:20AM
Query with GROUP BY not using Index   2,055 Imran Akbar 08/14/2012 01:06PM
Re: Query with GROUP BY not using Index   975 Øystein Grøvlen 08/15/2012 02:46AM
Re: Query with GROUP BY not using Index   936 Imran Akbar 08/16/2012 10:30AM
Re: Query with GROUP BY not using Index   977 Øystein Grøvlen 08/17/2012 02:58AM
Re: Query with GROUP BY not using Index   936 Rick James 08/18/2012 10:30PM
Re: Query with GROUP BY not using Index   868 Imran Akbar 08/24/2012 12:41PM
Re: Query with GROUP BY not using Index   951 Øystein Grøvlen 08/28/2012 03:11AM
Re: Query with GROUP BY not using Index   941 Imran Akbar 08/28/2012 06:21PM
Re: Query with GROUP BY not using Index   1,128 Øystein Grøvlen 08/29/2012 01:28AM
Re: Query with GROUP BY not using Index   894 Imran Akbar 08/29/2012 10:36AM
CONCAT and Index in where clause   6,947 Aurelien PANIZZA 08/22/2012 08:45AM
Re: CONCAT and Index in where clause   2,718 Øystein Grøvlen 08/23/2012 01:15AM
Re: CONCAT and Index in where clause   2,215 Rick James 08/23/2012 09:13PM
Re: CONCAT and Index in where clause   2,194 Aurelien PANIZZA 08/27/2012 09:53AM
Re: CONCAT and Index in where clause   2,334 Øystein Grøvlen 08/28/2012 02:50AM
Simple query spending too much time in 'statistics' state without reason   7,981 Vincent B. 08/21/2012 06:19AM
Re: Simple query spending too much time in 'statistics' state without reason   4,656 Jørgen Løland 08/24/2012 06:24AM
Re: Simple query spending too much time in 'statistics' state without reason   3,365 Vincent B. 08/28/2012 01:53AM
Re: Simple query spending too much time in 'statistics' state without reason   4,325 Rick James 08/22/2012 07:44PM
Order By Slows down Joins   2,727 Sami BH 08/22/2012 09:12AM
Re: Order By Slows down Joins   786 Rick James 08/23/2012 08:56PM
always uses filesort even after adding indexes   1,731 Pranav Gore 08/22/2012 02:49AM
Re: always uses filesort even after adding indexes   863 Rick James 08/22/2012 10:52PM
STRAIGHT_JOIN for OUTER JOINGS   2,410 Paul Tsui 08/19/2012 08:28PM
Re: STRAIGHT_JOIN for OUTER JOINGS   1,068 Øystein Grøvlen 08/20/2012 05:16AM
CPU usage 99% - and query very slow - help   3,248 irox ferenc 08/03/2012 10:49AM
Re: CPU usage 99% - and query very slow - help   1,281 Rick James 08/04/2012 01:36PM
Re: CPU usage 99% - and query very slow - help   1,894 robert eeeeee 08/06/2012 01:04PM
Re: CPU usage 99% - and query very slow - help   1,173 Øystein Grøvlen 08/15/2012 03:09AM
Execution plan: wrong index selected, very poor performance.   2,769 Andrej Andrejevic 07/18/2012 10:31AM
Re: Execution plan: wrong index selected, very poor performance.   1,196 Rick James 07/19/2012 10:07PM
Re: Execution plan: wrong index selected, very poor performance.   1,084 Andrej Andrejevic 07/20/2012 01:38AM
Re: Execution plan: wrong index selected, very poor performance.   948 Andrej Andrejevic 07/24/2012 04:27AM
Re: Execution plan: wrong index selected, very poor performance.   978 Rick James 07/25/2012 12:21AM
Index for Query   1,800 dileep ch 07/17/2012 12:41AM
Re: Index for Query   869 Rick James 07/17/2012 10:36PM
Re: Index for Query   917 dileep ch 07/18/2012 11:52PM
Re: Index for Query   1,486 Rick James 07/19/2012 09:49PM
best way to optimize this query   1,865 Jap bn 07/14/2012 09:54AM
Re: best way to optimize this query   1,241 Rick James 07/15/2012 10:11PM
Optimizer being overly aggressive   1,791 Adrian Cornish 07/06/2012 08:18PM
Re: Optimizer being overly aggressive   913 Rick James 07/10/2012 12:49PM
Re: Optimizer being overly aggressive   970 Adrian Cornish 07/10/2012 08:54PM
multiple-column index and order by   2,025 Raphael Hoffmann 07/06/2012 05:59PM
Re: multiple-column index and order by   946 Rick James 07/10/2012 12:55PM
From Months to Seconds with Subquery Materialization   1,364 Edwin DeSouza 07/09/2012 11:15AM
performing mysqldump corrected query issue?   1,712 Peter Sylvester 06/26/2012 01:12PM
Re: performing mysqldump corrected query issue?   964 Rick James 07/01/2012 06:43PM
Re: performing mysqldump corrected query issue?   828 Peter Sylvester 06/26/2012 02:08PM
difference between READ and SCAN   1,540 Linhai Song 06/20/2012 04:05PM
Re: difference between READ and SCAN   770 Rick James 06/20/2012 08:23PM
Re: difference between READ and SCAN   945 Linhai Song 06/21/2012 12:19PM
to optimize a self join request   1,424 Oracleuser user 06/14/2012 08:23AM
Re: to optimize a self join request   891 Rick James 06/15/2012 08:19AM
Call out for FULL JOIN - bug #18003   1,580 ted strauss 06/14/2012 10:23AM
Re: Call out for FULL JOIN - bug #18003   734 ted strauss 06/14/2012 12:13PM
index cannot be used when passing 'int' to 'varchar'   1,990 liao zhifeng 06/10/2012 11:16PM
Re: index cannot be used when passing 'int' to 'varchar'   816 Rick James 06/11/2012 11:27PM
Re: index cannot be used when passing 'int' to 'varchar'   836 liao zhifeng 06/12/2012 12:48AM
Re: index cannot be used when passing 'int' to 'varchar'   876 Rick James 06/12/2012 09:23PM
Re: index cannot be used when passing 'int' to 'varchar'   955 liao zhifeng 06/12/2012 11:16PM
Re: index cannot be used when passing 'int' to 'varchar'   834 Rick James 06/13/2012 07:15PM
Re: index cannot be used when passing 'int' to 'varchar'   810 liao zhifeng 06/13/2012 10:35PM
This topic has been moved.:  difference between READ and SCAN   0 Linhai Song 06/20/2012 05:47PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 17

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.