MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing a new webcast video that completes a deep dive into how to download and use Enterprise Manager for MySQL 04/04/2024 03:01PM

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

Subject
Views
Written By
Posted
select query optimize  
3,093
Robert Koziol
02/10/2011 05:14AM
Re: select query optimize  
1,396
Rick James
02/12/2011 06:56PM
Re: select query optimize  
1,360
Robert Koziol
02/14/2011 06:26AM
GROUP BY Not Using Index  
8,330
Conner Hewitt
01/19/2011 08:56AM
Re: GROUP BY Not Using Index  
3,959
Rick James
01/20/2011 10:02PM
Re: GROUP BY Not Using Index  
2,942
Conner Hewitt
01/21/2011 05:04PM
Re: GROUP BY Not Using Index  
2,552
Rick James
01/21/2011 11:07PM
Re: GROUP BY Not Using Index  
2,583
Conner Hewitt
02/08/2011 11:03AM
Max Number of Indexes?  
6,390
Conner Hewitt
01/26/2011 02:07PM
Re: Max Number of Indexes?  
2,119
Rick James
01/27/2011 11:13AM
Re: Max Number of Indexes?  
1,778
Conner Hewitt
01/29/2011 10:38PM
Re: Max Number of Indexes?  
2,523
Rick James
02/02/2011 09:46AM
Re: Max Number of Indexes?  
1,566
Conner Hewitt
02/08/2011 10:41AM
Help with a very slow select query  
2,674
Francisco Javier Morales López de Gamarra
02/02/2011 04:45AM
Re: Help with a very slow select query  
1,368
Richard Buckmaster
02/02/2011 06:02AM
Re: Help with a very slow select query  
1,206
Francisco Javier Morales López de Gamarra
02/02/2011 06:51AM
Re: Help with a very slow select query  
1,241
Rick James
02/02/2011 10:24AM
Re: Help with a very slow select query  
1,172
Francisco Javier Morales López de Gamarra
02/02/2011 06:17AM
500,000 rows - Slow when maintaining  
3,595
Erik Nord
01/20/2011 01:00AM
Re: 500,000 rows - Slow when maintaining  
1,235
Rick James
01/20/2011 10:55PM
Re: 500,000 rows - Slow when maintaining  
1,274
Vlad Pilly
01/20/2011 04:58AM
Re: 500,000 rows - Slow when maintaining  
1,263
Erik Nord
01/20/2011 12:17PM
Query Tuning for NOT EQUAL TO <> operator  
10,629
Irfan Ali
10/22/2010 07:42AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,538
Vlad Pilly
01/19/2011 11:33AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,450
Rick James
10/26/2010 10:40PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,116
Irfan Ali
10/31/2010 01:50PM
Re: Query Tuning for NOT EQUAL TO <> operator  
3,570
Rick James
11/02/2010 02:21PM
Field calculated using the WHERE  
2,864
Michael Silva
01/13/2011 03:22PM
Re: Field calculated using the WHERE  
1,231
Rick James
01/15/2011 12:42AM
identifying unused databases  
5,987
kannan Mohan
12/27/2010 10:31PM
Re: identifying unused databases  
2,285
kannan Mohan
01/12/2011 10:31PM
Re: identifying unused databases  
1,820
Rick James
01/15/2011 12:08AM
Re: identifying unused databases  
2,578
Rick James
12/31/2010 08:26PM
Explain shows different results on two servers  
4,186
Tomasz Wilk
01/10/2011 05:08PM
Re: Explain shows different results on two servers  
1,710
Rick James
01/14/2011 08:50AM
Optimizing query with having and count  
2,387
bw h ontwerpers
01/13/2011 05:58AM
same query sometimes very slow (punbb forum)  
5,454
Gennadiy Barvinok
01/06/2011 03:41AM
Re: same query sometimes very slow (punbb forum)  
1,909
Rick James
01/07/2011 11:03PM
optimize select query  
3,095
Robert Koziol
12/30/2010 10:59AM
Re: optimize select query  
1,335
Rick James
12/31/2010 08:22PM
Re: optimize select query  
1,446
Robert Koziol
01/04/2011 04:07AM
Re: optimize select query  
1,650
Rick James
01/06/2011 09:37PM
Re: optimize select query  
1,507
Robert Koziol
01/03/2011 01:02PM
Please help optimizing a long running query (left outer join, with 2 subqueries)  
2,452
arif bandali
12/31/2010 01:19AM
Re: Please help optimizing a long running query (left outer join, with 2 subqueries)  
1,420
Rick James
01/01/2011 07:21PM
SQL SELECT COUNT(*) TO SLOW  
4,026
Jim Louch
12/21/2010 02:28PM
Re: SQL SELECT COUNT(*) TO SLOW  
1,873
Rick James
12/26/2010 11:15AM
How to Optimize these sql?  
2,077
Gucci Koo
12/10/2010 04:02AM
Re: How to Optimize these sql?  
998
Rick James
12/11/2010 02:17PM
basic 2 table query slow - where, index?  
2,591
Matt S
12/01/2010 02:55PM
Re: basic 2 table query slow - where, index?  
1,267
Rick James
12/05/2010 12:56PM
"Optimizing sub queries with joins"  
3,075
SUNIL KUMAR
12/01/2010 10:42PM
Re: "Optimizing sub queries with joins"  
1,459
Rick James
12/05/2010 12:45PM
Optimized Indexing for a Schedule Table  
3,750
Wes Thompson
11/23/2010 11:58PM
Re: Optimized Indexing for a Schedule Table  
1,221
Rick James
11/25/2010 02:35PM
Re: Optimized Indexing for a Schedule Table  
1,842
Wes Thompson
11/25/2010 10:47PM
Re: Optimized Indexing for a Schedule Table  
1,281
Wes Thompson
11/25/2010 11:05PM
Re: Optimized Indexing for a Schedule Table  
1,731
Rick James
11/26/2010 01:42PM
Re: Optimized Indexing for a Schedule Table  
1,357
Wes Thompson
11/26/2010 11:36PM
Re: Optimized Indexing for a Schedule Table  
1,450
Rick James
11/27/2010 01:31PM
Re: Optimized Indexing for a Schedule Table  
1,364
Wes Thompson
11/27/2010 02:44PM
slow query sorting on group maximum  
3,388
Dong Hoon Van Uytsel
11/05/2010 09:11AM
Re: slow query sorting on group maximum  
1,426
Dong Hoon Van Uytsel
11/19/2010 04:30PM
Re: slow query sorting on group maximum  
1,286
Rick James
11/19/2010 07:14PM
Re: slow query sorting on group maximum  
1,537
Dong Hoon Van Uytsel
11/22/2010 03:35AM
Re: slow query sorting on group maximum  
1,902
Rick James
11/19/2010 07:05PM
Re: slow query sorting on group maximum  
1,288
Rick James
11/19/2010 07:20PM
Re: slow query sorting on group maximum  
1,210
Dong Hoon Van Uytsel
11/22/2010 03:33AM
Re: slow query sorting on group maximum  
1,357
Rick James
11/06/2010 10:56AM
Re: slow query sorting on group maximum  
1,295
Dong Hoon Van Uytsel
11/07/2010 07:24AM
Re: slow query sorting on group maximum  
1,363
Rick James
11/07/2010 01:05PM
Optimizing queries with Wildcards  
3,572
George K
11/19/2010 08:54AM
Re: Optimizing queries with Wildcards  
1,209
Rick James
11/20/2010 11:23AM
may databases or may tables  
2,005
kevin smith
11/18/2010 10:18PM
Re: many databases or many tables  
1,228
Rick James
11/20/2010 09:28AM
'not in' query is very slow how to change it?  
6,385
kevin smith
11/15/2010 09:01AM
Re: 'not in' query is very slow how to change it?  
3,536
Rick James
11/18/2010 12:59AM
Re: 'not in' query is very slow how to change it?  
2,207
kevin smith
11/18/2010 10:19PM
High Mysql Load - CPU 360%  
2,984
i Linux85
11/14/2010 11:41AM
Re: High Mysql Load - CPU 360%  
1,224
Rick James
11/18/2010 01:22AM
Dynamic Queries Optimization  
2,499
Irfan Ali
11/15/2010 01:51PM
Re: Dynamic Queries Optimization  
1,454
Rick James
11/18/2010 12:46AM
Way of incerasing web traffic  
2,157
Biswajit Saha
11/14/2010 09:40AM
Can MySQL use index in a RANGE QUERY with ORDER BY?  
2,688
John Smith
11/02/2010 07:53PM
Re: Can MySQL use index in a RANGE QUERY with ORDER BY?  
1,441
Rick James
11/03/2010 09:17PM
Slow Queries : Using Temporary , Using Filesort  
7,007
Irfan Ali
10/22/2010 06:41AM
Re: Slow Queries : Using Temporary , Using Filesort  
2,391
Rick James
10/26/2010 10:37PM
Re: Slow Queries : Using Temporary , Using Filesort  
3,098
Irfan Ali
10/30/2010 03:42PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,483
Rick James
11/02/2010 12:23PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,771
Rick James
10/26/2010 10:32PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,390
Irfan Ali
10/30/2010 03:29PM
Normalise and optimise- Urgent  
2,363
raj uni
10/27/2010 08:27PM
Re: Normalise and optimise- Urgent  
1,105
Rick James
10/28/2010 09:44PM
Slow query  
2,314
Dave Titan
10/23/2010 03:27AM
Re: Slow query  
1,072
Rick James
10/26/2010 10:42PM
Optimiztion of LEFT JOIN and LIMIT  
3,598
Sopace Sopcae
10/05/2010 01:33PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,431
Sopace Sopcae
10/05/2010 02:21PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,949
Rick James
10/06/2010 09:11PM
Database error : too many connectons  
2,099
abdelrahman ellithy
09/13/2010 05:25AM
Re: Database error : too many connectons  
1,572
Rick James
09/14/2010 07:58AM
NOP optimises Group By?  
3,941
Peter Griffioen
09/05/2010 08:16PM
Re: NOP optimises Group By?  
1,356
Rick James
09/11/2010 01:22PM
Re: NOP optimises Group By? -solved  
1,579
Peter Griffioen
09/12/2010 11:09PM
Re: NOP optimises Group By? -solved  
1,425
Peter Griffioen
09/13/2010 08:15PM
Re: NOP optimises Group By? -solved  
1,351
Rick James
09/13/2010 10:46PM
Re: NOP optimises Group By? -solved  
1,408
Rick James
09/13/2010 10:56AM
how to avoir filesort and temporary with theses 2 little tables ?  
2,159
yannick simon
09/07/2010 06:33AM
Re: how to avoir filesort and temporary with theses 2 little tables ?  
1,040
Rick James
09/09/2010 11:49PM
left join with sum and group by  
23,974
Andreas Schmidt
08/18/2010 05:46AM
Re: left join with sum and group by  
8,371
Rick James
08/20/2010 11:40PM
Re: left join with sum and group by  
4,522
Andreas Schmidt
08/23/2010 04:26AM
Re: left join with sum and group by  
6,610
Rick James
08/27/2010 08:01PM
Re: left join with sum and group by  
4,034
Andreas Schmidt
09/07/2010 05:08AM
Query cache was never filled up  
3,823
Reynard H
08/28/2010 09:58AM
Re: Query cache was never filled up  
1,490
Rick James
08/29/2010 09:25PM
Speed problem  
2,603
sridhar subramaniam
08/25/2010 03:33AM
Re: Speed problem  
1,220
Rick James
08/27/2010 08:03AM
SQL CACHE Not used. When it should be?  
3,485
James Barwick
08/10/2010 12:41AM
Re: SQL CACHE Not used. When it should be?  
1,945
Rick James
08/17/2010 08:34AM
Optimize: most recent N items with join  
2,799
Scott Gatz
08/03/2010 01:49PM
Re: Optimize: most recent N items with join  
1,356
Rick James
08/08/2010 10:35AM
Query Optimization on time-based data  
3,568
Greg Smith
08/03/2010 10:06AM
Re: Query Optimization on time-based data  
2,306
Rick James
08/05/2010 10:35PM
Advice on indexing a datetime column  
27,271
Michaël Ball
07/23/2010 08:56AM
Re: Advice on indexing a datetime column  
11,375
Jonathon Coombes
07/24/2010 09:58PM
Re: Advice on indexing a datetime column  
8,500
Michaël Ball
07/25/2010 02:01AM
Re: Advice on indexing a datetime column  
7,532
Rick James
07/27/2010 10:29PM
Estimating Index Size on Innodb Tables  
11,333
Paulo Victor Maluf Alves
07/26/2010 01:49PM
Re: Estimating Index Size on Innodb Tables  
4,168
Rick James
07/27/2010 08:08PM
Optimize my my.ini  
9,705
Mohamad Bataineh
07/22/2010 11:20AM
Re: Optimize my my.ini  
2,683
Rick James
07/25/2010 10:26PM
Help Optimizing My SELECT Query  
2,839
gooey graphics
07/19/2010 12:54PM
Re: Help Optimizing My SELECT Query  
1,290
Rick James
07/21/2010 01:06PM
Analyze question  
4,710
Dorian Kuroki
07/13/2010 03:30PM
Re: Analyze question  
1,559
Rick James
07/14/2010 10:48PM
Re: Analyze question  
1,695
Dorian Kuroki
07/15/2010 11:26AM
Re: Analyze question  
1,524
Rick James
07/15/2010 08:54PM
query executes slowly in a table with 2m records  
3,020
Zheng Li
07/13/2010 08:38AM
Re: query executes slowly in a table with 2m records  
1,456
Rick James
07/14/2010 11:12PM
Analyze and cardinality  
3,680
Dorian Kuroki
07/14/2010 10:50AM
Can we write one query instead of following three query?  
2,580
sunil divyeshvar
07/08/2010 01:44AM
Re: Can we write one query instead of following three query?  
1,282
Rick James
07/11/2010 11:47PM
multicolumn index & forcing index to avoid filesort  
3,974
Paolo Barroni
07/04/2010 09:30AM
Re: multicolumn index & forcing index to avoid filesort  
1,724
Rick James
07/05/2010 11:58PM
sub query  
2,885
lavanya kv
07/01/2010 05:33AM
Re: sub query  
1,475
Rick James
07/02/2010 09:01PM
Re: sub query  
1,405
lavanya kv
07/02/2010 10:39PM
Query needs to be optimized  
3,116
ponvictor abraham
06/29/2010 03:39AM
Re: Query needs to be optimized  
1,474
Rick James
06/30/2010 08:50AM
Re: Query needs to be optimized  
1,801
ponvictor abraham
07/01/2010 12:28AM
Re: Query needs to be optimized  
1,401
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.