MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Connector/Python 2.2.2 m3 Development Release has been released 12/01/2016 10:48AM
MySQL Cluster Manager 1.4.1 has been released 11/24/2016 06:24AM
MySQL Router 2.0.4 has been released 11/23/2016 11:22AM
MySQL Connector/Node.js 1.0.5 m4 Development Release has been released 11/14/2016 08:41AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 of 72
Subject Views Written By Posted
Best Index Strategy   944 Devrishi Shandilya 08/09/2015 11:35PM
Re: Best Index Strategy   353 Rick James 08/10/2015 07:02AM
Re: Best Index Strategy   306 Rick James 08/10/2015 07:17AM
Re: Best Index Strategy   318 Devrishi Shandilya 08/10/2015 11:30PM
Re: Best Index Strategy   315 Devrishi Shandilya 08/12/2015 10:53PM
Re: Best Index Strategy   296 Rick James 08/15/2015 04:34PM
Re: Best Index Strategy   320 Devrishi Shandilya 08/16/2015 11:53PM
Select last date check all rows   779 Pär Nordlund 08/04/2015 08:47AM
Re: Select last date check all rows   288 Rick James 08/05/2015 05:49PM
Re: Select last date check all rows   302 Pär Nordlund 08/06/2015 03:11AM
Re: Select last date check all rows   266 Pär Nordlund 08/06/2015 03:13AM
Re: Select last date check all rows   282 Rick James 08/06/2015 10:36PM
Re: Select last date check all rows   306 Pär Nordlund 08/07/2015 04:12AM
Re: Select last date check all rows   290 Rick James 08/08/2015 11:11AM
Number of table Partitions   684 Jawahar muthukrishnan 07/22/2015 01:24PM
Re: Number of table Partitions   381 Rick James 07/24/2015 03:14PM
Re: Number of table Partitions   349 Jeeva M 07/31/2015 02:15PM
Slow Query Urgent   813 a m 07/23/2015 09:21AM
Re: Slow Query Urgent   314 Peter Brawley 07/23/2015 10:19AM
Re: Slow Query Urgent   305 Rick James 07/24/2015 04:00PM
MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU   795 Timothy Mifsud 07/16/2015 07:50AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU   279 Peter Brawley 07/16/2015 09:39AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU   270 Rick James 07/17/2015 04:01PM
SELECT never completes   802 James Cobban 07/06/2015 10:08PM
Re: SELECT never completes   338 Peter Brawley 07/06/2015 11:51PM
Re: SELECT never completes   399 James Cobban 07/07/2015 02:16AM
Re: SELECT never completes   317 Rick James 07/09/2015 12:55AM
5.5: UPDATE massively slower than SELECT. Both affect zero rows.   807 Andy Theuninck 05/21/2015 10:09AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   423 Øystein Grøvlen 05/22/2015 02:19AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   403 Andy Theuninck 05/22/2015 08:15AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   329 Rick James 06/06/2015 12:30PM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.   304 Chandan Kumar 06/26/2015 08:24AM
Performance Issue for select query   687 amar singh chawan 06/08/2015 04:58AM
Re: Performance Issue for select query   338 Rick James 06/09/2015 11:42PM
Best Training Institute for Mysql performace tuning and Database scalabulity   657 amar singh chawan 06/07/2015 11:42PM
Is ORDER BY RAND() LIMIT 1 optimized?   1,033 Markus M. 05/27/2015 05:40PM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   476 Øystein Grøvlen 05/28/2015 02:18AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   416 Markus M. 05/28/2015 07:22AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   321 Øystein Grøvlen 05/28/2015 07:49AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?   333 Rick James 06/06/2015 12:16PM
Strange behavior of MySQL server   699 Deepak Itkar 05/27/2015 07:33AM
Re: Strange behavior of MySQL server   310 Rick James 06/06/2015 11:51AM
heavy read workload with high cpu usage   886 kim alex 05/28/2015 04:37AM
Re: heavy read workload with high cpu usage   345 Rick James 06/04/2015 08:35AM
query performance on partitioning table   809 sixin yang 05/12/2015 09:00AM
Re: query performance on partitioning table   388 Rick James 05/16/2015 11:49PM
Re: query performance on partitioning table   361 sixin yang 05/18/2015 08:30AM
Re: query performance on partitioning table   361 Rick James 06/04/2015 08:22AM
Avoid subquery   874 Wolfgang Jacques 05/12/2015 08:40AM
Re: Avoid subquery   372 Peter Brawley 05/12/2015 11:06AM
Re: Avoid subquery   353 Wolfgang Jacques 05/12/2015 01:29PM
Re: Avoid subquery   346 Peter Brawley 05/12/2015 01:41PM
Re: Avoid subquery   368 Rick James 05/17/2015 12:11AM
MYSQL Table Optimization   709 Yudhveer Kandukuri 05/13/2015 09:53PM
Re: MYSQL Table Optimization   334 Rick James 05/15/2015 11:02AM
Slow query   901 Manu Swami 04/21/2015 11:15AM
Re: Slow query   327 Maulik Parekh 04/22/2015 07:17AM
Re: Slow query   365 Rick James 04/22/2015 07:05PM
Re: Slow query   433 Manu Swami 04/23/2015 11:42PM
Re: Slow query   359 Manu Swami 04/23/2015 11:55PM
Re: Slow query   349 Rick James 04/24/2015 05:22PM
Re: Slow query   362 Manu Swami 04/25/2015 02:31AM
Re: Slow query   374 Manu Swami 04/25/2015 02:41AM
Re: Slow query   480 Manu Swami 04/25/2015 05:22AM
Re: Slow query   363 Rick James 04/25/2015 10:42PM
Re: Slow query   303 Øystein Grøvlen 05/13/2015 03:30AM
Re: Slow query   328 Manu Swami 04/28/2015 03:40AM
CPU usage extremely high   1,144 Temu Kinn 04/28/2015 08:55AM
Re: CPU usage extremely high   555 Temu Kinn 04/28/2015 09:03AM
Re: CPU usage extremely high   443 Rick James 04/29/2015 05:43PM
Re: CPU usage extremely high   492 Temu Kinn 05/09/2015 07:22AM
Re: CPU usage extremely high   408 Temu Kinn 05/09/2015 07:38AM
Re: CPU usage extremely high   430 Rick James 05/11/2015 06:30PM
Mysql indexes weird behavior   662 Nikhil Khekade 05/02/2015 02:17AM
Re: Mysql indexes weird behavior   285 Rick James 05/03/2015 06:21PM
slow query sorting result - sending data   1,236 Hugo Rodriguez 04/28/2015 07:27PM
Re: slow query sorting result - sending data   426 Peter Brawley 04/28/2015 10:38PM
Re: slow query sorting result - sending data   415 Rick James 05/01/2015 10:08PM
PROFILING   883 Khurram Naseem 04/27/2015 04:26AM
Re: PROFILING   378 Rick James 04/29/2015 06:53PM
Query time difference   1,041 Ofer Bechar 04/26/2015 07:28AM
Re: Query time difference   331 Rick James 04/27/2015 02:39PM
Re: Query time difference   358 Ofer Bechar 04/27/2015 11:29PM
Re: Query time difference   311 Rick James 04/29/2015 05:50PM
Performance issues with INNODB vs MyISAM   1,449 Milovan Krivokapic 04/17/2015 01:20PM
Re: Performance issues with INNODB vs MyISAM   617 Rick James 04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM   454 Milovan Krivokapic 04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM   380 Rick James 04/28/2015 10:34AM
Why mysqlslap doesn't return the correct Benchmark time?   751 Cai Vincent 04/20/2015 08:07AM
Writing at 847 MB/sec ???   802 Robert Gunther 04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???   399 Rick James 04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???   449 Robert Gunther 04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???   391 Rick James 04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???   415 Robert Gunther 04/20/2015 01:00AM
Mysql is consuming xtremely high CPU above 1000%   993 Eric Leung 04/11/2015 04:38PM
Re: Mysql is consuming xtremely high CPU above 1000%   574 Eric Leung 04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%   449 Rick James 04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%   417 Eric Leung 04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%   441 Rick James 04/17/2015 08:05PM
Re: Mysql is consuming xtremely high CPU above 1000%   553 Eric Leung 04/18/2015 06:07AM
Re: Mysql is consuming xtremely high CPU above 1000%   550 Rick James 04/19/2015 02:19PM
Client to server connection   700 Dan Toškan 04/14/2015 12:40PM
Re: Client to server connection   309 Peter Brawley 04/14/2015 11:18PM
Re: Client to server connection   279 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)   828 Ola Arwidsson 03/26/2015 06:40AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   363 Peter Brawley 03/26/2015 10:45AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   384 Ola Arwidsson 03/30/2015 01:22AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   401 Ola Arwidsson 03/30/2015 03:27AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)   373 Peter Brawley 03/30/2015 11:16AM
system table space vs file per table space   717 jongse park 03/27/2015 12:35AM
Re: system table space vs file per table space   378 Rick James 03/28/2015 03:36PM
Slow COUNT + GROUP BY   941 Refael Dakar 03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY   406 Jeremy Smyth 03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY   407 Refael Dakar 03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY   362 Rick James 03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY   363 Refael Dakar 03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY   396 Øystein Grøvlen 03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY   409 Matan K 03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY   412 Øystein Grøvlen 03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY   359 Matan K 03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY   404 Øystein Grøvlen 03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY   361 Matan K 03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY   424 Øystein Grøvlen 03/24/2015 03:37AM
Query Optimization Needed   905 Devrishi Shandilya 02/11/2015 01:31AM
Re: Query Optimization Needed   410 Peter Brawley 02/11/2015 12:42PM
Re: Query Optimization Needed   457 Devrishi Shandilya 02/12/2015 03:51AM
Re: Query Optimization Needed   421 Peter Brawley 02/12/2015 01:24PM
Re: Query Optimization Needed   445 Devrishi Shandilya 02/13/2015 06:53AM
Re: Query Optimization Needed   389 Peter Brawley 02/13/2015 07:36AM
Re: Query Optimization Needed   396 Rick James 02/14/2015 01:04AM
Re: Query Optimization Needed   416 Devrishi Shandilya 02/15/2015 11:07PM
Re: Query Optimization Needed   427 Rick James 02/16/2015 12:15AM
Re: Query Optimization Needed   341 Peter Brawley 03/13/2015 11:15AM
Exceedingly slow create table performance   988 Ronald Van Iwaarden 03/06/2015 10:51AM
Re: Exceedingly slow create table performance   411 Rick James 03/07/2015 11:03AM
Re: Exceedingly slow create table performance   392 Ronald Van Iwaarden 03/09/2015 10:10AM
Left join optimization- query is very slow   1,337 Devrishi Shandilya 03/05/2015 05:23AM
Re: Left join optimization- query is very slow   504 Øystein Grøvlen 03/05/2015 09:12AM
Re: Left join optimization- query is very slow   770 Rick James 03/06/2015 06:48PM
Re: Left join optimization- query is very slow   460 Devrishi Shandilya 03/08/2015 11:32PM
COUNT with GROUP BY, JOIN and SUBQUERY very slow   1,247 Anderson Scouto da Silva Dan 02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   517 Øystein Grøvlen 03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   403 Øystein Grøvlen 03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   580 Anderson Scouto da Silva Dan 03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   415 Øystein Grøvlen 03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   467 Rick James 03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   384 Anderson Scouto da Silva Dan 03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow   421 Anderson Scouto da Silva Dan 03/02/2015 07:20PM
Slow performance when using LIMIT 1000   773 Christian Esborg 02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000   403 Øystein Grøvlen 02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000   390 Rick James 02/27/2015 01:09AM
Analyse-Optimize and tablecache   784 Samuel Mutel 02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache   420 Rick James 02/18/2015 03:54PM
Temp tables on Disk issue   800 Devrishi Shandilya 02/15/2015 11:17PM
Re: Temp tables on Disk issue   333 Rick James 02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   1,021 Pól Ua Laoínecháin 02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.   415 Øystein Grøvlen 02/05/2015 01:51AM
Mysql performance between installation   995 Patrick MORAND 01/16/2015 07:32AM
Re: Mysql performance between installation   431 Rick James 01/17/2015 11:50AM
Re: Mysql performance between installation   470 Patrick MORAND 01/19/2015 08:26AM
Re: Mysql performance between installation   504 Rick James 01/20/2015 04:57PM
Re: Mysql performance between installation   384 Patrick MORAND 01/21/2015 02:30AM
RAM consideration/ IO usage   884 Jawahar muthukrishnan 01/13/2015 12:39PM
Re: RAM consideration/ IO usage   549 Rick James 01/14/2015 01:47PM
Re: RAM consideration/ IO usage   453 Jawahar muthukrishnan 01/15/2015 03:07PM
Re: RAM consideration/ IO usage   638 Rick James 01/16/2015 02:14PM
Unusually high cpu usage   1,359 Fabrizio Bartolomucci 01/11/2015 02:55PM
Re: Unusually high cpu usage   617 Rick James 01/12/2015 09:49PM
Re: Unusually high cpu usage   519 Fabrizio Bartolomucci 01/13/2015 09:32AM
Re: Unusually high cpu usage   680 Fabrizio Bartolomucci 01/13/2015 11:47AM
Re: Unusually high cpu usage   577 Rick James 01/13/2015 04:21PM
How To Use More Resources   979 Luis Cavazos 01/07/2015 11:12AM
Re: How To Use More Resources   442 Rick James 01/07/2015 07:14PM
Re: How To Use More Resources   539 Luis Cavazos 01/07/2015 09:14PM
Re: How To Use More Resources   550 Rick James 01/07/2015 11:21PM
Re: How To Use More Resources   395 Rick James 01/07/2015 11:42PM
Re: How To Use More Resources   397 Luis Cavazos 01/08/2015 05:48PM
Re: How To Use More Resources   464 Rick James 01/09/2015 02:39PM
How to use performance_schema.tables   789 jongse park 01/07/2015 02:05AM
Re: How to use performance_schema.tables   391 Øystein Grøvlen 01/07/2015 03:41AM
Re: How to use performance_schema.tables   480 Rick James 01/07/2015 05:02PM
lockfree approach to creating a single unique row without unique index   931 Andrew Nuss 01/03/2015 03:43PM
Re: lockfree approach to creating a single unique row without unique index   385 Rick James 01/05/2015 12:17AM
Re: lockfree approach to creating a single unique row without unique index   381 Rick James 01/05/2015 11:04AM
COUNT_STAR, SUM_TIMER_WAIT   871 jongse park 12/26/2014 02:08AM
Re: COUNT_STAR, SUM_TIMER_WAIT   499 Øystein Grøvlen 01/05/2015 04:27AM
what does table_open_cache_overflow=0 means?   976 jongse park 12/29/2014 07:42PM
Re: what does table_open_cache_overflow=0 means?   946 Rick James 12/31/2014 04:59PM
innodb_buffer_pool_read_requests global status wraparound   1,090 Wilson Hauck 11/18/2014 10:18AM
Re: innodb_buffer_pool_read_requests global status wraparound   542 Rick James 11/18/2014 10:40PM
Re: innodb_buffer_pool_read_requests global status wraparound   469 Wilson Hauck 11/19/2014 07:31AM
Re: innodb_buffer_pool_read_requests global status wraparound   439 Wilson Hauck 11/19/2014 10:19AM
Re: innodb_buffer_pool_read_requests global status wraparound   408 Rick James 12/22/2014 01:37AM
Re: innodb_buffer_pool_read_requests global status wraparound   434 Wilson Hauck 11/19/2014 03:00PM
Re: innodb_buffer_pool_read_requests global status wraparound   410 Wilson Hauck 12/20/2014 12:15PM
25.000+ rows - MySQL SELECT consecutive numbers performance issue   979 Daniel Negoita 12/12/2014 08:55AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   629 Daniel Negoita 12/12/2014 09:18AM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   450 Peter Brawley 12/12/2014 12:18PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   620 Rick James 12/14/2014 01:42PM
Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue   534 Peter Brawley 12/14/2014 04:19PM
innodb_checksum_algorithm stic_crc32 is slow response   1,130 Ankur Kaushik 12/08/2014 04:29AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   531 Ankur Kaushik 12/08/2014 04:32AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   495 Øystein Grøvlen 12/08/2014 05:45AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   461 Rick James 12/08/2014 10:52AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   434 Ankur Kaushik 12/09/2014 06:44AM
Re: innodb_checksum_algorithm stic_crc32 is slow response   527 Rick James 12/09/2014 03:34PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   476 Ankur Kaushik 12/13/2014 08:47PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   462 Ankur Kaushik 12/13/2014 08:49PM
Re: innodb_checksum_algorithm stic_crc32 is slow response   447 Rick James 12/14/2014 11:51AM
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   1,431 Daniel Chiaramello 12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?   729 Rick James 12/06/2014 02:40PM
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.