MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing a new webcast video that completes a deep dive into how to download and use Enterprise Manager for MySQL 04/04/2024 03:01PM

Advanced Search
New Topic
Pages:
« 1
...
7 8 9 10 11
...
19 »

Subject
Views
Written By
Posted
Question on bad execution plan  
4,431
Zw Zhu
06/16/2010 07:36AM
Re: Question on bad execution plan  
1,825
Rick James
06/17/2010 09:29AM
Re: Question on bad execution plan  
1,557
noicy seal
06/21/2010 09:24AM
Re: Question on bad execution plan  
1,717
Rick James
06/21/2010 06:47PM
Re: Question on bad execution plan  
1,774
noicy seal
06/22/2010 07:33AM
Re: Question on bad execution plan  
1,799
Rick James
06/22/2010 09:09AM
Re: Question on bad execution plan  
1,667
noicy seal
06/23/2010 07:44AM
Re: Question on bad execution plan  
1,775
Zw Zhu
06/24/2010 12:17AM
Re: Question on bad execution plan  
1,785
Rick James
06/24/2010 09:17PM
Re: Question on bad execution plan  
1,633
Zw Zhu
06/28/2010 02:39AM
Re: Question on bad execution plan  
1,781
Rick James
06/28/2010 08:50PM
Union of two binary Strings  
4,251
Amir Manzour
06/18/2010 10:43AM
Re: Union of two binary Strings  
2,071
Rick James
06/21/2010 06:49PM
Re: Union of two binary Strings  
1,584
Amir Manzour
06/26/2010 11:15AM
Re: Union of two binary Strings  
1,513
Rick James
06/26/2010 12:50PM
Re: Union of two binary Strings  
1,494
Amir Manzour
06/26/2010 05:40PM
Re: Union of two binary Strings  
1,413
Amir Manzour
06/26/2010 05:20PM
Re: Union of two binary Strings  
1,597
Amir Manzour
06/22/2010 09:30AM
Help  
2,487
Ami Panchal
06/24/2010 04:27AM
AUTO_INCREMENT does not work the way I want it to  
1,383
Rick James
06/26/2010 02:15PM
optimizar mysql innodb  
3,869
juan sanchez
06/24/2010 01:21AM
lock for update in Innodb  
3,389
noicy seal
06/23/2010 07:07AM
indices not used  
2,758
Martin Luy
05/25/2010 04:13AM
Re: indices not used  
1,586
Martin Luy
05/25/2010 12:07PM
Re: indices not used  
1,483
Rick James
05/27/2010 08:35PM
Re: indices not used  
1,429
Martin Luy
06/19/2010 03:35AM
Re: indices not used  
1,392
Rick James
06/21/2010 06:25PM
Re: indices not used  
1,333
Martin Luy
06/22/2010 01:15AM
Recurring expressions  
2,422
Johannes Gerer
05/27/2010 03:37PM
Re: Recurring expressions  
1,372
Rick James
05/28/2010 08:32PM
Execution plan changes back and forth  
2,979
John Scott
05/26/2010 02:46PM
Re: Execution plan changes back and forth  
1,649
Rick James
05/27/2010 08:26PM
COUNT(1) very slow why?  
3,330
fabio rossi
05/18/2010 02:56AM
Re: COUNT(1) very slow why?  
1,590
Rick James
05/20/2010 09:21PM
Query Optimization  
3,103
Alessandro De Lorenzi
05/18/2010 07:43AM
Re: Query Optimization  
1,514
Rick James
05/20/2010 09:19PM
ORDER BY and join: include columns that don't matter?  
2,567
Chris Hennick
05/11/2010 02:54AM
Re: ORDER BY and join: include columns that don't matter?  
1,601
Rick James
05/12/2010 08:04AM
Help with ORDER BY with LIMIT  
5,226
Lukas Pilny
05/09/2010 02:24PM
Re: Help with ORDER BY with LIMIT  
2,510
Rick James
05/10/2010 10:59PM
Re: Help with ORDER BY with LIMIT  
2,038
Lukas Pilny
05/11/2010 06:05AM
table_cache not getting read  
2,691
Douglas Ferguson
05/07/2010 01:08AM
Re: table_cache not getting read  
1,642
Rick James
05/10/2010 11:19PM
UDF is no longer optimal  
2,262
Chris Canipe
05/10/2010 02:07PM
Re: UDF is no longer optimal  
1,453
Chris Canipe
05/10/2010 03:15PM
Composite Primary Key  
4,574
Gaurav Sharma
04/27/2010 05:30AM
Re: Composite Primary Key  
1,876
Rick James
04/29/2010 11:19PM
Help with Explain Plan  
2,760
Corey Samuels
04/20/2010 10:02AM
Re: Help with Explain Plan  
1,591
Rick James
04/24/2010 02:36PM
Re: Help with Explain Plan  
1,685
Corey Samuels
04/27/2010 12:44PM
Re: Help with Explain Plan  
1,336
Rick James
04/29/2010 09:17PM
Re: Help with Explain Plan  
1,732
Corey Samuels
04/22/2010 09:53AM
help, optmization... 6 tables... 1 select!  
2,582
John Aust
04/27/2010 06:59AM
URGENT: MySQL don't get enough CPU  
2,339
Robert Garrido
04/21/2010 03:38AM
Re: URGENT: MySQL don't get enough CPU  
1,407
Rick James
04/24/2010 03:14PM
partition question  
2,601
h ch
04/14/2010 02:15AM
Re: partition question  
1,520
Rick James
04/18/2010 01:36AM
why can character set of string literal cause different optimazation?  
2,041
Jerry Roletter
04/15/2010 04:27PM
How can I optimize this query?  
5,225
Martin Schiff
03/12/2010 02:40PM
Re: How can I optimize this query?  
1,837
Martin Schiff
03/16/2010 01:59PM
Re: How can I optimize this query?  
1,835
Rick James
03/27/2010 03:36PM
Re: How can I optimize this query?  
1,601
Martin Schiff
04/14/2010 07:21AM
Re: How can I optimize this query?  
2,314
Rick James
03/13/2010 04:07PM
Re: How can I optimize this query?  
1,797
Martin Schiff
03/16/2010 09:40AM
Re: How can I optimize this query?  
1,816
Martin Schiff
03/16/2010 08:21AM
Re: How can I optimize this query?  
1,823
Martin Schiff
03/16/2010 08:16AM
Re: How can I optimize this query?  
1,781
Martin Schiff
03/16/2010 08:16AM
Re: How can I optimize this query?  
1,902
Martin Schiff
03/16/2010 07:58AM
Re: IP range optimization  
1,743
Rick James
03/13/2010 04:17PM
Re: IP range optimization  
1,900
Martin Schiff
03/16/2010 08:22AM
Re: IP range optimization  
2,371
pavel iliev
04/14/2010 02:27AM
still the trigger problem  
3,100
h ch
04/07/2010 03:11AM
Re: still the trigger problem  
1,432
h ch
04/07/2010 06:43PM
Re: still the trigger problem  
1,461
Rick James
04/10/2010 01:10AM
Re: still the trigger problem  
1,579
h ch
04/09/2010 06:39PM
Really slow query with dependent subquery  
3,629
Ivo H
04/07/2010 04:12AM
Re: Really slow query with dependent subquery  
1,848
Ivo H
04/07/2010 05:53AM
Not equal operation can benefit from hash index?  
4,449
h ch
04/05/2010 08:45PM
Re: Not equal operation can benefit from hash index?  
1,939
Rick James
04/06/2010 09:53PM
Optimizer struggling with smaller dataset  
2,374
Damian Harvey
03/31/2010 09:09PM
Re: Optimizer struggling with smaller dataset  
1,419
Rick James
04/02/2010 11:19PM
how can i get the query execute time ?  
2,163
h ch
04/01/2010 02:01AM
group by date(indexed datetime) hard to optimize  
7,655
Lee Marshall
03/30/2010 12:37AM
Re: group by date(indexed datetime) hard to optimize  
2,639
Rick James
03/31/2010 10:58PM
Why filtering, ordering and limiting does not use index?  
2,982
Marc Canaleta
03/30/2010 07:26AM
Re: Why filtering, ordering and limiting does not use index?  
1,541
Rick James
03/31/2010 10:44PM
slave low speed in replication  
3,052
h ch
03/29/2010 01:02AM
Re: slave low speed in replication  
1,781
Rick James
03/30/2010 08:28AM
Re: slave low speed in replication  
1,714
h ch
03/30/2010 06:43PM
Re: slave low speed in replication  
1,420
Rick James
03/30/2010 09:48PM
Re: slave low speed in replication  
1,600
h ch
03/31/2010 01:05AM
Error when using Indexing hint  
2,960
Susi P
03/28/2010 04:11AM
Re: Error when using Indexing hint  
1,506
Rick James
03/28/2010 10:53PM
execute select took 8 min  
2,545
h ch
03/26/2010 12:31AM
Re: execute select took 8 min  
1,397
h ch
03/26/2010 01:51AM
Re: execute select took 8 min  
1,389
h ch
03/26/2010 02:24AM
Projection of a WHERE attribute  
7,057
brice chardin
03/16/2010 12:03PM
Re: Projection of a WHERE attribute  
2,161
brice chardin
03/18/2010 04:15AM
Re: Projection of a WHERE attribute  
1,779
Rick James
03/19/2010 07:37AM
Re: Projection of a WHERE attribute  
2,055
brice chardin
03/19/2010 10:06AM
Problems with query not using expeced indexes  
4,266
Lars Olesen
03/09/2010 07:12AM
Re: Problems with query not using expeced indexes  
1,779
Rick James
03/10/2010 10:28PM
Re: Problems with query not using expeced indexes  
1,615
Lars Olesen
03/11/2010 06:08AM
Re: Problems with query not using expeced indexes  
1,614
Rick James
03/11/2010 11:00PM
Re: Problems with query not using expeced indexes  
1,675
Lars Olesen
03/17/2010 12:16PM
Re: Problems with query not using expeced indexes  
1,766
Rick James
03/17/2010 09:57PM
Re: Problems with query not using expeced indexes  
1,492
Lars Olesen
03/18/2010 01:06AM
Re: Problems with query not using expeced indexes  
1,862
Rick James
03/18/2010 07:41AM
Re: Problems with query not using expeced indexes  
1,596
Lars Olesen
03/09/2010 07:13AM
union, where and indices  
9,407
Mattia Belletti
03/12/2010 09:21AM
Re: union, where and indices  
2,194
Rick James
03/13/2010 11:46AM
query optimization  
2,410
amol deshpande
03/12/2010 06:12AM
Re: query optimization  
1,526
Rick James
03/13/2010 09:11AM
Close to a million records & query too slow  
6,100
sabelo simelane
03/03/2010 01:49PM
Re: Close to a million records & query too slow  
2,397
Rick James
03/04/2010 10:09PM
Re: Close to a million records & query too slow  
2,197
sabelo simelane
03/08/2010 03:36PM
Re: Close to a million records & query too slow  
1,855
sabelo simelane
03/08/2010 04:12PM
Re: Close to a million records & query too slow  
2,233
Rick James
03/09/2010 09:20PM
Re: Close to a million records & query too slow  
1,886
sabelo simelane
03/11/2010 01:47AM
table/query help  
3,185
a g
03/03/2010 12:36PM
Re: table/query help  
1,640
Rick James
03/04/2010 10:22PM
How to get rid of 'filesort'?  
3,761
Ruslan Osmanov
02/28/2010 08:51AM
Re: How to get rid of 'filesort'?  
1,810
Rick James
03/01/2010 04:51PM
Re: How to get rid of 'filesort'?  
1,669
Ruslan Osmanov
03/01/2010 10:03PM
Re: How to get rid of 'filesort'?  
1,942
Rick James
03/01/2010 11:27PM
Re: How to get rid of 'filesort'?  
1,771
Ruslan Osmanov
03/02/2010 02:34AM
Re: How to get rid of 'filesort'?  
1,611
Rick James
03/02/2010 04:56PM
Is it possible to avoid "Using temporary" when distinct is used with join?  
3,609
Wai Yip Lau
02/25/2010 06:33PM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
1,732
Rick James
02/26/2010 09:03PM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
2,121
Wai Yip Lau
03/02/2010 09:50AM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
1,848
Rick James
03/02/2010 02:36PM
Slow search on one table, many where, order by and limit  
4,067
Yair P
02/07/2010 07:34AM
Re: Slow search on one table, many where, order by and limit  
1,984
Rick James
02/11/2010 01:30AM
Re: Slow search on one table, many where, order by and limit  
1,966
Yair P
02/26/2010 11:27AM
Re: Slow search on one table, many where, order by and limit  
1,881
Rick James
02/26/2010 12:40PM
Re: Slow search on one table, many where, order by and limit  
2,091
Yair P
02/26/2010 02:02PM
Re: Slow search on one table, many where, order by and limit  
1,767
Rick James
02/26/2010 07:40PM
Re: Slow search on one table, many where, order by and limit  
2,888
Yair P
03/01/2010 03:33AM
Re: Slow search on one table, many where, order by and limit  
1,976
Rick James
03/01/2010 01:50PM
Query that returns indexed fields involves FILESORT, why?  
4,307
Yurij Zagrebnoy
02/26/2010 12:36PM
Re: Query that returns indexed fields involves FILESORT, why?  
2,197
Rick James
02/28/2010 01:36PM
Re: Query that returns indexed fields involves FILESORT, why?  
1,934
Yurij Zagrebnoy
03/01/2010 08:28AM
Re: Query that returns indexed fields involves FILESORT, why?  
2,061
Rick James
03/01/2010 01:16PM
aggregation in mysql  
2,807
luca ghionna
02/27/2010 11:05AM
Re: aggregation in mysql  
1,637
Rick James
02/28/2010 01:48PM
Re: aggregation in mysql  
2,125
luca ghionna
02/28/2010 02:21PM
INNER JOIN optimization  
13,087
Irfan Ali
02/22/2010 12:52AM
Re: INNER JOIN optimization  
3,844
Rick James
02/23/2010 11:44PM
Re: INNER JOIN optimization  
3,451
Irfan Ali
02/27/2010 01:36PM
Re: INNER JOIN optimization  
3,035
Rick James
02/28/2010 11:20AM
aggregation in mysql  
3,041
luca ghionna
02/27/2010 11:03AM
How to improve mysql when the table is larger than 4G  
3,550
Zhiyi Zhao
02/25/2010 08:19PM
Re: How to improve mysql when the table is larger than 4G  
1,696
Rick James
02/26/2010 11:37AM
Distinct/group by, order by and filesort  
5,747
Tolan Blundell
02/23/2010 01:20PM
Re: Distinct/group by, order by and filesort  
2,695
Tolan Blundell
02/24/2010 04:50AM
Re: Distinct/group by, order by and filesort  
2,423
Rick James
02/25/2010 10:39AM
Re: Distinct/group by, order by and filesort  
2,258
Tolan Blundell
02/25/2010 11:54AM
Re: Distinct/group by, order by and filesort  
2,197
Rick James
02/25/2010 01:34PM
Can this be optimized any futher?  
2,557
Rob Strong
02/16/2010 02:44PM
Re: Can this be optimized any futher?  
1,424
Rick James
02/20/2010 11:26PM
Major MySQL problems  
5,040
Paul Coulter
02/10/2010 04:26AM
Re: Major MySQL problems  
2,585
Rick James
02/11/2010 10:45PM
Re: Major MySQL problems  
2,405
Paul Coulter
02/12/2010 07:17AM
Re: Major MySQL problems  
1,920
Rick James
02/12/2010 11:04AM
How to list data effectively  
2,862
sricharan vemuri
02/10/2010 09:55AM
Re: How to list data effectively  
1,469
Rick James
02/11/2010 10:56PM
Re: How to list data effectively  
1,485
sricharan vemuri
02/12/2010 08:21AM
query optimisation  
2,248
Daniel Kirk
02/10/2010 08:08AM
Re: query optimisation  
1,443
Rick James
02/11/2010 10:46PM
Pages:
« 1
...
7 8 9 10 11
...
19 »

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.