MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Workbench 6.3.9 GA has been released 02/07/2017 02:16PM
MySQL Utilities 1.6.5 GA has been released 01/25/2017 06:51AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 72
Subject Views Written By Posted
Sticky:  MySQL Performance Schema Benchmarks: OLTP RW (1 Posts)   76 Edwin Desouza 01/26/2017 03:33PM
Sticky:  MySQL 8.0: Performance Schema (1 Posts)   398 Edwin Desouza 09/16/2016 09:07AM
Sticky:  MySQL XProtocol: Asynchronous Query Execution (1 Posts)   616 Edwin Desouza 05/27/2016 03:34PM
Sticky:  MySQL 5.7: Performance Benchmarks -- 1.6million QPS (1 Posts)   1,422 Edwin Desouza 10/27/2015 08:14AM
Sticky:  MySQL 5.7: includes SYS Schema (metrics, instumentation) (1 Posts)   1,570 Edwin Desouza 04/10/2015 02:40PM
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)   2,184 Edwin Desouza 02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   2,624 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   4,273 Edwin Desouza 02/12/2013 06:11PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   6,558 Edwin DeSouza 08/04/2011 09:09AM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   168,047 Edwin DeSouza 05/25/2006 10:50AM
MySQL Performance Tuning: Optimizer Hints   33 Edwin Desouza 02/04/2017 09:08PM
How to log slow DMLs   108 Susan Lam 01/10/2017 04:01PM
Re: How to log slow DMLs   64 Peter Brawley 01/10/2017 04:45PM
Re: How to log slow DMLs   61 Susan Lam 01/10/2017 06:54PM
Improve performance when Insert into ... select ...   201 Lyu Joey 12/15/2016 03:59AM
Re: Improve performance when Insert into ... select ...   116 Peter Brawley 12/15/2016 10:00AM
Re: Improve performance when Insert into ... select ...   138 Lyu Joey 12/15/2016 07:34PM
Re: Improve performance when Insert into ... select ...   116 Lyu Joey 12/15/2016 08:08PM
Re: Improve performance when Insert into ... select ...   123 Lyu Joey 12/15/2016 08:18PM
Re: Improve performance when Insert into ... select ...   116 Peter Brawley 12/15/2016 09:16PM
Recent Upgrade from MySQL 5.1 to 5.5   223 Alex Titley 12/07/2016 10:22AM
Re: Recent Upgrade from MySQL 5.1 to 5.5   130 Edwin Desouza 12/07/2016 08:47PM
Re: Recent Upgrade from MySQL 5.1 to 5.5   103 Alex Titley 12/08/2016 05:07AM
Re: Recent Upgrade from MySQL 5.1 to 5.5   104 Rick James 12/12/2016 02:08PM
Re: Recent Upgrade from MySQL 5.1 to 5.5   135 Alex Titley 12/14/2016 07:27AM
Re: Recent Upgrade from MySQL 5.1 to 5.5   127 Peter Brawley 12/14/2016 08:56AM
Select Query and Two Tables   205 Steve Royle 12/05/2016 09:43AM
Re: Select Query and Two Tables   141 Peter Brawley 12/05/2016 11:01AM
Re: Select Query and Two Tables   104 Steve Royle 12/07/2016 05:05AM
Performance issues afre upgrading to 5.7   246 Alexandru Badulescu 11/24/2016 08:48AM
Re: Performance issues afre upgrading to 5.7   179 Peter Brawley 11/24/2016 11:32AM
Re: Performance issues afre upgrading to 5.7   124 Øystein Grøvlen 11/25/2016 07:28AM
Re: Performance issues afre upgrading to 5.7   133 Øystein Grøvlen 11/25/2016 06:16AM
Re: Performance issues afre upgrading to 5.7   126 Alexandru Badulescu 11/25/2016 06:59AM
Re: Performance issues afre upgrading to 5.7   170 Øystein Grøvlen 11/25/2016 07:53AM
Re: Performance issues afre upgrading to 5.7   126 Rick James 11/25/2016 08:18PM
why select @@session.tx_read_only take long time   422 h h 10/31/2016 01:53AM
Re: why select @@session.tx_read_only take long time   208 Rick James 11/02/2016 11:43AM
Query optimizatoin   291 Syed Anjum 10/26/2016 03:32AM
Re: Query optimizatoin   134 Øystein Grøvlen 10/26/2016 04:41AM
Writing sample data very fast from (TwinCAT) PLC to a MySQL database?   293 sdgbfdsg fdhgfdhds 10/18/2016 08:14AM
Re: Writing sample data very fast from (TwinCAT) PLC to a MySQL database?   253 Rick James 10/23/2016 12:08AM
How to Analyze and Tune MySQL Queries for Better Performance   259 Edwin Desouza 10/21/2016 09:57AM
Locked queries   360 Juan Nino 09/28/2016 06:31PM
Re: Locked queries   192 Peter Brawley 09/29/2016 09:39AM
MySQL optimisation for single laptop with 16 GB RAM   363 Philip Gladwin 09/08/2016 05:58AM
Re: MySQL optimisation for single laptop with 16 GB RAM   213 Rick James 09/10/2016 12:17AM
Relationship between MySQL variable open_files_limit and table_open_cache   381 salman khan 09/09/2016 04:34AM
Re: Relationship between MySQL variable open_files_limit and table_open_cache   193 Rick James 09/10/2016 12:13AM
Millions of rows, storing aggregate/rollup results help please   430 Jacqueline Jacobin 08/28/2016 12:23PM
Re: Millions of rows, storing aggregate/rollup results help please   288 Rick James 08/30/2016 02:47PM
Re: Millions of rows, storing aggregate/rollup results help please   218 Jacqueline Jacobin 08/31/2016 07:03AM
Re: Millions of rows, storing aggregate/rollup results help please   206 Rick James 09/01/2016 04:35PM
Multiple indexes - how do they work?   363 Rathi Rao 08/25/2016 03:51AM
Re: Multiple indexes - how do they work?   219 Peter Brawley 08/25/2016 11:29AM
Re: Multiple indexes - how do they work?   196 Rathi Rao 08/29/2016 03:48AM
Re: Multiple indexes - how do they work?   205 Rick James 08/26/2016 02:20PM
Re: Multiple indexes - how do they work?   181 Rathi Rao 08/29/2016 03:46AM
Re: Multiple indexes - how do they work?   228 Øystein Grøvlen 08/29/2016 01:23AM
Re: Multiple indexes - how do they work?   194 Rathi Rao 08/29/2016 03:45AM
Re: Multiple indexes - how do they work?   186 Øystein Grøvlen 08/29/2016 04:17AM
Re: Multiple indexes - how do they work?   179 Rathi Rao 08/29/2016 04:39AM
MySQL Table Valued Parameter   394 tony mendoza 08/23/2016 11:29AM
Re: MySQL Table Valued Parameter   211 Rick James 08/26/2016 02:17PM
Partitioned table details in the Explain Plan   385 Rathi Rao 08/19/2016 01:54AM
Re: Partitioned table details in the Explain Plan   197 Øystein Grøvlen 08/19/2016 07:00AM
Re: Partitioned table details in the Explain Plan   190 Rick James 08/20/2016 06:10PM
Rolling unique user counts   331 Paul Stam 08/09/2016 02:06AM
Re: Rolling unique user counts   217 Rick James 08/14/2016 06:22PM
Re: Rolling unique user counts   206 Paul Stam 08/15/2016 01:49AM
Re: Rolling unique user counts   201 Paul Stam 08/18/2016 06:03AM
Re: Rolling unique user counts   209 Rick James 08/18/2016 04:37PM
Wrong estimation of Rows in explain   431 Rathi Rao 07/27/2016 06:19AM
Re: Wrong estimation of Rows in explain   221 Peter Brawley 07/27/2016 08:55AM
Re: Wrong estimation of Rows in explain   241 Rathi Rao 07/27/2016 11:58PM
Re: Wrong estimation of Rows in explain   228 Peter Brawley 07/28/2016 09:14AM
Re: Wrong estimation of Rows in explain   231 Rathi Rao 07/29/2016 05:11AM
Re: Wrong estimation of Rows in explain   225 Peter Brawley 07/29/2016 01:10PM
Re: Wrong estimation of Rows in explain   227 Rick James 07/29/2016 06:58PM
Re: Wrong estimation of Rows in explain   216 Rathi Rao 08/02/2016 05:48AM
Re: Wrong estimation of Rows in explain   227 Rick James 08/02/2016 06:23PM
Re: Wrong estimation of Rows in explain   208 Rathi Rao 08/02/2016 05:38AM
Re: Wrong estimation of Rows in explain   213 james wang 08/04/2016 05:31AM
30 millions reads/day   421 Srinivas K 07/29/2016 05:34AM
Re: 30 millions reads/day   215 Rick James 07/29/2016 07:03PM
Re: 30 millions reads/day   228 james wang 08/04/2016 05:15AM
mysql commit slow,please help me   540 jw maple 07/27/2016 02:11AM
Re: mysql commit slow,please help me   337 Rick James 07/29/2016 05:15PM
Very slow query when too many joins   664 As Os 06/05/2016 09:17AM
Re: Very slow query when too many joins   331 As Os 06/05/2016 09:27AM
Re: Very slow query when too many joins   317 Peter Brawley 06/05/2016 10:14AM
Re: Very slow query when too many joins   298 As Os 06/05/2016 10:48AM
Re: Very slow query when too many joins   305 Peter Brawley 06/05/2016 10:56AM
Re: Very slow query when too many joins   277 As Os 06/05/2016 03:33PM
Re: Very slow query when too many joins   302 Peter Brawley 06/05/2016 03:41PM
Re: Very slow query when too many joins   325 Rick James 06/05/2016 05:36PM
Re: Very slow query when too many joins   270 As Os 06/06/2016 02:23AM
Re: Very slow query when too many joins   301 As Os 06/06/2016 03:33AM
Re: Very slow query when too many joins   266 As Os 06/06/2016 08:36AM
Re: Very slow query when too many joins   261 Peter Brawley 06/06/2016 08:52AM
Re: Very slow query when too many joins   279 As Os 06/06/2016 09:02AM
Re: Very slow query when too many joins   269 Peter Brawley 06/06/2016 11:16AM
Re: Very slow query when too many joins   285 Peter Brawley 06/06/2016 08:29AM
Re: Very slow query when too many joins   297 As Os 06/06/2016 11:30AM
Re: Very slow query when too many joins   284 Peter Brawley 06/06/2016 12:08PM
Re: Very slow query when too many joins   292 As Os 06/06/2016 02:11PM
Re: Very slow query when too many joins   326 Rick James 06/07/2016 03:40PM
Re: Very slow query when too many joins   228 james wang 07/20/2016 05:34AM
Re: Very slow query when too many joins   241 Rick James 07/20/2016 09:37AM
Re: Very slow query when too many joins   259 james wang 07/21/2016 04:43AM
Re: Very slow query when too many joins   226 Rick James 07/22/2016 10:59PM
MySQL data volume   450 Parfait Fortuné NDOLO 07/21/2016 10:21AM
Re: MySQL data volume   243 Peter Brawley 07/21/2016 11:41PM
Re: MySQL data volume   244 Rick James 07/22/2016 10:57PM
Query optimize on large database   450 Pavel Volkov 07/13/2016 01:40AM
Re: Query optimize on large database   262 Rick James 07/15/2016 05:12PM
Re: Query optimize on large database   265 Pavel Volkov 07/16/2016 04:15AM
Re: Query optimize on large database   250 Peter Brawley 07/16/2016 12:09PM
Re: Query optimize on large database   244 Pavel Volkov 07/16/2016 12:36PM
Re: Query optimize on large database   240 Rick James 07/16/2016 02:46PM
Re: Query optimize on large database   243 Peter Brawley 07/17/2016 11:22AM
Re: Query optimize on large database   231 Pavel Volkov 07/18/2016 04:28AM
Re: Query optimize on large database   226 Peter Brawley 07/18/2016 08:40AM
Re: Query optimize on large database   233 james wang 07/20/2016 04:46AM
Re: Query optimize on large database   225 Pavel Volkov 07/20/2016 08:06AM
Re: Query optimize on large database   244 Rick James 07/20/2016 09:29AM
Re: Query optimize on large database   232 james wang 07/21/2016 04:35AM
Unexplained very bad subquery performance   388 Arnaud Bertrand 07/18/2016 04:29AM
Re: Unexplained very bad subquery performance   249 Peter Brawley 07/18/2016 08:44AM
Re: Unexplained very bad subquery performance   272 Arnaud Bertrand 07/18/2016 01:06PM
Re: Unexplained very bad subquery performance   226 Peter Brawley 07/18/2016 03:30PM
Re: Unexplained very bad subquery performance   240 Arnaud Bertrand 07/19/2016 03:16AM
Re: Unexplained very bad subquery performance   237 Peter Brawley 07/19/2016 04:21AM
Re: Unexplained very bad subquery performance   231 james wang 07/20/2016 04:35AM
specify conditions from outer query on a materialized subquery   352 Pratik Gandhi 07/12/2016 10:55PM
Re: specify conditions from outer query on a materialized subquery   219 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)   508 Ra Nala 06/28/2016 06:22AM
Re: count(*) or count(id)   248 Ra Nala 06/28/2016 06:26AM
Re: count(*) or count(id)   243 Peter Brawley 06/28/2016 05:18PM
Re: count(*) or count(id)   260 Rick James 07/04/2016 01:04PM
Re: count(*) or count(id)   259 Ra Nala 07/06/2016 12:30AM
CREATE INDEX Online DDL Not Working   505 Jayanath Dissanayake 06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working   269 Øystein Grøvlen 06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working   243 Rick James 06/23/2016 07:07PM
Select random rows when using UUID   549 Jonathan Keen 06/09/2016 11:43AM
Re: Select random rows when using UUID   284 Rick James 06/13/2016 01:36AM
Re: Select random rows when using UUID   323 Jonathan Keen 06/14/2016 11:23AM
Re: Select random rows when using UUID   286 Rick James 06/18/2016 01:35AM
SQLSTATE[HY000] [1044] Access denied   883 YOONTAE KIM 06/16/2016 07:55PM
Index Not being used.   541 Greg Mundt 05/26/2016 02:29PM
Re: Index Not being used.   288 Peter Brawley 05/26/2016 03:53PM
Re: Index Not being used.   307 Øystein Grøvlen 05/27/2016 12:45AM
Re: Index Not being used.   272 Greg Mundt 05/27/2016 07:05AM
Re: Index Not being used.   275 Rick James 05/27/2016 11:29PM
Re: Index Not being used.   275 Greg Mundt 05/31/2016 07:04AM
Re: Index Not being used.   273 Rick James 05/31/2016 09:26PM
Re: Index Not being used.   279 Greg Mundt 06/01/2016 05:40AM
Re: Index Not being used.   247 Rick James 06/01/2016 11:29AM
Re: Index Not being used.   294 Greg Mundt 06/01/2016 11:41AM
Re: Index Not being used.   268 Rick James 06/04/2016 05:14PM
Re: Index Not being used.   288 Greg Mundt 05/27/2016 10:14AM
A proposal to make disk IO much faster under SSD   635 suiyemin sui 05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD   350 Rick James 05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD   312 suiyemin sui 06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD   270 Rick James 06/04/2016 04:38PM
query taking really long time.   562 Mehraz Ahmed Sheikh 05/16/2016 09:45AM
Re: query taking really long time.   288 Rick James 05/23/2016 02:58PM
Left join vs Inner join   653 Vikas Sood 05/09/2016 06:10PM
Re: Left join vs Inner join   328 Øystein Grøvlen 05/10/2016 08:04AM
Re: Left join vs Inner join   301 Vikas Sood 05/10/2016 10:40AM
Re: Left join vs Inner join   299 Rick James 05/10/2016 07:23PM
How can I improve the import speed of a large SQL file?   637 Jeff Vincent 05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file?   326 Peter Brawley 05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file?   325 Jeff Vincent 05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file?   320 Rick James 05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file?   341 Shane Bester 05/08/2016 04:49AM
text vs varchar   665 hua kai 04/28/2016 08:36AM
Re: text vs varchar   331 Øystein Grøvlen 04/29/2016 12:41AM
Re: text vs varchar   339 Rick James 04/30/2016 11:51PM
Re: text vs varchar   365 Øystein Grøvlen 05/02/2016 04:37AM
Re: text vs varchar   317 hua kai 05/02/2016 09:14PM
Re: text vs varchar   320 Øystein Grøvlen 05/03/2016 02:19AM
Re: text vs varchar   435 hua kai 05/03/2016 04:12AM
Re: text vs varchar   300 hua kai 05/02/2016 08:02PM
Re: text vs varchar   365 Øystein Grøvlen 05/03/2016 02:25AM
Query with 2 x subquery   623 Jes Ramsing 04/29/2016 06:44AM
Re: Query with 2 x subquery   355 Øystein Grøvlen 04/29/2016 08:01AM
Re: Query with 2 x subquery   329 Jes Ramsing 05/01/2016 11:57PM
Re: Query with 2 x subquery   286 Øystein Grøvlen 05/02/2016 03:45AM
Re: Query with 2 x subquery   293 Jes Ramsing 05/02/2016 05:32AM
Re: Query with 2 x subquery   300 Rick James 05/01/2016 11:58PM
Re: Query with 2 x subquery   343 Jes Ramsing 05/02/2016 02:16AM
Slow Query, Optimization Advice Needed   646 Michael Lawson 04/26/2016 09:30AM
Re: Slow Query, Optimization Advice Needed   309 Øystein Grøvlen 04/27/2016 01:02AM
Re: Slow Query, Optimization Advice Needed   338 Michael Lawson 04/27/2016 07:20PM
Re: Slow Query, Optimization Advice Needed   320 Peter Brawley 04/27/2016 11:28PM
Re: Slow Query, Optimization Advice Needed   302 Øystein Grøvlen 04/28/2016 01:25AM
Re: Slow Query, Optimization Advice Needed   298 Rick James 05/01/2016 11:47PM
Re: Slow Query, Optimization Advice Needed   313 Øystein Grøvlen 05/02/2016 01:28AM
Re: Slow Query, Optimization Advice Needed   310 Øystein Grøvlen 04/28/2016 01:12AM
Reg table design and query performances   589 Devrishi Shandilya 04/26/2016 03:02AM
Re: Reg table design and query performances   320 Øystein Grøvlen 04/26/2016 06:02AM
Re: Reg table design and query performances   389 Devrishi Shandilya 04/26/2016 06:16AM
Re: Reg table design and query performances   314 Øystein Grøvlen 04/26/2016 06:35AM
Re: Reg table design and query performances   335 Devrishi Shandilya 04/26/2016 06:50AM
Re: Reg table design and query performances   313 Øystein Grøvlen 04/26/2016 07:04AM
Re: Reg table design and query performances   300 Rick James 04/30/2016 11:46PM
Re: Reg table design and query performances   274 Øystein Grøvlen 05/02/2016 01:00AM
Memory benefits of huge pages   614 Olga Turetskaya 04/30/2016 11:21AM
Re: Memory benefits of huge pages   316 Rick James 05/01/2016 02:36PM
Configuration review requested   806 Jens Meier 04/13/2016 11:55AM
Re: Configuration review requested   335 Rick James 04/14/2016 01:39PM
block_ops_in and block_ops_out meaning   1,003 hua kai 03/18/2016 02:33AM
Re: block_ops_in and block_ops_out meaning   478 Rick James 03/21/2016 11:34PM
Re: block_ops_in and block_ops_out meaning   502 Peter Brawley 03/22/2016 02:03AM
Re: block_ops_in and block_ops_out meaning   526 hua kai 03/25/2016 12:30AM
Re: block_ops_in and block_ops_out meaning   510 hua kai 04/14/2016 12:52AM
order by primary key slowly   777 varky chan 04/05/2016 10:42PM
Re: order by primary key slowly   364 Øystein Grøvlen 04/06/2016 04:35AM
Re: order by primary key slowly   399 varky chan 04/06/2016 10:15AM
Re: order by primary key slowly   375 Peter Brawley 04/06/2016 11:23AM
Re: order by primary key slowly   411 varky chan 04/06/2016 08:11PM
Re: order by primary key slowly   341 Peter Brawley 04/06/2016 10:35PM
Re: order by primary key slowly   355 varky chan 04/07/2016 12:34AM
Re: order by primary key slowly   381 Øystein Grøvlen 04/07/2016 07:21AM
Re: order by primary key slowly   367 Peter Brawley 04/07/2016 10:20AM
Re: order by primary key slowly   356 varky chan 04/07/2016 11:26PM
Re: order by primary key slowly   337 Rick James 04/12/2016 07:42PM
Re: order by primary key slowly   352 Peter Brawley 04/06/2016 08:57AM
Re: order by primary key slowly   343 varky chan 04/06/2016 10:17AM
[INNODB] why there are many "waiting for table level lock"?   651 HANWEN YIN 04/11/2016 12:08AM
Re: [INNODB] why there are many "waiting for table level lock"?   349 Rick James 04/12/2016 07:27PM
Improve performance when altering huge tables   645 Davide Cicuta 04/04/2016 07:24AM
Re: Improve performance when altering huge tables   377 Rick James 04/05/2016 02:59PM
MySql 5.7 - Poor Performance PURGE BINARY LOGS   823 Davy Campano 03/23/2016 08:08PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   379 Rick James 03/26/2016 11:58PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   406 Davy Campano 03/29/2016 09:44AM
where the snapshot for select in transaction stored   705 hua kai 03/21/2016 03:03AM
Re: where the snapshot for select in transaction stored   342 Rick James 03/21/2016 11:21PM
Difference execution plans for same query   795 Devrishi Shandilya 02/25/2016 12:05AM
Re: Difference execution plans for same query   364 Peter Brawley 02/25/2016 01:51AM
Re: Difference execution plans for same query   400 Øystein Grøvlen 02/25/2016 03:51AM
Re: Difference execution plans for same query   363 Rick James 03/05/2016 01:19AM
Slow join performance   879 Ra Nala 11/27/2015 04:55AM
Re: Slow join performance   477 Rick James 11/28/2015 03:02PM
Re: Slow join performance   365 Ra Nala 02/25/2016 06:22AM
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.