Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Community Server 5.6.20 has been released 08/01/2014 05:22PM
MySQL Community Server 5.5.39 has been released 08/01/2014 01:43AM
MySQL Utilities 1.4.4 GA has been released 07/31/2014 09:12PM
MySQL Connector/C++ 1.1.4 has been released 07/31/2014 02:41PM
MySQL Connector/Python 2.0.0 Alpha has been released 07/24/2014 11:56AM
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)   398 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.7 DMR: Performance Benchmarks - 1Mil QPS (1 Posts)   1,203 Edwin Desouza 09/21/2013 11:11AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   1,876 Edwin Desouza 02/12/2013 06:11PM
Sticky:  MySQL 5.6: Server Default Config changes - my.cnf and my.ini (1 Posts)   3,031 Edwin DeSouza 12/12/2012 08:19PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   4,422 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,477 Edwin DeSouza 10/21/2010 11:13AM
Sticky:  MySQL Performance Schema: A Big Bag of Epic Awesomeness (1 Posts)   9,795 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   158,224 Edwin DeSouza 05/25/2006 10:50AM
GROUP causing Using Temporary Using Filesort   27 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   11 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   5 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   4 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   2 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   0 Rick James 08/01/2014 11:45PM
Slow response in MY SQL 5.5.1.8   75 Amila Kumara 07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8   35 Rick James 07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8   23 Amila Kumara 07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8   14 Rick James 07/23/2014 12:19AM
Help in tuning MySQL 5.6 database   59 Deepak Dambe 07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database   18 Rick James 07/18/2014 12:12PM
Query slows down over time   197 Sameer Shah 05/28/2014 09:35AM
Re: Query slows down over time   86 Peter Brawley 05/28/2014 12:45PM
Re: Query slows down over time   80 Sameer Shah 05/28/2014 01:24PM
Re: Query slows down over time   85 Rick James 05/28/2014 04:57PM
Re: Query slows down over time   81 Sameer Shah 05/28/2014 05:46PM
Re: Query slows down over time   79 Rick James 05/28/2014 07:23PM
Re: Query slows down over time   89 Sam Shah 05/29/2014 05:38AM
Re: Query slows down over time   82 Rick James 05/29/2014 09:49AM
Re: Query slows down over time   82 Sam Shah 05/29/2014 03:12PM
Re: Query slows down over time   25 Sam Shah 07/15/2014 12:10PM
Re: Query slows down over time   34 Peter Brawley 07/15/2014 12:33PM
Re: Query slows down over time   23 Rick James 07/16/2014 11:19AM
Performance problem with outer join   143 RT Lee 07/11/2014 07:53AM
Re: Performance problem with outer join   48 Peter Brawley 07/11/2014 09:26AM
Re: Performance problem with outer join   38 Rick James 07/11/2014 04:26PM
Re: Performance problem with outer join   25 RT Lee 07/13/2014 12:29PM
Where to look for server freezes   94 Michael Muratet 07/10/2014 10:08AM
Re: Where to look for server freezes   27 Rick James 07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order   180 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   58 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   59 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   56 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   50 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   239 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   91 Rick James 06/26/2014 06:19PM
MySQL hangs due to large delete   126 Akshay Viswanathan 06/25/2014 08:51AM
Re: MySQL hangs due to large delete   53 Rick James 06/26/2014 06:13PM
Superkey vs Primary Key   157 Mario Schill 06/16/2014 04:13AM
Re: Superkey vs Primary Key   64 Peter Brawley 06/16/2014 10:42AM
Re: Superkey vs Primary Key   49 Mario Schill 06/17/2014 12:57AM
Re: Superkey vs Primary Key   54 Peter Brawley 06/17/2014 03:42AM
DML operations slow down   158 Sivaprakash Gopal 06/04/2014 04:43PM
Re: DML operations slow down   93 Rick James 06/06/2014 09:18AM
how to configure my.cnf for mysql 5.1, using too much cpu?   201 Aamir Sohail 06/05/2014 06:15AM
Re: how to configure my.cnf for mysql 5.1, using too much cpu?   101 Rick James 06/06/2014 09:09AM
'Compound' INDEXes   153 lee fei 06/04/2014 03:24AM
Re: 'Compound' INDEXes   67 Rick James 06/05/2014 09:12PM
Delete slow... randomly   207 Francesco De Carlo 06/02/2014 09:15AM
Re: Delete slow... randomly   88 Rick James 06/03/2014 09:51AM
Re: Delete slow... randomly   80 Francesco De Carlo 06/04/2014 03:43AM
Re: Delete slow... randomly   71 Rick James 06/05/2014 08:01PM
concurrent_insert   176 Ben Zhou 06/01/2014 08:15AM
Re: concurrent_insert   74 Rick James 06/02/2014 11:53AM
Re: concurrent_insert   68 Ben Zhou 06/04/2014 08:37AM
Re: concurrent_insert   63 Rick James 06/05/2014 07:55PM
Queriy taking long time in OTRS   218 Rajkumar D 05/29/2014 03:53AM
Re: Queriy taking long time in OTRS   79 Rajkumar D 05/29/2014 01:11PM
Re: Queriy taking long time in OTRS   84 Rick James 05/30/2014 10:41AM
Re: Queriy taking long time in OTRS   75 Rajkumar D 05/30/2014 12:45PM
Re: Queriy taking long time in OTRS   82 Øystein Grøvlen 06/02/2014 03:52AM
Query attacks against read-only database   162 joe blake 05/29/2014 09:46PM
Re: Query attacks against read-only database   69 Rick James 05/31/2014 08:04AM
my.cnf file with mysql tuner   246 maurizio ca 05/26/2014 03:03AM
Re: my.cnf file with mysql tuner   119 Rick James 05/26/2014 07:29PM
Out of memory - on any moderate query   210 rol and 05/23/2014 12:58PM
Re: Out of memory - on any moderate query   90 Peter Brawley 05/23/2014 10:59PM
Re: Out of memory - on any moderate query   78 Rick James 05/24/2014 03:18PM
Low priority SELECT   176 Glas Host 05/21/2014 07:18AM
Re: Low priority SELECT   82 Rick James 05/24/2014 03:05PM
Performance improvement with my.cnf configs   248 Manohar K 04/23/2014 10:23AM
Re: Performance improvement with my.cnf configs   116 Rick James 04/24/2014 08:08PM
Re: Performance improvement with my.cnf configs   113 Manohar K 04/24/2014 09:41PM
Re: Performance improvement with my.cnf configs   128 Rick James 04/25/2014 08:24PM
Re: Performance improvement with my.cnf configs   105 Manohar K 05/06/2014 10:22AM
Adding index kills query   285 Robert Stafford 04/23/2014 06:10PM
Re: Adding index kills query   106 Robert Stafford 04/23/2014 06:14PM
Re: Adding index kills query   104 Øystein Grøvlen 04/24/2014 02:44AM
Re: Adding index kills query   114 Robert Stafford 04/24/2014 09:07AM
Re: Adding index kills query   97 Øystein Grøvlen 04/25/2014 07:39AM
Re: Adding index kills query   125 Robert Stafford 04/25/2014 11:54AM
Re: Adding index kills query   109 Rick James 04/25/2014 02:25PM
Re: Adding index kills query   104 Øystein Grøvlen 04/28/2014 06:06AM
Re: Adding index kills query   95 Peter Brawley 04/24/2014 09:37AM
Re: Adding index kills query   105 Robert Stafford 04/24/2014 06:31PM
Re: Adding index kills query   90 Peter Brawley 04/24/2014 07:10PM
Re: Adding index kills query   97 Robert Stafford 04/24/2014 07:19PM
Re: Adding index kills query   115 Rick James 04/25/2014 10:55AM
Re: Adding index kills query   103 Øystein Grøvlen 04/25/2014 11:02PM
Re: Adding index kills query   139 Robert Stafford 04/27/2014 07:53PM
Re: Adding index kills query   96 Peter Brawley 04/27/2014 08:50PM
Re: Adding index kills query   99 Rick James 04/27/2014 09:00PM
No response to SELECT with IN clause   264 James Cobban 04/21/2014 06:39PM
Re: No response to SELECT with IN clause   109 Peter Brawley 04/21/2014 09:54PM
Re: No response to SELECT with IN clause   114 Rick James 04/22/2014 12:01AM
Recommended changes to my.cnf   231 W B 04/19/2014 01:56PM
Re: Recommended changes to my.cnf   122 Rick James 04/20/2014 04:53PM
Re: Recommended changes to my.cnf   100 W B 04/20/2014 05:01PM
Re: Recommended changes to my.cnf   106 Rick James 04/21/2014 11:24PM
MySQL MyISAM sorting query makes it slower   255 Timothy Mifsud 04/13/2014 03:06AM
Re: MySQL MyISAM sorting query makes it slower   117 Rick James 04/13/2014 10:39PM
Re: MySQL MyISAM sorting query makes it slower   133 Timothy Mifsud 04/14/2014 02:10AM
Re: MySQL MyISAM sorting query makes it slower   129 Rick James 04/14/2014 12:23PM
Re: MySQL MyISAM sorting query makes it slower   136 Timothy Mifsud 04/14/2014 04:13PM
Re: MySQL MyISAM sorting query makes it slower   115 Rick James 04/14/2014 07:01PM
Re: MySQL MyISAM sorting query makes it slower   122 Timothy Mifsud 04/15/2014 01:00PM
Re: MySQL MyISAM sorting query makes it slower   116 Rick James 04/16/2014 12:26PM
MySQL query with timestamp not using index   317 Bruno Miguel 04/11/2014 11:52AM
Re: MySQL query with timestamp not using index   145 Bruno Miguel 04/11/2014 12:35PM
Re: MySQL query with timestamp not using index   142 Rick James 04/12/2014 09:49AM
Re: MySQL query with timestamp not using index   186 Bruno Miguel 04/14/2014 08:17AM
Re: MySQL query with timestamp not using index   148 Rick James 04/15/2014 03:21PM
MySQL MyISAM - Insert takes much longer on LIVE environment than locally   214 Timothy Mifsud 04/14/2014 08:40AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally   133 Edwin Desouza 04/14/2014 09:16AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally   122 Timothy Mifsud 04/14/2014 02:33PM
MySQL 5.5 who is creating temp tables on disk   224 Till Brinkmann 04/08/2014 02:36AM
Re: MySQL 5.5 who is creating temp tables on disk   134 Øystein Grøvlen 04/09/2014 05:58AM
Re: MySQL 5.5 who is creating temp tables on disk   140 Rick James 04/09/2014 02:30PM
Huge temp file on simple select   251 Pavel Dvořák 04/05/2014 10:12AM
Re: Huge temp file on simple select   124 Rick James 04/06/2014 07:30PM
Re: Huge temp file on simple select   114 Pavel Dvořák 04/07/2014 03:18AM
Re: Huge temp file on simple select   151 Rick James 04/08/2014 11:20AM
Re: Huge temp file on simple select   127 Pavel Dvořák 04/09/2014 02:20AM
Table locked   252 Rafael Pertence Pertence 04/02/2014 06:28AM
Re: Table locked   122 Jonathan Stephens 04/02/2014 09:02AM
Re: Table locked   122 Rafael Pertence Pertence 04/02/2014 09:08AM
Re: Table locked   132 Jonathan Stephens 04/02/2014 11:35PM
Re: Table locked   121 Rick James 04/04/2014 11:33PM
Mysqltuner output - advice   332 rol and 04/01/2014 01:16PM
Re: Mysqltuner output - advice   186 Rick James 04/04/2014 11:13PM
MySQL Performance Schema : Prepared Statements Instrumentation   269 Edwin Desouza 04/01/2014 08:17AM
High CPU usage on mysql   562 wayne chen 03/24/2014 10:23AM
Re: High CPU usage on mysql   209 Rick James 03/27/2014 04:36PM
Slow update with two like 'string%' conditions   318 Oleg Komarov 03/25/2014 04:09PM
Re: Slow update with two like 'string%' conditions   157 Øystein Grøvlen 03/26/2014 03:41AM
Creating Sort Index Slow   792 SHI CAI LING 03/14/2014 09:59PM
Re: Creating Sort Index Slow   399 Rick James 03/17/2014 11:59AM
Re: Creating Sort Index Slow   370 SHI CAI LING 03/17/2014 08:20PM
Re: Creating Sort Index Slow   305 Peter Brawley 03/17/2014 08:46PM
Re: Creating Sort Index Slow   293 Rick James 03/17/2014 10:31PM
Re: Creating Sort Index Slow   268 SHI CAI LING 03/18/2014 01:13AM
Re: Creating Sort Index Slow   234 Rick James 03/19/2014 04:56PM
Re: Creating Sort Index Slow   244 Rick James 03/19/2014 05:04PM
Re: Creating Sort Index Slow   219 SHI CAI LING 03/19/2014 10:06PM
Re: Creating Sort Index Slow   300 Rick James 03/19/2014 11:23PM
WHY : select count(*) not returning any results?   443 yvonne kire 02/19/2014 01:00PM
Re: WHY : select count(*) not returning any results?   273 Rick James 02/21/2014 06:21PM
Re: WHY : select count(*) not returning any results?   179 sharda salvi 03/12/2014 12:34AM
Re: WHY : select count(*) not returning any results?   182 Rick James 03/12/2014 01:06PM
MySQL 5.5 Queries occasionally extremely slow   593 Marc Host 03/03/2014 05:33PM
Re: MySQL 5.5 Queries occasionally extremely slow   197 Øystein Grøvlen 03/04/2014 03:29AM
Re: MySQL 5.5 Queries occasionally extremely slow   192 Marc Host 03/04/2014 12:43PM
Re: MySQL 5.5 Queries occasionally extremely slow   185 Øystein Grøvlen 03/05/2014 04:37AM
Re: MySQL 5.5 Queries occasionally extremely slow   211 Rick James 03/05/2014 10:32PM
Re: MySQL 5.5 Queries occasionally extremely slow   159 Marc Host 03/10/2014 02:18PM
Re: MySQL 5.5 Queries occasionally extremely slow   188 Marc Host 03/10/2014 02:16PM
Re: MySQL 5.5 Queries occasionally extremely slow   253 Marc Host 03/04/2014 01:24PM
Query with Inner Join to small table suddenly takes FOREVER   420 Adam Reese 03/06/2014 05:05PM
Re: Query with Inner Join to small table suddenly takes FOREVER   184 Øystein Grøvlen 03/07/2014 09:21AM
Re: Query with Inner Join to small table suddenly takes FOREVER   191 Adam Reese 03/07/2014 01:12PM
Re: Query with Inner Join to small table suddenly takes FOREVER   184 Rick James 03/08/2014 01:03PM
Re: Query with Inner Join to small table suddenly takes FOREVER   184 Øystein Grøvlen 03/10/2014 01:55AM
VARCHAR performance   353 Andrew Ling 03/06/2014 05:15AM
Re: VARCHAR performance   155 Øystein Grøvlen 03/07/2014 08:48AM
Re: VARCHAR performance   164 Andrew Ling 03/07/2014 10:01AM
Re: VARCHAR performance   157 Øystein Grøvlen 03/07/2014 10:13AM
Re: VARCHAR performance   156 Andrew Ling 03/07/2014 10:57AM
Re: VARCHAR performance   163 Rick James 03/08/2014 12:53PM
Huge performance differences between systems   330 Julien Galiano 03/05/2014 08:44AM
Re: Huge performance differences between systems   168 Peter Brawley 03/05/2014 09:44AM
Re: Huge performance differences between systems   163 Julien Galiano 03/05/2014 12:13PM
Re: Huge performance differences between systems   160 Peter Brawley 03/05/2014 01:14PM
Re: Huge performance differences between systems   152 Rick James 03/05/2014 10:49PM
Sporadic Query "Freeze" with InnoDB, highly concurrent workload   564 Steve Ramage 02/24/2014 04:36PM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   206 Rick James 02/25/2014 08:42PM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   220 Steve Ramage 02/25/2014 11:28PM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   222 Rick James 02/27/2014 12:11AM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   170 Steve Ramage 03/04/2014 10:17AM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   220 Steve Ramage 03/04/2014 10:15AM
Customization of Algorithm in MySQL   302 Bhumika Shah 03/02/2014 11:57PM
Re: Customization of Algorithm in MySQL   167 Øystein Grøvlen 03/03/2014 01:51AM
High load average (MySQL 5.6.16)   2,106 Peter Wells 02/19/2014 05:24AM
Re: High load average (MySQL 5.6.16)   384 Rick James 02/21/2014 06:12PM
Re: High load average (MySQL 5.6.16)   336 Peter Wells 02/26/2014 08:48AM
Re: High load average (MySQL 5.6.16)   567 Peter Wells 02/26/2014 08:49AM
Re: High load average (MySQL 5.6.16)   339 Rick James 02/26/2014 11:44PM
Is it reasonable that lock_time is not included when decide SERVER_QUERY_WAS_SLOW   370 xiaobin lin 02/17/2014 05:20AM
Re: Is it reasonable that lock_time is not included when decide SERVER_QUERY_WAS_SLOW   171 Rick James 02/20/2014 12:01PM
Performance Issius   410 Palin Patzke 02/17/2014 05:00AM
Re: Performance Issius   179 Øystein Grøvlen 02/20/2014 02:50AM
Re: Performance Issius   174 Palin Patzke 02/20/2014 10:48AM
Help in improving query performance   382 Bill Tidy 02/19/2014 03:44AM
Re: Help in improving query performance   204 Øystein Grøvlen 02/20/2014 04:15AM
MySQL with SSD/HDD   681 Tobias K. 02/10/2014 08:59AM
Re: MySQL with SSD/HDD   353 Rick James 02/11/2014 08:26PM
Re: MySQL with SSD/HDD   297 Tobias K. 02/13/2014 06:00AM
Re: MySQL with SSD/HDD   286 Rick James 02/14/2014 03:40PM
Re: MySQL with SSD/HDD   328 Tobias K. 02/18/2014 05:03AM
CPU Usage Maxing Out   564 Anna M 02/03/2014 05:39PM
Re: CPU Usage Maxing Out   233 Anna M 02/03/2014 05:46PM
Re: CPU Usage Maxing Out   213 Rick James 02/04/2014 10:20PM
Re: CPU Usage Maxing Out   241 Anna M 02/05/2014 02:07PM
Re: CPU Usage Maxing Out   245 Rick James 02/06/2014 07:41PM
Re: CPU Usage Maxing Out   315 Anna M 02/07/2014 12:55PM
Re: CPU Usage Maxing Out   251 Rick James 02/07/2014 06:32PM
Re: CPU Usage Maxing Out   239 Anna M 02/13/2014 10:34AM
Slow insert rate in mysql innodb   932 Dhinakaran Arumugam 01/27/2014 10:11AM
Re: Slow insert rate in mysql innodb   435 Rick James 01/28/2014 06:46PM
Re: Slow insert rate in mysql innodb   361 Dhinakaran Arumugam 01/29/2014 11:49PM
Re: Slow insert rate in mysql innodb   332 Rick James 01/30/2014 08:31PM
Re: Slow insert rate in mysql innodb   314 Dhinakaran Arumugam 01/30/2014 11:50PM
Re: Slow insert rate in mysql innodb   313 Rick James 01/31/2014 08:31PM
Re: Slow insert rate in mysql innodb   297 Dhinakaran Arumugam 02/06/2014 07:28AM
Re: Slow insert rate in mysql innodb   327 Rick James 02/07/2014 11:00AM
Re: Slow insert rate in mysql innodb   285 Dhinakaran Arumugam 02/11/2014 10:04PM
Re: Slow insert rate in mysql innodb   294 Rick James 02/12/2014 07:30PM
Slow query on partitioned tables with over 200M rows   488 Hong Yang 02/11/2014 05:10PM
Re: Slow query on partitioned tables with over 200M rows   217 Øystein Grøvlen 02/12/2014 01:48AM
Re: Slow query on partitioned tables with over 200M rows   225 Hong Yang 02/12/2014 08:33AM
Re: Slow query on partitioned tables with over 200M rows   217 Rick James 02/12/2014 08:47AM
Re: Slow query on partitioned tables with over 200M rows   214 Hong Yang 02/12/2014 09:59AM
Re: Slow query on partitioned tables with over 200M rows   223 Rick James 02/12/2014 02:31PM
Re: Slow query on partitioned tables with over 200M rows   216 Hong Yang 02/12/2014 02:53PM
Re: Slow query on partitioned tables with over 200M rows   279 Rick James 02/12/2014 04:33PM
Re: Slow query on partitioned tables with over 200M rows   204 Hong Yang 02/12/2014 06:41PM
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.