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: 4 of 72
Subject Views Written By Posted
GROUP causing Using Temporary Using Filesort   8,703 RT Lee 07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort   3,239 Peter Brawley 07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort   2,705 RT Lee 07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort   2,360 Rick James 08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort   1,696 RT Lee 08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort   1,433 Rick James 08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort   1,353 RT Lee 08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort   1,444 Rick James 08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort   949 Leonardo Duque 10/30/2014 12:57PM
Leonardo, please do not hijack threads   691 Peter Brawley 10/31/2014 11:15AM
Eliminate filesort in update query   1,259 Matzz - 09/23/2014 02:48AM
Re: Eliminate filesort in update query   507 Rick James 09/23/2014 09:59PM
Re: Eliminate filesort in update query   461 Matzz - 09/24/2014 01:25AM
Re: Eliminate filesort in update query   488 Rick James 09/24/2014 08:40PM
Re: Eliminate filesort in update query   513 Matzz - 09/25/2014 05:48AM
Re: Eliminate filesort in update query   483 Rick James 09/26/2014 04:39PM
Re: Eliminate filesort in update query   499 Matzz - 10/01/2014 06:49AM
Re: Eliminate filesort in update query   483 Rick James 10/03/2014 10:09PM
Re: Eliminate filesort in update query   548 Matzz - 10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table   963 Jeetu Gaur 09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table   500 Rick James 09/27/2014 08:16AM
Slow response time due queries   2,069 Jens Meier 09/23/2014 01:32AM
Re: Slow response time due queries   827 Rick James 09/23/2014 10:11PM
PHP/MySQL to use all CPU/memory to increase performance   1,287 Caleb Pitman 09/21/2014 11:04AM
Re: PHP/MySQL to use all CPU/memory to increase performance   585 Rick James 09/22/2014 03:39PM
Re: PHP/MySQL to use all CPU/memory to increase performance   635 Caleb Pitman 09/22/2014 04:55PM
Re: PHP/MySQL to use all CPU/memory to increase performance   491 Rick James 09/23/2014 03:21PM
How to set mysql CPU affinity?   1,858 Metal Messiah 09/21/2014 01:33PM
Re: How to set mysql CPU affinity?   887 Rick James 09/22/2014 03:25PM
Re: How to set mysql CPU affinity?   857 Sophia Parsons 09/23/2014 01:30AM
Re: How to set mysql CPU affinity?   781 Rick James 09/23/2014 11:03AM
Query optimization to reduce execution time.   1,014 Neetu Nayak 09/22/2014 07:33AM
Re: Query optimization to reduce execution time.   488 Rick James 09/22/2014 08:46PM
Re: Query optimization to reduce execution time.   444 Neetu Nayak 09/23/2014 12:38AM
Re: Query optimization to reduce execution time.   495 Neetu Nayak 09/23/2014 01:42AM
Mass Update optimization   1,403 Susan Lin 09/14/2014 06:00PM
Re: Mass Update optimization   549 Rick James 09/15/2014 11:38AM
Re: Mass Update optimization   491 Sophia Parsons 09/23/2014 01:36AM
Optimising query with composite index, which says using where   1,018 Timothy Mifsud 09/06/2014 12:38AM
Re: Optimising query with composite index, which says using where   438 Timothy Mifsud 09/06/2014 01:53AM
Re: Optimising query with composite index, which says using where   379 Rick James 09/07/2014 10:46PM
Re: Optimising query with composite index, which says using where   418 Øystein Grøvlen 09/15/2014 06:03AM
Re: Optimising query with composite index, which says using where   358 Rick James 09/15/2014 10:03AM
Slow Performance with Multi-threaded app   992 Minesh Desai 09/12/2014 09:24AM
Re: Slow Performance with Multi-threaded app   455 Rick James 09/13/2014 09:47AM
InnoDB and locking, UPDATE and SELECT   1,027 Andreas Greulich 09/10/2014 01:18AM
Re: InnoDB and locking, UPDATE and SELECT   416 Rick James 09/13/2014 12:09AM
MySQL using too much CPU   1,287 31 Special 08/29/2014 05:12PM
Re: MySQL using too much CPU   547 Rick James 08/30/2014 05:27PM
Re: MySQL using too much CPU   659 31 Special 08/31/2014 10:13PM
Understanding Explain   1,029 J M 08/27/2014 07:31AM
Re: Understanding Explain   457 Peter Brawley 08/27/2014 10:35AM
Re: Understanding Explain   451 J M 08/27/2014 10:51AM
Re: Understanding Explain   494 Øystein Grøvlen 08/28/2014 03:00PM
Re: Understanding Explain   385 Rick James 08/29/2014 09:45PM
Need help to otimize my query   933 GAURAV JAIN 08/21/2014 07:28AM
Re: Need help to otimize my query   434 Rick James 08/24/2014 09:17PM
Slow response in MY SQL 5.5.1.8   868 Amila Kumara 07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8   468 Rick James 07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8   514 Amila Kumara 07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8   466 Rick James 07/23/2014 12:19AM
Help in tuning MySQL 5.6 database   909 Deepak Dambe 07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database   471 Rick James 07/18/2014 12:12PM
Query slows down over time   1,336 Sameer Shah 05/28/2014 09:35AM
Re: Query slows down over time   614 Peter Brawley 05/28/2014 12:45PM
Re: Query slows down over time   526 Sameer Shah 05/28/2014 01:24PM
Re: Query slows down over time   564 Rick James 05/28/2014 04:57PM
Re: Query slows down over time   598 Sameer Shah 05/28/2014 05:46PM
Re: Query slows down over time   569 Rick James 05/28/2014 07:23PM
Re: Query slows down over time   1,321 Sam Shah 05/29/2014 05:38AM
Re: Query slows down over time   658 Rick James 05/29/2014 09:49AM
Re: Query slows down over time   635 Sam Shah 05/29/2014 03:12PM
Re: Query slows down over time   638 Sam Shah 07/15/2014 12:10PM
Re: Query slows down over time   555 Peter Brawley 07/15/2014 12:33PM
Re: Query slows down over time   490 Rick James 07/16/2014 11:19AM
Performance problem with outer join   1,021 RT Lee 07/11/2014 07:53AM
Re: Performance problem with outer join   436 Peter Brawley 07/11/2014 09:26AM
Re: Performance problem with outer join   424 Rick James 07/11/2014 04:26PM
Re: Performance problem with outer join   460 RT Lee 07/13/2014 12:29PM
Where to look for server freezes   869 Michael Muratet 07/10/2014 10:08AM
Re: Where to look for server freezes   406 Rick James 07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order   1,210 bolden kintaro 06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order   578 Øystein Grøvlen 06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order   830 bolden kintaro 06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order   569 Øystein Grøvlen 06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order   571 Rick James 06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   2,696 Bill Plimpton 06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance   681 Rick James 06/26/2014 06:19PM
MySQL hangs due to large delete   1,091 Akshay Viswanathan 06/25/2014 08:51AM
Re: MySQL hangs due to large delete   447 Rick James 06/26/2014 06:13PM
Superkey vs Primary Key   1,720 Mario Schill 06/16/2014 04:13AM
Re: Superkey vs Primary Key   678 Peter Brawley 06/16/2014 10:42AM
Re: Superkey vs Primary Key   491 Mario Schill 06/17/2014 12:57AM
Re: Superkey vs Primary Key   506 Peter Brawley 06/17/2014 03:42AM
DML operations slow down   952 Sivaprakash Gopal 06/04/2014 04:43PM
Re: DML operations slow down   489 Rick James 06/06/2014 09:18AM
how to configure my.cnf for mysql 5.1, using too much cpu?   1,418 Aamir Sohail 06/05/2014 06:15AM
Re: how to configure my.cnf for mysql 5.1, using too much cpu?   615 Rick James 06/06/2014 09:09AM
'Compound' INDEXes   1,222 lee fei 06/04/2014 03:24AM
Re: 'Compound' INDEXes   536 Rick James 06/05/2014 09:12PM
Delete slow... randomly   1,299 Francesco De Carlo 06/02/2014 09:15AM
Re: Delete slow... randomly   538 Rick James 06/03/2014 09:51AM
Re: Delete slow... randomly   504 Francesco De Carlo 06/04/2014 03:43AM
Re: Delete slow... randomly   518 Rick James 06/05/2014 08:01PM
concurrent_insert   861 Ben Zhou 06/01/2014 08:15AM
Re: concurrent_insert   456 Rick James 06/02/2014 11:53AM
Re: concurrent_insert   423 Ben Zhou 06/04/2014 08:37AM
Re: concurrent_insert   470 Rick James 06/05/2014 07:55PM
Queriy taking long time in OTRS   1,414 Rajkumar D 05/29/2014 03:53AM
Re: Queriy taking long time in OTRS   452 Rajkumar D 05/29/2014 01:11PM
Re: Queriy taking long time in OTRS   868 Rick James 05/30/2014 10:41AM
Re: Queriy taking long time in OTRS   480 Rajkumar D 05/30/2014 12:45PM
Re: Queriy taking long time in OTRS   704 Øystein Grøvlen 06/02/2014 03:52AM
Query attacks against read-only database   816 joe blake 05/29/2014 09:46PM
Re: Query attacks against read-only database   447 Rick James 05/31/2014 08:04AM
my.cnf file with mysql tuner   1,644 maurizio ca 05/26/2014 03:03AM
Re: my.cnf file with mysql tuner   906 Rick James 05/26/2014 07:29PM
Out of memory - on any moderate query   971 rol and 05/23/2014 12:58PM
Re: Out of memory - on any moderate query   494 Peter Brawley 05/23/2014 10:59PM
Re: Out of memory - on any moderate query   482 Rick James 05/24/2014 03:18PM
Low priority SELECT   1,518 Glas Host 05/21/2014 07:18AM
Re: Low priority SELECT   735 Rick James 05/24/2014 03:05PM
Performance improvement with my.cnf configs   1,166 Manohar K 04/23/2014 10:23AM
Re: Performance improvement with my.cnf configs   477 Rick James 04/24/2014 08:08PM
Re: Performance improvement with my.cnf configs   499 Manohar K 04/24/2014 09:41PM
Re: Performance improvement with my.cnf configs   519 Rick James 04/25/2014 08:24PM
Re: Performance improvement with my.cnf configs   409 Manohar K 05/06/2014 10:22AM
Adding index kills query   1,132 Robert Stafford 04/23/2014 06:10PM
Re: Adding index kills query   508 Robert Stafford 04/23/2014 06:14PM
Re: Adding index kills query   543 Øystein Grøvlen 04/24/2014 02:44AM
Re: Adding index kills query   555 Robert Stafford 04/24/2014 09:07AM
Re: Adding index kills query   517 Øystein Grøvlen 04/25/2014 07:39AM
Re: Adding index kills query   577 Robert Stafford 04/25/2014 11:54AM
Re: Adding index kills query   560 Rick James 04/25/2014 02:25PM
Re: Adding index kills query   540 Øystein Grøvlen 04/28/2014 06:06AM
Re: Adding index kills query   483 Peter Brawley 04/24/2014 09:37AM
Re: Adding index kills query   499 Robert Stafford 04/24/2014 06:31PM
Re: Adding index kills query   568 Peter Brawley 04/24/2014 07:10PM
Re: Adding index kills query   562 Robert Stafford 04/24/2014 07:19PM
Re: Adding index kills query   624 Rick James 04/25/2014 10:55AM
Re: Adding index kills query   446 Øystein Grøvlen 04/25/2014 11:02PM
Re: Adding index kills query   542 Robert Stafford 04/27/2014 07:53PM
Re: Adding index kills query   490 Peter Brawley 04/27/2014 08:50PM
Re: Adding index kills query   533 Rick James 04/27/2014 09:00PM
No response to SELECT with IN clause   1,200 James Cobban 04/21/2014 06:39PM
Re: No response to SELECT with IN clause   416 Peter Brawley 04/21/2014 09:54PM
Re: No response to SELECT with IN clause   435 Rick James 04/22/2014 12:01AM
Recommended changes to my.cnf   830 W B 04/19/2014 01:56PM
Re: Recommended changes to my.cnf   453 Rick James 04/20/2014 04:53PM
Re: Recommended changes to my.cnf   408 W B 04/20/2014 05:01PM
Re: Recommended changes to my.cnf   451 Rick James 04/21/2014 11:24PM
MySQL MyISAM sorting query makes it slower   1,043 Timothy Mifsud 04/13/2014 03:06AM
Re: MySQL MyISAM sorting query makes it slower   523 Rick James 04/13/2014 10:39PM
Re: MySQL MyISAM sorting query makes it slower   517 Timothy Mifsud 04/14/2014 02:10AM
Re: MySQL MyISAM sorting query makes it slower   712 Rick James 04/14/2014 12:23PM
Re: MySQL MyISAM sorting query makes it slower   528 Timothy Mifsud 04/14/2014 04:13PM
Re: MySQL MyISAM sorting query makes it slower   457 Rick James 04/14/2014 07:01PM
Re: MySQL MyISAM sorting query makes it slower   507 Timothy Mifsud 04/15/2014 01:00PM
Re: MySQL MyISAM sorting query makes it slower   486 Rick James 04/16/2014 12:26PM
MySQL query with timestamp not using index   2,196 Bruno Miguel 04/11/2014 11:52AM
Re: MySQL query with timestamp not using index   782 Bruno Miguel 04/11/2014 12:35PM
Re: MySQL query with timestamp not using index   773 Rick James 04/12/2014 09:49AM
Re: MySQL query with timestamp not using index   904 Bruno Miguel 04/14/2014 08:17AM
Re: MySQL query with timestamp not using index   783 Rick James 04/15/2014 03:21PM
MySQL MyISAM - Insert takes much longer on LIVE environment than locally   895 Timothy Mifsud 04/14/2014 08:40AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally   435 Edwin Desouza 04/14/2014 09:16AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally   415 Timothy Mifsud 04/14/2014 02:33PM
MySQL 5.5 who is creating temp tables on disk   812 Till Brinkmann 04/08/2014 02:36AM
Re: MySQL 5.5 who is creating temp tables on disk   441 Øystein Grøvlen 04/09/2014 05:58AM
Re: MySQL 5.5 who is creating temp tables on disk   523 Rick James 04/09/2014 02:30PM
Huge temp file on simple select   872 Pavel Dvořák 04/05/2014 10:12AM
Re: Huge temp file on simple select   465 Rick James 04/06/2014 07:30PM
Re: Huge temp file on simple select   441 Pavel Dvořák 04/07/2014 03:18AM
Re: Huge temp file on simple select   466 Rick James 04/08/2014 11:20AM
Re: Huge temp file on simple select   507 Pavel Dvořák 04/09/2014 02:20AM
Table locked   902 Rafael Pertence Pertence 04/02/2014 06:28AM
Re: Table locked   480 Jonathan Stephens 04/02/2014 09:02AM
Re: Table locked   462 Rafael Pertence Pertence 04/02/2014 09:08AM
Re: Table locked   501 Jonathan Stephens 04/02/2014 11:35PM
Re: Table locked   505 Rick James 04/04/2014 11:33PM
Mysqltuner output - advice   1,510 rol and 04/01/2014 01:16PM
Re: Mysqltuner output - advice   675 Rick James 04/04/2014 11:13PM
MySQL Performance Schema : Prepared Statements Instrumentation   874 Edwin Desouza 04/01/2014 08:17AM
High CPU usage on mysql   2,358 wayne chen 03/24/2014 10:23AM
Re: High CPU usage on mysql   783 Rick James 03/27/2014 04:36PM
Slow update with two like 'string%' conditions   1,073 Oleg Komarov 03/25/2014 04:09PM
Re: Slow update with two like 'string%' conditions   492 Øystein Grøvlen 03/26/2014 03:41AM
Creating Sort Index Slow   11,028 SHI CAI LING 03/14/2014 09:59PM
Re: Creating Sort Index Slow   5,204 Rick James 03/17/2014 11:59AM
Re: Creating Sort Index Slow   3,836 SHI CAI LING 03/17/2014 08:20PM
Re: Creating Sort Index Slow   3,117 Peter Brawley 03/17/2014 08:46PM
Re: Creating Sort Index Slow   2,478 Rick James 03/17/2014 10:31PM
Re: Creating Sort Index Slow   2,153 SHI CAI LING 03/18/2014 01:13AM
Re: Creating Sort Index Slow   1,841 Rick James 03/19/2014 04:56PM
Re: Creating Sort Index Slow   1,748 Rick James 03/19/2014 05:04PM
Re: Creating Sort Index Slow   1,517 SHI CAI LING 03/19/2014 10:06PM
Re: Creating Sort Index Slow   2,561 Rick James 03/19/2014 11:23PM
WHY : select count(*) not returning any results?   1,297 yvonne kire 02/19/2014 01:00PM
Re: WHY : select count(*) not returning any results?   856 Rick James 02/21/2014 06:21PM
Re: WHY : select count(*) not returning any results?   510 sharda salvi 03/12/2014 12:34AM
Re: WHY : select count(*) not returning any results?   512 Rick James 03/12/2014 01:06PM
MySQL 5.5 Queries occasionally extremely slow   1,450 Marc Host 03/03/2014 05:33PM
Re: MySQL 5.5 Queries occasionally extremely slow   609 Øystein Grøvlen 03/04/2014 03:29AM
Re: MySQL 5.5 Queries occasionally extremely slow   598 Marc Host 03/04/2014 12:43PM
Re: MySQL 5.5 Queries occasionally extremely slow   610 Øystein Grøvlen 03/05/2014 04:37AM
Re: MySQL 5.5 Queries occasionally extremely slow   618 Rick James 03/05/2014 10:32PM
Re: MySQL 5.5 Queries occasionally extremely slow   527 Marc Host 03/10/2014 02:18PM
Re: MySQL 5.5 Queries occasionally extremely slow   600 Marc Host 03/10/2014 02:16PM
Re: MySQL 5.5 Queries occasionally extremely slow   674 Marc Host 03/04/2014 01:24PM
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.