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,915
Zw Zhu
06/16/2010 07:36AM
Re: Question on bad execution plan  
2,029
Rick James
06/17/2010 09:29AM
Re: Question on bad execution plan  
1,751
noicy seal
06/21/2010 09:24AM
Re: Question on bad execution plan  
1,899
Rick James
06/21/2010 06:47PM
Re: Question on bad execution plan  
1,966
noicy seal
06/22/2010 07:33AM
Re: Question on bad execution plan  
2,009
Rick James
06/22/2010 09:09AM
Re: Question on bad execution plan  
1,845
noicy seal
06/23/2010 07:44AM
Re: Question on bad execution plan  
1,986
Zw Zhu
06/24/2010 12:17AM
Re: Question on bad execution plan  
1,977
Rick James
06/24/2010 09:17PM
Re: Question on bad execution plan  
1,830
Zw Zhu
06/28/2010 02:39AM
Re: Question on bad execution plan  
1,954
Rick James
06/28/2010 08:50PM
Union of two binary Strings  
4,662
Amir Manzour
06/18/2010 10:43AM
Re: Union of two binary Strings  
2,250
Rick James
06/21/2010 06:49PM
Re: Union of two binary Strings  
1,751
Amir Manzour
06/26/2010 11:15AM
Re: Union of two binary Strings  
1,687
Rick James
06/26/2010 12:50PM
Re: Union of two binary Strings  
1,658
Amir Manzour
06/26/2010 05:40PM
Re: Union of two binary Strings  
1,588
Amir Manzour
06/26/2010 05:20PM
Re: Union of two binary Strings  
1,787
Amir Manzour
06/22/2010 09:30AM
Help  
2,802
Ami Panchal
06/24/2010 04:27AM
AUTO_INCREMENT does not work the way I want it to  
1,557
Rick James
06/26/2010 02:15PM
optimizar mysql innodb  
4,242
juan sanchez
06/24/2010 01:21AM
lock for update in Innodb  
3,731
noicy seal
06/23/2010 07:07AM
indices not used  
3,103
Martin Luy
05/25/2010 04:13AM
Re: indices not used  
1,816
Martin Luy
05/25/2010 12:07PM
Re: indices not used  
1,676
Rick James
05/27/2010 08:35PM
Re: indices not used  
1,610
Martin Luy
06/19/2010 03:35AM
Re: indices not used  
1,576
Rick James
06/21/2010 06:25PM
Re: indices not used  
1,500
Martin Luy
06/22/2010 01:15AM
Recurring expressions  
2,729
Johannes Gerer
05/27/2010 03:37PM
Re: Recurring expressions  
1,523
Rick James
05/28/2010 08:32PM
Execution plan changes back and forth  
3,304
John Scott
05/26/2010 02:46PM
Re: Execution plan changes back and forth  
1,828
Rick James
05/27/2010 08:26PM
COUNT(1) very slow why?  
3,607
fabio rossi
05/18/2010 02:56AM
Re: COUNT(1) very slow why?  
1,739
Rick James
05/20/2010 09:21PM
Query Optimization  
3,376
Alessandro De Lorenzi
05/18/2010 07:43AM
Re: Query Optimization  
1,669
Rick James
05/20/2010 09:19PM
ORDER BY and join: include columns that don't matter?  
2,902
Chris Hennick
05/11/2010 02:54AM
Re: ORDER BY and join: include columns that don't matter?  
1,752
Rick James
05/12/2010 08:04AM
Help with ORDER BY with LIMIT  
5,547
Lukas Pilny
05/09/2010 02:24PM
Re: Help with ORDER BY with LIMIT  
2,659
Rick James
05/10/2010 10:59PM
Re: Help with ORDER BY with LIMIT  
2,204
Lukas Pilny
05/11/2010 06:05AM
table_cache not getting read  
2,978
Douglas Ferguson
05/07/2010 01:08AM
Re: table_cache not getting read  
1,800
Rick James
05/10/2010 11:19PM
UDF is no longer optimal  
2,574
Chris Canipe
05/10/2010 02:07PM
Re: UDF is no longer optimal  
1,638
Chris Canipe
05/10/2010 03:15PM
Composite Primary Key  
4,882
Gaurav Sharma
04/27/2010 05:30AM
Re: Composite Primary Key  
2,032
Rick James
04/29/2010 11:19PM
Help with Explain Plan  
3,071
Corey Samuels
04/20/2010 10:02AM
Re: Help with Explain Plan  
1,778
Rick James
04/24/2010 02:36PM
Re: Help with Explain Plan  
1,869
Corey Samuels
04/27/2010 12:44PM
Re: Help with Explain Plan  
1,498
Rick James
04/29/2010 09:17PM
Re: Help with Explain Plan  
1,914
Corey Samuels
04/22/2010 09:53AM
help, optmization... 6 tables... 1 select!  
2,876
John Aust
04/27/2010 06:59AM
URGENT: MySQL don't get enough CPU  
2,644
Robert Garrido
04/21/2010 03:38AM
Re: URGENT: MySQL don't get enough CPU  
1,587
Rick James
04/24/2010 03:14PM
partition question  
2,937
h ch
04/14/2010 02:15AM
Re: partition question  
1,690
Rick James
04/18/2010 01:36AM
why can character set of string literal cause different optimazation?  
2,402
Jerry Roletter
04/15/2010 04:27PM
How can I optimize this query?  
5,803
Martin Schiff
03/12/2010 02:40PM
Re: How can I optimize this query?  
2,048
Martin Schiff
03/16/2010 01:59PM
Re: How can I optimize this query?  
2,049
Rick James
03/27/2010 03:36PM
Re: How can I optimize this query?  
1,797
Martin Schiff
04/14/2010 07:21AM
Re: How can I optimize this query?  
2,534
Rick James
03/13/2010 04:07PM
Re: How can I optimize this query?  
2,030
Martin Schiff
03/16/2010 09:40AM
Re: How can I optimize this query?  
2,024
Martin Schiff
03/16/2010 08:21AM
Re: How can I optimize this query?  
2,062
Martin Schiff
03/16/2010 08:16AM
Re: How can I optimize this query?  
2,099
Martin Schiff
03/16/2010 08:16AM
Re: How can I optimize this query?  
2,141
Martin Schiff
03/16/2010 07:58AM
Re: IP range optimization  
1,958
Rick James
03/13/2010 04:17PM
Re: IP range optimization  
2,131
Martin Schiff
03/16/2010 08:22AM
Re: IP range optimization  
2,595
pavel iliev
04/14/2010 02:27AM
still the trigger problem  
3,527
h ch
04/07/2010 03:11AM
Re: still the trigger problem  
1,603
h ch
04/07/2010 06:43PM
Re: still the trigger problem  
1,620
Rick James
04/10/2010 01:10AM
Re: still the trigger problem  
1,782
h ch
04/09/2010 06:39PM
Really slow query with dependent subquery  
4,064
Ivo H
04/07/2010 04:12AM
Re: Really slow query with dependent subquery  
2,020
Ivo H
04/07/2010 05:53AM
Not equal operation can benefit from hash index?  
4,819
h ch
04/05/2010 08:45PM
Re: Not equal operation can benefit from hash index?  
2,135
Rick James
04/06/2010 09:53PM
Optimizer struggling with smaller dataset  
2,758
Damian Harvey
03/31/2010 09:09PM
Re: Optimizer struggling with smaller dataset  
1,589
Rick James
04/02/2010 11:19PM
how can i get the query execute time ?  
2,517
h ch
04/01/2010 02:01AM
group by date(indexed datetime) hard to optimize  
8,480
Lee Marshall
03/30/2010 12:37AM
Re: group by date(indexed datetime) hard to optimize  
2,881
Rick James
03/31/2010 10:58PM
Why filtering, ordering and limiting does not use index?  
3,331
Marc Canaleta
03/30/2010 07:26AM
Re: Why filtering, ordering and limiting does not use index?  
1,718
Rick James
03/31/2010 10:44PM
slave low speed in replication  
3,363
h ch
03/29/2010 01:02AM
Re: slave low speed in replication  
1,967
Rick James
03/30/2010 08:28AM
Re: slave low speed in replication  
1,864
h ch
03/30/2010 06:43PM
Re: slave low speed in replication  
1,577
Rick James
03/30/2010 09:48PM
Re: slave low speed in replication  
1,779
h ch
03/31/2010 01:05AM
Error when using Indexing hint  
3,347
Susi P
03/28/2010 04:11AM
Re: Error when using Indexing hint  
1,657
Rick James
03/28/2010 10:53PM
execute select took 8 min  
2,931
h ch
03/26/2010 12:31AM
Re: execute select took 8 min  
1,576
h ch
03/26/2010 01:51AM
Re: execute select took 8 min  
1,570
h ch
03/26/2010 02:24AM
Projection of a WHERE attribute  
7,535
brice chardin
03/16/2010 12:03PM
Re: Projection of a WHERE attribute  
2,344
brice chardin
03/18/2010 04:15AM
Re: Projection of a WHERE attribute  
1,938
Rick James
03/19/2010 07:37AM
Re: Projection of a WHERE attribute  
2,247
brice chardin
03/19/2010 10:06AM
Problems with query not using expeced indexes  
4,728
Lars Olesen
03/09/2010 07:12AM
Re: Problems with query not using expeced indexes  
1,951
Rick James
03/10/2010 10:28PM
Re: Problems with query not using expeced indexes  
1,789
Lars Olesen
03/11/2010 06:08AM
Re: Problems with query not using expeced indexes  
1,800
Rick James
03/11/2010 11:00PM
Re: Problems with query not using expeced indexes  
1,859
Lars Olesen
03/17/2010 12:16PM
Re: Problems with query not using expeced indexes  
1,946
Rick James
03/17/2010 09:57PM
Re: Problems with query not using expeced indexes  
1,674
Lars Olesen
03/18/2010 01:06AM
Re: Problems with query not using expeced indexes  
2,062
Rick James
03/18/2010 07:41AM
Re: Problems with query not using expeced indexes  
1,782
Lars Olesen
03/09/2010 07:13AM
union, where and indices  
9,771
Mattia Belletti
03/12/2010 09:21AM
Re: union, where and indices  
2,381
Rick James
03/13/2010 11:46AM
query optimization  
2,745
amol deshpande
03/12/2010 06:12AM
Re: query optimization  
1,714
Rick James
03/13/2010 09:11AM
Close to a million records & query too slow  
6,593
sabelo simelane
03/03/2010 01:49PM
Re: Close to a million records & query too slow  
2,618
Rick James
03/04/2010 10:09PM
Re: Close to a million records & query too slow  
2,394
sabelo simelane
03/08/2010 03:36PM
Re: Close to a million records & query too slow  
2,041
sabelo simelane
03/08/2010 04:12PM
Re: Close to a million records & query too slow  
2,482
Rick James
03/09/2010 09:20PM
Re: Close to a million records & query too slow  
2,061
sabelo simelane
03/11/2010 01:47AM
table/query help  
3,650
a g
03/03/2010 12:36PM
Re: table/query help  
1,868
Rick James
03/04/2010 10:22PM
How to get rid of 'filesort'?  
4,133
Ruslan Osmanov
02/28/2010 08:51AM
Re: How to get rid of 'filesort'?  
2,061
Rick James
03/01/2010 04:51PM
Re: How to get rid of 'filesort'?  
1,856
Ruslan Osmanov
03/01/2010 10:03PM
Re: How to get rid of 'filesort'?  
2,168
Rick James
03/01/2010 11:27PM
Re: How to get rid of 'filesort'?  
1,968
Ruslan Osmanov
03/02/2010 02:34AM
Re: How to get rid of 'filesort'?  
1,838
Rick James
03/02/2010 04:56PM
Is it possible to avoid "Using temporary" when distinct is used with join?  
4,040
Wai Yip Lau
02/25/2010 06:33PM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
1,945
Rick James
02/26/2010 09:03PM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
2,309
Wai Yip Lau
03/02/2010 09:50AM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
2,073
Rick James
03/02/2010 02:36PM
Slow search on one table, many where, order by and limit  
4,486
Yair P
02/07/2010 07:34AM
Re: Slow search on one table, many where, order by and limit  
2,201
Rick James
02/11/2010 01:30AM
Re: Slow search on one table, many where, order by and limit  
2,160
Yair P
02/26/2010 11:27AM
Re: Slow search on one table, many where, order by and limit  
2,098
Rick James
02/26/2010 12:40PM
Re: Slow search on one table, many where, order by and limit  
2,316
Yair P
02/26/2010 02:02PM
Re: Slow search on one table, many where, order by and limit  
1,986
Rick James
02/26/2010 07:40PM
Re: Slow search on one table, many where, order by and limit  
3,079
Yair P
03/01/2010 03:33AM
Re: Slow search on one table, many where, order by and limit  
2,186
Rick James
03/01/2010 01:50PM
Query that returns indexed fields involves FILESORT, why?  
4,858
Yurij Zagrebnoy
02/26/2010 12:36PM
Re: Query that returns indexed fields involves FILESORT, why?  
2,415
Rick James
02/28/2010 01:36PM
Re: Query that returns indexed fields involves FILESORT, why?  
2,132
Yurij Zagrebnoy
03/01/2010 08:28AM
Re: Query that returns indexed fields involves FILESORT, why?  
2,261
Rick James
03/01/2010 01:16PM
aggregation in mysql  
3,161
luca ghionna
02/27/2010 11:05AM
Re: aggregation in mysql  
1,893
Rick James
02/28/2010 01:48PM
Re: aggregation in mysql  
2,303
luca ghionna
02/28/2010 02:21PM
INNER JOIN optimization  
13,501
Irfan Ali
02/22/2010 12:52AM
Re: INNER JOIN optimization  
4,039
Rick James
02/23/2010 11:44PM
Re: INNER JOIN optimization  
3,671
Irfan Ali
02/27/2010 01:36PM
Re: INNER JOIN optimization  
3,264
Rick James
02/28/2010 11:20AM
aggregation in mysql  
3,372
luca ghionna
02/27/2010 11:03AM
How to improve mysql when the table is larger than 4G  
3,931
Zhiyi Zhao
02/25/2010 08:19PM
Re: How to improve mysql when the table is larger than 4G  
1,915
Rick James
02/26/2010 11:37AM
Distinct/group by, order by and filesort  
6,211
Tolan Blundell
02/23/2010 01:20PM
Re: Distinct/group by, order by and filesort  
2,864
Tolan Blundell
02/24/2010 04:50AM
Re: Distinct/group by, order by and filesort  
2,611
Rick James
02/25/2010 10:39AM
Re: Distinct/group by, order by and filesort  
2,529
Tolan Blundell
02/25/2010 11:54AM
Re: Distinct/group by, order by and filesort  
2,448
Rick James
02/25/2010 01:34PM
Can this be optimized any futher?  
2,830
Rob Strong
02/16/2010 02:44PM
Re: Can this be optimized any futher?  
1,587
Rick James
02/20/2010 11:26PM
Major MySQL problems  
5,355
Paul Coulter
02/10/2010 04:26AM
Re: Major MySQL problems  
2,728
Rick James
02/11/2010 10:45PM
Re: Major MySQL problems  
2,567
Paul Coulter
02/12/2010 07:17AM
Re: Major MySQL problems  
2,073
Rick James
02/12/2010 11:04AM
How to list data effectively  
3,127
sricharan vemuri
02/10/2010 09:55AM
Re: How to list data effectively  
1,656
Rick James
02/11/2010 10:56PM
Re: How to list data effectively  
1,633
sricharan vemuri
02/12/2010 08:21AM
query optimisation  
2,515
Daniel Kirk
02/10/2010 08:08AM
Re: query optimisation  
1,569
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.