MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Connector/J 5.1.39 has been released 05/09/2016 02:23PM
MySQL Enterprise Backup 3.12.3 has been released 05/09/2016 11:30AM
MySQL Enterprise Monitor 3.2.1 has been released 05/03/2016 01:09PM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
Regression: Query optimized in 4.1, not at all in 5.0, why?   2,092 William Shubert 06/21/2006 12:35AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?   1,479 William Shubert 06/21/2006 12:36AM
RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min   3,663 Ijaz Rashid 06/20/2006 07:06AM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min   1,764 Bill Karwin 06/20/2006 12:18PM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min   1,802 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,149 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,765 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,670 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,670 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,629 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,690 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,676 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,652 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,771 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,637 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   4,908 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,909 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   2,967 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,469 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   11,860 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,813 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,501 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,791 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,421 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,212 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,108 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,055 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,262 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,872 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   12,744 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,516 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,127 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   5,995 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,285 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,265 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   5,041 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,632 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,621 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   7,007 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,493 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,653 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,365 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,810 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,289 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,466 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,417 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,317 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,307 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,118 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,470 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,765 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,277 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   2,020 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,043 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,133 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,323 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,509 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,633 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,706 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,197 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,014 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,845 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,901 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,049 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,086 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,496 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,552 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,872 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,132 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,552 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,574 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   1,979 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,546 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,309 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   2,021 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,091 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,875 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,755 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   20,968 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,561 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   2,076 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,688 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,799 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,092 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,915 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,304 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   2,036 Björn Steinbrink 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,948 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,711 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,809 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,979 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,964 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,724 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,913 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,207 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,312 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,555 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,210 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,190 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,802 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,808 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,593 Björn Steinbrink 05/03/2006 03:31PM
Re: Query Optimization   1,637 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,607 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,675 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,634 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,847 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,599 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,149 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,433 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   2,006 Björn Steinbrink 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   8,226 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,281 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,944 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   3,106 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   3,156 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   3,123 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,834 Björn Steinbrink 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   15,672 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,368 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,174 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,578 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,210 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,614 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   2,022 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,505 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,548 Björn Steinbrink 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,569 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,255 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,209 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   2,035 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,491 Apachez 04/21/2006 04:26AM
where condition optimization   2,436 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,544 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,566 prasanna 04/19/2006 02:26AM
Database structure question   2,095 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,540 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,915 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,963 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,772 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,563 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,563 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,636 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,602 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,702 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,650 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,594 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   2,005 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,257 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,705 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,560 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,584 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,570 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,672 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,878 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,562 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   2,035 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,189 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,600 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   2,023 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,987 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,601 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,791 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,798 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,818 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,674 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,678 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,597 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,623 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,556 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   2,037 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,849 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,740 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,616 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,143 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,962 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,913 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,595 Björn Steinbrink 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,927 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,835 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,921 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   4,022 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,793 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,768 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,369 Björn Steinbrink 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,736 Björn Steinbrink 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,686 Björn Steinbrink 03/24/2006 11:02AM
Query Optimization   2,217 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,564 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,496 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,618 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,323 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,799 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,198 Tobias Marx 03/20/2006 05:26PM
Query   2,131 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,628 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,576 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,561 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,597 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,611 Ilan Goldman 03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"   30,854 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,975 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,648 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,785 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,261 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   19,124 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,762 Solon Barns 03/06/2006 08:27AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 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.