Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
• MySQL Workbench 5.2.10 (BETA 2): Upgrade from MySQL Administrator, MySQL Query Browser 12/01/2009 05:30PM
• MySQL Connector/Python 0.1.0-devel: first development snapshot 11/28/2009 05:46PM
• MySQL Community Server 5.0.88 has been released 11/20/2009 03:10PM
• MySQL Workbench 5.2.8 (BETA 1): Upgrade from MySQL Administrator, MySQL Query Browser 11/18/2009 05:29PM
• MySQL Community Server 5.1.41 has been released 11/18/2009 01:04PM
Pages:  1 2 3 4 5 ...LastNext
Current Page: 1 of 46
Subject Views Written By Posted
Sticky:  MySQL Performance Schema (Worklog #2360) (1 Posts)   1,712 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Best Practices, FAQs, How-To, Articles, Blogs (2 Posts)   25,645 Edwin DeSouza 05/25/2006 10:50AM
Slow performance with date_range in select   28 john van Kasteren 11/30/2009 09:37AM
Re: Slow performance with date_range in select   7 Rick James 12/01/2009 09:12PM
Simple queries running slowly on new server   16 Ross Swift 12/01/2009 07:48PM
Innodb inser taking too long   13 Sreedevi Iyer 12/01/2009 07:18PM
improving insert performance on myisam   101 Brad Jensen 11/24/2009 04:06PM
Re: improving insert performance on myisam   47 Brad Jensen 11/25/2009 02:55PM
Re: improving insert performance on myisam   20 Igor Mendelev 11/30/2009 10:55AM
Re: improving insert performance on myisam   46 Rick James 11/25/2009 11:35PM
One or more mysql database?   44 marco sroggio 11/29/2009 06:19AM
Re: One or more mysql database?   11 Rick James 11/30/2009 09:06AM
Very Slow Simple Query   243 Martin Tsvetanov 11/17/2009 09:08PM
Re: Very Slow Simple Query   109 Rick James 11/19/2009 11:29PM
Re: Very Slow Simple Query   54 Martin Tsvetanov 11/25/2009 12:47PM
Re: Very Slow Simple Query   54 Rick James 11/25/2009 11:46PM
Re: Very Slow Simple Query   53 Martin Tsvetanov 11/26/2009 04:33AM
Re: Very Slow Simple Query   41 Rick James 11/26/2009 01:03PM
Re: Very Slow Simple Query   40 Martin Tsvetanov 11/26/2009 01:41PM
Re: Very Slow Simple Query   35 Rick James 11/27/2009 02:19PM
Re: Very Slow Simple Query   35 Martin Tsvetanov 11/27/2009 04:09PM
Re: Very Slow Simple Query   41 Rick James 11/27/2009 11:38PM
Indexing a table still scans many rows   70 Douglas Ferguson 11/25/2009 10:09PM
Re: Indexing a table still scans many rows   32 Rick James 11/27/2009 02:11PM
How many connections could I expect to handle on my server?   103 Erik Frøseth 11/25/2009 06:00AM
Re: How many connections could I expect to handle on my server?   61 Erik Frøseth 11/25/2009 10:23AM
Re: How many connections could I expect to handle on my server?   54 Rick James 11/26/2009 01:17PM
Re: How many connections could I expect to handle on my server?   45 Erik Frøseth 11/26/2009 02:14PM
ORDER BY LIMIT IS SLOW   149 Mohamed el Maslouhi 11/22/2009 10:32AM
Re: ORDER BY LIMIT IS SLOW   65 Rick James 11/23/2009 09:28PM
Re: ORDER BY LIMIT IS SLOW   77 Mohamed el Maslouhi 11/23/2009 10:01PM
Re: ORDER BY LIMIT IS SLOW   66 Mohamed el Maslouhi 11/23/2009 11:01PM
Re: ORDER BY LIMIT IS SLOW   56 Rick James 11/24/2009 10:51PM
Re: ORDER BY LIMIT IS SLOW   57 Mohamed el Maslouhi 11/25/2009 12:16AM
Re: ORDER BY LIMIT IS SLOW   51 Mohamed el Maslouhi 11/25/2009 12:16AM
Re: ORDER BY LIMIT IS SLOW   46 Rick James 11/26/2009 12:28AM
Re: ORDER BY LIMIT IS SLOW   75 Rick James 11/23/2009 10:26PM
MySQL Performance with large data   115 Manish Ranjan 11/24/2009 03:30AM
Re: MySQL Performance with large data   55 Rick James 11/25/2009 10:59PM
Strange? Join with text=id is faster than join on int=id   162 william wil 11/21/2009 04:58AM
Re: Strange? Join with text=id is faster than join on int=id   69 william wil 11/22/2009 03:30PM
Re: Strange? Join with text=id is faster than join on int=id   65 Rick James 11/22/2009 07:09PM
Re: Strange? Join with text=id is faster than join on int=id   73 william wil 11/23/2009 01:01PM
Re: Strange? Join with text=id is faster than join on int=id   55 Rick James 11/23/2009 10:38PM
Re: Strange? Join with text=id is faster than join on int=id   68 Rick James 11/22/2009 12:34PM
How to debug rare MySQL crashes   111 Guillaume Boissiere 11/21/2009 03:40PM
Re: How to debug rare MySQL crashes   75 Rick James 11/22/2009 06:46PM
Re: How to debug rare MySQL crashes   56 Guillaume Boissiere 11/23/2009 03:50PM
Re: How to debug rare MySQL crashes   52 Rick James 11/23/2009 10:19PM
Sorting with limit across a join. How to make it fast?   219 Garth Shoemaker 11/13/2009 02:51PM
Re: Sorting with limit across a join. How to make it fast?   92 Rick James 11/18/2009 07:21PM
Re: Sorting with limit across a join. How to make it fast?   66 Garth Shoemaker 11/23/2009 12:36AM
Re: Sorting with limit across a join. How to make it fast?   58 Rick James 11/23/2009 12:02PM
Re: Sorting with limit across a join. How to make it fast?   60 Garth Shoemaker 11/23/2009 04:39PM
Re: Sorting with limit across a join. How to make it fast?   57 Rick James 11/23/2009 10:05PM
load data infile real-time data load   196 Brian Kiesel 11/19/2009 02:29PM
Re: load data infile real-time data load   95 Rick James 11/21/2009 10:12AM
read write contention split table   136 Andrew Nuss 11/18/2009 05:24PM
Re: read write contention split table   87 Rick James 11/19/2009 11:12PM
Re: read write contention split table   74 Andrew Nuss 11/20/2009 05:10PM
Re: read write contention split table   79 Rick James 11/20/2009 07:23PM
Query many-to-many relation:: how to optimize it   162 Dimitris Theodorakis 11/17/2009 07:39AM
Re: Query many-to-many relation:: how to optimize it   103 Rick James 11/18/2009 06:54PM
Re: Query many-to-many relation:: how to optimize it   88 Dimitris Theodorakis 11/19/2009 08:03PM
3 hours to add an index?   147 Brett Garland 11/17/2009 09:49PM
Re: 3 hours to add an index?   92 Rick James 11/19/2009 12:07AM
Update Statement To Not Use A Subquery   234 Justin Keller 11/13/2009 05:47PM
Re: Update Statement To Not Use A Subquery   103 Rick James 11/18/2009 09:29PM
Re: Update Statement To Not Use A Subquery   110 Justin Keller 11/15/2009 11:51PM
updating DATETIME index performance problems   511 Steve Thomas 10/16/2009 01:22AM
Re: updating DATETIME index performance problems   109 Steve Thomas 11/17/2009 09:13AM
Re: updating DATETIME index performance problems   97 Rick James 11/18/2009 05:25PM
Re: updating DATETIME index performance problems   334 Rick James 10/17/2009 10:11PM
Re: updating DATETIME index performance problems   330 Steve Thomas 10/19/2009 02:15AM
Re: updating DATETIME index performance problems   290 Stefan Rindeskar 10/19/2009 05:03PM
Re: updating DATETIME index performance problems   304 Rick James 10/19/2009 10:29PM
LEFT JOIN with CASE WHEN   871 Chad Brogan 10/23/2009 02:25PM
PARTIAL RESOLUTION - Re: LEFT JOIN with CASE WHEN   272 Chad Brogan 10/27/2009 07:15PM
Re: PARTIAL RESOLUTION - Re: LEFT JOIN with CASE WHEN   128 Chad Brogan 11/14/2009 12:30PM
Re: PARTIAL RESOLUTION - Re: LEFT JOIN with CASE WHEN   129 Rick James 11/17/2009 11:44PM
Re: LEFT JOIN with CASE WHEN   324 Stefan Rindeskar 10/23/2009 06:33PM
Re: LEFT JOIN with CASE WHEN   299 Rick James 10/23/2009 10:29PM
Re: LEFT JOIN with CASE WHEN   287 Chad Brogan 10/25/2009 01:34PM
Re: LEFT JOIN with CASE WHEN   291 Chad Brogan 10/23/2009 09:54PM
Group By Perfomance MySQL vs MS SQL   319 Jim Peterson 11/11/2009 10:15AM
Re: Group By Perfomance MySQL vs MS SQL   196 Rick James 11/12/2009 07:06PM
Re: Group By Perfomance MySQL vs MS SQL   184 Jim Peterson 11/13/2009 11:10AM
Re: Group By Perfomance MySQL vs MS SQL   127 Rick James 11/17/2009 10:30PM
VARCHAR(4096) or TEXT   237 Justin Keller 11/12/2009 10:20PM
Re: VARCHAR(4096) or TEXT   133 Rick James 11/17/2009 10:15PM
JOIN vs Denormalize table vs Vertical partition   241 Laavanya K 11/12/2009 03:26AM
Re: JOIN vs Denormalize table vs Vertical partition   113 Rick James 11/17/2009 09:30PM
Muliple databases or one combined?   435 Jim Kellas 10/14/2009 08:57PM
Re: Muliple databases or one combined?   281 Rick James 10/15/2009 10:51PM
Re: Muliple databases or one combined?   122 Joe Rhoney 11/12/2009 06:02PM
Re: Muliple databases or one combined?   133 Rick James 11/12/2009 08:12PM
SQL Row Pattern Matching   215 David Coleman 11/11/2009 07:37AM
Multiple inner join Query with NOT IN takes forever to execute for large resultset   300 infinity heaven 11/09/2009 10:18AM
Re: Multiple inner join Query with NOT IN takes forever to execute for large resultset   180 Rick James 11/10/2009 10:05PM
Open Source Replication And Clustering Solution For MySQL And PostgreSQL   215 Petri Virsunen 11/10/2009 08:20PM
Lag when connecting to DB   171 ema bisa 11/10/2009 09:31AM
HELP! making choises on Performance - Storage engine - Caching   263 saif bechan 11/08/2009 08:31AM
Re: HELP! making choises on Performance - Storage engine - Caching   182 Rick James 11/09/2009 04:25PM
Re: HELP! making choises on Performance - Storage engine - Caching   168 saif bechan 11/10/2009 03:38AM
Re: HELP! making choises on Performance - Storage engine - Caching   186 Rick James 11/10/2009 09:29AM
High load - queries take long time   327 Prova Test 11/05/2009 01:22PM
Re: High load - queries take long time   268 Prova Test 11/05/2009 01:26PM
Re: High load - queries take long time   246 Rick James 11/06/2009 09:04PM
Re: High load - queries take long time   231 Prova Test 11/07/2009 10:02PM
Re: High load - queries take long time   215 Rick James 11/08/2009 10:36PM
Re: High load - queries take long time   217 Prova Test 11/09/2009 03:35AM
Deadlock / performance   244 Jason Wood 11/06/2009 05:23AM
mysql 4.1 - 50 Millieion records each year   261 Su Ni 11/05/2009 12:15AM
Re: mysql 4.1 - 50 Millieion records each year   178 Rick James 11/05/2009 11:42PM
Continuent Releases Tungsten Community Edition   224 Petri Virsunen 11/05/2009 07:54PM
High load - queries take long time   264 Prova Test 11/05/2009 01:18PM
why won't mysql use an index?   322 Jiong Mai 11/03/2009 11:53AM
Re: why won't mysql use an index?   224 Jiong Mai 11/03/2009 03:02PM
Re: why won't mysql use an index?   214 Rick James 11/04/2009 04:47PM
Copying data from a table   257 amir bilal 11/03/2009 04:33AM
Re: Copying data from a table   175 Rick James 11/04/2009 03:44PM
Removing NOT NULL constraint takes a long time. Why?   353 Ben Dowling 10/28/2009 08:54AM
Re: Removing NOT NULL constraint takes a long time. Why?   235 Rick James 10/29/2009 09:47PM
Re: Removing NOT NULL constraint takes a long time. Why?   202 Ben Dowling 11/03/2009 09:58AM
Re: Removing NOT NULL constraint takes a long time. Why?   190 Rick James 11/03/2009 08:48PM
Update table slower in trigger than in procedure. Is this possible?   393 Emilio Nicolás 10/27/2009 07:11PM
Re: Update table slower in trigger than in procedure. Is this possible?   233 Emilio Nicolás 10/28/2009 04:33AM
Re: Update table slower in trigger than in procedure. Is this possible?   195 Emilio Nicolás 11/02/2009 07:12AM
perf wierd cpu usage since one week   346 julian vanden broeck 10/22/2009 04:38AM
Re: perf wierd cpu usage since one week   253 Rick James 10/23/2009 10:47AM
Re: perf wierd cpu usage since one week   229 julian vanden broeck 10/29/2009 02:19AM
Re: perf wierd cpu usage since one week   224 Rick James 10/29/2009 07:33AM
Re: perf wierd cpu usage since one week   202 julian vanden broeck 11/02/2009 02:27AM
Performance impact of "flush tables"   325 Kristian Sørensen 10/29/2009 05:51AM
Re: Performance impact of "flush tables"   222 Kristian Sørensen 10/31/2009 11:10AM
Re: Performance impact of "flush tables"   206 Rick James 10/31/2009 02:03PM
Re: Performance impact of "flush tables"   195 Kristian Sørensen 10/31/2009 03:01PM
Re: Performance impact of "flush tables"   228 Rick James 10/30/2009 10:41AM
Slow many-to-many query with distinct and order by   389 Andreas Loo 10/29/2009 10:45AM
Re: Slow many-to-many query with distinct and order by   249 Rick James 10/30/2009 08:32PM
Lenovo T400 20 times faster than my DB server why?   362 joel maranhao 10/27/2009 06:03PM
Re: Lenovo T400 20 times faster than my DB server why?   262 joel maranhao 10/28/2009 06:23PM
Re: Lenovo T400 20 times faster than my DB server why?   255 Rick James 10/28/2009 10:35PM
Re: Lenovo T400 20 times faster than my DB server why?   245 joel maranhao 10/29/2009 05:54PM
Re: Lenovo T400 20 times faster than my DB server why?   249 Rick James 10/29/2009 08:37PM
Re: Lenovo T400 20 times faster than my DB server why?   225 joel maranhao 10/29/2009 08:59PM
Re: Lenovo T400 20 times faster than my DB server why?   251 Benedikt Schackenberg 10/28/2009 08:19AM
Error when trying to restore database   319 Aigini Navaneethan 10/29/2009 05:08AM
64bit mysql is slower than 32bit?   403 james q 10/27/2009 09:43PM
Re: 64bit mysql is slower than 32bit?   298 james q 10/27/2009 09:53PM
Can this be done with out a sub select?   338 Reine n/a 10/26/2009 07:05AM
Re: Can this be done with out a sub select?   229 Rick James 10/27/2009 09:33AM
Index taking 3+ days to build   331 Adrian Neal 10/26/2009 08:01AM
Re: Index taking 3+ days to build   235 Rick James 10/27/2009 09:15AM
Inserts taking too long   512 Premal Shah 10/12/2009 01:44PM
Re: Inserts taking too long   411 Rick James 10/14/2009 08:18AM
Re: Inserts taking too long   375 Premal Shah 10/16/2009 05:03PM
Re: Inserts taking too long   350 Rick James 10/16/2009 09:31PM
Re: Inserts taking too long   336 Premal Shah 10/17/2009 05:22PM
Re: Inserts taking too long   319 Rick James 10/17/2009 06:00PM
Re: Inserts taking too long   363 Premal Shah 10/18/2009 11:58PM
Re: Inserts taking too long   325 Rick James 10/19/2009 11:05PM
Re: Inserts taking too long   280 Premal Shah 10/23/2009 06:02PM
Re: Inserts taking too long   298 Rick James 10/23/2009 07:33PM
Re: Inserts taking too long   304 Premal Shah 10/26/2009 10:59AM
Re: Inserts taking too long   284 Rick James 10/26/2009 08:14PM
Re: Inserts taking too long   318 Prasath Krishnan 10/21/2009 07:33AM
Re: Inserts taking too long   368 Premal Shah 10/16/2009 10:26AM
add index take a long time?   487 Kevin Chen 10/22/2009 03:21AM
Re: add index take a long time?   326 Kevin Chen 10/22/2009 04:23AM
Re: add index take a long time?   320 Rick James 10/23/2009 09:56PM
Something awfull with latest mysql on latest FreeBSD   353 Aga Aga 10/22/2009 10:17AM
Re: Something awfull with latest mysql on latest FreeBSD   251 Rick James 10/23/2009 09:48PM
Which way is right for getting performance?   353 Monalee Bhandge (DBA) 10/22/2009 06:20AM
Re: Which way is right for getting performance?   235 Rick James 10/23/2009 10:19AM
Pages:  1 2 3 4 5 ...LastNext
Current Page: 1 of 46
powered by phorum