Skip navigation links

MySQL Forums :: Optimizer & Parser


Advanced Search

Announcements Last Post
MySQL Connector/Python 2.0.0 Alpha has been released 07/24/2014 11:56AM
MySQL Connector/NET 6.9.2 RC has been released 07/18/2014 07:41PM
MySQL Connector/ODBC 5.3.4 has been released 07/18/2014 05:49PM
MySQL Enterprise Monitor 3.0.13 has been released 07/18/2014 03:20PM
MySQL Cluster 7.1.32 has been released 07/15/2014 09:06PM
Current Page: 12 of 16
Subject Views Written By Posted
CPU 99%   2,171 Neela Mahendran 04/17/2007 09:47PM
Optimizing index use in select statement   5,008 Andrey Kondakov 04/15/2007 07:23AM
Re: Optimizing index use in select statement   2,042 KimSeong Loh 04/15/2007 03:10PM
How to Control MySQL CPU Usage   1,965 TAT LIM CHIN 04/13/2007 11:39AM
Index on difference of two columns   2,831 Marty - 04/08/2007 09:31AM
Re: Index on difference of two columns   1,724 KimSeong Loh 04/11/2007 06:38AM
Re: Index on difference of two columns   1,711 Marty - 04/12/2007 12:06AM
otimize search with wildcar "%" ?   2,378 edson fernando 04/07/2007 12:02AM
Re: otimize search with wildcar "%" ?   1,611 KimSeong Loh 04/08/2007 09:01AM
help - join query optimization   2,099 Brian Kohan 04/05/2007 09:18AM
how to analyze this query_cache status   2,515 d h 03/30/2007 12:46AM
Slow Queries   1,971 Farrukh Ahmed 03/29/2007 02:32AM
Slow Subquery - Optimization in this simple query needed   3,605 elissaios 03/27/2007 11:42PM
Re: Slow Subquery - Optimization in this simple query needed   1,976 Björn Steinbrink 03/28/2007 06:22PM
Re: Slow Subquery - Optimization in this simple query needed   2,194 KimSeong Loh 03/28/2007 05:59PM
Optimize Multiple CPUs on Windows 2003 Server   2,648 Thomas Mockbee 03/28/2007 02:01PM
Limiting query research to a specified n. of records   2,225 marco rossi 03/16/2007 04:35AM
Re: Limiting query research to a specified n. of records   1,653 Björn Steinbrink 03/16/2007 09:59AM
B-Tree index ignored. Why?   5,573 Daniel Terry 03/14/2007 12:46PM
Re: B-Tree index ignored. Why?   2,351 KimSeong Loh 03/14/2007 07:39PM
Optimizing a Query   2,008 Drew Kutcharian 03/12/2007 08:45PM
Removing default NULL from table definition   2,622 Andrey Kondakov 03/11/2007 09:52AM
sql_no_cache added by the optimizer   2,695 alan langridge 03/08/2007 12:32PM
Re: sql_no_cache added by the optimizer   1,658 KimSeong Loh 03/08/2007 07:19PM
Extremely slow subqueries when used in joins   2,096 kalinda 03/08/2007 06:50AM
Optimizing Queries   2,080 Scott Pringle 03/06/2007 03:32PM
the query not optimized   2,056 Luca 03/02/2007 05:47AM
Optimizing this query slows it down   2,114 wm 02/28/2007 08:33AM
Re: Optimizing this query slows it down   1,545 KimSeong Loh 02/28/2007 06:26PM
low query   3,610 hakim benmouhoub 02/16/2007 03:49AM
Re: low query   1,580 Toa Sty 02/16/2007 04:44AM
Re: low query   1,514 ben hakim 02/16/2007 08:28AM
Re: low query   1,538 KimSeong Loh 02/25/2007 11:55PM
MySQL Optimizer Blogs by Sergey Petrunia   2,333 Edwin DeSouza 02/24/2007 12:54AM
how to explain this table status   2,131 rei 02/06/2007 04:33AM
Re: how to explain this table status   1,607 rei 02/22/2007 08:23PM
Large database   2,501 Omar Khan 01/12/2007 07:45AM
Re: Large database   1,721 Albert Arul prakash Rajendran 02/09/2007 01:42AM
Re: Large database   1,515 Omar Khan 02/14/2007 06:55AM
Re: Large database   1,768 KimSeong Loh 02/14/2007 06:47PM
Re: Large database   1,680 Omar Khan 02/15/2007 05:35AM
Re: Large database   1,769 Sean Allin 02/15/2007 05:13PM
Indexing for queries including count   1,873 Omar Khan 02/14/2007 07:05AM
Retrieved columns affects index usage   1,994 Angus 02/13/2007 12:06PM
Re: Retrieved columns affects index usage   1,545 KimSeong Loh 02/13/2007 06:37PM
force index on text & integer joiin   3,383 Simon Cranmer 02/12/2007 11:31AM
Re: force index on text & integer joiin   1,712 KimSeong Loh 02/12/2007 07:35PM
Re: force index on text & integer joiin   1,815 Simon Cranmer 02/13/2007 07:54AM
Optimizing query with joins   2,430 kayne 06/03/2006 12:18PM
Re: Optimizing query with joins   1,638 Rob Blick 06/07/2006 10:17AM
Re: Optimizing query with joins   1,602 Rhonda Heath 02/12/2007 12:07PM
Large IN() Comparison Optimize Help   1,973 Garrett Gyssler 02/11/2007 02:51AM
How should I index the tables in this query?   2,101 Dan Bress 02/09/2007 01:35PM
Substring ignores index   5,935 Matt Ryan 09/29/2006 08:59AM
Re: Substring ignores index   3,124 Toa Sty 09/29/2006 09:48AM
Re: Substring ignores index   2,512 Denver Vender 02/09/2007 04:01AM
Help required in optimizing query   2,029 Albert Arul prakash Rajendran 02/08/2007 09:43PM
intense query with "union"   1,869 asif baloch 02/07/2007 04:54PM
my boss says mysql is not upto standard: Please reply urgent   1,974 jatin shah 02/06/2007 06:05AM
Re: my boss says mysql is not upto standard: Please reply urgent   1,579 Toa Sty 02/06/2007 09:31AM
Simple queries take a lot some times   1,943 Paolo Ragone 01/30/2007 01:04PM
ORDER BY + LIMIT   4,014 Markus Doppelbauer 11/12/2006 04:45AM
Re: ORDER BY + LIMIT   2,843 Toa Sty 11/12/2006 08:27AM
Re: ORDER BY + LIMIT   2,563 Markus Doppelbauer 11/12/2006 12:09PM
Re: ORDER BY + LIMIT   27,776 Toa Sty 11/13/2006 04:40AM
Re: ORDER BY + LIMIT   3,224 Markus Doppelbauer 01/30/2007 12:06PM
bug?? partial index gives wrong results with IN subquery   2,071 Paul Davies 01/29/2007 08:44AM
File Sort   2,110 aftab khan 01/25/2007 08:49AM
Re: File Sort   1,635 KimSeong Loh 01/26/2007 07:50AM
SQL Newbie needs urgently help! [optimizing query]   2,696 Toxic Head 01/24/2007 05:31AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,741 Toxic Head 01/24/2007 05:52AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,659 Toa Sty 01/24/2007 06:07AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,715 Toxic Head 01/24/2007 06:18AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,633 Toa Sty 01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,808 Toxic Head 01/24/2007 07:32AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,651 Toxic Head 01/24/2007 06:41AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,631 Toxic Head 01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,662 Toa Sty 01/24/2007 08:16AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,728 Toxic Head 01/24/2007 08:50AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,603 Toxic Head 01/24/2007 09:24AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,674 Björn Steinbrink 01/24/2007 03:19PM
Re: SQL Newbie needs urgently help! [optimizing query]   1,618 Toxic Head 01/25/2007 07:27AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,675 Toa Sty 01/24/2007 10:29AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,661 Toxic Head 01/24/2007 10:40AM
Re: SQL Newbie needs urgently help! [optimizing query]   1,679 Toa Sty 01/24/2007 09:10AM
need solution for ORDER BY and COUNT   2,312 Konstantin S. 01/25/2007 05:46AM
Need help optmizing query   1,909 Pascual Angulo 01/16/2007 03:58PM
Re: Need help optmizing query   1,641 KimSeong Loh 01/16/2007 06:42PM
How to optimize a derived table required for re-ordering.   2,795 Vikash Bucha 11/25/2006 05:58AM
Re: How to optimize a derived table required for re-ordering.   2,367 Toa Sty 01/15/2007 08:41AM
Help optimizing a slow query entry   2,140 Patrick 01/12/2007 10:28AM
Re: Help optimizing a slow query entry   1,588 Toa Sty 01/15/2007 08:30AM
Having problems with ORDER BY COUNT   12,796 steed coptang 04/29/2006 08:56AM
Re: Having problems with ORDER BY COUNT   4,644 Omar Khan 01/15/2007 03:35AM
Re: Having problems with ORDER BY COUNT   4,108 Toa Sty 01/15/2007 08:28AM
Problems optimize query   2,752 Rafal Kedziorski 01/08/2007 05:14PM
Make this faster?   2,635 Levi Tedder 01/04/2007 07:38AM
Re: Make this faster?   1,781 Björn Steinbrink 01/04/2007 03:34PM
Re: Make this faster?   1,814 Levi Tedder 01/05/2007 02:40AM
Re: Make this faster?   1,716 Björn Steinbrink 01/05/2007 05:07AM
Re: Make this faster?   1,700 Levi Tedder 01/05/2007 08:31AM
Re: Make this faster?   1,715 Toa Sty 01/05/2007 08:45AM
Re: Make this faster?   1,733 Levi Tedder 01/08/2007 02:44AM
Re: Make this faster?   1,717 Toa Sty 01/08/2007 04:28AM
Re: Make this faster?   1,753 Levi Tedder 01/08/2007 04:41AM
Re: Make this faster?   1,766 Levi Tedder 01/05/2007 03:11PM
Re: Make this faster?   1,729 Felix Geerinckx 01/05/2007 06:55AM
Re: Make this faster?   1,728 Toa Sty 01/05/2007 08:31AM
Re: Make this faster?   1,774 Levi Tedder 01/05/2007 08:33AM
Re: Make this faster?   1,776 Toa Sty 01/05/2007 08:45AM
Re: Make this faster?   1,754 Toa Sty 01/04/2007 10:21AM
Re: Make this faster?   1,711 Levi Tedder 01/04/2007 11:51AM
REGEXP is not optimized?   2,284 Maarten Oosten 12/15/2006 07:54AM
Re: REGEXP is not optimized?   1,981 Toa Sty 01/05/2007 08:57AM
Two general MySQL questions   3,459 Joost 01/02/2007 09:24AM
Re: Two general MySQL questions   1,702 KimSeong Loh 01/02/2007 08:11PM
Re: Two general MySQL questions   1,644 Joost 01/03/2007 05:35PM
Re: Two general MySQL questions   1,682 KimSeong Loh 01/03/2007 06:10PM
Re: Two general MySQL questions   1,696 Joost 01/04/2007 05:49AM
Re: Two general MySQL questions   1,609 Toa Sty 01/04/2007 10:53AM
i've got the query optimization blues ... stumped   1,949 Joe Simone 12/15/2006 02:48PM
Re: i've got the query optimization blues ... stumped   1,612 Toa Sty 01/04/2007 10:32AM
How to optimize the "order by" & "limit" query?   2,447 Jiangyubao Jiangyubao 12/18/2006 09:48AM
Re: How to optimize the "order by" & "limit" query?   1,719 Toa Sty 01/04/2007 10:25AM
parallelizing queries   1,912 Niklas Saers 01/02/2007 05:59AM
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.