MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing August 2026 Releases featuring MySQL Server, MySQL NDB Cluster, Shell and Connector/ODBC 08/25/2026 01:01AM

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

Subject
Views
Written By
Posted
mysql subquery query optimization question  
3,341
Yong Yim
01/12/2013 09:24AM
Re: mysql subquery query optimization question  
1,533
Rick James
01/13/2013 11:30AM
Create a New Datatype  
2,914
Andy Gurzynski
01/06/2013 01:00AM
Re: Create a New Datatype  
1,472
Rick James
01/07/2013 11:01PM
MySQL Optimizer: InnoDB extended secondary keys  
2,862
Edwin Desouza
12/21/2012 12:12PM
Optimizer for innodb does not reduce "data_free"  
5,595
Sebastian Schött
12/06/2012 03:39AM
Re: Optimizer for innodb does not reduce "data_free"  
2,083
Rick James
12/08/2012 01:33PM
Complex query - need advise  
3,359
chris boer
11/03/2012 04:16PM
Re: Complex query - need advise  
1,676
chris boer
11/03/2012 04:24PM
Re: Complex query - need advise  
1,610
chris boer
11/04/2012 10:05AM
Re: Complex query - need advise  
1,990
Rick James
11/05/2012 11:12AM
Follow up on "Query Execution Plan"  
2,863
Chris Slominski
10/24/2012 11:59AM
Re: Follow up on "Query Execution Plan"  
1,599
Chris Slominski
10/25/2012 11:14AM
Re: Follow up on "Query Execution Plan"  
1,449
Chris Slominski
10/25/2012 06:15AM
JOIN query too slow  
3,076
N. Kovac
10/13/2012 11:52AM
Re: JOIN query too slow  
1,492
Peter Brawley
10/14/2012 10:26AM
Re: JOIN query too slow  
1,562
Rick James
10/16/2012 07:48PM
bulk update very slow  
5,502
james che
09/25/2012 02:51PM
Re: bulk update very slow  
2,241
james che
09/26/2012 02:58PM
Re: bulk update very slow  
2,317
Rick James
09/27/2012 08:19PM
Re: bulk update very slow  
3,819
Jørgen Løland
09/27/2012 12:01PM
Why Query Cache Actived Returns Wrong Results?  
3,459
Daniel Estrada
09/22/2012 08:57PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,971
Rick James
09/23/2012 03:46PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,925
Daniel Estrada
09/23/2012 08:24PM
Re: Why Query Cache Actived Returns Wrong Results?  
1,493
Rick James
09/24/2012 11:43PM
Join? Union? I am so lost.  
2,868
Hank Reardon
09/17/2012 09:09AM
Re: Join? Union? I am so lost.  
1,480
Rick James
09/18/2012 07:48AM
How make indexes work with group by statement  
2,831
Adnan Raza
09/13/2012 12:48AM
Re: How make indexes work with group by statement  
1,624
Rick James
09/15/2012 10:34PM
Re: How make indexes work with group by statement  
1,608
Jørgen Løland
09/13/2012 01:50AM
Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
3,342
Dominik Bieringer
09/05/2012 02:57AM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
1,501
Rick James
09/06/2012 10:42PM
Re: Query Optimizer Problem - OrderBy - 5.0.51 to 5.5.27  
1,587
Øystein Grøvlen
09/06/2012 04:32AM
optimize the query  
2,934
ch srinivas
08/27/2012 10:47PM
Re: optimize the query  
1,501
Øystein Grøvlen
08/28/2012 01:43AM
Re: optimize the query  
1,445
ch srinivas
08/29/2012 04:15AM
Re: optimize the query  
1,564
Øystein Grøvlen
08/29/2012 04:39AM
Re: optimize the query  
1,398
ch srinivas
08/29/2012 05:38AM
Re: optimize the query  
1,487
Rick James
08/30/2012 07:20AM
Query with GROUP BY not using Index  
3,541
Imran Akbar
08/14/2012 01:06PM
Re: Query with GROUP BY not using Index  
1,860
Øystein Grøvlen
08/15/2012 02:46AM
Re: Query with GROUP BY not using Index  
1,638
Imran Akbar
08/16/2012 10:30AM
Re: Query with GROUP BY not using Index  
1,938
Øystein Grøvlen
08/17/2012 02:58AM
Re: Query with GROUP BY not using Index  
1,713
Rick James
08/18/2012 10:30PM
Re: Query with GROUP BY not using Index  
1,645
Imran Akbar
08/24/2012 12:41PM
Re: Query with GROUP BY not using Index  
1,655
Øystein Grøvlen
08/28/2012 03:11AM
Re: Query with GROUP BY not using Index  
1,743
Imran Akbar
08/28/2012 06:21PM
Re: Query with GROUP BY not using Index  
2,162
Øystein Grøvlen
08/29/2012 01:28AM
Re: Query with GROUP BY not using Index  
1,616
Imran Akbar
08/29/2012 10:36AM
CONCAT and Index in where clause  
18,408
Aurelien PANIZZA
08/22/2012 08:45AM
Re: CONCAT and Index in where clause  
5,983
Øystein Grøvlen
08/23/2012 01:15AM
Re: CONCAT and Index in where clause  
4,611
Rick James
08/23/2012 09:13PM
Re: CONCAT and Index in where clause  
4,723
Aurelien PANIZZA
08/27/2012 09:53AM
Re: CONCAT and Index in where clause  
4,784
Øystein Grøvlen
08/28/2012 02:50AM
Simple query spending too much time in 'statistics' state without reason  
12,856
Vincent B.
08/21/2012 06:19AM
Re: Simple query spending too much time in 'statistics' state without reason  
6,827
Jørgen Løland
08/24/2012 06:24AM
Re: Simple query spending too much time in 'statistics' state without reason  
5,071
Vincent B.
08/28/2012 01:53AM
Re: Simple query spending too much time in 'statistics' state without reason  
6,352
Rick James
08/22/2012 07:44PM
Order By Slows down Joins  
4,078
Sami BH
08/22/2012 09:12AM
Re: Order By Slows down Joins  
1,372
Rick James
08/23/2012 08:56PM
always uses filesort even after adding indexes  
3,371
Pranav Gore
08/22/2012 02:49AM
Re: always uses filesort even after adding indexes  
1,472
Rick James
08/22/2012 10:52PM
STRAIGHT_JOIN for OUTER JOINGS  
4,430
Paul Tsui
08/19/2012 08:28PM
Re: STRAIGHT_JOIN for OUTER JOINGS  
2,301
Øystein Grøvlen
08/20/2012 05:16AM
CPU usage 99% - and query very slow - help  
5,563
irox ferenc
08/03/2012 10:49AM
Re: CPU usage 99% - and query very slow - help  
2,209
Rick James
08/04/2012 01:36PM
Re: CPU usage 99% - and query very slow - help  
2,999
robert eeeeee
08/06/2012 01:04PM
Re: CPU usage 99% - and query very slow - help  
2,360
Øystein Grøvlen
08/15/2012 03:09AM
Execution plan: wrong index selected, very poor performance.  
5,060
Andrej Andrejevic
07/18/2012 10:31AM
Re: Execution plan: wrong index selected, very poor performance.  
2,007
Rick James
07/19/2012 10:07PM
Re: Execution plan: wrong index selected, very poor performance.  
1,835
Andrej Andrejevic
07/20/2012 01:38AM
Re: Execution plan: wrong index selected, very poor performance.  
1,575
Andrej Andrejevic
07/24/2012 04:27AM
Re: Execution plan: wrong index selected, very poor performance.  
1,718
Rick James
07/25/2012 12:21AM
Index for Query  
3,465
dileep ch
07/17/2012 12:41AM
Re: Index for Query  
1,707
Rick James
07/17/2012 10:36PM
Re: Index for Query  
1,653
dileep ch
07/18/2012 11:52PM
Re: Index for Query  
2,338
Rick James
07/19/2012 09:49PM
best way to optimize this query  
3,303
Jap bn
07/14/2012 09:54AM
Re: best way to optimize this query  
1,826
Rick James
07/15/2012 10:11PM
Optimizer being overly aggressive  
3,168
Adrian Cornish
07/06/2012 08:18PM
Re: Optimizer being overly aggressive  
1,612
Rick James
07/10/2012 12:49PM
Re: Optimizer being overly aggressive  
1,605
Adrian Cornish
07/10/2012 08:54PM
multiple-column index and order by  
3,421
Raphael Hoffmann
07/06/2012 05:59PM
Re: multiple-column index and order by  
1,655
Rick James
07/10/2012 12:55PM
From Months to Seconds with Subquery Materialization  
2,591
Edwin DeSouza
07/09/2012 11:15AM
performing mysqldump corrected query issue?  
2,930
Peter Sylvester
06/26/2012 01:12PM
Re: performing mysqldump corrected query issue?  
1,620
Rick James
07/01/2012 06:43PM
Re: performing mysqldump corrected query issue?  
1,446
Peter Sylvester
06/26/2012 02:08PM
difference between READ and SCAN  
2,676
Linhai Song
06/20/2012 04:05PM
Re: difference between READ and SCAN  
1,384
Rick James
06/20/2012 08:23PM
Re: difference between READ and SCAN  
1,736
Linhai Song
06/21/2012 12:19PM
to optimize a self join request  
2,625
Oracleuser user
06/14/2012 08:23AM
Re: to optimize a self join request  
1,708
Rick James
06/15/2012 08:19AM
Call out for FULL JOIN - bug #18003  
2,643
ted strauss
06/14/2012 10:23AM
Re: Call out for FULL JOIN - bug #18003  
1,275
ted strauss
06/14/2012 12:13PM
index cannot be used when passing 'int' to 'varchar'  
3,469
liao zhifeng
06/10/2012 11:16PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,554
Rick James
06/11/2012 11:27PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,480
liao zhifeng
06/12/2012 12:48AM
Re: index cannot be used when passing 'int' to 'varchar'  
1,553
Rick James
06/12/2012 09:23PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,752
liao zhifeng
06/12/2012 11:16PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,499
Rick James
06/13/2012 07:15PM
Re: index cannot be used when passing 'int' to 'varchar'  
1,491
liao zhifeng
06/13/2012 10:35PM
Table does not support optimize...  
4,342
Piotr Ch
06/02/2012 12:58AM
Querying a fast subquery never returns  
2,657
Eric Coll
05/22/2012 05:15PM
Re: Querying a fast subquery never returns  
1,453
Eric Coll
05/22/2012 05:19PM
Re: Querying a fast subquery never returns  
1,780
Rick James
05/24/2012 12:40AM
Re: Querying a fast subquery never returns  
1,727
Eric Coll
05/25/2012 11:15AM
Re: Querying a fast subquery never returns  
1,589
Rick James
05/26/2012 10:59AM
table index optimization  
2,871
Matus Zeman
05/01/2012 10:55AM
Re: table index optimization  
1,380
Rick James
05/02/2012 07:08PM
Re: table index optimization  
1,587
Rick James
05/05/2012 09:07AM
Re: table index optimization  
1,488
Matus Zeman
05/17/2012 09:25AM
Re: table index optimization  
1,716
Matus Zeman
05/04/2012 08:20AM
Query execution plan  
3,581
Chris Slominski
05/08/2012 12:38PM
Re: Query execution plan  
1,616
Rick James
05/09/2012 09:35PM
Re: Query execution plan  
1,681
Chris Slominski
05/10/2012 08:29AM
Re: Query execution plan  
1,626
Rick James
05/11/2012 07:16PM
Re: Query execution plan  
1,727
Chris Slominski
05/14/2012 05:27AM
Re: Query execution plan  
1,492
Rick James
05/15/2012 07:22PM
Re: Query execution plan  
1,467
Chris Slominski
05/09/2012 11:08AM
limit & scala subquery  
2,836
jongse park
05/08/2012 10:33PM
Re: limit & scala subquery  
1,358
Rick James
05/09/2012 09:21PM
Mysql slow upadte  
2,192
krishna krishna
04/30/2012 06:09AM
1000 Columns, 1000 Tables, or what?  
3,519
Fernando Oliveira
04/19/2012 08:09AM
Re: 1000 Columns, 1000 Tables, or what?  
1,687
Rick James
04/20/2012 06:50PM
Re: 1000 Columns, 1000 Tables, or what?  
1,486
Fernando Oliveira
04/23/2012 08:10AM
Re: 1000 Columns, 1000 Tables, or what?  
1,734
Rick James
04/26/2012 07:59AM
Help with query/tables optimization  
2,702
Oleg Ivanov
04/14/2012 05:20AM
Re: Help with query/tables optimization  
1,538
Rick James
04/16/2012 12:05AM
Re: Help with query/tables optimization  
1,639
Oleg Ivanov
04/16/2012 11:53AM
Re: Help with query/tables optimization  
1,978
Oleg Ivanov
04/16/2012 12:04PM
Identical servers different plan for the same query  
3,746
Eric Coll
04/07/2012 01:20AM
Re: Identical servers different plan for the same query  
1,656
Eric Coll
04/10/2012 03:28PM
Re: Identical servers different plan for the same query  
1,751
Rick James
04/10/2012 10:29PM
Re: Identical servers different plan for the same query  
1,591
Eric Coll
04/11/2012 10:05AM
Re: Identical servers different plan for the same query  
1,669
Rick James
04/12/2012 08:56AM
Re: Identical servers different plan for the same query  
1,669
Eric Coll
04/12/2012 03:23PM
Re: Identical servers different plan for the same query  
2,796
Rick James
04/13/2012 03:49PM
Re: Identical servers different plan for the same query  
1,638
Eric Coll
04/07/2012 09:55AM
Re: Identical servers different plan for the same query  
1,612
irek kordirko
04/07/2012 02:54PM
Re: Identical servers different plan for the same query  
1,926
Rick James
04/08/2012 12:20PM
Re: Identical servers different plan for the same query  
2,096
Eric Coll
04/09/2012 10:24AM
Re: Identical servers different plan for the same query  
1,697
Eric Coll
04/09/2012 10:35AM
Re: Identical servers different plan for the same query  
1,582
Eric Coll
04/09/2012 10:37AM
Re: Identical servers different plan for the same query  
1,698
Eric Coll
04/09/2012 10:42AM
MySQL Optimizer: Improved DBT-3 Results with MySQL 5.6.5  
2,260
Edwin DeSouza
04/10/2012 05:31PM
MySQL Optimizer: Improvements for many-table joins  
2,201
Edwin DeSouza
04/10/2012 02:54PM
MySQL Optimizer Team Blog  
2,542
Edwin DeSouza
04/10/2012 01:58PM
MySQL Optimizer: Index Condition Pushdown to the rescue!  
2,350
Edwin DeSouza
04/10/2012 01:56PM
MySQL Optimizer: Semi-join in MySQL 5.6  
1,960
Edwin DeSouza
04/10/2012 01:56PM
MySQL Optimizer: On queries with many values in the IN clause  
2,181
Edwin DeSouza
04/10/2012 01:55PM
MySQL Optimizer: Faster subqueries with materialization  
1,980
Edwin DeSouza
04/10/2012 01:54PM
MySQL Optimizer: Structured EXPLAIN (JSON)  
2,445
Edwin DeSouza
04/10/2012 01:54PM
LEFT JOIN WHERE GROUP BY  
3,479
Daniel Flöijer
04/02/2012 02:51AM
Re: LEFT JOIN WHERE GROUP BY  
1,742
Rick James
04/05/2012 08:01PM
Re: LEFT JOIN WHERE GROUP BY  
1,503
irek kordirko
04/02/2012 12:04PM
Re: LEFT JOIN WHERE GROUP BY  
1,561
Daniel Flöijer
04/02/2012 01:24PM
Re: LEFT JOIN WHERE GROUP BY  
1,568
irek kordirko
04/02/2012 04:29PM
Re: LEFT JOIN WHERE GROUP BY  
2,283
Daniel Flöijer
04/03/2012 12:50AM
Re: LEFT JOIN WHERE GROUP BY  
1,526
irek kordirko
04/03/2012 05:40PM
Re: LEFT JOIN WHERE GROUP BY  
1,657
Daniel Flöijer
04/03/2012 11:22PM
Re: LEFT JOIN WHERE GROUP BY  
1,483
irek kordirko
04/04/2012 05:12PM
Re: LEFT JOIN WHERE GROUP BY  
1,231
Daniel Flöijer
04/04/2012 11:10PM
Explain the order of query  
2,810
jongse park
03/19/2012 01:49AM
Re: Explain the order of query  
1,448
Rick James
03/19/2012 10:38PM
Re: Explain the order of query  
1,444
jongse park
03/21/2012 07:06PM
Re: Explain the order of query  
1,845
Jørgen Løland
03/28/2012 05:06AM
Re: Explain the order of query  
1,227
Rick James
03/22/2012 06:01PM
Re: Explain the order of query  
1,226
jongse park
03/22/2012 08:13PM
Re: Explain the order of query  
1,254
Rick James
03/23/2012 07:57PM
This topic has been moved.:  difference between READ and SCAN  
0
Linhai Song
06/20/2012 05:47PM
Pages:
« 1
...
3 4 5 6 7
...
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.