MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Cluster 7.3.30 has been released 07/14/2020 12:50PM

Advanced Search
New Topic
Pages:
« 1 2 3 4 5
...
19 »

Subject
Views
Written By
Posted
Optimizer executes inperformant subquery first  
3,182
Martin Kirchner
12/06/2013 07:12AM
Re: Optimizer executes inperformant subquery first  
1,257
Rick James
12/07/2013 02:30PM
Re: Optimizer executes inperformant subquery first  
1,486
Martin Kirchner
12/07/2013 03:49PM
Re: Optimizer executes inperformant subquery first  
1,577
Øystein Grøvlen
12/09/2013 09:48AM
Re: Optimizer executes inperformant subquery first  
1,454
Martin Kirchner
12/18/2013 03:04AM
Re: Optimizer executes inperformant subquery first  
1,280
Øystein Grøvlen
12/19/2013 02:45AM
Re: Optimizer executes inperformant subquery first  
1,212
Martin Kirchner
12/20/2013 02:24AM
Re: Optimizer executes inperformant subquery first  
1,164
Øystein Grøvlen
12/23/2013 08:07AM
Re: Optimizer executes inperformant subquery first  
1,155
Rick James
12/23/2013 01:11PM
Re: Optimizer executes inperformant subquery first  
1,267
Martin Kirchner
12/18/2013 05:16AM
Re: Optimizer executes inperformant subquery first  
1,299
Rick James
12/18/2013 06:49PM
Re: Optimizer executes inperformant subquery first  
1,224
Øystein Grøvlen
12/19/2013 02:49AM
my.cnf  
2,143
Juan Medina
10/27/2013 02:08PM
Re: my.cnf  
1,070
Rick James
10/29/2013 07:12PM
my.cnf optimization please help  
3,524
Ivan Kratunkov
10/28/2013 03:39AM
Re: my.cnf optimization please help  
1,245
Rick James
10/29/2013 07:10PM
MySQL Optimizer: Features in MySQL 5.7  
1,812
Edwin Desouza
10/18/2013 09:33AM
I need help in optimzing a order by clause in a join query  
2,050
George Maharis
10/08/2013 12:09PM
Re: I need help in optimzing a order by clause in a join query  
1,105
Rick James
10/10/2013 09:34PM
Re: I need help in optimzing a order by clause in a join query  
1,078
George Maharis
10/12/2013 02:07PM
Re: I need help in optimzing a order by clause in a join query  
1,103
Rick James
10/16/2013 08:36PM
MySQL My.cnf Config Help  
2,283
Mathieu Louis
10/03/2013 09:32PM
Very slow dependent subquery  
2,350
patrick canarelli
09/18/2013 03:06AM
Re: Very slow dependent subquery  
1,416
Øystein Grøvlen
09/18/2013 07:06AM
Re: Very slow dependent subquery  
1,347
patrick canarelli
09/18/2013 07:51AM
Re: Very slow dependent subquery  
1,313
Øystein Grøvlen
09/18/2013 02:57PM
Re: Very slow dependent subquery  
1,239
Peter Brawley
09/18/2013 02:13PM
Re: Very slow dependent subquery  
1,166
patrick canarelli
09/18/2013 03:10PM
Re: Very slow dependent subquery  
1,181
Rick James
09/24/2013 10:04PM
Re: Very slow dependent subquery  
1,492
patrick canarelli
09/25/2013 12:53AM
big database +1 million rows/days  
2,746
khaoula el hammoumi
09/11/2013 04:06AM
Re: big database +1 million rows/days  
1,131
khaoula el hammoumi
09/12/2013 01:37AM
Re: big database +1 million rows/days  
1,121
Rick James
09/13/2013 10:59PM
Optimize query join with 25,000 records  
2,225
Andrea Presazzi
08/26/2013 02:27AM
Re: Optimize query join with 25,000 records  
1,108
Rick James
08/31/2013 04:19PM
Index not used for JOIN on compound key plus WHERE range filter  
3,436
Chad B
08/15/2013 09:24AM
Re: Index not used for JOIN on compound key plus WHERE range filter  
1,577
Chad B
08/15/2013 10:44AM
Re: Index not used for JOIN on compound key plus WHERE range filter  
1,330
Rick James
08/31/2013 04:13PM
query index not used  
1,777
Adrian Petre
08/15/2013 05:23AM
Re: query index not used  
999
Rick James
08/31/2013 03:41PM
optimize request with order by and limit  
2,443
yassine laouija
07/18/2013 05:26AM
Re: optimize request with order by and limit  
1,290
Rick James
07/20/2013 10:25PM
Re: optimize request with order by and limit  
1,090
yassine laouija
07/22/2013 09:46AM
Re: optimize request with order by and limit  
1,048
Rick James
07/23/2013 08:58AM
Re: optimize request with order by and limit  
1,084
yassine laouija
07/26/2013 04:07AM
Re: optimize request with order by and limit  
1,099
Rick James
07/26/2013 11:53PM
Re: optimize request with order by and limit  
1,185
yassine laouija
07/29/2013 04:40AM
Re: optimize request with order by and limit  
1,095
Rick James
08/01/2013 10:39PM
providing a single line for multiple records from a table  
1,997
raja chacham
07/23/2013 09:56AM
Re: providing a single line for multiple records from a table  
980
Rick James
07/24/2013 09:08AM
Optimize Inner Join With WHERE BETWEEN dates  
3,596
Anthony Galano
05/21/2013 07:32PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,522
Rick James
05/22/2013 06:41PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,474
Anthony Galano
05/24/2013 12:40PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,331
Rick James
05/25/2013 11:43AM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,328
Anthony Galano
05/30/2013 05:30PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,299
Rick James
06/02/2013 01:15PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
1,471
Anthony Galano
06/03/2013 05:02PM
Re: Optimize Inner Join With WHERE BETWEEN dates  
2,633
Rick James
06/04/2013 11:49PM
Query optimization  
2,480
Jan Kowalski
05/10/2013 05:35AM
Re: Query optimization  
1,217
Rick James
05/12/2013 08:42PM
Re: Query optimization  
1,177
Jan Kowalski
05/15/2013 06:45AM
Re: Query optimization  
1,186
Jan Kowalski
05/15/2013 08:35AM
Re: Query optimization  
1,298
Rick James
05/16/2013 08:18AM
Re: Query optimization  
1,215
Jan Kowalski
05/17/2013 03:52AM
Re: Query optimization  
1,187
Rick James
05/17/2013 11:47PM
Re: Query optimization  
1,096
Jan Kowalski
05/21/2013 08:51AM
Re: Query optimization  
1,187
Jan Kowalski
05/22/2013 08:08AM
MySQL Optimizer: When is a Subquery Executed?  
1,851
Edwin Desouza
05/02/2013 10:05AM
Index optimized left join with group by  
3,015
Michal Kurgan
03/11/2013 05:41PM
Re: Index optimized left join with group by  
1,192
Øystein Grøvlen
03/12/2013 04:16AM
Select last row that is less than or equal to a date  
6,307
David Marcus
01/23/2013 06:35PM
Re: Select last row that is less than or equal to a date  
1,781
Rick James
01/24/2013 10:27PM
Re: Select last row that is less than or equal to a date  
1,813
David Marcus
01/26/2013 09:35AM
Re: Select last row that is less than or equal to a date  
1,597
Rick James
01/27/2013 10:19AM
Re: Select last row that is less than or equal to a date  
1,754
David Marcus
01/27/2013 12:00PM
Re: Select last row that is less than or equal to a date  
1,512
Rick James
01/29/2013 12:51AM
Re: Select last row that is less than or equal to a date  
1,547
David Marcus
01/29/2013 06:28PM
Re: Select last row that is less than or equal to a date  
1,977
Øystein Grøvlen
01/30/2013 04:50AM
Re: Select last row that is less than or equal to a date  
1,513
David Marcus
01/30/2013 05:50PM
Re: Select last row that is less than or equal to a date  
1,451
Øystein Grøvlen
02/01/2013 06:03AM
Re: Select last row that is less than or equal to a date  
1,546
David Marcus
02/02/2013 07:14AM
Re: Select last row that is less than or equal to a date  
1,460
Øystein Grøvlen
02/02/2013 01:49PM
Re: Select last row that is less than or equal to a date  
1,488
David Marcus
02/02/2013 02:25PM
Re: Select last row that is less than or equal to a date  
1,386
Øystein Grøvlen
02/03/2013 05:58AM
Re: Select last row that is less than or equal to a date  
1,405
David Marcus
02/03/2013 10:04AM
Re: Select last row that is less than or equal to a date  
1,479
Rick James
02/03/2013 10:43AM
Re: Select last row that is less than or equal to a date  
2,010
David Marcus
02/03/2013 12:33PM
Re: Select last row that is less than or equal to a date  
1,480
Rick James
02/03/2013 02:59PM
Re: Select last row that is less than or equal to a date  
1,583
David Marcus
02/03/2013 03:35PM
Re: Select last row that is less than or equal to a date  
1,491
Rick James
02/03/2013 04:02PM
Re: Select last row that is less than or equal to a date  
1,524
David Marcus
02/03/2013 04:15PM
Very slow query, help please  
2,568
Jaume Roca
01/29/2013 10:18AM
Re: Very slow query, help please  
1,401
Øystein Grøvlen
01/30/2013 05:12AM
Re: Very slow query, help please  
1,351
Rick James
01/30/2013 08:38AM
Re: Very slow query, help please  
1,390
Jaume Roca
01/30/2013 09:05AM
MySQL 5.6: IN Subqueries Are Optimized away  
1,890
Edwin Desouza
01/29/2013 01:08PM
CPU load very very high !!!!, Please assist !!  
8,039
Sayed Ali
01/22/2013 06:49AM
Re: CPU load very very high !!!!, Please assist !!  
2,846
Rick James
01/22/2013 11:32PM
New EXPLAIN Features in MySQL 5.6 – FORMAT=JSON actually adds more information!  
2,014
Edwin Desouza
01/22/2013 05:58PM
Can we expect an enhancement for derived table merge optimization?  
3,618
Michael Hogue
01/04/2013 12:04PM
Re: Can we expect an enhancement for derived table merge optimization?  
1,450
Rick James
01/07/2013 10:50PM
Re: Can we expect an enhancement for derived table merge optimization?  
1,857
Roy Lyseng
01/11/2013 09:18AM
Re: Can we expect an enhancement for derived table merge optimization?  
1,289
Rick James
01/13/2013 12:24PM
Re: Can we expect an enhancement for derived table merge optimization?  
1,452
Roy Lyseng
01/14/2013 08:43AM
Re: Can we expect an enhancement for derived table merge optimization?  
1,265
Rick James
01/14/2013 09:54AM
Re: Can we expect an enhancement for derived table merge optimization?  
1,367
Roy Lyseng
01/15/2013 06:15AM
Re: Can we expect an enhancement for derived table merge optimization?  
1,279
Roy Lyseng
01/11/2013 08:51AM
How to best optimize MYSQL Database  
2,295
Muhammad Usman
12/10/2012 03:45AM
Re: How to best optimize MYSQL Database  
1,241
Rick James
12/21/2012 12:49PM
mysql subquery query optimization question  
2,560
Yong Yim
01/12/2013 09:24AM
Re: mysql subquery query optimization question  
1,172
Rick James
01/13/2013 11:30AM
Create a New Datatype  
2,232
Andy Gurzynski
01/06/2013 01:00AM
Re: Create a New Datatype  
1,108
Rick James
01/07/2013 11:01PM
MySQL Optimizer: InnoDB extended secondary keys  
2,236
Edwin Desouza
12/21/2012 12:12PM
Optimizer for innodb does not reduce "data_free"  
4,190
Sebastian Schött
12/06/2012 03:39AM
Re: Optimizer for innodb does not reduce "data_free"  
1,623
Rick James
12/08/2012 01:33PM
Complex query - need advise  
2,584
chris boer
11/03/2012 04:16PM
Re: Complex query - need advise  
1,281
chris boer
11/03/2012 04:24PM
Re: Complex query - need advise  
1,253
chris boer
11/04/2012 10:05AM
Re: Complex query - need advise  
1,559
Rick James
11/05/2012 11:12AM
Follow up on "Query Execution Plan"  
2,188
Chris Slominski
10/24/2012 11:59AM
Re: Follow up on "Query Execution Plan"  
1,221
Chris Slominski
10/25/2012 11:14AM
Re: Follow up on "Query Execution Plan"  
1,070
Chris Slominski
10/25/2012 06:15AM
JOIN query too slow  
2,254
N. Kovac
10/13/2012 11:52AM
Re: JOIN query too slow  
1,112
Peter Brawley
10/14/2012 10:26AM
Re: JOIN query too slow  
1,172
Rick James
10/16/2012 07:48PM
bulk update very slow  
4,633
james che
09/25/2012 02:51PM
Re: bulk update very slow  
1,769
james che
09/26/2012 02:58PM
Re: bulk update very slow  
1,794
Rick James
09/27/2012 08:19PM
Re: bulk update very slow  
2,643
Jørgen Løland
09/27/2012 12:01PM
Why Query Cache Actived Returns Wrong Results?  
2,616
Daniel Estrada
09/22/2012 08:57PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,417
Rick James
09/23/2012 03:46PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,375
Daniel Estrada
09/23/2012 08:24PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,104
Rick James
09/24/2012 11:43PM
Join? Union? I am so lost.  
2,090
Hank Reardon
09/17/2012 09:09AM
Re: Join? Union? I am so lost.  
1,099
Rick James
09/18/2012 07:48AM
How make indexes work with group by statement  
2,045
Adnan Raza
09/13/2012 12:48AM
Re: How make indexes work with group by statement  
1,161
Rick James
09/15/2012 10:34PM
Re: How make indexes work with group by statement  
1,212
Jørgen Løland
09/13/2012 01:50AM
Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
2,447
Dominik Bieringer
09/05/2012 02:57AM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
1,110
Rick James
09/06/2012 10:42PM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
1,207
Øystein Grøvlen
09/06/2012 04:32AM
optimize the query  
2,205
ch srinivas
08/27/2012 10:47PM
Re: optimize the query  
1,141
Øystein Grøvlen
08/28/2012 01:43AM
Re: optimize the query  
1,037
ch srinivas
08/29/2012 04:15AM
Re: optimize the query  
1,104
Øystein Grøvlen
08/29/2012 04:39AM
Re: optimize the query  
1,014
ch srinivas
08/29/2012 05:38AM
Re: optimize the query  
1,075
Rick James
08/30/2012 07:20AM
Query with GROUP BY not using Index  
2,633
Imran Akbar
08/14/2012 01:06PM
Re: Query with GROUP BY not using Index  
1,268
Øystein Grøvlen
08/15/2012 02:46AM
Re: Query with GROUP BY not using Index  
1,197
Imran Akbar
08/16/2012 10:30AM
Re: Query with GROUP BY not using Index  
1,446
Øystein Grøvlen
08/17/2012 02:58AM
Re: Query with GROUP BY not using Index  
1,213
Rick James
08/18/2012 10:30PM
Re: Query with GROUP BY not using Index  
1,150
Imran Akbar
08/24/2012 12:41PM
Re: Query with GROUP BY not using Index  
1,230
Øystein Grøvlen
08/28/2012 03:11AM
Re: Query with GROUP BY not using Index  
1,274
Imran Akbar
08/28/2012 06:21PM
Re: Query with GROUP BY not using Index  
1,622
Øystein Grøvlen
08/29/2012 01:28AM
Re: Query with GROUP BY not using Index  
1,119
Imran Akbar
08/29/2012 10:36AM
CONCAT and Index in where clause  
13,987
Aurelien PANIZZA
08/22/2012 08:45AM
Re: CONCAT and Index in where clause  
4,912
Øystein Grøvlen
08/23/2012 01:15AM
Re: CONCAT and Index in where clause  
3,806
Rick James
08/23/2012 09:13PM
Re: CONCAT and Index in where clause  
3,830
Aurelien PANIZZA
08/27/2012 09:53AM
Re: CONCAT and Index in where clause  
3,801
Øystein Grøvlen
08/28/2012 02:50AM
Simple query spending too much time in 'statistics' state without reason  
11,549
Vincent B.
08/21/2012 06:19AM
Re: Simple query spending too much time in 'statistics' state without reason  
6,158
Jørgen Løland
08/24/2012 06:24AM
Re: Simple query spending too much time in 'statistics' state without reason  
4,463
Vincent B.
08/28/2012 01:53AM
Re: Simple query spending too much time in 'statistics' state without reason  
5,778
Rick James
08/22/2012 07:44PM
Order By Slows down Joins  
3,366
Sami BH
08/22/2012 09:12AM
Re: Order By Slows down Joins  
1,020
Rick James
08/23/2012 08:56PM
always uses filesort even after adding indexes  
2,313
Pranav Gore
08/22/2012 02:49AM
Re: always uses filesort even after adding indexes  
1,111
Rick James
08/22/2012 10:52PM
STRAIGHT_JOIN for OUTER JOINGS  
3,338
Paul Tsui
08/19/2012 08:28PM
Re: STRAIGHT_JOIN for OUTER JOINGS  
1,527
Øystein Grøvlen
08/20/2012 05:16AM
CPU usage 99% - and query very slow - help  
4,357
irox ferenc
08/03/2012 10:49AM
Re: CPU usage 99% - and query very slow - help  
1,768
Rick James
08/04/2012 01:36PM
Re: CPU usage 99% - and query very slow - help  
2,470
robert eeeeee
08/06/2012 01:04PM
Re: CPU usage 99% - and query very slow - help  
1,805
Øystein Grøvlen
08/15/2012 03:09AM
Execution plan: wrong index selected, very poor performance.  
3,951
Andrej Andrejevic
07/18/2012 10:31AM
Re: Execution plan: wrong index selected, very poor performance.  
1,590
Rick James
07/19/2012 10:07PM
Re: Execution plan: wrong index selected, very poor performance.  
1,407
Andrej Andrejevic
07/20/2012 01:38AM
Re: Execution plan: wrong index selected, very poor performance.  
1,218
Andrej Andrejevic
07/24/2012 04:27AM
Re: Execution plan: wrong index selected, very poor performance.  
1,241
Rick James
07/25/2012 12:21AM
Index for Query  
2,416
dileep ch
07/17/2012 12:41AM
Re: Index for Query  
1,220
Rick James
07/17/2012 10:36PM
Re: Index for Query  
1,238
dileep ch
07/18/2012 11:52PM
Re: Index for Query  
1,872
Rick James
07/19/2012 09:49PM
best way to optimize this query  
2,525
Jap bn
07/14/2012 09:54AM
Re: best way to optimize this query  
1,475
Rick James
07/15/2012 10:11PM
Optimizer being overly aggressive  
2,421
Adrian Cornish
07/06/2012 08:18PM
Re: Optimizer being overly aggressive  
1,245
Rick James
07/10/2012 12:49PM
Re: Optimizer being overly aggressive  
1,236
Adrian Cornish
07/10/2012 08:54PM
multiple-column index and order by  
2,681
Raphael Hoffmann
07/06/2012 05:59PM
Re: multiple-column index and order by  
1,269
Rick James
07/10/2012 12:55PM
From Months to Seconds with Subquery Materialization  
1,878
Edwin DeSouza
07/09/2012 11:15AM
Pages:
« 1 2 3 4 5
...
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.