Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
• MySql Connector/Net 6.0.5 has been released 11/12/2009 09:31AM
• MySQL Connector/ODBC 5.1.6 is available! 11/09/2009 01:37PM
• MySQL Community Server 5.0.87 has been released 10/26/2009 12:58PM
• MySQL Community Server 5.1.40 has been released 10/26/2009 12:55PM
• MySql Connector/Net 6.2.0 alpha has been released 10/21/2009 10:33AM
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,611 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Best Practices, FAQs, How-To, Articles, Blogs (2 Posts)   24,453 Edwin DeSouza 05/25/2006 10:50AM
LEFT JOIN with CASE WHEN   482 Chad Brogan 10/23/2009 02:25PM
PARTIAL RESOLUTION - Re: LEFT JOIN with CASE WHEN   130 Chad Brogan 10/27/2009 07:15PM
Re: PARTIAL RESOLUTION - Re: LEFT JOIN with CASE WHEN   5 Chad Brogan 11/14/2009 12:30PM
Re: LEFT JOIN with CASE WHEN   179 Stefan Rindeskar 10/23/2009 06:33PM
Re: LEFT JOIN with CASE WHEN   159 Rick James 10/23/2009 10:29PM
Re: LEFT JOIN with CASE WHEN   150 Chad Brogan 10/25/2009 01:34PM
Re: LEFT JOIN with CASE WHEN   153 Chad Brogan 10/23/2009 09:54PM
Update Statement To Not Use A Subquery   32 Justin Keller 11/13/2009 05:47PM
Sorting with limit across a join. How to make it fast?   31 Garth Shoemaker 11/13/2009 02:51PM
Group By Perfomance MySQL vs MS SQL   74 Jim Peterson 11/11/2009 10:15AM
Re: Group By Perfomance MySQL vs MS SQL   41 Rick James 11/12/2009 07:06PM
Re: Group By Perfomance MySQL vs MS SQL   18 Jim Peterson 11/13/2009 11:10AM
VARCHAR(4096) or TEXT   30 Justin Keller 11/12/2009 10:20PM
Muliple databases or one combined?   300 Jim Kellas 10/14/2009 08:57PM
Re: Muliple databases or one combined?   185 Rick James 10/15/2009 10:51PM
Re: Muliple databases or one combined?   21 Joe Rhoney 11/12/2009 06:02PM
Re: Muliple databases or one combined?   17 Rick James 11/12/2009 08:12PM
JOIN vs Denormalize table vs Vertical partition   42 Laavanya K 11/12/2009 03:26AM
SQL Row Pattern Matching   51 David Coleman 11/11/2009 07:37AM
Multiple inner join Query with NOT IN takes forever to execute for large resultset   82 infinity heaven 11/09/2009 10:18AM
Re: Multiple inner join Query with NOT IN takes forever to execute for large resultset   40 Rick James 11/10/2009 10:05PM
Open Source Replication And Clustering Solution For MySQL And PostgreSQL   53 Petri Virsunen 11/10/2009 08:20PM
Lag when connecting to DB   53 ema bisa 11/10/2009 09:31AM
HELP! making choises on Performance - Storage engine - Caching   97 saif bechan 11/08/2009 08:31AM
Re: HELP! making choises on Performance - Storage engine - Caching   54 Rick James 11/09/2009 04:25PM
Re: HELP! making choises on Performance - Storage engine - Caching   47 saif bechan 11/10/2009 03:38AM
Re: HELP! making choises on Performance - Storage engine - Caching   49 Rick James 11/10/2009 09:29AM
High load - queries take long time   148 Prova Test 11/05/2009 01:22PM
Re: High load - queries take long time   116 Prova Test 11/05/2009 01:26PM
Re: High load - queries take long time   97 Rick James 11/06/2009 09:04PM
Re: High load - queries take long time   79 Prova Test 11/07/2009 10:02PM
Re: High load - queries take long time   58 Rick James 11/08/2009 10:36PM
Re: High load - queries take long time   59 Prova Test 11/09/2009 03:35AM
Deadlock / performance   98 Jason Wood 11/06/2009 05:23AM
mysql 4.1 - 50 Millieion records each year   122 Su Ni 11/05/2009 12:15AM
Re: mysql 4.1 - 50 Millieion records each year   63 Rick James 11/05/2009 11:42PM
Continuent Releases Tungsten Community Edition   85 Petri Virsunen 11/05/2009 07:54PM
High load - queries take long time   91 Prova Test 11/05/2009 01:18PM
why won't mysql use an index?   142 Jiong Mai 11/03/2009 11:53AM
Re: why won't mysql use an index?   94 Jiong Mai 11/03/2009 03:02PM
Re: why won't mysql use an index?   85 Rick James 11/04/2009 04:47PM
Copying data from a table   110 amir bilal 11/03/2009 04:33AM
Re: Copying data from a table   65 Rick James 11/04/2009 03:44PM
Removing NOT NULL constraint takes a long time. Why?   207 Ben Dowling 10/28/2009 08:54AM
Re: Removing NOT NULL constraint takes a long time. Why?   108 Rick James 10/29/2009 09:47PM
Re: Removing NOT NULL constraint takes a long time. Why?   88 Ben Dowling 11/03/2009 09:58AM
Re: Removing NOT NULL constraint takes a long time. Why?   77 Rick James 11/03/2009 08:48PM
Update table slower in trigger than in procedure. Is this possible?   241 Emilio Nicolás 10/27/2009 07:11PM
Re: Update table slower in trigger than in procedure. Is this possible?   117 Emilio Nicolás 10/28/2009 04:33AM
Re: Update table slower in trigger than in procedure. Is this possible?   85 Emilio Nicolás 11/02/2009 07:12AM
perf wierd cpu usage since one week   233 julian vanden broeck 10/22/2009 04:38AM
Re: perf wierd cpu usage since one week   143 Rick James 10/23/2009 10:47AM
Re: perf wierd cpu usage since one week   119 julian vanden broeck 10/29/2009 02:19AM
Re: perf wierd cpu usage since one week   114 Rick James 10/29/2009 07:33AM
Re: perf wierd cpu usage since one week   86 julian vanden broeck 11/02/2009 02:27AM
Performance impact of "flush tables"   185 Kristian Sørensen 10/29/2009 05:51AM
Re: Performance impact of "flush tables"   108 Kristian Sørensen 10/31/2009 11:10AM
Re: Performance impact of "flush tables"   100 Rick James 10/31/2009 02:03PM
Re: Performance impact of "flush tables"   85 Kristian Sørensen 10/31/2009 03:01PM
Re: Performance impact of "flush tables"   118 Rick James 10/30/2009 10:41AM
Slow many-to-many query with distinct and order by   220 Andreas Loo 10/29/2009 10:45AM
Re: Slow many-to-many query with distinct and order by   109 Rick James 10/30/2009 08:32PM
Lenovo T400 20 times faster than my DB server why?   213 joel maranhao 10/27/2009 06:03PM
Re: Lenovo T400 20 times faster than my DB server why?   135 joel maranhao 10/28/2009 06:23PM
Re: Lenovo T400 20 times faster than my DB server why?   135 Rick James 10/28/2009 10:35PM
Re: Lenovo T400 20 times faster than my DB server why?   122 joel maranhao 10/29/2009 05:54PM
Re: Lenovo T400 20 times faster than my DB server why?   121 Rick James 10/29/2009 08:37PM
Re: Lenovo T400 20 times faster than my DB server why?   117 joel maranhao 10/29/2009 08:59PM
Re: Lenovo T400 20 times faster than my DB server why?   130 Benedikt Schackenberg 10/28/2009 08:19AM
Error when trying to restore database   175 Aigini Navaneethan 10/29/2009 05:08AM
64bit mysql is slower than 32bit?   223 james q 10/27/2009 09:43PM
Re: 64bit mysql is slower than 32bit?   157 james q 10/27/2009 09:53PM
Can this be done with out a sub select?   198 Reine n/a 10/26/2009 07:05AM
Re: Can this be done with out a sub select?   123 Rick James 10/27/2009 09:33AM
Index taking 3+ days to build   184 Adrian Neal 10/26/2009 08:01AM
Re: Index taking 3+ days to build   127 Rick James 10/27/2009 09:15AM
Inserts taking too long   379 Premal Shah 10/12/2009 01:44PM
Re: Inserts taking too long   284 Rick James 10/14/2009 08:18AM
Re: Inserts taking too long   255 Premal Shah 10/16/2009 05:03PM
Re: Inserts taking too long   237 Rick James 10/16/2009 09:31PM
Re: Inserts taking too long   224 Premal Shah 10/17/2009 05:22PM
Re: Inserts taking too long   214 Rick James 10/17/2009 06:00PM
Re: Inserts taking too long   240 Premal Shah 10/18/2009 11:58PM
Re: Inserts taking too long   201 Rick James 10/19/2009 11:05PM
Re: Inserts taking too long   164 Premal Shah 10/23/2009 06:02PM
Re: Inserts taking too long   176 Rick James 10/23/2009 07:33PM
Re: Inserts taking too long   174 Premal Shah 10/26/2009 10:59AM
Re: Inserts taking too long   162 Rick James 10/26/2009 08:14PM
Re: Inserts taking too long   193 Prasath Krishnan 10/21/2009 07:33AM
Re: Inserts taking too long   256 Premal Shah 10/16/2009 10:26AM
add index take a long time?   300 Kevin Chen 10/22/2009 03:21AM
Re: add index take a long time?   196 Kevin Chen 10/22/2009 04:23AM
Re: add index take a long time?   174 Rick James 10/23/2009 09:56PM
Something awfull with latest mysql on latest FreeBSD   228 Aga Aga 10/22/2009 10:17AM
Re: Something awfull with latest mysql on latest FreeBSD   147 Rick James 10/23/2009 09:48PM
Which way is right for getting performance?   235 Monalee Bhandge (DBA) 10/22/2009 06:20AM
Re: Which way is right for getting performance?   133 Rick James 10/23/2009 10:19AM
multi column indexing on datetime and an id   266 Daniel Blackhurst 10/20/2009 11:48AM
Re: multi column indexing on datetime and an id   182 Stefan Rindeskar 10/20/2009 03:26PM
Re: multi column indexing on datetime and an id   201 Daniel Blackhurst 10/21/2009 05:09AM
Re: multi column indexing on datetime and an id   192 Rick James 10/21/2009 11:59PM
Re: multi column indexing on datetime and an id   181 Daniel Blackhurst 10/22/2009 01:47AM
Re: multi column indexing on datetime and an id   178 Rick James 10/22/2009 09:06AM
Re: multi column indexing on datetime and an id   160 Daniel Blackhurst 10/22/2009 12:04PM
Re: multi column indexing on datetime and an id   161 Rick James 10/22/2009 07:44PM
Geocoded Location Cache   244 Daniel Blackhurst 10/20/2009 02:17AM
Re: Geocoded Location Cache   149 Rick James 10/21/2009 09:06PM
Re: Geocoded Location Cache   149 Daniel Blackhurst 10/22/2009 02:20AM
Re: Geocoded Location Cache   150 Rick James 10/22/2009 08:38AM
Re: Geocoded Location Cache   132 Daniel Blackhurst 10/22/2009 12:36PM
MyISAM read performance on Solaris UFS/ZFS and Ubuntu   256 Arin Ben-Aharon 10/21/2009 02:22AM
Data layout - More fields or more records?   261 James Dear 10/18/2009 04:04AM
Re: Data layout - More fields or more records?   150 Rick James 10/19/2009 11:20PM
updating DATETIME index performance problems   348 Steve Thomas 10/16/2009 01:22AM
Re: updating DATETIME index performance problems   220 Rick James 10/17/2009 10:11PM
Re: updating DATETIME index performance problems   200 Steve Thomas 10/19/2009 02:15AM
Re: updating DATETIME index performance problems   181 Stefan Rindeskar 10/19/2009 05:03PM
Re: updating DATETIME index performance problems   193 Rick James 10/19/2009 10:29PM
MySQL rand() is slow on large datasets   443 maximiliam daniel 10/08/2009 02:12PM
Re: MySQL rand() is slow on large datasets   247 Rick James 10/09/2009 07:32PM
Re: MySQL rand() is slow on large datasets   247 maximiliam daniel 10/09/2009 10:21PM
Re: MySQL rand() is slow on large datasets   268 Rick James 10/10/2009 11:22AM
Re: MySQL rand() is slow on large datasets   218 maximiliam daniel 10/17/2009 03:12PM
Re: MySQL rand() is slow on large datasets   199 Rick James 10/17/2009 06:18PM
Re: MySQL rand() is slow on large datasets   200 maximiliam daniel 10/18/2009 02:44PM
Re: MySQL rand() is slow on large datasets   182 maximiliam daniel 10/18/2009 03:21PM
Re: MySQL rand() is slow on large datasets   187 Rick James 10/18/2009 04:37PM
size of [innodb_buffer_pool_size] in Windows 2003 (32 bits)   288 Sebastián Gómez 10/15/2009 06:35PM
Re: size of [innodb_buffer_pool_size] in Windows 2003 (32 bits)   187 Stefan Rindeskar 10/17/2009 11:26AM
Re: size of [innodb_buffer_pool_size] in Windows 2003 (32 bits)   178 Rick James 10/17/2009 06:25PM
Re: size of [innodb_buffer_pool_size] in Windows 2003 (32 bits)   188 Rick James 10/16/2009 09:26PM
Not having luck with GROUP BY in 2-table join   326 Wired Insight 10/15/2009 11:45AM
Re: Not having luck with GROUP BY in 2-table join   194 Rick James 10/16/2009 09:15PM
High granularity DB hits vs sleeping SQL processes.   694 David T 08/01/2009 02:14AM
Re: High granularity DB hits vs sleeping SQL processes.   204 Matt Pardee 10/16/2009 03:17AM
Re: High granularity DB hits vs sleeping SQL processes.   463 Rick James 08/07/2009 10:22PM
Are SELECT fields optimized to avoid repeated evaluation of the same expressions?   251 Stephen Cantini 10/15/2009 09:52AM
Very high CPU utilisation with 40-50 concurrent connection on Innodb table   318 Pankaj joshi 10/14/2009 08:43AM
Re: Very high CPU utilisation with 40-50 concurrent connection on Innodb table   230 Rick James 10/15/2009 12:13AM
Unique constraint multiple columns vs md5   510 Amnon Lahav 10/14/2009 11:07AM
Re: Unique constraint multiple columns vs md5   247 Rick James 10/14/2009 11:11PM
Best performance for a modified date on a record   342 Matthew Berg 10/12/2009 01:32PM
Re: Best performance for a modified date on a record   238 Stefan Rindeskar 10/13/2009 06:29AM
Re: Best performance for a modified date on a record   204 Matthew Berg 10/13/2009 10:16AM
Re: Best performance for a modified date on a record   213 Stefan Rindeskar 10/13/2009 01:23PM
Re: Best performance for a modified date on a record   208 Rick James 10/14/2009 05:58PM
IP Bypass for many connections error   297 Justin Beeler 10/13/2009 05:10PM
Re: IP Bypass for many connections error   213 Stefan Rindeskar 10/14/2009 06:41AM
Slow "checking permissions"   681 Raphael Thoma 08/06/2009 06:25AM
Re: Slow "checking permissions"   467 Rick James 08/07/2009 05:59PM
Re: Slow "checking permissions"   201 Matthew Montgomery 10/12/2009 09:28PM
PHP Applications: 120 Performance Tuning screws for MySQL   320 Edwin DeSouza 10/12/2009 06:24PM
Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   675 sathish kumar 09/26/2009 02:57AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   395 Rick James 09/27/2009 10:41AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   404 sathish kumar 09/27/2009 11:55AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   363 Rick James 09/27/2009 12:13PM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   394 sathish kumar 09/28/2009 01:20AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   373 sathish kumar 09/28/2009 01:53AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   380 Rick James 09/28/2009 09:19AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   326 sathish kumar 10/10/2009 03:08PM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   359 Rick James 10/10/2009 10:27PM
Pages:  1 2 3 4 5 ...LastNext
Current Page: 1 of 46
powered by phorum