MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
Announcing: MySQL Enterprise Transparent Data Encryption (TDE) 04/21/2016 03:33PM
MySQL Cluster 7.4.11 has been released 04/20/2016 09:34AM
MySQL Cluster 7.2.24 has been released 04/20/2016 06:30AM
MySQL Cluster 7.3.13 has been released 04/19/2016 11:56PM
MySQL Enterprise Monitor 3.2 GA has been released 04/12/2016 03:25AM
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,636 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,761 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,797 Ijaz Rashid 06/20/2006 07:18AM
Why does this delete statement take so long?   4,125 Jim Daemon 06/15/2006 02:11PM
Re: Why does this delete statement take so long?   1,760 Bob Field 06/15/2006 03:56PM
Re: Why does this delete statement take so long?   1,666 Jim Daemon 06/15/2006 04:16PM
Why isn't the index being used?   2,652 Jim Daemon 06/12/2006 06:11PM
Re: Why isn't the index being used?   1,625 Jim Daemon 06/13/2006 04:03PM
Re: Why isn't the index being used?   1,685 Jim Daemon 06/13/2006 09:54AM
Re: Why isn't the index being used?   1,673 KimSeong Loh 06/13/2006 10:34AM
Re: Why isn't the index being used?   1,650 Bob Field 06/13/2006 09:11AM
Re: Why isn't the index being used?   1,768 Jim Daemon 06/13/2006 08:41AM
Re: Why isn't the index being used?   1,634 Bob Field 06/12/2006 06:41PM
How to avoid temporary and filesort?   4,894 Jim Daemon 06/13/2006 08:49AM
Re: How to avoid temporary and filesort?   2,905 KimSeong Loh 06/13/2006 09:06AM
Re: How to avoid temporary and filesort?   2,963 Jim Daemon 06/13/2006 09:39AM
Re: How to avoid temporary and filesort?   2,465 KimSeong Loh 06/13/2006 10:31AM
How to avoid filesort   11,851 Jim Daemon 06/11/2006 06:50PM
Re: How to avoid filesort   5,809 Jim Daemon 06/12/2006 01:30PM
Re: How to avoid filesort   6,496 KimSeong Loh 06/12/2006 08:40AM
Re: How to avoid filesort   5,787 Jim Daemon 06/12/2006 09:10AM
Help with optimizing GROUP BY query   4,410 lasse 06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query   2,208 KimSeong Loh 06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query   2,103 lasse 06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query   2,050 KimSeong Loh 06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?   3,247 Tad Woods 06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?   1,865 Tad Woods 06/11/2006 03:39PM
fast way to delete records?   12,719 ylu 05/23/2006 03:35PM
Re: fast way to delete records?   5,508 KimSeong Loh 05/24/2006 06:43PM
Re: fast way to delete records?   4,123 tri.truong 06/08/2006 12:30PM
Re: fast way to delete records?   5,983 Anthony Willard 05/24/2006 07:29AM
Will sort help optimizing this query?   2,275 binglew 06/08/2006 11:27AM
count(*) versus mysql_num_rows   26,210 nachomonterde 11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows   5,032 Rob Blick 06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows   6,622 Paul Loy 06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows   8,613 Alexandru Cristescu 11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows   6,992 Jacky Shu 11/24/2005 09:18AM
Selecting a proper table stucture   2,476 Daniel Misio 06/07/2006 04:07AM
Re: Selecting a proper table stucture   1,646 Anthony Willard 06/07/2006 09:47AM
Slow Database   8,343 Dominic Hayhoe 05/31/2006 11:29AM
Re: Slow Database   2,786 Dominic Hayhoe 06/01/2006 04:14AM
Re: Slow Database   2,285 KimSeong Loh 06/01/2006 06:40PM
Re: Slow Database   2,450 Dominic Hayhoe 06/02/2006 02:17AM
Re: Slow Database   2,407 KimSeong Loh 06/05/2006 10:37AM
Re: Slow Database   2,309 KimSeong Loh 05/31/2006 07:43PM
Re: Slow Database   2,305 Dominic Hayhoe 06/01/2006 12:19AM
Re: Slow Database   3,112 Peter Brawley 05/31/2006 12:06PM
Re: Slow Database   2,465 Dominic Hayhoe 05/31/2006 12:43PM
Help to optimize my query   1,759 björn spiegel 06/04/2006 09:34AM
Optimizing query with multiple joins   4,269 EM Ayllon 05/29/2006 05:07AM
Re: Optimizing query with multiple joins   2,012 EM Ayllon 05/30/2006 07:15AM
Re: Optimizing query with multiple joins   2,039 Peter Brawley 05/29/2006 08:36AM
Great masses of files on database.   2,124 Tronks 05/26/2006 01:06PM
Re: Great masses of files on database.   1,318 Bill Karwin 05/26/2006 04:00PM
Re: Great masses of files on database.   1,506 Peter Brawley 05/26/2006 08:59PM
Re: Great masses of files on database.   1,627 Anthony Willard 05/26/2006 01:37PM
JOIN with GROUP BY, without PRIMARY KEY   5,687 Jerome Asselin 05/12/2006 10:57AM
Re: JOIN with GROUP BY, without PRIMARY KEY   3,190 Jerome Asselin 05/25/2006 12:31PM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,010 Jerome Asselin 05/17/2006 10:30AM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,842 KimSeong Loh 05/17/2006 09:44PM
Re: JOIN with GROUP BY, without PRIMARY KEY   1,893 Jerome Asselin 05/23/2006 09:39AM
Re: JOIN with GROUP BY, without PRIMARY KEY   2,046 KimSeong Loh 05/14/2006 06:58PM
Optimization advise needed   2,082 Jerry Tian 05/18/2006 12:51AM
Re: Optimization advise needed   1,494 Jerry Tian 05/18/2006 12:57PM
Re: Optimization advise needed   1,550 Björn Steinbrink 05/18/2006 01:51AM
index ignored   1,865 Lauren Bradford 05/18/2006 12:00PM
mySQL performance problem on subqueries   2,119 Falcon Meriva 05/15/2006 05:14AM
Re: mySQL performance problem on subqueries   1,545 KimSeong Loh 05/15/2006 06:17PM
Re: mySQL performance problem on subqueries   1,571 Peter Brawley 05/15/2006 12:31PM
How to optimize this query   1,968 Yogesh Salvi 05/13/2006 04:36AM
Re: How to optimize this query   1,541 Apachez 05/13/2006 08:22AM
Problem with index and left join   3,298 Erland Isaksson 05/05/2006 03:04PM
Re: Problem with index and left join   2,013 KimSeong Loh 05/09/2006 06:17PM
Re: Problem with index and left join   2,086 Erland Isaksson 05/09/2006 10:44PM
Re: Problem with index and left join   1,867 Apachez 05/09/2006 11:48PM
Re: Problem with index and left join   1,751 Erland Isaksson 05/10/2006 10:52AM
Optimize Query with SUM() and CASE... statements   20,849 Jacob Drew 05/05/2006 11:21PM
Re: Optimize Query with SUM() and CASE... statements   4,547 Anthony Willard 05/08/2006 07:57AM
HELPPPPPPPPPPPPPPP PLEASE   2,062 Odimar Tomazeli 05/04/2006 12:21PM
Make optimized LEFT JOIN with GROUP BY   11,659 Jerry Potokar 05/03/2006 08:30AM
Re: Make optimized LEFT JOIN with GROUP BY   1,791 Jerry Potokar 05/03/2006 05:09PM
Re: Make optimized LEFT JOIN with GROUP BY   2,087 Jerry Potokar 05/03/2006 05:45PM
Re: Make optimized LEFT JOIN with GROUP BY   1,910 Jerry Potokar 05/04/2006 06:05AM
Re: Make optimized LEFT JOIN with GROUP BY   3,297 Jerry Potokar 05/04/2006 08:10AM
Re: Make optimized LEFT JOIN with GROUP BY   2,028 Björn Steinbrink 05/03/2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY   1,942 Jerry Potokar 05/03/2006 04:03PM
Re: Make optimized LEFT JOIN with GROUP BY   3,700 Beat Vontobel 05/03/2006 04:29PM
Re: Make optimized LEFT JOIN with GROUP BY   1,793 Jerry Potokar 05/03/2006 04:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,973 Jerry Potokar 05/03/2006 01:17PM
Re: Make optimized LEFT JOIN with GROUP BY   1,962 Beat Vontobel 05/03/2006 01:23PM
Re: Make optimized LEFT JOIN with GROUP BY   3,720 Jerry Potokar 05/03/2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY   2,900 Beat Vontobel 05/03/2006 12:58PM
Re: Make optimized LEFT JOIN with GROUP BY   3,199 Jerry Potokar 05/03/2006 09:21AM
Re: Make optimized LEFT JOIN with GROUP BY   5,300 Beat Vontobel 05/03/2006 01:19PM
Re: Make optimized LEFT JOIN with GROUP BY   3,550 Jerry Potokar 05/03/2006 02:38PM
Re: Make optimized LEFT JOIN with GROUP BY   2,207 Jerry Potokar 05/03/2006 02:43PM
Re: Make optimized LEFT JOIN with GROUP BY   3,185 Beat Vontobel 05/03/2006 03:35PM
Re: Make optimized LEFT JOIN with GROUP BY   4,798 Beat Vontobel 05/03/2006 09:11AM
Query Optimization   2,792 Joe Taylor 04/26/2006 01:57PM
Re: Query Optimization   1,590 Björn Steinbrink 05/03/2006 03:31PM
Re: Query Optimization   1,632 Bill Karwin 04/26/2006 04:46PM
Re: Query Optimization   1,602 Apachez 04/26/2006 04:56PM
Re: Query Optimization   1,672 Bill Karwin 04/26/2006 05:29PM
Re: Query Optimization   1,631 Joe Taylor 05/03/2006 03:11PM
Optimizing Substring Query   4,831 spicedh 05/02/2006 01:01PM
Re: Optimizing Substring Query   1,594 Peter Brawley 05/02/2006 02:39PM
Re: Optimizing Substring Query   2,145 spicedh 05/02/2006 02:45PM
Re: Optimizing Substring Query   1,425 Peter Brawley 05/02/2006 03:00PM
Re: Optimizing Substring Query   2,004 Björn Steinbrink 05/02/2006 02:59PM
Performance impact of filtering in ON vs WHERE clause   8,168 John McNally 04/28/2006 12:17PM
Re: Performance impact of filtering in ON vs WHERE clause   3,256 Apachez 04/28/2006 12:26PM
Re: Performance impact of filtering in ON vs WHERE clause   2,930 Sebastien Caisse 05/01/2006 08:40AM
Re: Performance impact of filtering in ON vs WHERE clause   3,084 Apachez 05/01/2006 12:54PM
Re: Performance impact of filtering in ON vs WHERE clause   3,134 Sebastien Caisse 05/02/2006 01:06PM
Re: Performance impact of filtering in ON vs WHERE clause   3,100 Apachez 05/02/2006 01:15PM
Re: Performance impact of filtering in ON vs WHERE clause   3,815 Björn Steinbrink 05/02/2006 02:21PM
INDEX on DATE field and MONTH() YEAR() functions   15,605 Tristan Crombez 04/30/2006 01:14PM
Re: INDEX on DATE field and MONTH() YEAR() functions   6,342 Bill Karwin 04/30/2006 03:55PM
table design and query opimization   2,166 prasanna 04/19/2006 02:11AM
Re: table design and query opimization   1,575 Sebastien Caisse 04/27/2006 11:27AM
Re: table design and query opimization   1,207 prasanna 04/19/2006 10:25PM
Re: table design and query opimization   1,610 moraless92 04/19/2006 10:29AM
Optimizer not working adequately   2,017 emilio.ayllon 04/25/2006 07:41PM
Re: Optimizer not working adequately   1,502 EM Ayllon 04/26/2006 09:43AM
Re: Optimizer not working adequately   1,545 Björn Steinbrink 04/26/2006 03:36AM
UNION/UNION ALL queries and parallel processing   4,543 Dominique PRUNIER 04/20/2006 09:39AM
Re: UNION/UNION ALL queries and parallel processing   2,244 James Day 04/23/2006 02:11PM
Re: UNION/UNION ALL queries and parallel processing   2,183 Dominique PRUNIER 04/23/2006 08:04PM
Using "optimize table"   2,029 Bozhidar Bozhanov 04/21/2006 04:02AM
Re: Using "optimize table"   1,489 Apachez 04/21/2006 04:26AM
where condition optimization   2,429 Srivats Chandrasekaran 02/27/2006 03:57AM
Re: where condition optimization   1,538 Bob Field 04/19/2006 09:51AM
Re: where condition optimization   1,564 prasanna 04/19/2006 02:26AM
Database structure question   2,088 Bozhidar Bozhanov 04/17/2006 10:29AM
Re: Database structure question   1,536 Bill Karwin 04/17/2006 10:54AM
High RAM usage   2,902 Nathan Bartell 04/12/2006 08:25AM
Re: High RAM usage   1,959 Bill Karwin 04/12/2006 11:33AM
LEFT JOIN Issue in 5.0   2,760 Martin Dubuc 04/10/2006 10:28AM
Re: LEFT JOIN Issue in 5.0   1,562 Roman Kolcun 04/10/2006 03:24PM
Re: LEFT JOIN Issue in 5.0   1,560 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,635 Martin Dubuc 04/11/2006 07:34AM
Re: LEFT JOIN Issue in 5.0   1,598 Bob Field 04/10/2006 12:50PM
Re: LEFT JOIN Issue in 5.0   1,697 Martin Dubuc 04/10/2006 03:11PM
Re: LEFT JOIN Issue in 5.0   1,647 Bob Field 04/10/2006 10:37AM
Re: LEFT JOIN Issue in 5.0   1,591 Martin Dubuc 04/10/2006 11:38AM
Index merge optimization (with OR) and table joins   1,998 Stuart Brooks 04/07/2006 06:56AM
data design optimization   2,246 BattleMan BattleClan 03/30/2006 07:44AM
Re: data design optimization   1,699 BattleMan BattleClan 04/01/2006 06:38AM
Re: data design optimization   1,556 Peter Brawley 03/31/2006 04:59PM
Re: data design optimization   1,578 BattleMan BattleClan 03/31/2006 01:42PM
Re: data design optimization   1,567 Peter Brawley 03/30/2006 04:03PM
Re: data design optimization   1,668 BattleMan BattleClan 03/30/2006 01:41PM
Query Statement   1,869 BattleMan BattleClan 03/30/2006 01:43PM
Re: data design optimization   1,558 Peter Brawley 03/30/2006 09:02AM
refashion MySQL parse engine problem(bison, flex)   2,030 feeling wu 03/28/2006 09:26AM
Defragmentation and Database Optimizing Tool in the Background   2,179 Mathias Bischoff 01/26/2006 10:53AM
Re: Defragmentation and Database Optimizing Tool in the Background   1,597 Ulrich Schmid 03/28/2006 04:01AM
Question regarding 5.0 LEFT JOIN   2,019 Timothy Brooks 03/27/2006 04:59PM
Re: Question regarding 5.0 LEFT JOIN   1,983 Peter Brawley 03/27/2006 06:23PM
Problem with LEF OUTER JOIN   2,590 wdeveloper 03/19/2006 04:01PM
Re: Problem with LEF OUTER JOIN   1,787 wdeveloper 03/26/2006 11:40PM
Re: Problem with LEF OUTER JOIN   1,794 wdeveloper 03/24/2006 02:01PM
Re: Problem with LEF OUTER JOIN   1,812 KimSeong Loh 03/26/2006 08:05PM
Re: Problem with LEF OUTER JOIN   1,672 KimSeong Loh 03/22/2006 07:06PM
Re: Problem with LEF OUTER JOIN   1,673 wdeveloper 03/22/2006 05:10PM
Re: Problem with LEF OUTER JOIN   1,594 Sebastien Caisse 03/23/2006 08:06AM
Re: Problem with LEF OUTER JOIN   1,617 KimSeong Loh 03/21/2006 06:35PM
Re: Problem with LEF OUTER JOIN   1,552 Bob Field 03/19/2006 05:48PM
Re: Problem with LEF OUTER JOIN   2,032 wdeveloper 03/20/2006 04:04AM
Re: Problem with LEF OUTER JOIN   1,843 Bob Field 03/20/2006 10:31AM
Re: Problem with LEF OUTER JOIN   1,737 wdeveloper 03/20/2006 03:02PM
Re: Problem with LEF OUTER JOIN   1,614 Bob Field 03/20/2006 03:34PM
Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,131 Beat Vontobel 03/08/2006 03:30PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,955 KimSeong Loh 03/09/2006 02:50AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,904 Beat Vontobel 03/09/2006 03:09AM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   3,593 Björn Steinbrink 03/24/2006 12:02PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,922 Jay Pipes 03/08/2006 10:03PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,833 Beat Vontobel 03/23/2006 02:41PM
Re: Dependent subquery stupidity: Is it me or the optimizer? ;-)   1,916 Beat Vontobel 03/09/2006 02:16AM
suggestion for optimizing with non-matching compound indexes   4,003 Nathan Cheng 03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes   1,786 Harrison Fisk 03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes   1,765 Nathan Cheng 03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes   2,361 Björn Steinbrink 03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes   1,731 Björn Steinbrink 03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes   1,683 Björn Steinbrink 03/24/2006 11:02AM
Query Optimization   2,209 Jorden Dunne 03/21/2006 06:10AM
Re: Query Optimization   1,563 Peter Brawley 03/21/2006 08:24AM
Re: Query Optimization   1,494 Jorden Dunne 03/21/2006 09:19AM
Re: Query Optimization   1,615 Peter Brawley 03/21/2006 11:24AM
Mysql high cpu usage problem   2,314 vikki saggu 01/07/2006 02:29PM
Re: Mysql high cpu usage problem   1,795 Bruno B. 01/31/2006 07:13AM
Re: Mysql high cpu usage problem   2,194 Tobias Marx 03/20/2006 05:26PM
Query   2,124 Jorge Ferreira 03/15/2006 11:08AM
Re: Query   1,624 Jorge Ferreira 03/15/2006 11:17AM
Re: Query   1,572 Jay Pipes 03/15/2006 11:37AM
Re: Query   1,557 Jorge Ferreira 03/17/2006 08:38AM
my.cnf option file , which one to use ?   2,584 Ilan Goldman 03/07/2006 02:48PM
UP , JUMP , PLEASE HELP   1,607 Ilan Goldman 03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"   30,823 Solon Barns 03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"   18,970 Solon Barns 03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,641 Jay Pipes 03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"   15,777 Solon Barns 03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"   17,256 Jay Pipes 03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"   19,118 Jay Pipes 03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"   17,759 Solon Barns 03/06/2006 08:27AM
MIN on an indexed field too slow   3,040 Camelia Ticau 03/01/2006 01:58PM
Re: MIN on an indexed field too slow   1,816 Björn Steinbrink 03/09/2006 06:04AM
Re: MIN on an indexed field too slow   1,656 Apachez 03/02/2006 03:28PM
Re: MIN on an indexed field too slow   1,731 Camelia Ticau 03/02/2006 11:38AM
Re: MIN on an indexed field too slow   1,835 Apachez 03/01/2006 05:19PM
Re: MIN on an indexed field too slow   1,779 Camelia Ticau 03/01/2006 04:54PM
Re: MIN on an indexed field too slow   1,886 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.