Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.24 has been released 08/28/2015 01:07PM
MySQL Connector/NET 6.9.7 has been released 08/05/2015 06:38AM
MySQL Community Server 5.7.8 has been released (part 3/3) 08/03/2015 09:14AM
MySQL Community Server 5.7.8 has been released (part 2/3) 08/03/2015 09:12AM
MySQL Community Server 5.7.8 has been released (part 1/3) 08/03/2015 09:09AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 71
Subject Views Written By Posted
lockfree approach to creating a single unique row without unique index   522 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   261 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   256 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   575 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   257 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   607 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   427 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   727 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   364 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   344 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   296 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   293 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   289 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   243 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   677 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   372 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   300 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   365 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   365 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   666 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   370 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   335 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   321 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   293 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   303 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   308 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   281 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   307 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   837 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   442 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   636 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   271 Rick James 11/28/2014 06:59PM
Cardinality Problem   615 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   262 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   253 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   244 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   811 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   341 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   311 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   352 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   327 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   380 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   334 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   325 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   284 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   309 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   296 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   703 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   362 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   276 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   286 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   287 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   272 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   777 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   367 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   301 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   330 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   311 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   315 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   741 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   313 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   289 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   273 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   279 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   298 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   301 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   265 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   1,526 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   817 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   612 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   539 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   437 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   434 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   354 Ravi Malghan 11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support   767 Christine Ross 10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support   435 Peter Brawley 10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support   400 Christine Ross 10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support   449 Rick James 11/02/2014 09:33AM
GROUP causing Using Temporary Using Filesort   4,527 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   1,948 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   1,671 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   1,402 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   1,051 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   878 Rick James 08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort   789 RT Lee 08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort   819 Rick James 08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort   613 Leonardo Duque 10/30/2014 12:57PM
Leonardo, please do not hijack threads   472 Peter Brawley 10/31/2014 11:15AM
Eliminate filesort in update query   800 Matzz - 09/23/2014 02:48AM
Re: Eliminate filesort in update query   377 Rick James 09/23/2014 09:59PM
Re: Eliminate filesort in update query   362 Matzz - 09/24/2014 01:25AM
Re: Eliminate filesort in update query   356 Rick James 09/24/2014 08:40PM
Re: Eliminate filesort in update query   381 Matzz - 09/25/2014 05:48AM
Re: Eliminate filesort in update query   369 Rick James 09/26/2014 04:39PM
Re: Eliminate filesort in update query   379 Matzz - 10/01/2014 06:49AM
Re: Eliminate filesort in update query   370 Rick James 10/03/2014 10:09PM
Re: Eliminate filesort in update query   383 Matzz - 10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table   638 Jeetu Gaur 09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table   344 Rick James 09/27/2014 08:16AM
Slow response time due queries   1,185 Jens Meier 09/23/2014 01:32AM
Re: Slow response time due queries   470 Rick James 09/23/2014 10:11PM
PHP/MySQL to use all CPU/memory to increase performance   821 Caleb Pitman 09/21/2014 11:04AM
Re: PHP/MySQL to use all CPU/memory to increase performance   431 Rick James 09/22/2014 03:39PM
Re: PHP/MySQL to use all CPU/memory to increase performance   458 Caleb Pitman 09/22/2014 04:55PM
Re: PHP/MySQL to use all CPU/memory to increase performance   372 Rick James 09/23/2014 03:21PM
How to set mysql CPU affinity?   1,097 Metal Messiah 09/21/2014 01:33PM
Re: How to set mysql CPU affinity?   543 Rick James 09/22/2014 03:25PM
Re: How to set mysql CPU affinity?   507 Sophia Parsons 09/23/2014 01:30AM
Re: How to set mysql CPU affinity?   507 Rick James 09/23/2014 11:03AM
Query optimization to reduce execution time.   696 Neetu Nayak 09/22/2014 07:33AM
Re: Query optimization to reduce execution time.   366 Rick James 09/22/2014 08:46PM
Re: Query optimization to reduce execution time.   354 Neetu Nayak 09/23/2014 12:38AM
Re: Query optimization to reduce execution time.   346 Neetu Nayak 09/23/2014 01:42AM
Mass Update optimization   821 Susan Lin 09/14/2014 06:00PM
Re: Mass Update optimization   372 Rick James 09/15/2014 11:38AM
Re: Mass Update optimization   355 Sophia Parsons 09/23/2014 01:36AM
Optimising query with composite index, which says using where   682 Timothy Mifsud 09/06/2014 12:38AM
Re: Optimising query with composite index, which says using where   297 Timothy Mifsud 09/06/2014 01:53AM
Re: Optimising query with composite index, which says using where   281 Rick James 09/07/2014 10:46PM
Re: Optimising query with composite index, which says using where   278 Øystein Grøvlen 09/15/2014 06:03AM
Re: Optimising query with composite index, which says using where   271 Rick James 09/15/2014 10:03AM
Slow Performance with Multi-threaded app   699 Minesh Desai 09/12/2014 09:24AM
Re: Slow Performance with Multi-threaded app   318 Rick James 09/13/2014 09:47AM
InnoDB and locking, UPDATE and SELECT   707 Andreas Greulich 09/10/2014 01:18AM
Re: InnoDB and locking, UPDATE and SELECT   309 Rick James 09/13/2014 12:09AM
MySQL using too much CPU   801 31 Special 08/29/2014 05:12PM
Re: MySQL using too much CPU   363 Rick James 08/30/2014 05:27PM
Re: MySQL using too much CPU   434 31 Special 08/31/2014 10:13PM
Understanding Explain   694 J M 08/27/2014 07:31AM
Re: Understanding Explain   355 Peter Brawley 08/27/2014 10:35AM
Re: Understanding Explain   303 J M 08/27/2014 10:51AM
Re: Understanding Explain   303 Øystein Grøvlen 08/28/2014 03:00PM
Re: Understanding Explain   291 Rick James 08/29/2014 09:45PM
Need help to otimize my query   623 GAURAV JAIN 08/21/2014 07:28AM
Re: Need help to otimize my query   333 Rick James 08/24/2014 09:17PM
Slow response in MY SQL 5.5.1.8   606 Amila Kumara 07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8   336 Rick James 07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8   362 Amila Kumara 07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8   367 Rick James 07/23/2014 12:19AM
Help in tuning MySQL 5.6 database   615 Deepak Dambe 07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database   362 Rick James 07/18/2014 12:12PM
Query slows down over time   845 Sameer Shah 05/28/2014 09:35AM
Re: Query slows down over time   414 Peter Brawley 05/28/2014 12:45PM
Re: Query slows down over time   377 Sameer Shah 05/28/2014 01:24PM
Re: Query slows down over time   425 Rick James 05/28/2014 04:57PM
Re: Query slows down over time   445 Sameer Shah 05/28/2014 05:46PM
Re: Query slows down over time   420 Rick James 05/28/2014 07:23PM
Re: Query slows down over time   699 Sam Shah 05/29/2014 05:38AM
Re: Query slows down over time   425 Rick James 05/29/2014 09:49AM
Re: Query slows down over time   460 Sam Shah 05/29/2014 03:12PM
Re: Query slows down over time   371 Sam Shah 07/15/2014 12:10PM
Re: Query slows down over time   375 Peter Brawley 07/15/2014 12:33PM
Re: Query slows down over time   313 Rick James 07/16/2014 11:19AM
Performance problem with outer join   692 RT Lee 07/11/2014 07:53AM
Re: Performance problem with outer join   349 Peter Brawley 07/11/2014 09:26AM
Re: Performance problem with outer join   346 Rick James 07/11/2014 04:26PM
Re: Performance problem with outer join   327 RT Lee 07/13/2014 12:29PM
Where to look for server freezes   610 Michael Muratet 07/10/2014 10:08AM
Re: Where to look for server freezes   275 Rick James 07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order   853 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   432 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   568 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   421 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   451 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   1,688 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   476 Rick James 06/26/2014 06:19PM
MySQL hangs due to large delete   719 Akshay Viswanathan 06/25/2014 08:51AM
Re: MySQL hangs due to large delete   333 Rick James 06/26/2014 06:13PM
Superkey vs Primary Key   1,059 Mario Schill 06/16/2014 04:13AM
Re: Superkey vs Primary Key   456 Peter Brawley 06/16/2014 10:42AM
Re: Superkey vs Primary Key   375 Mario Schill 06/17/2014 12:57AM
Re: Superkey vs Primary Key   397 Peter Brawley 06/17/2014 03:42AM
DML operations slow down   646 Sivaprakash Gopal 06/04/2014 04:43PM
Re: DML operations slow down   359 Rick James 06/06/2014 09:18AM
how to configure my.cnf for mysql 5.1, using too much cpu?   883 Aamir Sohail 06/05/2014 06:15AM
Re: how to configure my.cnf for mysql 5.1, using too much cpu?   396 Rick James 06/06/2014 09:09AM
'Compound' INDEXes   775 lee fei 06/04/2014 03:24AM
Re: 'Compound' INDEXes   370 Rick James 06/05/2014 09:12PM
Delete slow... randomly   819 Francesco De Carlo 06/02/2014 09:15AM
Re: Delete slow... randomly   361 Rick James 06/03/2014 09:51AM
Re: Delete slow... randomly   359 Francesco De Carlo 06/04/2014 03:43AM
Re: Delete slow... randomly   352 Rick James 06/05/2014 08:01PM
concurrent_insert   657 Ben Zhou 06/01/2014 08:15AM
Re: concurrent_insert   344 Rick James 06/02/2014 11:53AM
Re: concurrent_insert   327 Ben Zhou 06/04/2014 08:37AM
Re: concurrent_insert   359 Rick James 06/05/2014 07:55PM
Queriy taking long time in OTRS   948 Rajkumar D 05/29/2014 03:53AM
Re: Queriy taking long time in OTRS   337 Rajkumar D 05/29/2014 01:11PM
Re: Queriy taking long time in OTRS   484 Rick James 05/30/2014 10:41AM
Re: Queriy taking long time in OTRS   341 Rajkumar D 05/30/2014 12:45PM
Re: Queriy taking long time in OTRS   441 Øystein Grøvlen 06/02/2014 03:52AM
Query attacks against read-only database   619 joe blake 05/29/2014 09:46PM
Re: Query attacks against read-only database   313 Rick James 05/31/2014 08:04AM
my.cnf file with mysql tuner   1,137 maurizio ca 05/26/2014 03:03AM
Re: my.cnf file with mysql tuner   663 Rick James 05/26/2014 07:29PM
Out of memory - on any moderate query   669 rol and 05/23/2014 12:58PM
Re: Out of memory - on any moderate query   319 Peter Brawley 05/23/2014 10:59PM
Re: Out of memory - on any moderate query   346 Rick James 05/24/2014 03:18PM
Low priority SELECT   989 Glas Host 05/21/2014 07:18AM
Re: Low priority SELECT   491 Rick James 05/24/2014 03:05PM
Performance improvement with my.cnf configs   810 Manohar K 04/23/2014 10:23AM
Re: Performance improvement with my.cnf configs   345 Rick James 04/24/2014 08:08PM
Re: Performance improvement with my.cnf configs   357 Manohar K 04/24/2014 09:41PM
Re: Performance improvement with my.cnf configs   397 Rick James 04/25/2014 08:24PM
Re: Performance improvement with my.cnf configs   325 Manohar K 05/06/2014 10:22AM
Adding index kills query   819 Robert Stafford 04/23/2014 06:10PM
Re: Adding index kills query   401 Robert Stafford 04/23/2014 06:14PM
Re: Adding index kills query   412 Øystein Grøvlen 04/24/2014 02:44AM
Re: Adding index kills query   406 Robert Stafford 04/24/2014 09:07AM
Re: Adding index kills query   387 Øystein Grøvlen 04/25/2014 07:39AM
Re: Adding index kills query   415 Robert Stafford 04/25/2014 11:54AM
Re: Adding index kills query   427 Rick James 04/25/2014 02:25PM
Re: Adding index kills query   380 Øystein Grøvlen 04/28/2014 06:06AM
Re: Adding index kills query   372 Peter Brawley 04/24/2014 09:37AM
Re: Adding index kills query   370 Robert Stafford 04/24/2014 06:31PM
Re: Adding index kills query   417 Peter Brawley 04/24/2014 07:10PM
Re: Adding index kills query   341 Robert Stafford 04/24/2014 07:19PM
Re: Adding index kills query   387 Rick James 04/25/2014 10:55AM
Re: Adding index kills query   352 Øystein Grøvlen 04/25/2014 11:02PM
Re: Adding index kills query   394 Robert Stafford 04/27/2014 07:53PM
Re: Adding index kills query   389 Peter Brawley 04/27/2014 08:50PM
Re: Adding index kills query   374 Rick James 04/27/2014 09:00PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 71

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.