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
Current Page: 12 of 17
Subject Views Written By Posted
Optimizing a search query   2,494 Staffan S 07/25/2007 03:58AM
Index evaluation   2,918 Drei Bit 07/23/2007 04:51PM
Re: Index evaluation   2,087 KimSeong Loh 07/23/2007 07:27PM
Re: Index evaluation   2,038 Drei Bit 07/24/2007 05:24AM
Re: Index evaluation   2,000 Drei Bit 07/23/2007 05:18PM
Re: Index evaluation   2,030 KimSeong Loh 07/24/2007 02:06AM
Re: Index evaluation   1,986 Drei Bit 07/24/2007 04:33AM
Profiling only works in MySQL 5.0.37?   3,605 Suave Su 07/19/2007 12:22AM
Re: Profiling only works in MySQL 5.0.37?   2,207 KimSeong Loh 07/19/2007 05:02AM
Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   4,844 Drei Bit 07/03/2007 05:37PM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,203 KimSeong Loh 07/04/2007 06:45AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,159 Drei Bit 07/04/2007 10:49AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,130 KimSeong Loh 07/05/2007 01:14AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,112 Drei Bit 07/05/2007 03:22AM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,064 KimSeong Loh 07/05/2007 03:16PM
Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]   2,130 Drei Bit 07/10/2007 09:37AM
join order when using order by   5,495 Christopher Cudennec 07/09/2007 07:54AM
default order by   4,014 Joel Webb 07/06/2007 08:49AM
Cost Model Information   2,588 Drei Bit 07/05/2007 03:26AM
Optimizer misbehaves   2,598 Drei Bit 07/04/2007 05:16AM
Re: Optimizer misbehaves   2,047 KimSeong Loh 07/04/2007 07:26AM
Re: Optimizer misbehaves   1,958 Drei Bit 07/04/2007 10:37AM
Variable where index optimizing   2,433 alex jordanov 06/29/2007 04:37AM
How to optimize this program? Thanks   2,323 li grewat 06/28/2007 08:31PM
Star joins?   2,688 Seth Grimes 01/17/2006 08:57PM
Re: Star joins?   2,049 Seth Grimes 01/26/2006 11:35AM
Re: Star joins?   2,117 Jay Pipes 01/26/2006 01:00PM
Re: Star joins?   1,980 Seth Grimes 01/21/2006 07:32PM
Re: Star joins?   2,752 Timour Katchaounov 01/23/2006 04:10PM
Re: Star joins?   4,058 Jag Singh 06/28/2007 04:23AM
Re: Star joins?   2,098 Peter Welker 12/09/2006 06:25AM
Re: Star joins?   2,042 Jay Pipes 01/22/2006 03:22PM
Re: Star joins?   2,103 Jay Pipes 01/18/2006 10:39PM
Re: Star joins?   1,976 Jay Pipes 01/18/2006 10:41PM
Re: Star joins?   1,969 Seth Grimes 01/20/2006 03:08PM
Re: Star joins?   2,134 Jay Pipes 01/20/2006 06:42PM
how to store 10GB data in a table(using mysql 5.0.24).   3,250 justin jose 05/02/2007 10:39PM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,208 Olexandr Novosad 05/26/2007 03:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,112 Peter Steiner 06/25/2007 07:45AM
Re: how to store 10GB data in a table(using mysql 5.0.24).   2,219 KimSeong Loh 05/27/2007 03:00AM
How to optimize this trigger?   3,357 li grewat 06/21/2007 08:18PM
Re: How to optimize this trigger?   1,945 KimSeong Loh 06/22/2007 05:49AM
Re: How to optimize this trigger?   1,928 li grewat 06/24/2007 06:22PM
Please help:The performance of before insert trigger and after insert trigger?   2,342 li grewat 06/23/2007 06:40AM
Index optimizations for huge table   2,686 Mennan Kara 04/30/2007 08:57PM
Re: Index optimizations for huge table   1,988 Sergey Petrunya 05/22/2007 03:38PM
Index fields order   2,806 Andrey Kondakov 05/14/2007 08:35AM
Re: Index fields order   1,858 Sergey Petrunya 05/22/2007 03:19PM
Re: Index fields order   1,879 Andrey Kondakov 05/14/2007 09:14AM
Functions in the where clause   3,707 John Dzilvelis 05/21/2007 10:26AM
Re: Functions in the where clause   2,218 Timour Katchaounov 05/22/2007 04:50AM
datetime vs date,time   8,027 Alberto González 05/16/2007 02:31AM
Re: datetime vs date,time   2,750 KimSeong Loh 05/17/2007 06:08AM
Re: datetime vs date,time   2,618 Alberto González 05/17/2007 10:08AM
Re: datetime vs date,time   3,238 Jonathan Webb 05/17/2007 05:07AM
Use of join buffer is now visible in EXPLAIN   2,390 Edwin DeSouza 05/15/2007 10:21PM
Index distribution stats   2,011 Gabriel Tataranu 05/12/2007 09:54PM
Re: Index distribution stats   1,824 Gabriel Tataranu 05/13/2007 05:42PM
Optimising query with self-join and GROUP BY   7,051 Richard Fairhurst 05/07/2007 01:24PM
Re: Optimising query with self-join and GROUP BY   2,957 Björn Steinbrink 05/09/2007 05:21PM
Re: Optimising query with self-join and GROUP BY   2,255 Richard Fairhurst 05/13/2007 03:12PM
select + order by + limit 0,1   6,194 Markus Doppelbauer 05/11/2007 01:10AM
Re: select + order by + limit 0,1   2,381 Markus Doppelbauer 05/11/2007 01:22AM
How to optimize I/O?   2,438 gpslocator 05/09/2007 09:41PM
Huge amount of data   3,525 Sebastien Salou 04/25/2007 02:47AM
Re: Huge amount of data   1,872 KimSeong Loh 04/29/2007 10:23PM
Re: Huge amount of data   1,857 justin jose 05/02/2007 10:37PM
Need to optimise complex query   2,485 Ben Sebborn 04/29/2007 04:13PM
Re: Need to optimise complex query   1,773 KimSeong Loh 04/29/2007 10:21PM
Re: Need to optimise complex query   1,752 Ben Sebborn 04/30/2007 05:00AM
Re: Need to optimise complex query   1,814 KimSeong Loh 04/30/2007 08:36PM
Random-row queries   4,681 James Yopp 04/29/2007 06:35PM
how to create the index for three fields?   2,754 justin ux 04/24/2007 08:35PM
Query performance on indexed columns   2,178 marco rossi 04/24/2007 06:52AM
Table JOIN causes FULLSCAN despite of indeces   2,344 Denis 04/19/2007 11:58AM
CPU 99%   2,296 Neela Mahendran 04/17/2007 09:47PM
Optimizing index use in select statement   5,333 Andrey Kondakov 04/15/2007 07:23AM
Re: Optimizing index use in select statement   2,119 KimSeong Loh 04/15/2007 03:10PM
How to Control MySQL CPU Usage   2,109 TAT LIM CHIN 04/13/2007 11:39AM
Index on difference of two columns   3,007 Marty - 04/08/2007 09:31AM
Re: Index on difference of two columns   1,809 KimSeong Loh 04/11/2007 06:38AM
Re: Index on difference of two columns   1,786 Marty - 04/12/2007 12:06AM
otimize search with wildcar "%" ?   2,525 edson fernando 04/07/2007 12:02AM
Re: otimize search with wildcar "%" ?   1,672 KimSeong Loh 04/08/2007 09:01AM
help - join query optimization   2,282 Brian Kohan 04/05/2007 09:18AM
how to analyze this query_cache status   2,729 d h 03/30/2007 12:46AM
Slow Queries   2,137 Farrukh Ahmed 03/29/2007 02:32AM
Slow Subquery - Optimization in this simple query needed   3,815 elissaios 03/27/2007 11:42PM
Re: Slow Subquery - Optimization in this simple query needed   2,053 Björn Steinbrink 03/28/2007 06:22PM
Re: Slow Subquery - Optimization in this simple query needed   2,261 KimSeong Loh 03/28/2007 05:59PM
Optimize Multiple CPUs on Windows 2003 Server   2,793 Thomas Mockbee 03/28/2007 02:01PM
Limiting query research to a specified n. of records   2,440 marco rossi 03/16/2007 04:35AM
Re: Limiting query research to a specified n. of records   1,739 Björn Steinbrink 03/16/2007 09:59AM
B-Tree index ignored. Why?   5,987 Daniel Terry 03/14/2007 12:46PM
Re: B-Tree index ignored. Why?   2,408 KimSeong Loh 03/14/2007 07:39PM
Optimizing a Query   2,201 Drew Kutcharian 03/12/2007 08:45PM
Removing default NULL from table definition   2,904 Andrey Kondakov 03/11/2007 09:52AM
sql_no_cache added by the optimizer   2,929 alan langridge 03/08/2007 12:32PM
Re: sql_no_cache added by the optimizer   1,731 KimSeong Loh 03/08/2007 07:19PM
Extremely slow subqueries when used in joins   2,269 kalinda 03/08/2007 06:50AM
Optimizing Queries   2,213 Scott Pringle 03/06/2007 03:32PM
the query not optimized   2,196 Luca 03/02/2007 05:47AM
Optimizing this query slows it down   2,328 wm 02/28/2007 08:33AM
Re: Optimizing this query slows it down   1,636 KimSeong Loh 02/28/2007 06:26PM
low query   3,849 hakim benmouhoub 02/16/2007 03:49AM
Re: low query   1,656 Toa Sty 02/16/2007 04:44AM
Re: low query   1,610 ben hakim 02/16/2007 08:28AM
Re: low query   1,611 KimSeong Loh 02/25/2007 11:55PM
MySQL Optimizer Blogs by Sergey Petrunia   2,478 Edwin DeSouza 02/24/2007 12:54AM
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.