MySQL Forums
Forum List  »  Optimizer & Parser

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

Subject
Views
Written By
Posted
select query optimize  
3,278
Robert Koziol
02/10/2011 05:14AM
Re: select query optimize  
1,502
Rick James
02/12/2011 06:56PM
Re: select query optimize  
1,446
Robert Koziol
02/14/2011 06:26AM
GROUP BY Not Using Index  
8,578
Conner Hewitt
01/19/2011 08:56AM
Re: GROUP BY Not Using Index  
4,069
Rick James
01/20/2011 10:02PM
Re: GROUP BY Not Using Index  
3,053
Conner Hewitt
01/21/2011 05:04PM
Re: GROUP BY Not Using Index  
2,651
Rick James
01/21/2011 11:07PM
Re: GROUP BY Not Using Index  
2,703
Conner Hewitt
02/08/2011 11:03AM
Max Number of Indexes?  
6,623
Conner Hewitt
01/26/2011 02:07PM
Re: Max Number of Indexes?  
2,214
Rick James
01/27/2011 11:13AM
Re: Max Number of Indexes?  
1,875
Conner Hewitt
01/29/2011 10:38PM
Re: Max Number of Indexes?  
2,635
Rick James
02/02/2011 09:46AM
Re: Max Number of Indexes?  
1,665
Conner Hewitt
02/08/2011 10:41AM
Help with a very slow select query  
2,925
Francisco Javier Morales López de Gamarra
02/02/2011 04:45AM
Re: Help with a very slow select query  
1,446
Richard Buckmaster
02/02/2011 06:02AM
Re: Help with a very slow select query  
1,296
Francisco Javier Morales López de Gamarra
02/02/2011 06:51AM
Re: Help with a very slow select query  
1,338
Rick James
02/02/2011 10:24AM
Re: Help with a very slow select query  
1,263
Francisco Javier Morales López de Gamarra
02/02/2011 06:17AM
500,000 rows - Slow when maintaining  
3,802
Erik Nord
01/20/2011 01:00AM
Re: 500,000 rows - Slow when maintaining  
1,321
Rick James
01/20/2011 10:55PM
Re: 500,000 rows - Slow when maintaining  
1,371
Vlad Pilly
01/20/2011 04:58AM
Re: 500,000 rows - Slow when maintaining  
1,345
Erik Nord
01/20/2011 12:17PM
Query Tuning for NOT EQUAL TO <> operator  
10,861
Irfan Ali
10/22/2010 07:42AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,618
Vlad Pilly
01/19/2011 11:33AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,538
Rick James
10/26/2010 10:40PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,198
Irfan Ali
10/31/2010 01:50PM
Re: Query Tuning for NOT EQUAL TO <> operator  
3,671
Rick James
11/02/2010 02:21PM
Field calculated using the WHERE  
3,026
Michael Silva
01/13/2011 03:22PM
Re: Field calculated using the WHERE  
1,299
Rick James
01/15/2011 12:42AM
identifying unused databases  
6,197
kannan Mohan
12/27/2010 10:31PM
Re: identifying unused databases  
2,378
kannan Mohan
01/12/2011 10:31PM
Re: identifying unused databases  
1,910
Rick James
01/15/2011 12:08AM
Re: identifying unused databases  
2,672
Rick James
12/31/2010 08:26PM
Explain shows different results on two servers  
4,403
Tomasz Wilk
01/10/2011 05:08PM
Re: Explain shows different results on two servers  
1,789
Rick James
01/14/2011 08:50AM
Optimizing query with having and count  
2,579
bw h ontwerpers
01/13/2011 05:58AM
same query sometimes very slow (punbb forum)  
5,651
Gennadiy Barvinok
01/06/2011 03:41AM
Re: same query sometimes very slow (punbb forum)  
2,015
Rick James
01/07/2011 11:03PM
optimize select query  
3,350
Robert Koziol
12/30/2010 10:59AM
Re: optimize select query  
1,422
Rick James
12/31/2010 08:22PM
Re: optimize select query  
1,548
Robert Koziol
01/04/2011 04:07AM
Re: optimize select query  
1,774
Rick James
01/06/2011 09:37PM
Re: optimize select query  
1,601
Robert Koziol
01/03/2011 01:02PM
Please help optimizing a long running query (left outer join, with 2 subqueries)  
2,628
arif bandali
12/31/2010 01:19AM
Re: Please help optimizing a long running query (left outer join, with 2 subqueries)  
1,510
Rick James
01/01/2011 07:21PM
SQL SELECT COUNT(*) TO SLOW  
4,187
Jim Louch
12/21/2010 02:28PM
Re: SQL SELECT COUNT(*) TO SLOW  
1,954
Rick James
12/26/2010 11:15AM
How to Optimize these sql?  
2,246
Gucci Koo
12/10/2010 04:02AM
Re: How to Optimize these sql?  
1,107
Rick James
12/11/2010 02:17PM
basic 2 table query slow - where, index?  
2,737
Matt S
12/01/2010 02:55PM
Re: basic 2 table query slow - where, index?  
1,371
Rick James
12/05/2010 12:56PM
"Optimizing sub queries with joins"  
3,283
SUNIL KUMAR
12/01/2010 10:42PM
Re: "Optimizing sub queries with joins"  
1,545
Rick James
12/05/2010 12:45PM
Optimized Indexing for a Schedule Table  
3,923
Wes Thompson
11/23/2010 11:58PM
Re: Optimized Indexing for a Schedule Table  
1,313
Rick James
11/25/2010 02:35PM
Re: Optimized Indexing for a Schedule Table  
1,950
Wes Thompson
11/25/2010 10:47PM
Re: Optimized Indexing for a Schedule Table  
1,387
Wes Thompson
11/25/2010 11:05PM
Re: Optimized Indexing for a Schedule Table  
1,831
Rick James
11/26/2010 01:42PM
Re: Optimized Indexing for a Schedule Table  
1,457
Wes Thompson
11/26/2010 11:36PM
Re: Optimized Indexing for a Schedule Table  
1,556
Rick James
11/27/2010 01:31PM
Re: Optimized Indexing for a Schedule Table  
1,450
Wes Thompson
11/27/2010 02:44PM
slow query sorting on group maximum  
3,573
Dong Hoon Van Uytsel
11/05/2010 09:11AM
Re: slow query sorting on group maximum  
1,519
Dong Hoon Van Uytsel
11/19/2010 04:30PM
Re: slow query sorting on group maximum  
1,391
Rick James
11/19/2010 07:14PM
Re: slow query sorting on group maximum  
1,628
Dong Hoon Van Uytsel
11/22/2010 03:35AM
Re: slow query sorting on group maximum  
1,991
Rick James
11/19/2010 07:05PM
Re: slow query sorting on group maximum  
1,392
Rick James
11/19/2010 07:20PM
Re: slow query sorting on group maximum  
1,301
Dong Hoon Van Uytsel
11/22/2010 03:33AM
Re: slow query sorting on group maximum  
1,448
Rick James
11/06/2010 10:56AM
Re: slow query sorting on group maximum  
1,392
Dong Hoon Van Uytsel
11/07/2010 07:24AM
Re: slow query sorting on group maximum  
1,458
Rick James
11/07/2010 01:05PM
Optimizing queries with Wildcards  
3,727
George K
11/19/2010 08:54AM
Re: Optimizing queries with Wildcards  
1,306
Rick James
11/20/2010 11:23AM
may databases or may tables  
2,155
kevin smith
11/18/2010 10:18PM
Re: many databases or many tables  
1,310
Rick James
11/20/2010 09:28AM
'not in' query is very slow how to change it?  
6,553
kevin smith
11/15/2010 09:01AM
Re: 'not in' query is very slow how to change it?  
3,636
Rick James
11/18/2010 12:59AM
Re: 'not in' query is very slow how to change it?  
2,304
kevin smith
11/18/2010 10:19PM
High Mysql Load - CPU 360%  
3,140
i Linux85
11/14/2010 11:41AM
Re: High Mysql Load - CPU 360%  
1,307
Rick James
11/18/2010 01:22AM
Dynamic Queries Optimization  
2,695
Irfan Ali
11/15/2010 01:51PM
Re: Dynamic Queries Optimization  
1,561
Rick James
11/18/2010 12:46AM
Way of incerasing web traffic  
2,338
Biswajit Saha
11/14/2010 09:40AM
Can MySQL use index in a RANGE QUERY with ORDER BY?  
2,889
John Smith
11/02/2010 07:53PM
Re: Can MySQL use index in a RANGE QUERY with ORDER BY?  
1,546
Rick James
11/03/2010 09:17PM
Slow Queries : Using Temporary , Using Filesort  
7,313
Irfan Ali
10/22/2010 06:41AM
Re: Slow Queries : Using Temporary , Using Filesort  
2,503
Rick James
10/26/2010 10:37PM
Re: Slow Queries : Using Temporary , Using Filesort  
3,216
Irfan Ali
10/30/2010 03:42PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,592
Rick James
11/02/2010 12:23PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,887
Rick James
10/26/2010 10:32PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,478
Irfan Ali
10/30/2010 03:29PM
Normalise and optimise- Urgent  
2,546
raj uni
10/27/2010 08:27PM
Re: Normalise and optimise- Urgent  
1,182
Rick James
10/28/2010 09:44PM
Slow query  
2,511
Dave Titan
10/23/2010 03:27AM
Re: Slow query  
1,178
Rick James
10/26/2010 10:42PM
Optimiztion of LEFT JOIN and LIMIT  
3,744
Sopace Sopcae
10/05/2010 01:33PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,547
Sopace Sopcae
10/05/2010 02:21PM
Re: Optimiztion of LEFT JOIN and LIMIT  
2,098
Rick James
10/06/2010 09:11PM
Database error : too many connectons  
2,262
abdelrahman ellithy
09/13/2010 05:25AM
Re: Database error : too many connectons  
1,676
Rick James
09/14/2010 07:58AM
NOP optimises Group By?  
4,153
Peter Griffioen
09/05/2010 08:16PM
Re: NOP optimises Group By?  
1,451
Rick James
09/11/2010 01:22PM
Re: NOP optimises Group By? -solved  
1,691
Peter Griffioen
09/12/2010 11:09PM
Re: NOP optimises Group By? -solved  
1,539
Peter Griffioen
09/13/2010 08:15PM
Re: NOP optimises Group By? -solved  
1,449
Rick James
09/13/2010 10:46PM
Re: NOP optimises Group By? -solved  
1,515
Rick James
09/13/2010 10:56AM
how to avoir filesort and temporary with theses 2 little tables ?  
2,374
yannick simon
09/07/2010 06:33AM
Re: how to avoir filesort and temporary with theses 2 little tables ?  
1,164
Rick James
09/09/2010 11:49PM
left join with sum and group by  
24,436
Andreas Schmidt
08/18/2010 05:46AM
Re: left join with sum and group by  
8,532
Rick James
08/20/2010 11:40PM
Re: left join with sum and group by  
4,660
Andreas Schmidt
08/23/2010 04:26AM
Re: left join with sum and group by  
6,748
Rick James
08/27/2010 08:01PM
Re: left join with sum and group by  
4,166
Andreas Schmidt
09/07/2010 05:08AM
Query cache was never filled up  
4,096
Reynard H
08/28/2010 09:58AM
Re: Query cache was never filled up  
1,583
Rick James
08/29/2010 09:25PM
Speed problem  
2,763
sridhar subramaniam
08/25/2010 03:33AM
Re: Speed problem  
1,301
Rick James
08/27/2010 08:03AM
SQL CACHE Not used. When it should be?  
3,653
James Barwick
08/10/2010 12:41AM
Re: SQL CACHE Not used. When it should be?  
2,038
Rick James
08/17/2010 08:34AM
Optimize: most recent N items with join  
2,948
Scott Gatz
08/03/2010 01:49PM
Re: Optimize: most recent N items with join  
1,450
Rick James
08/08/2010 10:35AM
Query Optimization on time-based data  
3,721
Greg Smith
08/03/2010 10:06AM
Re: Query Optimization on time-based data  
2,391
Rick James
08/05/2010 10:35PM
Advice on indexing a datetime column  
27,914
Michaël Ball
07/23/2010 08:56AM
Re: Advice on indexing a datetime column  
11,590
Jonathon Coombes
07/24/2010 09:58PM
Re: Advice on indexing a datetime column  
8,658
Michaël Ball
07/25/2010 02:01AM
Re: Advice on indexing a datetime column  
7,704
Rick James
07/27/2010 10:29PM
Estimating Index Size on Innodb Tables  
11,559
Paulo Victor Maluf Alves
07/26/2010 01:49PM
Re: Estimating Index Size on Innodb Tables  
4,283
Rick James
07/27/2010 08:08PM
Optimize my my.ini  
10,442
Mohamad Bataineh
07/22/2010 11:20AM
Re: Optimize my my.ini  
2,840
Rick James
07/25/2010 10:26PM
Help Optimizing My SELECT Query  
3,003
gooey graphics
07/19/2010 12:54PM
Re: Help Optimizing My SELECT Query  
1,371
Rick James
07/21/2010 01:06PM
Analyze question  
4,950
Dorian Kuroki
07/13/2010 03:30PM
Re: Analyze question  
1,670
Rick James
07/14/2010 10:48PM
Re: Analyze question  
1,801
Dorian Kuroki
07/15/2010 11:26AM
Re: Analyze question  
1,618
Rick James
07/15/2010 08:54PM
query executes slowly in a table with 2m records  
3,199
Zheng Li
07/13/2010 08:38AM
Re: query executes slowly in a table with 2m records  
1,544
Rick James
07/14/2010 11:12PM
Analyze and cardinality  
3,848
Dorian Kuroki
07/14/2010 10:50AM
Can we write one query instead of following three query?  
2,734
sunil divyeshvar
07/08/2010 01:44AM
Re: Can we write one query instead of following three query?  
1,363
Rick James
07/11/2010 11:47PM
multicolumn index & forcing index to avoid filesort  
4,299
Paolo Barroni
07/04/2010 09:30AM
Re: multicolumn index & forcing index to avoid filesort  
1,844
Rick James
07/05/2010 11:58PM
sub query  
3,064
lavanya kv
07/01/2010 05:33AM
Re: sub query  
1,578
Rick James
07/02/2010 09:01PM
Re: sub query  
1,486
lavanya kv
07/02/2010 10:39PM
Query needs to be optimized  
3,310
ponvictor abraham
06/29/2010 03:39AM
Re: Query needs to be optimized  
1,573
Rick James
06/30/2010 08:50AM
Re: Query needs to be optimized  
1,890
ponvictor abraham
07/01/2010 12:28AM
Re: Query needs to be optimized  
1,504
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.