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: 4 of 72
Subject Views Written By Posted
InnoDB and locking, UPDATE and SELECT   994 Andreas Greulich 09/10/2014 01:18AM
Re: InnoDB and locking, UPDATE and SELECT   407 Rick James 09/13/2014 12:09AM
MySQL using too much CPU   1,226 31 Special 08/29/2014 05:12PM
Re: MySQL using too much CPU   512 Rick James 08/30/2014 05:27PM
Re: MySQL using too much CPU   622 31 Special 08/31/2014 10:13PM
Understanding Explain   997 J M 08/27/2014 07:31AM
Re: Understanding Explain   449 Peter Brawley 08/27/2014 10:35AM
Re: Understanding Explain   444 J M 08/27/2014 10:51AM
Re: Understanding Explain   474 Øystein Grøvlen 08/28/2014 03:00PM
Re: Understanding Explain   379 Rick James 08/29/2014 09:45PM
Need help to otimize my query   900 GAURAV JAIN 08/21/2014 07:28AM
Re: Need help to otimize my query   425 Rick James 08/24/2014 09:17PM
Slow response in MY SQL 5.5.1.8   833 Amila Kumara 07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8   457 Rick James 07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8   498 Amila Kumara 07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8   456 Rick James 07/23/2014 12:19AM
Help in tuning MySQL 5.6 database   879 Deepak Dambe 07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database   461 Rick James 07/18/2014 12:12PM
Query slows down over time   1,276 Sameer Shah 05/28/2014 09:35AM
Re: Query slows down over time   587 Peter Brawley 05/28/2014 12:45PM
Re: Query slows down over time   510 Sameer Shah 05/28/2014 01:24PM
Re: Query slows down over time   536 Rick James 05/28/2014 04:57PM
Re: Query slows down over time   570 Sameer Shah 05/28/2014 05:46PM
Re: Query slows down over time   543 Rick James 05/28/2014 07:23PM
Re: Query slows down over time   1,209 Sam Shah 05/29/2014 05:38AM
Re: Query slows down over time   620 Rick James 05/29/2014 09:49AM
Re: Query slows down over time   606 Sam Shah 05/29/2014 03:12PM
Re: Query slows down over time   608 Sam Shah 07/15/2014 12:10PM
Re: Query slows down over time   528 Peter Brawley 07/15/2014 12:33PM
Re: Query slows down over time   467 Rick James 07/16/2014 11:19AM
Performance problem with outer join   962 RT Lee 07/11/2014 07:53AM
Re: Performance problem with outer join   429 Peter Brawley 07/11/2014 09:26AM
Re: Performance problem with outer join   414 Rick James 07/11/2014 04:26PM
Re: Performance problem with outer join   440 RT Lee 07/13/2014 12:29PM
Where to look for server freezes   839 Michael Muratet 07/10/2014 10:08AM
Re: Where to look for server freezes   387 Rick James 07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order   1,158 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   564 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   789 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   555 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   557 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   2,553 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   657 Rick James 06/26/2014 06:19PM
MySQL hangs due to large delete   1,050 Akshay Viswanathan 06/25/2014 08:51AM
Re: MySQL hangs due to large delete   435 Rick James 06/26/2014 06:13PM
Superkey vs Primary Key   1,623 Mario Schill 06/16/2014 04:13AM
Re: Superkey vs Primary Key   649 Peter Brawley 06/16/2014 10:42AM
Re: Superkey vs Primary Key   477 Mario Schill 06/17/2014 12:57AM
Re: Superkey vs Primary Key   493 Peter Brawley 06/17/2014 03:42AM
DML operations slow down   913 Sivaprakash Gopal 06/04/2014 04:43PM
Re: DML operations slow down   476 Rick James 06/06/2014 09:18AM
how to configure my.cnf for mysql 5.1, using too much cpu?   1,354 Aamir Sohail 06/05/2014 06:15AM
Re: how to configure my.cnf for mysql 5.1, using too much cpu?   590 Rick James 06/06/2014 09:09AM
'Compound' INDEXes   1,157 lee fei 06/04/2014 03:24AM
Re: 'Compound' INDEXes   505 Rick James 06/05/2014 09:12PM
Delete slow... randomly   1,236 Francesco De Carlo 06/02/2014 09:15AM
Re: Delete slow... randomly   505 Rick James 06/03/2014 09:51AM
Re: Delete slow... randomly   470 Francesco De Carlo 06/04/2014 03:43AM
Re: Delete slow... randomly   487 Rick James 06/05/2014 08:01PM
concurrent_insert   834 Ben Zhou 06/01/2014 08:15AM
Re: concurrent_insert   432 Rick James 06/02/2014 11:53AM
Re: concurrent_insert   400 Ben Zhou 06/04/2014 08:37AM
Re: concurrent_insert   444 Rick James 06/05/2014 07:55PM
Queriy taking long time in OTRS   1,352 Rajkumar D 05/29/2014 03:53AM
Re: Queriy taking long time in OTRS   433 Rajkumar D 05/29/2014 01:11PM
Re: Queriy taking long time in OTRS   814 Rick James 05/30/2014 10:41AM
Re: Queriy taking long time in OTRS   456 Rajkumar D 05/30/2014 12:45PM
Re: Queriy taking long time in OTRS   673 Øystein Grøvlen 06/02/2014 03:52AM
Query attacks against read-only database   790 joe blake 05/29/2014 09:46PM
Re: Query attacks against read-only database   422 Rick James 05/31/2014 08:04AM
my.cnf file with mysql tuner   1,573 maurizio ca 05/26/2014 03:03AM
Re: my.cnf file with mysql tuner   859 Rick James 05/26/2014 07:29PM
Out of memory - on any moderate query   918 rol and 05/23/2014 12:58PM
Re: Out of memory - on any moderate query   458 Peter Brawley 05/23/2014 10:59PM
Re: Out of memory - on any moderate query   460 Rick James 05/24/2014 03:18PM
Low priority SELECT   1,419 Glas Host 05/21/2014 07:18AM
Re: Low priority SELECT   671 Rick James 05/24/2014 03:05PM
Performance improvement with my.cnf configs   1,135 Manohar K 04/23/2014 10:23AM
Re: Performance improvement with my.cnf configs   449 Rick James 04/24/2014 08:08PM
Re: Performance improvement with my.cnf configs   473 Manohar K 04/24/2014 09:41PM
Re: Performance improvement with my.cnf configs   497 Rick James 04/25/2014 08:24PM
Re: Performance improvement with my.cnf configs   399 Manohar K 05/06/2014 10:22AM
Adding index kills query   1,078 Robert Stafford 04/23/2014 06:10PM
Re: Adding index kills query   496 Robert Stafford 04/23/2014 06:14PM
Re: Adding index kills query   513 Øystein Grøvlen 04/24/2014 02:44AM
Re: Adding index kills query   529 Robert Stafford 04/24/2014 09:07AM
Re: Adding index kills query   494 Øystein Grøvlen 04/25/2014 07:39AM
Re: Adding index kills query   556 Robert Stafford 04/25/2014 11:54AM
Re: Adding index kills query   542 Rick James 04/25/2014 02:25PM
Re: Adding index kills query   511 Øystein Grøvlen 04/28/2014 06:06AM
Re: Adding index kills query   461 Peter Brawley 04/24/2014 09:37AM
Re: Adding index kills query   486 Robert Stafford 04/24/2014 06:31PM
Re: Adding index kills query   546 Peter Brawley 04/24/2014 07:10PM
Re: Adding index kills query   510 Robert Stafford 04/24/2014 07:19PM
Re: Adding index kills query   586 Rick James 04/25/2014 10:55AM
Re: Adding index kills query   428 Øystein Grøvlen 04/25/2014 11:02PM
Re: Adding index kills query   511 Robert Stafford 04/27/2014 07:53PM
Re: Adding index kills query   472 Peter Brawley 04/27/2014 08:50PM
Re: Adding index kills query   513 Rick James 04/27/2014 09:00PM
No response to SELECT with IN clause   1,148 James Cobban 04/21/2014 06:39PM
Re: No response to SELECT with IN clause   406 Peter Brawley 04/21/2014 09:54PM
Re: No response to SELECT with IN clause   424 Rick James 04/22/2014 12:01AM
Recommended changes to my.cnf   796 W B 04/19/2014 01:56PM
Re: Recommended changes to my.cnf   437 Rick James 04/20/2014 04:53PM
Re: Recommended changes to my.cnf   397 W B 04/20/2014 05:01PM
Re: Recommended changes to my.cnf   440 Rick James 04/21/2014 11:24PM
MySQL MyISAM sorting query makes it slower   1,008 Timothy Mifsud 04/13/2014 03:06AM
Re: MySQL MyISAM sorting query makes it slower   511 Rick James 04/13/2014 10:39PM
Re: MySQL MyISAM sorting query makes it slower   504 Timothy Mifsud 04/14/2014 02:10AM
Re: MySQL MyISAM sorting query makes it slower   685 Rick James 04/14/2014 12:23PM
Re: MySQL MyISAM sorting query makes it slower   512 Timothy Mifsud 04/14/2014 04:13PM
Re: MySQL MyISAM sorting query makes it slower   438 Rick James 04/14/2014 07:01PM
Re: MySQL MyISAM sorting query makes it slower   492 Timothy Mifsud 04/15/2014 01:00PM
Re: MySQL MyISAM sorting query makes it slower   479 Rick James 04/16/2014 12:26PM
MySQL query with timestamp not using index   2,029 Bruno Miguel 04/11/2014 11:52AM
Re: MySQL query with timestamp not using index   730 Bruno Miguel 04/11/2014 12:35PM
Re: MySQL query with timestamp not using index   726 Rick James 04/12/2014 09:49AM
Re: MySQL query with timestamp not using index   845 Bruno Miguel 04/14/2014 08:17AM
Re: MySQL query with timestamp not using index   729 Rick James 04/15/2014 03:21PM
MySQL MyISAM - Insert takes much longer on LIVE environment than locally   871 Timothy Mifsud 04/14/2014 08:40AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally   420 Edwin Desouza 04/14/2014 09:16AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally   406 Timothy Mifsud 04/14/2014 02:33PM
MySQL 5.5 who is creating temp tables on disk   788 Till Brinkmann 04/08/2014 02:36AM
Re: MySQL 5.5 who is creating temp tables on disk   431 Øystein Grøvlen 04/09/2014 05:58AM
Re: MySQL 5.5 who is creating temp tables on disk   514 Rick James 04/09/2014 02:30PM
Huge temp file on simple select   851 Pavel Dvořák 04/05/2014 10:12AM
Re: Huge temp file on simple select   454 Rick James 04/06/2014 07:30PM
Re: Huge temp file on simple select   431 Pavel Dvořák 04/07/2014 03:18AM
Re: Huge temp file on simple select   455 Rick James 04/08/2014 11:20AM
Re: Huge temp file on simple select   499 Pavel Dvořák 04/09/2014 02:20AM
Table locked   868 Rafael Pertence Pertence 04/02/2014 06:28AM
Re: Table locked   469 Jonathan Stephens 04/02/2014 09:02AM
Re: Table locked   450 Rafael Pertence Pertence 04/02/2014 09:08AM
Re: Table locked   478 Jonathan Stephens 04/02/2014 11:35PM
Re: Table locked   490 Rick James 04/04/2014 11:33PM
Mysqltuner output - advice   1,457 rol and 04/01/2014 01:16PM
Re: Mysqltuner output - advice   662 Rick James 04/04/2014 11:13PM
MySQL Performance Schema : Prepared Statements Instrumentation   853 Edwin Desouza 04/01/2014 08:17AM
High CPU usage on mysql   2,257 wayne chen 03/24/2014 10:23AM
Re: High CPU usage on mysql   761 Rick James 03/27/2014 04:36PM
Slow update with two like 'string%' conditions   1,028 Oleg Komarov 03/25/2014 04:09PM
Re: Slow update with two like 'string%' conditions   485 Øystein Grøvlen 03/26/2014 03:41AM
Creating Sort Index Slow   10,290 SHI CAI LING 03/14/2014 09:59PM
Re: Creating Sort Index Slow   4,880 Rick James 03/17/2014 11:59AM
Re: Creating Sort Index Slow   3,609 SHI CAI LING 03/17/2014 08:20PM
Re: Creating Sort Index Slow   2,945 Peter Brawley 03/17/2014 08:46PM
Re: Creating Sort Index Slow   2,339 Rick James 03/17/2014 10:31PM
Re: Creating Sort Index Slow   1,999 SHI CAI LING 03/18/2014 01:13AM
Re: Creating Sort Index Slow   1,698 Rick James 03/19/2014 04:56PM
Re: Creating Sort Index Slow   1,625 Rick James 03/19/2014 05:04PM
Re: Creating Sort Index Slow   1,403 SHI CAI LING 03/19/2014 10:06PM
Re: Creating Sort Index Slow   2,357 Rick James 03/19/2014 11:23PM
WHY : select count(*) not returning any results?   1,238 yvonne kire 02/19/2014 01:00PM
Re: WHY : select count(*) not returning any results?   842 Rick James 02/21/2014 06:21PM
Re: WHY : select count(*) not returning any results?   500 sharda salvi 03/12/2014 12:34AM
Re: WHY : select count(*) not returning any results?   501 Rick James 03/12/2014 01:06PM
MySQL 5.5 Queries occasionally extremely slow   1,389 Marc Host 03/03/2014 05:33PM
Re: MySQL 5.5 Queries occasionally extremely slow   594 Øystein Grøvlen 03/04/2014 03:29AM
Re: MySQL 5.5 Queries occasionally extremely slow   589 Marc Host 03/04/2014 12:43PM
Re: MySQL 5.5 Queries occasionally extremely slow   587 Øystein Grøvlen 03/05/2014 04:37AM
Re: MySQL 5.5 Queries occasionally extremely slow   581 Rick James 03/05/2014 10:32PM
Re: MySQL 5.5 Queries occasionally extremely slow   515 Marc Host 03/10/2014 02:18PM
Re: MySQL 5.5 Queries occasionally extremely slow   587 Marc Host 03/10/2014 02:16PM
Re: MySQL 5.5 Queries occasionally extremely slow   638 Marc Host 03/04/2014 01:24PM
Query with Inner Join to small table suddenly takes FOREVER   1,344 Adam Reese 03/06/2014 05:05PM
Re: Query with Inner Join to small table suddenly takes FOREVER   584 Øystein Grøvlen 03/07/2014 09:21AM
Re: Query with Inner Join to small table suddenly takes FOREVER   688 Adam Reese 03/07/2014 01:12PM
Re: Query with Inner Join to small table suddenly takes FOREVER   642 Rick James 03/08/2014 01:03PM
Re: Query with Inner Join to small table suddenly takes FOREVER   644 Øystein Grøvlen 03/10/2014 01:55AM
VARCHAR performance   1,035 Andrew Ling 03/06/2014 05:15AM
Re: VARCHAR performance   454 Øystein Grøvlen 03/07/2014 08:48AM
Re: VARCHAR performance   505 Andrew Ling 03/07/2014 10:01AM
Re: VARCHAR performance   504 Øystein Grøvlen 03/07/2014 10:13AM
Re: VARCHAR performance   451 Andrew Ling 03/07/2014 10:57AM
Re: VARCHAR performance   534 Rick James 03/08/2014 12:53PM
Huge performance differences between systems   967 Julien Galiano 03/05/2014 08:44AM
Re: Huge performance differences between systems   437 Peter Brawley 03/05/2014 09:44AM
Re: Huge performance differences between systems   430 Julien Galiano 03/05/2014 12:13PM
Re: Huge performance differences between systems   405 Peter Brawley 03/05/2014 01:14PM
Re: Huge performance differences between systems   442 Rick James 03/05/2014 10:49PM
Sporadic Query "Freeze" with InnoDB, highly concurrent workload   1,755 Steve Ramage 02/24/2014 04:36PM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   505 Rick James 02/25/2014 08:42PM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   600 Steve Ramage 02/25/2014 11:28PM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   588 Rick James 02/27/2014 12:11AM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   453 Steve Ramage 03/04/2014 10:17AM
Re: Sporadic Query "Freeze" with InnoDB, highly concurrent workload   607 Steve Ramage 03/04/2014 10:15AM
Customization of Algorithm in MySQL   716 Bhumika Shah 03/02/2014 11:57PM
Re: Customization of Algorithm in MySQL   453 Øystein Grøvlen 03/03/2014 01:51AM
High load average (MySQL 5.6.16)   6,985 Peter Wells 02/19/2014 05:24AM
Re: High load average (MySQL 5.6.16)   1,496 Rick James 02/21/2014 06:12PM
Re: High load average (MySQL 5.6.16)   1,216 Peter Wells 02/26/2014 08:48AM
Re: High load average (MySQL 5.6.16)   1,880 Peter Wells 02/26/2014 08:49AM
Re: High load average (MySQL 5.6.16)   1,292 Rick James 02/26/2014 11:44PM
Is it reasonable that lock_time is not included when decide SERVER_QUERY_WAS_SLOW   947 xiaobin lin 02/17/2014 05:20AM
Re: Is it reasonable that lock_time is not included when decide SERVER_QUERY_WAS_SLOW   411 Rick James 02/20/2014 12:01PM
Performance Issius   905 Palin Patzke 02/17/2014 05:00AM
Re: Performance Issius   441 Øystein Grøvlen 02/20/2014 02:50AM
Re: Performance Issius   479 Palin Patzke 02/20/2014 10:48AM
Help in improving query performance   881 Bill Tidy 02/19/2014 03:44AM
Re: Help in improving query performance   482 Øystein Grøvlen 02/20/2014 04:15AM
MySQL with SSD/HDD   2,981 Tobias K. 02/10/2014 08:59AM
Re: MySQL with SSD/HDD   1,642 Rick James 02/11/2014 08:26PM
Re: MySQL with SSD/HDD   994 Tobias K. 02/13/2014 06:00AM
Re: MySQL with SSD/HDD   969 Rick James 02/14/2014 03:40PM
Re: MySQL with SSD/HDD   1,053 Tobias K. 02/18/2014 05:03AM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 4 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.