Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
• MySQL Connector/Net 6.3.3 has been released 07/27/2010 02:58PM
• MySQL Community Server 5.1.49 has been released 07/23/2010 07:55AM
• MySQL Community Server 5.5.5-m3 has been released 07/19/2010 02:28AM
Pages:  1 2 3 4 5 ...LastNext
Current Page: 1 of 51
Subject Views Written By Posted
Sticky:  MySQL 5.5 + InnoDB 1.1: Performance & Scalability (1 Posts)   766 Edwin DeSouza 04/19/2010 10:07PM
Sticky:  MySQL Performance Schema (Worklog #2360) (1 Posts)   2,995 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Best Practices, FAQs, How-To, Articles, Blogs (2 Posts)   44,651 Edwin DeSouza 05/25/2006 10:50AM
Query that takes too much time to execute by using function   15 sunil divyeshvar 07/31/2010 04:05AM
Performance issue   109 ashr ben 07/26/2010 11:24AM
Re: Performance issue   31 Rick James 07/27/2010 08:42PM
Re: Performance issue   25 ashr ben 07/28/2010 09:56AM
Re: Performance issue   24 Rick James 07/28/2010 08:43PM
Re: Performance issue   20 ashr ben 07/28/2010 09:35PM
Re: Performance issue   30 Rick James 07/28/2010 10:02PM
Re: Performance issue   12 ashr ben 07/30/2010 03:47PM
Bad performance, quick pointers?   38 Tim Grayson 07/30/2010 09:17AM
MySQL server configuration for a 8 cpu+20gb RAM server   1,238 josé renato milanez 05/13/2010 10:17AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   462 ivo welch 06/01/2010 03:06PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   419 Rick James 06/01/2010 07:48PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   144 Mayur P Vegad 07/07/2010 08:54AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   98 Ahamed kabeer 07/23/2010 05:40AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   61 Rick James 07/25/2010 11:26PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   52 Ahamed kabeer 07/26/2010 12:28AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   37 Rick James 07/26/2010 10:53PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   35 Ahamed kabeer 07/26/2010 11:26PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   36 Rick James 07/27/2010 09:06AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   390 ivo welch 06/02/2010 06:24AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   599 Rick James 05/14/2010 06:40PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   584 josé renato milanez 05/15/2010 06:15AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   551 Rick James 05/15/2010 07:35AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   515 josé renato milanez 05/15/2010 11:34AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server   514 Rick James 05/15/2010 01:06PM
MySQL Command is causing massive load and slowing site down - need help   238 Marc M 07/14/2010 11:23PM
Re: MySQL Command is causing massive load and slowing site down - need help   84 Marc M 07/15/2010 05:07PM
Re: MySQL Command is causing massive load and slowing site down - need help   25 Rick James 07/26/2010 11:45PM
View Query Cache   161 Wim De Saegher 07/22/2010 03:17AM
Re: View Query Cache   36 Rick James 07/25/2010 10:27PM
Re: View Query Cache   27 Wim De Saegher 07/26/2010 05:00AM
Improve Performance Large Number of Queries to Build Web Page   211 James Cobban 07/16/2010 08:52AM
Re: Improve Performance Large Number of Queries to Build Web Page   36 Rick James 07/25/2010 10:47PM
Optimize my my.ini   188 Mohamad Bataineh 07/22/2010 11:21AM
Re: Optimize my my.ini   50 Rick James 07/25/2010 10:26PM
Slow Query Lock_time   160 Syed Hashmi 07/23/2010 03:03AM
Re: Slow Query Lock_time   39 Rick James 07/25/2010 10:22PM
key cache is low on 2 of 6 slaves   179 Fotios Smyrnis 07/21/2010 06:54PM
Re: key cache is low on 2 of 6 slaves   29 Rick James 07/25/2010 10:18PM
Wich is better? "SELECT *" or "SELECT <list of columns>"   379 roberto falanga 07/01/2010 10:04AM
Re: Wich is better? "SELECT *" or "SELECT <list of columns>"   53 Wim De Saegher 07/22/2010 03:25AM
Re: Wich is better? "SELECT *" or "SELECT <list of columns>"   153 Rick James 07/03/2010 12:58AM
Re: Wich is better? "SELECT *" or "SELECT <list of columns>"   131 Craig Logan 07/03/2010 07:18AM
COUNT(*) very slowly in large InnoDB table   309 Dominik Leiner 07/13/2010 11:43AM
Re: COUNT(*) very slowly in large InnoDB table   104 Rick James 07/14/2010 11:04PM
Re: COUNT(*) very slowly in large InnoDB table   66 wayne r 07/20/2010 10:38PM
Re: COUNT(*) very slowly in large InnoDB table   62 Rick James 07/21/2010 12:11PM
Re: COUNT(*) very slowly in large InnoDB table   57 Wim De Saegher 07/22/2010 03:23AM
Re: COUNT(*) very slowly in large InnoDB table   56 abilash vs 07/21/2010 11:52AM
Re: COUNT(*) very slowly in large InnoDB table   109 Dominik Leiner 07/15/2010 02:24AM
Re: COUNT(*) very slowly in large InnoDB table   127 Rick James 07/15/2010 08:51AM
Re: COUNT(*) very slowly in large InnoDB table   90 Dominik Leiner 07/15/2010 09:48AM
Re: COUNT(*) very slowly in large InnoDB table   98 Rick James 07/15/2010 09:09PM
Re: COUNT(*) very slowly in large InnoDB table   88 Dominik Leiner 07/16/2010 12:58AM
Re: COUNT(*) very slowly in large InnoDB table   88 abilash vs 07/19/2010 12:18PM
Re: COUNT(*) very slowly in large InnoDB table   86 Dominik Leiner 07/19/2010 12:45PM
Re: COUNT(*) very slowly in large InnoDB table   70 abilash vs 07/19/2010 09:25PM
Binary Flag Index   211 Duncan Gray 07/18/2010 05:26AM
Re: Binary Flag Index   71 Rick James 07/21/2010 02:08PM
Poor performance on very large table   186 07/20/2010 08:53AM
Re: Poor performance on very large table   77 Rick James 07/21/2010 12:19PM
Re: Poor performance on very large table   59 07/21/2010 01:45PM
nolog option with DML   309 Abrar Ahmad 07/13/2010 12:20AM
Re: nolog option with DML   115 Rick James 07/14/2010 11:20PM
Re: nolog option with DML   90 Abrar Ahmad 07/18/2010 01:37PM
Re: nolog option with DML   59 Rick James 07/21/2010 12:31PM
MySQL4.1 CPU usage at 99.9% even when idle on Gentoo Linux 1.4.16   233 Daniel Adams 07/15/2010 04:13AM
Re: MySQL4.1 CPU usage at 99.9% even when idle on Gentoo Linux 1.4.16   84 Rick James 07/16/2010 10:51AM
Strange Index Choice Behavior   291 Ben Smith 07/09/2010 01:44PM
Re: Strange Index Choice Behavior   102 Rick James 07/10/2010 06:33PM
Re: Strange Index Choice Behavior   67 Sunil Ramesh 07/16/2010 03:06AM
Re: Strange Index Choice Behavior   66 Rick James 07/16/2010 10:34AM
Temporarily down   228 Fotis Andritsopoulos 07/14/2010 01:59AM
Re: Temporarily down   63 Rick James 07/15/2010 11:27PM
Re: Temporarily down   82 Dominik Leiner 07/14/2010 11:25AM
Select query on a join of tables very slow   360 Nitya Thacker 07/12/2010 01:50PM
Re: Select query on a join of tables very slow   77 Nitya Thacker 07/14/2010 12:49PM
Re: Select query on a join of tables very slow   71 Rick James 07/14/2010 10:29PM
Re: Select query on a join of tables very slow   89 Rick James 07/13/2010 07:03PM
Replica with Virtual Servers Xen   246 Alberto Moreno 07/10/2010 02:30PM
Re: Replica with Virtual Servers Xen   83 Rick James 07/13/2010 09:37AM
Preformance: Bulk Insert with one Index   310 Shary M 07/09/2010 09:08PM
Re: Preformance: Bulk Insert with one Index   109 Shawn Taylor 07/13/2010 07:38AM
Re: Preformance: Bulk Insert with one Index   86 Shary M 07/11/2010 03:52PM
Re: Preformance: Bulk Insert with one Index   95 Rick James 07/11/2010 11:39PM
Re: Preformance: Bulk Insert with one Index   87 Rick James 07/10/2010 11:10PM
Index drops automatically   406 sunil divyeshvar 06/20/2010 11:20PM
Re: Index drops automatically   191 Rick James 06/22/2010 01:27AM
Re: Index drops automatically   183 sunil divyeshvar 06/22/2010 03:39AM
Re: Index drops automatically   182 Rick James 06/22/2010 10:05PM
Re: Index drops automatically   199 sunil divyeshvar 06/22/2010 11:47PM
Re: Index drops automatically   171 Rick James 06/23/2010 09:51AM
Re: Index drops automatically   178 sunil divyeshvar 06/24/2010 12:41AM
Re: Index drops automatically   85 Mayur P Vegad 07/12/2010 04:44AM
1,500 (0.008) second queries adds up to 16 seconds   238 nathan cobb 07/10/2010 10:20PM
Re: 1,500 (0.008) second queries adds up to 16 seconds   86 Rick James 07/11/2010 12:21PM
A second consecutive insert into statement takes forever   329 Daniel Croona 07/04/2010 12:35AM
Re: A second consecutive insert into statement takes forever   137 Daniel Croona 07/05/2010 12:03AM
Re: A second consecutive insert into statement takes forever   136 Rick James 07/06/2010 08:58AM
Re: A second consecutive insert into statement takes forever   100 Daniel Croona 07/08/2010 10:50PM
Re: A second consecutive insert into statement takes forever   101 Daniel Croona 07/09/2010 01:36AM
Re: A second consecutive insert into statement takes forever   111 Daniel Croona 07/09/2010 02:48AM
Re: A second consecutive insert into statement takes forever   99 Rick James 07/09/2010 08:34AM
Re: A second consecutive insert into statement takes forever   107 Daniel Croona 07/09/2010 04:25PM
TOP command shows server busy but SHOW PROCESSLIST shows nothing?   356 Bing Wu 07/07/2010 09:37AM
Re: TOP command shows server busy but SHOW PROCESSLIST shows nothing?   133 Rick James 07/08/2010 07:58PM
Re: TOP command shows server busy but SHOW PROCESSLIST shows nothing?   128 Bing Wu 07/09/2010 01:01AM
Updating my.cnf for new hardware   278 Trevor Johnson 07/08/2010 04:27PM
Table to table compare for 90 million record dB   302 Drew Ostrowski 07/06/2010 12:14PM
Re: Table to table compare for 90 million record dB   111 Rick James 07/07/2010 09:43PM
Query takes more time to execute after creation of index.   423 sunil divyeshvar 06/25/2010 11:53PM
Re: Query takes more time to execute after creation of index.   176 Rick James 06/27/2010 01:20PM
Re: Query takes more time to execute after creation of index.   168 sunil divyeshvar 06/28/2010 10:52PM
Re: Query takes more time to execute after creation of index.   164 Rick James 06/28/2010 11:18PM
Re: Query takes more time to execute after creation of index.   158 sunil divyeshvar 06/28/2010 11:42PM
Re: Query takes more time to execute after creation of index.   185 Rick James 06/28/2010 11:50PM
Re: Query takes more time to execute after creation of index.   153 sunil divyeshvar 06/29/2010 12:40AM
Re: Query takes more time to execute after creation of index.   112 Mayur P Vegad 07/07/2010 08:21AM
HyperThreading or number of logical processors ?   309 Cédric Vuillet 07/04/2010 02:00AM
Re: HyperThreading or number of logical processors ?   148 Rick James 07/05/2010 01:38PM
Re: HyperThreading or number of logical processors ?   130 Cédric Vuillet 07/05/2010 02:56PM
Re: HyperThreading or number of logical processors ?   132 Rick James 07/05/2010 11:21PM
Whether to use one table per user or one really big table   337 Chris-Werner Reimer 07/02/2010 05:34AM
Re: Whether to use one table per user or one really big table   154 Craig Logan 07/03/2010 07:24AM
Re: Whether to use one table per user or one really big table   146 Rick James 07/03/2010 02:35PM
MySQL 5.1.48 CREATE TABLE performance on Mac OS X 10.6.4   310 Harish Agarwal 07/02/2010 12:36PM
performance of Mysql on SUN FIRE X4170 and SUN enterprise M3000   288 justin ux 06/30/2010 09:26PM
Re: performance of Mysql on SUN FIRE X4170 and SUN enterprise M3000   131 Rick James 07/01/2010 11:11PM
I'm having trouble with indexes for a query that take ~20 seconds to run   341 matthew horrocks 06/29/2010 07:13AM
Re: I'm having trouble with indexes for a query that take ~20 seconds to run   153 Rick James 06/30/2010 08:47AM
Re: I'm having trouble with indexes for a query that take ~20 seconds to run   147 matthew horrocks 07/01/2010 04:12AM
Re: I'm having trouble with indexes for a query that take ~20 seconds to run   129 Rick James 07/01/2010 10:04PM
Performance problem   341 Xavier Gosset 06/28/2010 02:30AM
Re: Performance problem   141 Rick James 06/29/2010 12:01AM
Best way to import and transform data   423 dennis haarbrink 06/23/2010 04:42AM
Re: Best way to import and transform data   166 Rick James 06/26/2010 02:13PM
Performance and huge number of bases, tables or records ?   454 Tristan LEY 06/19/2010 04:56PM
Re: Performance and huge number of bases, tables or records ?   210 Rick James 06/20/2010 09:01PM
Re: Performance and huge number of bases, tables or records ?   240 Tristan LEY 06/22/2010 05:59AM
Re: Performance and huge number of bases, tables or records ?   178 Tristan LEY 06/25/2010 04:34PM
Simple question with two indexes on a large InnoDB table   343 T Kristoffersen 06/23/2010 10:24AM
Re: Simple question with two indexes on a large InnoDB table   165 T Kristoffersen 06/24/2010 02:04AM
subquery performace   362 Uday V 06/21/2010 06:17PM
Re: subquery performace   169 Rick James 06/22/2010 10:28PM
Index performance   470 Alex Vilner 06/15/2010 08:30AM
Re: Index performance   225 Rick James 06/16/2010 09:54AM
Re: Index performance   246 Alex Vilner 06/16/2010 12:03PM
Re: Index performance   239 Rick James 06/16/2010 08:47PM
Re: Index performance   205 Alex Vilner 06/20/2010 02:30PM
Re: Index performance   198 Rick James 06/20/2010 11:05PM
Re: Index performance   190 Alex Vilner 06/21/2010 07:35AM
Re: Index performance   176 Rick James 06/21/2010 09:21AM
Re: Index performance   199 Alex Vilner 06/21/2010 10:31AM
Re: Index performance   183 Rick James 06/21/2010 06:43PM
Re: Index performance   197 Alex Vilner 06/21/2010 06:55PM
SQL query explain   376 Yeo Wee tat 06/16/2010 12:31AM
Re: SQL query explain   169 Yeo Wee tat 06/21/2010 03:53AM
Re: SQL query explain   206 Rick James 06/17/2010 10:27AM
User Defined Function in SELECT clause - slow   460 Alex Vilner 06/17/2010 06:19PM
Re: User Defined Function in SELECT clause - slow   196 Rick James 06/18/2010 07:57PM
Re: User Defined Function in SELECT clause - slow   195 Alex Vilner 06/18/2010 08:11PM
Re: User Defined Function in SELECT clause - slow   196 Rick James 06/18/2010 11:45PM
Re: User Defined Function in SELECT clause - slow   200 Alex Vilner 06/19/2010 07:09AM
Optimizing a Radius Search   406 aaron 06/16/2010 12:59PM
Re: Optimizing a Radius Search   188 Saurabh Deshpande 06/18/2010 01:32AM
Re: Optimizing a Radius Search   213 Rick James 06/17/2010 10:47PM
Re: Optimizing a Radius Search   196 aaron 06/18/2010 10:58AM
Queries from remote hosts not using indexes   342 Dan Cannon 06/18/2010 08:27AM
JOIN optimization MYISAM v5.0.51 php5.2   387 Denes Smith 06/16/2010 07:33AM
Re: JOIN optimization MYISAM v5.0.51 php5.2   212 Rick James 06/17/2010 10:04AM
Re: JOIN optimization MYISAM v5.0.51 php5.2   227 Denes Smith 06/17/2010 10:41AM
Group By <ID> & Order By <Name>   404 Knut Meinke 06/14/2010 08:34AM
Re: Group By <ID> & Order By <Name>   196 Rick James 06/15/2010 10:36PM
Re: Group By <ID> & Order By <Name>   207 Rick James 06/17/2010 12:22AM
Re: Group By <ID> & Order By <Name>   187 Knut Meinke 06/17/2010 01:48AM
sql query cause mysql performance to be slow   427 Yeo Wee tat 06/15/2010 03:28AM
Re: sql query cause mysql performance to be slow   231 Rick James 06/16/2010 08:42AM
Re: sql query cause mysql performance to be slow   217 Yeo Wee tat 06/16/2010 10:28PM
Performance tuning question   478 Alex Vilner 06/10/2010 09:44AM
Re: Performance tuning question   264 Alex Vilner 06/10/2010 10:36AM
Re: Performance tuning question   260 Rick James 06/12/2010 10:01AM
Re: Performance tuning question   256 Rick James 06/12/2010 06:11PM
Re: Performance tuning question   241 Alex Vilner 06/14/2010 07:27AM
Re: Performance tuning question   248 Rick James 06/14/2010 08:02AM
Re: Performance tuning question   228 Alex Vilner 06/12/2010 11:15AM
Query takes too long and there's hardly any CPU utilization   471 T Kristoffersen 06/09/2010 09:35AM
Re: Query takes too long and there's hardly any CPU utilization   248 Rick James 06/13/2010 09:05PM
indexes on a table are no longer fast   409 Patrick St.Onge 06/02/2010 01:32PM
Re: indexes on a table are no longer fast   226 Rick James 06/13/2010 01:36PM
[HELP] my.cnf settings for a server with 4GB ram?   489 jirayu sukheepoj 06/11/2010 11:01PM
Re: [HELP] my.cnf settings for a server with 4GB ram?   288 Rick James 06/13/2010 01:13PM
This topic has been moved.:  Preformance: Bulk Insert with one Index   0 Shary M 07/13/2010 11:59AM
This topic has been moved.:  Select query on a join of tables very slow   0 Nitya Thacker 07/12/2010 03:37PM
Pages:  1 2 3 4 5 ...LastNext
Current Page: 1 of 51
powered by phorum