MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Connector/C 6.1.10 GA has been released 04/28/2017 11:34AM
MySQL Connector/J 5.1.42 has been released 04/27/2017 11:35PM
MySQL for Visual Studio 2.0.5 m4 release has been released 04/25/2017 04:25AM
MySQL Connector/Python 2.1.6 GA has been released 04/18/2017 08:49AM
MySQL Router 2.1.3 GA has been released 04/12/2017 12:17PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 17
Subject Views Written By Posted
Sticky:  Unofficial MySQL 8.0 Optimizer Guide (1 Posts)   107 Edwin Desouza 02/13/2017 04:16PM
Sticky:  MySQL 8.0: Window Functions (1 Posts)   151 Edwin Desouza 02/04/2017 08:57PM
Sticky:  MySQL 8.0: CTEs (1 Posts)   442 Edwin Desouza 10/18/2016 09:38AM
Sticky:  MySQL 8.0: Optimizer & Parser (1 Posts)   442 Edwin Desouza 09/13/2016 10:54AM
Sticky:  MySQL Performance Tuning (1 Posts)   1,285 Edwin Desouza 07/06/2015 10:37AM
Sticky:  MySQL Parser (1 Posts)   1,941 Edwin Desouza 04/03/2014 03:31PM
Sticky:  MySQL Optimizer: Features in MySQL 5.7 (1 Posts)   3,313 Edwin Desouza 12/18/2012 11:38AM
Sticky:  MySQL EXPLAIN (1 Posts)   3,862 Edwin Desouza 07/10/2012 10:32AM
Sticky:  MySQL Optimizer: Blogs (1 Posts)   9,365 Edwin DeSouza 04/28/2007 06:20PM
How to Analyze and Tune MySQL Queries for Better Performance   23 Edwin Desouza 04/27/2017 11:32AM
MySQL 8.0: Optimizer: What's New   26 Edwin Desouza 04/27/2017 11:31AM
MySQL 8.0 Optimizer Guide   24 Edwin Desouza 04/27/2017 11:30AM
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows   45 Edwin Desouza 04/12/2017 11:57AM
MySQL 8.0: Improved performance with CTE   53 Edwin Desouza 04/12/2017 11:57AM
MySQL 5.7: What to Do When the Optimizer Overestimates the Condition Filtering Effect   53 Edwin Desouza 03/24/2017 11:30AM
prepare don't work for optimize statement   87 Long WU 03/22/2017 12:30AM
Re: prepare don't work for optimize statement   29 Øystein Grøvlen 03/22/2017 01:34AM
MySQL 5.7: Improved JOIN Order by Taking Condition Filter Effect into Account   69 Edwin Desouza 03/17/2017 02:49PM
Improve search when using IN() ORDER BY PRIMARY and LIMIT   145 jon sans 02/11/2017 07:17AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT   56 jon sans 02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT   63 Øystein Grøvlen 02/13/2017 05:58AM
MySQL Performance Tuning: Optimizer Hints   128 Edwin Desouza 02/04/2017 09:09PM
Hiw to fast delete rows from table in relation?   176 Andrzej Borucki 01/22/2017 02:21AM
Re: Hiw to fast delete rows from table in relation?   91 Andrzej Borucki 01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?   107 Andrzej Borucki 01/22/2017 04:03AM
Query not always using indexes   227 K DBA 01/06/2017 05:48AM
Re: Query not always using indexes   103 Peter Brawley 01/06/2017 12:28PM
Re: Query not always using indexes   182 K DBA 01/09/2017 05:18AM
Re: Query not always using indexes   164 Øystein Grøvlen 01/09/2017 02:30AM
Optimize subquery, replace IN() with JOIN   322 Miron jajtic 11/15/2016 02:37PM
Re: Optimize subquery, replace IN() with JOIN   178 Peter Brawley 11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN   195 Miron jajtic 11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN   165 Rick James 11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN   162 Peter Brawley 11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN   182 Miron jajtic 11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN   165 Peter Brawley 11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN   184 Miron jajtic 11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN   180 Peter Brawley 11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN   131 sahar gull 12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN   167 Øystein Grøvlen 11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN   156 Miron jajtic 11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN   200 Øystein Grøvlen 11/16/2016 06:23AM
Improved Query Performance by Using Derived Table instead of IN-subquery   196 Edwin Desouza 12/23/2016 08:50AM
primary key vs covered index   287 marcin kot 11/30/2016 09:55AM
Re: primary key vs covered index   180 Øystein Grøvlen 12/01/2016 01:39AM
Re: primary key vs covered index   198 marcin kot 12/01/2016 03:38AM
Re: primary key vs covered index   182 Øystein Grøvlen 12/01/2016 03:57AM
Re: primary key vs covered index   154 marcin kot 12/01/2016 04:16AM
Re: primary key vs covered index   195 Øystein Grøvlen 12/01/2016 04:25AM
MySQL 8.0: Refactoring and Improving the Parser   320 Edwin Desouza 11/22/2016 10:58AM
MySQL subquery   380 harry sheng 10/27/2016 02:51PM
Re: MySQL subquery   171 Øystein Grøvlen 10/28/2016 01:03AM
Re: MySQL subquery   214 harry sheng 11/06/2016 08:50PM
Re: MySQL subquery   196 Øystein Grøvlen 11/07/2016 01:39AM
How to Analyze and Tune MySQL Queries for Better Performance   338 Edwin Desouza 10/21/2016 09:58AM
Index on timestamp   470 Adeline M 10/14/2016 08:47AM
Re: Index on timestamp   245 Rick James 10/16/2016 04:40PM
MySQL 8.0: Descending Indexes   462 Edwin Desouza 10/12/2016 10:00AM
Pivot table with dynamic columns   675 Aram Mirzadeh 09/30/2016 06:03PM
Re: Pivot table with dynamic columns   292 Rick James 10/03/2016 03:40PM
inner join vs left join - huge performance difference   659 michael cook 07/06/2016 09:32AM
Re: inner join vs left join - huge performance difference   287 Peter Brawley 07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference   216 michael cook 07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference   221 michael cook 07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference   204 Peter Brawley 07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference   250 michael cook 07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference   201 michael cook 07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference   225 Peter Brawley 07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference   193 michael cook 07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference   196 Rick James 07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference   210 Peter Brawley 07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference   217 Isabella Swan 09/27/2016 07:13AM
This topic has been moved.:  INSERT AfTER LEFT JOIN creates duplicate records   10 Brad Liu 09/20/2016 02:09PM
MySQL 8.0: Invisible Indexes   365 Edwin Desouza 09/20/2016 09:21AM
Preparse Query Rewrite Plugin DLL   670 Francois Haddad 08/12/2016 05:16PM
Re: Preparse Query Rewrite Plugin DLL   225 Georgi Kodinov 09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL   278 Francois Haddad 09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL   233 Tor Didriksen 09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL   264 Francois Haddad 09/15/2016 11:34AM
why the two query has a different execute plan?   635 h h 08/22/2016 02:55AM
Re: why the two query has a different execute plan?   234 Øystein Grøvlen 08/22/2016 05:08AM
Re: why the two query has a different execute plan?   212 Rick James 08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL   203 Francois Haddad 08/15/2016 09:28AM
how to optimize this sql?   441 h h 07/07/2016 07:38PM
Re: how to optimize this sql?   263 Peter Brawley 07/08/2016 10:59AM
Re: how to optimize this sql?   264 h h 07/12/2016 09:01PM
Re: how to optimize this sql?   258 Rick James 07/09/2016 11:04PM
Re: how to optimize this sql?   241 h h 07/12/2016 09:08PM
Re: how to optimize this sql?   238 Rick James 07/14/2016 12:52PM
Indexing for date column for range query   490 duc minh 07/05/2016 11:04PM
Re: Indexing for date column for range query   267 Rick James 07/09/2016 10:47PM
Help with partially unique index   579 El T 06/22/2016 04:44AM
Re: Help with partially unique index   279 Rick James 06/25/2016 10:45PM
Re: Help with partially unique index   263 El T 07/02/2016 03:33PM
Re: Help with partially unique index   260 Rick James 07/04/2016 12:50PM
Explain plans for InnoDB and Memory Engines   596 Jagan Kumar 05/02/2016 03:15PM
Re: Explain plans for InnoDB and Memory Engines   298 Peter Brawley 05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines   292 Øystein Grøvlen 05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines   300 Rick James 05/05/2016 10:18PM
MySQL Query Rewrite Plugins   689 Edwin Desouza 02/02/2016 09:48PM
why left join can not use unique index?   1,212 h h 12/07/2015 08:30PM
Re: why left join can not use unique index?   448 Rick James 12/08/2015 08:46PM
Re: why left join can not use unique index?   446 h h 12/11/2015 03:20AM
Re: why left join can not use unique index?   452 Rick James 12/15/2015 11:08AM
This topic has been moved.:  A stored function to remove diacritics and other chars   20 Marc Elbet 12/11/2015 03:50AM
prepared statement query takes 3s for a few hundred lines - query issue   831 Michael W. 11/16/2015 11:14AM
Re: prepared statement query takes 3s for a few hundred lines - query issue   402 Rick James 11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue   495 Michael W. 12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue   420 Rick James 12/07/2015 01:17AM
Why not use index   930 zhang peng 11/08/2015 11:14PM
Re: Why not use index   438 Peter Brawley 11/09/2015 11:42AM
Re: Why not use index   482 zhang peng 11/11/2015 12:17AM
Re: Why not use index   427 Øystein Grøvlen 11/10/2015 10:35AM
Re: Why not use index   467 zhang peng 11/11/2015 12:15AM
Re: Why not use index   432 Øystein Grøvlen 11/11/2015 03:40AM
Re: Why not use index   447 zhang peng 11/11/2015 07:29PM
Re: Why not use index   466 Peter Brawley 11/11/2015 11:00PM
Re: Why not use index   427 Øystein Grøvlen 11/12/2015 01:48AM
Re: Why not use index   442 zhang peng 11/16/2015 12:17AM
Google Update Optimizer system   839 Anik Bhowmik 11/09/2015 09:35PM
Re: Google Update Optimizer system   436 Peter Brawley 11/09/2015 10:12PM
Re: Google Update Optimizer system   426 Jonathan Stephens 11/10/2015 01:02AM
Normalize dump table   1,192 Jose Valle 10/11/2015 08:37PM
Re: Normalize dump table   412 Jose Valle 10/11/2015 08:42PM
Re: Normalize dump table   449 Antonio Valle 10/13/2015 01:41PM
Re: Normalize dump table   442 Rick James 10/17/2015 07:15PM
optimize query for index using between and group by   1,266 Raghavendra raghu 08/28/2015 03:21AM
Re: optimize query for index using between and group by   686 Rick James 08/29/2015 09:56AM
Re: optimize query for index using between and group by   515 Raghavendra raghu 08/31/2015 02:34AM
Parsing in MySQL Workbench: the ANTLR age   1,005 Edwin Desouza 08/14/2015 10:16AM
MySQL Optimizer: Hints   1,195 Edwin Desouza 07/29/2015 10:07AM
Index not working for date field used in between query   1,532 Shrinivasa rao 07/22/2015 11:48PM
Re: Index not working for date field used in between query   705 Rick James 07/26/2015 08:28AM
MyISAM using 'wrong' index   1,122 Danny Stommen 06/08/2015 04:14AM
Re: MyISAM using 'wrong' index   606 Rick James 06/09/2015 11:53PM
Re: MyISAM using 'wrong' index   632 Danny Stommen 06/30/2015 03:22AM
Re: MyISAM using 'wrong' index   662 Rick James 07/02/2015 09:28PM
Re: MyISAM using 'wrong' index   577 Danny Stommen 07/03/2015 03:16AM
Re: MyISAM using 'wrong' index   657 Rick James 07/04/2015 11:10AM
Re: MyISAM using 'wrong' index   575 Danny Stommen 07/07/2015 01:56AM
Re: MyISAM using 'wrong' index   551 Edwin Desouza 07/07/2015 09:10AM
Need help understanding optimizer behavior in 5.6   1,277 Aaron Craven 06/22/2015 08:30AM
Re: Need help understanding optimizer behavior in 5.6   632 Aaron Craven 06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6   573 Rick James 06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6   566 Aaron Craven 06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6   554 Rick James 06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6   564 Aaron Craven 06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6   556 Øystein Grøvlen 06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6   798 Aaron Craven 06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6   575 Aaron Craven 06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6   575 Øystein Grøvlen 07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6   557 Aaron Craven 07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6   606 Edwin Desouza 07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6   580 Aaron Craven 07/02/2015 07:48AM
MySQL 5.7: Optimizer Trace and EXPLAIN FORMAT=JSON   1,268 Edwin Desouza 05/25/2015 10:41AM
foreign key creation in a huge database   1,282 Raffael Vendrametto 03/05/2015 04:05PM
Please do NOT duplicate posts   681 Peter Brawley 03/05/2015 05:42PM
Query Taking 2.5hrs on 5.6.20 version   1,542 ch srinivas 03/04/2015 01:30AM
Re: Query Taking 2.5hrs on 5.6.20 version   721 Peter Brawley 03/04/2015 12:15PM
Re: Query Taking 2.5hrs on 5.6.20 version   656 Rick James 03/04/2015 08:18PM
Query optimisation advice   1,539 Paul Feely 01/08/2015 11:02PM
Re: Query optimisation advice   823 Rick James 01/10/2015 01:22AM
Re: Query optimisation advice   781 Paul Feely 01/11/2015 05:50PM
Re: Query optimisation advice   755 Rick James 01/12/2015 10:35PM
actual Size calculation of mysql table (engine innodb)   1,518 Afaque Ahmad Siddiqui 12/10/2014 09:38AM
Re: actual Size calculation of mysql table (engine innodb)   764 Rick James 12/12/2014 08:32PM
Re: actual Size calculation of mysql table (engine innodb)   785 Rick James 12/12/2014 08:36PM
MySQL cash optimization   1,658 Sasha Katsman 11/27/2014 06:33AM
Re: MySQL cash optimization   910 Peter Brawley 11/27/2014 04:34PM
Re: MySQL cash optimization   707 Sasha Katsman 12/09/2014 04:33AM
Re: MySQL cache optimization   676 Peter Brawley 12/09/2014 12:28PM
This topic has been moved.:  Improve search when using IN() ORDER BY PRIMARY and LIMIT   0 jon sans 02/11/2017 01:36PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 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.