Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Workbench 6.3.1 Beta has been released 03/05/2015 04:03AM
MySQL Connector/NET 6.7.7 has been released 03/04/2015 02:39PM
MySQL Connector/NET 6.9.6 has been released 03/04/2015 01:30PM
MySQL Utilities 1.6.1 Alpha has been released 03/04/2015 04:57AM
MySQL Utilities 1.5.4 has been released 03/04/2015 04:40AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 70
Subject Views Written By Posted
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)   56 Edwin Desouza 02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   923 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.7 DMR: Performance Benchmarks - 1Mil QPS (1 Posts)   1,774 Edwin Desouza 09/21/2013 11:11AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   2,424 Edwin Desouza 02/12/2013 06:11PM
Sticky:  MySQL 5.6: Server Default Config changes - my.cnf and my.ini (1 Posts)   3,757 Edwin DeSouza 12/12/2012 08:19PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   4,887 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,978 Edwin DeSouza 10/21/2010 11:13AM
Sticky:  MySQL Performance Schema: A Big Bag of Epic Awesomeness (1 Posts)   10,326 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   160,789 Edwin DeSouza 05/25/2006 10:50AM
COUNT with GROUP BY, JOIN and SUBQUERY very slow   85 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   25 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   26 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   32 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   16 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   17 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   17 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   13 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   62 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   20 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   18 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   108 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   35 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   81 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   34 Rick James 02/16/2015 12:19AM
Query Optimization Needed   134 Devrishi Shandilya 02/11/2015 01:31AM
Re: Query Optimization Needed   45 Peter Brawley 02/11/2015 12:42PM
Re: Query Optimization Needed   43 Devrishi Shandilya 02/12/2015 03:51AM
Re: Query Optimization Needed   46 Peter Brawley 02/12/2015 01:24PM
Re: Query Optimization Needed   38 Devrishi Shandilya 02/13/2015 06:53AM
Re: Query Optimization Needed   38 Peter Brawley 02/13/2015 07:36AM
Re: Query Optimization Needed   43 Rick James 02/14/2015 01:04AM
Re: Query Optimization Needed   38 Devrishi Shandilya 02/15/2015 11:07PM
Re: Query Optimization Needed   35 Rick James 02/16/2015 12:15AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   135 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   59 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   155 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   74 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   65 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   70 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   67 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   192 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   93 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   74 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   80 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   256 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   92 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   87 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   98 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   81 Rick James 01/13/2015 04:21PM
How To Use More Resources   232 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   81 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   112 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   103 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   85 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   69 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   80 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   180 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   78 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   80 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   203 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   82 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   80 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   227 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   82 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   210 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   126 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   335 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   155 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   152 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   105 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   92 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   110 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   80 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   279 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   128 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   113 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   142 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   124 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   258 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   156 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   121 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   124 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   113 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   119 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   108 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   106 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   116 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   350 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   152 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   273 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   107 Rick James 11/28/2014 06:59PM
Cardinality Problem   317 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   112 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   110 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   102 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   386 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   156 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   152 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   182 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   144 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   194 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   149 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   163 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   120 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   127 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   119 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   364 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   183 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   119 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   123 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   125 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   117 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   359 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   180 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   140 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   159 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   144 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   150 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   407 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   156 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   140 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   138 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   139 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   151 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   152 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   129 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   632 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   343 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   295 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   245 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   199 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   213 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   163 Ravi Malghan 11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support   418 Christine Ross 10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support   267 Peter Brawley 10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support   242 Christine Ross 10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support   219 Rick James 11/02/2014 09:33AM
GROUP causing Using Temporary Using Filesort   2,192 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   973 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   889 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   747 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   580 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   494 Rick James 08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort   406 RT Lee 08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort   428 Rick James 08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort   314 Leonardo Duque 10/30/2014 12:57PM
Leonardo, please do not hijack threads   254 Peter Brawley 10/31/2014 11:15AM
Eliminate filesort in update query   532 Matzz - 09/23/2014 02:48AM
Re: Eliminate filesort in update query   221 Rick James 09/23/2014 09:59PM
Re: Eliminate filesort in update query   208 Matzz - 09/24/2014 01:25AM
Re: Eliminate filesort in update query   229 Rick James 09/24/2014 08:40PM
Re: Eliminate filesort in update query   222 Matzz - 09/25/2014 05:48AM
Re: Eliminate filesort in update query   216 Rick James 09/26/2014 04:39PM
Re: Eliminate filesort in update query   237 Matzz - 10/01/2014 06:49AM
Re: Eliminate filesort in update query   216 Rick James 10/03/2014 10:09PM
Re: Eliminate filesort in update query   227 Matzz - 10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table   419 Jeetu Gaur 09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table   205 Rick James 09/27/2014 08:16AM
Slow response time due queries   620 Jens Meier 09/23/2014 01:32AM
Re: Slow response time due queries   249 Rick James 09/23/2014 10:11PM
PHP/MySQL to use all CPU/memory to increase performance   506 Caleb Pitman 09/21/2014 11:04AM
Re: PHP/MySQL to use all CPU/memory to increase performance   255 Rick James 09/22/2014 03:39PM
Re: PHP/MySQL to use all CPU/memory to increase performance   275 Caleb Pitman 09/22/2014 04:55PM
Re: PHP/MySQL to use all CPU/memory to increase performance   238 Rick James 09/23/2014 03:21PM
How to set mysql CPU affinity?   691 Metal Messiah 09/21/2014 01:33PM
Re: How to set mysql CPU affinity?   346 Rick James 09/22/2014 03:25PM
Re: How to set mysql CPU affinity?   322 Sophia Parsons 09/23/2014 01:30AM
Re: How to set mysql CPU affinity?   303 Rick James 09/23/2014 11:03AM
Query optimization to reduce execution time.   450 Neetu Nayak 09/22/2014 07:33AM
Re: Query optimization to reduce execution time.   255 Rick James 09/22/2014 08:46PM
Re: Query optimization to reduce execution time.   241 Neetu Nayak 09/23/2014 12:38AM
Re: Query optimization to reduce execution time.   228 Neetu Nayak 09/23/2014 01:42AM
Mass Update optimization   522 Susan Lin 09/14/2014 06:00PM
Re: Mass Update optimization   245 Rick James 09/15/2014 11:38AM
Re: Mass Update optimization   218 Sophia Parsons 09/23/2014 01:36AM
Optimising query with composite index, which says using where   453 Timothy Mifsud 09/06/2014 12:38AM
Re: Optimising query with composite index, which says using where   196 Timothy Mifsud 09/06/2014 01:53AM
Re: Optimising query with composite index, which says using where   188 Rick James 09/07/2014 10:46PM
Re: Optimising query with composite index, which says using where   180 Øystein Grøvlen 09/15/2014 06:03AM
Re: Optimising query with composite index, which says using where   177 Rick James 09/15/2014 10:03AM
Slow Performance with Multi-threaded app   479 Minesh Desai 09/12/2014 09:24AM
Re: Slow Performance with Multi-threaded app   216 Rick James 09/13/2014 09:47AM
InnoDB and locking, UPDATE and SELECT   461 Andreas Greulich 09/10/2014 01:18AM
Re: InnoDB and locking, UPDATE and SELECT   211 Rick James 09/13/2014 12:09AM
MySQL using too much CPU   507 31 Special 08/29/2014 05:12PM
Re: MySQL using too much CPU   256 Rick James 08/30/2014 05:27PM
Re: MySQL using too much CPU   321 31 Special 08/31/2014 10:13PM
Understanding Explain   500 J M 08/27/2014 07:31AM
Re: Understanding Explain   258 Peter Brawley 08/27/2014 10:35AM
Re: Understanding Explain   207 J M 08/27/2014 10:51AM
Re: Understanding Explain   204 Øystein Grøvlen 08/28/2014 03:00PM
Re: Understanding Explain   198 Rick James 08/29/2014 09:45PM
Need help to otimize my query   446 GAURAV JAIN 08/21/2014 07:28AM
Re: Need help to otimize my query   252 Rick James 08/24/2014 09:17PM
Slow response in MY SQL 5.5.1.8   473 Amila Kumara 07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8   247 Rick James 07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8   267 Amila Kumara 07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8   276 Rick James 07/23/2014 12:19AM
Help in tuning MySQL 5.6 database   475 Deepak Dambe 07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database   251 Rick James 07/18/2014 12:12PM
Query slows down over time   633 Sameer Shah 05/28/2014 09:35AM
Re: Query slows down over time   319 Peter Brawley 05/28/2014 12:45PM
Re: Query slows down over time   293 Sameer Shah 05/28/2014 01:24PM
Re: Query slows down over time   334 Rick James 05/28/2014 04:57PM
Re: Query slows down over time   356 Sameer Shah 05/28/2014 05:46PM
Re: Query slows down over time   327 Rick James 05/28/2014 07:23PM
Re: Query slows down over time   477 Sam Shah 05/29/2014 05:38AM
Re: Query slows down over time   317 Rick James 05/29/2014 09:49AM
Re: Query slows down over time   326 Sam Shah 05/29/2014 03:12PM
Re: Query slows down over time   271 Sam Shah 07/15/2014 12:10PM
Re: Query slows down over time   275 Peter Brawley 07/15/2014 12:33PM
Re: Query slows down over time   230 Rick James 07/16/2014 11:19AM
Performance problem with outer join   534 RT Lee 07/11/2014 07:53AM
Re: Performance problem with outer join   276 Peter Brawley 07/11/2014 09:26AM
Re: Performance problem with outer join   269 Rick James 07/11/2014 04:26PM
Re: Performance problem with outer join   249 RT Lee 07/13/2014 12:29PM
Where to look for server freezes   486 Michael Muratet 07/10/2014 10:08AM
Re: Where to look for server freezes   218 Rick James 07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order   668 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   347 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   397 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   327 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   352 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   1,117 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   357 Rick James 06/26/2014 06:19PM
MySQL hangs due to large delete   548 Akshay Viswanathan 06/25/2014 08:51AM
Re: MySQL hangs due to large delete   272 Rick James 06/26/2014 06:13PM
Superkey vs Primary Key   756 Mario Schill 06/16/2014 04:13AM
Re: Superkey vs Primary Key   359 Peter Brawley 06/16/2014 10:42AM
Re: Superkey vs Primary Key   314 Mario Schill 06/17/2014 12:57AM
Re: Superkey vs Primary Key   344 Peter Brawley 06/17/2014 03:42AM
DML operations slow down   559 Sivaprakash Gopal 06/04/2014 04:43PM
Re: DML operations slow down   310 Rick James 06/06/2014 09:18AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 70

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.