MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic
Pages:
« 1
...
8 9 10 11 12
...
19 »

Subject
Views
Written By
Posted
Query/table structure optimization CHALLENGE!  
3,489
Olli S
02/06/2010 06:53PM
Re: Query/table structure optimization CHALLENGE!  
1,792
Rick James
02/07/2010 09:34PM
View Optimization using Aggregation Functions  
3,785
Kevin Harms
02/03/2010 05:00PM
Re: View Optimization using Aggregation Functions  
1,510
Rick James
02/05/2010 11:50PM
Optimizer slow on large number of sub-queries  
3,339
Tim Brody
01/29/2010 08:42AM
Re: Optimizer slow on large number of sub-queries  
1,681
Rick James
01/30/2010 07:26PM
Re: Optimizer slow on large number of sub-queries  
1,824
Tim Brody
01/31/2010 05:43AM
Re: Optimizer slow on large number of sub-queries  
1,540
Rick James
01/31/2010 06:04PM
Query optimizer - cost estimation  
4,759
John Edwards
01/28/2010 01:38PM
Re: Query optimizer - cost estimation  
2,011
Rick James
01/30/2010 07:37PM
Trying to use EXPLAIN to optimize this small example  
5,179
Steven Mac
01/28/2010 10:15AM
Re: Trying to use EXPLAIN to optimize this small example  
1,872
Rick James
01/30/2010 07:36PM
Simple join uses temptables and filesort, why?  
6,501
Reine n/a
01/25/2010 04:52AM
Re: Simple join uses temptables and filesort, why?  
2,737
Rick James
01/26/2010 10:13PM
'check table' changes indexes used in query?  
4,223
Rene Churchill
01/20/2010 09:49PM
Re: 'check table' changes indexes used in query?  
1,899
Rick James
01/24/2010 11:16PM
Re: 'check table' changes indexes used in query?  
2,014
Rene Churchill
01/25/2010 09:06AM
Re: 'check table' changes indexes used in query?  
1,906
Rick James
01/25/2010 11:15AM
Efficient way to get list of first letter of fields?  
11,449
Scott Mueller
01/01/2010 06:17AM
Re: Efficient way to get list of first letter of fields?  
3,986
Rick James
01/02/2010 10:42PM
Re: Efficient way to get list of first letter of fields?  
3,848
Scott Mueller
01/03/2010 02:28AM
Re: Efficient way to get list of first letter of fields?  
3,721
Rick James
01/03/2010 11:07AM
Re: Efficient way to get list of first letter of fields?  
3,075
Scott Mueller
01/09/2010 03:31AM
Re: Efficient way to get list of first letter of fields?  
2,898
Rick James
01/10/2010 03:36PM
Simple query, but slow one.  
3,668
Laurent Thoulon
12/01/2009 04:30AM
Re: Simple query, but slow one.  
2,161
Rick James
12/05/2009 11:37PM
Re: Simple query, but slow one.  
2,150
Laurent Thoulon
12/09/2009 09:33AM
Re: Simple query, but slow one.  
2,002
Rick James
12/10/2009 11:13PM
Re: Simple query, but slow one.  
2,008
Laurent Thoulon
12/14/2009 07:17AM
Re: Simple query, but slow one.  
1,976
Rick James
12/22/2009 11:47AM
Re: Simple query, but slow one.  
1,969
Laurent Thoulon
01/04/2010 05:25AM
Re: Simple query, but slow one.  
1,964
Rick James
01/04/2010 10:39AM
Re: Simple query, but slow one.  
1,904
Laurent Thoulon
01/04/2010 11:01AM
Re: Simple query, but slow one.  
1,995
Rick James
01/04/2010 11:47PM
Re: Simple query, but slow one.  
1,898
Laurent Thoulon
01/05/2010 03:11AM
Re: Simple query, but slow one.  
2,012
Rick James
01/05/2010 09:23AM
calculating total products in each category  
5,013
tep .
12/16/2009 04:26AM
Re: calculating total products in each category  
2,106
tep .
12/17/2009 09:58AM
Re: calculating total products in each category  
2,275
Paul Nichitoiu
12/18/2009 07:46AM
Re: calculating total products in each category  
2,363
tep .
12/18/2009 07:50AM
Re: calculating total products in each category  
2,114
Rick James
12/29/2009 09:54PM
Re: calculating total products in each category  
2,360
tep .
12/30/2009 02:35AM
Re: calculating total products in each category  
2,188
Rick James
12/30/2009 08:09PM
Re: calculating total products in each category  
2,561
tep .
12/31/2009 12:39AM
Re: calculating total products in each category  
5,184
tep .
12/31/2009 01:42AM
Re: calculating total products in each category  
3,461
tep .
01/04/2010 08:13AM
Re: calculating total products in each category  
2,114
tep .
12/23/2009 08:15AM
Web Speed ???  
2,975
Frank Regufluid
01/03/2010 12:15AM
Re: Web Speed ???  
1,869
David Lee
01/04/2010 08:00AM
Re: Web Speed ???  
1,772
Rick James
01/03/2010 05:34PM
Query optimization issue  
3,493
dhiraj kumar
12/29/2009 07:54AM
Re: Query optimization issue  
1,863
Jonathon Coombes
12/29/2009 09:46PM
Re: Query optimization issue  
1,709
Rick James
12/30/2009 12:21AM
General Question: Multi Query Optimization in MySql  
4,145
Martin Dürre
11/30/2009 07:34AM
Re: General Question: Multi Query Optimization in MySql  
2,206
Rick James
12/05/2009 11:42PM
Re: General Question: Multi Query Optimization in MySql  
2,165
abdelrahman ellithy
12/27/2009 05:45AM
Re: General Question: Multi Query Optimization in MySql  
2,225
Martin Dürre
12/07/2009 06:11AM
Re: General Question: Multi Query Optimization in MySql  
1,982
Rick James
12/11/2009 12:04AM
problem about slow_query in log  
3,897
h ch
12/25/2009 02:59AM
Re: problem about slow_query in log  
1,831
Rick James
12/26/2009 12:02PM
Query optimisation help  
2,735
Paul Smith
12/18/2009 08:30AM
Re: Query optimisation help  
1,775
Rick James
12/22/2009 10:03PM
Re: Query optimisation help  
1,802
12/23/2009 02:46AM
question about DATE,TIME,and DATETIME  
3,097
h ch
12/16/2009 08:22PM
Re: question about DATE,TIME,and DATETIME  
1,829
Rick James
12/22/2009 10:04PM
full table scan for limit??  
5,955
h ch
12/15/2009 01:49AM
Re: full table scan for limit??  
2,894
Rick James
12/22/2009 12:04PM
Get 200K x PR0 Backlinks (Permanent) on 200K Different Domains & Different IPs.  
5,232
tirtha roy
12/08/2009 12:35AM
query hangs in 'statistics' state  
5,303
jan koum
11/29/2009 02:16AM
Re: query hangs in 'statistics' state  
2,611
Rick James
12/05/2009 11:46PM
Configuration of open_files_limit  
7,707
Paul Rosier
12/02/2009 03:33AM
Re: Configuration of open_files_limit  
3,382
Rick James
12/05/2009 04:33PM
Query giving slow performance.  
3,103
Lokesh Kumar
11/24/2009 05:13AM
Re: Query giving slow performance.  
1,613
Rick James
11/25/2009 11:19PM
Unexpected behavior of the optimizer  
3,067
11/20/2009 10:02AM
Re: Unexpected behavior of the optimizer  
1,556
Rick James
11/24/2009 11:58PM
Simple select very slow  
4,268
thierry fournier
11/15/2009 07:37AM
Re: Simple select very slow  
2,113
Rick James
11/18/2009 07:37PM
Configure MySQL For Largest Data  
2,869
ali mokhlesi
11/11/2009 09:01AM
Re: Configure MySQL For Largest Data  
1,751
Rick James
11/18/2009 07:03PM
optimizing query  
3,371
kavitha L
11/10/2009 01:19AM
Re: optimizing query  
2,104
Rick James
11/18/2009 04:42PM
Re: optimizing query  
1,879
kavitha L
11/10/2009 01:24AM
Search Engine Optimization Services  
3,423
Arber Technologies
11/09/2009 03:31AM
Update table slower in trigger than in procedure. Is this possible?  
3,684
Emilio Nicolás
10/28/2009 12:31PM
Re: Update table slower in trigger than in procedure. Is this possible?  
2,411
Emilio Nicolás
11/02/2009 07:14AM
Re: Update table slower in trigger than in procedure. Is this possible?  
2,008
Rick James
11/03/2009 10:15AM
Query is so slow  
4,264
Fitsum Tesfagiorgis
10/30/2009 08:45AM
Re: Query is so slow  
2,130
Rick James
10/31/2009 10:19AM
Re: Query is so slow  
2,125
Fitsum Tesfagiorgis
11/01/2009 09:49PM
Re: Query is so slow  
2,114
Rick James
11/02/2009 10:45AM
Re: Query is so slow  
2,029
Fitsum Tesfagiorgis
11/02/2009 02:22PM
Re: Query is so slow  
2,123
Fitsum Tesfagiorgis
10/31/2009 03:49PM
SELECT on indexed key is slow  
3,569
Francois Mazerolle
10/28/2009 08:39AM
Re: SELECT on indexed key is slow  
1,975
Rick James
10/29/2009 10:08PM
i have a big table,how can i reduce it's size?  
5,173
h ch
10/27/2009 02:50AM
Re: i have a big table,how can i reduce it's size?  
3,106
Rick James
10/28/2009 10:12PM
Very Large Non-Dynamic Table for Lookups  
4,241
Eidetic Hans
10/23/2009 05:46PM
Re: Very Large Non-Dynamic Table for Lookups  
2,038
Rick James
10/24/2009 08:02PM
Re: Very Large Non-Dynamic Table for Lookups  
2,137
Eidetic Hans
10/24/2009 08:55PM
Re: Very Large Non-Dynamic Table for Lookups  
2,221
Rick James
10/24/2009 10:50PM
Re: Very Large Non-Dynamic Table for Lookups  
2,138
Eidetic Hans
10/25/2009 11:23AM
Re: Very Large Non-Dynamic Table for Lookups  
2,238
Rick James
10/25/2009 12:32PM
Re: Very Large Non-Dynamic Table for Lookups  
2,268
Eidetic Hans
10/26/2009 12:19PM
Re: Very Large Non-Dynamic Table for Lookups  
2,380
Rick James
10/26/2009 08:03PM
Optimizer doesn't use PRIMARY key  
4,060
Michal Kozusznik
10/24/2009 07:51AM
Re: Optimizer doesn't use PRIMARY key  
2,089
Rick James
10/25/2009 10:11AM
Re: Optimizer doesn't use PRIMARY key  
2,153
Michal Kozusznik
10/25/2009 06:04PM
Re: Optimizer doesn't use PRIMARY key  
2,162
Rick James
10/25/2009 07:08PM
Re: Optimizer doesn't use PRIMARY key  
2,340
Michal Kozusznik
10/26/2009 06:51PM
My.ini performance  
6,128
Dozer Redoz
10/22/2009 02:52AM
Re: My.ini performance  
2,419
Rick James
10/23/2009 10:05PM
simple JOIN with sub SELECT strangeness  
4,715
Fabien Fab
10/19/2009 03:19AM
Re: simple JOIN with sub SELECT strangeness  
2,140
Rick James
10/20/2009 08:46AM
Re: simple JOIN with sub SELECT strangeness  
2,228
Fab Ien
10/21/2009 01:56AM
Re: simple JOIN with sub SELECT strangeness  
2,143
Rick James
10/21/2009 08:52PM
query en grandes tablas  
3,226
leonardo sandoval
10/20/2009 12:57PM
Simple query vs. large table  
4,290
Marat Rysbekov
10/07/2009 04:00AM
Re: Simple query vs. large table  
2,154
leonardo sandoval
10/20/2009 12:56PM
Re: Simple query vs. large table  
2,139
Rick James
10/08/2009 07:05PM
My.cnf optimizer  
6,142
alissonx alisson
10/13/2009 08:19AM
Re: My.cnf optimizer  
2,419
Rick James
10/14/2009 06:29PM
Re: My.cnf optimizer  
2,656
alissonx alisson
10/15/2009 06:45AM
Re: My.cnf optimizer  
2,444
Rick James
10/15/2009 07:10AM
Re: My.cnf optimizer  
2,213
alissonx alisson
10/15/2009 07:36AM
Re: My.cnf optimizer  
2,861
alissonx alisson
10/15/2009 07:40AM
Re: My.cnf optimizer  
2,337
Rick James
10/15/2009 10:53AM
LEFT JOIN, GROUP BY, ORDER BY  
5,990
Dmitry Piramidin
10/13/2009 12:44AM
Re: LEFT JOIN, GROUP BY, ORDER BY  
3,679
Rick James
10/14/2009 06:40PM
Need help for query optimization  
2,953
shripad kulkarni
10/08/2009 04:59AM
Re: Need help for query optimization  
1,901
Rick James
10/10/2009 10:16PM
how to increase delete speed?  
3,949
shinichi son
10/09/2009 02:25AM
Re: how to increase delete speed?  
2,730
Rick James
10/10/2009 11:31AM
Deadlock on different Tables without recycled tables reference  
2,805
wenew zhang
10/01/2009 10:06PM
Help for query optimization  
3,603
Vladimir Goncharov
09/23/2009 10:53AM
Re: Help for query optimization  
2,061
Rick James
09/25/2009 11:54PM
Re: Help for query optimization  
1,996
Vladimir Goncharov
09/24/2009 01:54PM
Cardinality Estimation in Joins  
3,734
Rakshit Trivedi
09/16/2009 12:48AM
PRIMARY key not used on join  
4,786
Joao Assad
09/10/2009 09:14AM
Re: PRIMARY key not used on join  
2,290
Rick James
09/11/2009 06:45PM
Re: PRIMARY key not used on join  
2,266
Joao Assad
09/15/2009 02:58PM
Query taking long time to execute.  
3,678
Saurabh Bagchi
09/14/2009 02:32AM
Re: Query taking long time to execute.  
2,878
Rick James
09/15/2009 08:42AM
ORDER BY. Cannot get rid of 'filesort' in EXPLAIN  
4,957
Ruslan Osmanov
09/13/2009 04:16AM
Re: ORDER BY. Cannot get rid of 'filesort' in EXPLAIN  
2,514
Rick James
09/14/2009 10:00AM
Classic join w/ criteria on multi tables and correct key selection  
3,830
Keith Humm
09/09/2009 07:04PM
Re: Classic join w/ criteria on multi tables and correct key selection  
2,262
Rick James
09/10/2009 10:29PM
Statistics used by optimizer.  
6,846
Rakshit Trivedi
08/28/2009 07:32AM
Re: Statistics used by optimizer.  
2,781
Rick James
08/29/2009 01:11PM
Re: Statistics used by optimizer.  
2,642
Rakshit Trivedi
09/01/2009 06:30AM
Re: Statistics used by optimizer.  
2,593
Rick James
09/01/2009 07:44AM
Re: Statistics used by optimizer.  
2,650
Rakshit Trivedi
09/01/2009 02:51PM
Re: Statistics used by optimizer.  
2,432
Rick James
09/01/2009 09:59PM
Re: Statistics used by optimizer.  
2,563
Rakshit Trivedi
09/04/2009 11:00AM
Re: Statistics used by optimizer.  
2,527
Rick James
09/04/2009 07:37PM
query takes too much time  
3,666
alev mutlu
08/31/2009 09:26AM
Re: query takes too much time  
2,124
Rick James
09/01/2009 10:34PM
Query is taking lot of time with not in clause  
4,056
shahbaz khan
08/16/2009 05:06AM
Re: Query is taking lot of time with not in clause  
2,617
Rick James
08/17/2009 09:56AM
Re: Query is taking lot of time with not in clause  
2,752
shahbaz khan
08/18/2009 02:06AM
Re: Query is taking lot of time with not in clause  
2,707
shahbaz khan
08/18/2009 02:09AM
Re: Query is taking lot of time with not in clause  
3,005
Rick James
08/18/2009 06:20PM
Re: Query is taking lot of time with not in clause  
2,760
shahbaz khan
08/19/2009 01:54AM
Re: Query is taking lot of time with not in clause  
2,480
shahbaz khan
08/19/2009 04:54AM
Re: Query is taking lot of time with not in clause  
2,677
shahbaz khan
08/19/2009 05:01AM
Re: Query is taking lot of time with not in clause  
2,458
shahbaz khan
08/19/2009 05:57AM
Re: Query is taking lot of time with not in clause  
2,608
Rick James
08/19/2009 09:25AM
Re: Query is taking lot of time with not in clause  
2,620
shahbaz khan
08/20/2009 12:32AM
Re: Query is taking lot of time with not in clause  
2,558
Rick James
08/20/2009 09:57AM
Re: Query is taking lot of time with not in clause  
2,579
shahbaz khan
08/22/2009 05:32AM
Re: Query is taking lot of time with not in clause  
2,564
Rick James
08/22/2009 05:25PM
Re: Query is taking lot of time with not in clause  
2,643
shahbaz khan
08/23/2009 01:19AM
Re: Query is taking lot of time with not in clause  
2,877
Rick James
08/23/2009 09:43AM
Re: Query is taking lot of time with not in clause  
2,302
shahbaz khan
08/23/2009 11:56PM
Re: Query is taking lot of time with not in clause  
2,506
Rick James
08/24/2009 09:05AM
Re: Query is taking lot of time with not in clause  
2,544
shahbaz khan
08/24/2009 12:12PM
Re: Query is taking lot of time with not in clause  
2,303
Rick James
08/24/2009 05:20PM
Pages:
« 1
...
8 9 10 11 12
...
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.