Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Utilities 1.6.2 Beta has been released 08/31/2015 02:28PM
MySQL Enterprise Monitor 3.0.24 has been released 08/28/2015 01:07PM
MySQL Connector/NET 6.9.7 has been released 08/05/2015 06:38AM
MySQL Community Server 5.7.8 has been released (part 3/3) 08/03/2015 09:14AM
MySQL Community Server 5.7.8 has been released (part 2/3) 08/03/2015 09:12AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 71
Subject Views Written By Posted
Sticky:  MySQL 5.7: includes SYS Schema (metrics, instumentation) (1 Posts)   431 Edwin Desouza 04/10/2015 02:40PM
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)   665 Edwin Desouza 02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   1,372 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.7 DMR: Performance Benchmarks - 1Mil QPS (1 Posts)   2,264 Edwin Desouza 09/21/2013 11:11AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   2,900 Edwin Desouza 02/12/2013 06:11PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   5,318 Edwin DeSouza 08/04/2011 09:09AM
Sticky:  MySQL Performance Schema: A Big Bag of Epic Awesomeness (1 Posts)   10,809 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   162,819 Edwin DeSouza 05/25/2006 10:50AM
MYSql Query - #2013 - Lost connection to MySQL server during query   46 gourav kaila 08/27/2015 01:50PM
Re: MYSql Query - #2013 - Lost connection to MySQL server during query   14 Peter Brawley 08/27/2015 09:43PM
Delete query not using index and cause deadlock   90 Devrishi Shandilya 08/20/2015 06:28AM
Re: Delete query not using index and cause deadlock   22 Øystein Grøvlen 08/21/2015 07:13AM
Re: Delete query not using index and cause deadlock   20 Rick James 08/22/2015 03:48PM
Re: Delete query not using index and cause deadlock   20 Øystein Grøvlen 08/24/2015 02:35AM
Re: Delete query not using index and cause deadlock   23 Rick James 08/24/2015 12:27PM
Re: Delete query not using index and cause deadlock   20 Øystein Grøvlen 08/25/2015 02:57AM
Help for checking server configuration   78 Michele Quaini 08/16/2015 11:08AM
Re: Help for checking server configuration   30 Rick James 08/17/2015 10:56AM
Re: Help for checking server configuration   27 Michele Quaini 08/19/2015 09:32AM
Re: Help for checking server configuration   20 Rick James 08/22/2015 02:59PM
Deadlock issue and table lock frequently   120 Devrishi Shandilya 08/07/2015 02:57AM
Re: Deadlock issue and table lock frequently   45 Rick James 08/07/2015 10:09PM
Re: Deadlock issue and table lock frequently   42 Devrishi Shandilya 08/17/2015 02:50AM
Re: Deadlock issue and table lock frequently   26 Rick James 08/18/2015 09:23PM
Re: Deadlock issue and table lock frequently   48 Devrishi Shandilya 08/20/2015 12:06AM
Re: Deadlock issue and table lock frequently   25 Rick James 08/22/2015 01:45PM
Deleted Records and Optimize   73 Luis Cavazos 08/21/2015 08:08AM
Re: Deleted Records and Optimize   15 Rick James 08/22/2015 11:13AM
table_cache   99 Julian König 08/13/2015 01:19AM
Re: table_cache   32 Rick James 08/15/2015 04:19PM
Re: table_cache   32 Julian König 08/16/2015 01:24PM
Re: table_cache   31 Rick James 08/17/2015 09:30AM
Best Index Strategy   118 Devrishi Shandilya 08/09/2015 11:35PM
Re: Best Index Strategy   37 Rick James 08/10/2015 07:02AM
Re: Best Index Strategy   40 Rick James 08/10/2015 07:17AM
Re: Best Index Strategy   37 Devrishi Shandilya 08/10/2015 11:30PM
Re: Best Index Strategy   37 Devrishi Shandilya 08/12/2015 10:53PM
Re: Best Index Strategy   26 Rick James 08/15/2015 04:34PM
Re: Best Index Strategy   31 Devrishi Shandilya 08/16/2015 11:53PM
Utilize maximum system resources for better performance   225 Ronald Brown 07/14/2015 01:54AM
Re: Utilize maximum system resources for better performance   73 Ronald Brown 07/14/2015 01:58AM
Re: Utilize maximum system resources for better performance   61 Ronald Brown 07/14/2015 02:12AM
Re: Utilize maximum system resources for better performance   63 Peter Brawley 07/14/2015 11:30AM
Re: Utilize maximum system resources for better performance   61 Ronald Brown 07/14/2015 11:57AM
Re: Utilize maximum system resources for better performance   65 Rick James 07/15/2015 08:36PM
Re: Utilize maximum system resources for better performance   44 Ronald Brown 07/30/2015 07:22AM
Re: Utilize maximum system resources for better performance   44 Ronald Brown 07/30/2015 07:26AM
Re: Utilize maximum system resources for better performance   41 Rick James 07/31/2015 10:20PM
Re: Utilize maximum system resources for better performance   39 Ronald Brown 08/02/2015 01:27AM
Re: Utilize maximum system resources for better performance   43 Rick James 08/02/2015 11:10AM
Re: Utilize maximum system resources for better performance   30 Ronald Brown 08/08/2015 01:27AM
Re: Utilize maximum system resources for better performance   38 Rick James 08/08/2015 11:49AM
Re: Utilize maximum system resources for better performance   31 Ronald Brown 08/08/2015 01:01PM
Re: Utilize maximum system resources for better performance   30 Rick James 08/08/2015 03:43PM
Re: Utilize maximum system resources for better performance   32 Ronald Brown 08/09/2015 12:40AM
Re: Utilize maximum system resources for better performance   29 Ronald Brown 08/09/2015 07:33AM
Re: Utilize maximum system resources for better performance   34 Rick James 08/09/2015 03:53PM
Re: Utilize maximum system resources for better performance   28 Ronald Brown 08/09/2015 08:04PM
Re: Utilize maximum system resources for better performance   28 Rick James 08/09/2015 11:17PM
Re: Utilize maximum system resources for better performance   29 Ronald Brown 08/10/2015 12:00AM
Re: Utilize maximum system resources for better performance   29 Ronald Brown 08/10/2015 08:36AM
Re: Utilize maximum system resources for better performance   33 Rick James 08/10/2015 11:00AM
Re: Utilize maximum system resources for better performance   29 Rick James 08/10/2015 11:03AM
Re: Utilize maximum system resources for better performance   31 Ronald Brown 08/09/2015 01:07AM
Select last date check all rows   204 Pär Nordlund 08/04/2015 08:47AM
Re: Select last date check all rows   43 Rick James 08/05/2015 05:49PM
Re: Select last date check all rows   42 Pär Nordlund 08/06/2015 03:11AM
Re: Select last date check all rows   36 Pär Nordlund 08/06/2015 03:13AM
Re: Select last date check all rows   39 Rick James 08/06/2015 10:36PM
Re: Select last date check all rows   34 Pär Nordlund 08/07/2015 04:12AM
Re: Select last date check all rows   38 Rick James 08/08/2015 11:11AM
Number of table Partitions   140 Jawahar muthukrishnan 07/22/2015 01:24PM
Re: Number of table Partitions   56 Rick James 07/24/2015 03:14PM
Re: Number of table Partitions   35 Jeeva M 07/31/2015 02:15PM
Slow Query Urgent   175 a m 07/23/2015 09:21AM
Re: Slow Query Urgent   64 Peter Brawley 07/23/2015 10:19AM
Re: Slow Query Urgent   56 Rick James 07/24/2015 04:00PM
MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU   181 Timothy Mifsud 07/16/2015 07:50AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU   64 Peter Brawley 07/16/2015 09:39AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU   61 Rick James 07/17/2015 04:01PM
SELECT never completes   169 James Cobban 07/06/2015 10:08PM
Re: SELECT never completes   72 Peter Brawley 07/06/2015 11:51PM
Re: SELECT never completes   71 James Cobban 07/07/2015 02:16AM
Re: SELECT never completes   69 Rick James 07/09/2015 12:55AM
5.5: UPDATE massively slower than SELECT. Both affect zero rows.   301 Andy Theuninck 05/21/2015 10:09AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   121 Øystein Grøvlen 05/22/2015 02:19AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   135 Andy Theuninck 05/22/2015 08:15AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   95 Rick James 06/06/2015 12:30PM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   83 Chandan Kumar 06/26/2015 08:24AM
Performance Issue for select query   244 amar singh chawan 06/08/2015 04:58AM
Re: Performance Issue for select query   93 Rick James 06/09/2015 11:42PM
Best Training Institute for Mysql performace tuning and Database scalabulity   199 amar singh chawan 06/07/2015 11:42PM
Is ORDER BY RAND() LIMIT 1 optimized?   298 Markus M. 05/27/2015 05:40PM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   114 Øystein Grøvlen 05/28/2015 02:18AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   107 Markus M. 05/28/2015 07:22AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   106 Øystein Grøvlen 05/28/2015 07:49AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   94 Rick James 06/06/2015 12:16PM
Strange behavior of MySQL server   265 Deepak Itkar 05/27/2015 07:33AM
Re: Strange behavior of MySQL server   87 Rick James 06/06/2015 11:51AM
heavy read workload with high cpu usage   277 kim alex 05/28/2015 04:37AM
Re: heavy read workload with high cpu usage   97 Rick James 06/04/2015 08:35AM
query performance on partitioning table   321 sixin yang 05/12/2015 09:00AM
Re: query performance on partitioning table   124 Rick James 05/16/2015 11:49PM
Re: query performance on partitioning table   106 sixin yang 05/18/2015 08:30AM
Re: query performance on partitioning table   89 Rick James 06/04/2015 08:22AM
Avoid subquery   324 Wolfgang Jacques 05/12/2015 08:40AM
Re: Avoid subquery   112 Peter Brawley 05/12/2015 11:06AM
Re: Avoid subquery   115 Wolfgang Jacques 05/12/2015 01:29PM
Re: Avoid subquery   118 Peter Brawley 05/12/2015 01:41PM
Re: Avoid subquery   114 Rick James 05/17/2015 12:11AM
MYSQL Table Optimization   287 Yudhveer Kandukuri 05/13/2015 09:53PM
Re: MYSQL Table Optimization   115 Rick James 05/15/2015 11:02AM
Slow query   375 Manu Swami 04/21/2015 11:15AM
Re: Slow query   136 Maulik Parekh 04/22/2015 07:17AM
Re: Slow query   131 Rick James 04/22/2015 07:05PM
Re: Slow query   153 Manu Swami 04/23/2015 11:42PM
Re: Slow query   139 Manu Swami 04/23/2015 11:55PM
Re: Slow query   128 Rick James 04/24/2015 05:22PM
Re: Slow query   126 Manu Swami 04/25/2015 02:31AM
Re: Slow query   131 Manu Swami 04/25/2015 02:41AM
Re: Slow query   150 Manu Swami 04/25/2015 05:22AM
Re: Slow query   138 Rick James 04/25/2015 10:42PM
Re: Slow query   112 Øystein Grøvlen 05/13/2015 03:30AM
Re: Slow query   126 Manu Swami 04/28/2015 03:40AM
CPU usage extremely high   396 Temu Kinn 04/28/2015 08:55AM
Re: CPU usage extremely high   185 Temu Kinn 04/28/2015 09:03AM
Re: CPU usage extremely high   169 Rick James 04/29/2015 05:43PM
Re: CPU usage extremely high   154 Temu Kinn 05/09/2015 07:22AM
Re: CPU usage extremely high   140 Temu Kinn 05/09/2015 07:38AM
Re: CPU usage extremely high   141 Rick James 05/11/2015 06:30PM
Mysql indexes weird behavior   279 Nikhil Khekade 05/02/2015 02:17AM
Re: Mysql indexes weird behavior   121 Rick James 05/03/2015 06:21PM
slow query sorting result - sending data   408 Hugo Rodriguez 04/28/2015 07:27PM
Re: slow query sorting result - sending data   152 Peter Brawley 04/28/2015 10:38PM
Re: slow query sorting result - sending data   139 Rick James 05/01/2015 10:08PM
PROFILING   371 Khurram Naseem 04/27/2015 04:26AM
Re: PROFILING   126 Rick James 04/29/2015 06:53PM
Query time difference   600 Ofer Bechar 04/26/2015 07:28AM
Re: Query time difference   127 Rick James 04/27/2015 02:39PM
Re: Query time difference   132 Ofer Bechar 04/27/2015 11:29PM
Re: Query time difference   121 Rick James 04/29/2015 05:50PM
Performance issues with INNODB vs MyISAM   665 Milovan Krivokapic 04/17/2015 01:20PM
Re: Performance issues with INNODB vs MyISAM   201 Rick James 04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM   168 Milovan Krivokapic 04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM   140 Rick James 04/28/2015 10:34AM
Why mysqlslap doesn't return the correct Benchmark time?   350 Cai Vincent 04/20/2015 08:07AM
Writing at 847 MB/sec ???   360 Robert Gunther 04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???   154 Rick James 04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???   151 Robert Gunther 04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???   135 Rick James 04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???   135 Robert Gunther 04/20/2015 01:00AM
Mysql is consuming xtremely high CPU above 1000%   409 Eric Leung 04/11/2015 04:38PM
Re: Mysql is consuming xtremely high CPU above 1000%   246 Eric Leung 04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%   180 Rick James 04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%   181 Eric Leung 04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%   179 Rick James 04/17/2015 08:05PM
Re: Mysql is consuming xtremely high CPU above 1000%   208 Eric Leung 04/18/2015 06:07AM
Re: Mysql is consuming xtremely high CPU above 1000%   213 Rick James 04/19/2015 02:19PM
Client to server connection   343 Dan Toškan 04/14/2015 12:40PM
Re: Client to server connection   146 Peter Brawley 04/14/2015 11:18PM
Re: Client to server connection   132 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)   424 Ola Arwidsson 03/26/2015 06:40AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   182 Peter Brawley 03/26/2015 10:45AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   175 Ola Arwidsson 03/30/2015 01:22AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   163 Ola Arwidsson 03/30/2015 03:27AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   181 Peter Brawley 03/30/2015 11:16AM
system table space vs file per table space   341 jongse park 03/27/2015 12:35AM
Re: system table space vs file per table space   165 Rick James 03/28/2015 03:36PM
Slow COUNT + GROUP BY   484 Refael Dakar 03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY   216 Jeremy Smyth 03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY   223 Refael Dakar 03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY   203 Rick James 03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY   221 Refael Dakar 03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY   210 Øystein Grøvlen 03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY   191 Matan K 03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY   211 Øystein Grøvlen 03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY   187 Matan K 03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY   192 Øystein Grøvlen 03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY   185 Matan K 03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY   200 Øystein Grøvlen 03/24/2015 03:37AM
Query Optimization Needed   498 Devrishi Shandilya 02/11/2015 01:31AM
Re: Query Optimization Needed   240 Peter Brawley 02/11/2015 12:42PM
Re: Query Optimization Needed   240 Devrishi Shandilya 02/12/2015 03:51AM
Re: Query Optimization Needed   218 Peter Brawley 02/12/2015 01:24PM
Re: Query Optimization Needed   261 Devrishi Shandilya 02/13/2015 06:53AM
Re: Query Optimization Needed   217 Peter Brawley 02/13/2015 07:36AM
Re: Query Optimization Needed   218 Rick James 02/14/2015 01:04AM
Re: Query Optimization Needed   219 Devrishi Shandilya 02/15/2015 11:07PM
Re: Query Optimization Needed   218 Rick James 02/16/2015 12:15AM
Re: Query Optimization Needed   176 Peter Brawley 03/13/2015 11:15AM
Exceedingly slow create table performance   461 Ronald Van Iwaarden 03/06/2015 10:51AM
Re: Exceedingly slow create table performance   210 Rick James 03/07/2015 11:03AM
Re: Exceedingly slow create table performance   185 Ronald Van Iwaarden 03/09/2015 10:10AM
Left join optimization- query is very slow   556 Devrishi Shandilya 03/05/2015 05:23AM
Re: Left join optimization- query is very slow   259 Øystein Grøvlen 03/05/2015 09:12AM
Re: Left join optimization- query is very slow   334 Rick James 03/06/2015 06:48PM
Re: Left join optimization- query is very slow   233 Devrishi Shandilya 03/08/2015 11:32PM
COUNT with GROUP BY, JOIN and SUBQUERY very slow   590 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   233 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   226 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   218 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   231 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   210 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   203 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   213 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   413 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   205 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   200 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   493 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   202 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   500 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   209 Rick James 02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   573 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   255 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   552 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   247 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   234 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   254 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   235 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   541 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   280 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   264 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   302 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   780 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   345 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   319 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   382 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   322 Rick James 01/13/2015 04:21PM
How To Use More Resources   598 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   256 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   315 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   307 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   260 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   255 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   269 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   513 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   252 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   269 Rick James 01/07/2015 05:02PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 71

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.