MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.2.4 has been released 07/22/2016 12:36PM
MySQL Cluster 7.2.25 has been released 07/18/2016 08:38AM
MySQL Cluster 7.4.12 has been released 07/18/2016 05:35AM
MySQL Cluster 7.3.14 has been released 07/18/2016 04:29AM
MySQL Connector/Python 2.2.0 m1 Development Release has been released 07/12/2016 10:30AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 of 72
Subject Views Written By Posted
slow query sorting result - sending data   1,040 Hugo Rodriguez 04/28/2015 07:27PM
Re: slow query sorting result - sending data   380 Peter Brawley 04/28/2015 10:38PM
Re: slow query sorting result - sending data   375 Rick James 05/01/2015 10:08PM
PROFILING   783 Khurram Naseem 04/27/2015 04:26AM
Re: PROFILING   326 Rick James 04/29/2015 06:53PM
Query time difference   991 Ofer Bechar 04/26/2015 07:28AM
Re: Query time difference   301 Rick James 04/27/2015 02:39PM
Re: Query time difference   313 Ofer Bechar 04/27/2015 11:29PM
Re: Query time difference   285 Rick James 04/29/2015 05:50PM
Performance issues with INNODB vs MyISAM   1,286 Milovan Krivokapic 04/17/2015 01:20PM
Re: Performance issues with INNODB vs MyISAM   561 Rick James 04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM   411 Milovan Krivokapic 04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM   349 Rick James 04/28/2015 10:34AM
Why mysqlslap doesn't return the correct Benchmark time?   685 Cai Vincent 04/20/2015 08:07AM
Writing at 847 MB/sec ???   731 Robert Gunther 04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???   353 Rick James 04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???   375 Robert Gunther 04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???   343 Rick James 04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???   365 Robert Gunther 04/20/2015 01:00AM
Mysql is consuming xtremely high CPU above 1000%   866 Eric Leung 04/11/2015 04:38PM
Re: Mysql is consuming xtremely high CPU above 1000%   487 Eric Leung 04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%   407 Rick James 04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%   371 Eric Leung 04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%   400 Rick James 04/17/2015 08:05PM
Re: Mysql is consuming xtremely high CPU above 1000%   481 Eric Leung 04/18/2015 06:07AM
Re: Mysql is consuming xtremely high CPU above 1000%   481 Rick James 04/19/2015 02:19PM
Client to server connection   642 Dan Toškan 04/14/2015 12:40PM
Re: Client to server connection   287 Peter Brawley 04/14/2015 11:18PM
Re: Client to server connection   258 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)   755 Ola Arwidsson 03/26/2015 06:40AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   335 Peter Brawley 03/26/2015 10:45AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   346 Ola Arwidsson 03/30/2015 01:22AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   371 Ola Arwidsson 03/30/2015 03:27AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   346 Peter Brawley 03/30/2015 11:16AM
system table space vs file per table space   654 jongse park 03/27/2015 12:35AM
Re: system table space vs file per table space   341 Rick James 03/28/2015 03:36PM
Slow COUNT + GROUP BY   866 Refael Dakar 03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY   373 Jeremy Smyth 03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY   385 Refael Dakar 03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY   337 Rick James 03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY   339 Refael Dakar 03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY   362 Øystein Grøvlen 03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY   359 Matan K 03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY   384 Øystein Grøvlen 03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY   333 Matan K 03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY   369 Øystein Grøvlen 03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY   331 Matan K 03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY   374 Øystein Grøvlen 03/24/2015 03:37AM
Query Optimization Needed   836 Devrishi Shandilya 02/11/2015 01:31AM
Re: Query Optimization Needed   387 Peter Brawley 02/11/2015 12:42PM
Re: Query Optimization Needed   424 Devrishi Shandilya 02/12/2015 03:51AM
Re: Query Optimization Needed   386 Peter Brawley 02/12/2015 01:24PM
Re: Query Optimization Needed   416 Devrishi Shandilya 02/13/2015 06:53AM
Re: Query Optimization Needed   366 Peter Brawley 02/13/2015 07:36AM
Re: Query Optimization Needed   368 Rick James 02/14/2015 01:04AM
Re: Query Optimization Needed   374 Devrishi Shandilya 02/15/2015 11:07PM
Re: Query Optimization Needed   361 Rick James 02/16/2015 12:15AM
Re: Query Optimization Needed   316 Peter Brawley 03/13/2015 11:15AM
Exceedingly slow create table performance   896 Ronald Van Iwaarden 03/06/2015 10:51AM
Re: Exceedingly slow create table performance   367 Rick James 03/07/2015 11:03AM
Re: Exceedingly slow create table performance   359 Ronald Van Iwaarden 03/09/2015 10:10AM
Left join optimization- query is very slow   1,198 Devrishi Shandilya 03/05/2015 05:23AM
Re: Left join optimization- query is very slow   470 Øystein Grøvlen 03/05/2015 09:12AM
Re: Left join optimization- query is very slow   701 Rick James 03/06/2015 06:48PM
Re: Left join optimization- query is very slow   432 Devrishi Shandilya 03/08/2015 11:32PM
COUNT with GROUP BY, JOIN and SUBQUERY very slow   1,115 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   461 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   373 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   490 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   390 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   406 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   354 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   394 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   708 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   366 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   359 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   742 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   355 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   748 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   308 Rick James 02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   954 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   389 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   884 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   405 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   403 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   435 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   343 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   803 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   471 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   402 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   537 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   1,211 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   567 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   483 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   626 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   517 Rick James 01/13/2015 04:21PM
How To Use More Resources   893 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   409 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   480 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   496 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   376 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   371 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   442 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   717 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   359 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   443 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   878 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   367 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   352 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   804 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   454 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   852 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   788 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   987 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   496 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   441 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   409 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   380 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   395 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   373 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   897 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   580 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   420 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   575 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   495 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   1,007 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   494 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   467 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   434 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   389 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   482 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   434 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   422 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   411 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   1,299 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   682 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   875 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   374 Rick James 11/28/2014 06:59PM
Cardinality Problem   757 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   338 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   344 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   333 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   1,074 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   444 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   451 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   453 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   461 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   469 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   406 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   432 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   372 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   401 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   390 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   921 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   468 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   409 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   403 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   436 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   399 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   1,250 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   489 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   455 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   481 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   498 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   447 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   1,034 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   414 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   372 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   374 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   408 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   385 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   440 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   343 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   2,675 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   1,372 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   987 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   845 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   717 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   677 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   525 Ravi Malghan 11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support   1,067 Christine Ross 10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support   557 Peter Brawley 10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support   515 Christine Ross 10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support   650 Rick James 11/02/2014 09:33AM
GROUP causing Using Temporary Using Filesort   8,228 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   3,132 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   2,619 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   2,291 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   1,640 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   1,372 Rick James 08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort   1,291 RT Lee 08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort   1,358 Rick James 08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort   915 Leonardo Duque 10/30/2014 12:57PM
Leonardo, please do not hijack threads   670 Peter Brawley 10/31/2014 11:15AM
Eliminate filesort in update query   1,201 Matzz - 09/23/2014 02:48AM
Re: Eliminate filesort in update query   488 Rick James 09/23/2014 09:59PM
Re: Eliminate filesort in update query   446 Matzz - 09/24/2014 01:25AM
Re: Eliminate filesort in update query   470 Rick James 09/24/2014 08:40PM
Re: Eliminate filesort in update query   498 Matzz - 09/25/2014 05:48AM
Re: Eliminate filesort in update query   476 Rick James 09/26/2014 04:39PM
Re: Eliminate filesort in update query   487 Matzz - 10/01/2014 06:49AM
Re: Eliminate filesort in update query   469 Rick James 10/03/2014 10:09PM
Re: Eliminate filesort in update query   531 Matzz - 10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table   924 Jeetu Gaur 09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table   488 Rick James 09/27/2014 08:16AM
Slow response time due queries   1,967 Jens Meier 09/23/2014 01:32AM
Re: Slow response time due queries   788 Rick James 09/23/2014 10:11PM
PHP/MySQL to use all CPU/memory to increase performance   1,241 Caleb Pitman 09/21/2014 11:04AM
Re: PHP/MySQL to use all CPU/memory to increase performance   570 Rick James 09/22/2014 03:39PM
Re: PHP/MySQL to use all CPU/memory to increase performance   622 Caleb Pitman 09/22/2014 04:55PM
Re: PHP/MySQL to use all CPU/memory to increase performance   480 Rick James 09/23/2014 03:21PM
How to set mysql CPU affinity?   1,730 Metal Messiah 09/21/2014 01:33PM
Re: How to set mysql CPU affinity?   819 Rick James 09/22/2014 03:25PM
Re: How to set mysql CPU affinity?   786 Sophia Parsons 09/23/2014 01:30AM
Re: How to set mysql CPU affinity?   734 Rick James 09/23/2014 11:03AM
Query optimization to reduce execution time.   981 Neetu Nayak 09/22/2014 07:33AM
Re: Query optimization to reduce execution time.   475 Rick James 09/22/2014 08:46PM
Re: Query optimization to reduce execution time.   429 Neetu Nayak 09/23/2014 12:38AM
Re: Query optimization to reduce execution time.   483 Neetu Nayak 09/23/2014 01:42AM
Mass Update optimization   1,306 Susan Lin 09/14/2014 06:00PM
Re: Mass Update optimization   529 Rick James 09/15/2014 11:38AM
Re: Mass Update optimization   472 Sophia Parsons 09/23/2014 01:36AM
Optimising query with composite index, which says using where   990 Timothy Mifsud 09/06/2014 12:38AM
Re: Optimising query with composite index, which says using where   421 Timothy Mifsud 09/06/2014 01:53AM
Re: Optimising query with composite index, which says using where   373 Rick James 09/07/2014 10:46PM
Re: Optimising query with composite index, which says using where   407 Øystein Grøvlen 09/15/2014 06:03AM
Re: Optimising query with composite index, which says using where   348 Rick James 09/15/2014 10:03AM
Slow Performance with Multi-threaded app   961 Minesh Desai 09/12/2014 09:24AM
Re: Slow Performance with Multi-threaded app   430 Rick James 09/13/2014 09:47AM
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.