Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.19 has been released 01/28/2015 03:25PM
MySQL Connector/Python 2.0.3 GA has been released 01/28/2015 10:53AM
MySQL Cluster 7.2.19 has been released 01/25/2015 07:51PM
MySQL Cluster 7.3.8 has been released 01/22/2015 02:19AM
MySQL Cluster 7.4.3 has been released 01/21/2015 07:50PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 70
Subject Views Written By Posted
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   821 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.7 DMR: Performance Benchmarks - 1Mil QPS (1 Posts)   1,686 Edwin Desouza 09/21/2013 11:11AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   2,327 Edwin Desouza 02/12/2013 06:11PM
Sticky:  MySQL 5.6: Server Default Config changes - my.cnf and my.ini (1 Posts)   3,630 Edwin DeSouza 12/12/2012 08:19PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   4,808 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,891 Edwin DeSouza 10/21/2010 11:13AM
Sticky:  MySQL Performance Schema: A Big Bag of Epic Awesomeness (1 Posts)   10,234 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   160,382 Edwin DeSouza 05/25/2006 10:50AM
Mysql performance between installation   65 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   23 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   18 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   18 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   18 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   101 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   43 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   27 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   21 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   134 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   29 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   25 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   31 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   25 Rick James 01/13/2015 04:21PM
How To Use More Resources   138 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   40 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   49 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   43 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   35 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   28 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   31 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   94 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   36 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   34 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   113 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   33 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   31 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   123 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   30 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   116 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   55 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   233 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   104 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   87 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   64 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   48 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   66 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   37 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   181 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   69 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   57 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   84 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   62 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   157 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   93 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   68 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   71 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   59 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   67 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   57 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   59 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   56 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   237 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   82 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   179 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   62 Rick James 11/28/2014 06:59PM
Cardinality Problem   226 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   70 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   63 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   61 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   276 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   87 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   90 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   107 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   81 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   123 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   81 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   91 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   70 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   66 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   65 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   263 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   122 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   77 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   79 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   82 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   71 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   258 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   117 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   85 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   98 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   89 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   88 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   314 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   102 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   97 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   93 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   95 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   92 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   101 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   83 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   423 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   216 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   198 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   173 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   136 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   144 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   109 Ravi Malghan 11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support   308 Christine Ross 10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support   190 Peter Brawley 10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support   168 Christine Ross 10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support   153 Rick James 11/02/2014 09:33AM
GROUP causing Using Temporary Using Filesort   1,739 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   743 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   672 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   578 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   468 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   402 Rick James 08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort   328 RT Lee 08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort   350 Rick James 08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort   219 Leonardo Duque 10/30/2014 12:57PM
Leonardo, please do not hijack threads   164 Peter Brawley 10/31/2014 11:15AM
Eliminate filesort in update query   413 Matzz - 09/23/2014 02:48AM
Re: Eliminate filesort in update query   150 Rick James 09/23/2014 09:59PM
Re: Eliminate filesort in update query   160 Matzz - 09/24/2014 01:25AM
Re: Eliminate filesort in update query   160 Rick James 09/24/2014 08:40PM
Re: Eliminate filesort in update query   154 Matzz - 09/25/2014 05:48AM
Re: Eliminate filesort in update query   152 Rick James 09/26/2014 04:39PM
Re: Eliminate filesort in update query   165 Matzz - 10/01/2014 06:49AM
Re: Eliminate filesort in update query   152 Rick James 10/03/2014 10:09PM
Re: Eliminate filesort in update query   162 Matzz - 10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table   333 Jeetu Gaur 09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table   157 Rick James 09/27/2014 08:16AM
Slow response time due queries   440 Jens Meier 09/23/2014 01:32AM
Re: Slow response time due queries   170 Rick James 09/23/2014 10:11PM
PHP/MySQL to use all CPU/memory to increase performance   399 Caleb Pitman 09/21/2014 11:04AM
Re: PHP/MySQL to use all CPU/memory to increase performance   197 Rick James 09/22/2014 03:39PM
Re: PHP/MySQL to use all CPU/memory to increase performance   200 Caleb Pitman 09/22/2014 04:55PM
Re: PHP/MySQL to use all CPU/memory to increase performance   182 Rick James 09/23/2014 03:21PM
How to set mysql CPU affinity?   529 Metal Messiah 09/21/2014 01:33PM
Re: How to set mysql CPU affinity?   245 Rick James 09/22/2014 03:25PM
Re: How to set mysql CPU affinity?   222 Sophia Parsons 09/23/2014 01:30AM
Re: How to set mysql CPU affinity?   215 Rick James 09/23/2014 11:03AM
Query optimization to reduce execution time.   351 Neetu Nayak 09/22/2014 07:33AM
Re: Query optimization to reduce execution time.   191 Rick James 09/22/2014 08:46PM
Re: Query optimization to reduce execution time.   180 Neetu Nayak 09/23/2014 12:38AM
Re: Query optimization to reduce execution time.   171 Neetu Nayak 09/23/2014 01:42AM
Mass Update optimization   410 Susan Lin 09/14/2014 06:00PM
Re: Mass Update optimization   201 Rick James 09/15/2014 11:38AM
Re: Mass Update optimization   156 Sophia Parsons 09/23/2014 01:36AM
Optimising query with composite index, which says using where   361 Timothy Mifsud 09/06/2014 12:38AM
Re: Optimising query with composite index, which says using where   150 Timothy Mifsud 09/06/2014 01:53AM
Re: Optimising query with composite index, which says using where   139 Rick James 09/07/2014 10:46PM
Re: Optimising query with composite index, which says using where   136 Øystein Grøvlen 09/15/2014 06:03AM
Re: Optimising query with composite index, which says using where   127 Rick James 09/15/2014 10:03AM
Slow Performance with Multi-threaded app   385 Minesh Desai 09/12/2014 09:24AM
Re: Slow Performance with Multi-threaded app   170 Rick James 09/13/2014 09:47AM
InnoDB and locking, UPDATE and SELECT   364 Andreas Greulich 09/10/2014 01:18AM
Re: InnoDB and locking, UPDATE and SELECT   157 Rick James 09/13/2014 12:09AM
MySQL using too much CPU   410 31 Special 08/29/2014 05:12PM
Re: MySQL using too much CPU   208 Rick James 08/30/2014 05:27PM
Re: MySQL using too much CPU   257 31 Special 08/31/2014 10:13PM
Understanding Explain   387 J M 08/27/2014 07:31AM
Re: Understanding Explain   193 Peter Brawley 08/27/2014 10:35AM
Re: Understanding Explain   159 J M 08/27/2014 10:51AM
Re: Understanding Explain   161 Øystein Grøvlen 08/28/2014 03:00PM
Re: Understanding Explain   155 Rick James 08/29/2014 09:45PM
Need help to otimize my query   366 GAURAV JAIN 08/21/2014 07:28AM
Re: Need help to otimize my query   194 Rick James 08/24/2014 09:17PM
Slow response in MY SQL 5.5.1.8   403 Amila Kumara 07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8   202 Rick James 07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8   219 Amila Kumara 07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8   222 Rick James 07/23/2014 12:19AM
Help in tuning MySQL 5.6 database   394 Deepak Dambe 07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database   199 Rick James 07/18/2014 12:12PM
Query slows down over time   543 Sameer Shah 05/28/2014 09:35AM
Re: Query slows down over time   270 Peter Brawley 05/28/2014 12:45PM
Re: Query slows down over time   252 Sameer Shah 05/28/2014 01:24PM
Re: Query slows down over time   276 Rick James 05/28/2014 04:57PM
Re: Query slows down over time   290 Sameer Shah 05/28/2014 05:46PM
Re: Query slows down over time   262 Rick James 05/28/2014 07:23PM
Re: Query slows down over time   403 Sam Shah 05/29/2014 05:38AM
Re: Query slows down over time   262 Rick James 05/29/2014 09:49AM
Re: Query slows down over time   262 Sam Shah 05/29/2014 03:12PM
Re: Query slows down over time   219 Sam Shah 07/15/2014 12:10PM
Re: Query slows down over time   223 Peter Brawley 07/15/2014 12:33PM
Re: Query slows down over time   183 Rick James 07/16/2014 11:19AM
Performance problem with outer join   457 RT Lee 07/11/2014 07:53AM
Re: Performance problem with outer join   221 Peter Brawley 07/11/2014 09:26AM
Re: Performance problem with outer join   215 Rick James 07/11/2014 04:26PM
Re: Performance problem with outer join   203 RT Lee 07/13/2014 12:29PM
Where to look for server freezes   410 Michael Muratet 07/10/2014 10:08AM
Re: Where to look for server freezes   178 Rick James 07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order   582 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   296 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   309 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   271 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   264 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   959 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   293 Rick James 06/26/2014 06:19PM
MySQL hangs due to large delete   466 Akshay Viswanathan 06/25/2014 08:51AM
Re: MySQL hangs due to large delete   221 Rick James 06/26/2014 06:13PM
Superkey vs Primary Key   627 Mario Schill 06/16/2014 04:13AM
Re: Superkey vs Primary Key   298 Peter Brawley 06/16/2014 10:42AM
Re: Superkey vs Primary Key   248 Mario Schill 06/17/2014 12:57AM
Re: Superkey vs Primary Key   280 Peter Brawley 06/17/2014 03:42AM
DML operations slow down   483 Sivaprakash Gopal 06/04/2014 04:43PM
Re: DML operations slow down   267 Rick James 06/06/2014 09:18AM
how to configure my.cnf for mysql 5.1, using too much cpu?   592 Aamir Sohail 06/05/2014 06:15AM
Re: how to configure my.cnf for mysql 5.1, using too much cpu?   301 Rick James 06/06/2014 09:09AM
'Compound' INDEXes   522 lee fei 06/04/2014 03:24AM
Re: 'Compound' INDEXes   253 Rick James 06/05/2014 09:12PM
Delete slow... randomly   588 Francesco De Carlo 06/02/2014 09:15AM
Re: Delete slow... randomly   281 Rick James 06/03/2014 09:51AM
Re: Delete slow... randomly   262 Francesco De Carlo 06/04/2014 03:43AM
Re: Delete slow... randomly   258 Rick James 06/05/2014 08:01PM
concurrent_insert   512 Ben Zhou 06/01/2014 08:15AM
Re: concurrent_insert   266 Rick James 06/02/2014 11:53AM
Re: concurrent_insert   255 Ben Zhou 06/04/2014 08:37AM
Re: concurrent_insert   269 Rick James 06/05/2014 07:55PM
Queriy taking long time in OTRS   692 Rajkumar D 05/29/2014 03:53AM
Re: Queriy taking long time in OTRS   258 Rajkumar D 05/29/2014 01:11PM
Re: Queriy taking long time in OTRS   296 Rick James 05/30/2014 10:41AM
Re: Queriy taking long time in OTRS   260 Rajkumar D 05/30/2014 12:45PM
Re: Queriy taking long time in OTRS   293 Øystein Grøvlen 06/02/2014 03:52AM
Query attacks against read-only database   499 joe blake 05/29/2014 09:46PM
Re: Query attacks against read-only database   245 Rick James 05/31/2014 08:04AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 70

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.