Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 2.3.16 has been released 04/17/2014 11:45AM
MySQL Enterprise Monitor 3.0.9 has been released 04/14/2014 05:53PM
MySQL Cluster 7.2.16 has been released 04/09/2014 04:32AM
MySQL Cluster 7.3.5 has been released 04/07/2014 08:15PM
MySQL Connector/ODBC 5.3.2 GA has been released 04/07/2014 08:14PM
Current Page: 12 of 16
Subject Views Written By Posted
how to analyze this query_cache status   2,471 d h 03/30/2007 12:46AM
Slow Queries   1,949 Farrukh Ahmed 03/29/2007 02:32AM
Slow Subquery - Optimization in this simple query needed   3,543 elissaios 03/27/2007 11:42PM
Re: Slow Subquery - Optimization in this simple query needed   1,966 Björn Steinbrink 03/28/2007 06:22PM
Re: Slow Subquery - Optimization in this simple query needed   2,182 KimSeong Loh 03/28/2007 05:59PM
Optimize Multiple CPUs on Windows 2003 Server   2,639 Thomas Mockbee 03/28/2007 02:01PM
Limiting query research to a specified n. of records   2,202 marco rossi 03/16/2007 04:35AM
Re: Limiting query research to a specified n. of records   1,642 Björn Steinbrink 03/16/2007 09:59AM
B-Tree index ignored. Why?   5,492 Daniel Terry 03/14/2007 12:46PM
Re: B-Tree index ignored. Why?   2,340 KimSeong Loh 03/14/2007 07:39PM
Optimizing a Query   1,981 Drew Kutcharian 03/12/2007 08:45PM
Removing default NULL from table definition   2,580 Andrey Kondakov 03/11/2007 09:52AM
sql_no_cache added by the optimizer   2,657 alan langridge 03/08/2007 12:32PM
Re: sql_no_cache added by the optimizer   1,649 KimSeong Loh 03/08/2007 07:19PM
Extremely slow subqueries when used in joins   2,065 kalinda 03/08/2007 06:50AM
Optimizing Queries   2,056 Scott Pringle 03/06/2007 03:32PM
the query not optimized   2,039 Luca 03/02/2007 05:47AM
Optimizing this query slows it down   2,081 wm 02/28/2007 08:33AM
Re: Optimizing this query slows it down   1,535 KimSeong Loh 02/28/2007 06:26PM
low query   3,572 hakim benmouhoub 02/16/2007 03:49AM
Re: low query   1,560 Toa Sty 02/16/2007 04:44AM
Re: low query   1,500 ben hakim 02/16/2007 08:28AM
Re: low query   1,526 KimSeong Loh 02/25/2007 11:55PM
MySQL Optimizer Blogs by Sergey Petrunia   2,320 Edwin DeSouza 02/24/2007 12:54AM
how to explain this table status   2,105 rei 02/06/2007 04:33AM
Re: how to explain this table status   1,595 rei 02/22/2007 08:23PM
Large database   2,476 Omar Khan 01/12/2007 07:45AM
Re: Large database   1,710 Albert Arul prakash Rajendran 02/09/2007 01:42AM
Re: Large database   1,500 Omar Khan 02/14/2007 06:55AM
Re: Large database   1,756 KimSeong Loh 02/14/2007 06:47PM
Re: Large database   1,668 Omar Khan 02/15/2007 05:35AM
Re: Large database   1,751 Sean Allin 02/15/2007 05:13PM
Indexing for queries including count   1,847 Omar Khan 02/14/2007 07:05AM
Retrieved columns affects index usage   1,963 Angus 02/13/2007 12:06PM
Re: Retrieved columns affects index usage   1,533 KimSeong Loh 02/13/2007 06:37PM
force index on text & integer joiin   3,367 Simon Cranmer 02/12/2007 11:31AM
Re: force index on text & integer joiin   1,703 KimSeong Loh 02/12/2007 07:35PM
Re: force index on text & integer joiin   1,790 Simon Cranmer 02/13/2007 07:54AM
Optimizing query with joins   2,409 kayne 06/03/2006 12:18PM
Re: Optimizing query with joins   1,628 Rob Blick 06/07/2006 10:17AM
Re: Optimizing query with joins   1,592 Rhonda Heath 02/12/2007 12:07PM
Large IN() Comparison Optimize Help   1,948 Garrett Gyssler 02/11/2007 02:51AM
How should I index the tables in this query?   2,063 Dan Bress 02/09/2007 01:35PM
Substring ignores index   5,891 Matt Ryan 09/29/2006 08:59AM
Re: Substring ignores index   3,100 Toa Sty 09/29/2006 09:48AM
Re: Substring ignores index   2,504 Denver Vender 02/09/2007 04:01AM
Help required in optimizing query   1,955 Albert Arul prakash Rajendran 02/08/2007 09:43PM
intense query with "union"   1,852 asif baloch 02/07/2007 04:54PM
my boss says mysql is not upto standard: Please reply urgent   1,946 jatin shah 02/06/2007 06:05AM
Re: my boss says mysql is not upto standard: Please reply urgent   1,558 Toa Sty 02/06/2007 09:31AM
Simple queries take a lot some times   1,920 Paolo Ragone 01/30/2007 01:04PM
ORDER BY + LIMIT   3,970 Markus Doppelbauer 11/12/2006 04:45AM
Re: ORDER BY + LIMIT   2,815 Toa Sty 11/12/2006 08:27AM
Re: ORDER BY + LIMIT   2,534 Markus Doppelbauer 11/12/2006 12:09PM
Re: ORDER BY + LIMIT   26,888 Toa Sty 11/13/2006 04:40AM
Re: ORDER BY + LIMIT   3,186 Markus Doppelbauer 01/30/2007 12:06PM
bug?? partial index gives wrong results with IN subquery   2,034 Paul Davies 01/29/2007 08:44AM
File Sort   2,087 aftab khan 01/25/2007 08:49AM
Re: File Sort   1,623 KimSeong Loh 01/26/2007 07:50AM
SQL Newbie needs urgently help! [optimizing query]   2,667 Toxic Head 01/24/2007 05:31AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,726 Toxic Head 01/24/2007 05:52AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,645 Toa Sty 01/24/2007 06:07AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,698 Toxic Head 01/24/2007 06:18AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,617 Toa Sty 01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,792 Toxic Head 01/24/2007 07:32AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,637 Toxic Head 01/24/2007 06:41AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,614 Toxic Head 01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,639 Toa Sty 01/24/2007 08:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,715 Toxic Head 01/24/2007 08:50AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,588 Toxic Head 01/24/2007 09:24AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,661 Björn Steinbrink 01/24/2007 03:19PM
Re: SQL Newbie needs urgently help! [optimizing query]   1,604 Toxic Head 01/25/2007 07:27AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,651 Toa Sty 01/24/2007 10:29AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,649 Toxic Head 01/24/2007 10:40AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,660 Toa Sty 01/24/2007 09:10AM
need solution for ORDER BY and COUNT   2,280 Konstantin S. 01/25/2007 05:46AM
Need help optmizing query   1,892 Pascual Angulo 01/16/2007 03:58PM
Re: Need help optmizing query   1,626 KimSeong Loh 01/16/2007 06:42PM
How to optimize a derived table required for re-ordering.   2,749 Vikash Bucha 11/25/2006 05:58AM
Re: How to optimize a derived table required for re-ordering.   2,344 Toa Sty 01/15/2007 08:41AM
Help optimizing a slow query entry   2,109 Patrick 01/12/2007 10:28AM
Re: Help optimizing a slow query entry   1,577 Toa Sty 01/15/2007 08:30AM
Having problems with ORDER BY COUNT   12,718 steed coptang 04/29/2006 08:56AM
Re: Having problems with ORDER BY COUNT   4,625 Omar Khan 01/15/2007 03:35AM
Re: Having problems with ORDER BY COUNT   4,094 Toa Sty 01/15/2007 08:28AM
Problems optimize query   2,726 Rafal Kedziorski 01/08/2007 05:14PM
Make this faster?   2,598 Levi Tedder 01/04/2007 07:38AM
Re: Make this faster?   1,758 Björn Steinbrink 01/04/2007 03:34PM
Re: Make this faster?   1,793 Levi Tedder 01/05/2007 02:40AM
Re: Make this faster?   1,703 Björn Steinbrink 01/05/2007 05:07AM
Re: Make this faster?   1,685 Levi Tedder 01/05/2007 08:31AM
Re: Make this faster?   1,701 Toa Sty 01/05/2007 08:45AM
Re: Make this faster?   1,721 Levi Tedder 01/08/2007 02:44AM
Re: Make this faster?   1,699 Toa Sty 01/08/2007 04:28AM
Re: Make this faster?   1,734 Levi Tedder 01/08/2007 04:41AM
Re: Make this faster?   1,754 Levi Tedder 01/05/2007 03:11PM
Re: Make this faster?   1,714 Felix Geerinckx 01/05/2007 06:55AM
Re: Make this faster?   1,709 Toa Sty 01/05/2007 08:31AM
Re: Make this faster?   1,759 Levi Tedder 01/05/2007 08:33AM
Re: Make this faster?   1,758 Toa Sty 01/05/2007 08:45AM
Re: Make this faster?   1,739 Toa Sty 01/04/2007 10:21AM
Re: Make this faster?   1,690 Levi Tedder 01/04/2007 11:51AM
REGEXP is not optimized?   2,230 Maarten Oosten 12/15/2006 07:54AM
Re: REGEXP is not optimized?   1,961 Toa Sty 01/05/2007 08:57AM
Two general MySQL questions   3,432 Joost 01/02/2007 09:24AM
Re: Two general MySQL questions   1,692 KimSeong Loh 01/02/2007 08:11PM
Re: Two general MySQL questions   1,633 Joost 01/03/2007 05:35PM
Re: Two general MySQL questions   1,665 KimSeong Loh 01/03/2007 06:10PM
Re: Two general MySQL questions   1,684 Joost 01/04/2007 05:49AM
Re: Two general MySQL questions   1,593 Toa Sty 01/04/2007 10:53AM
i've got the query optimization blues ... stumped   1,927 Joe Simone 12/15/2006 02:48PM
Re: i've got the query optimization blues ... stumped   1,593 Toa Sty 01/04/2007 10:32AM
How to optimize the "order by" & "limit" query?   2,422 Jiangyubao Jiangyubao 12/18/2006 09:48AM
Re: How to optimize the "order by" & "limit" query?   1,705 Toa Sty 01/04/2007 10:25AM
parallelizing queries   1,893 Niklas Saers 01/02/2007 05:59AM
Query with GROUP BY (Using index for group-by -> Using index)   8,108 mnf 11/30/2006 05:20AM
Re: Query with GROUP BY (Using index for group-by -> Using index)   2,776 mnf 12/06/2006 02:03AM
Re: Query with GROUP BY (Using index for group-by -> Using index)   2,623 KimSeong Loh 12/07/2006 12:19AM
Re: Query with GROUP BY (Using index for group-by -> Using index)   2,618 mnf 12/25/2006 06:35AM
Re: Query with GROUP BY (Using index for group-by -> Using index)   3,198 KimSeong Loh 11/30/2006 08:18PM
Re: Query with GROUP BY (Using index for group-by -> Using index)   2,989 mnf 12/01/2006 12:21AM
optimization with table_cache   47,347 rei 09/05/2006 09:17PM
Re: optimization with table_cache   19,001 Björn Steinbrink 12/20/2006 02:45AM
Re: optimization with table_cache   19,645 sneakyimp 12/18/2006 10:40PM
Re: optimization with table_cache   19,473 Björn Steinbrink 12/20/2006 02:37AM
Optimizer Tool   2,382 Danie Van der Walt 09/04/2006 03:10AM
Re: Optimizer Tool   1,801 Yogesh Salvi 12/13/2006 04:57AM
Re: Optimizer Tool   2,634 KimSeong Loh 12/13/2006 07:39PM
Creating an index to include ORDER BY   2,132 Angus 11/02/2006 08:28AM
Re: Creating an index to include ORDER BY   1,553 KimSeong Loh 11/02/2006 05:31PM
Re: Creating an index to include ORDER BY   1,627 Angus 11/03/2006 09:24AM
Re: Creating an index to include ORDER BY   1,584 Yogesh Salvi 12/13/2006 05:02AM
Bad performance caused by DISTINCT?   7,247 Heist TheAlmighty 11/13/2006 02:02PM
Re: Bad performance caused by DISTINCT?   2,962 Yogesh Salvi 12/13/2006 04:46AM
Re: Bad performance caused by DISTINCT?   3,747 KimSeong Loh 11/19/2006 09:29PM
Two possible indexes in simple select but none is used   2,439 Ozkan Mehmedali 11/28/2006 10:40AM
Re: Two possible indexes in simple select but none is used   1,516 Yogesh Salvi 12/13/2006 04:41AM
Re: Two possible indexes in simple select but none is used   1,558 KimSeong Loh 11/28/2006 06:27PM
Current Page: 12 of 16

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.