MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing July 2024 off-cycle Releases featuring MySQL Server 9.0.1 Innovation, 8.4.2 LTS and 8.0.39 07/24/2024 11:15AM
•   Announcing July 2024 Releases featuring MySQL Server 9.0.0 Innovation, 8.4.1 LTS and 8.0.38 07/02/2024 06:42AM

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

Subject
Views
Written By
Posted
select query optimize  
3,115
Robert Koziol
02/10/2011 05:14AM
Re: select query optimize  
1,414
Rick James
02/12/2011 06:56PM
Re: select query optimize  
1,372
Robert Koziol
02/14/2011 06:26AM
GROUP BY Not Using Index  
8,379
Conner Hewitt
01/19/2011 08:56AM
Re: GROUP BY Not Using Index  
3,977
Rick James
01/20/2011 10:02PM
Re: GROUP BY Not Using Index  
2,962
Conner Hewitt
01/21/2011 05:04PM
Re: GROUP BY Not Using Index  
2,567
Rick James
01/21/2011 11:07PM
Re: GROUP BY Not Using Index  
2,603
Conner Hewitt
02/08/2011 11:03AM
Max Number of Indexes?  
6,434
Conner Hewitt
01/26/2011 02:07PM
Re: Max Number of Indexes?  
2,131
Rick James
01/27/2011 11:13AM
Re: Max Number of Indexes?  
1,796
Conner Hewitt
01/29/2011 10:38PM
Re: Max Number of Indexes?  
2,540
Rick James
02/02/2011 09:46AM
Re: Max Number of Indexes?  
1,582
Conner Hewitt
02/08/2011 10:41AM
Help with a very slow select query  
2,714
Francisco Javier Morales López de Gamarra
02/02/2011 04:45AM
Re: Help with a very slow select query  
1,382
Richard Buckmaster
02/02/2011 06:02AM
Re: Help with a very slow select query  
1,222
Francisco Javier Morales López de Gamarra
02/02/2011 06:51AM
Re: Help with a very slow select query  
1,255
Rick James
02/02/2011 10:24AM
Re: Help with a very slow select query  
1,185
Francisco Javier Morales López de Gamarra
02/02/2011 06:17AM
500,000 rows - Slow when maintaining  
3,622
Erik Nord
01/20/2011 01:00AM
Re: 500,000 rows - Slow when maintaining  
1,248
Rick James
01/20/2011 10:55PM
Re: 500,000 rows - Slow when maintaining  
1,289
Vlad Pilly
01/20/2011 04:58AM
Re: 500,000 rows - Slow when maintaining  
1,274
Erik Nord
01/20/2011 12:17PM
Query Tuning for NOT EQUAL TO <> operator  
10,675
Irfan Ali
10/22/2010 07:42AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,548
Vlad Pilly
01/19/2011 11:33AM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,468
Rick James
10/26/2010 10:40PM
Re: Query Tuning for NOT EQUAL TO <> operator  
2,131
Irfan Ali
10/31/2010 01:50PM
Re: Query Tuning for NOT EQUAL TO <> operator  
3,587
Rick James
11/02/2010 02:21PM
Field calculated using the WHERE  
2,888
Michael Silva
01/13/2011 03:22PM
Re: Field calculated using the WHERE  
1,244
Rick James
01/15/2011 12:42AM
identifying unused databases  
6,021
kannan Mohan
12/27/2010 10:31PM
Re: identifying unused databases  
2,303
kannan Mohan
01/12/2011 10:31PM
Re: identifying unused databases  
1,835
Rick James
01/15/2011 12:08AM
Re: identifying unused databases  
2,593
Rick James
12/31/2010 08:26PM
Explain shows different results on two servers  
4,245
Tomasz Wilk
01/10/2011 05:08PM
Re: Explain shows different results on two servers  
1,728
Rick James
01/14/2011 08:50AM
Optimizing query with having and count  
2,420
bw h ontwerpers
01/13/2011 05:58AM
same query sometimes very slow (punbb forum)  
5,487
Gennadiy Barvinok
01/06/2011 03:41AM
Re: same query sometimes very slow (punbb forum)  
1,928
Rick James
01/07/2011 11:03PM
optimize select query  
3,145
Robert Koziol
12/30/2010 10:59AM
Re: optimize select query  
1,347
Rick James
12/31/2010 08:22PM
Re: optimize select query  
1,460
Robert Koziol
01/04/2011 04:07AM
Re: optimize select query  
1,670
Rick James
01/06/2011 09:37PM
Re: optimize select query  
1,523
Robert Koziol
01/03/2011 01:02PM
Please help optimizing a long running query (left outer join, with 2 subqueries)  
2,477
arif bandali
12/31/2010 01:19AM
Re: Please help optimizing a long running query (left outer join, with 2 subqueries)  
1,431
Rick James
01/01/2011 07:21PM
SQL SELECT COUNT(*) TO SLOW  
4,045
Jim Louch
12/21/2010 02:28PM
Re: SQL SELECT COUNT(*) TO SLOW  
1,884
Rick James
12/26/2010 11:15AM
How to Optimize these sql?  
2,099
Gucci Koo
12/10/2010 04:02AM
Re: How to Optimize these sql?  
1,008
Rick James
12/11/2010 02:17PM
basic 2 table query slow - where, index?  
2,605
Matt S
12/01/2010 02:55PM
Re: basic 2 table query slow - where, index?  
1,282
Rick James
12/05/2010 12:56PM
"Optimizing sub queries with joins"  
3,110
SUNIL KUMAR
12/01/2010 10:42PM
Re: "Optimizing sub queries with joins"  
1,469
Rick James
12/05/2010 12:45PM
Optimized Indexing for a Schedule Table  
3,777
Wes Thompson
11/23/2010 11:58PM
Re: Optimized Indexing for a Schedule Table  
1,235
Rick James
11/25/2010 02:35PM
Re: Optimized Indexing for a Schedule Table  
1,864
Wes Thompson
11/25/2010 10:47PM
Re: Optimized Indexing for a Schedule Table  
1,295
Wes Thompson
11/25/2010 11:05PM
Re: Optimized Indexing for a Schedule Table  
1,746
Rick James
11/26/2010 01:42PM
Re: Optimized Indexing for a Schedule Table  
1,367
Wes Thompson
11/26/2010 11:36PM
Re: Optimized Indexing for a Schedule Table  
1,462
Rick James
11/27/2010 01:31PM
Re: Optimized Indexing for a Schedule Table  
1,376
Wes Thompson
11/27/2010 02:44PM
slow query sorting on group maximum  
3,413
Dong Hoon Van Uytsel
11/05/2010 09:11AM
Re: slow query sorting on group maximum  
1,438
Dong Hoon Van Uytsel
11/19/2010 04:30PM
Re: slow query sorting on group maximum  
1,304
Rick James
11/19/2010 07:14PM
Re: slow query sorting on group maximum  
1,548
Dong Hoon Van Uytsel
11/22/2010 03:35AM
Re: slow query sorting on group maximum  
1,912
Rick James
11/19/2010 07:05PM
Re: slow query sorting on group maximum  
1,299
Rick James
11/19/2010 07:20PM
Re: slow query sorting on group maximum  
1,222
Dong Hoon Van Uytsel
11/22/2010 03:33AM
Re: slow query sorting on group maximum  
1,366
Rick James
11/06/2010 10:56AM
Re: slow query sorting on group maximum  
1,309
Dong Hoon Van Uytsel
11/07/2010 07:24AM
Re: slow query sorting on group maximum  
1,379
Rick James
11/07/2010 01:05PM
Optimizing queries with Wildcards  
3,590
George K
11/19/2010 08:54AM
Re: Optimizing queries with Wildcards  
1,224
Rick James
11/20/2010 11:23AM
may databases or may tables  
2,023
kevin smith
11/18/2010 10:18PM
Re: many databases or many tables  
1,238
Rick James
11/20/2010 09:28AM
'not in' query is very slow how to change it?  
6,416
kevin smith
11/15/2010 09:01AM
Re: 'not in' query is very slow how to change it?  
3,553
Rick James
11/18/2010 12:59AM
Re: 'not in' query is very slow how to change it?  
2,221
kevin smith
11/18/2010 10:19PM
High Mysql Load - CPU 360%  
3,004
i Linux85
11/14/2010 11:41AM
Re: High Mysql Load - CPU 360%  
1,240
Rick James
11/18/2010 01:22AM
Dynamic Queries Optimization  
2,523
Irfan Ali
11/15/2010 01:51PM
Re: Dynamic Queries Optimization  
1,474
Rick James
11/18/2010 12:46AM
Way of incerasing web traffic  
2,185
Biswajit Saha
11/14/2010 09:40AM
Can MySQL use index in a RANGE QUERY with ORDER BY?  
2,717
John Smith
11/02/2010 07:53PM
Re: Can MySQL use index in a RANGE QUERY with ORDER BY?  
1,460
Rick James
11/03/2010 09:17PM
Slow Queries : Using Temporary , Using Filesort  
7,061
Irfan Ali
10/22/2010 06:41AM
Re: Slow Queries : Using Temporary , Using Filesort  
2,408
Rick James
10/26/2010 10:37PM
Re: Slow Queries : Using Temporary , Using Filesort  
3,122
Irfan Ali
10/30/2010 03:42PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,503
Rick James
11/02/2010 12:23PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,789
Rick James
10/26/2010 10:32PM
Re: Slow Queries : Using Temporary , Using Filesort  
2,409
Irfan Ali
10/30/2010 03:29PM
Normalise and optimise- Urgent  
2,397
raj uni
10/27/2010 08:27PM
Re: Normalise and optimise- Urgent  
1,119
Rick James
10/28/2010 09:44PM
Slow query  
2,350
Dave Titan
10/23/2010 03:27AM
Re: Slow query  
1,090
Rick James
10/26/2010 10:42PM
Optimiztion of LEFT JOIN and LIMIT  
3,623
Sopace Sopcae
10/05/2010 01:33PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,451
Sopace Sopcae
10/05/2010 02:21PM
Re: Optimiztion of LEFT JOIN and LIMIT  
1,979
Rick James
10/06/2010 09:11PM
Database error : too many connectons  
2,122
abdelrahman ellithy
09/13/2010 05:25AM
Re: Database error : too many connectons  
1,588
Rick James
09/14/2010 07:58AM
NOP optimises Group By?  
3,979
Peter Griffioen
09/05/2010 08:16PM
Re: NOP optimises Group By?  
1,375
Rick James
09/11/2010 01:22PM
Re: NOP optimises Group By? -solved  
1,610
Peter Griffioen
09/12/2010 11:09PM
Re: NOP optimises Group By? -solved  
1,442
Peter Griffioen
09/13/2010 08:15PM
Re: NOP optimises Group By? -solved  
1,366
Rick James
09/13/2010 10:46PM
Re: NOP optimises Group By? -solved  
1,428
Rick James
09/13/2010 10:56AM
how to avoir filesort and temporary with theses 2 little tables ?  
2,197
yannick simon
09/07/2010 06:33AM
Re: how to avoir filesort and temporary with theses 2 little tables ?  
1,060
Rick James
09/09/2010 11:49PM
left join with sum and group by  
24,059
Andreas Schmidt
08/18/2010 05:46AM
Re: left join with sum and group by  
8,397
Rick James
08/20/2010 11:40PM
Re: left join with sum and group by  
4,543
Andreas Schmidt
08/23/2010 04:26AM
Re: left join with sum and group by  
6,632
Rick James
08/27/2010 08:01PM
Re: left join with sum and group by  
4,057
Andreas Schmidt
09/07/2010 05:08AM
Query cache was never filled up  
3,872
Reynard H
08/28/2010 09:58AM
Re: Query cache was never filled up  
1,501
Rick James
08/29/2010 09:25PM
Speed problem  
2,622
sridhar subramaniam
08/25/2010 03:33AM
Re: Speed problem  
1,229
Rick James
08/27/2010 08:03AM
SQL CACHE Not used. When it should be?  
3,510
James Barwick
08/10/2010 12:41AM
Re: SQL CACHE Not used. When it should be?  
1,958
Rick James
08/17/2010 08:34AM
Optimize: most recent N items with join  
2,813
Scott Gatz
08/03/2010 01:49PM
Re: Optimize: most recent N items with join  
1,369
Rick James
08/08/2010 10:35AM
Query Optimization on time-based data  
3,583
Greg Smith
08/03/2010 10:06AM
Re: Query Optimization on time-based data  
2,319
Rick James
08/05/2010 10:35PM
Advice on indexing a datetime column  
27,337
Michaël Ball
07/23/2010 08:56AM
Re: Advice on indexing a datetime column  
11,399
Jonathon Coombes
07/24/2010 09:58PM
Re: Advice on indexing a datetime column  
8,517
Michaël Ball
07/25/2010 02:01AM
Re: Advice on indexing a datetime column  
7,553
Rick James
07/27/2010 10:29PM
Estimating Index Size on Innodb Tables  
11,365
Paulo Victor Maluf Alves
07/26/2010 01:49PM
Re: Estimating Index Size on Innodb Tables  
4,194
Rick James
07/27/2010 08:08PM
Optimize my my.ini  
9,890
Mohamad Bataineh
07/22/2010 11:20AM
Re: Optimize my my.ini  
2,711
Rick James
07/25/2010 10:26PM
Help Optimizing My SELECT Query  
2,863
gooey graphics
07/19/2010 12:54PM
Re: Help Optimizing My SELECT Query  
1,301
Rick James
07/21/2010 01:06PM
Analyze question  
4,744
Dorian Kuroki
07/13/2010 03:30PM
Re: Analyze question  
1,576
Rick James
07/14/2010 10:48PM
Re: Analyze question  
1,710
Dorian Kuroki
07/15/2010 11:26AM
Re: Analyze question  
1,534
Rick James
07/15/2010 08:54PM
query executes slowly in a table with 2m records  
3,044
Zheng Li
07/13/2010 08:38AM
Re: query executes slowly in a table with 2m records  
1,469
Rick James
07/14/2010 11:12PM
Analyze and cardinality  
3,700
Dorian Kuroki
07/14/2010 10:50AM
Can we write one query instead of following three query?  
2,595
sunil divyeshvar
07/08/2010 01:44AM
Re: Can we write one query instead of following three query?  
1,291
Rick James
07/11/2010 11:47PM
multicolumn index & forcing index to avoid filesort  
4,041
Paolo Barroni
07/04/2010 09:30AM
Re: multicolumn index & forcing index to avoid filesort  
1,738
Rick James
07/05/2010 11:58PM
sub query  
2,902
lavanya kv
07/01/2010 05:33AM
Re: sub query  
1,492
Rick James
07/02/2010 09:01PM
Re: sub query  
1,414
lavanya kv
07/02/2010 10:39PM
Query needs to be optimized  
3,143
ponvictor abraham
06/29/2010 03:39AM
Re: Query needs to be optimized  
1,488
Rick James
06/30/2010 08:50AM
Re: Query needs to be optimized  
1,811
ponvictor abraham
07/01/2010 12:28AM
Re: Query needs to be optimized  
1,410
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.