MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Connector/Python 2.2.2 m3 Development Release has been released 12/01/2016 10:48AM
MySQL Cluster Manager 1.4.1 has been released 11/24/2016 06:24AM
MySQL Router 2.0.4 has been released 11/23/2016 11:22AM
MySQL Connector/Node.js 1.0.5 m4 Development Release has been released 11/14/2016 08:41AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 72
Subject Views Written By Posted
Sticky:  MySQL 8.0: Performance Schema (1 Posts)   204 Edwin Desouza 09/16/2016 09:07AM
Sticky:  MySQL XProtocol: Asynchronous Query Execution (1 Posts)   471 Edwin Desouza 05/27/2016 03:34PM
Sticky:  MySQL 5.7: Performance Benchmarks -- 1.6million QPS (1 Posts)   1,262 Edwin Desouza 10/27/2015 08:14AM
Sticky:  MySQL 5.7: includes SYS Schema (metrics, instumentation) (1 Posts)   1,453 Edwin Desouza 04/10/2015 02:40PM
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)   2,021 Edwin Desouza 02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   2,476 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   4,137 Edwin Desouza 02/12/2013 06:11PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   6,427 Edwin DeSouza 08/04/2011 09:09AM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   167,490 Edwin DeSouza 05/25/2006 10:50AM
Recent Upgrade from MySQL 5.1 to 5.5   37 Alex Titley 12/07/2016 10:22AM
Re: Recent Upgrade from MySQL 5.1 to 5.5   16 Edwin Desouza 12/07/2016 08:47PM
Re: Recent Upgrade from MySQL 5.1 to 5.5   9 Alex Titley 12/08/2016 05:07AM
Select Query and Two Tables   31 Steve Royle 12/05/2016 09:43AM
Re: Select Query and Two Tables   18 Peter Brawley 12/05/2016 11:01AM
Re: Select Query and Two Tables   4 Steve Royle 12/07/2016 05:05AM
Performance issues afre upgrading to 5.7   74 Alexandru Badulescu 11/24/2016 08:48AM
Re: Performance issues afre upgrading to 5.7   39 Peter Brawley 11/24/2016 11:32AM
Re: Performance issues afre upgrading to 5.7   36 Øystein Grøvlen 11/25/2016 07:28AM
Re: Performance issues afre upgrading to 5.7   44 Øystein Grøvlen 11/25/2016 06:16AM
Re: Performance issues afre upgrading to 5.7   33 Alexandru Badulescu 11/25/2016 06:59AM
Re: Performance issues afre upgrading to 5.7   34 Øystein Grøvlen 11/25/2016 07:53AM
Re: Performance issues afre upgrading to 5.7   33 Rick James 11/25/2016 08:18PM
why select @@session.tx_read_only take long time   118 h h 10/31/2016 01:53AM
Re: why select @@session.tx_read_only take long time   45 Rick James 11/02/2016 11:43AM
Query optimizatoin   125 Syed Anjum 10/26/2016 03:32AM
Re: Query optimizatoin   58 Øystein Grøvlen 10/26/2016 04:41AM
Writing sample data very fast from (TwinCAT) PLC to a MySQL database?   123 sdgbfdsg fdhgfdhds 10/18/2016 08:14AM
Re: Writing sample data very fast from (TwinCAT) PLC to a MySQL database?   69 Rick James 10/23/2016 12:08AM
How to Analyze and Tune MySQL Queries for Better Performance   123 Edwin Desouza 10/21/2016 09:57AM
Locked queries   171 Juan Nino 09/28/2016 06:31PM
Re: Locked queries   81 Peter Brawley 09/29/2016 09:39AM
MySQL optimisation for single laptop with 16 GB RAM   215 Philip Gladwin 09/08/2016 05:58AM
Re: MySQL optimisation for single laptop with 16 GB RAM   113 Rick James 09/10/2016 12:17AM
Relationship between MySQL variable open_files_limit and table_open_cache   198 salman khan 09/09/2016 04:34AM
Re: Relationship between MySQL variable open_files_limit and table_open_cache   109 Rick James 09/10/2016 12:13AM
Millions of rows, storing aggregate/rollup results help please   248 Jacqueline Jacobin 08/28/2016 12:23PM
Re: Millions of rows, storing aggregate/rollup results help please   159 Rick James 08/30/2016 02:47PM
Re: Millions of rows, storing aggregate/rollup results help please   124 Jacqueline Jacobin 08/31/2016 07:03AM
Re: Millions of rows, storing aggregate/rollup results help please   113 Rick James 09/01/2016 04:35PM
Multiple indexes - how do they work?   230 Rathi Rao 08/25/2016 03:51AM
Re: Multiple indexes - how do they work?   139 Peter Brawley 08/25/2016 11:29AM
Re: Multiple indexes - how do they work?   116 Rathi Rao 08/29/2016 03:48AM
Re: Multiple indexes - how do they work?   123 Rick James 08/26/2016 02:20PM
Re: Multiple indexes - how do they work?   102 Rathi Rao 08/29/2016 03:46AM
Re: Multiple indexes - how do they work?   135 Øystein Grøvlen 08/29/2016 01:23AM
Re: Multiple indexes - how do they work?   114 Rathi Rao 08/29/2016 03:45AM
Re: Multiple indexes - how do they work?   113 Øystein Grøvlen 08/29/2016 04:17AM
Re: Multiple indexes - how do they work?   101 Rathi Rao 08/29/2016 04:39AM
MySQL Table Valued Parameter   216 tony mendoza 08/23/2016 11:29AM
Re: MySQL Table Valued Parameter   123 Rick James 08/26/2016 02:17PM
Partitioned table details in the Explain Plan   240 Rathi Rao 08/19/2016 01:54AM
Re: Partitioned table details in the Explain Plan   116 Øystein Grøvlen 08/19/2016 07:00AM
Re: Partitioned table details in the Explain Plan   114 Rick James 08/20/2016 06:10PM
Rolling unique user counts   206 Paul Stam 08/09/2016 02:06AM
Re: Rolling unique user counts   136 Rick James 08/14/2016 06:22PM
Re: Rolling unique user counts   128 Paul Stam 08/15/2016 01:49AM
Re: Rolling unique user counts   120 Paul Stam 08/18/2016 06:03AM
Re: Rolling unique user counts   121 Rick James 08/18/2016 04:37PM
Wrong estimation of Rows in explain   273 Rathi Rao 07/27/2016 06:19AM
Re: Wrong estimation of Rows in explain   150 Peter Brawley 07/27/2016 08:55AM
Re: Wrong estimation of Rows in explain   156 Rathi Rao 07/27/2016 11:58PM
Re: Wrong estimation of Rows in explain   146 Peter Brawley 07/28/2016 09:14AM
Re: Wrong estimation of Rows in explain   145 Rathi Rao 07/29/2016 05:11AM
Re: Wrong estimation of Rows in explain   146 Peter Brawley 07/29/2016 01:10PM
Re: Wrong estimation of Rows in explain   142 Rick James 07/29/2016 06:58PM
Re: Wrong estimation of Rows in explain   129 Rathi Rao 08/02/2016 05:48AM
Re: Wrong estimation of Rows in explain   140 Rick James 08/02/2016 06:23PM
Re: Wrong estimation of Rows in explain   132 Rathi Rao 08/02/2016 05:38AM
Re: Wrong estimation of Rows in explain   140 james wang 08/04/2016 05:31AM
30 millions reads/day   240 Srinivas K 07/29/2016 05:34AM
Re: 30 millions reads/day   144 Rick James 07/29/2016 07:03PM
Re: 30 millions reads/day   141 james wang 08/04/2016 05:15AM
mysql commit slow,please help me   258 jw maple 07/27/2016 02:11AM
Re: mysql commit slow,please help me   202 Rick James 07/29/2016 05:15PM
Very slow query when too many joins   484 As Os 06/05/2016 09:17AM
Re: Very slow query when too many joins   224 As Os 06/05/2016 09:27AM
Re: Very slow query when too many joins   214 Peter Brawley 06/05/2016 10:14AM
Re: Very slow query when too many joins   203 As Os 06/05/2016 10:48AM
Re: Very slow query when too many joins   222 Peter Brawley 06/05/2016 10:56AM
Re: Very slow query when too many joins   194 As Os 06/05/2016 03:33PM
Re: Very slow query when too many joins   207 Peter Brawley 06/05/2016 03:41PM
Re: Very slow query when too many joins   205 Rick James 06/05/2016 05:36PM
Re: Very slow query when too many joins   192 As Os 06/06/2016 02:23AM
Re: Very slow query when too many joins   222 As Os 06/06/2016 03:33AM
Re: Very slow query when too many joins   188 As Os 06/06/2016 08:36AM
Re: Very slow query when too many joins   179 Peter Brawley 06/06/2016 08:52AM
Re: Very slow query when too many joins   191 As Os 06/06/2016 09:02AM
Re: Very slow query when too many joins   182 Peter Brawley 06/06/2016 11:16AM
Re: Very slow query when too many joins   196 Peter Brawley 06/06/2016 08:29AM
Re: Very slow query when too many joins   202 As Os 06/06/2016 11:30AM
Re: Very slow query when too many joins   196 Peter Brawley 06/06/2016 12:08PM
Re: Very slow query when too many joins   203 As Os 06/06/2016 02:11PM
Re: Very slow query when too many joins   230 Rick James 06/07/2016 03:40PM
Re: Very slow query when too many joins   144 james wang 07/20/2016 05:34AM
Re: Very slow query when too many joins   149 Rick James 07/20/2016 09:37AM
Re: Very slow query when too many joins   159 james wang 07/21/2016 04:43AM
Re: Very slow query when too many joins   147 Rick James 07/22/2016 10:59PM
MySQL data volume   302 Parfait Fortuné NDOLO 07/21/2016 10:21AM
Re: MySQL data volume   158 Peter Brawley 07/21/2016 11:41PM
Re: MySQL data volume   166 Rick James 07/22/2016 10:57PM
Query optimize on large database   310 Pavel Volkov 07/13/2016 01:40AM
Re: Query optimize on large database   174 Rick James 07/15/2016 05:12PM
Re: Query optimize on large database   168 Pavel Volkov 07/16/2016 04:15AM
Re: Query optimize on large database   168 Peter Brawley 07/16/2016 12:09PM
Re: Query optimize on large database   162 Pavel Volkov 07/16/2016 12:36PM
Re: Query optimize on large database   156 Rick James 07/16/2016 02:46PM
Re: Query optimize on large database   159 Peter Brawley 07/17/2016 11:22AM
Re: Query optimize on large database   157 Pavel Volkov 07/18/2016 04:28AM
Re: Query optimize on large database   150 Peter Brawley 07/18/2016 08:40AM
Re: Query optimize on large database   150 james wang 07/20/2016 04:46AM
Re: Query optimize on large database   152 Pavel Volkov 07/20/2016 08:06AM
Re: Query optimize on large database   157 Rick James 07/20/2016 09:29AM
Re: Query optimize on large database   149 james wang 07/21/2016 04:35AM
Unexplained very bad subquery performance   251 Arnaud Bertrand 07/18/2016 04:29AM
Re: Unexplained very bad subquery performance   164 Peter Brawley 07/18/2016 08:44AM
Re: Unexplained very bad subquery performance   148 Arnaud Bertrand 07/18/2016 01:06PM
Re: Unexplained very bad subquery performance   145 Peter Brawley 07/18/2016 03:30PM
Re: Unexplained very bad subquery performance   158 Arnaud Bertrand 07/19/2016 03:16AM
Re: Unexplained very bad subquery performance   154 Peter Brawley 07/19/2016 04:21AM
Re: Unexplained very bad subquery performance   148 james wang 07/20/2016 04:35AM
specify conditions from outer query on a materialized subquery   234 Pratik Gandhi 07/12/2016 10:55PM
Re: specify conditions from outer query on a materialized subquery   146 Rick James 07/15/2016 05:15PM
This topic has been moved.:  GOT PACKETS OUT OF ORDER   12 Jeisson Sierra 07/11/2016 07:48PM
count(*) or count(id)   290 Ra Nala 06/28/2016 06:22AM
Re: count(*) or count(id)   161 Ra Nala 06/28/2016 06:26AM
Re: count(*) or count(id)   159 Peter Brawley 06/28/2016 05:18PM
Re: count(*) or count(id)   163 Rick James 07/04/2016 01:04PM
Re: count(*) or count(id)   163 Ra Nala 07/06/2016 12:30AM
CREATE INDEX Online DDL Not Working   363 Jayanath Dissanayake 06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working   183 Øystein Grøvlen 06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working   173 Rick James 06/23/2016 07:07PM
Select random rows when using UUID   384 Jonathan Keen 06/09/2016 11:43AM
Re: Select random rows when using UUID   185 Rick James 06/13/2016 01:36AM
Re: Select random rows when using UUID   199 Jonathan Keen 06/14/2016 11:23AM
Re: Select random rows when using UUID   184 Rick James 06/18/2016 01:35AM
SQLSTATE[HY000] [1044] Access denied   551 YOONTAE KIM 06/16/2016 07:55PM
Index Not being used.   410 Greg Mundt 05/26/2016 02:29PM
Re: Index Not being used.   212 Peter Brawley 05/26/2016 03:53PM
Re: Index Not being used.   221 Øystein Grøvlen 05/27/2016 12:45AM
Re: Index Not being used.   197 Greg Mundt 05/27/2016 07:05AM
Re: Index Not being used.   199 Rick James 05/27/2016 11:29PM
Re: Index Not being used.   193 Greg Mundt 05/31/2016 07:04AM
Re: Index Not being used.   190 Rick James 05/31/2016 09:26PM
Re: Index Not being used.   193 Greg Mundt 06/01/2016 05:40AM
Re: Index Not being used.   178 Rick James 06/01/2016 11:29AM
Re: Index Not being used.   211 Greg Mundt 06/01/2016 11:41AM
Re: Index Not being used.   187 Rick James 06/04/2016 05:14PM
Re: Index Not being used.   196 Greg Mundt 05/27/2016 10:14AM
A proposal to make disk IO much faster under SSD   446 suiyemin sui 05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD   234 Rick James 05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD   217 suiyemin sui 06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD   190 Rick James 06/04/2016 04:38PM
query taking really long time.   435 Mehraz Ahmed Sheikh 05/16/2016 09:45AM
Re: query taking really long time.   214 Rick James 05/23/2016 02:58PM
Left join vs Inner join   463 Vikas Sood 05/09/2016 06:10PM
Re: Left join vs Inner join   228 Øystein Grøvlen 05/10/2016 08:04AM
Re: Left join vs Inner join   214 Vikas Sood 05/10/2016 10:40AM
Re: Left join vs Inner join   226 Rick James 05/10/2016 07:23PM
How can I improve the import speed of a large SQL file?   439 Jeff Vincent 05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file?   230 Peter Brawley 05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file?   225 Jeff Vincent 05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file?   222 Rick James 05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file?   233 Shane Bester 05/08/2016 04:49AM
text vs varchar   495 hua kai 04/28/2016 08:36AM
Re: text vs varchar   247 Øystein Grøvlen 04/29/2016 12:41AM
Re: text vs varchar   243 Rick James 04/30/2016 11:51PM
Re: text vs varchar   241 Øystein Grøvlen 05/02/2016 04:37AM
Re: text vs varchar   215 hua kai 05/02/2016 09:14PM
Re: text vs varchar   228 Øystein Grøvlen 05/03/2016 02:19AM
Re: text vs varchar   250 hua kai 05/03/2016 04:12AM
Re: text vs varchar   222 hua kai 05/02/2016 08:02PM
Re: text vs varchar   224 Øystein Grøvlen 05/03/2016 02:25AM
Query with 2 x subquery   444 Jes Ramsing 04/29/2016 06:44AM
Re: Query with 2 x subquery   274 Øystein Grøvlen 04/29/2016 08:01AM
Re: Query with 2 x subquery   241 Jes Ramsing 05/01/2016 11:57PM
Re: Query with 2 x subquery   204 Øystein Grøvlen 05/02/2016 03:45AM
Re: Query with 2 x subquery   204 Jes Ramsing 05/02/2016 05:32AM
Re: Query with 2 x subquery   213 Rick James 05/01/2016 11:58PM
Re: Query with 2 x subquery   269 Jes Ramsing 05/02/2016 02:16AM
Slow Query, Optimization Advice Needed   472 Michael Lawson 04/26/2016 09:30AM
Re: Slow Query, Optimization Advice Needed   221 Øystein Grøvlen 04/27/2016 01:02AM
Re: Slow Query, Optimization Advice Needed   231 Michael Lawson 04/27/2016 07:20PM
Re: Slow Query, Optimization Advice Needed   235 Peter Brawley 04/27/2016 11:28PM
Re: Slow Query, Optimization Advice Needed   219 Øystein Grøvlen 04/28/2016 01:25AM
Re: Slow Query, Optimization Advice Needed   219 Rick James 05/01/2016 11:47PM
Re: Slow Query, Optimization Advice Needed   227 Øystein Grøvlen 05/02/2016 01:28AM
Re: Slow Query, Optimization Advice Needed   230 Øystein Grøvlen 04/28/2016 01:12AM
Reg table design and query performances   466 Devrishi Shandilya 04/26/2016 03:02AM
Re: Reg table design and query performances   239 Øystein Grøvlen 04/26/2016 06:02AM
Re: Reg table design and query performances   275 Devrishi Shandilya 04/26/2016 06:16AM
Re: Reg table design and query performances   241 Øystein Grøvlen 04/26/2016 06:35AM
Re: Reg table design and query performances   247 Devrishi Shandilya 04/26/2016 06:50AM
Re: Reg table design and query performances   242 Øystein Grøvlen 04/26/2016 07:04AM
Re: Reg table design and query performances   221 Rick James 04/30/2016 11:46PM
Re: Reg table design and query performances   197 Øystein Grøvlen 05/02/2016 01:00AM
Memory benefits of huge pages   464 Olga Turetskaya 04/30/2016 11:21AM
Re: Memory benefits of huge pages   222 Rick James 05/01/2016 02:36PM
Configuration review requested   572 Jens Meier 04/13/2016 11:55AM
Re: Configuration review requested   254 Rick James 04/14/2016 01:39PM
block_ops_in and block_ops_out meaning   731 hua kai 03/18/2016 02:33AM
Re: block_ops_in and block_ops_out meaning   356 Rick James 03/21/2016 11:34PM
Re: block_ops_in and block_ops_out meaning   352 Peter Brawley 03/22/2016 02:03AM
Re: block_ops_in and block_ops_out meaning   383 hua kai 03/25/2016 12:30AM
Re: block_ops_in and block_ops_out meaning   315 hua kai 04/14/2016 12:52AM
order by primary key slowly   567 varky chan 04/05/2016 10:42PM
Re: order by primary key slowly   287 Øystein Grøvlen 04/06/2016 04:35AM
Re: order by primary key slowly   311 varky chan 04/06/2016 10:15AM
Re: order by primary key slowly   293 Peter Brawley 04/06/2016 11:23AM
Re: order by primary key slowly   290 varky chan 04/06/2016 08:11PM
Re: order by primary key slowly   265 Peter Brawley 04/06/2016 10:35PM
Re: order by primary key slowly   269 varky chan 04/07/2016 12:34AM
Re: order by primary key slowly   275 Øystein Grøvlen 04/07/2016 07:21AM
Re: order by primary key slowly   274 Peter Brawley 04/07/2016 10:20AM
Re: order by primary key slowly   268 varky chan 04/07/2016 11:26PM
Re: order by primary key slowly   258 Rick James 04/12/2016 07:42PM
Re: order by primary key slowly   266 Peter Brawley 04/06/2016 08:57AM
Re: order by primary key slowly   257 varky chan 04/06/2016 10:17AM
[INNODB] why there are many "waiting for table level lock"?   506 HANWEN YIN 04/11/2016 12:08AM
Re: [INNODB] why there are many "waiting for table level lock"?   264 Rick James 04/12/2016 07:27PM
Improve performance when altering huge tables   505 Davide Cicuta 04/04/2016 07:24AM
Re: Improve performance when altering huge tables   272 Rick James 04/05/2016 02:59PM
MySql 5.7 - Poor Performance PURGE BINARY LOGS   642 Davy Campano 03/23/2016 08:08PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   297 Rick James 03/26/2016 11:58PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   318 Davy Campano 03/29/2016 09:44AM
where the snapshot for select in transaction stored   578 hua kai 03/21/2016 03:03AM
Re: where the snapshot for select in transaction stored   261 Rick James 03/21/2016 11:21PM
Difference execution plans for same query   641 Devrishi Shandilya 02/25/2016 12:05AM
Re: Difference execution plans for same query   281 Peter Brawley 02/25/2016 01:51AM
Re: Difference execution plans for same query   304 Øystein Grøvlen 02/25/2016 03:51AM
Re: Difference execution plans for same query   293 Rick James 03/05/2016 01:19AM
Slow join performance   725 Ra Nala 11/27/2015 04:55AM
Re: Slow join performance   403 Rick James 11/28/2015 03:02PM
Re: Slow join performance   286 Ra Nala 02/25/2016 06:22AM
which is best for JOIN approach   787 Ra Nala 11/24/2015 09:39AM
Re: which is best for JOIN approach   450 Øystein Grøvlen 11/25/2015 02:14AM
Re: which is best for JOIN approach   423 Ra Nala 11/25/2015 02:42AM
Re: which is best for JOIN approach   403 Rick James 11/29/2015 11:53AM
Re: which is best for JOIN approach   309 Ra Nala 02/19/2016 05:28AM
Re: which is best for JOIN approach   303 Peter Brawley 02/21/2016 04:56PM
Re: which is best for JOIN approach   289 Ra Nala 02/19/2016 05:31AM
Re: which is best for JOIN approach   290 Rick James 02/21/2016 01:40PM
Re: which is best for JOIN approach   315 Rick James 02/21/2016 01:43PM
Re: which is best for JOIN approach   343 Ra Nala 02/25/2016 05:50AM
Why is wrong index being selected   610 Steve Bell 02/23/2016 01:54PM
Re: Why is wrong index being selected   288 Rick James 02/23/2016 11:39PM
Re: Why is wrong index being selected   322 Øystein Grøvlen 02/24/2016 03:22AM
Re: Why is wrong index being selected   286 Steve Bell 02/25/2016 02:47AM
Distinct or Group by which is faster   664 Ra Nala 02/22/2016 08:50AM
Re: Distinct or Group by which is faster   317 Peter Brawley 02/22/2016 12:33PM
Re: Distinct or Group by which is faster   300 Chandan Kumar 02/23/2016 12:51PM
This topic has been moved.:  MySQL optimisation for single laptop with 16 GB RAM   0 Philip Gladwin 09/08/2016 09:41AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 72

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.