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:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 of 72
Subject Views Written By Posted
heavy read workload with high cpu usage   816 kim alex 05/28/2015 04:37AM
Re: heavy read workload with high cpu usage   322 Rick James 06/04/2015 08:35AM
query performance on partitioning table   756 sixin yang 05/12/2015 09:00AM
Re: query performance on partitioning table   341 Rick James 05/16/2015 11:49PM
Re: query performance on partitioning table   335 sixin yang 05/18/2015 08:30AM
Re: query performance on partitioning table   315 Rick James 06/04/2015 08:22AM
Avoid subquery   809 Wolfgang Jacques 05/12/2015 08:40AM
Re: Avoid subquery   340 Peter Brawley 05/12/2015 11:06AM
Re: Avoid subquery   328 Wolfgang Jacques 05/12/2015 01:29PM
Re: Avoid subquery   327 Peter Brawley 05/12/2015 01:41PM
Re: Avoid subquery   338 Rick James 05/17/2015 12:11AM
MYSQL Table Optimization   672 Yudhveer Kandukuri 05/13/2015 09:53PM
Re: MYSQL Table Optimization   306 Rick James 05/15/2015 11:02AM
Slow query   826 Manu Swami 04/21/2015 11:15AM
Re: Slow query   305 Maulik Parekh 04/22/2015 07:17AM
Re: Slow query   337 Rick James 04/22/2015 07:05PM
Re: Slow query   378 Manu Swami 04/23/2015 11:42PM
Re: Slow query   329 Manu Swami 04/23/2015 11:55PM
Re: Slow query   308 Rick James 04/24/2015 05:22PM
Re: Slow query   329 Manu Swami 04/25/2015 02:31AM
Re: Slow query   336 Manu Swami 04/25/2015 02:41AM
Re: Slow query   415 Manu Swami 04/25/2015 05:22AM
Re: Slow query   340 Rick James 04/25/2015 10:42PM
Re: Slow query   280 Øystein Grøvlen 05/13/2015 03:30AM
Re: Slow query   293 Manu Swami 04/28/2015 03:40AM
CPU usage extremely high   1,032 Temu Kinn 04/28/2015 08:55AM
Re: CPU usage extremely high   502 Temu Kinn 04/28/2015 09:03AM
Re: CPU usage extremely high   416 Rick James 04/29/2015 05:43PM
Re: CPU usage extremely high   440 Temu Kinn 05/09/2015 07:22AM
Re: CPU usage extremely high   381 Temu Kinn 05/09/2015 07:38AM
Re: CPU usage extremely high   387 Rick James 05/11/2015 06:30PM
Mysql indexes weird behavior   636 Nikhil Khekade 05/02/2015 02:17AM
Re: Mysql indexes weird behavior   269 Rick James 05/03/2015 06:21PM
slow query sorting result - sending data   1,094 Hugo Rodriguez 04/28/2015 07:27PM
Re: slow query sorting result - sending data   392 Peter Brawley 04/28/2015 10:38PM
Re: slow query sorting result - sending data   389 Rick James 05/01/2015 10:08PM
PROFILING   809 Khurram Naseem 04/27/2015 04:26AM
Re: PROFILING   338 Rick James 04/29/2015 06:53PM
Query time difference   1,005 Ofer Bechar 04/26/2015 07:28AM
Re: Query time difference   310 Rick James 04/27/2015 02:39PM
Re: Query time difference   323 Ofer Bechar 04/27/2015 11:29PM
Re: Query time difference   291 Rick James 04/29/2015 05:50PM
Performance issues with INNODB vs MyISAM   1,324 Milovan Krivokapic 04/17/2015 01:20PM
Re: Performance issues with INNODB vs MyISAM   572 Rick James 04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM   423 Milovan Krivokapic 04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM   357 Rick James 04/28/2015 10:34AM
Why mysqlslap doesn't return the correct Benchmark time?   705 Cai Vincent 04/20/2015 08:07AM
Writing at 847 MB/sec ???   749 Robert Gunther 04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???   365 Rick James 04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???   389 Robert Gunther 04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???   356 Rick James 04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???   378 Robert Gunther 04/20/2015 01:00AM
Mysql is consuming xtremely high CPU above 1000%   902 Eric Leung 04/11/2015 04:38PM
Re: Mysql is consuming xtremely high CPU above 1000%   509 Eric Leung 04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%   418 Rick James 04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%   385 Eric Leung 04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%   411 Rick James 04/17/2015 08:05PM
Re: Mysql is consuming xtremely high CPU above 1000%   496 Eric Leung 04/18/2015 06:07AM
Re: Mysql is consuming xtremely high CPU above 1000%   495 Rick James 04/19/2015 02:19PM
Client to server connection   656 Dan Toškan 04/14/2015 12:40PM
Re: Client to server connection   291 Peter Brawley 04/14/2015 11:18PM
Re: Client to server connection   262 Rick James 04/17/2015 08:09PM
This topic has been moved.:  Mysql NDB Cluster   36 SRINIVASA RAO PUJARI 04/01/2015 11:23PM
Fast way to have an inparameter match all values? (COALESCE slow)   772 Ola Arwidsson 03/26/2015 06:40AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   337 Peter Brawley 03/26/2015 10:45AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   353 Ola Arwidsson 03/30/2015 01:22AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   381 Ola Arwidsson 03/30/2015 03:27AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   351 Peter Brawley 03/30/2015 11:16AM
system table space vs file per table space   672 jongse park 03/27/2015 12:35AM
Re: system table space vs file per table space   349 Rick James 03/28/2015 03:36PM
Slow COUNT + GROUP BY   884 Refael Dakar 03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY   381 Jeremy Smyth 03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY   391 Refael Dakar 03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY   339 Rick James 03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY   344 Refael Dakar 03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY   371 Øystein Grøvlen 03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY   373 Matan K 03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY   390 Øystein Grøvlen 03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY   337 Matan K 03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY   380 Øystein Grøvlen 03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY   339 Matan K 03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY   385 Øystein Grøvlen 03/24/2015 03:37AM
Query Optimization Needed   851 Devrishi Shandilya 02/11/2015 01:31AM
Re: Query Optimization Needed   391 Peter Brawley 02/11/2015 12:42PM
Re: Query Optimization Needed   431 Devrishi Shandilya 02/12/2015 03:51AM
Re: Query Optimization Needed   394 Peter Brawley 02/12/2015 01:24PM
Re: Query Optimization Needed   423 Devrishi Shandilya 02/13/2015 06:53AM
Re: Query Optimization Needed   371 Peter Brawley 02/13/2015 07:36AM
Re: Query Optimization Needed   374 Rick James 02/14/2015 01:04AM
Re: Query Optimization Needed   385 Devrishi Shandilya 02/15/2015 11:07PM
Re: Query Optimization Needed   372 Rick James 02/16/2015 12:15AM
Re: Query Optimization Needed   322 Peter Brawley 03/13/2015 11:15AM
Exceedingly slow create table performance   919 Ronald Van Iwaarden 03/06/2015 10:51AM
Re: Exceedingly slow create table performance   376 Rick James 03/07/2015 11:03AM
Re: Exceedingly slow create table performance   365 Ronald Van Iwaarden 03/09/2015 10:10AM
Left join optimization- query is very slow   1,232 Devrishi Shandilya 03/05/2015 05:23AM
Re: Left join optimization- query is very slow   480 Øystein Grøvlen 03/05/2015 09:12AM
Re: Left join optimization- query is very slow   720 Rick James 03/06/2015 06:48PM
Re: Left join optimization- query is very slow   439 Devrishi Shandilya 03/08/2015 11:32PM
COUNT with GROUP BY, JOIN and SUBQUERY very slow   1,143 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   481 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   377 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   511 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   394 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   419 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   358 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   397 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   724 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   377 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   365 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   750 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   370 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   763 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   311 Rick James 02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   977 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   394 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   904 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   410 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   419 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   454 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   356 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   828 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   486 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   410 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   564 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   1,242 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   580 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   495 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   639 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   533 Rick James 01/13/2015 04:21PM
How To Use More Resources   920 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   418 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   501 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   510 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   378 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   374 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   444 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   733 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   366 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   452 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   894 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   368 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   358 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   818 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   467 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   890 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   837 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   1,014 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   506 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   446 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   417 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   384 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   405 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   381 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   918 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   596 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   427 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   587 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   505 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   1,037 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   503 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   478 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   440 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   398 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   495 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   441 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   432 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   418 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   1,336 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   698 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   891 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   381 Rick James 11/28/2014 06:59PM
Cardinality Problem   767 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   343 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   349 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   336 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   1,091 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   449 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   462 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   459 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   471 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   475 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   411 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   438 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   375 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   405 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   401 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   935 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   473 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   417 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   413 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   444 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   404 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   1,290 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   506 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   468 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   492 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   514 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   463 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   1,058 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   420 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   377 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   378 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   414 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   389 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   443 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   348 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   2,763 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   1,412 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   1,012 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   864 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   746 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   697 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   536 Ravi Malghan 11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support   1,088 Christine Ross 10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support   565 Peter Brawley 10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support   521 Christine Ross 10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support   667 Rick James 11/02/2014 09:33AM
GROUP causing Using Temporary Using Filesort   8,498 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   3,198 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   2,673 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   2,335 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   1,677 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   1,412 Rick James 08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort   1,331 RT Lee 08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort   1,405 Rick James 08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort   931 Leonardo Duque 10/30/2014 12:57PM
Leonardo, please do not hijack threads   683 Peter Brawley 10/31/2014 11:15AM
Eliminate filesort in update query   1,237 Matzz - 09/23/2014 02:48AM
Re: Eliminate filesort in update query   498 Rick James 09/23/2014 09:59PM
Re: Eliminate filesort in update query   451 Matzz - 09/24/2014 01:25AM
Re: Eliminate filesort in update query   478 Rick James 09/24/2014 08:40PM
Re: Eliminate filesort in update query   507 Matzz - 09/25/2014 05:48AM
Re: Eliminate filesort in update query   482 Rick James 09/26/2014 04:39PM
Re: Eliminate filesort in update query   496 Matzz - 10/01/2014 06:49AM
Re: Eliminate filesort in update query   477 Rick James 10/03/2014 10:09PM
Re: Eliminate filesort in update query   544 Matzz - 10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table   948 Jeetu Gaur 09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table   494 Rick James 09/27/2014 08:16AM
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.