MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Backup 4.0.1 has been released 05/26/2016 11:16AM
MySQL Enterprise Monitor 3.1.4 has been released 05/26/2016 11:04AM
MySQL Connector/J 5.1.39 has been released 05/09/2016 02:23PM
MySQL Enterprise Backup 3.12.3 has been released 05/09/2016 11:30AM
MySQL Enterprise Monitor 3.2.1 has been released 05/03/2016 01:09PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 of 72
Subject Views Written By Posted
Slow COUNT + GROUP BY   829 Refael Dakar 03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY   354 Jeremy Smyth 03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY   374 Refael Dakar 03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY   329 Rick James 03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY   329 Refael Dakar 03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY   348 Øystein Grøvlen 03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY   343 Matan K 03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY   372 Øystein Grøvlen 03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY   324 Matan K 03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY   347 Øystein Grøvlen 03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY   317 Matan K 03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY   354 Øystein Grøvlen 03/24/2015 03:37AM
Query Optimization Needed   802 Devrishi Shandilya 02/11/2015 01:31AM
Re: Query Optimization Needed   379 Peter Brawley 02/11/2015 12:42PM
Re: Query Optimization Needed   407 Devrishi Shandilya 02/12/2015 03:51AM
Re: Query Optimization Needed   364 Peter Brawley 02/12/2015 01:24PM
Re: Query Optimization Needed   408 Devrishi Shandilya 02/13/2015 06:53AM
Re: Query Optimization Needed   357 Peter Brawley 02/13/2015 07:36AM
Re: Query Optimization Needed   357 Rick James 02/14/2015 01:04AM
Re: Query Optimization Needed   362 Devrishi Shandilya 02/15/2015 11:07PM
Re: Query Optimization Needed   336 Rick James 02/16/2015 12:15AM
Re: Query Optimization Needed   308 Peter Brawley 03/13/2015 11:15AM
Exceedingly slow create table performance   845 Ronald Van Iwaarden 03/06/2015 10:51AM
Re: Exceedingly slow create table performance   353 Rick James 03/07/2015 11:03AM
Re: Exceedingly slow create table performance   335 Ronald Van Iwaarden 03/09/2015 10:10AM
Left join optimization- query is very slow   1,126 Devrishi Shandilya 03/05/2015 05:23AM
Re: Left join optimization- query is very slow   443 Øystein Grøvlen 03/05/2015 09:12AM
Re: Left join optimization- query is very slow   656 Rick James 03/06/2015 06:48PM
Re: Left join optimization- query is very slow   417 Devrishi Shandilya 03/08/2015 11:32PM
COUNT with GROUP BY, JOIN and SUBQUERY very slow   1,039 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   431 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   357 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   456 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   379 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   382 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   336 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   369 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   674 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   339 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   344 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   712 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   333 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   721 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   300 Rick James 02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   890 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   373 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   838 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   381 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   369 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   398 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   322 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   759 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   448 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   376 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   492 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   1,144 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   530 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   461 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   595 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   492 Rick James 01/13/2015 04:21PM
How To Use More Resources   844 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   385 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   449 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   466 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   362 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   354 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   428 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   683 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   338 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   419 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   847 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   350 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   335 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   775 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   430 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   811 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   725 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   943 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   479 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   429 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   390 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   368 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   370 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   359 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   859 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   547 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   407 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   548 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   470 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   949 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   478 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   437 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   414 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   377 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   459 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   413 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   394 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   392 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   1,220 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   649 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   839 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   356 Rick James 11/28/2014 06:59PM
Cardinality Problem   738 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   330 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   335 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   322 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   1,039 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   432 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   436 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   444 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   441 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   457 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   395 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   409 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   364 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   390 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   376 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   894 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   454 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   397 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   374 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   423 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   378 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   1,164 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   460 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   428 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   459 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   470 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   424 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   1,002 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   402 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   360 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   365 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   395 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   376 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   429 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   333 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   2,475 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   1,267 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   932 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   805 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   678 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   632 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   503 Ravi Malghan 11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support   1,017 Christine Ross 10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support   537 Peter Brawley 10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support   493 Christine Ross 10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support   623 Rick James 11/02/2014 09:33AM
GROUP causing Using Temporary Using Filesort   7,691 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   2,979 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   2,497 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   2,172 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   1,558 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   1,286 Rick James 08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort   1,224 RT Lee 08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort   1,286 Rick James 08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort   866 Leonardo Duque 10/30/2014 12:57PM
Leonardo, please do not hijack threads   636 Peter Brawley 10/31/2014 11:15AM
Eliminate filesort in update query   1,128 Matzz - 09/23/2014 02:48AM
Re: Eliminate filesort in update query   463 Rick James 09/23/2014 09:59PM
Re: Eliminate filesort in update query   427 Matzz - 09/24/2014 01:25AM
Re: Eliminate filesort in update query   448 Rick James 09/24/2014 08:40PM
Re: Eliminate filesort in update query   482 Matzz - 09/25/2014 05:48AM
Re: Eliminate filesort in update query   458 Rick James 09/26/2014 04:39PM
Re: Eliminate filesort in update query   473 Matzz - 10/01/2014 06:49AM
Re: Eliminate filesort in update query   453 Rick James 10/03/2014 10:09PM
Re: Eliminate filesort in update query   497 Matzz - 10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table   885 Jeetu Gaur 09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table   468 Rick James 09/27/2014 08:16AM
Slow response time due queries   1,825 Jens Meier 09/23/2014 01:32AM
Re: Slow response time due queries   731 Rick James 09/23/2014 10:11PM
PHP/MySQL to use all CPU/memory to increase performance   1,173 Caleb Pitman 09/21/2014 11:04AM
Re: PHP/MySQL to use all CPU/memory to increase performance   555 Rick James 09/22/2014 03:39PM
Re: PHP/MySQL to use all CPU/memory to increase performance   610 Caleb Pitman 09/22/2014 04:55PM
Re: PHP/MySQL to use all CPU/memory to increase performance   462 Rick James 09/23/2014 03:21PM
How to set mysql CPU affinity?   1,614 Metal Messiah 09/21/2014 01:33PM
Re: How to set mysql CPU affinity?   776 Rick James 09/22/2014 03:25PM
Re: How to set mysql CPU affinity?   726 Sophia Parsons 09/23/2014 01:30AM
Re: How to set mysql CPU affinity?   695 Rick James 09/23/2014 11:03AM
Query optimization to reduce execution time.   940 Neetu Nayak 09/22/2014 07:33AM
Re: Query optimization to reduce execution time.   458 Rick James 09/22/2014 08:46PM
Re: Query optimization to reduce execution time.   413 Neetu Nayak 09/23/2014 12:38AM
Re: Query optimization to reduce execution time.   455 Neetu Nayak 09/23/2014 01:42AM
Mass Update optimization   1,216 Susan Lin 09/14/2014 06:00PM
Re: Mass Update optimization   517 Rick James 09/15/2014 11:38AM
Re: Mass Update optimization   451 Sophia Parsons 09/23/2014 01:36AM
Optimising query with composite index, which says using where   943 Timothy Mifsud 09/06/2014 12:38AM
Re: Optimising query with composite index, which says using where   393 Timothy Mifsud 09/06/2014 01:53AM
Re: Optimising query with composite index, which says using where   349 Rick James 09/07/2014 10:46PM
Re: Optimising query with composite index, which says using where   387 Øystein Grøvlen 09/15/2014 06:03AM
Re: Optimising query with composite index, which says using where   324 Rick James 09/15/2014 10:03AM
Slow Performance with Multi-threaded app   923 Minesh Desai 09/12/2014 09:24AM
Re: Slow Performance with Multi-threaded app   395 Rick James 09/13/2014 09:47AM
InnoDB and locking, UPDATE and SELECT   956 Andreas Greulich 09/10/2014 01:18AM
Re: InnoDB and locking, UPDATE and SELECT   394 Rick James 09/13/2014 12:09AM
MySQL using too much CPU   1,165 31 Special 08/29/2014 05:12PM
Re: MySQL using too much CPU   483 Rick James 08/30/2014 05:27PM
Re: MySQL using too much CPU   573 31 Special 08/31/2014 10:13PM
Understanding Explain   949 J M 08/27/2014 07:31AM
Re: Understanding Explain   429 Peter Brawley 08/27/2014 10:35AM
Re: Understanding Explain   417 J M 08/27/2014 10:51AM
Re: Understanding Explain   437 Øystein Grøvlen 08/28/2014 03:00PM
Re: Understanding Explain   355 Rick James 08/29/2014 09:45PM
Need help to otimize my query   852 GAURAV JAIN 08/21/2014 07:28AM
Re: Need help to otimize my query   403 Rick James 08/24/2014 09:17PM
Slow response in MY SQL 5.5.1.8   795 Amila Kumara 07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8   446 Rick James 07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8   475 Amila Kumara 07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8   438 Rick James 07/23/2014 12:19AM
Help in tuning MySQL 5.6 database   836 Deepak Dambe 07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database   443 Rick James 07/18/2014 12:12PM
Query slows down over time   1,203 Sameer Shah 05/28/2014 09:35AM
Re: Query slows down over time   550 Peter Brawley 05/28/2014 12:45PM
Re: Query slows down over time   497 Sameer Shah 05/28/2014 01:24PM
Re: Query slows down over time   517 Rick James 05/28/2014 04:57PM
Re: Query slows down over time   554 Sameer Shah 05/28/2014 05:46PM
Re: Query slows down over time   525 Rick James 05/28/2014 07:23PM
Re: Query slows down over time   1,117 Sam Shah 05/29/2014 05:38AM
Re: Query slows down over time   591 Rick James 05/29/2014 09:49AM
Re: Query slows down over time   584 Sam Shah 05/29/2014 03:12PM
Re: Query slows down over time   584 Sam Shah 07/15/2014 12:10PM
Re: Query slows down over time   505 Peter Brawley 07/15/2014 12:33PM
Re: Query slows down over time   454 Rick James 07/16/2014 11:19AM
Performance problem with outer join   914 RT Lee 07/11/2014 07:53AM
Re: Performance problem with outer join   418 Peter Brawley 07/11/2014 09:26AM
Re: Performance problem with outer join   405 Rick James 07/11/2014 04:26PM
Re: Performance problem with outer join   418 RT Lee 07/13/2014 12:29PM
Where to look for server freezes   806 Michael Muratet 07/10/2014 10:08AM
Re: Where to look for server freezes   369 Rick James 07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order   1,112 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   545 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   753 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   531 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   534 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   2,410 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   622 Rick James 06/26/2014 06:19PM
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.