MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing April 2025 Releases featuring MySQL Server 9.3.0 Innovation, 8.4.5 LTS and 8.0.42 04/16/2025 12:35PM

Advanced Search
New Topic
Pages:
« 1
...
4 5 6 7 8
...
19 »

Subject
Views
Written By
Posted
Queries using JOIN and ORDER BY LIMIT  
20,124
Nikita Dubrovsky
03/10/2012 01:11PM
Re: Queries using JOIN and ORDER BY LIMIT  
2,823
irek kordirko
03/12/2012 06:18PM
Re: Queries using JOIN and ORDER BY LIMIT  
2,674
Rick James
03/13/2012 11:07PM
Re: Queries using JOIN and ORDER BY LIMIT  
2,667
Nikita Dubrovsky
03/14/2012 08:45AM
Re: Queries using JOIN and ORDER BY LIMIT  
2,627
Rick James
03/15/2012 10:50AM
Obfuscate Functions and Procedures  
2,250
Tremal Naik
03/12/2012 05:00AM
Re: Obfuscate Functions and Procedures  
1,547
Rick James
03/13/2012 10:46PM
Group by not using index  
2,570
Matthew Moles
03/02/2012 10:06AM
Re: Group by not using index  
1,319
Rick James
03/04/2012 10:59PM
Re: Group by not using index  
1,226
Matthew Moles
03/05/2012 03:57AM
Re: Group by not using index  
1,171
irek kordirko
03/03/2012 05:22PM
Optimizing query  
2,257
Marko Kupusic
02/24/2012 06:07AM
Re: Optimizing query  
1,223
Rick James
02/25/2012 05:54PM
Re: Optimizing query  
1,159
Marko Kupusic
02/27/2012 06:04AM
Re: Optimizing query  
1,240
Rick James
02/28/2012 07:57PM
Re: Optimizing query  
1,144
Ole John Aske
02/25/2012 03:49AM
Re: Optimizing query  
1,491
Marko Kupusic
02/27/2012 05:57AM
Re: Optimizing query  
1,261
Scott Nemes
02/24/2012 01:16PM
how to optimise query for 10+ millions records  
3,024
Azhar Rahi
02/09/2012 03:30AM
Re: how to optimise query for 10+ millions records  
1,737
irek kordirko
02/09/2012 05:31AM
Re: how to optimise query for 10+ millions records  
1,399
Azhar Rahi
02/09/2012 05:38AM
Re: how to optimise query for 10+ millions records  
1,309
irek kordirko
02/09/2012 05:58PM
Re: how to optimise query for 10+ millions records  
1,281
Rick James
02/11/2012 11:26PM
Re: how to optimise query for 10+ millions records  
1,536
Azhar Rahi
02/12/2012 10:12PM
Re: how to optimise query for 10+ millions records  
1,391
irek kordirko
02/13/2012 02:18PM
Re: how to optimise query for 10+ millions records  
1,602
Azhar Rahi
02/14/2012 02:33AM
Re: how to optimise query for 10+ millions records  
1,405
irek kordirko
02/14/2012 07:24AM
Re: how to optimise query for 10+ millions records  
1,415
Rick James
02/15/2012 07:30AM
Re: how to optimise query for 10+ millions records  
1,864
Azhar Rahi
02/16/2012 03:54AM
Re: how to optimise query for 10+ millions records  
1,304
Rick James
02/17/2012 01:20AM
Re: how to optimise query for 10+ millions records  
1,261
Azhar Rahi
02/17/2012 03:57PM
Re: how to optimise query for 10+ millions records  
1,544
irek kordirko
02/17/2012 05:12PM
Re: how to optimise query for 10+ millions records  
1,347
Azhar Rahi
02/20/2012 02:21AM
Re: how to optimise query for 10+ millions records  
1,347
Rick James
02/18/2012 07:18AM
Re: how to optimise query for 10+ millions records  
1,404
Azhar Rahi
02/21/2012 03:25AM
Re: how to optimise query for 10+ millions records  
1,405
Rick James
02/24/2012 10:45AM
Join  
2,243
johne doe
02/01/2012 06:51AM
Re: Join Query Performance Problme  
1,205
Rick James
02/03/2012 10:18AM
Re: Join Query Performance Problme  
1,230
irek kordirko
02/01/2012 11:14AM
Re: Join Query Performance Problme  
1,240
johne doe
02/02/2012 12:39AM
Re: Join Query Performance Problme  
1,206
johne doe
02/02/2012 06:47AM
Re: Join Query Performance Problme  
1,250
irek kordirko
02/02/2012 07:02PM
Re: Join Query Performance Problme  
1,190
johne doe
02/03/2012 12:29AM
Re: Join Query Performance Problme  
1,444
irek kordirko
02/03/2012 11:27AM
Re: Join Query Performance Problme  
1,258
Rick James
02/04/2012 10:39AM
Re: Join Query Performance Problme  
1,389
johne doe
02/14/2012 06:08PM
Re: Join Query Performance Problme  
1,214
johne doe
02/06/2012 06:13AM
query cost calculations  
4,121
Silpa Majeti
02/11/2012 04:01AM
Re: query cost calculations  
1,485
Øystein Grøvlen
02/13/2012 07:13PM
Re: query cost calculations  
1,651
Rick James
02/12/2012 01:03PM
Strange performance results with JOIN/COUNT  
2,454
Tomas Pluskal
02/08/2012 06:25PM
Re: Strange performance results with JOIN/COUNT  
1,170
Øystein Grøvlen
02/09/2012 03:01AM
Re: Strange performance results with JOIN/COUNT  
1,550
Tomas Pluskal
02/09/2012 03:13AM
Re: Strange performance results with JOIN/COUNT  
1,477
irek kordirko
02/11/2012 02:53AM
Re: Strange performance results with JOIN/COUNT  
1,133
Tomas Pluskal
02/12/2012 06:44PM
Strange performance with JOIN/COUNT  
2,943
Tomas Pluskal
02/09/2012 12:30AM
Re: Strange performance with JOIN/COUNT  
1,231
Rick James
02/11/2012 11:11PM
Why MySQL does not use an index?  
3,029
Panayotis Matsinopoulos
01/16/2012 02:50AM
Re: Why MySQL does not use an index?  
1,387
Rick James
01/19/2012 12:25AM
Re: Why MySQL does not use an index?  
1,469
Panayotis Matsinopoulos
02/10/2012 01:21AM
Re: Why MySQL does not use an index?  
1,389
Rick James
02/11/2012 10:48PM
Re: Why MySQL does not use an index?  
1,245
irek kordirko
02/10/2012 09:50AM
MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
3,046
Chris Ricks
02/02/2012 01:17AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
1,297
Chris Ricks
02/01/2012 07:33PM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
1,207
Øystein Grøvlen
02/02/2012 03:58AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
1,268
Chris Ricks
02/02/2012 04:43AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
1,206
Rick James
02/03/2012 11:57PM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)  
1,319
Chris Ricks
02/02/2012 03:06AM
running running running  
2,315
paolo tome
01/30/2012 03:16AM
Re: running running running  
1,281
Øystein Grøvlen
01/30/2012 02:39AM
Re: running running running  
1,069
paolo tome
01/30/2012 09:13AM
Re: running running running  
1,053
paolo tome
01/31/2012 05:44AM
Re: running running running  
1,158
Øystein Grøvlen
01/31/2012 07:54AM
Re: running running running  
1,295
paolo tome
01/31/2012 03:10AM
Re: running running running  
1,248
Ole John Aske
01/31/2012 05:00PM
How to avoid filesort in ORDER BY?  
4,479
Andy S
01/26/2012 10:58PM
Re: How to avoid filesort in ORDER BY?  
1,984
irek kordirko
01/27/2012 08:20AM
avoid filesort  
1,983
Magnus Larsson
01/22/2012 01:08PM
Re: avoid filesort  
1,252
Rick James
01/24/2012 01:17AM
Re: avoid filesort  
1,364
Magnus Larsson
01/24/2012 04:36PM
Re: avoid filesort  
1,266
Rick James
01/25/2012 08:26PM
Re: avoid filesort  
1,239
Magnus Larsson
01/26/2012 04:56AM
Re: avoid filesort  
1,491
irek kordirko
01/25/2012 07:24PM
Re: avoid filesort  
1,270
Magnus Larsson
01/26/2012 04:57AM
Simple 1-table query taking WAY to long.....  
1,849
Jason Moore
01/23/2012 02:31AM
Re: Simple 1-table query taking WAY to long.....  
1,167
Rick James
01/24/2012 01:09AM
want to make this query faster, but not sure how  
2,566
Luc Foisy
01/19/2012 09:55AM
Re: want to make this query faster, but not sure how  
1,325
irek kordirko
01/19/2012 05:39PM
Re: want to make this query faster, but not sure how  
1,437
Luc Foisy
01/20/2012 10:51AM
Re: want to make this query faster, but not sure how  
1,025
Luc Foisy
01/19/2012 10:12AM
Re: want to make this query faster, but not sure how  
1,020
Luc Foisy
01/19/2012 10:29AM
MySQL 5.6: Optimizer Tracing  
1,610
Edwin DeSouza
01/19/2012 12:07PM
Query no longer uses index, takes much longer to run  
2,362
Richard Cunningham
01/09/2012 12:36PM
Re: Query no longer uses index, takes much longer to run  
1,035
Jørgen Løland
01/10/2012 01:43PM
Re: Query no longer uses index, takes much longer to run  
1,102
Richard Cunningham
01/10/2012 03:54PM
Weird issue with join buffer (Performance suffers)  
2,144
Ozgur Orhan
01/10/2012 01:54AM
Re: Weird issue with join buffer (Performance suffers)  
1,614
Jørgen Løland
01/10/2012 01:37PM
Problem with a query performance  
3,245
V Pode
01/04/2012 01:43PM
Re: Problem with a query performance  
1,370
Rick James
01/05/2012 10:41AM
Re: Problem with a query performance  
1,280
V Pode
01/06/2012 12:36PM
Re: Problem with a query performance  
1,307
Rick James
01/07/2012 10:52AM
index not used when join condition added  
2,848
Daniel Walter
01/02/2012 11:55AM
Re: index not used when join condition added  
1,349
Rick James
01/03/2012 08:42PM
Re: index not used when join condition added  
1,366
Daniel Walter
01/03/2012 09:49PM
Re: index not used when join condition added  
1,770
Rick James
01/04/2012 06:26PM
Re: index not used when join condition added  
1,299
Daniel Walter
01/04/2012 07:21PM
Re: index not used when join condition added  
1,182
Rick James
01/04/2012 06:28PM
Primary key index with a DATETIME as first part of the compound key is never used  
5,642
jeremy cohen solal
12/30/2011 08:10AM
Re: Primary key index with a DATETIME as first part of the compound key is never used  
2,013
Rick James
01/02/2012 09:06PM
help me, optimize a long running query  
3,166
h ch
10/25/2011 12:00AM
Re: help me, optimize a long running query  
1,276
Massimo Brignoli
10/26/2011 06:48AM
Re: help me, optimize a long running query  
1,260
h ch
10/27/2011 12:39AM
Re: help me, optimize a long running query  
1,359
Rick James
10/27/2011 09:04PM
Re: help me, optimize a long running query  
1,638
h ch
12/26/2011 11:52PM
Re: help me, optimize a long running query  
1,128
Rick James
12/27/2011 10:00PM
SELECT counter  
2,320
Root Tr
12/17/2011 01:24PM
Re: SELECT counter  
1,124
Jørgen Løland
12/19/2011 06:57AM
Strange behavior with a strange request  
2,286
Julien Palard
12/08/2011 05:03AM
Re: Strange behavior with a strange request  
1,133
Rick James
12/10/2011 11:37PM
Re: Strange behavior with a strange request  
1,187
Julien Palard
12/12/2011 09:01AM
left outer join performance  
4,029
Michael Shavlovsky
11/28/2011 09:58PM
Re: left outer join performance  
1,518
Michael Shavlovsky
11/28/2011 11:10PM
Re: left outer join performance  
1,425
Rick James
11/29/2011 09:27PM
Join without duplicates  
4,140
Jamie M
11/28/2011 11:22AM
Re: Join without duplicates  
1,311
Jørgen Løland
11/28/2011 02:39PM
Re: Join without duplicates  
1,638
Jamie M
11/29/2011 04:19AM
Re: Join without duplicates  
1,806
Jørgen Løland
11/29/2011 02:58PM
Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?  
2,352
WeiQi Huang
11/27/2011 05:18AM
Re: Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?  
1,153
Øystein Grøvlen
11/29/2011 03:19AM
Re: Is there any way to tell the optimizer that my large, but simple-schema table are already sorted?  
1,070
Rick James
11/28/2011 11:06AM
Need to increase packet size in MySQL  
2,705
Ashvin Ravi Shankar
11/25/2011 12:08AM
Re: Need to increase packet size in MySQL  
1,361
Rick James
11/26/2011 08:53AM
Executing same query in 1 moment  
2,599
Brano Gerzo
11/19/2011 09:27AM
Re: Executing same query in 1 moment  
1,227
Rick James
11/20/2011 04:42PM
Re: Executing same query in 1 moment  
1,178
Brano Gerzo
11/21/2011 12:42AM
Re: Executing same query in 1 moment  
1,254
Brano Gerzo
11/20/2011 10:31PM
Re: Executing same query in 1 moment  
1,092
Rick James
11/22/2011 12:05AM
Slow LEFT JOIN!  
3,321
Sasha Mitich
11/18/2011 04:18AM
Re: Slow LEFT JOIN!  
1,167
Rick James
11/19/2011 12:42AM
table join optimize help!  
2,200
kelvin chou
11/14/2011 01:10AM
Re: table join optimize help!  
1,019
Rick James
11/14/2011 09:24PM
Re: table join optimize help!  
1,298
kelvin chou
11/16/2011 01:20AM
Re: table join optimize help!  
1,058
Rick James
11/16/2011 09:41PM
Re: table join optimize help!  
1,142
kelvin chou
11/18/2011 01:18AM
help~the statement don't use index  
2,329
kelvin chou
11/08/2011 01:54AM
Re: help~the statement don't use index  
1,387
Øystein Grøvlen
11/08/2011 09:31AM
Re: help~the statement don't use index  
1,098
kelvin chou
11/08/2011 09:11PM
How to optimize group by and where  
2,206
Eric Colson
11/06/2011 01:36AM
Re: How to optimize group by and where  
1,156
Jørgen Løland
11/07/2011 07:06AM
Optimize Query for ndb 7.2.1....  
2,791
Mohammed Munazir Ul Hasan
10/18/2011 01:21AM
Re: Optimize Query for ndb 7.2.1....  
1,164
Ole John Aske
10/26/2011 08:40AM
Re: Optimize Query for ndb 7.2.1....  
1,106
Massimo Brignoli
10/26/2011 06:46AM
Re: Optimize Query for ndb 7.2.1....  
996
Mat Keep
10/26/2011 03:35AM
not optimizing the table after index is created  
3,095
ragen sol
10/15/2011 04:04AM
Re: not optimizing the table after index is created  
1,599
Rick James
10/16/2011 11:02AM
Re: not optimizing the table after index is created  
1,220
ragen sol
10/18/2011 04:24AM
Re: not optimizing the table after index is created  
1,082
Rick James
10/18/2011 09:31PM
Re: not optimizing the table after index is created  
1,081
ragen sol
10/20/2011 12:10AM
Re: not optimizing the table after index is created  
1,248
Rick James
10/20/2011 09:30PM
Optimize Query  
1,820
Mohammed Munazir Ul Hasan
10/18/2011 01:25AM
Re: Optimize Query  
1,069
Øystein Grøvlen
10/20/2011 12:46AM
optimize query -- need help  
2,324
Mohammed Munazir Ul Hasan
10/15/2011 04:44AM
Re: optimize query -- need help  
1,016
Rick James
10/16/2011 10:58AM
Re: optimize query -- need help  
1,039
Mohammed Munazir Ul Hasan
10/17/2011 11:33PM
Re: optimize query -- need help  
1,024
Rick James
10/18/2011 10:42PM
Query optimization for slow query  
1,852
Mohammed Munazir Ul Hasan
10/15/2011 03:03AM
optimize query  
1,520
Mohammed Munazir Ul Hasan
10/15/2011 01:13AM
GROUP BY ,ORDER BY optimization help  
3,708
Ciobanu MArius
10/06/2011 09:31AM
Re: GROUP BY ,ORDER BY optimization help  
1,505
Rick James
10/07/2011 11:54AM
Re: GROUP BY ,ORDER BY optimization help  
1,494
Ciobanu MArius
10/08/2011 03:41AM
Re: GROUP BY ,ORDER BY optimization help  
1,664
Rick James
10/09/2011 08:58PM
Re: GROUP BY ,ORDER BY optimization help  
1,293
Ciobanu MArius
10/10/2011 09:22AM
Re: GROUP BY ,ORDER BY optimization help  
1,847
Rick James
10/11/2011 05:36PM
Re: GROUP BY ,ORDER BY optimization help  
1,113
Ciobanu MArius
10/12/2011 10:43AM
Explain plan--join type  
2,669
Amy Ng
10/05/2011 11:10PM
Re: Explain plan--join type  
1,269
Jørgen Løland
10/07/2011 12:41AM
MySQL Optimizer: new EXPLAIN for data-modifiers  
2,095
Edwin DeSouza
10/04/2011 12:54PM
MySQL Batched Key Access Speeds Up Disk-Bound Join Queries  
1,972
Edwin DeSouza
10/04/2011 10:52AM
MySQL Optimizer tracing: Query Execution Plan descriptions beyond EXPLAIN  
1,893
Edwin DeSouza
10/04/2011 08:54AM
MySQL: Killer response time for non-overlapping intervals  
1,709
Edwin DeSouza
09/27/2011 01:55PM
Mysql using 95% of cpu  
3,536
Hitesh Rank
07/21/2011 08:57AM
Re: Mysql using 95% of cpu  
1,127
Duncan Cox
09/22/2011 06:11AM
Re: Mysql using 95% of cpu  
1,410
Rick James
09/23/2011 09:14AM
Re: Mysql using 95% of cpu  
1,202
Rick James
07/22/2011 07:33PM
not able to use index, seems optimizer forces not to use index,  
2,624
yi li
09/21/2011 08:08AM
Re: not able to use index, seems optimizer forces not to use index,  
1,115
Rick James
09/22/2011 03:30PM
Re: not able to use index, seems optimizer forces not to use index,  
1,065
Øystein Grøvlen
09/22/2011 01:24AM
Query Optimisation of a slow query  
3,954
Gaurav Bhuyan
09/13/2011 03:26AM
Re: Query Optimisation of a slow query  
1,496
Rick James
09/16/2011 10:21PM
Re: Query Optimisation of a slow query  
1,193
Gaurav Bhuyan
09/20/2011 01:51AM
Re: Query Optimisation of a slow query  
1,388
Gaurav Bhuyan
09/19/2011 01:01AM
Re: Query Optimisation of a slow query  
1,293
Rick James
09/20/2011 09:20PM
Re: Query Optimisation of a slow query  
1,259
Gaurav Bhuyan
09/21/2011 02:38AM
Re: Query Optimisation of a slow query  
1,202
Rick James
09/22/2011 12:03AM
Re: Query Optimisation of a slow query  
1,210
Gaurav Bhuyan
09/21/2011 12:21AM
Close conections  
3,821
Mihai Claudiu
07/31/2011 10:16AM
Re: Close conections  
1,773
Rick James
08/08/2011 08:51AM
Re: Close conections  
1,356
Mihai Claudiu
09/17/2011 02:18PM
Re: Close conections  
1,288
Rick James
09/18/2011 12:54PM
Re: Close conections  
1,312
Mihai Claudiu
09/18/2011 02:48PM
Re: Close conections  
1,349
Rick James
09/19/2011 07:23PM
Re: Close conections  
1,192
Mihai Claudiu
09/20/2011 05:40AM
Re: Close conections  
1,469
Rick James
09/21/2011 11:37PM
Pages:
« 1
...
4 5 6 7 8
...
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.