MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing October 2025 Releases featuring MySQL Server 9.5.0 Innovation, 8.4.7 LTS and 8.0.44 10/25/2025 05:45AM

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

Subject
Views
Written By
Posted
select query optimize  
3,369
Robert Koziol
02/10/2011 05:14AM
Re: select query optimize  
1,550
Rick James
02/12/2011 06:56PM
Re: select query optimize  
1,485
Robert Koziol
02/14/2011 06:26AM
GROUP BY Not Using Index  
8,737
Conner Hewitt
01/19/2011 08:56AM
Re: GROUP BY Not Using Index  
4,113
Rick James
01/20/2011 10:02PM
Re: GROUP BY Not Using Index  
3,106
Conner Hewitt
01/21/2011 05:04PM
Re: GROUP BY Not Using Index  
2,692
Rick James
01/21/2011 11:07PM
Re: GROUP BY Not Using Index  
2,755
Conner Hewitt
02/08/2011 11:03AM
Max Number of Indexes?  
6,726
Conner Hewitt
01/26/2011 02:07PM
Re: Max Number of Indexes?  
2,249
Rick James
01/27/2011 11:13AM
Re: Max Number of Indexes?  
1,909
Conner Hewitt
01/29/2011 10:38PM
Re: Max Number of Indexes?  
2,679
Rick James
02/02/2011 09:46AM
Re: Max Number of Indexes?  
1,716
Conner Hewitt
02/08/2011 10:41AM
Help with a very slow select query  
3,024
Francisco Javier Morales López de Gamarra
02/02/2011 04:45AM
Re: Help with a very slow select query  
1,494
Richard Buckmaster
02/02/2011 06:02AM
Re: Help with a very slow select query  
1,336
Francisco Javier Morales López de Gamarra
02/02/2011 06:51AM
Re: Help with a very slow select query  
1,389
Rick James
02/02/2011 10:24AM
Re: Help with a very slow select query  
1,315
Francisco Javier Morales López de Gamarra
02/02/2011 06:17AM
500,000 rows - Slow when maintaining  
3,891
Erik Nord
01/20/2011 01:00AM
Re: 500,000 rows - Slow when maintaining  
1,356
Rick James
01/20/2011 10:55PM
Re: 500,000 rows - Slow when maintaining  
1,415
Vlad Pilly
01/20/2011 04:58AM
Re: 500,000 rows - Slow when maintaining  
1,375
Erik Nord
01/20/2011 12:17PM
Query Tuning for NOT EQUAL TO <> operator  
11,000
Irfan Ali
10/22/2010 07:42AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,661
Vlad Pilly
01/19/2011 11:33AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,574
Rick James
10/26/2010 10:40PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,236
Irfan Ali
10/31/2010 01:50PM
Re: Query Tuning for NOT EQUAL TO <> operator  
3,715
Rick James
11/02/2010 02:21PM
Field calculated using the WHERE  
3,100
Michael Silva
01/13/2011 03:22PM
Re: Field calculated using the WHERE  
1,327
Rick James
01/15/2011 12:42AM
identifying unused databases  
6,278
kannan Mohan
12/27/2010 10:31PM
Re: identifying unused databases  
2,409
kannan Mohan
01/12/2011 10:31PM
Re: identifying unused databases  
1,953
Rick James
01/15/2011 12:08AM
Re: identifying unused databases  
2,706
Rick James
12/31/2010 08:26PM
Explain shows different results on two servers  
4,483
Tomasz Wilk
01/10/2011 05:08PM
Re: Explain shows different results on two servers  
1,825
Rick James
01/14/2011 08:50AM
Optimizing query with having and count  
2,662
bw h ontwerpers
01/13/2011 05:58AM
same query sometimes very slow (punbb forum)  
5,733
Gennadiy Barvinok
01/06/2011 03:41AM
Re: same query sometimes very slow (punbb forum)  
2,055
Rick James
01/07/2011 11:03PM
optimize select query  
3,429
Robert Koziol
12/30/2010 10:59AM
Re: optimize select query  
1,464
Rick James
12/31/2010 08:22PM
Re: optimize select query  
1,583
Robert Koziol
01/04/2011 04:07AM
Re: optimize select query  
1,814
Rick James
01/06/2011 09:37PM
Re: optimize select query  
1,664
Robert Koziol
01/03/2011 01:02PM
Please help optimizing a long running query (left outer join, with 2 subqueries)  
2,703
arif bandali
12/31/2010 01:19AM
Re: Please help optimizing a long running query (left outer join, with 2 subqueries)  
1,546
Rick James
01/01/2011 07:21PM
SQL SELECT COUNT(*) TO SLOW  
4,266
Jim Louch
12/21/2010 02:28PM
Re: SQL SELECT COUNT(*) TO SLOW  
1,978
Rick James
12/26/2010 11:15AM
How to Optimize these sql?  
2,324
Gucci Koo
12/10/2010 04:02AM
Re: How to Optimize these sql?  
1,140
Rick James
12/11/2010 02:17PM
basic 2 table query slow - where, index?  
2,820
Matt S
12/01/2010 02:55PM
Re: basic 2 table query slow - where, index?  
1,406
Rick James
12/05/2010 12:56PM
"Optimizing sub queries with joins"  
3,384
SUNIL KUMAR
12/01/2010 10:42PM
Re: "Optimizing sub queries with joins"  
1,587
Rick James
12/05/2010 12:45PM
Optimized Indexing for a Schedule Table  
4,006
Wes Thompson
11/23/2010 11:58PM
Re: Optimized Indexing for a Schedule Table  
1,359
Rick James
11/25/2010 02:35PM
Re: Optimized Indexing for a Schedule Table  
1,994
Wes Thompson
11/25/2010 10:47PM
Re: Optimized Indexing for a Schedule Table  
1,431
Wes Thompson
11/25/2010 11:05PM
Re: Optimized Indexing for a Schedule Table  
1,864
Rick James
11/26/2010 01:42PM
Re: Optimized Indexing for a Schedule Table  
1,489
Wes Thompson
11/26/2010 11:36PM
Re: Optimized Indexing for a Schedule Table  
1,589
Rick James
11/27/2010 01:31PM
Re: Optimized Indexing for a Schedule Table  
1,480
Wes Thompson
11/27/2010 02:44PM
slow query sorting on group maximum  
3,652
Dong Hoon Van Uytsel
11/05/2010 09:11AM
Re: slow query sorting on group maximum  
1,552
Dong Hoon Van Uytsel
11/19/2010 04:30PM
Re: slow query sorting on group maximum  
1,435
Rick James
11/19/2010 07:14PM
Re: slow query sorting on group maximum  
1,664
Dong Hoon Van Uytsel
11/22/2010 03:35AM
Re: slow query sorting on group maximum  
2,048
Rick James
11/19/2010 07:05PM
Re: slow query sorting on group maximum  
1,428
Rick James
11/19/2010 07:20PM
Re: slow query sorting on group maximum  
1,342
Dong Hoon Van Uytsel
11/22/2010 03:33AM
Re: slow query sorting on group maximum  
1,487
Rick James
11/06/2010 10:56AM
Re: slow query sorting on group maximum  
1,442
Dong Hoon Van Uytsel
11/07/2010 07:24AM
Re: slow query sorting on group maximum  
1,501
Rick James
11/07/2010 01:05PM
Optimizing queries with Wildcards  
3,802
George K
11/19/2010 08:54AM
Re: Optimizing queries with Wildcards  
1,339
Rick James
11/20/2010 11:23AM
may databases or may tables  
2,232
kevin smith
11/18/2010 10:18PM
Re: many databases or many tables  
1,340
Rick James
11/20/2010 09:28AM
'not in' query is very slow how to change it?  
6,627
kevin smith
11/15/2010 09:01AM
Re: 'not in' query is very slow how to change it?  
3,712
Rick James
11/18/2010 12:59AM
Re: 'not in' query is very slow how to change it?  
2,341
kevin smith
11/18/2010 10:19PM
High Mysql Load - CPU 360%  
3,208
i Linux85
11/14/2010 11:41AM
Re: High Mysql Load - CPU 360%  
1,344
Rick James
11/18/2010 01:22AM
Dynamic Queries Optimization  
2,780
Irfan Ali
11/15/2010 01:51PM
Re: Dynamic Queries Optimization  
1,598
Rick James
11/18/2010 12:46AM
Way of incerasing web traffic  
2,418
Biswajit Saha
11/14/2010 09:40AM
Can MySQL use index in a RANGE QUERY with ORDER BY?  
3,008
John Smith
11/02/2010 07:53PM
Re: Can MySQL use index in a RANGE QUERY with ORDER BY?  
1,586
Rick James
11/03/2010 09:17PM
Slow Queries : Using Temporary , Using Filesort  
7,436
Irfan Ali
10/22/2010 06:41AM
Re: Slow Queries : Using Temporary , Using Filesort  
2,542
Rick James
10/26/2010 10:37PM
Re: Slow Queries : Using Temporary , Using Filesort  
3,253
Irfan Ali
10/30/2010 03:42PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,635
Rick James
11/02/2010 12:23PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,926
Rick James
10/26/2010 10:32PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,515
Irfan Ali
10/30/2010 03:29PM
Normalise and optimise- Urgent  
2,632
raj uni
10/27/2010 08:27PM
Re: Normalise and optimise- Urgent  
1,218
Rick James
10/28/2010 09:44PM
Slow query  
2,588
Dave Titan
10/23/2010 03:27AM
Re: Slow query  
1,209
Rick James
10/26/2010 10:42PM
Optimiztion of LEFT JOIN and LIMIT  
3,816
Sopace Sopcae
10/05/2010 01:33PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,584
Sopace Sopcae
10/05/2010 02:21PM
Re: Optimiztion of LEFT JOIN and LIMIT  
2,137
Rick James
10/06/2010 09:11PM
Database error : too many connectons  
2,352
abdelrahman ellithy
09/13/2010 05:25AM
Re: Database error : too many connectons  
1,712
Rick James
09/14/2010 07:58AM
NOP optimises Group By?  
4,239
Peter Griffioen
09/05/2010 08:16PM
Re: NOP optimises Group By?  
1,505
Rick James
09/11/2010 01:22PM
Re: NOP optimises Group By? -solved  
1,728
Peter Griffioen
09/12/2010 11:09PM
Re: NOP optimises Group By? -solved  
1,576
Peter Griffioen
09/13/2010 08:15PM
Re: NOP optimises Group By? -solved  
1,485
Rick James
09/13/2010 10:46PM
Re: NOP optimises Group By? -solved  
1,551
Rick James
09/13/2010 10:56AM
how to avoir filesort and temporary with theses 2 little tables ?  
2,448
yannick simon
09/07/2010 06:33AM
Re: how to avoir filesort and temporary with theses 2 little tables ?  
1,197
Rick James
09/09/2010 11:49PM
left join with sum and group by  
24,588
Andreas Schmidt
08/18/2010 05:46AM
Re: left join with sum and group by  
8,582
Rick James
08/20/2010 11:40PM
Re: left join with sum and group by  
4,694
Andreas Schmidt
08/23/2010 04:26AM
Re: left join with sum and group by  
6,803
Rick James
08/27/2010 08:01PM
Re: left join with sum and group by  
4,210
Andreas Schmidt
09/07/2010 05:08AM
Query cache was never filled up  
4,215
Reynard H
08/28/2010 09:58AM
Re: Query cache was never filled up  
1,621
Rick James
08/29/2010 09:25PM
Speed problem  
2,843
sridhar subramaniam
08/25/2010 03:33AM
Re: Speed problem  
1,334
Rick James
08/27/2010 08:03AM
SQL CACHE Not used. When it should be?  
3,736
James Barwick
08/10/2010 12:41AM
Re: SQL CACHE Not used. When it should be?  
2,069
Rick James
08/17/2010 08:34AM
Optimize: most recent N items with join  
3,029
Scott Gatz
08/03/2010 01:49PM
Re: Optimize: most recent N items with join  
1,484
Rick James
08/08/2010 10:35AM
Query Optimization on time-based data  
3,798
Greg Smith
08/03/2010 10:06AM
Re: Query Optimization on time-based data  
2,428
Rick James
08/05/2010 10:35PM
Advice on indexing a datetime column  
28,144
Michaël Ball
07/23/2010 08:56AM
Re: Advice on indexing a datetime column  
11,670
Jonathon Coombes
07/24/2010 09:58PM
Re: Advice on indexing a datetime column  
8,734
Michaël Ball
07/25/2010 02:01AM
Re: Advice on indexing a datetime column  
7,749
Rick James
07/27/2010 10:29PM
Estimating Index Size on Innodb Tables  
11,646
Paulo Victor Maluf Alves
07/26/2010 01:49PM
Re: Estimating Index Size on Innodb Tables  
4,320
Rick James
07/27/2010 08:08PM
Optimize my my.ini  
10,627
Mohamad Bataineh
07/22/2010 11:20AM
Re: Optimize my my.ini  
2,881
Rick James
07/25/2010 10:26PM
Help Optimizing My SELECT Query  
3,086
gooey graphics
07/19/2010 12:54PM
Re: Help Optimizing My SELECT Query  
1,408
Rick James
07/21/2010 01:06PM
Analyze question  
5,058
Dorian Kuroki
07/13/2010 03:30PM
Re: Analyze question  
1,711
Rick James
07/14/2010 10:48PM
Re: Analyze question  
1,839
Dorian Kuroki
07/15/2010 11:26AM
Re: Analyze question  
1,658
Rick James
07/15/2010 08:54PM
query executes slowly in a table with 2m records  
3,289
Zheng Li
07/13/2010 08:38AM
Re: query executes slowly in a table with 2m records  
1,588
Rick James
07/14/2010 11:12PM
Analyze and cardinality  
3,929
Dorian Kuroki
07/14/2010 10:50AM
Can we write one query instead of following three query?  
2,826
sunil divyeshvar
07/08/2010 01:44AM
Re: Can we write one query instead of following three query?  
1,402
Rick James
07/11/2010 11:47PM
multicolumn index & forcing index to avoid filesort  
4,412
Paolo Barroni
07/04/2010 09:30AM
Re: multicolumn index & forcing index to avoid filesort  
1,893
Rick James
07/05/2010 11:58PM
sub query  
3,140
lavanya kv
07/01/2010 05:33AM
Re: sub query  
1,623
Rick James
07/02/2010 09:01PM
Re: sub query  
1,517
lavanya kv
07/02/2010 10:39PM
Query needs to be optimized  
3,393
ponvictor abraham
06/29/2010 03:39AM
Re: Query needs to be optimized  
1,610
Rick James
06/30/2010 08:50AM
Re: Query needs to be optimized  
1,927
ponvictor abraham
07/01/2010 12:28AM
Re: Query needs to be optimized  
1,543
Rick James
07/01/2010 09:43PM
This topic has been moved.:  Analyze question  
0
Dorian Kuroki
07/14/2010 10:18PM
This topic has been moved.:  Query needs to be optimized  
15
ponvictor abraham
06/29/2010 10:15PM
Pages:
« 1
...
6 7 8 9 10
...
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.