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,148
Robert Koziol
02/10/2011 05:14AM
Re: select query optimize  
1,437
Rick James
02/12/2011 06:56PM
Re: select query optimize  
1,390
Robert Koziol
02/14/2011 06:26AM
GROUP BY Not Using Index  
8,417
Conner Hewitt
01/19/2011 08:56AM
Re: GROUP BY Not Using Index  
3,994
Rick James
01/20/2011 10:02PM
Re: GROUP BY Not Using Index  
2,976
Conner Hewitt
01/21/2011 05:04PM
Re: GROUP BY Not Using Index  
2,581
Rick James
01/21/2011 11:07PM
Re: GROUP BY Not Using Index  
2,618
Conner Hewitt
02/08/2011 11:03AM
Max Number of Indexes?  
6,466
Conner Hewitt
01/26/2011 02:07PM
Re: Max Number of Indexes?  
2,145
Rick James
01/27/2011 11:13AM
Re: Max Number of Indexes?  
1,806
Conner Hewitt
01/29/2011 10:38PM
Re: Max Number of Indexes?  
2,554
Rick James
02/02/2011 09:46AM
Re: Max Number of Indexes?  
1,596
Conner Hewitt
02/08/2011 10:41AM
Help with a very slow select query  
2,767
Francisco Javier Morales López de Gamarra
02/02/2011 04:45AM
Re: Help with a very slow select query  
1,394
Richard Buckmaster
02/02/2011 06:02AM
Re: Help with a very slow select query  
1,242
Francisco Javier Morales López de Gamarra
02/02/2011 06:51AM
Re: Help with a very slow select query  
1,273
Rick James
02/02/2011 10:24AM
Re: Help with a very slow select query  
1,201
Francisco Javier Morales López de Gamarra
02/02/2011 06:17AM
500,000 rows - Slow when maintaining  
3,641
Erik Nord
01/20/2011 01:00AM
Re: 500,000 rows - Slow when maintaining  
1,263
Rick James
01/20/2011 10:55PM
Re: 500,000 rows - Slow when maintaining  
1,303
Vlad Pilly
01/20/2011 04:58AM
Re: 500,000 rows - Slow when maintaining  
1,286
Erik Nord
01/20/2011 12:17PM
Query Tuning for NOT EQUAL TO <> operator  
10,703
Irfan Ali
10/22/2010 07:42AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,560
Vlad Pilly
01/19/2011 11:33AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,479
Rick James
10/26/2010 10:40PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,143
Irfan Ali
10/31/2010 01:50PM
Re: Query Tuning for NOT EQUAL TO <> operator  
3,599
Rick James
11/02/2010 02:21PM
Field calculated using the WHERE  
2,915
Michael Silva
01/13/2011 03:22PM
Re: Field calculated using the WHERE  
1,253
Rick James
01/15/2011 12:42AM
identifying unused databases  
6,055
kannan Mohan
12/27/2010 10:31PM
Re: identifying unused databases  
2,316
kannan Mohan
01/12/2011 10:31PM
Re: identifying unused databases  
1,850
Rick James
01/15/2011 12:08AM
Re: identifying unused databases  
2,609
Rick James
12/31/2010 08:26PM
Explain shows different results on two servers  
4,274
Tomasz Wilk
01/10/2011 05:08PM
Re: Explain shows different results on two servers  
1,739
Rick James
01/14/2011 08:50AM
Optimizing query with having and count  
2,446
bw h ontwerpers
01/13/2011 05:58AM
same query sometimes very slow (punbb forum)  
5,513
Gennadiy Barvinok
01/06/2011 03:41AM
Re: same query sometimes very slow (punbb forum)  
1,943
Rick James
01/07/2011 11:03PM
optimize select query  
3,190
Robert Koziol
12/30/2010 10:59AM
Re: optimize select query  
1,359
Rick James
12/31/2010 08:22PM
Re: optimize select query  
1,473
Robert Koziol
01/04/2011 04:07AM
Re: optimize select query  
1,693
Rick James
01/06/2011 09:37PM
Re: optimize select query  
1,537
Robert Koziol
01/03/2011 01:02PM
Please help optimizing a long running query (left outer join, with 2 subqueries)  
2,505
arif bandali
12/31/2010 01:19AM
Re: Please help optimizing a long running query (left outer join, with 2 subqueries)  
1,446
Rick James
01/01/2011 07:21PM
SQL SELECT COUNT(*) TO SLOW  
4,074
Jim Louch
12/21/2010 02:28PM
Re: SQL SELECT COUNT(*) TO SLOW  
1,896
Rick James
12/26/2010 11:15AM
How to Optimize these sql?  
2,131
Gucci Koo
12/10/2010 04:02AM
Re: How to Optimize these sql?  
1,025
Rick James
12/11/2010 02:17PM
basic 2 table query slow - where, index?  
2,632
Matt S
12/01/2010 02:55PM
Re: basic 2 table query slow - where, index?  
1,300
Rick James
12/05/2010 12:56PM
"Optimizing sub queries with joins"  
3,143
SUNIL KUMAR
12/01/2010 10:42PM
Re: "Optimizing sub queries with joins"  
1,484
Rick James
12/05/2010 12:45PM
Optimized Indexing for a Schedule Table  
3,804
Wes Thompson
11/23/2010 11:58PM
Re: Optimized Indexing for a Schedule Table  
1,252
Rick James
11/25/2010 02:35PM
Re: Optimized Indexing for a Schedule Table  
1,878
Wes Thompson
11/25/2010 10:47PM
Re: Optimized Indexing for a Schedule Table  
1,315
Wes Thompson
11/25/2010 11:05PM
Re: Optimized Indexing for a Schedule Table  
1,766
Rick James
11/26/2010 01:42PM
Re: Optimized Indexing for a Schedule Table  
1,386
Wes Thompson
11/26/2010 11:36PM
Re: Optimized Indexing for a Schedule Table  
1,480
Rick James
11/27/2010 01:31PM
Re: Optimized Indexing for a Schedule Table  
1,390
Wes Thompson
11/27/2010 02:44PM
slow query sorting on group maximum  
3,443
Dong Hoon Van Uytsel
11/05/2010 09:11AM
Re: slow query sorting on group maximum  
1,455
Dong Hoon Van Uytsel
11/19/2010 04:30PM
Re: slow query sorting on group maximum  
1,318
Rick James
11/19/2010 07:14PM
Re: slow query sorting on group maximum  
1,562
Dong Hoon Van Uytsel
11/22/2010 03:35AM
Re: slow query sorting on group maximum  
1,925
Rick James
11/19/2010 07:05PM
Re: slow query sorting on group maximum  
1,317
Rick James
11/19/2010 07:20PM
Re: slow query sorting on group maximum  
1,234
Dong Hoon Van Uytsel
11/22/2010 03:33AM
Re: slow query sorting on group maximum  
1,383
Rick James
11/06/2010 10:56AM
Re: slow query sorting on group maximum  
1,324
Dong Hoon Van Uytsel
11/07/2010 07:24AM
Re: slow query sorting on group maximum  
1,394
Rick James
11/07/2010 01:05PM
Optimizing queries with Wildcards  
3,609
George K
11/19/2010 08:54AM
Re: Optimizing queries with Wildcards  
1,242
Rick James
11/20/2010 11:23AM
may databases or may tables  
2,042
kevin smith
11/18/2010 10:18PM
Re: many databases or many tables  
1,250
Rick James
11/20/2010 09:28AM
'not in' query is very slow how to change it?  
6,439
kevin smith
11/15/2010 09:01AM
Re: 'not in' query is very slow how to change it?  
3,571
Rick James
11/18/2010 12:59AM
Re: 'not in' query is very slow how to change it?  
2,236
kevin smith
11/18/2010 10:19PM
High Mysql Load - CPU 360%  
3,030
i Linux85
11/14/2010 11:41AM
Re: High Mysql Load - CPU 360%  
1,250
Rick James
11/18/2010 01:22AM
Dynamic Queries Optimization  
2,557
Irfan Ali
11/15/2010 01:51PM
Re: Dynamic Queries Optimization  
1,488
Rick James
11/18/2010 12:46AM
Way of incerasing web traffic  
2,211
Biswajit Saha
11/14/2010 09:40AM
Can MySQL use index in a RANGE QUERY with ORDER BY?  
2,743
John Smith
11/02/2010 07:53PM
Re: Can MySQL use index in a RANGE QUERY with ORDER BY?  
1,476
Rick James
11/03/2010 09:17PM
Slow Queries : Using Temporary , Using Filesort  
7,093
Irfan Ali
10/22/2010 06:41AM
Re: Slow Queries : Using Temporary , Using Filesort  
2,431
Rick James
10/26/2010 10:37PM
Re: Slow Queries : Using Temporary , Using Filesort  
3,139
Irfan Ali
10/30/2010 03:42PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,518
Rick James
11/02/2010 12:23PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,806
Rick James
10/26/2010 10:32PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,419
Irfan Ali
10/30/2010 03:29PM
Normalise and optimise- Urgent  
2,425
raj uni
10/27/2010 08:27PM
Re: Normalise and optimise- Urgent  
1,132
Rick James
10/28/2010 09:44PM
Slow query  
2,386
Dave Titan
10/23/2010 03:27AM
Re: Slow query  
1,107
Rick James
10/26/2010 10:42PM
Optimiztion of LEFT JOIN and LIMIT  
3,643
Sopace Sopcae
10/05/2010 01:33PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,462
Sopace Sopcae
10/05/2010 02:21PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,998
Rick James
10/06/2010 09:11PM
Database error : too many connectons  
2,140
abdelrahman ellithy
09/13/2010 05:25AM
Re: Database error : too many connectons  
1,602
Rick James
09/14/2010 07:58AM
NOP optimises Group By?  
4,012
Peter Griffioen
09/05/2010 08:16PM
Re: NOP optimises Group By?  
1,390
Rick James
09/11/2010 01:22PM
Re: NOP optimises Group By? -solved  
1,626
Peter Griffioen
09/12/2010 11:09PM
Re: NOP optimises Group By? -solved  
1,457
Peter Griffioen
09/13/2010 08:15PM
Re: NOP optimises Group By? -solved  
1,381
Rick James
09/13/2010 10:46PM
Re: NOP optimises Group By? -solved  
1,444
Rick James
09/13/2010 10:56AM
how to avoir filesort and temporary with theses 2 little tables ?  
2,223
yannick simon
09/07/2010 06:33AM
Re: how to avoir filesort and temporary with theses 2 little tables ?  
1,076
Rick James
09/09/2010 11:49PM
left join with sum and group by  
24,140
Andreas Schmidt
08/18/2010 05:46AM
Re: left join with sum and group by  
8,419
Rick James
08/20/2010 11:40PM
Re: left join with sum and group by  
4,566
Andreas Schmidt
08/23/2010 04:26AM
Re: left join with sum and group by  
6,649
Rick James
08/27/2010 08:01PM
Re: left join with sum and group by  
4,081
Andreas Schmidt
09/07/2010 05:08AM
Query cache was never filled up  
3,915
Reynard H
08/28/2010 09:58AM
Re: Query cache was never filled up  
1,522
Rick James
08/29/2010 09:25PM
Speed problem  
2,646
sridhar subramaniam
08/25/2010 03:33AM
Re: Speed problem  
1,241
Rick James
08/27/2010 08:03AM
SQL CACHE Not used. When it should be?  
3,530
James Barwick
08/10/2010 12:41AM
Re: SQL CACHE Not used. When it should be?  
1,974
Rick James
08/17/2010 08:34AM
Optimize: most recent N items with join  
2,833
Scott Gatz
08/03/2010 01:49PM
Re: Optimize: most recent N items with join  
1,380
Rick James
08/08/2010 10:35AM
Query Optimization on time-based data  
3,603
Greg Smith
08/03/2010 10:06AM
Re: Query Optimization on time-based data  
2,333
Rick James
08/05/2010 10:35PM
Advice on indexing a datetime column  
27,418
Michaël Ball
07/23/2010 08:56AM
Re: Advice on indexing a datetime column  
11,423
Jonathon Coombes
07/24/2010 09:58PM
Re: Advice on indexing a datetime column  
8,537
Michaël Ball
07/25/2010 02:01AM
Re: Advice on indexing a datetime column  
7,576
Rick James
07/27/2010 10:29PM
Estimating Index Size on Innodb Tables  
11,398
Paulo Victor Maluf Alves
07/26/2010 01:49PM
Re: Estimating Index Size on Innodb Tables  
4,212
Rick James
07/27/2010 08:08PM
Optimize my my.ini  
9,970
Mohamad Bataineh
07/22/2010 11:20AM
Re: Optimize my my.ini  
2,731
Rick James
07/25/2010 10:26PM
Help Optimizing My SELECT Query  
2,880
gooey graphics
07/19/2010 12:54PM
Re: Help Optimizing My SELECT Query  
1,310
Rick James
07/21/2010 01:06PM
Analyze question  
4,778
Dorian Kuroki
07/13/2010 03:30PM
Re: Analyze question  
1,594
Rick James
07/14/2010 10:48PM
Re: Analyze question  
1,726
Dorian Kuroki
07/15/2010 11:26AM
Re: Analyze question  
1,549
Rick James
07/15/2010 08:54PM
query executes slowly in a table with 2m records  
3,073
Zheng Li
07/13/2010 08:38AM
Re: query executes slowly in a table with 2m records  
1,484
Rick James
07/14/2010 11:12PM
Analyze and cardinality  
3,725
Dorian Kuroki
07/14/2010 10:50AM
Can we write one query instead of following three query?  
2,624
sunil divyeshvar
07/08/2010 01:44AM
Re: Can we write one query instead of following three query?  
1,307
Rick James
07/11/2010 11:47PM
multicolumn index & forcing index to avoid filesort  
4,081
Paolo Barroni
07/04/2010 09:30AM
Re: multicolumn index & forcing index to avoid filesort  
1,759
Rick James
07/05/2010 11:58PM
sub query  
2,935
lavanya kv
07/01/2010 05:33AM
Re: sub query  
1,512
Rick James
07/02/2010 09:01PM
Re: sub query  
1,428
lavanya kv
07/02/2010 10:39PM
Query needs to be optimized  
3,179
ponvictor abraham
06/29/2010 03:39AM
Re: Query needs to be optimized  
1,505
Rick James
06/30/2010 08:50AM
Re: Query needs to be optimized  
1,828
ponvictor abraham
07/01/2010 12:28AM
Re: Query needs to be optimized  
1,426
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.