MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.1.2 has been released 02/11/2016 10:46AM
MySQL Community Server 5.6.29 has been released 02/05/2016 05:55PM
MySQL Community Server 5.5.48 has been released 02/05/2016 03:02PM
MySQL Community Server 5.7.11 has been released 02/05/2016 09:22AM
MySQL Cluster 7.5.0 has been released (part 3/3) 02/05/2016 02:12AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 71
Subject Views Written By Posted
Slow Query Urgent   528 a m 07/23/2015 09:21AM
Re: Slow Query Urgent   219 Peter Brawley 07/23/2015 10:19AM
Re: Slow Query Urgent   208 Rick James 07/24/2015 04:00PM
MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU   547 Timothy Mifsud 07/16/2015 07:50AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU   198 Peter Brawley 07/16/2015 09:39AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU   201 Rick James 07/17/2015 04:01PM
SELECT never completes   487 James Cobban 07/06/2015 10:08PM
Re: SELECT never completes   209 Peter Brawley 07/06/2015 11:51PM
Re: SELECT never completes   225 James Cobban 07/07/2015 02:16AM
Re: SELECT never completes   221 Rick James 07/09/2015 12:55AM
5.5: UPDATE massively slower than SELECT. Both affect zero rows.   585 Andy Theuninck 05/21/2015 10:09AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   275 Øystein Grøvlen 05/22/2015 02:19AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   281 Andy Theuninck 05/22/2015 08:15AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   232 Rick James 06/06/2015 12:30PM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   227 Chandan Kumar 06/26/2015 08:24AM
Performance Issue for select query   539 amar singh chawan 06/08/2015 04:58AM
Re: Performance Issue for select query   252 Rick James 06/09/2015 11:42PM
Best Training Institute for Mysql performace tuning and Database scalabulity   476 amar singh chawan 06/07/2015 11:42PM
Is ORDER BY RAND() LIMIT 1 optimized?   670 Markus M. 05/27/2015 05:40PM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   307 Øystein Grøvlen 05/28/2015 02:18AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   279 Markus M. 05/28/2015 07:22AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   245 Øystein Grøvlen 05/28/2015 07:49AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   235 Rick James 06/06/2015 12:16PM
Strange behavior of MySQL server   525 Deepak Itkar 05/27/2015 07:33AM
Re: Strange behavior of MySQL server   208 Rick James 06/06/2015 11:51AM
heavy read workload with high cpu usage   619 kim alex 05/28/2015 04:37AM
Re: heavy read workload with high cpu usage   247 Rick James 06/04/2015 08:35AM
query performance on partitioning table   598 sixin yang 05/12/2015 09:00AM
Re: query performance on partitioning table   248 Rick James 05/16/2015 11:49PM
Re: query performance on partitioning table   247 sixin yang 05/18/2015 08:30AM
Re: query performance on partitioning table   231 Rick James 06/04/2015 08:22AM
Avoid subquery   645 Wolfgang Jacques 05/12/2015 08:40AM
Re: Avoid subquery   249 Peter Brawley 05/12/2015 11:06AM
Re: Avoid subquery   249 Wolfgang Jacques 05/12/2015 01:29PM
Re: Avoid subquery   253 Peter Brawley 05/12/2015 01:41PM
Re: Avoid subquery   259 Rick James 05/17/2015 12:11AM
MYSQL Table Optimization   533 Yudhveer Kandukuri 05/13/2015 09:53PM
Re: MYSQL Table Optimization   232 Rick James 05/15/2015 11:02AM
Slow query   667 Manu Swami 04/21/2015 11:15AM
Re: Slow query   261 Maulik Parekh 04/22/2015 07:17AM
Re: Slow query   268 Rick James 04/22/2015 07:05PM
Re: Slow query   275 Manu Swami 04/23/2015 11:42PM
Re: Slow query   266 Manu Swami 04/23/2015 11:55PM
Re: Slow query   239 Rick James 04/24/2015 05:22PM
Re: Slow query   245 Manu Swami 04/25/2015 02:31AM
Re: Slow query   252 Manu Swami 04/25/2015 02:41AM
Re: Slow query   289 Manu Swami 04/25/2015 05:22AM
Re: Slow query   265 Rick James 04/25/2015 10:42PM
Re: Slow query   228 Øystein Grøvlen 05/13/2015 03:30AM
Re: Slow query   243 Manu Swami 04/28/2015 03:40AM
CPU usage extremely high   751 Temu Kinn 04/28/2015 08:55AM
Re: CPU usage extremely high   372 Temu Kinn 04/28/2015 09:03AM
Re: CPU usage extremely high   329 Rick James 04/29/2015 05:43PM
Re: CPU usage extremely high   324 Temu Kinn 05/09/2015 07:22AM
Re: CPU usage extremely high   300 Temu Kinn 05/09/2015 07:38AM
Re: CPU usage extremely high   301 Rick James 05/11/2015 06:30PM
Mysql indexes weird behavior   519 Nikhil Khekade 05/02/2015 02:17AM
Re: Mysql indexes weird behavior   224 Rick James 05/03/2015 06:21PM
slow query sorting result - sending data   782 Hugo Rodriguez 04/28/2015 07:27PM
Re: slow query sorting result - sending data   303 Peter Brawley 04/28/2015 10:38PM
Re: slow query sorting result - sending data   286 Rick James 05/01/2015 10:08PM
PROFILING   622 Khurram Naseem 04/27/2015 04:26AM
Re: PROFILING   253 Rick James 04/29/2015 06:53PM
Query time difference   865 Ofer Bechar 04/26/2015 07:28AM
Re: Query time difference   238 Rick James 04/27/2015 02:39PM
Re: Query time difference   241 Ofer Bechar 04/27/2015 11:29PM
Re: Query time difference   232 Rick James 04/29/2015 05:50PM
Performance issues with INNODB vs MyISAM   1,074 Milovan Krivokapic 04/17/2015 01:20PM
Re: Performance issues with INNODB vs MyISAM   437 Rick James 04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM   335 Milovan Krivokapic 04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM   281 Rick James 04/28/2015 10:34AM
Why mysqlslap doesn't return the correct Benchmark time?   570 Cai Vincent 04/20/2015 08:07AM
Writing at 847 MB/sec ???   592 Robert Gunther 04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???   274 Rick James 04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???   276 Robert Gunther 04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???   262 Rick James 04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???   267 Robert Gunther 04/20/2015 01:00AM
Mysql is consuming xtremely high CPU above 1000%   674 Eric Leung 04/11/2015 04:38PM
Re: Mysql is consuming xtremely high CPU above 1000%   390 Eric Leung 04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%   318 Rick James 04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%   305 Eric Leung 04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%   322 Rick James 04/17/2015 08:05PM
Re: Mysql is consuming xtremely high CPU above 1000%   370 Eric Leung 04/18/2015 06:07AM
Re: Mysql is consuming xtremely high CPU above 1000%   379 Rick James 04/19/2015 02:19PM
Client to server connection   527 Dan Toškan 04/14/2015 12:40PM
Re: Client to server connection   249 Peter Brawley 04/14/2015 11:18PM
Re: Client to server connection   226 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)   626 Ola Arwidsson 03/26/2015 06:40AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   287 Peter Brawley 03/26/2015 10:45AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   297 Ola Arwidsson 03/30/2015 01:22AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   281 Ola Arwidsson 03/30/2015 03:27AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   291 Peter Brawley 03/30/2015 11:16AM
system table space vs file per table space   534 jongse park 03/27/2015 12:35AM
Re: system table space vs file per table space   264 Rick James 03/28/2015 03:36PM
Slow COUNT + GROUP BY   717 Refael Dakar 03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY   316 Jeremy Smyth 03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY   330 Refael Dakar 03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY   307 Rick James 03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY   311 Refael Dakar 03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY   325 Øystein Grøvlen 03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY   310 Matan K 03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY   332 Øystein Grøvlen 03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY   295 Matan K 03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY   305 Øystein Grøvlen 03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY   292 Matan K 03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY   312 Øystein Grøvlen 03/24/2015 03:37AM
Query Optimization Needed   716 Devrishi Shandilya 02/11/2015 01:31AM
Re: Query Optimization Needed   338 Peter Brawley 02/11/2015 12:42PM
Re: Query Optimization Needed   359 Devrishi Shandilya 02/12/2015 03:51AM
Re: Query Optimization Needed   335 Peter Brawley 02/12/2015 01:24PM
Re: Query Optimization Needed   370 Devrishi Shandilya 02/13/2015 06:53AM
Re: Query Optimization Needed   327 Peter Brawley 02/13/2015 07:36AM
Re: Query Optimization Needed   315 Rick James 02/14/2015 01:04AM
Re: Query Optimization Needed   332 Devrishi Shandilya 02/15/2015 11:07PM
Re: Query Optimization Needed   304 Rick James 02/16/2015 12:15AM
Re: Query Optimization Needed   270 Peter Brawley 03/13/2015 11:15AM
Exceedingly slow create table performance   707 Ronald Van Iwaarden 03/06/2015 10:51AM
Re: Exceedingly slow create table performance   312 Rick James 03/07/2015 11:03AM
Re: Exceedingly slow create table performance   288 Ronald Van Iwaarden 03/09/2015 10:10AM
Left join optimization- query is very slow   919 Devrishi Shandilya 03/05/2015 05:23AM
Re: Left join optimization- query is very slow   396 Øystein Grøvlen 03/05/2015 09:12AM
Re: Left join optimization- query is very slow   563 Rick James 03/06/2015 06:48PM
Re: Left join optimization- query is very slow   372 Devrishi Shandilya 03/08/2015 11:32PM
COUNT with GROUP BY, JOIN and SUBQUERY very slow   916 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   366 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   331 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   378 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   341 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   312 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   296 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   327 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   600 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   304 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   296 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   653 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   295 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   657 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   273 Rick James 02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   770 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   325 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   738 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   332 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   325 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   344 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   295 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   681 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   383 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   331 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   421 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   1,022 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   455 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   414 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   518 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   430 Rick James 01/13/2015 04:21PM
How To Use More Resources   756 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   337 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   389 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   407 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   319 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   322 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   373 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   618 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   305 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   365 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   764 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   310 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   298 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   684 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   357 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   732 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   616 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   847 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   433 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   391 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   352 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   337 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   336 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   303 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   782 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   482 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   359 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   478 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   422 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   857 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   451 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   394 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   386 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   342 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   407 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   370 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   351 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   358 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   1,045 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   563 Rick James 12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam   761 MURALI NARAYANASWAMY 11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam   315 Rick James 11/28/2014 06:59PM
Cardinality Problem   674 Katja Kahl 11/26/2014 06:53AM
Re: Cardinality Problem   302 Peter Brawley 11/26/2014 12:03PM
Re: Cardinality Problem   297 Katja Kahl 11/27/2014 03:08AM
Re: Cardinality Problem   283 Rick James 11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++   951 saraswathi srinath 11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++   399 Rick James 11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   391 saraswathi srinath 11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   401 Rick James 11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   388 saraswathi srinath 11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   423 Rick James 11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   369 saraswathi srinath 11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   378 saraswathi srinath 11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   339 Rick James 11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   358 saraswathi srinath 11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++   341 Rick James 11/20/2014 07:59PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 71

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.