MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.2.4 has been released 07/22/2016 12:36PM
MySQL Cluster 7.2.25 has been released 07/18/2016 08:38AM
MySQL Cluster 7.4.12 has been released 07/18/2016 05:35AM
MySQL Cluster 7.3.14 has been released 07/18/2016 04:29AM
MySQL Connector/Python 2.2.0 m1 Development Release has been released 07/12/2016 10:30AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
Boolean search and 99% cpu   1,965 Taiyo Rai 06/27/2006 07:17AM
Joining several multi-to-multi tables   2,844 adambrill1986 06/20/2006 11:59AM
Re: Joining several multi-to-multi tables   1,759 adambrill1986 06/23/2006 06:58AM
Re: Joining several multi-to-multi tables   1,612 adambrill1986 06/20/2006 12:21PM
Re: Joining several multi-to-multi tables   1,625 adambrill1986 06/20/2006 01:44PM
Re: Joining several multi-to-multi tables   1,546 Bill Karwin 06/20/2006 04:23PM
Re: Joining several multi-to-multi tables   1,549 KimSeong Loh 06/20/2006 06:02PM
Re: Joining several multi-to-multi tables   1,557 Bill Karwin 06/20/2006 01:02PM
Re: Joining several multi-to-multi tables   1,563 Bill Karwin 06/20/2006 12:14PM
no optimization?   1,990 Uwe 05/22/2006 05:47AM
Re: no optimization?   1,611 Apachez 06/18/2006 08:50PM
Re: no optimization?   1,538 Uwe 06/21/2006 10:40AM
Regression: Query optimized in 4.1, not at all in 5.0, why?   2,102 William Shubert 06/21/2006 12:35AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?   1,490 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,719 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,775 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,816 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,189 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,771 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,673 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,692 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,642 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,699 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,690 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,664 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,782 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,649 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   4,948 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,918 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   2,978 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,478 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   11,892 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,820 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,509 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,801 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,436 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,222 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,119 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,069 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,284 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,878 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   12,818 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,533 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,141 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   6,026 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,301 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,415 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   5,064 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,651 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,642 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   7,024 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,517 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,667 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,425 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,853 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,296 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,495 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,433 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,340 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,327 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,128 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,484 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,792 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,294 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   2,033 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,052 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,149 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,328 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,517 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,640 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,757 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,213 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,030 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,857 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,910 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,060 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,101 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,519 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,557 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,886 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,161 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,561 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,584 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   1,997 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,565 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,340 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   2,038 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,103 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,888 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,763 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   21,212 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,590 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   2,112 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,746 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,816 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,109 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,928 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,316 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   2,049 Björn Steinbrink 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,957 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,723 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,837 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,994 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,978 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,744 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,933 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,217 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,335 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,561 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,220 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,206 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,813 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,840 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,603 Björn Steinbrink 05/03/2006 03:31PM
Re: Query Optimization   1,648 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,614 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,687 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,643 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,870 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,611 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,160 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,443 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   2,017 Björn Steinbrink 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   8,403 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,363 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,980 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   3,146 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   3,195 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   3,158 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,876 Björn Steinbrink 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   15,841 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,451 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,188 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,590 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,219 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,624 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   2,036 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,513 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,556 Björn Steinbrink 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,644 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,288 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,250 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   2,048 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,501 Apachez 04/21/2006 04:26AM
where condition optimization   2,453 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,549 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,577 prasanna 04/19/2006 02:26AM
Database structure question   2,110 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,548 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,948 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,971 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,817 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,569 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,573 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,648 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,611 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,713 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,663 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,601 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   2,016 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,278 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,715 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,570 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,591 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,578 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,683 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,895 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,569 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   2,054 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,215 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,611 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   2,035 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,999 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,624 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,803 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,806 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,825 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,685 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,689 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,602 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,634 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,568 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   2,047 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,860 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,748 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,621 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,164 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,973 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,935 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,601 Björn Steinbrink 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,939 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,843 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,928 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   4,053 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,815 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,779 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,390 Björn Steinbrink 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,740 Björn Steinbrink 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,693 Björn Steinbrink 03/24/2006 11:02AM
Query Optimization   2,229 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,569 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,508 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,623 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,341 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,802 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,203 Tobias Marx 03/20/2006 05:26PM
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.