MySQL Forums
Forum List  »  Optimizer & Parser

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

Subject
Views
Written By
Posted
Question on bad execution plan  
4,533
Zw Zhu
06/16/2010 07:36AM
Re: Question on bad execution plan  
1,866
Rick James
06/17/2010 09:29AM
Re: Question on bad execution plan  
1,608
noicy seal
06/21/2010 09:24AM
Re: Question on bad execution plan  
1,752
Rick James
06/21/2010 06:47PM
Re: Question on bad execution plan  
1,816
noicy seal
06/22/2010 07:33AM
Re: Question on bad execution plan  
1,843
Rick James
06/22/2010 09:09AM
Re: Question on bad execution plan  
1,705
noicy seal
06/23/2010 07:44AM
Re: Question on bad execution plan  
1,814
Zw Zhu
06/24/2010 12:17AM
Re: Question on bad execution plan  
1,833
Rick James
06/24/2010 09:17PM
Re: Question on bad execution plan  
1,674
Zw Zhu
06/28/2010 02:39AM
Re: Question on bad execution plan  
1,818
Rick James
06/28/2010 08:50PM
Union of two binary Strings  
4,317
Amir Manzour
06/18/2010 10:43AM
Re: Union of two binary Strings  
2,104
Rick James
06/21/2010 06:49PM
Re: Union of two binary Strings  
1,631
Amir Manzour
06/26/2010 11:15AM
Re: Union of two binary Strings  
1,553
Rick James
06/26/2010 12:50PM
Re: Union of two binary Strings  
1,538
Amir Manzour
06/26/2010 05:40PM
Re: Union of two binary Strings  
1,458
Amir Manzour
06/26/2010 05:20PM
Re: Union of two binary Strings  
1,640
Amir Manzour
06/22/2010 09:30AM
Help  
2,560
Ami Panchal
06/24/2010 04:27AM
AUTO_INCREMENT does not work the way I want it to  
1,422
Rick James
06/26/2010 02:15PM
optimizar mysql innodb  
3,970
juan sanchez
06/24/2010 01:21AM
lock for update in Innodb  
3,454
noicy seal
06/23/2010 07:07AM
indices not used  
2,830
Martin Luy
05/25/2010 04:13AM
Re: indices not used  
1,628
Martin Luy
05/25/2010 12:07PM
Re: indices not used  
1,523
Rick James
05/27/2010 08:35PM
Re: indices not used  
1,464
Martin Luy
06/19/2010 03:35AM
Re: indices not used  
1,424
Rick James
06/21/2010 06:25PM
Re: indices not used  
1,361
Martin Luy
06/22/2010 01:15AM
Recurring expressions  
2,468
Johannes Gerer
05/27/2010 03:37PM
Re: Recurring expressions  
1,400
Rick James
05/28/2010 08:32PM
Execution plan changes back and forth  
3,030
John Scott
05/26/2010 02:46PM
Re: Execution plan changes back and forth  
1,678
Rick James
05/27/2010 08:26PM
COUNT(1) very slow why?  
3,371
fabio rossi
05/18/2010 02:56AM
Re: COUNT(1) very slow why?  
1,612
Rick James
05/20/2010 09:21PM
Query Optimization  
3,154
Alessandro De Lorenzi
05/18/2010 07:43AM
Re: Query Optimization  
1,541
Rick James
05/20/2010 09:19PM
ORDER BY and join: include columns that don't matter?  
2,634
Chris Hennick
05/11/2010 02:54AM
Re: ORDER BY and join: include columns that don't matter?  
1,625
Rick James
05/12/2010 08:04AM
Help with ORDER BY with LIMIT  
5,286
Lukas Pilny
05/09/2010 02:24PM
Re: Help with ORDER BY with LIMIT  
2,534
Rick James
05/10/2010 10:59PM
Re: Help with ORDER BY with LIMIT  
2,067
Lukas Pilny
05/11/2010 06:05AM
table_cache not getting read  
2,743
Douglas Ferguson
05/07/2010 01:08AM
Re: table_cache not getting read  
1,672
Rick James
05/10/2010 11:19PM
UDF is no longer optimal  
2,315
Chris Canipe
05/10/2010 02:07PM
Re: UDF is no longer optimal  
1,498
Chris Canipe
05/10/2010 03:15PM
Composite Primary Key  
4,632
Gaurav Sharma
04/27/2010 05:30AM
Re: Composite Primary Key  
1,898
Rick James
04/29/2010 11:19PM
Help with Explain Plan  
2,819
Corey Samuels
04/20/2010 10:02AM
Re: Help with Explain Plan  
1,625
Rick James
04/24/2010 02:36PM
Re: Help with Explain Plan  
1,726
Corey Samuels
04/27/2010 12:44PM
Re: Help with Explain Plan  
1,374
Rick James
04/29/2010 09:17PM
Re: Help with Explain Plan  
1,767
Corey Samuels
04/22/2010 09:53AM
help, optmization... 6 tables... 1 select!  
2,639
John Aust
04/27/2010 06:59AM
URGENT: MySQL don't get enough CPU  
2,397
Robert Garrido
04/21/2010 03:38AM
Re: URGENT: MySQL don't get enough CPU  
1,444
Rick James
04/24/2010 03:14PM
partition question  
2,656
h ch
04/14/2010 02:15AM
Re: partition question  
1,549
Rick James
04/18/2010 01:36AM
why can character set of string literal cause different optimazation?  
2,138
Jerry Roletter
04/15/2010 04:27PM
How can I optimize this query?  
5,333
Martin Schiff
03/12/2010 02:40PM
Re: How can I optimize this query?  
1,876
Martin Schiff
03/16/2010 01:59PM
Re: How can I optimize this query?  
1,878
Rick James
03/27/2010 03:36PM
Re: How can I optimize this query?  
1,641
Martin Schiff
04/14/2010 07:21AM
Re: How can I optimize this query?  
2,354
Rick James
03/13/2010 04:07PM
Re: How can I optimize this query?  
1,846
Martin Schiff
03/16/2010 09:40AM
Re: How can I optimize this query?  
1,859
Martin Schiff
03/16/2010 08:21AM
Re: How can I optimize this query?  
1,859
Martin Schiff
03/16/2010 08:16AM
Re: How can I optimize this query?  
1,823
Martin Schiff
03/16/2010 08:16AM
Re: How can I optimize this query?  
1,946
Martin Schiff
03/16/2010 07:58AM
Re: IP range optimization  
1,783
Rick James
03/13/2010 04:17PM
Re: IP range optimization  
1,943
Martin Schiff
03/16/2010 08:22AM
Re: IP range optimization  
2,414
pavel iliev
04/14/2010 02:27AM
still the trigger problem  
3,193
h ch
04/07/2010 03:11AM
Re: still the trigger problem  
1,469
h ch
04/07/2010 06:43PM
Re: still the trigger problem  
1,496
Rick James
04/10/2010 01:10AM
Re: still the trigger problem  
1,616
h ch
04/09/2010 06:39PM
Really slow query with dependent subquery  
3,716
Ivo H
04/07/2010 04:12AM
Re: Really slow query with dependent subquery  
1,886
Ivo H
04/07/2010 05:53AM
Not equal operation can benefit from hash index?  
4,514
h ch
04/05/2010 08:45PM
Re: Not equal operation can benefit from hash index?  
1,975
Rick James
04/06/2010 09:53PM
Optimizer struggling with smaller dataset  
2,454
Damian Harvey
03/31/2010 09:09PM
Re: Optimizer struggling with smaller dataset  
1,450
Rick James
04/02/2010 11:19PM
how can i get the query execute time ?  
2,246
h ch
04/01/2010 02:01AM
group by date(indexed datetime) hard to optimize  
7,784
Lee Marshall
03/30/2010 12:37AM
Re: group by date(indexed datetime) hard to optimize  
2,706
Rick James
03/31/2010 10:58PM
Why filtering, ordering and limiting does not use index?  
3,054
Marc Canaleta
03/30/2010 07:26AM
Re: Why filtering, ordering and limiting does not use index?  
1,572
Rick James
03/31/2010 10:44PM
slave low speed in replication  
3,123
h ch
03/29/2010 01:02AM
Re: slave low speed in replication  
1,819
Rick James
03/30/2010 08:28AM
Re: slave low speed in replication  
1,754
h ch
03/30/2010 06:43PM
Re: slave low speed in replication  
1,459
Rick James
03/30/2010 09:48PM
Re: slave low speed in replication  
1,640
h ch
03/31/2010 01:05AM
Error when using Indexing hint  
3,038
Susi P
03/28/2010 04:11AM
Re: Error when using Indexing hint  
1,542
Rick James
03/28/2010 10:53PM
execute select took 8 min  
2,615
h ch
03/26/2010 12:31AM
Re: execute select took 8 min  
1,436
h ch
03/26/2010 01:51AM
Re: execute select took 8 min  
1,425
h ch
03/26/2010 02:24AM
Projection of a WHERE attribute  
7,173
brice chardin
03/16/2010 12:03PM
Re: Projection of a WHERE attribute  
2,198
brice chardin
03/18/2010 04:15AM
Re: Projection of a WHERE attribute  
1,815
Rick James
03/19/2010 07:37AM
Re: Projection of a WHERE attribute  
2,099
brice chardin
03/19/2010 10:06AM
Problems with query not using expeced indexes  
4,402
Lars Olesen
03/09/2010 07:12AM
Re: Problems with query not using expeced indexes  
1,818
Rick James
03/10/2010 10:28PM
Re: Problems with query not using expeced indexes  
1,648
Lars Olesen
03/11/2010 06:08AM
Re: Problems with query not using expeced indexes  
1,649
Rick James
03/11/2010 11:00PM
Re: Problems with query not using expeced indexes  
1,710
Lars Olesen
03/17/2010 12:16PM
Re: Problems with query not using expeced indexes  
1,802
Rick James
03/17/2010 09:57PM
Re: Problems with query not using expeced indexes  
1,526
Lars Olesen
03/18/2010 01:06AM
Re: Problems with query not using expeced indexes  
1,903
Rick James
03/18/2010 07:41AM
Re: Problems with query not using expeced indexes  
1,630
Lars Olesen
03/09/2010 07:13AM
union, where and indices  
9,466
Mattia Belletti
03/12/2010 09:21AM
Re: union, where and indices  
2,238
Rick James
03/13/2010 11:46AM
query optimization  
2,486
amol deshpande
03/12/2010 06:12AM
Re: query optimization  
1,566
Rick James
03/13/2010 09:11AM
Close to a million records & query too slow  
6,208
sabelo simelane
03/03/2010 01:49PM
Re: Close to a million records & query too slow  
2,442
Rick James
03/04/2010 10:09PM
Re: Close to a million records & query too slow  
2,243
sabelo simelane
03/08/2010 03:36PM
Re: Close to a million records & query too slow  
1,895
sabelo simelane
03/08/2010 04:12PM
Re: Close to a million records & query too slow  
2,275
Rick James
03/09/2010 09:20PM
Re: Close to a million records & query too slow  
1,927
sabelo simelane
03/11/2010 01:47AM
table/query help  
3,288
a g
03/03/2010 12:36PM
Re: table/query help  
1,689
Rick James
03/04/2010 10:22PM
How to get rid of 'filesort'?  
3,829
Ruslan Osmanov
02/28/2010 08:51AM
Re: How to get rid of 'filesort'?  
1,862
Rick James
03/01/2010 04:51PM
Re: How to get rid of 'filesort'?  
1,715
Ruslan Osmanov
03/01/2010 10:03PM
Re: How to get rid of 'filesort'?  
1,991
Rick James
03/01/2010 11:27PM
Re: How to get rid of 'filesort'?  
1,819
Ruslan Osmanov
03/02/2010 02:34AM
Re: How to get rid of 'filesort'?  
1,666
Rick James
03/02/2010 04:56PM
Is it possible to avoid "Using temporary" when distinct is used with join?  
3,693
Wai Yip Lau
02/25/2010 06:33PM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
1,770
Rick James
02/26/2010 09:03PM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
2,156
Wai Yip Lau
03/02/2010 09:50AM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
1,896
Rick James
03/02/2010 02:36PM
Slow search on one table, many where, order by and limit  
4,136
Yair P
02/07/2010 07:34AM
Re: Slow search on one table, many where, order by and limit  
2,036
Rick James
02/11/2010 01:30AM
Re: Slow search on one table, many where, order by and limit  
2,008
Yair P
02/26/2010 11:27AM
Re: Slow search on one table, many where, order by and limit  
1,923
Rick James
02/26/2010 12:40PM
Re: Slow search on one table, many where, order by and limit  
2,134
Yair P
02/26/2010 02:02PM
Re: Slow search on one table, many where, order by and limit  
1,808
Rick James
02/26/2010 07:40PM
Re: Slow search on one table, many where, order by and limit  
2,937
Yair P
03/01/2010 03:33AM
Re: Slow search on one table, many where, order by and limit  
2,018
Rick James
03/01/2010 01:50PM
Query that returns indexed fields involves FILESORT, why?  
4,434
Yurij Zagrebnoy
02/26/2010 12:36PM
Re: Query that returns indexed fields involves FILESORT, why?  
2,250
Rick James
02/28/2010 01:36PM
Re: Query that returns indexed fields involves FILESORT, why?  
1,976
Yurij Zagrebnoy
03/01/2010 08:28AM
Re: Query that returns indexed fields involves FILESORT, why?  
2,100
Rick James
03/01/2010 01:16PM
aggregation in mysql  
2,876
luca ghionna
02/27/2010 11:05AM
Re: aggregation in mysql  
1,688
Rick James
02/28/2010 01:48PM
Re: aggregation in mysql  
2,164
luca ghionna
02/28/2010 02:21PM
INNER JOIN optimization  
13,208
Irfan Ali
02/22/2010 12:52AM
Re: INNER JOIN optimization  
3,882
Rick James
02/23/2010 11:44PM
Re: INNER JOIN optimization  
3,490
Irfan Ali
02/27/2010 01:36PM
Re: INNER JOIN optimization  
3,075
Rick James
02/28/2010 11:20AM
aggregation in mysql  
3,102
luca ghionna
02/27/2010 11:03AM
How to improve mysql when the table is larger than 4G  
3,617
Zhiyi Zhao
02/25/2010 08:19PM
Re: How to improve mysql when the table is larger than 4G  
1,727
Rick James
02/26/2010 11:37AM
Distinct/group by, order by and filesort  
5,819
Tolan Blundell
02/23/2010 01:20PM
Re: Distinct/group by, order by and filesort  
2,730
Tolan Blundell
02/24/2010 04:50AM
Re: Distinct/group by, order by and filesort  
2,463
Rick James
02/25/2010 10:39AM
Re: Distinct/group by, order by and filesort  
2,313
Tolan Blundell
02/25/2010 11:54AM
Re: Distinct/group by, order by and filesort  
2,259
Rick James
02/25/2010 01:34PM
Can this be optimized any futher?  
2,607
Rob Strong
02/16/2010 02:44PM
Re: Can this be optimized any futher?  
1,452
Rick James
02/20/2010 11:26PM
Major MySQL problems  
5,082
Paul Coulter
02/10/2010 04:26AM
Re: Major MySQL problems  
2,610
Rick James
02/11/2010 10:45PM
Re: Major MySQL problems  
2,427
Paul Coulter
02/12/2010 07:17AM
Re: Major MySQL problems  
1,945
Rick James
02/12/2010 11:04AM
How to list data effectively  
2,905
sricharan vemuri
02/10/2010 09:55AM
Re: How to list data effectively  
1,494
Rick James
02/11/2010 10:56PM
Re: How to list data effectively  
1,508
sricharan vemuri
02/12/2010 08:21AM
query optimisation  
2,291
Daniel Kirk
02/10/2010 08:08AM
Re: query optimisation  
1,462
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.