MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Community Server 5.6.29 has been released 02/05/2016 05:55PM
MySQL Community Server 5.5.48 has been released 02/05/2016 03:02PM
MySQL Community Server 5.7.11 has been released 02/05/2016 09:22AM
MySQL Cluster 7.5.0 has been released (part 3/3) 02/05/2016 02:12AM
MySQL Cluster 7.5.0 has been released (part 2/3) 02/05/2016 02:09AM
Pages:  Previous First... 13 14 15 16 17 Next
Current Page: 15 of 17
Subject Views Written By Posted
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,549 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,725 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,770 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,035 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,743 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,649 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,605 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,603 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,663 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,646 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,629 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,743 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,613 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   4,862 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,882 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   2,941 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,444 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   11,811 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,797 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,479 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,769 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,379 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,191 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,080 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,031 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,198 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,850 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   12,584 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,481 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,100 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   5,943 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,234 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,026 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   4,998 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,579 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,574 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   6,934 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,409 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,617 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,252 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,734 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,268 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,401 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,376 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,280 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,278 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,094 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,433 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,727 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,239 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   1,998 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,020 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,088 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,301 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,490 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,608 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,614 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,161 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,992 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,826 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,874 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,026 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,040 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,479 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,537 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,839 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,080 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,517 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,554 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   1,922 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,505 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,255 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   1,996 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,066 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,841 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,730 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   20,420 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,507 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   2,004 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,568 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,766 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,057 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,888 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,270 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   2,011 Björn Steinbrink 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,921 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,680 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,766 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,954 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,938 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,701 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,867 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,175 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,261 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,527 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,186 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,158 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,777 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,740 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,572 Björn Steinbrink 05/03/2006 03:31PM
Re: Query Optimization   1,616 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,583 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,654 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,613 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,782 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,572 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,122 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,404 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   1,981 Björn Steinbrink 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   7,953 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,181 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,870 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   3,025 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   3,068 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   3,030 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,771 Björn Steinbrink 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   15,360 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,231 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,132 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,557 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,188 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,587 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   1,984 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,487 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,528 Björn Steinbrink 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,440 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,199 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,120 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   1,995 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,473 Apachez 04/21/2006 04:26AM
where condition optimization   2,392 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,519 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,552 prasanna 04/19/2006 02:26AM
Database structure question   2,053 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,519 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,841 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,940 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,693 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,551 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,545 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,620 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,582 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,676 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,632 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,575 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   1,960 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,209 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,681 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,539 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,566 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,557 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,645 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,843 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,544 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   1,997 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,145 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,581 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   1,991 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,963 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,554 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,764 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,778 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,792 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,652 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,653 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,575 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,599 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,531 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   2,012 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,821 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,719 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,595 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,084 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,939 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,876 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,574 Björn Steinbrink 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,900 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,821 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,904 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   3,944 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,767 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,745 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,330 Björn Steinbrink 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,720 Björn Steinbrink 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,666 Björn Steinbrink 03/24/2006 11:02AM
Query Optimization   2,178 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,552 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,481 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,603 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,289 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,779 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,178 Tobias Marx 03/20/2006 05:26PM
Query   2,084 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,602 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,547 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,542 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,555 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,592 Ilan Goldman 03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"   30,709 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,939 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,615 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,736 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,221 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   19,084 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,734 Solon Barns 03/06/2006 08:27AM
MIN on an indexed field too slow   3,002 Camelia Ticau 03/01/2006 01:58PM
Re: MIN on an indexed field too slow   1,791 Björn Steinbrink 03/09/2006 06:04AM
Re: MIN on an indexed field too slow   1,642 Apachez 03/02/2006 03:28PM
Re: MIN on an indexed field too slow   1,713 Camelia Ticau 03/02/2006 11:38AM
Re: MIN on an indexed field too slow   1,803 Apachez 03/01/2006 05:19PM
Re: MIN on an indexed field too slow   1,757 Camelia Ticau 03/01/2006 04:54PM
Re: MIN on an indexed field too slow   1,869 Apachez 03/01/2006 03:25PM
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.