MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Shell for VS Code 1.17.1 has been released 11/05/2024 10:26PM
•   Announcing October 2024 Releases featuring MySQL Server 9.1.0 Innovation, 8.4.3 LTS and 8.0.40 10/16/2024 11:48AM

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

Subject
Views
Written By
Posted
Question on bad execution plan  
4,544
Zw Zhu
06/16/2010 07:36AM
Re: Question on bad execution plan  
1,875
Rick James
06/17/2010 09:29AM
Re: Question on bad execution plan  
1,616
noicy seal
06/21/2010 09:24AM
Re: Question on bad execution plan  
1,759
Rick James
06/21/2010 06:47PM
Re: Question on bad execution plan  
1,824
noicy seal
06/22/2010 07:33AM
Re: Question on bad execution plan  
1,850
Rick James
06/22/2010 09:09AM
Re: Question on bad execution plan  
1,718
noicy seal
06/23/2010 07:44AM
Re: Question on bad execution plan  
1,824
Zw Zhu
06/24/2010 12:17AM
Re: Question on bad execution plan  
1,841
Rick James
06/24/2010 09:17PM
Re: Question on bad execution plan  
1,683
Zw Zhu
06/28/2010 02:39AM
Re: Question on bad execution plan  
1,825
Rick James
06/28/2010 08:50PM
Union of two binary Strings  
4,329
Amir Manzour
06/18/2010 10:43AM
Re: Union of two binary Strings  
2,111
Rick James
06/21/2010 06:49PM
Re: Union of two binary Strings  
1,637
Amir Manzour
06/26/2010 11:15AM
Re: Union of two binary Strings  
1,561
Rick James
06/26/2010 12:50PM
Re: Union of two binary Strings  
1,545
Amir Manzour
06/26/2010 05:40PM
Re: Union of two binary Strings  
1,464
Amir Manzour
06/26/2010 05:20PM
Re: Union of two binary Strings  
1,649
Amir Manzour
06/22/2010 09:30AM
Help  
2,569
Ami Panchal
06/24/2010 04:27AM
AUTO_INCREMENT does not work the way I want it to  
1,429
Rick James
06/26/2010 02:15PM
optimizar mysql innodb  
3,985
juan sanchez
06/24/2010 01:21AM
lock for update in Innodb  
3,471
noicy seal
06/23/2010 07:07AM
indices not used  
2,840
Martin Luy
05/25/2010 04:13AM
Re: indices not used  
1,642
Martin Luy
05/25/2010 12:07PM
Re: indices not used  
1,532
Rick James
05/27/2010 08:35PM
Re: indices not used  
1,472
Martin Luy
06/19/2010 03:35AM
Re: indices not used  
1,435
Rick James
06/21/2010 06:25PM
Re: indices not used  
1,370
Martin Luy
06/22/2010 01:15AM
Recurring expressions  
2,481
Johannes Gerer
05/27/2010 03:37PM
Re: Recurring expressions  
1,410
Rick James
05/28/2010 08:32PM
Execution plan changes back and forth  
3,042
John Scott
05/26/2010 02:46PM
Re: Execution plan changes back and forth  
1,690
Rick James
05/27/2010 08:26PM
COUNT(1) very slow why?  
3,390
fabio rossi
05/18/2010 02:56AM
Re: COUNT(1) very slow why?  
1,624
Rick James
05/20/2010 09:21PM
Query Optimization  
3,165
Alessandro De Lorenzi
05/18/2010 07:43AM
Re: Query Optimization  
1,548
Rick James
05/20/2010 09:19PM
ORDER BY and join: include columns that don't matter?  
2,645
Chris Hennick
05/11/2010 02:54AM
Re: ORDER BY and join: include columns that don't matter?  
1,636
Rick James
05/12/2010 08:04AM
Help with ORDER BY with LIMIT  
5,300
Lukas Pilny
05/09/2010 02:24PM
Re: Help with ORDER BY with LIMIT  
2,543
Rick James
05/10/2010 10:59PM
Re: Help with ORDER BY with LIMIT  
2,073
Lukas Pilny
05/11/2010 06:05AM
table_cache not getting read  
2,752
Douglas Ferguson
05/07/2010 01:08AM
Re: table_cache not getting read  
1,681
Rick James
05/10/2010 11:19PM
UDF is no longer optimal  
2,324
Chris Canipe
05/10/2010 02:07PM
Re: UDF is no longer optimal  
1,505
Chris Canipe
05/10/2010 03:15PM
Composite Primary Key  
4,641
Gaurav Sharma
04/27/2010 05:30AM
Re: Composite Primary Key  
1,905
Rick James
04/29/2010 11:19PM
Help with Explain Plan  
2,828
Corey Samuels
04/20/2010 10:02AM
Re: Help with Explain Plan  
1,632
Rick James
04/24/2010 02:36PM
Re: Help with Explain Plan  
1,734
Corey Samuels
04/27/2010 12:44PM
Re: Help with Explain Plan  
1,383
Rick James
04/29/2010 09:17PM
Re: Help with Explain Plan  
1,775
Corey Samuels
04/22/2010 09:53AM
help, optmization... 6 tables... 1 select!  
2,649
John Aust
04/27/2010 06:59AM
URGENT: MySQL don't get enough CPU  
2,404
Robert Garrido
04/21/2010 03:38AM
Re: URGENT: MySQL don't get enough CPU  
1,453
Rick James
04/24/2010 03:14PM
partition question  
2,667
h ch
04/14/2010 02:15AM
Re: partition question  
1,555
Rick James
04/18/2010 01:36AM
why can character set of string literal cause different optimazation?  
2,140
Jerry Roletter
04/15/2010 04:27PM
How can I optimize this query?  
5,344
Martin Schiff
03/12/2010 02:40PM
Re: How can I optimize this query?  
1,879
Martin Schiff
03/16/2010 01:59PM
Re: How can I optimize this query?  
1,882
Rick James
03/27/2010 03:36PM
Re: How can I optimize this query?  
1,643
Martin Schiff
04/14/2010 07:21AM
Re: How can I optimize this query?  
2,359
Rick James
03/13/2010 04:07PM
Re: How can I optimize this query?  
1,855
Martin Schiff
03/16/2010 09:40AM
Re: How can I optimize this query?  
1,863
Martin Schiff
03/16/2010 08:21AM
Re: How can I optimize this query?  
1,862
Martin Schiff
03/16/2010 08:16AM
Re: How can I optimize this query?  
1,826
Martin Schiff
03/16/2010 08:16AM
Re: How can I optimize this query?  
1,949
Martin Schiff
03/16/2010 07:58AM
Re: IP range optimization  
1,787
Rick James
03/13/2010 04:17PM
Re: IP range optimization  
1,946
Martin Schiff
03/16/2010 08:22AM
Re: IP range optimization  
2,417
pavel iliev
04/14/2010 02:27AM
still the trigger problem  
3,199
h ch
04/07/2010 03:11AM
Re: still the trigger problem  
1,470
h ch
04/07/2010 06:43PM
Re: still the trigger problem  
1,497
Rick James
04/10/2010 01:10AM
Re: still the trigger problem  
1,619
h ch
04/09/2010 06:39PM
Really slow query with dependent subquery  
3,730
Ivo H
04/07/2010 04:12AM
Re: Really slow query with dependent subquery  
1,895
Ivo H
04/07/2010 05:53AM
Not equal operation can benefit from hash index?  
4,526
h ch
04/05/2010 08:45PM
Re: Not equal operation can benefit from hash index?  
1,983
Rick James
04/06/2010 09:53PM
Optimizer struggling with smaller dataset  
2,467
Damian Harvey
03/31/2010 09:09PM
Re: Optimizer struggling with smaller dataset  
1,462
Rick James
04/02/2010 11:19PM
how can i get the query execute time ?  
2,258
h ch
04/01/2010 02:01AM
group by date(indexed datetime) hard to optimize  
7,810
Lee Marshall
03/30/2010 12:37AM
Re: group by date(indexed datetime) hard to optimize  
2,726
Rick James
03/31/2010 10:58PM
Why filtering, ordering and limiting does not use index?  
3,064
Marc Canaleta
03/30/2010 07:26AM
Re: Why filtering, ordering and limiting does not use index?  
1,581
Rick James
03/31/2010 10:44PM
slave low speed in replication  
3,134
h ch
03/29/2010 01:02AM
Re: slave low speed in replication  
1,826
Rick James
03/30/2010 08:28AM
Re: slave low speed in replication  
1,765
h ch
03/30/2010 06:43PM
Re: slave low speed in replication  
1,469
Rick James
03/30/2010 09:48PM
Re: slave low speed in replication  
1,648
h ch
03/31/2010 01:05AM
Error when using Indexing hint  
3,047
Susi P
03/28/2010 04:11AM
Re: Error when using Indexing hint  
1,550
Rick James
03/28/2010 10:53PM
execute select took 8 min  
2,631
h ch
03/26/2010 12:31AM
Re: execute select took 8 min  
1,447
h ch
03/26/2010 01:51AM
Re: execute select took 8 min  
1,434
h ch
03/26/2010 02:24AM
Projection of a WHERE attribute  
7,196
brice chardin
03/16/2010 12:03PM
Re: Projection of a WHERE attribute  
2,207
brice chardin
03/18/2010 04:15AM
Re: Projection of a WHERE attribute  
1,826
Rick James
03/19/2010 07:37AM
Re: Projection of a WHERE attribute  
2,107
brice chardin
03/19/2010 10:06AM
Problems with query not using expeced indexes  
4,419
Lars Olesen
03/09/2010 07:12AM
Re: Problems with query not using expeced indexes  
1,827
Rick James
03/10/2010 10:28PM
Re: Problems with query not using expeced indexes  
1,656
Lars Olesen
03/11/2010 06:08AM
Re: Problems with query not using expeced indexes  
1,658
Rick James
03/11/2010 11:00PM
Re: Problems with query not using expeced indexes  
1,717
Lars Olesen
03/17/2010 12:16PM
Re: Problems with query not using expeced indexes  
1,813
Rick James
03/17/2010 09:57PM
Re: Problems with query not using expeced indexes  
1,534
Lars Olesen
03/18/2010 01:06AM
Re: Problems with query not using expeced indexes  
1,912
Rick James
03/18/2010 07:41AM
Re: Problems with query not using expeced indexes  
1,637
Lars Olesen
03/09/2010 07:13AM
union, where and indices  
9,479
Mattia Belletti
03/12/2010 09:21AM
Re: union, where and indices  
2,250
Rick James
03/13/2010 11:46AM
query optimization  
2,505
amol deshpande
03/12/2010 06:12AM
Re: query optimization  
1,574
Rick James
03/13/2010 09:11AM
Close to a million records & query too slow  
6,228
sabelo simelane
03/03/2010 01:49PM
Re: Close to a million records & query too slow  
2,455
Rick James
03/04/2010 10:09PM
Re: Close to a million records & query too slow  
2,251
sabelo simelane
03/08/2010 03:36PM
Re: Close to a million records & query too slow  
1,903
sabelo simelane
03/08/2010 04:12PM
Re: Close to a million records & query too slow  
2,286
Rick James
03/09/2010 09:20PM
Re: Close to a million records & query too slow  
1,935
sabelo simelane
03/11/2010 01:47AM
table/query help  
3,308
a g
03/03/2010 12:36PM
Re: table/query help  
1,701
Rick James
03/04/2010 10:22PM
How to get rid of 'filesort'?  
3,843
Ruslan Osmanov
02/28/2010 08:51AM
Re: How to get rid of 'filesort'?  
1,875
Rick James
03/01/2010 04:51PM
Re: How to get rid of 'filesort'?  
1,727
Ruslan Osmanov
03/01/2010 10:03PM
Re: How to get rid of 'filesort'?  
2,002
Rick James
03/01/2010 11:27PM
Re: How to get rid of 'filesort'?  
1,829
Ruslan Osmanov
03/02/2010 02:34AM
Re: How to get rid of 'filesort'?  
1,676
Rick James
03/02/2010 04:56PM
Is it possible to avoid "Using temporary" when distinct is used with join?  
3,708
Wai Yip Lau
02/25/2010 06:33PM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
1,779
Rick James
02/26/2010 09:03PM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
2,163
Wai Yip Lau
03/02/2010 09:50AM
Re: Is it possible to avoid "Using temporary" when distinct is used with join?  
1,906
Rick James
03/02/2010 02:36PM
Slow search on one table, many where, order by and limit  
4,148
Yair P
02/07/2010 07:34AM
Re: Slow search on one table, many where, order by and limit  
2,046
Rick James
02/11/2010 01:30AM
Re: Slow search on one table, many where, order by and limit  
2,014
Yair P
02/26/2010 11:27AM
Re: Slow search on one table, many where, order by and limit  
1,933
Rick James
02/26/2010 12:40PM
Re: Slow search on one table, many where, order by and limit  
2,146
Yair P
02/26/2010 02:02PM
Re: Slow search on one table, many where, order by and limit  
1,814
Rick James
02/26/2010 07:40PM
Re: Slow search on one table, many where, order by and limit  
2,948
Yair P
03/01/2010 03:33AM
Re: Slow search on one table, many where, order by and limit  
2,026
Rick James
03/01/2010 01:50PM
Query that returns indexed fields involves FILESORT, why?  
4,455
Yurij Zagrebnoy
02/26/2010 12:36PM
Re: Query that returns indexed fields involves FILESORT, why?  
2,260
Rick James
02/28/2010 01:36PM
Re: Query that returns indexed fields involves FILESORT, why?  
1,988
Yurij Zagrebnoy
03/01/2010 08:28AM
Re: Query that returns indexed fields involves FILESORT, why?  
2,113
Rick James
03/01/2010 01:16PM
aggregation in mysql  
2,885
luca ghionna
02/27/2010 11:05AM
Re: aggregation in mysql  
1,691
Rick James
02/28/2010 01:48PM
Re: aggregation in mysql  
2,168
luca ghionna
02/28/2010 02:21PM
INNER JOIN optimization  
13,219
Irfan Ali
02/22/2010 12:52AM
Re: INNER JOIN optimization  
3,888
Rick James
02/23/2010 11:44PM
Re: INNER JOIN optimization  
3,498
Irfan Ali
02/27/2010 01:36PM
Re: INNER JOIN optimization  
3,078
Rick James
02/28/2010 11:20AM
aggregation in mysql  
3,108
luca ghionna
02/27/2010 11:03AM
How to improve mysql when the table is larger than 4G  
3,625
Zhiyi Zhao
02/25/2010 08:19PM
Re: How to improve mysql when the table is larger than 4G  
1,731
Rick James
02/26/2010 11:37AM
Distinct/group by, order by and filesort  
5,832
Tolan Blundell
02/23/2010 01:20PM
Re: Distinct/group by, order by and filesort  
2,738
Tolan Blundell
02/24/2010 04:50AM
Re: Distinct/group by, order by and filesort  
2,470
Rick James
02/25/2010 10:39AM
Re: Distinct/group by, order by and filesort  
2,321
Tolan Blundell
02/25/2010 11:54AM
Re: Distinct/group by, order by and filesort  
2,263
Rick James
02/25/2010 01:34PM
Can this be optimized any futher?  
2,615
Rob Strong
02/16/2010 02:44PM
Re: Can this be optimized any futher?  
1,458
Rick James
02/20/2010 11:26PM
Major MySQL problems  
5,087
Paul Coulter
02/10/2010 04:26AM
Re: Major MySQL problems  
2,612
Rick James
02/11/2010 10:45PM
Re: Major MySQL problems  
2,431
Paul Coulter
02/12/2010 07:17AM
Re: Major MySQL problems  
1,950
Rick James
02/12/2010 11:04AM
How to list data effectively  
2,911
sricharan vemuri
02/10/2010 09:55AM
Re: How to list data effectively  
1,499
Rick James
02/11/2010 10:56PM
Re: How to list data effectively  
1,515
sricharan vemuri
02/12/2010 08:21AM
query optimisation  
2,295
Daniel Kirk
02/10/2010 08:08AM
Re: query optimisation  
1,467
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.