Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.18 has been released 12/17/2014 06:54PM
MySQL Enterprise Monitor 2.3.19 has been released 12/11/2014 05:18PM
MySQL Cluster Manager 1.3.3 has been released 12/01/2014 12:23PM
MySQL Community Server 5.6.22 has been released 12/01/2014 11:46AM
MySQL Community Server 5.5.41 has been released 11/28/2014 05:28AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 69
Subject Views Written By Posted
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   730 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.7 DMR: Performance Benchmarks - 1Mil QPS (1 Posts)   1,600 Edwin Desouza 09/21/2013 11:11AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   2,229 Edwin Desouza 02/12/2013 06:11PM
Sticky:  MySQL 5.6: Server Default Config changes - my.cnf and my.ini (1 Posts)   3,508 Edwin DeSouza 12/12/2012 08:19PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   4,719 Edwin DeSouza 08/04/2011 09:09AM
Sticky:  Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server (1 Posts)   6,790 Edwin DeSouza 10/21/2010 11:13AM
Sticky:  MySQL Performance Schema: A Big Bag of Epic Awesomeness (1 Posts)   10,152 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   159,927 Edwin DeSouza 05/25/2006 10:50AM
innodb_buffer_pool_read_requests global status wraparound   142 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   52 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   38 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   33 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   40 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   0 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   72 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   21 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   16 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   18 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   17 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   79 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   26 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   31 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   26 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   21 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   21 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   14 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   14 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   16 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   94 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   30 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   83 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   32 Rick James 11/28/2014 06:59PM
Cardinality Problem   129 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   41 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   34 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   34 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   170 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   40 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   44 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   53 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   42 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   55 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   38 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   42 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   39 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   29 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   29 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   167 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   64 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   46 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   50 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   46 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   31 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   159 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   65 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   54 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   57 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   45 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   48 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   201 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   67 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   61 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   61 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   66 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   62 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   69 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   52 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   246 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   119 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   109 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   111 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   82 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   85 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   62 Ravi Malghan 11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support   204 Christine Ross 10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support   111 Peter Brawley 10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support   99 Christine Ross 10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support   97 Rick James 11/02/2014 09:33AM
GROUP causing Using Temporary Using Filesort   1,269 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   532 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   490 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   432 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   350 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   290 Rick James 08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort   242 RT Lee 08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort   278 Rick James 08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort   129 Leonardo Duque 10/30/2014 12:57PM
Leonardo, please do not hijack threads   92 Peter Brawley 10/31/2014 11:15AM
Eliminate filesort in update query   305 Matzz - 09/23/2014 02:48AM
Re: Eliminate filesort in update query   102 Rick James 09/23/2014 09:59PM
Re: Eliminate filesort in update query   109 Matzz - 09/24/2014 01:25AM
Re: Eliminate filesort in update query   106 Rick James 09/24/2014 08:40PM
Re: Eliminate filesort in update query   97 Matzz - 09/25/2014 05:48AM
Re: Eliminate filesort in update query   100 Rick James 09/26/2014 04:39PM
Re: Eliminate filesort in update query   94 Matzz - 10/01/2014 06:49AM
Re: Eliminate filesort in update query   105 Rick James 10/03/2014 10:09PM
Re: Eliminate filesort in update query   111 Matzz - 10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table   249 Jeetu Gaur 09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table   115 Rick James 09/27/2014 08:16AM
Slow response time due queries   308 Jens Meier 09/23/2014 01:32AM
Re: Slow response time due queries   115 Rick James 09/23/2014 10:11PM
PHP/MySQL to use all CPU/memory to increase performance   301 Caleb Pitman 09/21/2014 11:04AM
Re: PHP/MySQL to use all CPU/memory to increase performance   146 Rick James 09/22/2014 03:39PM
Re: PHP/MySQL to use all CPU/memory to increase performance   134 Caleb Pitman 09/22/2014 04:55PM
Re: PHP/MySQL to use all CPU/memory to increase performance   125 Rick James 09/23/2014 03:21PM
How to set mysql CPU affinity?   371 Metal Messiah 09/21/2014 01:33PM
Re: How to set mysql CPU affinity?   171 Rick James 09/22/2014 03:25PM
Re: How to set mysql CPU affinity?   152 Sophia Parsons 09/23/2014 01:30AM
Re: How to set mysql CPU affinity?   147 Rick James 09/23/2014 11:03AM
Query optimization to reduce execution time.   273 Neetu Nayak 09/22/2014 07:33AM
Re: Query optimization to reduce execution time.   142 Rick James 09/22/2014 08:46PM
Re: Query optimization to reduce execution time.   123 Neetu Nayak 09/23/2014 12:38AM
Re: Query optimization to reduce execution time.   125 Neetu Nayak 09/23/2014 01:42AM
Mass Update optimization   324 Susan Lin 09/14/2014 06:00PM
Re: Mass Update optimization   168 Rick James 09/15/2014 11:38AM
Re: Mass Update optimization   111 Sophia Parsons 09/23/2014 01:36AM
Optimising query with composite index, which says using where   285 Timothy Mifsud 09/06/2014 12:38AM
Re: Optimising query with composite index, which says using where   119 Timothy Mifsud 09/06/2014 01:53AM
Re: Optimising query with composite index, which says using where   109 Rick James 09/07/2014 10:46PM
Re: Optimising query with composite index, which says using where   104 Øystein Grøvlen 09/15/2014 06:03AM
Re: Optimising query with composite index, which says using where   98 Rick James 09/15/2014 10:03AM
Slow Performance with Multi-threaded app   285 Minesh Desai 09/12/2014 09:24AM
Re: Slow Performance with Multi-threaded app   127 Rick James 09/13/2014 09:47AM
InnoDB and locking, UPDATE and SELECT   283 Andreas Greulich 09/10/2014 01:18AM
Re: InnoDB and locking, UPDATE and SELECT   109 Rick James 09/13/2014 12:09AM
MySQL using too much CPU   324 31 Special 08/29/2014 05:12PM
Re: MySQL using too much CPU   149 Rick James 08/30/2014 05:27PM
Re: MySQL using too much CPU   200 31 Special 08/31/2014 10:13PM
Understanding Explain   304 J M 08/27/2014 07:31AM
Re: Understanding Explain   144 Peter Brawley 08/27/2014 10:35AM
Re: Understanding Explain   129 J M 08/27/2014 10:51AM
Re: Understanding Explain   122 Øystein Grøvlen 08/28/2014 03:00PM
Re: Understanding Explain   119 Rick James 08/29/2014 09:45PM
Need help to otimize my query   291 GAURAV JAIN 08/21/2014 07:28AM
Re: Need help to otimize my query   141 Rick James 08/24/2014 09:17PM
Slow response in MY SQL 5.5.1.8   331 Amila Kumara 07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8   169 Rick James 07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8   178 Amila Kumara 07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8   164 Rick James 07/23/2014 12:19AM
Help in tuning MySQL 5.6 database   327 Deepak Dambe 07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database   168 Rick James 07/18/2014 12:12PM
Query slows down over time   469 Sameer Shah 05/28/2014 09:35AM
Re: Query slows down over time   235 Peter Brawley 05/28/2014 12:45PM
Re: Query slows down over time   222 Sameer Shah 05/28/2014 01:24PM
Re: Query slows down over time   228 Rick James 05/28/2014 04:57PM
Re: Query slows down over time   237 Sameer Shah 05/28/2014 05:46PM
Re: Query slows down over time   221 Rick James 05/28/2014 07:23PM
Re: Query slows down over time   341 Sam Shah 05/29/2014 05:38AM
Re: Query slows down over time   231 Rick James 05/29/2014 09:49AM
Re: Query slows down over time   232 Sam Shah 05/29/2014 03:12PM
Re: Query slows down over time   173 Sam Shah 07/15/2014 12:10PM
Re: Query slows down over time   189 Peter Brawley 07/15/2014 12:33PM
Re: Query slows down over time   157 Rick James 07/16/2014 11:19AM
Performance problem with outer join   398 RT Lee 07/11/2014 07:53AM
Re: Performance problem with outer join   178 Peter Brawley 07/11/2014 09:26AM
Re: Performance problem with outer join   168 Rick James 07/11/2014 04:26PM
Re: Performance problem with outer join   158 RT Lee 07/13/2014 12:29PM
Where to look for server freezes   341 Michael Muratet 07/10/2014 10:08AM
Re: Where to look for server freezes   148 Rick James 07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order   513 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   242 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   245 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   223 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   204 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   784 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   241 Rick James 06/26/2014 06:19PM
MySQL hangs due to large delete   387 Akshay Viswanathan 06/25/2014 08:51AM
Re: MySQL hangs due to large delete   177 Rick James 06/26/2014 06:13PM
Superkey vs Primary Key   539 Mario Schill 06/16/2014 04:13AM
Re: Superkey vs Primary Key   238 Peter Brawley 06/16/2014 10:42AM
Re: Superkey vs Primary Key   199 Mario Schill 06/17/2014 12:57AM
Re: Superkey vs Primary Key   213 Peter Brawley 06/17/2014 03:42AM
DML operations slow down   407 Sivaprakash Gopal 06/04/2014 04:43PM
Re: DML operations slow down   229 Rick James 06/06/2014 09:18AM
how to configure my.cnf for mysql 5.1, using too much cpu?   524 Aamir Sohail 06/05/2014 06:15AM
Re: how to configure my.cnf for mysql 5.1, using too much cpu?   261 Rick James 06/06/2014 09:09AM
'Compound' INDEXes   441 lee fei 06/04/2014 03:24AM
Re: 'Compound' INDEXes   215 Rick James 06/05/2014 09:12PM
Delete slow... randomly   498 Francesco De Carlo 06/02/2014 09:15AM
Re: Delete slow... randomly   229 Rick James 06/03/2014 09:51AM
Re: Delete slow... randomly   218 Francesco De Carlo 06/04/2014 03:43AM
Re: Delete slow... randomly   210 Rick James 06/05/2014 08:01PM
concurrent_insert   436 Ben Zhou 06/01/2014 08:15AM
Re: concurrent_insert   231 Rick James 06/02/2014 11:53AM
Re: concurrent_insert   204 Ben Zhou 06/04/2014 08:37AM
Re: concurrent_insert   217 Rick James 06/05/2014 07:55PM
Queriy taking long time in OTRS   585 Rajkumar D 05/29/2014 03:53AM
Re: Queriy taking long time in OTRS   209 Rajkumar D 05/29/2014 01:11PM
Re: Queriy taking long time in OTRS   253 Rick James 05/30/2014 10:41AM
Re: Queriy taking long time in OTRS   211 Rajkumar D 05/30/2014 12:45PM
Re: Queriy taking long time in OTRS   237 Øystein Grøvlen 06/02/2014 03:52AM
Query attacks against read-only database   414 joe blake 05/29/2014 09:46PM
Re: Query attacks against read-only database   209 Rick James 05/31/2014 08:04AM
my.cnf file with mysql tuner   716 maurizio ca 05/26/2014 03:03AM
Re: my.cnf file with mysql tuner   390 Rick James 05/26/2014 07:29PM
Out of memory - on any moderate query   470 rol and 05/23/2014 12:58PM
Re: Out of memory - on any moderate query   221 Peter Brawley 05/23/2014 10:59PM
Re: Out of memory - on any moderate query   253 Rick James 05/24/2014 03:18PM
Low priority SELECT   528 Glas Host 05/21/2014 07:18AM
Re: Low priority SELECT   279 Rick James 05/24/2014 03:05PM
Performance improvement with my.cnf configs   499 Manohar K 04/23/2014 10:23AM
Re: Performance improvement with my.cnf configs   245 Rick James 04/24/2014 08:08PM
Re: Performance improvement with my.cnf configs   257 Manohar K 04/24/2014 09:41PM
Re: Performance improvement with my.cnf configs   271 Rick James 04/25/2014 08:24PM
Re: Performance improvement with my.cnf configs   243 Manohar K 05/06/2014 10:22AM
Adding index kills query   568 Robert Stafford 04/23/2014 06:10PM
Re: Adding index kills query   259 Robert Stafford 04/23/2014 06:14PM
Re: Adding index kills query   261 Øystein Grøvlen 04/24/2014 02:44AM
Re: Adding index kills query   262 Robert Stafford 04/24/2014 09:07AM
Re: Adding index kills query   258 Øystein Grøvlen 04/25/2014 07:39AM
Re: Adding index kills query   290 Robert Stafford 04/25/2014 11:54AM
Re: Adding index kills query   277 Rick James 04/25/2014 02:25PM
Re: Adding index kills query   252 Øystein Grøvlen 04/28/2014 06:06AM
Re: Adding index kills query   232 Peter Brawley 04/24/2014 09:37AM
Re: Adding index kills query   237 Robert Stafford 04/24/2014 06:31PM
Re: Adding index kills query   248 Peter Brawley 04/24/2014 07:10PM
Re: Adding index kills query   223 Robert Stafford 04/24/2014 07:19PM
Re: Adding index kills query   249 Rick James 04/25/2014 10:55AM
Re: Adding index kills query   228 Øystein Grøvlen 04/25/2014 11:02PM
Re: Adding index kills query   288 Robert Stafford 04/27/2014 07:53PM
Re: Adding index kills query   234 Peter Brawley 04/27/2014 08:50PM
Re: Adding index kills query   235 Rick James 04/27/2014 09:00PM
No response to SELECT with IN clause   587 James Cobban 04/21/2014 06:39PM
Re: No response to SELECT with IN clause   237 Peter Brawley 04/21/2014 09:54PM
Re: No response to SELECT with IN clause   255 Rick James 04/22/2014 12:01AM
Recommended changes to my.cnf   447 W B 04/19/2014 01:56PM
Re: Recommended changes to my.cnf   264 Rick James 04/20/2014 04:53PM
Re: Recommended changes to my.cnf   225 W B 04/20/2014 05:01PM
Re: Recommended changes to my.cnf   235 Rick James 04/21/2014 11:24PM
MySQL MyISAM sorting query makes it slower   559 Timothy Mifsud 04/13/2014 03:06AM
Re: MySQL MyISAM sorting query makes it slower   294 Rick James 04/13/2014 10:39PM
Re: MySQL MyISAM sorting query makes it slower   288 Timothy Mifsud 04/14/2014 02:10AM
Re: MySQL MyISAM sorting query makes it slower   276 Rick James 04/14/2014 12:23PM
Re: MySQL MyISAM sorting query makes it slower   288 Timothy Mifsud 04/14/2014 04:13PM
Re: MySQL MyISAM sorting query makes it slower   255 Rick James 04/14/2014 07:01PM
Re: MySQL MyISAM sorting query makes it slower   270 Timothy Mifsud 04/15/2014 01:00PM
Re: MySQL MyISAM sorting query makes it slower   267 Rick James 04/16/2014 12:26PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 69

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.