MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.3 GA has been released 09/15/2016 03:06PM
MySQL Connector/Python 2.2.1 m2 Development Release has been released 09/13/2016 09:58AM
Oracle Enterprise Manager for MySQL Database 12.1.0.4.0 has been released 09/12/2016 02:59PM
MySQL Community Server 8.0.0-dmr has been released (part 3/3) 09/12/2016 08:52AM
MySQL Community Server 8.0.0-dmr has been released (part 2/3) 09/12/2016 08:50AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 of 72
Subject Views Written By Posted
Performance Issue for select query   661 amar singh chawan 06/08/2015 04:58AM
Re: Performance Issue for select query   318 Rick James 06/09/2015 11:42PM
Best Training Institute for Mysql performace tuning and Database scalabulity   623 amar singh chawan 06/07/2015 11:42PM
Is ORDER BY RAND() LIMIT 1 optimized?   951 Markus M. 05/27/2015 05:40PM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   445 Øystein Grøvlen 05/28/2015 02:18AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   385 Markus M. 05/28/2015 07:22AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   307 Øystein Grøvlen 05/28/2015 07:49AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   309 Rick James 06/06/2015 12:16PM
Strange behavior of MySQL server   669 Deepak Itkar 05/27/2015 07:33AM
Re: Strange behavior of MySQL server   291 Rick James 06/06/2015 11:51AM
heavy read workload with high cpu usage   839 kim alex 05/28/2015 04:37AM
Re: heavy read workload with high cpu usage   329 Rick James 06/04/2015 08:35AM
query performance on partitioning table   774 sixin yang 05/12/2015 09:00AM
Re: query performance on partitioning table   354 Rick James 05/16/2015 11:49PM
Re: query performance on partitioning table   343 sixin yang 05/18/2015 08:30AM
Re: query performance on partitioning table   330 Rick James 06/04/2015 08:22AM
Avoid subquery   830 Wolfgang Jacques 05/12/2015 08:40AM
Re: Avoid subquery   348 Peter Brawley 05/12/2015 11:06AM
Re: Avoid subquery   332 Wolfgang Jacques 05/12/2015 01:29PM
Re: Avoid subquery   333 Peter Brawley 05/12/2015 01:41PM
Re: Avoid subquery   346 Rick James 05/17/2015 12:11AM
MYSQL Table Optimization   682 Yudhveer Kandukuri 05/13/2015 09:53PM
Re: MYSQL Table Optimization   314 Rick James 05/15/2015 11:02AM
Slow query   844 Manu Swami 04/21/2015 11:15AM
Re: Slow query   313 Maulik Parekh 04/22/2015 07:17AM
Re: Slow query   343 Rick James 04/22/2015 07:05PM
Re: Slow query   394 Manu Swami 04/23/2015 11:42PM
Re: Slow query   338 Manu Swami 04/23/2015 11:55PM
Re: Slow query   321 Rick James 04/24/2015 05:22PM
Re: Slow query   339 Manu Swami 04/25/2015 02:31AM
Re: Slow query   351 Manu Swami 04/25/2015 02:41AM
Re: Slow query   434 Manu Swami 04/25/2015 05:22AM
Re: Slow query   345 Rick James 04/25/2015 10:42PM
Re: Slow query   284 Øystein Grøvlen 05/13/2015 03:30AM
Re: Slow query   304 Manu Swami 04/28/2015 03:40AM
CPU usage extremely high   1,064 Temu Kinn 04/28/2015 08:55AM
Re: CPU usage extremely high   514 Temu Kinn 04/28/2015 09:03AM
Re: CPU usage extremely high   422 Rick James 04/29/2015 05:43PM
Re: CPU usage extremely high   456 Temu Kinn 05/09/2015 07:22AM
Re: CPU usage extremely high   386 Temu Kinn 05/09/2015 07:38AM
Re: CPU usage extremely high   397 Rick James 05/11/2015 06:30PM
Mysql indexes weird behavior   641 Nikhil Khekade 05/02/2015 02:17AM
Re: Mysql indexes weird behavior   271 Rick James 05/03/2015 06:21PM
slow query sorting result - sending data   1,142 Hugo Rodriguez 04/28/2015 07:27PM
Re: slow query sorting result - sending data   401 Peter Brawley 04/28/2015 10:38PM
Re: slow query sorting result - sending data   396 Rick James 05/01/2015 10:08PM
PROFILING   838 Khurram Naseem 04/27/2015 04:26AM
Re: PROFILING   351 Rick James 04/29/2015 06:53PM
Query time difference   1,014 Ofer Bechar 04/26/2015 07:28AM
Re: Query time difference   318 Rick James 04/27/2015 02:39PM
Re: Query time difference   334 Ofer Bechar 04/27/2015 11:29PM
Re: Query time difference   298 Rick James 04/29/2015 05:50PM
Performance issues with INNODB vs MyISAM   1,379 Milovan Krivokapic 04/17/2015 01:20PM
Re: Performance issues with INNODB vs MyISAM   587 Rick James 04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM   434 Milovan Krivokapic 04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM   364 Rick James 04/28/2015 10:34AM
Why mysqlslap doesn't return the correct Benchmark time?   721 Cai Vincent 04/20/2015 08:07AM
Writing at 847 MB/sec ???   765 Robert Gunther 04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???   382 Rick James 04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???   413 Robert Gunther 04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???   367 Rick James 04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???   392 Robert Gunther 04/20/2015 01:00AM
Mysql is consuming xtremely high CPU above 1000%   933 Eric Leung 04/11/2015 04:38PM
Re: Mysql is consuming xtremely high CPU above 1000%   542 Eric Leung 04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%   425 Rick James 04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%   394 Eric Leung 04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%   421 Rick James 04/17/2015 08:05PM
Re: Mysql is consuming xtremely high CPU above 1000%   512 Eric Leung 04/18/2015 06:07AM
Re: Mysql is consuming xtremely high CPU above 1000%   512 Rick James 04/19/2015 02:19PM
Client to server connection   669 Dan Toškan 04/14/2015 12:40PM
Re: Client to server connection   297 Peter Brawley 04/14/2015 11:18PM
Re: Client to server connection   267 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)   789 Ola Arwidsson 03/26/2015 06:40AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   346 Peter Brawley 03/26/2015 10:45AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   364 Ola Arwidsson 03/30/2015 01:22AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   385 Ola Arwidsson 03/30/2015 03:27AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   355 Peter Brawley 03/30/2015 11:16AM
system table space vs file per table space   689 jongse park 03/27/2015 12:35AM
Re: system table space vs file per table space   360 Rick James 03/28/2015 03:36PM
Slow COUNT + GROUP BY   902 Refael Dakar 03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY   391 Jeremy Smyth 03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY   394 Refael Dakar 03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY   345 Rick James 03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY   347 Refael Dakar 03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY   381 Øystein Grøvlen 03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY   387 Matan K 03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY   396 Øystein Grøvlen 03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY   343 Matan K 03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY   388 Øystein Grøvlen 03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY   348 Matan K 03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY   399 Øystein Grøvlen 03/24/2015 03:37AM
Query Optimization Needed   870 Devrishi Shandilya 02/11/2015 01:31AM
Re: Query Optimization Needed   396 Peter Brawley 02/11/2015 12:42PM
Re: Query Optimization Needed   439 Devrishi Shandilya 02/12/2015 03:51AM
Re: Query Optimization Needed   406 Peter Brawley 02/12/2015 01:24PM
Re: Query Optimization Needed   430 Devrishi Shandilya 02/13/2015 06:53AM
Re: Query Optimization Needed   374 Peter Brawley 02/13/2015 07:36AM
Re: Query Optimization Needed   380 Rick James 02/14/2015 01:04AM
Re: Query Optimization Needed   395 Devrishi Shandilya 02/15/2015 11:07PM
Re: Query Optimization Needed   392 Rick James 02/16/2015 12:15AM
Re: Query Optimization Needed   327 Peter Brawley 03/13/2015 11:15AM
Exceedingly slow create table performance   943 Ronald Van Iwaarden 03/06/2015 10:51AM
Re: Exceedingly slow create table performance   385 Rick James 03/07/2015 11:03AM
Re: Exceedingly slow create table performance   372 Ronald Van Iwaarden 03/09/2015 10:10AM
Left join optimization- query is very slow   1,266 Devrishi Shandilya 03/05/2015 05:23AM
Re: Left join optimization- query is very slow   487 Øystein Grøvlen 03/05/2015 09:12AM
Re: Left join optimization- query is very slow   736 Rick James 03/06/2015 06:48PM
Re: Left join optimization- query is very slow   442 Devrishi Shandilya 03/08/2015 11:32PM
COUNT with GROUP BY, JOIN and SUBQUERY very slow   1,188 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   500 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   386 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   535 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   401 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   431 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   366 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   403 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   742 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   383 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   371 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   762 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   388 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   775 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   315 Rick James 02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   990 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   398 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   942 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   416 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   439 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   470 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   365 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   849 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   506 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   420 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   593 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   1,275 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   590 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   501 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   650 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   549 Rick James 01/13/2015 04:21PM
How To Use More Resources   938 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   427 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   512 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   520 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   383 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   382 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   453 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   748 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   374 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   462 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   907 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   374 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   365 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   836 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   480 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   926 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   883 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   1,039 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   517 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   451 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   422 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   391 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   414 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   389 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   933 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   606 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   437 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   600 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   514 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   1,068 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   512 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   482 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   447 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   405 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   509 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   450 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   443 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   428 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   1,373 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   706 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   906 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   384 Rick James 11/28/2014 06:59PM
Cardinality Problem   778 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   346 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   355 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   339 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   1,111 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   458 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   469 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   466 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   476 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   489 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   417 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   447 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   379 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   409 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   407 Rick James 11/20/2014 07:59PM
Which server hardware would you pick?   947 Robert Gunther 11/14/2014 08:24PM
Re: Which server hardware would you pick?   481 Rick James 11/15/2014 08:46PM
Re: Which server hardware would you pick?   422 Robert Gunther 11/16/2014 06:25PM
Re: Which server hardware would you pick?   431 Rick James 11/17/2014 03:42PM
Re: Which server hardware would you pick?   450 Robert Gunther 11/18/2014 09:08AM
Re: Which server hardware would you pick?   411 Rick James 11/19/2014 05:02PM
MySQL query execution time differs between executions   1,321 Ofer Bechar 11/16/2014 09:49AM
Re: MySQL query execution time differs between executions   519 Peter Brawley 11/16/2014 12:19PM
Re: MySQL query execution time differs between executions   473 Rick James 11/16/2014 03:24PM
Re: MySQL query execution time differs between executions   503 Ofer Bechar 11/17/2014 02:57AM
Re: MySQL query execution time differs between executions   523 Rick James 11/17/2014 04:09PM
Re: MySQL query execution time differs between executions   474 Ofer Bechar 11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?   1,085 Yao Yao 11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?   427 Dexter Yao 11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?   383 Rick James 11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?   382 Dexter Yao 11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?   416 Rick James 11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?   394 Dexter Yao 11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?   449 Rick James 11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?   352 Dexter Yao 11/05/2014 04:39AM
Performance of insert on duplicate key update   2,884 Ravi Malghan 10/23/2014 02:03PM
Re: Performance of insert on duplicate key update   1,472 Rick James 10/24/2014 10:39AM
Re: Performance of insert on duplicate key update   1,045 Ravi Malghan 10/24/2014 11:54AM
Re: Performance of insert on duplicate key update   894 Rick James 10/25/2014 12:51PM
Re: Performance of insert on duplicate key update   780 Ravi Malghan 10/27/2014 07:44AM
Re: Performance of insert on duplicate key update   720 Rick James 10/28/2014 11:33AM
Re: Performance of insert on duplicate key update   557 Ravi Malghan 11/04/2014 06:40AM
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.