Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Connector/J 5.1.36 has been released 07/03/2015 11:48AM
MySQL Cluster Manager 1.3.6 has been released 07/02/2015 01:08AM
MySQL Enterprise Monitor 3.0.22 has been released 07/01/2015 07:16PM
MySQL Enterprise Backup 3.12.1 has been released 06/29/2015 10:28AM
MySQL Workbench 6.3.4 GA has been released 06/15/2015 08:04AM
Current Page: 5 of 70
Subject Views Written By Posted
High CPU usage in %user   16,687 Marco Ramirez 05/14/2013 12:31PM
Re: High CPU usage in %user   3,008 Rick James 05/15/2013 08:00PM
Re: High CPU usage in %user   2,532 Marco Ramirez 05/16/2013 02:22AM
Re: High CPU usage in %user   2,128 Rick James 05/16/2013 09:46PM
Queries locking up   951 Thomas Kazarian 05/07/2013 01:13PM
Re: Queries locking up   443 Rick James 05/08/2013 08:50PM
Re: Queries locking up   363 Thomas Kazarian 05/09/2013 10:09PM
Re: Queries locking up   496 Rick James 05/11/2013 11:29PM
Re: Queries locking up   368 Thomas Kazarian 05/15/2013 09:33PM
Composite index - selecting components and order   965 Rick Ingram 05/04/2013 10:54AM
Re: Composite index - selecting components and order   424 Rick James 05/06/2013 07:47PM
Re: Composite index - selecting components and order   431 Rick Ingram 05/06/2013 10:47PM
Re: Composite index - selecting components and order   488 Rick James 05/07/2013 08:05PM
Re: Composite index - selecting components and order   388 Rick Ingram 05/07/2013 08:40PM
Re: Composite index - selecting components and order   436 Rick Ingram 05/08/2013 06:55AM
Re: Composite index - selecting components and order   392 Rick James 05/08/2013 08:45PM
Re: Composite index - selecting components and order   415 Rick Ingram 05/08/2013 09:54PM
Re: Composite index - selecting components and order   704 Rick James 05/09/2013 10:46PM
Re: Composite index - selecting components and order   397 Rick Ingram 05/09/2013 10:56PM
How MySQL Uses Indexes   884 Mola Ji 05/04/2013 08:28AM
Re: How MySQL Uses Indexes   436 Øystein Grøvlen 05/06/2013 03:46AM
Re: How MySQL Uses Indexes   472 Mola Ji 05/06/2013 10:31AM
Re: How MySQL Uses Indexes   461 Rick James 05/06/2013 07:57PM
Re: How MySQL Uses Indexes   426 Mola Ji 05/07/2013 12:24PM
Re: How MySQL Uses Indexes   442 Rick James 05/07/2013 07:47PM
Re: How MySQL Uses Indexes   405 Mola Ji 05/08/2013 05:33AM
Re: How MySQL Uses Indexes   398 Rick James 05/08/2013 09:04PM
This topic has been moved.:  jdbc "Communications link failure" / Logging myql   13 Stefan Scheffler 05/07/2013 09:50AM
Hardware sizing tools   1,594 James Marcus 05/01/2013 11:32AM
Re: Hardware sizing tools   744 Rick James 05/02/2013 07:38AM
Re: Hardware sizing tools   699 James Marcus 05/03/2013 11:24AM
Re: Hardware sizing tools   622 Rick James 05/04/2013 01:34PM
cache not used with restricted privileges ?   853 brocu lus 04/30/2013 02:44AM
Re: cache not used with restricted privileges ?   406 Rick James 05/01/2013 11:57PM
Re: cache not used with restricted privileges ?   426 brocu lus 05/02/2013 08:35AM
Re: QUERY cache not used with restricted privileges ?   414 Rick James 05/03/2013 09:32AM
partitioning every year data   920 mohamed bashid s 04/13/2013 07:20PM
Re: partitioning every year data   447 Mikael Ronström 04/24/2013 12:30PM
Re: partitioning every year data   421 mohamed bashid s 04/29/2013 04:53AM
Re: partitioning every year data   470 Rick James 05/02/2013 12:00AM
Re: partitioning every year data   435 mohamed bashid s 05/02/2013 02:59AM
Re: partitioning every year data   426 Rick James 05/02/2013 07:57AM
In-memory dB on Embedded system   1,086 Sandhya Srinivas 04/24/2013 03:58AM
Re: In-memory dB on Embedded system   517 Rick James 04/24/2013 10:51PM
mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   6,595 Meteor SY 04/22/2013 09:03AM
Re: mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   2,362 Meteor SY 04/22/2013 07:31PM
Re: mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   2,351 Rick James 04/23/2013 11:22PM
pattern matching with LIKE or REGEXP   947 Oka Putra 04/21/2013 10:05AM
Re: pattern matching with LIKE or REGEXP   404 Rick James 04/23/2013 08:33AM
Simple join taking longer than it should   934 Kenneth Mitchner 04/16/2013 02:02PM
Re: Simple join taking longer than it should   384 Rick James 04/17/2013 09:04PM
Sortable columns dilemma   860 Patrick Clas 04/13/2013 11:28AM
Re: Sortable columns dilemma   364 Rick James 04/14/2013 01:09PM
Insertion performance degrade with large index   1,134 holy holy 04/11/2013 02:36AM
Re: Insertion performance degrade with large index   522 Rick James 04/11/2013 10:08PM
Re: Insertion performance degrade with large index   442 holy holy 04/12/2013 12:51AM
Re: Insertion performance degrade with large index   454 Rick James 04/12/2013 08:23PM
handle multiple years data   805 mohamed bashid s 02/27/2013 12:50AM
Re: handle multiple years data   511 Rick James 02/27/2013 11:23PM
Re: handle multiple years data   408 mohamed bashid s 04/12/2013 06:38AM
MySQL 5.6 update doubled IOs   1,537 Christian Meisinger 03/18/2013 08:33AM
Re: MySQL 5.6 update doubled IOs   666 Christian Meisinger 03/19/2013 08:58AM
Re: MySQL 5.6 update doubled IOs   706 Rick James 03/20/2013 08:52AM
Re: MySQL 5.6 update doubled IOs   649 Dimitri Kravtchuk 03/21/2013 09:51AM
Re: MySQL 5.6 update doubled IOs   777 Christian Meisinger 03/26/2013 08:29AM
Re: MySQL 5.6 update doubled IOs   752 Dimitri Kravtchuk 03/27/2013 11:11AM
Re: MySQL 5.6 update doubled IOs   642 Rick James 03/27/2013 11:44PM
Re: MySQL 5.6 update doubled IOs   671 Christian Meisinger 03/28/2013 02:17AM
Re: MySQL 5.6 update doubled IOs   642 Dimitri Kravtchuk 03/28/2013 09:55AM
Re: MySQL 5.6 update doubled IOs   996 Christian Meisinger 03/29/2013 02:20AM
Re: MySQL 5.6 update doubled IOs   672 Dimitri Kravtchuk 03/29/2013 06:30AM
Re: MySQL 5.6 update doubled IOs   684 Christian Meisinger 03/29/2013 06:56AM
Re: MySQL 5.6 update doubled IOs   640 Dimitri Kravtchuk 03/29/2013 07:18AM
Re: MySQL 5.6 update doubled IOs   605 Christian Meisinger 03/29/2013 07:49AM
Re: MySQL 5.6 update doubled IOs   609 Dimitri Kravtchuk 03/29/2013 08:08AM
Re: MySQL 5.6 update doubled IOs   568 Christian Meisinger 03/29/2013 10:07AM
Re: MySQL 5.6 update doubled IOs   681 Rick James 03/28/2013 07:49PM
Re: MySQL 5.6 update doubled IOs   656 Christian Meisinger 03/29/2013 01:23AM
Re: MySQL 5.6 update doubled IOs   654 Olav Sandstå 04/02/2013 12:20AM
Re: MySQL 5.6 update doubled IOs   678 Øystein Grøvlen 04/02/2013 12:30AM
Re: MySQL 5.6 update doubled IOs   684 Øystein Grøvlen 04/02/2013 12:44AM
Re: MySQL 5.6 update doubled IOs   528 Christian Meisinger 04/02/2013 02:23AM
Re: MySQL 5.6 update doubled IOs   537 Rick James 04/02/2013 09:57PM
Re: MySQL 5.6 update doubled IOs   705 Øystein Grøvlen 04/03/2013 12:46AM
Re: MySQL 5.6 update doubled IOs   648 Dimitri Kravtchuk 04/03/2013 03:29AM
Re: MySQL 5.6 update doubled IOs   648 Christian Meisinger 04/05/2013 01:57AM
Re: MySQL 5.6 update doubled IOs   631 Dimitri Kravtchuk 04/05/2013 06:24AM
Re: MySQL 5.6 update doubled IOs   586 Christian Meisinger 04/10/2013 08:12AM
Re: MySQL 5.6 update doubled IOs   644 Olav Sandstå 04/10/2013 08:31AM
out of memory error   7,927 Christine Ross 04/08/2013 12:26PM
Re: out of memory error   2,252 Rick James 04/09/2013 09:23AM
Mysql DB server hits 400% CPU   1,530 Mannoj Kumar 04/04/2013 05:16AM
Re: Mysql DB server hits 400% CPU   550 Rick James 04/05/2013 09:41AM
4 GB RAM and runs so low the PC screams   1,250 Mike Jonsson 03/31/2013 12:36AM
Re: 4 GB RAM and runs so low the PC screams   589 Rick James 03/31/2013 09:51PM
Re: 4 GB RAM and runs so low the PC screams   1,028 Mike Jonsson 04/01/2013 03:12AM
Re: 4 GB RAM and runs so low the PC screams   548 Mike Jonsson 04/01/2013 12:48PM
Re: 4 GB RAM and runs so low the PC screams   588 Mike Jonsson 04/01/2013 04:56PM
Re: 4 GB RAM and runs so low the PC screams   568 Rick James 04/01/2013 10:53PM
Re: 4 GB RAM and runs so low the PC screams   540 Mike Jonsson 04/02/2013 01:38AM
Re: 4 GB RAM and runs so low the PC screams - resolved   736 Mike Jonsson 04/02/2013 04:00PM
Re: 4 GB RAM and runs so low the PC screams - resolved   551 Rick James 04/02/2013 07:54PM
Re: 4 GB RAM and runs so low the PC screams - resolved   494 Rick James 04/02/2013 08:45PM
Mysql is very slow but using CPU <10%   1,010 Percy Xu 03/22/2013 08:47AM
Re: Mysql is very slow but using CPU <10%   522 Rick James 03/23/2013 12:59PM
Re: Mysql is very slow but using CPU <10%   503 Mike Jonsson 03/31/2013 01:25AM
Performance over Leased Line 10 Mbit   1,684 Peter Konrady 03/27/2013 06:54AM
Re: Performance over Leased Line 10 Mbit   485 Rick James 03/28/2013 08:49AM
Re: Performance over Leased Line 10 Mbit   440 Dimitri Kravtchuk 03/28/2013 10:51AM
AUTO_INCREMENT PK best practices   1,093 Venkatesh Iyer 03/26/2013 11:14AM
Re: AUTO_INCREMENT PK best practices   387 Rick James 03/27/2013 11:23PM
Load Data Infile takes a long time   2,146 Venkatesh Iyer 03/15/2013 04:44PM
Re: Load Data Infile takes a long time   837 Rick James 03/16/2013 06:15PM
Re: Load Data Infile takes a long time   800 Venkatesh Iyer 03/17/2013 11:39PM
Re: Load Data Infile takes a long time   807 addision philip 03/17/2013 11:05PM
Re: Load Data Infile takes a long time   833 Øystein Grøvlen 03/18/2013 03:04AM
Re: Load Data Infile takes a long time   718 Rick James 03/19/2013 08:28PM
Re: Load Data Infile takes a long time   727 Venkatesh Iyer 03/20/2013 12:25PM
Re: Load Data Infile takes a long time   672 Rick James 03/20/2013 05:03PM
Re: Load Data Infile takes a long time   672 Venkatesh Iyer 03/26/2013 11:06AM
Problems encountered when testing with mysqlslap   1,008 Zhipan Wang 03/25/2013 12:50PM
mysql order by limit too slow, faster when making select a sub query   1,371 Mathew V 03/20/2013 01:54AM
Re: mysql order by limit too slow, faster when making select a sub query   623 Øystein Grøvlen 03/20/2013 05:39AM
Re: mysql order by limit too slow, faster when making select a sub query   657 Rick James 03/20/2013 09:07AM
Re: mysql order by limit too slow, faster when making select a sub query   1,910 Mathew V 03/20/2013 10:37PM
Re: mysql order by limit too slow, faster when making select a sub query   837 Rick James 03/21/2013 09:16AM
Re: mysql order by limit too slow, faster when making select a sub query   784 Øystein Grøvlen 03/22/2013 04:03AM
Re: mysql order by limit too slow, faster when making select a sub query   688 Rick James 03/23/2013 12:17AM
Strange behavior with queries using "limit"   1,126 Jagat P 03/21/2013 03:18PM
Re: Strange behavior with queries using "limit"   551 Jørgen Løland 03/22/2013 09:14AM
Re: Strange behavior with queries using "limit"   381 Rick James 03/23/2013 12:09AM
Optimizing a query with UNION   1,552 Matthew Devine 03/14/2013 03:28PM
Re: Optimizing a query with UNION   547 Peter Brawley 03/14/2013 09:08PM
Re: Optimizing a query with UNION   535 Rick James 03/14/2013 10:41PM
Re: Optimizing a query with UNION   850 Matthew Devine 03/15/2013 09:13AM
Re: Optimizing a query with UNION   638 Rick James 03/15/2013 11:32PM
Re: Optimizing a query with UNION   474 Matthew Devine 03/16/2013 05:29AM
Mad 5.5 performance on identical servers   940 Peter Konrady 03/12/2013 10:10AM
Re: Mad 5.5 performance on identical servers   423 Rick James 03/13/2013 11:43PM
Re: Mad 5.5 performance on identical servers   437 Peter Konrady 03/14/2013 09:47AM
Re: Mad 5.5 performance on identical servers   403 Rick James 03/15/2013 08:08AM
Explain   818 Alex Singh 03/06/2013 07:20AM
Re: Explain   454 Jeremy Smyth 03/06/2013 11:59AM
Re: Explain   416 Jørgen Løland 03/11/2013 01:43AM
Mysql : Completely strange performance behavior   1,033 dominique papin 02/28/2013 10:35AM
Re: Mysql : Completely strange performance behavior   566 dominique papin 02/28/2013 03:27PM
Re: Mysql : Completely strange performance behavior   506 Jørgen Løland 03/01/2013 07:13AM
Re: Mysql : Completely strange performance behavior   566 dominique papin 03/01/2013 08:03AM
Re: Mysql : Completely strange performance behavior   505 Jørgen Løland 03/01/2013 08:28AM
Re: Mysql : Completely strange performance behavior   585 Rick James 03/01/2013 08:41PM
Re: Mysql : Completely strange performance behavior   564 Jørgen Løland 03/04/2013 02:00AM
Re: Mysql : Completely strange performance behavior   561 Rick James 03/04/2013 11:55PM
Re: Mysql : Completely strange performance behavior   536 Øystein Grøvlen 03/04/2013 03:27AM
Case sensitive vs non case sensitive performance   1,732 Kjeld Flarup 02/27/2013 03:29AM
Re: Case sensitive vs non case sensitive performance   676 Rick James 02/28/2013 09:04AM
MySQL 5.6 disk requirements   1,220 justin edmands 02/25/2013 11:49AM
Re: MySQL 5.6 disk requirements   520 Rick James 02/26/2013 09:17AM
Re: MySQL 5.6 disk requirements   615 justin edmands 02/26/2013 01:44PM
Re: MySQL 5.6 disk requirements   457 Rick James 02/27/2013 11:17PM
INNODB large database performance   2,071 Paul Smith 02/16/2013 03:11AM
Re: INNODB large database performance   699 Rick James 02/20/2013 05:31PM
Re: INNODB large database performance   627 Paul Smith 02/21/2013 02:51AM
Re: INNODB large database performance   662 Rick James 02/21/2013 11:12PM
Re: INNODB large database performance   646 Paul Smith 02/22/2013 03:38AM
Re: INNODB large database performance   547 Rick James 02/23/2013 12:04AM
Re: INNODB large database performance   527 Paul Smith 02/23/2013 03:28PM
Re: INNODB large database performance   528 Rick James 02/24/2013 02:10PM
Re: INNODB large database performance   556 Paul Smith 02/24/2013 03:02PM
Re: INNODB large database performance   576 Rick James 02/25/2013 10:39PM
Problematic ALTER (empty) TABLE performance   1,055 Haron Media 02/20/2013 05:50AM
Re: Problematic ALTER (empty) TABLE performance   459 Rick James 02/21/2013 11:17PM
Re: Problematic ALTER (empty) TABLE performance   539 Haron Media 02/22/2013 02:58AM
Re: Problematic ALTER (empty) TABLE performance   453 Rick James 02/23/2013 12:16AM
Re: Problematic ALTER (empty) TABLE performance   515 Haron Media 02/23/2013 03:15AM
Re: Problematic ALTER (empty) TABLE performance   453 Rick James 02/23/2013 11:47PM
Help tunning MySQL 5.5 (query_cache_size, table_cache, ...)   4,187 Dimas Streich 02/18/2013 06:46AM
Re: Help tunning MySQL 5.5 (query_cache_size, table_cache, ...)   1,924 Rick James 02/20/2013 10:35PM
Adding limit clause takes query from 2 seconds to 42 minutes   1,503 Josh Higham 12/12/2012 03:53PM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   611 Øystein Grøvlen 12/19/2012 04:15AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   525 Rick James 12/22/2012 03:44PM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   582 Josh H 02/11/2013 11:22AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   603 aftab khan 12/24/2012 03:31AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   521 Josh H 02/11/2013 11:17AM
UPDATE with two table join is very slow   1,096 Meen Sathish 02/08/2013 10:45AM
Re: UPDATE with two table join is very slow   629 Rick James 02/09/2013 01:24PM
Slow query_time with heavy locking   1,552 Matthias Siebler 02/07/2013 04:29AM
Re: Slow query_time with heavy locking   660 Rick James 02/08/2013 10:11AM
Index and date functions   1,792 Aurelien PANIZZA 01/30/2013 10:30AM
Re: Index and date functions   821 Rick James 01/31/2013 10:22PM
Re: Index and date functions   881 Aurelien PANIZZA 02/04/2013 03:33AM
Re: Index and date functions   691 Aurelien PANIZZA 02/04/2013 10:45AM
Performance tuning - comparing two computers   1,775 Francis Mariani 01/23/2013 07:23PM
Re: Performance tuning - comparing two computers   688 Øystein Grøvlen 01/24/2013 03:15AM
Re: Performance tuning - comparing two computers   595 Francis Mariani 01/24/2013 09:27PM
Re: Performance tuning - comparing two computers   613 Rick James 01/24/2013 10:38PM
Re: Performance tuning - comparing two computers   617 Francis Mariani 01/25/2013 07:59PM
Re: Performance tuning - comparing two computers   588 Francis Mariani 01/25/2013 08:36PM
Re: Performance tuning - comparing two computers   587 Rick James 01/26/2013 12:11AM
Connections Sleeping not disconnecting   2,300 Nick Arnone 01/24/2013 02:32PM
Re: Connections Sleeping not disconnecting   845 Rick James 01/25/2013 08:14PM
Steps to Load ODBC driver   1,188 Norm Bailey 01/22/2013 10:34AM
Performance Tuning Tools   3,500 Robert Jackson 01/09/2013 04:29AM
Re: Performance Tuning Tools   1,635 Rick James 01/10/2013 09:08PM
Re: Performance Tuning Tools   1,479 akka lala 01/18/2013 03:52AM
Re: Performance Tuning Tools   1,040 Robert Jackson 01/19/2013 02:22PM
Help With mysqltuner Output   5,670 Ifechukwukwu Okobi 01/14/2013 05:33AM
Re: Help With mysqltuner Output   4,069 Rick James 01/15/2013 08:50AM
Re: Help With mysqltuner Output   2,039 Ifechukwukwu Okobi 01/15/2013 09:03AM
Re: Help With mysqltuner Output   1,782 Rick James 01/16/2013 07:41PM
Re: Help With mysqltuner Output   1,358 Ifechukwukwu Okobi 01/19/2013 12:18AM
Locks in slow-query-log   1,101 Alax James 01/15/2013 01:02AM
Re: Locks in slow-query-log   498 Rick James 01/15/2013 09:11PM
mysql query with modulus in where clause   1,520 sreedevi iyer 01/11/2013 03:02PM
Re: mysql query with modulus in where clause   894 Rick James 01/12/2013 11:13AM
buffer pool read/write?   1,549 Rizwan Mian 01/03/2013 08:38PM
Re: buffer pool read/write?   876 Rick James 01/05/2013 02:37PM
Re: buffer pool read/write?   614 Rizwan Mian 01/05/2013 04:50PM
Re: buffer pool read/write?   584 Rick James 01/06/2013 06:01PM
Re: buffer pool read/write?   489 aftab khan 01/08/2013 06:18AM
testing and optimizing mysql based app for a shared server   1,078 Kshitij Ahuja 12/29/2012 07:19AM
Re: testing and optimizing mysql based app for a shared server   588 Rick James 01/02/2013 05:06PM
Re: testing and optimizing mysql based app for a shared server   939 Kshitij Ahuja 01/03/2013 02:57AM
Re: testing and optimizing mysql based app for a shared server   551 aftab khan 01/03/2013 07:07AM
Re: testing and optimizing mysql based app for a shared server   595 Rick James 01/03/2013 07:37PM
Dead query   1,462 Pablo Worcel 12/21/2012 08:00AM
Re: Dead query   624 Rick James 12/22/2012 03:27PM
Re: Dead query   543 Øystein Grøvlen 01/03/2013 07:48AM
Performance on 2 table operations   1,056 Emre Bilgin 12/29/2012 03:23AM
Re: Performance on 2 table operations   555 Rick James 01/02/2013 04:59PM
Current Page: 5 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.