MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Cluster 7.5.5 has been released 01/17/2017 02:22PM
MySQL Cluster 7.2.27 has been released 01/17/2017 11:04AM
MySQL Cluster 7.3.16 has been released 01/17/2017 10:56AM
MySQL Cluster 7.4.14 has been released 01/17/2017 10:38AM
MySQL Connector/C 6.1.9 GA has been released 01/10/2017 09:47AM
Current Page: 12 of 17
Subject Views Written By Posted
ORDER BY ... LIMIT   3,539 Ed Mazur 09/27/2007 11:24AM
Re: ORDER BY ... LIMIT   2,322 KimSeong Loh 09/27/2007 05:07PM
How to speed up my DB   2,748 Venkateswaran Nagarajan 09/21/2007 09:05PM
Query execution time depends on the size of the tables????????????   2,869 Venkateswaran Nagarajan 09/21/2007 08:56PM
multiple index is used only partially   4,010 Miguel Balsevich 09/08/2007 03:37PM
Re: multiple index is used only partially   2,368 Miguel Balsevich 09/11/2007 08:04AM
Using FileSort   3,639 Clement Ho 09/10/2007 05:21PM
Help join optimisation   2,738 Catia Lavalle 09/05/2007 05:41AM
Can I speed this up?   4,752 Eljakim Schrijvers 02/17/2007 11:18AM
Re: Can I speed this up?   2,605 Adrian Chapela Cordeiro 08/30/2007 02:55AM
Re: Can I speed this up?   2,726 KimSeong Loh 02/25/2007 11:40PM
Re: Can I speed this up?   2,702 Eljakim Schrijvers 03/10/2007 01:23PM
Re: Can I speed this up?   2,653 KimSeong Loh 03/11/2007 12:59AM
Re: Can I speed this up?   2,672 Dian Kresno 04/26/2007 01:04AM
Re: Can I speed this up?   2,870 Eljakim Schrijvers 02/17/2007 11:23AM
time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables   4,890 Jan Theodore Galkowski 06/27/2007 08:52AM
Re: time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables   2,764 Adrian Chapela Cordeiro 08/30/2007 02:13AM
LEFT JOIN Optimization   7,327 Ram R 08/21/2007 03:04PM
Re: LEFT JOIN Optimization   3,604 KimSeong Loh 08/21/2007 06:45PM
Re: LEFT JOIN Optimization   2,934 Adrian Chapela Cordeiro 08/29/2007 03:55AM
Re: LEFT JOIN Optimization   3,169 Ram R 08/21/2007 11:32PM
Re: LEFT JOIN Optimization   3,157 KimSeong Loh 08/29/2007 07:19PM
A popular forum not able to take load.. my.cnf optimization needed   7,145 Raman Singh 08/12/2007 12:48AM
Re: A popular forum not able to take load.. my.cnf optimization needed   2,603 Adrian Chapela Cordeiro 08/29/2007 04:50AM
Re: A popular forum not able to take load.. my.cnf optimization needed   2,654 KimSeong Loh 08/12/2007 05:17PM
Optimized query still way too slow   3,107 Brad Douglas 08/13/2007 04:54PM
Speed up query execution with 30Million rows   6,659 Vibhu Bansal 08/09/2007 06:40AM
Re: Speed up query execution with 30Million rows   3,185 Yogesh Salvi 08/13/2007 05:46AM
How to optimize this query?   3,893 Kwang Chin Lee 06/20/2007 07:38AM
Re: How to optimize this query?   2,121 Yogesh Salvi 08/13/2007 05:43AM
How to stop temporary table in this query   3,389 Mike Zupan 08/09/2007 11:19AM
Indexing table takes 4 hours   2,664 Francisco Cha 08/08/2007 03:11PM
Help requested optimising query with subquery   2,839 Christian Seaman 08/08/2007 06:21AM
Re: Help requested optimising query with subquery   2,007 KimSeong Loh 08/08/2007 07:01AM
Need some help to optimize a query with multiple JOIN   6,162 Jean-Baptiste ANNE 07/30/2007 01:42PM
Re: Need some help to optimize a query with multiple JOIN   2,723 Sergey Belov 07/31/2007 05:55AM
Re: Need some help to optimize a query with multiple JOIN   2,611 Jean-Baptiste ANNE 07/31/2007 10:20AM
Re: Need some help to optimize a query with multiple JOIN   2,601 Sergey Belov 08/01/2007 01:12AM
Re: Need some help to optimize a query with multiple JOIN   2,715 Jean-Baptiste ANNE 08/01/2007 07:58AM
Re: Need some help to optimize a query with multiple JOIN   2,773 KimSeong Loh 08/05/2007 01:03AM
why does explain plan change?   10,718 charlie w 07/30/2007 10:14AM
Re: why does explain plan change?   2,885 Fabio Sgamo 08/03/2007 05:22AM
Problem with optimization of a WHERE clause   3,291 Giorgio Calderone 08/02/2007 12:41PM
Can't understand why optimizer doesn't work properly :(   2,916 Sergey Belov 07/23/2007 02:03PM
Re: Can't understand why optimizer doesn't work properly :(   2,049 KimSeong Loh 07/23/2007 07:21PM
Re: Can't understand why optimizer doesn't work properly :(   2,138 Sergey Belov 07/24/2007 12:26AM
Re: Can't understand why optimizer doesn't work properly :(   1,997 KimSeong Loh 07/24/2007 02:08AM
Re: Can't understand why optimizer doesn't work properly :(   2,198 Sergey Belov 07/24/2007 02:42AM
Re: Can't understand why optimizer doesn't work properly :(   1,961 KimSeong Loh 07/24/2007 06:02PM
Re: Can't understand why optimizer doesn't work properly :(   2,063 Sergey Belov 07/25/2007 11:10PM
Optimizing a search query   2,587 Staffan S 07/25/2007 03:58AM
Index evaluation   3,042 Drei Bit 07/23/2007 04:51PM
Re: Index evaluation   2,124 KimSeong Loh 07/23/2007 07:27PM
Re: Index evaluation   2,073 Drei Bit 07/24/2007 05:24AM
Re: Index evaluation   2,046 Drei Bit 07/23/2007 05:18PM
Re: Index evaluation   2,077 KimSeong Loh 07/24/2007 02:06AM
Re: Index evaluation   2,020 Drei Bit 07/24/2007 04:33AM
Profiling only works in MySQL 5.0.37?   3,672 Suave Su 07/19/2007 12:22AM
Re: Profiling only works in MySQL 5.0.37?   2,240 KimSeong Loh 07/19/2007 05:02AM
Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   5,001 Drei Bit 07/03/2007 05:37PM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,240 KimSeong Loh 07/04/2007 06:45AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,206 Drei Bit 07/04/2007 10:49AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,175 KimSeong Loh 07/05/2007 01:14AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,168 Drei Bit 07/05/2007 03:22AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,128 KimSeong Loh 07/05/2007 03:16PM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,165 Drei Bit 07/10/2007 09:37AM
join order when using order by   5,683 Christopher Cudennec 07/09/2007 07:54AM
default order by   4,206 Joel Webb 07/06/2007 08:49AM
Cost Model Information   2,694 Drei Bit 07/05/2007 03:26AM
Optimizer misbehaves   2,720 Drei Bit 07/04/2007 05:16AM
Re: Optimizer misbehaves   2,084 KimSeong Loh 07/04/2007 07:26AM
Re: Optimizer misbehaves   1,999 Drei Bit 07/04/2007 10:37AM
Variable where index optimizing   2,506 alex jordanov 06/29/2007 04:37AM
How to optimize this program? Thanks   2,426 li grewat 06/28/2007 08:31PM
Star joins?   2,784 Seth Grimes 01/17/2006 08:57PM
Re: Star joins?   2,095 Seth Grimes 01/26/2006 11:35AM
Re: Star joins?   2,186 Jay Pipes 01/26/2006 01:00PM
Re: Star joins?   2,032 Seth Grimes 01/21/2006 07:32PM
Re: Star joins?   2,849 Timour Katchaounov 01/23/2006 04:10PM
Re: Star joins?   4,214 Jag Singh 06/28/2007 04:23AM
Re: Star joins?   2,146 Peter Welker 12/09/2006 06:25AM
Re: Star joins?   2,090 Jay Pipes 01/22/2006 03:22PM
Re: Star joins?   2,183 Jay Pipes 01/18/2006 10:39PM
Re: Star joins?   2,030 Jay Pipes 01/18/2006 10:41PM
Re: Star joins?   2,059 Seth Grimes 01/20/2006 03:08PM
Re: Star joins?   2,200 Jay Pipes 01/20/2006 06:42PM
how to store 10GB data in a table(using mysql 5.0.24).   3,353 justin jose 05/02/2007 10:39PM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,315 Olexandr Novosad 05/26/2007 03:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,153 Peter Steiner 06/25/2007 07:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,275 KimSeong Loh 05/27/2007 03:00AM
How to optimize this trigger?   3,519 li grewat 06/21/2007 08:18PM
Re: How to optimize this trigger?   2,025 KimSeong Loh 06/22/2007 05:49AM
Re: How to optimize this trigger?   2,005 li grewat 06/24/2007 06:22PM
Please help:The performance of before insert trigger and after insert trigger?   2,408 li grewat 06/23/2007 06:40AM
Index optimizations for huge table   2,781 Mennan Kara 04/30/2007 08:57PM
Re: Index optimizations for huge table   2,040 Sergey Petrunya 05/22/2007 03:38PM
Index fields order   2,903 Andrey Kondakov 05/14/2007 08:35AM
Re: Index fields order   1,885 Sergey Petrunya 05/22/2007 03:19PM
Re: Index fields order   1,916 Andrey Kondakov 05/14/2007 09:14AM
Functions in the where clause   3,809 John Dzilvelis 05/21/2007 10:26AM
Re: Functions in the where clause   2,260 Timour Katchaounov 05/22/2007 04:50AM
datetime vs date,time   8,270 Alberto González 05/16/2007 02:31AM
Re: datetime vs date,time   2,811 KimSeong Loh 05/17/2007 06:08AM
Re: datetime vs date,time   2,657 Alberto González 05/17/2007 10:08AM
Re: datetime vs date,time   3,281 Jonathan Webb 05/17/2007 05:07AM
Use of join buffer is now visible in EXPLAIN   2,460 Edwin DeSouza 05/15/2007 10:21PM
Index distribution stats   2,088 Gabriel Tataranu 05/12/2007 09:54PM
Re: Index distribution stats   1,863 Gabriel Tataranu 05/13/2007 05:42PM
Optimising query with self-join and GROUP BY   7,381 Richard Fairhurst 05/07/2007 01:24PM
Re: Optimising query with self-join and GROUP BY   3,011 Björn Steinbrink 05/09/2007 05:21PM
Re: Optimising query with self-join and GROUP BY   2,289 Richard Fairhurst 05/13/2007 03:12PM
select + order by + limit 0,1   6,342 Markus Doppelbauer 05/11/2007 01:10AM
Re: select + order by + limit 0,1   2,417 Markus Doppelbauer 05/11/2007 01:22AM
How to optimize I/O?   2,514 gpslocator 05/09/2007 09:41PM
Huge amount of data   3,618 Sebastien Salou 04/25/2007 02:47AM
Re: Huge amount of data   1,911 KimSeong Loh 04/29/2007 10:23PM
Re: Huge amount of data   1,925 justin jose 05/02/2007 10:37PM
Need to optimise complex query   2,630 Ben Sebborn 04/29/2007 04:13PM
Re: Need to optimise complex query   1,809 KimSeong Loh 04/29/2007 10:21PM
Re: Need to optimise complex query   1,805 Ben Sebborn 04/30/2007 05:00AM
Re: Need to optimise complex query   1,863 KimSeong Loh 04/30/2007 08:36PM
Random-row queries   4,934 James Yopp 04/29/2007 06:35PM
how to create the index for three fields?   2,911 justin ux 04/24/2007 08:35PM
Query performance on indexed columns   2,315 marco rossi 04/24/2007 06:52AM
Table JOIN causes FULLSCAN despite of indeces   2,461 Denis 04/19/2007 11:58AM
CPU 99%   2,387 Neela Mahendran 04/17/2007 09:47PM
Current Page: 12 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.