MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.2.1 has been released 05/03/2016 01:09PM
Announcing: MySQL Enterprise Transparent Data Encryption (TDE) 04/21/2016 03:33PM
MySQL Cluster 7.4.11 has been released 04/20/2016 09:34AM
MySQL Cluster 7.2.24 has been released 04/20/2016 06:30AM
MySQL Cluster 7.3.13 has been released 04/19/2016 11:56PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 of 72
Subject Views Written By Posted
COUNT with GROUP BY, JOIN and SUBQUERY very slow   1,014 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   413 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   350 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   432 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   366 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   362 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   325 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   356 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   653 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   326 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   329 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   693 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   321 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   702 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   292 Rick James 02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   866 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   362 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   816 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   367 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   359 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   383 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   315 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   731 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   431 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   356 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   471 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   1,113 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   504 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   446 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   582 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   473 Rick James 01/13/2015 04:21PM
How To Use More Resources   823 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   377 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   436 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   446 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   351 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   346 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   417 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   666 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   330 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   407 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   824 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   340 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   326 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   753 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   417 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   794 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   703 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   922 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   466 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   416 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   380 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   362 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   355 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   340 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   842 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   534 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   396 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   529 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   461 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   923 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   468 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   426 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   407 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   361 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   439 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   403 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   385 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   381 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   1,178 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   633 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   823 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   343 Rick James 11/28/2014 06:59PM
Cardinality Problem   720 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   326 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   324 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   313 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   1,023 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   422 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   419 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   434 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   428 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   445 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   387 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   399 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   356 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   385 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   368 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   872 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   448 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   385 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   361 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   404 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   367 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   1,127 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   449 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   416 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   444 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   456 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   412 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   981 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   392 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   350 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   353 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   384 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   369 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   415 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   327 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   2,400 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   1,229 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   908 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   783 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   653 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   613 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   492 Ravi Malghan 11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support   1,003 Christine Ross 10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support   524 Peter Brawley 10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support   483 Christine Ross 10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support   607 Rick James 11/02/2014 09:33AM
GROUP causing Using Temporary Using Filesort   7,434 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   2,914 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   2,434 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   2,118 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   1,532 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   1,252 Rick James 08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort   1,194 RT Lee 08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort   1,253 Rick James 08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort   846 Leonardo Duque 10/30/2014 12:57PM
Leonardo, please do not hijack threads   623 Peter Brawley 10/31/2014 11:15AM
Eliminate filesort in update query   1,092 Matzz - 09/23/2014 02:48AM
Re: Eliminate filesort in update query   453 Rick James 09/23/2014 09:59PM
Re: Eliminate filesort in update query   419 Matzz - 09/24/2014 01:25AM
Re: Eliminate filesort in update query   439 Rick James 09/24/2014 08:40PM
Re: Eliminate filesort in update query   472 Matzz - 09/25/2014 05:48AM
Re: Eliminate filesort in update query   452 Rick James 09/26/2014 04:39PM
Re: Eliminate filesort in update query   466 Matzz - 10/01/2014 06:49AM
Re: Eliminate filesort in update query   448 Rick James 10/03/2014 10:09PM
Re: Eliminate filesort in update query   490 Matzz - 10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table   859 Jeetu Gaur 09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table   456 Rick James 09/27/2014 08:16AM
Slow response time due queries   1,767 Jens Meier 09/23/2014 01:32AM
Re: Slow response time due queries   701 Rick James 09/23/2014 10:11PM
PHP/MySQL to use all CPU/memory to increase performance   1,150 Caleb Pitman 09/21/2014 11:04AM
Re: PHP/MySQL to use all CPU/memory to increase performance   548 Rick James 09/22/2014 03:39PM
Re: PHP/MySQL to use all CPU/memory to increase performance   601 Caleb Pitman 09/22/2014 04:55PM
Re: PHP/MySQL to use all CPU/memory to increase performance   453 Rick James 09/23/2014 03:21PM
How to set mysql CPU affinity?   1,568 Metal Messiah 09/21/2014 01:33PM
Re: How to set mysql CPU affinity?   755 Rick James 09/22/2014 03:25PM
Re: How to set mysql CPU affinity?   703 Sophia Parsons 09/23/2014 01:30AM
Re: How to set mysql CPU affinity?   673 Rick James 09/23/2014 11:03AM
Query optimization to reduce execution time.   917 Neetu Nayak 09/22/2014 07:33AM
Re: Query optimization to reduce execution time.   451 Rick James 09/22/2014 08:46PM
Re: Query optimization to reduce execution time.   404 Neetu Nayak 09/23/2014 12:38AM
Re: Query optimization to reduce execution time.   442 Neetu Nayak 09/23/2014 01:42AM
Mass Update optimization   1,181 Susan Lin 09/14/2014 06:00PM
Re: Mass Update optimization   507 Rick James 09/15/2014 11:38AM
Re: Mass Update optimization   435 Sophia Parsons 09/23/2014 01:36AM
Optimising query with composite index, which says using where   922 Timothy Mifsud 09/06/2014 12:38AM
Re: Optimising query with composite index, which says using where   383 Timothy Mifsud 09/06/2014 01:53AM
Re: Optimising query with composite index, which says using where   340 Rick James 09/07/2014 10:46PM
Re: Optimising query with composite index, which says using where   372 Øystein Grøvlen 09/15/2014 06:03AM
Re: Optimising query with composite index, which says using where   317 Rick James 09/15/2014 10:03AM
Slow Performance with Multi-threaded app   901 Minesh Desai 09/12/2014 09:24AM
Re: Slow Performance with Multi-threaded app   386 Rick James 09/13/2014 09:47AM
InnoDB and locking, UPDATE and SELECT   933 Andreas Greulich 09/10/2014 01:18AM
Re: InnoDB and locking, UPDATE and SELECT   387 Rick James 09/13/2014 12:09AM
MySQL using too much CPU   1,132 31 Special 08/29/2014 05:12PM
Re: MySQL using too much CPU   469 Rick James 08/30/2014 05:27PM
Re: MySQL using too much CPU   556 31 Special 08/31/2014 10:13PM
Understanding Explain   925 J M 08/27/2014 07:31AM
Re: Understanding Explain   422 Peter Brawley 08/27/2014 10:35AM
Re: Understanding Explain   409 J M 08/27/2014 10:51AM
Re: Understanding Explain   424 Øystein Grøvlen 08/28/2014 03:00PM
Re: Understanding Explain   346 Rick James 08/29/2014 09:45PM
Need help to otimize my query   831 GAURAV JAIN 08/21/2014 07:28AM
Re: Need help to otimize my query   393 Rick James 08/24/2014 09:17PM
Slow response in MY SQL 5.5.1.8   777 Amila Kumara 07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8   434 Rick James 07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8   462 Amila Kumara 07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8   431 Rick James 07/23/2014 12:19AM
Help in tuning MySQL 5.6 database   814 Deepak Dambe 07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database   437 Rick James 07/18/2014 12:12PM
Query slows down over time   1,170 Sameer Shah 05/28/2014 09:35AM
Re: Query slows down over time   530 Peter Brawley 05/28/2014 12:45PM
Re: Query slows down over time   491 Sameer Shah 05/28/2014 01:24PM
Re: Query slows down over time   507 Rick James 05/28/2014 04:57PM
Re: Query slows down over time   540 Sameer Shah 05/28/2014 05:46PM
Re: Query slows down over time   515 Rick James 05/28/2014 07:23PM
Re: Query slows down over time   1,078 Sam Shah 05/29/2014 05:38AM
Re: Query slows down over time   569 Rick James 05/29/2014 09:49AM
Re: Query slows down over time   571 Sam Shah 05/29/2014 03:12PM
Re: Query slows down over time   559 Sam Shah 07/15/2014 12:10PM
Re: Query slows down over time   493 Peter Brawley 07/15/2014 12:33PM
Re: Query slows down over time   444 Rick James 07/16/2014 11:19AM
Performance problem with outer join   893 RT Lee 07/11/2014 07:53AM
Re: Performance problem with outer join   410 Peter Brawley 07/11/2014 09:26AM
Re: Performance problem with outer join   398 Rick James 07/11/2014 04:26PM
Re: Performance problem with outer join   405 RT Lee 07/13/2014 12:29PM
Where to look for server freezes   778 Michael Muratet 07/10/2014 10:08AM
Re: Where to look for server freezes   359 Rick James 07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order   1,094 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   534 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   733 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   521 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   524 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   2,355 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   607 Rick James 06/26/2014 06:19PM
MySQL hangs due to large delete   984 Akshay Viswanathan 06/25/2014 08:51AM
Re: MySQL hangs due to large delete   413 Rick James 06/26/2014 06:13PM
Superkey vs Primary Key   1,500 Mario Schill 06/16/2014 04:13AM
Re: Superkey vs Primary Key   596 Peter Brawley 06/16/2014 10:42AM
Re: Superkey vs Primary Key   438 Mario Schill 06/17/2014 12:57AM
Re: Superkey vs Primary Key   461 Peter Brawley 06/17/2014 03:42AM
DML operations slow down   863 Sivaprakash Gopal 06/04/2014 04:43PM
Re: DML operations slow down   455 Rick James 06/06/2014 09:18AM
how to configure my.cnf for mysql 5.1, using too much cpu?   1,238 Aamir Sohail 06/05/2014 06:15AM
Re: how to configure my.cnf for mysql 5.1, using too much cpu?   553 Rick James 06/06/2014 09:09AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 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.