Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Community Server 5.5.44 has been released 05/29/2015 02:02AM
MySQL Connector/Python 2.1.2 Beta has been released 04/30/2015 07:02PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 70
Subject Views Written By Posted
Sticky:  MySQL 5.7: includes SYS Schema (metrics, instumentation) (1 Posts)   222 Edwin Desouza 04/10/2015 02:40PM
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)   373 Edwin Desouza 02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   1,171 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.7 DMR: Performance Benchmarks - 1Mil QPS (1 Posts)   2,032 Edwin Desouza 09/21/2013 11:11AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   2,681 Edwin Desouza 02/12/2013 06:11PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   5,114 Edwin DeSouza 08/04/2011 09:09AM
Sticky:  MySQL Performance Schema: A Big Bag of Epic Awesomeness (1 Posts)   10,564 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   161,804 Edwin DeSouza 05/25/2006 10:50AM
Is ORDER BY RAND() LIMIT 1 optimized?   43 Markus M. 05/27/2015 05:40PM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   13 Øystein Grøvlen 05/28/2015 02:18AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   13 Markus M. 05/28/2015 07:22AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   9 Øystein Grøvlen 05/28/2015 07:49AM
heavy read workload with high cpu usage   36 kim alex 05/28/2015 04:37AM
Strange behavior of MySQL server   51 Deepak Itkar 05/27/2015 07:33AM
5.5: UPDATE massively slower than SELECT. Both affect zero rows.   88 Andy Theuninck 05/21/2015 10:09AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   22 Øystein Grøvlen 05/22/2015 02:19AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   24 Andy Theuninck 05/22/2015 08:15AM
query performance on partitioning table   106 sixin yang 05/12/2015 09:00AM
Re: query performance on partitioning table   32 Rick James 05/16/2015 11:49PM
Re: query performance on partitioning table   22 sixin yang 05/18/2015 08:30AM
Avoid subquery   113 Wolfgang Jacques 05/12/2015 08:40AM
Re: Avoid subquery   34 Peter Brawley 05/12/2015 11:06AM
Re: Avoid subquery   32 Wolfgang Jacques 05/12/2015 01:29PM
Re: Avoid subquery   30 Peter Brawley 05/12/2015 01:41PM
Re: Avoid subquery   29 Rick James 05/17/2015 12:11AM
MYSQL Table Optimization   84 Yudhveer Kandukuri 05/13/2015 09:53PM
Re: MYSQL Table Optimization   29 Rick James 05/15/2015 11:02AM
Slow query   172 Manu Swami 04/21/2015 11:15AM
Re: Slow query   56 Maulik Parekh 04/22/2015 07:17AM
Re: Slow query   42 Rick James 04/22/2015 07:05PM
Re: Slow query   56 Manu Swami 04/23/2015 11:42PM
Re: Slow query   52 Manu Swami 04/23/2015 11:55PM
Re: Slow query   51 Rick James 04/24/2015 05:22PM
Re: Slow query   48 Manu Swami 04/25/2015 02:31AM
Re: Slow query   50 Manu Swami 04/25/2015 02:41AM
Re: Slow query   56 Manu Swami 04/25/2015 05:22AM
Re: Slow query   53 Rick James 04/25/2015 10:42PM
Re: Slow query   30 Øystein Grøvlen 05/13/2015 03:30AM
Re: Slow query   43 Manu Swami 04/28/2015 03:40AM
CPU usage extremely high   160 Temu Kinn 04/28/2015 08:55AM
Re: CPU usage extremely high   59 Temu Kinn 04/28/2015 09:03AM
Re: CPU usage extremely high   63 Rick James 04/29/2015 05:43PM
Re: CPU usage extremely high   37 Temu Kinn 05/09/2015 07:22AM
Re: CPU usage extremely high   38 Temu Kinn 05/09/2015 07:38AM
Re: CPU usage extremely high   30 Rick James 05/11/2015 06:30PM
Mysql indexes weird behavior   109 Nikhil Khekade 05/02/2015 02:17AM
Re: Mysql indexes weird behavior   41 Rick James 05/03/2015 06:21PM
slow query sorting result - sending data   163 Hugo Rodriguez 04/28/2015 07:27PM
Re: slow query sorting result - sending data   54 Peter Brawley 04/28/2015 10:38PM
Re: slow query sorting result - sending data   48 Rick James 05/01/2015 10:08PM
PROFILING   152 Khurram Naseem 04/27/2015 04:26AM
Re: PROFILING   38 Rick James 04/29/2015 06:53PM
Query time difference   148 Ofer Bechar 04/26/2015 07:28AM
Re: Query time difference   41 Rick James 04/27/2015 02:39PM
Re: Query time difference   49 Ofer Bechar 04/27/2015 11:29PM
Re: Query time difference   36 Rick James 04/29/2015 05:50PM
Performance issues with INNODB vs MyISAM   323 Milovan Krivokapic 04/17/2015 01:20PM
Re: Performance issues with INNODB vs MyISAM   94 Rick James 04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM   61 Milovan Krivokapic 04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM   49 Rick James 04/28/2015 10:34AM
Why mysqlslap doesn't return the correct Benchmark time?   175 Cai Vincent 04/20/2015 08:07AM
Writing at 847 MB/sec ???   192 Robert Gunther 04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???   72 Rick James 04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???   71 Robert Gunther 04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???   57 Rick James 04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???   58 Robert Gunther 04/20/2015 01:00AM
Mysql is consuming xtremely high CPU above 1000%   206 Eric Leung 04/11/2015 04:38PM
Re: Mysql is consuming xtremely high CPU above 1000%   104 Eric Leung 04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%   84 Rick James 04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%   85 Eric Leung 04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%   84 Rick James 04/17/2015 08:05PM
Re: Mysql is consuming xtremely high CPU above 1000%   89 Eric Leung 04/18/2015 06:07AM
Re: Mysql is consuming xtremely high CPU above 1000%   91 Rick James 04/19/2015 02:19PM
Client to server connection   173 Dan Toškan 04/14/2015 12:40PM
Re: Client to server connection   68 Peter Brawley 04/14/2015 11:18PM
Re: Client to server connection   57 Rick James 04/17/2015 08:09PM
This topic has been moved.:  Mysql NDB Cluster   36 SRINIVASA RAO PUJARI 04/01/2015 11:23PM
Fast way to have an inparameter match all values? (COALESCE slow)   242 Ola Arwidsson 03/26/2015 06:40AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   98 Peter Brawley 03/26/2015 10:45AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   96 Ola Arwidsson 03/30/2015 01:22AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   86 Ola Arwidsson 03/30/2015 03:27AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   95 Peter Brawley 03/30/2015 11:16AM
system table space vs file per table space   195 jongse park 03/27/2015 12:35AM
Re: system table space vs file per table space   85 Rick James 03/28/2015 03:36PM
Slow COUNT + GROUP BY   289 Refael Dakar 03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY   119 Jeremy Smyth 03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY   118 Refael Dakar 03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY   107 Rick James 03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY   118 Refael Dakar 03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY   118 Øystein Grøvlen 03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY   108 Matan K 03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY   121 Øystein Grøvlen 03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY   110 Matan K 03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY   102 Øystein Grøvlen 03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY   107 Matan K 03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY   114 Øystein Grøvlen 03/24/2015 03:37AM
Query Optimization Needed   348 Devrishi Shandilya 02/11/2015 01:31AM
Re: Query Optimization Needed   155 Peter Brawley 02/11/2015 12:42PM
Re: Query Optimization Needed   152 Devrishi Shandilya 02/12/2015 03:51AM
Re: Query Optimization Needed   140 Peter Brawley 02/12/2015 01:24PM
Re: Query Optimization Needed   174 Devrishi Shandilya 02/13/2015 06:53AM
Re: Query Optimization Needed   130 Peter Brawley 02/13/2015 07:36AM
Re: Query Optimization Needed   139 Rick James 02/14/2015 01:04AM
Re: Query Optimization Needed   134 Devrishi Shandilya 02/15/2015 11:07PM
Re: Query Optimization Needed   134 Rick James 02/16/2015 12:15AM
Re: Query Optimization Needed   98 Peter Brawley 03/13/2015 11:15AM
Exceedingly slow create table performance   273 Ronald Van Iwaarden 03/06/2015 10:51AM
Re: Exceedingly slow create table performance   126 Rick James 03/07/2015 11:03AM
Re: Exceedingly slow create table performance   105 Ronald Van Iwaarden 03/09/2015 10:10AM
Left join optimization- query is very slow   340 Devrishi Shandilya 03/05/2015 05:23AM
Re: Left join optimization- query is very slow   164 Øystein Grøvlen 03/05/2015 09:12AM
Re: Left join optimization- query is very slow   194 Rick James 03/06/2015 06:48PM
Re: Left join optimization- query is very slow   139 Devrishi Shandilya 03/08/2015 11:32PM
COUNT with GROUP BY, JOIN and SUBQUERY very slow   387 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   140 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   140 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   132 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   148 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   130 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   122 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   129 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   269 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   122 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   121 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   342 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   129 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   303 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   131 Rick James 02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   387 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   166 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   386 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   168 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   156 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   173 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   158 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   390 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   196 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   179 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   197 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   555 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   215 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   206 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   249 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   208 Rick James 01/13/2015 04:21PM
How To Use More Resources   439 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   175 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   219 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   210 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   179 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   166 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   182 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   381 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   179 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   181 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   384 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   184 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   182 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   431 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   178 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   451 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   285 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   593 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   291 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   277 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   219 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   217 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   217 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   178 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   532 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   281 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   232 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   270 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   288 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   489 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   292 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   261 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   248 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   221 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   220 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   237 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   216 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   232 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   622 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   331 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   501 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   206 Rick James 11/28/2014 06:59PM
Cardinality Problem   517 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   205 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   205 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   194 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   655 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   275 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   253 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   300 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   267 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   328 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   287 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   273 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   233 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   256 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   248 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   606 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   311 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   224 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   222 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   228 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   218 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   620 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   306 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   243 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   276 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   247 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   260 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   626 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   273 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   245 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   234 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   236 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   262 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   252 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   228 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   1,156 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   614 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   497 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   440 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   360 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   368 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   294 Ravi Malghan 11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support   651 Christine Ross 10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support   398 Peter Brawley 10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support   361 Christine Ross 10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support   369 Rick James 11/02/2014 09:33AM
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.