Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Connector/J 5.1.35 has been released 03/24/2015 04:19AM
MySQL Cluster 7.4.5 has been released 03/20/2015 12:52PM
MySQL Connector/C 6.1.6 has been released 03/20/2015 11:23AM
MySQL Enterprise Backup 3.12.0 has been released 03/16/2015 10:55AM
MySQL Workbench 6.3.2 RC has been released 03/13/2015 06:57AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 70
Subject Views Written By Posted
Slow query when joining 2 very large tables with Group and Order   721 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   371 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   438 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   357 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   390 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   1,229 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   388 Rick James 06/26/2014 06:19PM
MySQL hangs due to large delete   586 Akshay Viswanathan 06/25/2014 08:51AM
Re: MySQL hangs due to large delete   289 Rick James 06/26/2014 06:13PM
Superkey vs Primary Key   810 Mario Schill 06/16/2014 04:13AM
Re: Superkey vs Primary Key   374 Peter Brawley 06/16/2014 10:42AM
Re: Superkey vs Primary Key   325 Mario Schill 06/17/2014 12:57AM
Re: Superkey vs Primary Key   352 Peter Brawley 06/17/2014 03:42AM
DML operations slow down   574 Sivaprakash Gopal 06/04/2014 04:43PM
Re: DML operations slow down   317 Rick James 06/06/2014 09:18AM
how to configure my.cnf for mysql 5.1, using too much cpu?   713 Aamir Sohail 06/05/2014 06:15AM
Re: how to configure my.cnf for mysql 5.1, using too much cpu?   355 Rick James 06/06/2014 09:09AM
'Compound' INDEXes   627 lee fei 06/04/2014 03:24AM
Re: 'Compound' INDEXes   307 Rick James 06/05/2014 09:12PM
Delete slow... randomly   674 Francesco De Carlo 06/02/2014 09:15AM
Re: Delete slow... randomly   323 Rick James 06/03/2014 09:51AM
Re: Delete slow... randomly   309 Francesco De Carlo 06/04/2014 03:43AM
Re: Delete slow... randomly   308 Rick James 06/05/2014 08:01PM
concurrent_insert   586 Ben Zhou 06/01/2014 08:15AM
Re: concurrent_insert   302 Rick James 06/02/2014 11:53AM
Re: concurrent_insert   293 Ben Zhou 06/04/2014 08:37AM
Re: concurrent_insert   318 Rick James 06/05/2014 07:55PM
Queriy taking long time in OTRS   805 Rajkumar D 05/29/2014 03:53AM
Re: Queriy taking long time in OTRS   301 Rajkumar D 05/29/2014 01:11PM
Re: Queriy taking long time in OTRS   363 Rick James 05/30/2014 10:41AM
Re: Queriy taking long time in OTRS   300 Rajkumar D 05/30/2014 12:45PM
Re: Queriy taking long time in OTRS   350 Øystein Grøvlen 06/02/2014 03:52AM
Query attacks against read-only database   558 joe blake 05/29/2014 09:46PM
Re: Query attacks against read-only database   274 Rick James 05/31/2014 08:04AM
my.cnf file with mysql tuner   919 maurizio ca 05/26/2014 03:03AM
Re: my.cnf file with mysql tuner   528 Rick James 05/26/2014 07:29PM
Out of memory - on any moderate query   583 rol and 05/23/2014 12:58PM
Re: Out of memory - on any moderate query   287 Peter Brawley 05/23/2014 10:59PM
Re: Out of memory - on any moderate query   310 Rick James 05/24/2014 03:18PM
Low priority SELECT   794 Glas Host 05/21/2014 07:18AM
Re: Low priority SELECT   388 Rick James 05/24/2014 03:05PM
Performance improvement with my.cnf configs   636 Manohar K 04/23/2014 10:23AM
Re: Performance improvement with my.cnf configs   299 Rick James 04/24/2014 08:08PM
Re: Performance improvement with my.cnf configs   304 Manohar K 04/24/2014 09:41PM
Re: Performance improvement with my.cnf configs   340 Rick James 04/25/2014 08:24PM
Re: Performance improvement with my.cnf configs   284 Manohar K 05/06/2014 10:22AM
Adding index kills query   705 Robert Stafford 04/23/2014 06:10PM
Re: Adding index kills query   355 Robert Stafford 04/23/2014 06:14PM
Re: Adding index kills query   366 Øystein Grøvlen 04/24/2014 02:44AM
Re: Adding index kills query   352 Robert Stafford 04/24/2014 09:07AM
Re: Adding index kills query   335 Øystein Grøvlen 04/25/2014 07:39AM
Re: Adding index kills query   359 Robert Stafford 04/25/2014 11:54AM
Re: Adding index kills query   374 Rick James 04/25/2014 02:25PM
Re: Adding index kills query   326 Øystein Grøvlen 04/28/2014 06:06AM
Re: Adding index kills query   320 Peter Brawley 04/24/2014 09:37AM
Re: Adding index kills query   320 Robert Stafford 04/24/2014 06:31PM
Re: Adding index kills query   356 Peter Brawley 04/24/2014 07:10PM
Re: Adding index kills query   286 Robert Stafford 04/24/2014 07:19PM
Re: Adding index kills query   311 Rick James 04/25/2014 10:55AM
Re: Adding index kills query   306 Øystein Grøvlen 04/25/2014 11:02PM
Re: Adding index kills query   349 Robert Stafford 04/27/2014 07:53PM
Re: Adding index kills query   337 Peter Brawley 04/27/2014 08:50PM
Re: Adding index kills query   302 Rick James 04/27/2014 09:00PM
No response to SELECT with IN clause   734 James Cobban 04/21/2014 06:39PM
Re: No response to SELECT with IN clause   282 Peter Brawley 04/21/2014 09:54PM
Re: No response to SELECT with IN clause   305 Rick James 04/22/2014 12:01AM
Recommended changes to my.cnf   561 W B 04/19/2014 01:56PM
Re: Recommended changes to my.cnf   314 Rick James 04/20/2014 04:53PM
Re: Recommended changes to my.cnf   287 W B 04/20/2014 05:01PM
Re: Recommended changes to my.cnf   292 Rick James 04/21/2014 11:24PM
MySQL MyISAM sorting query makes it slower   668 Timothy Mifsud 04/13/2014 03:06AM
Re: MySQL MyISAM sorting query makes it slower   376 Rick James 04/13/2014 10:39PM
Re: MySQL MyISAM sorting query makes it slower   349 Timothy Mifsud 04/14/2014 02:10AM
Re: MySQL MyISAM sorting query makes it slower   334 Rick James 04/14/2014 12:23PM
Re: MySQL MyISAM sorting query makes it slower   324 Timothy Mifsud 04/14/2014 04:13PM
Re: MySQL MyISAM sorting query makes it slower   315 Rick James 04/14/2014 07:01PM
Re: MySQL MyISAM sorting query makes it slower   319 Timothy Mifsud 04/15/2014 01:00PM
Re: MySQL MyISAM sorting query makes it slower   316 Rick James 04/16/2014 12:26PM
MySQL query with timestamp not using index   869 Bruno Miguel 04/11/2014 11:52AM
Re: MySQL query with timestamp not using index   440 Bruno Miguel 04/11/2014 12:35PM
Re: MySQL query with timestamp not using index   402 Rick James 04/12/2014 09:49AM
Re: MySQL query with timestamp not using index   461 Bruno Miguel 04/14/2014 08:17AM
Re: MySQL query with timestamp not using index   399 Rick James 04/15/2014 03:21PM
MySQL MyISAM - Insert takes much longer on LIVE environment than locally   548 Timothy Mifsud 04/14/2014 08:40AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally   281 Edwin Desouza 04/14/2014 09:16AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally   291 Timothy Mifsud 04/14/2014 02:33PM
MySQL 5.5 who is creating temp tables on disk   523 Till Brinkmann 04/08/2014 02:36AM
Re: MySQL 5.5 who is creating temp tables on disk   307 Øystein Grøvlen 04/09/2014 05:58AM
Re: MySQL 5.5 who is creating temp tables on disk   354 Rick James 04/09/2014 02:30PM
Huge temp file on simple select   610 Pavel Dvořák 04/05/2014 10:12AM
Re: Huge temp file on simple select   322 Rick James 04/06/2014 07:30PM
Re: Huge temp file on simple select   287 Pavel Dvořák 04/07/2014 03:18AM
Re: Huge temp file on simple select   337 Rick James 04/08/2014 11:20AM
Re: Huge temp file on simple select   345 Pavel Dvořák 04/09/2014 02:20AM
Table locked   591 Rafael Pertence Pertence 04/02/2014 06:28AM
Re: Table locked   321 Jonathan Stephens 04/02/2014 09:02AM
Re: Table locked   315 Rafael Pertence Pertence 04/02/2014 09:08AM
Re: Table locked   334 Jonathan Stephens 04/02/2014 11:35PM
Re: Table locked   333 Rick James 04/04/2014 11:33PM
Mysqltuner output - advice   850 rol and 04/01/2014 01:16PM
Re: Mysqltuner output - advice   406 Rick James 04/04/2014 11:13PM
MySQL Performance Schema : Prepared Statements Instrumentation   558 Edwin Desouza 04/01/2014 08:17AM
High CPU usage on mysql   1,339 wayne chen 03/24/2014 10:23AM
Re: High CPU usage on mysql   470 Rick James 03/27/2014 04:36PM
Slow update with two like 'string%' conditions   628 Oleg Komarov 03/25/2014 04:09PM
Re: Slow update with two like 'string%' conditions   337 Øystein Grøvlen 03/26/2014 03:41AM
Creating Sort Index Slow   3,851 SHI CAI LING 03/14/2014 09:59PM
Re: Creating Sort Index Slow   2,000 Rick James 03/17/2014 11:59AM
Re: Creating Sort Index Slow   1,541 SHI CAI LING 03/17/2014 08:20PM
Re: Creating Sort Index Slow   1,322 Peter Brawley 03/17/2014 08:46PM
Re: Creating Sort Index Slow   1,109 Rick James 03/17/2014 10:31PM
Re: Creating Sort Index Slow   914 SHI CAI LING 03/18/2014 01:13AM
Re: Creating Sort Index Slow   765 Rick James 03/19/2014 04:56PM
Re: Creating Sort Index Slow   810 Rick James 03/19/2014 05:04PM
Re: Creating Sort Index Slow   662 SHI CAI LING 03/19/2014 10:06PM
Re: Creating Sort Index Slow   982 Rick James 03/19/2014 11:23PM
WHY : select count(*) not returning any results?   770 yvonne kire 02/19/2014 01:00PM
Re: WHY : select count(*) not returning any results?   512 Rick James 02/21/2014 06:21PM
Re: WHY : select count(*) not returning any results?   356 sharda salvi 03/12/2014 12:34AM
Re: WHY : select count(*) not returning any results?   359 Rick James 03/12/2014 01:06PM
MySQL 5.5 Queries occasionally extremely slow   943 Marc Host 03/03/2014 05:33PM
Re: MySQL 5.5 Queries occasionally extremely slow   400 Øystein Grøvlen 03/04/2014 03:29AM
Re: MySQL 5.5 Queries occasionally extremely slow   374 Marc Host 03/04/2014 12:43PM
Re: MySQL 5.5 Queries occasionally extremely slow   383 Øystein Grøvlen 03/05/2014 04:37AM
Re: MySQL 5.5 Queries occasionally extremely slow   413 Rick James 03/05/2014 10:32PM
Re: MySQL 5.5 Queries occasionally extremely slow   351 Marc Host 03/10/2014 02:18PM
Re: MySQL 5.5 Queries occasionally extremely slow   411 Marc Host 03/10/2014 02:16PM
Re: MySQL 5.5 Queries occasionally extremely slow   427 Marc Host 03/04/2014 01:24PM
Query with Inner Join to small table suddenly takes FOREVER   834 Adam Reese 03/06/2014 05:05PM
Re: Query with Inner Join to small table suddenly takes FOREVER   372 Øystein Grøvlen 03/07/2014 09:21AM
Re: Query with Inner Join to small table suddenly takes FOREVER   438 Adam Reese 03/07/2014 01:12PM
Re: Query with Inner Join to small table suddenly takes FOREVER   420 Rick James 03/08/2014 01:03PM
Re: Query with Inner Join to small table suddenly takes FOREVER   409 Øystein Grøvlen 03/10/2014 01:55AM
VARCHAR performance   667 Andrew Ling 03/06/2014 05:15AM
Re: VARCHAR performance   333 Øystein Grøvlen 03/07/2014 08:48AM
Re: VARCHAR performance   328 Andrew Ling 03/07/2014 10:01AM
Re: VARCHAR performance   330 Øystein Grøvlen 03/07/2014 10:13AM
Re: VARCHAR performance   323 Andrew Ling 03/07/2014 10:57AM
Re: VARCHAR performance   342 Rick James 03/08/2014 12:53PM
Huge performance differences between systems   597 Julien Galiano 03/05/2014 08:44AM
Re: Huge performance differences between systems   304 Peter Brawley 03/05/2014 09:44AM
Re: Huge performance differences between systems   294 Julien Galiano 03/05/2014 12:13PM
Re: Huge performance differences between systems   285 Peter Brawley 03/05/2014 01:14PM
Re: Huge performance differences between systems   298 Rick James 03/05/2014 10:49PM
Sporadic Query "Freeze" with InnoDB, highly concurrent workload   1,068 Steve Ramage 02/24/2014 04:36PM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   355 Rick James 02/25/2014 08:42PM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   380 Steve Ramage 02/25/2014 11:28PM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   369 Rick James 02/27/2014 12:11AM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   313 Steve Ramage 03/04/2014 10:17AM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   403 Steve Ramage 03/04/2014 10:15AM
Customization of Algorithm in MySQL   514 Bhumika Shah 03/02/2014 11:57PM
Re: Customization of Algorithm in MySQL   311 Øystein Grøvlen 03/03/2014 01:51AM
High load average (MySQL 5.6.16)   4,252 Peter Wells 02/19/2014 05:24AM
Re: High load average (MySQL 5.6.16)   831 Rick James 02/21/2014 06:12PM
Re: High load average (MySQL 5.6.16)   672 Peter Wells 02/26/2014 08:48AM
Re: High load average (MySQL 5.6.16)   1,349 Peter Wells 02/26/2014 08:49AM
Re: High load average (MySQL 5.6.16)   712 Rick James 02/26/2014 11:44PM
Is it reasonable that lock_time is not included when decide SERVER_QUERY_WAS_SLOW   605 xiaobin lin 02/17/2014 05:20AM
Re: Is it reasonable that lock_time is not included when decide SERVER_QUERY_WAS_SLOW   284 Rick James 02/20/2014 12:01PM
Performance Issius   609 Palin Patzke 02/17/2014 05:00AM
Re: Performance Issius   301 Øystein Grøvlen 02/20/2014 02:50AM
Re: Performance Issius   313 Palin Patzke 02/20/2014 10:48AM
Help in improving query performance   578 Bill Tidy 02/19/2014 03:44AM
Re: Help in improving query performance   317 Øystein Grøvlen 02/20/2014 04:15AM
MySQL with SSD/HDD   1,693 Tobias K. 02/10/2014 08:59AM
Re: MySQL with SSD/HDD   814 Rick James 02/11/2014 08:26PM
Re: MySQL with SSD/HDD   672 Tobias K. 02/13/2014 06:00AM
Re: MySQL with SSD/HDD   618 Rick James 02/14/2014 03:40PM
Re: MySQL with SSD/HDD   646 Tobias K. 02/18/2014 05:03AM
CPU Usage Maxing Out   1,128 Anna M 02/03/2014 05:39PM
Re: CPU Usage Maxing Out   421 Anna M 02/03/2014 05:46PM
Re: CPU Usage Maxing Out   397 Rick James 02/04/2014 10:20PM
Re: CPU Usage Maxing Out   447 Anna M 02/05/2014 02:07PM
Re: CPU Usage Maxing Out   438 Rick James 02/06/2014 07:41PM
Re: CPU Usage Maxing Out   499 Anna M 02/07/2014 12:55PM
Re: CPU Usage Maxing Out   445 Rick James 02/07/2014 06:32PM
Re: CPU Usage Maxing Out   412 Anna M 02/13/2014 10:34AM
Slow insert rate in mysql innodb   2,338 Dhinakaran Arumugam 01/27/2014 10:11AM
Re: Slow insert rate in mysql innodb   974 Rick James 01/28/2014 06:46PM
Re: Slow insert rate in mysql innodb   792 Dhinakaran Arumugam 01/29/2014 11:49PM
Re: Slow insert rate in mysql innodb   713 Rick James 01/30/2014 08:31PM
Re: Slow insert rate in mysql innodb   629 Dhinakaran Arumugam 01/30/2014 11:50PM
Re: Slow insert rate in mysql innodb   656 Rick James 01/31/2014 08:31PM
Re: Slow insert rate in mysql innodb   550 Dhinakaran Arumugam 02/06/2014 07:28AM
Re: Slow insert rate in mysql innodb   581 Rick James 02/07/2014 11:00AM
Re: Slow insert rate in mysql innodb   565 Dhinakaran Arumugam 02/11/2014 10:04PM
Re: Slow insert rate in mysql innodb   565 Rick James 02/12/2014 07:30PM
Slow query on partitioned tables with over 200M rows   839 Hong Yang 02/11/2014 05:10PM
Re: Slow query on partitioned tables with over 200M rows   355 Øystein Grøvlen 02/12/2014 01:48AM
Re: Slow query on partitioned tables with over 200M rows   338 Hong Yang 02/12/2014 08:33AM
Re: Slow query on partitioned tables with over 200M rows   350 Rick James 02/12/2014 08:47AM
Re: Slow query on partitioned tables with over 200M rows   371 Hong Yang 02/12/2014 09:59AM
Re: Slow query on partitioned tables with over 200M rows   359 Rick James 02/12/2014 02:31PM
Re: Slow query on partitioned tables with over 200M rows   341 Hong Yang 02/12/2014 02:53PM
Re: Slow query on partitioned tables with over 200M rows   501 Rick James 02/12/2014 04:33PM
Re: Slow query on partitioned tables with over 200M rows   331 Hong Yang 02/12/2014 06:41PM
What does timestamp repeating in slow query log mean?   970 Joe Murray 01/30/2014 07:52PM
Re: What does timestamp repeating in slow query log mean?   483 Rick James 01/31/2014 04:52PM
reduce execution time of query   1,265 jyoti saini 01/29/2014 03:50AM
Re: reduce execution time of query   435 Peter Brawley 01/29/2014 11:59AM
Re: reduce execution time of query   570 Rick James 01/29/2014 03:44PM
Facing performance related problem with select query.   606 Hardik Patel 01/27/2014 07:54AM
Re: Facing performance related problem with select query.   277 Rick James 01/28/2014 07:05PM
Performance Tuning   530 Karuthappandyan Mahalingam 01/27/2014 04:46PM
Re: Performance Tuning   265 Rick James 01/28/2014 06:39PM
Indexes and Explain Plan Question   625 Jerry Garcia 01/17/2014 12:18PM
Re: Indexes and Explain Plan Question   416 Rick James 01/18/2014 10:17AM
Re: Indexes and Explain Plan Question   319 Jerry Garcia 01/19/2014 07:07AM
Re: Indexes and Explain Plan Question   308 Jerry Garcia 01/19/2014 07:19AM
Re: Indexes and Explain Plan Question   303 Rick James 01/20/2014 03:00PM
MySQL 5.5.31 cripplingly slow   861 Mohammad Chang 01/15/2014 07:16AM
Re: MySQL 5.5.31 cripplingly slow   477 Peter Brawley 01/15/2014 11:44AM
Re: MySQL 5.5.31 cripplingly slow   451 Rick James 01/15/2014 02:12PM
Re: MySQL 5.5.31 cripplingly slow   1,473 Mohammad Chang 01/17/2014 05:52AM
Re: MySQL 5.5.31 cripplingly slow   690 Mohammad Chang 01/17/2014 07:56AM
Re: MySQL 5.5.31 cripplingly slow   560 Peter Brawley 01/17/2014 11:23AM
Re: MySQL 5.5.31 cripplingly slow   526 Mohammad Chang 01/17/2014 11:29AM
Re: MySQL 5.5.31 cripplingly slow   538 Rick James 01/17/2014 02:03PM
Re: MySQL 5.5.31 cripplingly slow   424 Mohammad Chang 01/17/2014 02:43PM
Re: MySQL 5.5.31 cripplingly slow   496 Rick James 01/17/2014 05:13PM
Re: MySQL 5.5.31 cripplingly slow   454 Mohammad Chang 01/18/2014 09:53AM
Re: MySQL 5.5.31 cripplingly slow   432 Rick James 01/18/2014 04:00PM
Re: MySQL 5.5.31 cripplingly slow   466 Mohammad Chang 01/18/2014 08:55PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 2 of 70

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.