MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Connector/C 6.1.9 GA has been released 01/10/2017 09:47AM
MySQL Enterprise Monitor 3.3.2 has been released 01/09/2017 01:31PM
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)   294 Edwin Desouza 09/16/2016 09:07AM
Sticky:  MySQL XProtocol: Asynchronous Query Execution (1 Posts)   558 Edwin Desouza 05/27/2016 03:34PM
Sticky:  MySQL 5.7: Performance Benchmarks -- 1.6million QPS (1 Posts)   1,345 Edwin Desouza 10/27/2015 08:14AM
Sticky:  MySQL 5.7: includes SYS Schema (metrics, instumentation) (1 Posts)   1,514 Edwin Desouza 04/10/2015 02:40PM
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)   2,102 Edwin Desouza 02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   2,560 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   4,208 Edwin Desouza 02/12/2013 06:11PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   6,497 Edwin DeSouza 08/04/2011 09:09AM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   167,753 Edwin DeSouza 05/25/2006 10:50AM
How to log slow DMLs   36 Susan Lam 01/10/2017 04:01PM
Re: How to log slow DMLs   16 Peter Brawley 01/10/2017 04:45PM
Re: How to log slow DMLs   16 Susan Lam 01/10/2017 06:54PM
Improve performance when Insert into ... select ...   100 Lyu Joey 12/15/2016 03:59AM
Re: Improve performance when Insert into ... select ...   50 Peter Brawley 12/15/2016 10:00AM
Re: Improve performance when Insert into ... select ...   59 Lyu Joey 12/15/2016 07:34PM
Re: Improve performance when Insert into ... select ...   50 Lyu Joey 12/15/2016 08:08PM
Re: Improve performance when Insert into ... select ...   49 Lyu Joey 12/15/2016 08:18PM
Re: Improve performance when Insert into ... select ...   51 Peter Brawley 12/15/2016 09:16PM
Recent Upgrade from MySQL 5.1 to 5.5   136 Alex Titley 12/07/2016 10:22AM
Re: Recent Upgrade from MySQL 5.1 to 5.5   72 Edwin Desouza 12/07/2016 08:47PM
Re: Recent Upgrade from MySQL 5.1 to 5.5   65 Alex Titley 12/08/2016 05:07AM
Re: Recent Upgrade from MySQL 5.1 to 5.5   61 Rick James 12/12/2016 02:08PM
Re: Recent Upgrade from MySQL 5.1 to 5.5   58 Alex Titley 12/14/2016 07:27AM
Re: Recent Upgrade from MySQL 5.1 to 5.5   62 Peter Brawley 12/14/2016 08:56AM
Select Query and Two Tables   116 Steve Royle 12/05/2016 09:43AM
Re: Select Query and Two Tables   80 Peter Brawley 12/05/2016 11:01AM
Re: Select Query and Two Tables   51 Steve Royle 12/07/2016 05:05AM
Performance issues afre upgrading to 5.7   161 Alexandru Badulescu 11/24/2016 08:48AM
Re: Performance issues afre upgrading to 5.7   82 Peter Brawley 11/24/2016 11:32AM
Re: Performance issues afre upgrading to 5.7   75 Øystein Grøvlen 11/25/2016 07:28AM
Re: Performance issues afre upgrading to 5.7   88 Øystein Grøvlen 11/25/2016 06:16AM
Re: Performance issues afre upgrading to 5.7   74 Alexandru Badulescu 11/25/2016 06:59AM
Re: Performance issues afre upgrading to 5.7   80 Øystein Grøvlen 11/25/2016 07:53AM
Re: Performance issues afre upgrading to 5.7   78 Rick James 11/25/2016 08:18PM
why select @@session.tx_read_only take long time   240 h h 10/31/2016 01:53AM
Re: why select @@session.tx_read_only take long time   102 Rick James 11/02/2016 11:43AM
Query optimizatoin   215 Syed Anjum 10/26/2016 03:32AM
Re: Query optimizatoin   97 Øystein Grøvlen 10/26/2016 04:41AM
Writing sample data very fast from (TwinCAT) PLC to a MySQL database?   208 sdgbfdsg fdhgfdhds 10/18/2016 08:14AM
Re: Writing sample data very fast from (TwinCAT) PLC to a MySQL database?   119 Rick James 10/23/2016 12:08AM
How to Analyze and Tune MySQL Queries for Better Performance   187 Edwin Desouza 10/21/2016 09:57AM
Locked queries   256 Juan Nino 09/28/2016 06:31PM
Re: Locked queries   126 Peter Brawley 09/29/2016 09:39AM
MySQL optimisation for single laptop with 16 GB RAM   292 Philip Gladwin 09/08/2016 05:58AM
Re: MySQL optimisation for single laptop with 16 GB RAM   158 Rick James 09/10/2016 12:17AM
Relationship between MySQL variable open_files_limit and table_open_cache   263 salman khan 09/09/2016 04:34AM
Re: Relationship between MySQL variable open_files_limit and table_open_cache   150 Rick James 09/10/2016 12:13AM
Millions of rows, storing aggregate/rollup results help please   348 Jacqueline Jacobin 08/28/2016 12:23PM
Re: Millions of rows, storing aggregate/rollup results help please   232 Rick James 08/30/2016 02:47PM
Re: Millions of rows, storing aggregate/rollup results help please   169 Jacqueline Jacobin 08/31/2016 07:03AM
Re: Millions of rows, storing aggregate/rollup results help please   161 Rick James 09/01/2016 04:35PM
Multiple indexes - how do they work?   299 Rathi Rao 08/25/2016 03:51AM
Re: Multiple indexes - how do they work?   180 Peter Brawley 08/25/2016 11:29AM
Re: Multiple indexes - how do they work?   152 Rathi Rao 08/29/2016 03:48AM
Re: Multiple indexes - how do they work?   166 Rick James 08/26/2016 02:20PM
Re: Multiple indexes - how do they work?   141 Rathi Rao 08/29/2016 03:46AM
Re: Multiple indexes - how do they work?   181 Øystein Grøvlen 08/29/2016 01:23AM
Re: Multiple indexes - how do they work?   155 Rathi Rao 08/29/2016 03:45AM
Re: Multiple indexes - how do they work?   152 Øystein Grøvlen 08/29/2016 04:17AM
Re: Multiple indexes - how do they work?   139 Rathi Rao 08/29/2016 04:39AM
MySQL Table Valued Parameter   294 tony mendoza 08/23/2016 11:29AM
Re: MySQL Table Valued Parameter   159 Rick James 08/26/2016 02:17PM
Partitioned table details in the Explain Plan   312 Rathi Rao 08/19/2016 01:54AM
Re: Partitioned table details in the Explain Plan   156 Øystein Grøvlen 08/19/2016 07:00AM
Re: Partitioned table details in the Explain Plan   150 Rick James 08/20/2016 06:10PM
Rolling unique user counts   261 Paul Stam 08/09/2016 02:06AM
Re: Rolling unique user counts   174 Rick James 08/14/2016 06:22PM
Re: Rolling unique user counts   164 Paul Stam 08/15/2016 01:49AM
Re: Rolling unique user counts   160 Paul Stam 08/18/2016 06:03AM
Re: Rolling unique user counts   161 Rick James 08/18/2016 04:37PM
Wrong estimation of Rows in explain   341 Rathi Rao 07/27/2016 06:19AM
Re: Wrong estimation of Rows in explain   188 Peter Brawley 07/27/2016 08:55AM
Re: Wrong estimation of Rows in explain   202 Rathi Rao 07/27/2016 11:58PM
Re: Wrong estimation of Rows in explain   185 Peter Brawley 07/28/2016 09:14AM
Re: Wrong estimation of Rows in explain   188 Rathi Rao 07/29/2016 05:11AM
Re: Wrong estimation of Rows in explain   185 Peter Brawley 07/29/2016 01:10PM
Re: Wrong estimation of Rows in explain   181 Rick James 07/29/2016 06:58PM
Re: Wrong estimation of Rows in explain   169 Rathi Rao 08/02/2016 05:48AM
Re: Wrong estimation of Rows in explain   179 Rick James 08/02/2016 06:23PM
Re: Wrong estimation of Rows in explain   176 Rathi Rao 08/02/2016 05:38AM
Re: Wrong estimation of Rows in explain   178 james wang 08/04/2016 05:31AM
30 millions reads/day   310 Srinivas K 07/29/2016 05:34AM
Re: 30 millions reads/day   183 Rick James 07/29/2016 07:03PM
Re: 30 millions reads/day   185 james wang 08/04/2016 05:15AM
mysql commit slow,please help me   425 jw maple 07/27/2016 02:11AM
Re: mysql commit slow,please help me   256 Rick James 07/29/2016 05:15PM
Very slow query when too many joins   579 As Os 06/05/2016 09:17AM
Re: Very slow query when too many joins   271 As Os 06/05/2016 09:27AM
Re: Very slow query when too many joins   261 Peter Brawley 06/05/2016 10:14AM
Re: Very slow query when too many joins   254 As Os 06/05/2016 10:48AM
Re: Very slow query when too many joins   267 Peter Brawley 06/05/2016 10:56AM
Re: Very slow query when too many joins   240 As Os 06/05/2016 03:33PM
Re: Very slow query when too many joins   260 Peter Brawley 06/05/2016 03:41PM
Re: Very slow query when too many joins   258 Rick James 06/05/2016 05:36PM
Re: Very slow query when too many joins   237 As Os 06/06/2016 02:23AM
Re: Very slow query when too many joins   265 As Os 06/06/2016 03:33AM
Re: Very slow query when too many joins   231 As Os 06/06/2016 08:36AM
Re: Very slow query when too many joins   229 Peter Brawley 06/06/2016 08:52AM
Re: Very slow query when too many joins   238 As Os 06/06/2016 09:02AM
Re: Very slow query when too many joins   228 Peter Brawley 06/06/2016 11:16AM
Re: Very slow query when too many joins   237 Peter Brawley 06/06/2016 08:29AM
Re: Very slow query when too many joins   254 As Os 06/06/2016 11:30AM
Re: Very slow query when too many joins   248 Peter Brawley 06/06/2016 12:08PM
Re: Very slow query when too many joins   246 As Os 06/06/2016 02:11PM
Re: Very slow query when too many joins   271 Rick James 06/07/2016 03:40PM
Re: Very slow query when too many joins   189 james wang 07/20/2016 05:34AM
Re: Very slow query when too many joins   194 Rick James 07/20/2016 09:37AM
Re: Very slow query when too many joins   209 james wang 07/21/2016 04:43AM
Re: Very slow query when too many joins   190 Rick James 07/22/2016 10:59PM
MySQL data volume   377 Parfait Fortuné NDOLO 07/21/2016 10:21AM
Re: MySQL data volume   197 Peter Brawley 07/21/2016 11:41PM
Re: MySQL data volume   204 Rick James 07/22/2016 10:57PM
Query optimize on large database   383 Pavel Volkov 07/13/2016 01:40AM
Re: Query optimize on large database   217 Rick James 07/15/2016 05:12PM
Re: Query optimize on large database   209 Pavel Volkov 07/16/2016 04:15AM
Re: Query optimize on large database   211 Peter Brawley 07/16/2016 12:09PM
Re: Query optimize on large database   203 Pavel Volkov 07/16/2016 12:36PM
Re: Query optimize on large database   197 Rick James 07/16/2016 02:46PM
Re: Query optimize on large database   202 Peter Brawley 07/17/2016 11:22AM
Re: Query optimize on large database   196 Pavel Volkov 07/18/2016 04:28AM
Re: Query optimize on large database   187 Peter Brawley 07/18/2016 08:40AM
Re: Query optimize on large database   192 james wang 07/20/2016 04:46AM
Re: Query optimize on large database   190 Pavel Volkov 07/20/2016 08:06AM
Re: Query optimize on large database   197 Rick James 07/20/2016 09:29AM
Re: Query optimize on large database   194 james wang 07/21/2016 04:35AM
Unexplained very bad subquery performance   321 Arnaud Bertrand 07/18/2016 04:29AM
Re: Unexplained very bad subquery performance   207 Peter Brawley 07/18/2016 08:44AM
Re: Unexplained very bad subquery performance   186 Arnaud Bertrand 07/18/2016 01:06PM
Re: Unexplained very bad subquery performance   184 Peter Brawley 07/18/2016 03:30PM
Re: Unexplained very bad subquery performance   205 Arnaud Bertrand 07/19/2016 03:16AM
Re: Unexplained very bad subquery performance   201 Peter Brawley 07/19/2016 04:21AM
Re: Unexplained very bad subquery performance   194 james wang 07/20/2016 04:35AM
specify conditions from outer query on a materialized subquery   301 Pratik Gandhi 07/12/2016 10:55PM
Re: specify conditions from outer query on a materialized subquery   189 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)   356 Ra Nala 06/28/2016 06:22AM
Re: count(*) or count(id)   203 Ra Nala 06/28/2016 06:26AM
Re: count(*) or count(id)   206 Peter Brawley 06/28/2016 05:18PM
Re: count(*) or count(id)   213 Rick James 07/04/2016 01:04PM
Re: count(*) or count(id)   206 Ra Nala 07/06/2016 12:30AM
CREATE INDEX Online DDL Not Working   431 Jayanath Dissanayake 06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working   224 Øystein Grøvlen 06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working   213 Rick James 06/23/2016 07:07PM
Select random rows when using UUID   465 Jonathan Keen 06/09/2016 11:43AM
Re: Select random rows when using UUID   236 Rick James 06/13/2016 01:36AM
Re: Select random rows when using UUID   255 Jonathan Keen 06/14/2016 11:23AM
Re: Select random rows when using UUID   227 Rick James 06/18/2016 01:35AM
SQLSTATE[HY000] [1044] Access denied   698 YOONTAE KIM 06/16/2016 07:55PM
Index Not being used.   479 Greg Mundt 05/26/2016 02:29PM
Re: Index Not being used.   253 Peter Brawley 05/26/2016 03:53PM
Re: Index Not being used.   270 Øystein Grøvlen 05/27/2016 12:45AM
Re: Index Not being used.   237 Greg Mundt 05/27/2016 07:05AM
Re: Index Not being used.   239 Rick James 05/27/2016 11:29PM
Re: Index Not being used.   240 Greg Mundt 05/31/2016 07:04AM
Re: Index Not being used.   229 Rick James 05/31/2016 09:26PM
Re: Index Not being used.   239 Greg Mundt 06/01/2016 05:40AM
Re: Index Not being used.   215 Rick James 06/01/2016 11:29AM
Re: Index Not being used.   252 Greg Mundt 06/01/2016 11:41AM
Re: Index Not being used.   230 Rick James 06/04/2016 05:14PM
Re: Index Not being used.   240 Greg Mundt 05/27/2016 10:14AM
A proposal to make disk IO much faster under SSD   546 suiyemin sui 05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD   276 Rick James 05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD   268 suiyemin sui 06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD   233 Rick James 06/04/2016 04:38PM
query taking really long time.   508 Mehraz Ahmed Sheikh 05/16/2016 09:45AM
Re: query taking really long time.   252 Rick James 05/23/2016 02:58PM
Left join vs Inner join   566 Vikas Sood 05/09/2016 06:10PM
Re: Left join vs Inner join   275 Øystein Grøvlen 05/10/2016 08:04AM
Re: Left join vs Inner join   258 Vikas Sood 05/10/2016 10:40AM
Re: Left join vs Inner join   266 Rick James 05/10/2016 07:23PM
How can I improve the import speed of a large SQL file?   510 Jeff Vincent 05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file?   271 Peter Brawley 05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file?   275 Jeff Vincent 05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file?   267 Rick James 05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file?   282 Shane Bester 05/08/2016 04:49AM
text vs varchar   572 hua kai 04/28/2016 08:36AM
Re: text vs varchar   293 Øystein Grøvlen 04/29/2016 12:41AM
Re: text vs varchar   289 Rick James 04/30/2016 11:51PM
Re: text vs varchar   295 Øystein Grøvlen 05/02/2016 04:37AM
Re: text vs varchar   262 hua kai 05/02/2016 09:14PM
Re: text vs varchar   273 Øystein Grøvlen 05/03/2016 02:19AM
Re: text vs varchar   310 hua kai 05/03/2016 04:12AM
Re: text vs varchar   263 hua kai 05/02/2016 08:02PM
Re: text vs varchar   270 Øystein Grøvlen 05/03/2016 02:25AM
Query with 2 x subquery   516 Jes Ramsing 04/29/2016 06:44AM
Re: Query with 2 x subquery   312 Øystein Grøvlen 04/29/2016 08:01AM
Re: Query with 2 x subquery   285 Jes Ramsing 05/01/2016 11:57PM
Re: Query with 2 x subquery   245 Øystein Grøvlen 05/02/2016 03:45AM
Re: Query with 2 x subquery   248 Jes Ramsing 05/02/2016 05:32AM
Re: Query with 2 x subquery   254 Rick James 05/01/2016 11:58PM
Re: Query with 2 x subquery   308 Jes Ramsing 05/02/2016 02:16AM
Slow Query, Optimization Advice Needed   542 Michael Lawson 04/26/2016 09:30AM
Re: Slow Query, Optimization Advice Needed   270 Øystein Grøvlen 04/27/2016 01:02AM
Re: Slow Query, Optimization Advice Needed   277 Michael Lawson 04/27/2016 07:20PM
Re: Slow Query, Optimization Advice Needed   288 Peter Brawley 04/27/2016 11:28PM
Re: Slow Query, Optimization Advice Needed   263 Øystein Grøvlen 04/28/2016 01:25AM
Re: Slow Query, Optimization Advice Needed   259 Rick James 05/01/2016 11:47PM
Re: Slow Query, Optimization Advice Needed   275 Øystein Grøvlen 05/02/2016 01:28AM
Re: Slow Query, Optimization Advice Needed   271 Øystein Grøvlen 04/28/2016 01:12AM
Reg table design and query performances   528 Devrishi Shandilya 04/26/2016 03:02AM
Re: Reg table design and query performances   281 Øystein Grøvlen 04/26/2016 06:02AM
Re: Reg table design and query performances   325 Devrishi Shandilya 04/26/2016 06:16AM
Re: Reg table design and query performances   281 Øystein Grøvlen 04/26/2016 06:35AM
Re: Reg table design and query performances   290 Devrishi Shandilya 04/26/2016 06:50AM
Re: Reg table design and query performances   281 Øystein Grøvlen 04/26/2016 07:04AM
Re: Reg table design and query performances   261 Rick James 04/30/2016 11:46PM
Re: Reg table design and query performances   238 Øystein Grøvlen 05/02/2016 01:00AM
Memory benefits of huge pages   540 Olga Turetskaya 04/30/2016 11:21AM
Re: Memory benefits of huge pages   272 Rick James 05/01/2016 02:36PM
Configuration review requested   655 Jens Meier 04/13/2016 11:55AM
Re: Configuration review requested   299 Rick James 04/14/2016 01:39PM
block_ops_in and block_ops_out meaning   843 hua kai 03/18/2016 02:33AM
Re: block_ops_in and block_ops_out meaning   399 Rick James 03/21/2016 11:34PM
Re: block_ops_in and block_ops_out meaning   394 Peter Brawley 03/22/2016 02:03AM
Re: block_ops_in and block_ops_out meaning   445 hua kai 03/25/2016 12:30AM
Re: block_ops_in and block_ops_out meaning   366 hua kai 04/14/2016 12:52AM
order by primary key slowly   643 varky chan 04/05/2016 10:42PM
Re: order by primary key slowly   326 Øystein Grøvlen 04/06/2016 04:35AM
Re: order by primary key slowly   358 varky chan 04/06/2016 10:15AM
Re: order by primary key slowly   338 Peter Brawley 04/06/2016 11:23AM
Re: order by primary key slowly   333 varky chan 04/06/2016 08:11PM
Re: order by primary key slowly   308 Peter Brawley 04/06/2016 10:35PM
Re: order by primary key slowly   310 varky chan 04/07/2016 12:34AM
Re: order by primary key slowly   325 Øystein Grøvlen 04/07/2016 07:21AM
Re: order by primary key slowly   327 Peter Brawley 04/07/2016 10:20AM
Re: order by primary key slowly   321 varky chan 04/07/2016 11:26PM
Re: order by primary key slowly   305 Rick James 04/12/2016 07:42PM
Re: order by primary key slowly   309 Peter Brawley 04/06/2016 08:57AM
Re: order by primary key slowly   310 varky chan 04/06/2016 10:17AM
[INNODB] why there are many "waiting for table level lock"?   576 HANWEN YIN 04/11/2016 12:08AM
Re: [INNODB] why there are many "waiting for table level lock"?   301 Rick James 04/12/2016 07:27PM
Improve performance when altering huge tables   575 Davide Cicuta 04/04/2016 07:24AM
Re: Improve performance when altering huge tables   328 Rick James 04/05/2016 02:59PM
MySql 5.7 - Poor Performance PURGE BINARY LOGS   717 Davy Campano 03/23/2016 08:08PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   342 Rick James 03/26/2016 11:58PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   367 Davy Campano 03/29/2016 09:44AM
where the snapshot for select in transaction stored   651 hua kai 03/21/2016 03:03AM
Re: where the snapshot for select in transaction stored   304 Rick James 03/21/2016 11:21PM
Difference execution plans for same query   726 Devrishi Shandilya 02/25/2016 12:05AM
Re: Difference execution plans for same query   321 Peter Brawley 02/25/2016 01:51AM
Re: Difference execution plans for same query   346 Øystein Grøvlen 02/25/2016 03:51AM
Re: Difference execution plans for same query   334 Rick James 03/05/2016 01:19AM
Slow join performance   792 Ra Nala 11/27/2015 04:55AM
Re: Slow join performance   441 Rick James 11/28/2015 03:02PM
Re: Slow join performance   322 Ra Nala 02/25/2016 06:22AM
which is best for JOIN approach   848 Ra Nala 11/24/2015 09:39AM
Re: which is best for JOIN approach   493 Øystein Grøvlen 11/25/2015 02:14AM
Re: which is best for JOIN approach   467 Ra Nala 11/25/2015 02:42AM
Re: which is best for JOIN approach   449 Rick James 11/29/2015 11:53AM
Re: which is best for JOIN approach   351 Ra Nala 02/19/2016 05:28AM
Re: which is best for JOIN approach   345 Peter Brawley 02/21/2016 04:56PM
Re: which is best for JOIN approach   331 Ra Nala 02/19/2016 05:31AM
Re: which is best for JOIN approach   333 Rick James 02/21/2016 01:40PM
Re: which is best for JOIN approach   360 Rick James 02/21/2016 01:43PM
Re: which is best for JOIN approach   385 Ra Nala 02/25/2016 05:50AM
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.