MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.27 has been released 08/22/2016 12:00PM
MySQL Connector/NET 7.0.4 m3 development has been released 08/22/2016 08:36AM
MySQL Utilities 1.6.4 GA has been released 08/05/2016 10:44AM
MySQL Enterprise Backup 4.0.3 has been released 08/05/2016 09:28AM
MySQL Notifier 1.1.7 has been released 08/01/2016 04:37PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 72
Subject Views Written By Posted
Sticky:  MySQL XProtocol: Asynchronous Query Execution (1 Posts)   267 Edwin Desouza 05/27/2016 03:34PM
Sticky:  MySQL 5.7: Performance Benchmarks -- 1.6million QPS (1 Posts)   1,039 Edwin Desouza 10/27/2015 08:14AM
Sticky:  MySQL 5.7: includes SYS Schema (metrics, instumentation) (1 Posts)   1,278 Edwin Desouza 04/10/2015 02:40PM
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)   1,789 Edwin Desouza 02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   2,288 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   3,918 Edwin Desouza 02/12/2013 06:11PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   6,226 Edwin DeSouza 08/04/2011 09:09AM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   166,646 Edwin DeSouza 05/25/2006 10:50AM
Multiple indexes - how do they work?   26 Rathi Rao 08/25/2016 03:51AM
Re: Multiple indexes - how do they work?   11 Peter Brawley 08/25/2016 11:29AM
Re: Multiple indexes - how do they work?   5 Rick James 08/26/2016 02:20PM
MySQL Table Valued Parameter   29 tony mendoza 08/23/2016 11:29AM
Re: MySQL Table Valued Parameter   4 Rick James 08/26/2016 02:17PM
Partitioned table details in the Explain Plan   37 Rathi Rao 08/19/2016 01:54AM
Re: Partitioned table details in the Explain Plan   17 Øystein Grøvlen 08/19/2016 07:00AM
Re: Partitioned table details in the Explain Plan   18 Rick James 08/20/2016 06:10PM
Rolling unique user counts   49 Paul Stam 08/09/2016 02:06AM
Re: Rolling unique user counts   26 Rick James 08/14/2016 06:22PM
Re: Rolling unique user counts   23 Paul Stam 08/15/2016 01:49AM
Re: Rolling unique user counts   16 Paul Stam 08/18/2016 06:03AM
Re: Rolling unique user counts   20 Rick James 08/18/2016 04:37PM
Wrong estimation of Rows in explain   99 Rathi Rao 07/27/2016 06:19AM
Re: Wrong estimation of Rows in explain   40 Peter Brawley 07/27/2016 08:55AM
Re: Wrong estimation of Rows in explain   43 Rathi Rao 07/27/2016 11:58PM
Re: Wrong estimation of Rows in explain   42 Peter Brawley 07/28/2016 09:14AM
Re: Wrong estimation of Rows in explain   38 Rathi Rao 07/29/2016 05:11AM
Re: Wrong estimation of Rows in explain   42 Peter Brawley 07/29/2016 01:10PM
Re: Wrong estimation of Rows in explain   36 Rick James 07/29/2016 06:58PM
Re: Wrong estimation of Rows in explain   34 Rathi Rao 08/02/2016 05:48AM
Re: Wrong estimation of Rows in explain   33 Rick James 08/02/2016 06:23PM
Re: Wrong estimation of Rows in explain   28 Rathi Rao 08/02/2016 05:38AM
Re: Wrong estimation of Rows in explain   31 james wang 08/04/2016 05:31AM
30 millions reads/day   83 Srinivas K 07/29/2016 05:34AM
Re: 30 millions reads/day   43 Rick James 07/29/2016 07:03PM
Re: 30 millions reads/day   28 james wang 08/04/2016 05:15AM
mysql commit slow,please help me   89 jw maple 07/27/2016 02:11AM
Re: mysql commit slow,please help me   48 Rick James 07/29/2016 05:15PM
Very slow query when too many joins   259 As Os 06/05/2016 09:17AM
Re: Very slow query when too many joins   107 As Os 06/05/2016 09:27AM
Re: Very slow query when too many joins   99 Peter Brawley 06/05/2016 10:14AM
Re: Very slow query when too many joins   100 As Os 06/05/2016 10:48AM
Re: Very slow query when too many joins   107 Peter Brawley 06/05/2016 10:56AM
Re: Very slow query when too many joins   90 As Os 06/05/2016 03:33PM
Re: Very slow query when too many joins   106 Peter Brawley 06/05/2016 03:41PM
Re: Very slow query when too many joins   94 Rick James 06/05/2016 05:36PM
Re: Very slow query when too many joins   91 As Os 06/06/2016 02:23AM
Re: Very slow query when too many joins   109 As Os 06/06/2016 03:33AM
Re: Very slow query when too many joins   86 As Os 06/06/2016 08:36AM
Re: Very slow query when too many joins   84 Peter Brawley 06/06/2016 08:52AM
Re: Very slow query when too many joins   87 As Os 06/06/2016 09:02AM
Re: Very slow query when too many joins   83 Peter Brawley 06/06/2016 11:16AM
Re: Very slow query when too many joins   94 Peter Brawley 06/06/2016 08:29AM
Re: Very slow query when too many joins   88 As Os 06/06/2016 11:30AM
Re: Very slow query when too many joins   84 Peter Brawley 06/06/2016 12:08PM
Re: Very slow query when too many joins   93 As Os 06/06/2016 02:11PM
Re: Very slow query when too many joins   128 Rick James 06/07/2016 03:40PM
Re: Very slow query when too many joins   46 james wang 07/20/2016 05:34AM
Re: Very slow query when too many joins   49 Rick James 07/20/2016 09:37AM
Re: Very slow query when too many joins   49 james wang 07/21/2016 04:43AM
Re: Very slow query when too many joins   43 Rick James 07/22/2016 10:59PM
MySQL data volume   105 Parfait Fortuné NDOLO 07/21/2016 10:21AM
Re: MySQL data volume   46 Peter Brawley 07/21/2016 11:41PM
Re: MySQL data volume   54 Rick James 07/22/2016 10:57PM
Query optimize on large database   131 Pavel Volkov 07/13/2016 01:40AM
Re: Query optimize on large database   62 Rick James 07/15/2016 05:12PM
Re: Query optimize on large database   54 Pavel Volkov 07/16/2016 04:15AM
Re: Query optimize on large database   53 Peter Brawley 07/16/2016 12:09PM
Re: Query optimize on large database   48 Pavel Volkov 07/16/2016 12:36PM
Re: Query optimize on large database   50 Rick James 07/16/2016 02:46PM
Re: Query optimize on large database   43 Peter Brawley 07/17/2016 11:22AM
Re: Query optimize on large database   50 Pavel Volkov 07/18/2016 04:28AM
Re: Query optimize on large database   45 Peter Brawley 07/18/2016 08:40AM
Re: Query optimize on large database   48 james wang 07/20/2016 04:46AM
Re: Query optimize on large database   48 Pavel Volkov 07/20/2016 08:06AM
Re: Query optimize on large database   46 Rick James 07/20/2016 09:29AM
Re: Query optimize on large database   45 james wang 07/21/2016 04:35AM
Unexplained very bad subquery performance   103 Arnaud Bertrand 07/18/2016 04:29AM
Re: Unexplained very bad subquery performance   52 Peter Brawley 07/18/2016 08:44AM
Re: Unexplained very bad subquery performance   44 Arnaud Bertrand 07/18/2016 01:06PM
Re: Unexplained very bad subquery performance   48 Peter Brawley 07/18/2016 03:30PM
Re: Unexplained very bad subquery performance   48 Arnaud Bertrand 07/19/2016 03:16AM
Re: Unexplained very bad subquery performance   50 Peter Brawley 07/19/2016 04:21AM
Re: Unexplained very bad subquery performance   46 james wang 07/20/2016 04:35AM
specify conditions from outer query on a materialized subquery   100 Pratik Gandhi 07/12/2016 10:55PM
Re: specify conditions from outer query on a materialized subquery   47 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)   142 Ra Nala 06/28/2016 06:22AM
Re: count(*) or count(id)   60 Ra Nala 06/28/2016 06:26AM
Re: count(*) or count(id)   61 Peter Brawley 06/28/2016 05:18PM
Re: count(*) or count(id)   60 Rick James 07/04/2016 01:04PM
Re: count(*) or count(id)   53 Ra Nala 07/06/2016 12:30AM
CREATE INDEX Online DDL Not Working   177 Jayanath Dissanayake 06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working   79 Øystein Grøvlen 06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working   67 Rick James 06/23/2016 07:07PM
Select random rows when using UUID   205 Jonathan Keen 06/09/2016 11:43AM
Re: Select random rows when using UUID   94 Rick James 06/13/2016 01:36AM
Re: Select random rows when using UUID   84 Jonathan Keen 06/14/2016 11:23AM
Re: Select random rows when using UUID   88 Rick James 06/18/2016 01:35AM
SQLSTATE[HY000] [1044] Access denied   209 YOONTAE KIM 06/16/2016 07:55PM
Index Not being used.   236 Greg Mundt 05/26/2016 02:29PM
Re: Index Not being used.   107 Peter Brawley 05/26/2016 03:53PM
Re: Index Not being used.   106 Øystein Grøvlen 05/27/2016 12:45AM
Re: Index Not being used.   95 Greg Mundt 05/27/2016 07:05AM
Re: Index Not being used.   106 Rick James 05/27/2016 11:29PM
Re: Index Not being used.   89 Greg Mundt 05/31/2016 07:04AM
Re: Index Not being used.   92 Rick James 05/31/2016 09:26PM
Re: Index Not being used.   93 Greg Mundt 06/01/2016 05:40AM
Re: Index Not being used.   85 Rick James 06/01/2016 11:29AM
Re: Index Not being used.   107 Greg Mundt 06/01/2016 11:41AM
Re: Index Not being used.   91 Rick James 06/04/2016 05:14PM
Re: Index Not being used.   93 Greg Mundt 05/27/2016 10:14AM
A proposal to make disk IO much faster under SSD   250 suiyemin sui 05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD   127 Rick James 05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD   110 suiyemin sui 06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD   87 Rick James 06/04/2016 04:38PM
query taking really long time.   271 Mehraz Ahmed Sheikh 05/16/2016 09:45AM
Re: query taking really long time.   113 Rick James 05/23/2016 02:58PM
Left join vs Inner join   236 Vikas Sood 05/09/2016 06:10PM
Re: Left join vs Inner join   135 Øystein Grøvlen 05/10/2016 08:04AM
Re: Left join vs Inner join   122 Vikas Sood 05/10/2016 10:40AM
Re: Left join vs Inner join   123 Rick James 05/10/2016 07:23PM
How can I improve the import speed of a large SQL file?   254 Jeff Vincent 05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file?   124 Peter Brawley 05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file?   127 Jeff Vincent 05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file?   117 Rick James 05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file?   131 Shane Bester 05/08/2016 04:49AM
text vs varchar   314 hua kai 04/28/2016 08:36AM
Re: text vs varchar   144 Øystein Grøvlen 04/29/2016 12:41AM
Re: text vs varchar   142 Rick James 04/30/2016 11:51PM
Re: text vs varchar   136 Øystein Grøvlen 05/02/2016 04:37AM
Re: text vs varchar   122 hua kai 05/02/2016 09:14PM
Re: text vs varchar   119 Øystein Grøvlen 05/03/2016 02:19AM
Re: text vs varchar   133 hua kai 05/03/2016 04:12AM
Re: text vs varchar   118 hua kai 05/02/2016 08:02PM
Re: text vs varchar   124 Øystein Grøvlen 05/03/2016 02:25AM
Query with 2 x subquery   274 Jes Ramsing 04/29/2016 06:44AM
Re: Query with 2 x subquery   165 Øystein Grøvlen 04/29/2016 08:01AM
Re: Query with 2 x subquery   137 Jes Ramsing 05/01/2016 11:57PM
Re: Query with 2 x subquery   112 Øystein Grøvlen 05/02/2016 03:45AM
Re: Query with 2 x subquery   116 Jes Ramsing 05/02/2016 05:32AM
Re: Query with 2 x subquery   126 Rick James 05/01/2016 11:58PM
Re: Query with 2 x subquery   174 Jes Ramsing 05/02/2016 02:16AM
Slow Query, Optimization Advice Needed   301 Michael Lawson 04/26/2016 09:30AM
Re: Slow Query, Optimization Advice Needed   131 Øystein Grøvlen 04/27/2016 01:02AM
Re: Slow Query, Optimization Advice Needed   142 Michael Lawson 04/27/2016 07:20PM
Re: Slow Query, Optimization Advice Needed   134 Peter Brawley 04/27/2016 11:28PM
Re: Slow Query, Optimization Advice Needed   126 Øystein Grøvlen 04/28/2016 01:25AM
Re: Slow Query, Optimization Advice Needed   116 Rick James 05/01/2016 11:47PM
Re: Slow Query, Optimization Advice Needed   122 Øystein Grøvlen 05/02/2016 01:28AM
Re: Slow Query, Optimization Advice Needed   142 Øystein Grøvlen 04/28/2016 01:12AM
Reg table design and query performances   291 Devrishi Shandilya 04/26/2016 03:02AM
Re: Reg table design and query performances   130 Øystein Grøvlen 04/26/2016 06:02AM
Re: Reg table design and query performances   147 Devrishi Shandilya 04/26/2016 06:16AM
Re: Reg table design and query performances   144 Øystein Grøvlen 04/26/2016 06:35AM
Re: Reg table design and query performances   156 Devrishi Shandilya 04/26/2016 06:50AM
Re: Reg table design and query performances   134 Øystein Grøvlen 04/26/2016 07:04AM
Re: Reg table design and query performances   127 Rick James 04/30/2016 11:46PM
Re: Reg table design and query performances   107 Øystein Grøvlen 05/02/2016 01:00AM
Memory benefits of huge pages   276 Olga Turetskaya 04/30/2016 11:21AM
Re: Memory benefits of huge pages   125 Rick James 05/01/2016 02:36PM
Configuration review requested   364 Jens Meier 04/13/2016 11:55AM
Re: Configuration review requested   160 Rick James 04/14/2016 01:39PM
block_ops_in and block_ops_out meaning   455 hua kai 03/18/2016 02:33AM
Re: block_ops_in and block_ops_out meaning   223 Rick James 03/21/2016 11:34PM
Re: block_ops_in and block_ops_out meaning   217 Peter Brawley 03/22/2016 02:03AM
Re: block_ops_in and block_ops_out meaning   217 hua kai 03/25/2016 12:30AM
Re: block_ops_in and block_ops_out meaning   179 hua kai 04/14/2016 12:52AM
order by primary key slowly   372 varky chan 04/05/2016 10:42PM
Re: order by primary key slowly   193 Øystein Grøvlen 04/06/2016 04:35AM
Re: order by primary key slowly   195 varky chan 04/06/2016 10:15AM
Re: order by primary key slowly   199 Peter Brawley 04/06/2016 11:23AM
Re: order by primary key slowly   185 varky chan 04/06/2016 08:11PM
Re: order by primary key slowly   175 Peter Brawley 04/06/2016 10:35PM
Re: order by primary key slowly   173 varky chan 04/07/2016 12:34AM
Re: order by primary key slowly   168 Øystein Grøvlen 04/07/2016 07:21AM
Re: order by primary key slowly   179 Peter Brawley 04/07/2016 10:20AM
Re: order by primary key slowly   172 varky chan 04/07/2016 11:26PM
Re: order by primary key slowly   148 Rick James 04/12/2016 07:42PM
Re: order by primary key slowly   164 Peter Brawley 04/06/2016 08:57AM
Re: order by primary key slowly   158 varky chan 04/06/2016 10:17AM
[INNODB] why there are many "waiting for table level lock"?   328 HANWEN YIN 04/11/2016 12:08AM
Re: [INNODB] why there are many "waiting for table level lock"?   155 Rick James 04/12/2016 07:27PM
Improve performance when altering huge tables   341 Davide Cicuta 04/04/2016 07:24AM
Re: Improve performance when altering huge tables   160 Rick James 04/05/2016 02:59PM
MySql 5.7 - Poor Performance PURGE BINARY LOGS   438 Davy Campano 03/23/2016 08:08PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   210 Rick James 03/26/2016 11:58PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   225 Davy Campano 03/29/2016 09:44AM
where the snapshot for select in transaction stored   407 hua kai 03/21/2016 03:03AM
Re: where the snapshot for select in transaction stored   170 Rick James 03/21/2016 11:21PM
Difference execution plans for same query   448 Devrishi Shandilya 02/25/2016 12:05AM
Re: Difference execution plans for same query   198 Peter Brawley 02/25/2016 01:51AM
Re: Difference execution plans for same query   204 Øystein Grøvlen 02/25/2016 03:51AM
Re: Difference execution plans for same query   191 Rick James 03/05/2016 01:19AM
Slow join performance   562 Ra Nala 11/27/2015 04:55AM
Re: Slow join performance   305 Rick James 11/28/2015 03:02PM
Re: Slow join performance   194 Ra Nala 02/25/2016 06:22AM
which is best for JOIN approach   629 Ra Nala 11/24/2015 09:39AM
Re: which is best for JOIN approach   351 Øystein Grøvlen 11/25/2015 02:14AM
Re: which is best for JOIN approach   323 Ra Nala 11/25/2015 02:42AM
Re: which is best for JOIN approach   309 Rick James 11/29/2015 11:53AM
Re: which is best for JOIN approach   209 Ra Nala 02/19/2016 05:28AM
Re: which is best for JOIN approach   205 Peter Brawley 02/21/2016 04:56PM
Re: which is best for JOIN approach   200 Ra Nala 02/19/2016 05:31AM
Re: which is best for JOIN approach   194 Rick James 02/21/2016 01:40PM
Re: which is best for JOIN approach   209 Rick James 02/21/2016 01:43PM
Re: which is best for JOIN approach   244 Ra Nala 02/25/2016 05:50AM
Why is wrong index being selected   440 Steve Bell 02/23/2016 01:54PM
Re: Why is wrong index being selected   192 Rick James 02/23/2016 11:39PM
Re: Why is wrong index being selected   225 Øystein Grøvlen 02/24/2016 03:22AM
Re: Why is wrong index being selected   188 Steve Bell 02/25/2016 02:47AM
Distinct or Group by which is faster   473 Ra Nala 02/22/2016 08:50AM
Re: Distinct or Group by which is faster   214 Peter Brawley 02/22/2016 12:33PM
Re: Distinct or Group by which is faster   201 Chandan Kumar 02/23/2016 12:51PM
MySQL server is not disk bound, how do I make it faster?   427 Robert Gunther 02/21/2016 09:35PM
Re: MySQL server is not disk bound, how do I make it faster?   205 Peter Brawley 02/22/2016 12:38PM
Re: MySQL server is not disk bound, how do I make it faster?   220 Rick James 02/22/2016 06:18PM
mysql text datatype SELECT query slow even with tmp dir on tmpfs   422 Muhammad Omair 02/22/2016 08:36AM
Re: mysql text datatype SELECT query slow even with tmp dir on tmpfs   194 Peter Brawley 02/22/2016 12:35PM
How can I improve this table and query   447 Adam Copley 02/17/2016 04:49AM
Re: How can I improve this table and query   212 Øystein Grøvlen 02/17/2016 06:07AM
Re: How can I improve this table and query   220 Adam Copley 02/17/2016 08:25AM
Re: How can I improve this table and query   209 Adam Copley 02/17/2016 08:26AM
Re: How can I improve this table and query   214 Øystein Grøvlen 02/17/2016 08:51AM
Re: How can I improve this table and query   215 Adam Copley 02/17/2016 09:03AM
Re: How can I improve this table and query   213 Rick James 02/21/2016 11:14PM
Does prefixing field names with their table name improve query speed?   419 Guillaume TRUCHOT 02/18/2016 04:02PM
Re: Does prefixing field names with their table name improve query speed?   204 Peter Brawley 02/18/2016 05:21PM
Re: Does prefixing field names with their table name improve query speed?   219 Rick James 02/21/2016 07:19PM
slow response when where clause has a field from 2nd table in a left join   458 Ravi Malghan 02/12/2016 12:51PM
Re: slow response when where clause has a field from 2nd table in a left join   219 Øystein Grøvlen 02/15/2016 02:10AM
Re: slow response when where clause has a field from 2nd table in a left join   192 Rick James 02/15/2016 04:17PM
Re: slow response when where clause has a field from 2nd table in a left join   188 Ravi Malghan 02/19/2016 10:18AM
max_allowed_packet error   510 Ra Nala 02/02/2016 05:12AM
Re: max_allowed_packet error   213 Rick James 02/06/2016 07:26PM
Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)   531 Bill Joyce 12/06/2015 11:41PM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)   283 Mayank Prasad 12/10/2015 03:53AM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)   240 Bill Joyce 02/04/2016 04:15PM
query performance optimization   614 Devrishi Shandilya 01/18/2016 04:49AM
Re: query performance optimization   272 Øystein Grøvlen 01/19/2016 02:30AM
Re: query performance optimization   278 Devrishi Shandilya 01/19/2016 02:50AM
Re: query performance optimization   227 Øystein Grøvlen 01/19/2016 06:24AM
Re: query performance optimization   262 Rick James 01/22/2016 06:29PM
Re: query performance optimization   247 Øystein Grøvlen 01/29/2016 04:37AM
Re: query performance optimization   312 Devrishi Shandilya 01/22/2016 06:18AM
Re: query performance optimization   224 Øystein Grøvlen 01/27/2016 06:56AM
Re: query performance optimization   252 Peter Brawley 01/22/2016 01:08PM
Re: query performance optimization   264 Peter Brawley 01/22/2016 11:10PM
Slow performance on join query using indexes   561 Amit Kapoor 01/21/2016 02:36PM
Re: Slow performance on join query using indexes   300 Øystein Grøvlen 01/22/2016 03:02AM
Re: Slow performance on join query using indexes   270 Rick James 01/23/2016 07:43PM
high cpu on request with JOIN   514 Gérard Moisset 01/15/2016 03:49AM
Re: high cpu on request with JOIN   244 Øystein Grøvlen 01/15/2016 05:43AM
Lock wait timeout exceeded; try restarting transaction   603 Ra Nala 01/07/2016 05:28AM
Re: Lock wait timeout exceeded; try restarting transaction   300 Rick James 01/07/2016 10:47PM
Re: Lock wait timeout exceeded; try restarting transaction   286 Ra Nala 01/08/2016 12:45AM
Re: Lock wait timeout exceeded; try restarting transaction   303 Ra Nala 01/08/2016 06:23AM
Re: Lock wait timeout exceeded; try restarting transaction   333 Rick James 01/09/2016 11:52PM
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.