Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.23 has been released 07/31/2015 12:40PM
MySQL for Visual Studio 1.2.4 has been released 07/28/2015 01:57AM
MySQL Community Server 5.6.26 has been released 07/25/2015 05:53PM
MySQL Community Server 5.5.45 has been released 07/24/2015 10:33AM
MySQL Cluster 7.3.10 has been released 07/14/2015 07:14AM
Current Page: 5 of 70
Subject Views Written By Posted
Question on slow queries   1,577 Michele Quaini 05/30/2013 04:18AM
Re: Question on slow queries   466 Rick James 05/31/2013 05:14AM
Re: Question on slow queries   440 Michele Quaini 05/31/2013 06:09AM
Re: Question on slow queries   414 Rick James 06/01/2013 02:45PM
Re: Question on slow queries   584 Michele Quaini 06/04/2013 02:35AM
Re: Question on slow queries   557 Rick James 06/05/2013 11:27PM
Re: Question on slow queries   384 Michele Quaini 06/06/2013 02:02AM
Static, 120GB, InnoDB table is unusuable   1,092 Nicholas Hans 06/01/2013 09:24AM
Re: Static, 120GB, InnoDB table is unusuable   434 Rick James 06/01/2013 09:49PM
Re: Static, 120GB, InnoDB table is unusuable   459 Rick James 06/01/2013 10:51PM
Re: Static, 120GB, InnoDB table is unusuable   474 Nicholas Hans 06/01/2013 11:29PM
Re: Static, 120GB, InnoDB table is unusuable   469 Rick James 06/02/2013 08:33PM
Slow performance over network   1,246 Will Duckworth 05/30/2013 03:45AM
The mysql vs mysqli db driver for a php app - any clear cut winner?   772 Thomas Kazarian 05/23/2013 09:48AM
Re: The mysql vs mysqli db driver for a php app - any clear cut winner?   375 Rick James 05/25/2013 03:55PM
MySQL database drop insanely slow   3,054 Stephane Eybert 04/15/2013 01:31PM
Re: MySQL database drop insanely slow   900 Stephane Eybert 04/15/2013 04:01PM
Re: MySQL database drop insanely slow   894 Stephane Eybert 04/15/2013 04:04PM
Re: MySQL database drop insanely slow   769 Rick James 04/15/2013 10:11PM
Re: MySQL database drop insanely slow   790 Stephane Eybert 04/17/2013 10:10AM
Re: MySQL database drop insanely slow   747 Stephane Eybert 04/22/2013 05:44AM
Re: MySQL database drop insanely slow   658 Stephane Eybert 04/22/2013 06:32AM
Re: MySQL database drop insanely slow   655 Stephane Eybert 04/22/2013 05:57AM
Re: MySQL database drop insanely slow   773 Rick James 04/23/2013 08:30AM
Re: MySQL database drop insanely slow   653 Stephane Eybert 05/25/2013 11:01AM
Re: MySQL database drop insanely slow   721 Stephane Eybert 04/22/2013 06:25AM
Re: MySQL database drop insanely slow   682 Stephane Eybert 04/22/2013 06:46AM
High CPU usage in %user   17,007 Marco Ramirez 05/14/2013 12:31PM
Re: High CPU usage in %user   3,051 Rick James 05/15/2013 08:00PM
Re: High CPU usage in %user   2,577 Marco Ramirez 05/16/2013 02:22AM
Re: High CPU usage in %user   2,162 Rick James 05/16/2013 09:46PM
Queries locking up   1,025 Thomas Kazarian 05/07/2013 01:13PM
Re: Queries locking up   450 Rick James 05/08/2013 08:50PM
Re: Queries locking up   372 Thomas Kazarian 05/09/2013 10:09PM
Re: Queries locking up   508 Rick James 05/11/2013 11:29PM
Re: Queries locking up   376 Thomas Kazarian 05/15/2013 09:33PM
Composite index - selecting components and order   996 Rick Ingram 05/04/2013 10:54AM
Re: Composite index - selecting components and order   434 Rick James 05/06/2013 07:47PM
Re: Composite index - selecting components and order   441 Rick Ingram 05/06/2013 10:47PM
Re: Composite index - selecting components and order   495 Rick James 05/07/2013 08:05PM
Re: Composite index - selecting components and order   395 Rick Ingram 05/07/2013 08:40PM
Re: Composite index - selecting components and order   448 Rick Ingram 05/08/2013 06:55AM
Re: Composite index - selecting components and order   404 Rick James 05/08/2013 08:45PM
Re: Composite index - selecting components and order   423 Rick Ingram 05/08/2013 09:54PM
Re: Composite index - selecting components and order   721 Rick James 05/09/2013 10:46PM
Re: Composite index - selecting components and order   401 Rick Ingram 05/09/2013 10:56PM
How MySQL Uses Indexes   902 Mola Ji 05/04/2013 08:28AM
Re: How MySQL Uses Indexes   445 Øystein Grøvlen 05/06/2013 03:46AM
Re: How MySQL Uses Indexes   486 Mola Ji 05/06/2013 10:31AM
Re: How MySQL Uses Indexes   478 Rick James 05/06/2013 07:57PM
Re: How MySQL Uses Indexes   436 Mola Ji 05/07/2013 12:24PM
Re: How MySQL Uses Indexes   455 Rick James 05/07/2013 07:47PM
Re: How MySQL Uses Indexes   416 Mola Ji 05/08/2013 05:33AM
Re: How MySQL Uses Indexes   405 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,648 James Marcus 05/01/2013 11:32AM
Re: Hardware sizing tools   774 Rick James 05/02/2013 07:38AM
Re: Hardware sizing tools   727 James Marcus 05/03/2013 11:24AM
Re: Hardware sizing tools   641 Rick James 05/04/2013 01:34PM
cache not used with restricted privileges ?   876 brocu lus 04/30/2013 02:44AM
Re: cache not used with restricted privileges ?   414 Rick James 05/01/2013 11:57PM
Re: cache not used with restricted privileges ?   435 brocu lus 05/02/2013 08:35AM
Re: QUERY cache not used with restricted privileges ?   426 Rick James 05/03/2013 09:32AM
partitioning every year data   939 mohamed bashid s 04/13/2013 07:20PM
Re: partitioning every year data   462 Mikael Ronström 04/24/2013 12:30PM
Re: partitioning every year data   430 mohamed bashid s 04/29/2013 04:53AM
Re: partitioning every year data   484 Rick James 05/02/2013 12:00AM
Re: partitioning every year data   449 mohamed bashid s 05/02/2013 02:59AM
Re: partitioning every year data   438 Rick James 05/02/2013 07:57AM
In-memory dB on Embedded system   1,116 Sandhya Srinivas 04/24/2013 03:58AM
Re: In-memory dB on Embedded system   536 Rick James 04/24/2013 10:51PM
mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   6,776 Meteor SY 04/22/2013 09:03AM
Re: mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   2,440 Meteor SY 04/22/2013 07:31PM
Re: mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   2,423 Rick James 04/23/2013 11:22PM
pattern matching with LIKE or REGEXP   979 Oka Putra 04/21/2013 10:05AM
Re: pattern matching with LIKE or REGEXP   414 Rick James 04/23/2013 08:33AM
Simple join taking longer than it should   954 Kenneth Mitchner 04/16/2013 02:02PM
Re: Simple join taking longer than it should   396 Rick James 04/17/2013 09:04PM
Sortable columns dilemma   876 Patrick Clas 04/13/2013 11:28AM
Re: Sortable columns dilemma   376 Rick James 04/14/2013 01:09PM
Insertion performance degrade with large index   1,154 holy holy 04/11/2013 02:36AM
Re: Insertion performance degrade with large index   535 Rick James 04/11/2013 10:08PM
Re: Insertion performance degrade with large index   449 holy holy 04/12/2013 12:51AM
Re: Insertion performance degrade with large index   462 Rick James 04/12/2013 08:23PM
handle multiple years data   814 mohamed bashid s 02/27/2013 12:50AM
Re: handle multiple years data   520 Rick James 02/27/2013 11:23PM
Re: handle multiple years data   416 mohamed bashid s 04/12/2013 06:38AM
MySQL 5.6 update doubled IOs   1,566 Christian Meisinger 03/18/2013 08:33AM
Re: MySQL 5.6 update doubled IOs   675 Christian Meisinger 03/19/2013 08:58AM
Re: MySQL 5.6 update doubled IOs   716 Rick James 03/20/2013 08:52AM
Re: MySQL 5.6 update doubled IOs   656 Dimitri Kravtchuk 03/21/2013 09:51AM
Re: MySQL 5.6 update doubled IOs   793 Christian Meisinger 03/26/2013 08:29AM
Re: MySQL 5.6 update doubled IOs   760 Dimitri Kravtchuk 03/27/2013 11:11AM
Re: MySQL 5.6 update doubled IOs   648 Rick James 03/27/2013 11:44PM
Re: MySQL 5.6 update doubled IOs   678 Christian Meisinger 03/28/2013 02:17AM
Re: MySQL 5.6 update doubled IOs   654 Dimitri Kravtchuk 03/28/2013 09:55AM
Re: MySQL 5.6 update doubled IOs   1,007 Christian Meisinger 03/29/2013 02:20AM
Re: MySQL 5.6 update doubled IOs   681 Dimitri Kravtchuk 03/29/2013 06:30AM
Re: MySQL 5.6 update doubled IOs   696 Christian Meisinger 03/29/2013 06:56AM
Re: MySQL 5.6 update doubled IOs   648 Dimitri Kravtchuk 03/29/2013 07:18AM
Re: MySQL 5.6 update doubled IOs   616 Christian Meisinger 03/29/2013 07:49AM
Re: MySQL 5.6 update doubled IOs   621 Dimitri Kravtchuk 03/29/2013 08:08AM
Re: MySQL 5.6 update doubled IOs   578 Christian Meisinger 03/29/2013 10:07AM
Re: MySQL 5.6 update doubled IOs   689 Rick James 03/28/2013 07:49PM
Re: MySQL 5.6 update doubled IOs   664 Christian Meisinger 03/29/2013 01:23AM
Re: MySQL 5.6 update doubled IOs   665 Olav Sandstå 04/02/2013 12:20AM
Re: MySQL 5.6 update doubled IOs   691 Øystein Grøvlen 04/02/2013 12:30AM
Re: MySQL 5.6 update doubled IOs   693 Øystein Grøvlen 04/02/2013 12:44AM
Re: MySQL 5.6 update doubled IOs   539 Christian Meisinger 04/02/2013 02:23AM
Re: MySQL 5.6 update doubled IOs   549 Rick James 04/02/2013 09:57PM
Re: MySQL 5.6 update doubled IOs   718 Øystein Grøvlen 04/03/2013 12:46AM
Re: MySQL 5.6 update doubled IOs   656 Dimitri Kravtchuk 04/03/2013 03:29AM
Re: MySQL 5.6 update doubled IOs   658 Christian Meisinger 04/05/2013 01:57AM
Re: MySQL 5.6 update doubled IOs   647 Dimitri Kravtchuk 04/05/2013 06:24AM
Re: MySQL 5.6 update doubled IOs   601 Christian Meisinger 04/10/2013 08:12AM
Re: MySQL 5.6 update doubled IOs   657 Olav Sandstå 04/10/2013 08:31AM
out of memory error   8,061 Christine Ross 04/08/2013 12:26PM
Re: out of memory error   2,290 Rick James 04/09/2013 09:23AM
Mysql DB server hits 400% CPU   1,571 Mannoj Kumar 04/04/2013 05:16AM
Re: Mysql DB server hits 400% CPU   565 Rick James 04/05/2013 09:41AM
4 GB RAM and runs so low the PC screams   1,261 Mike Jonsson 03/31/2013 12:36AM
Re: 4 GB RAM and runs so low the PC screams   596 Rick James 03/31/2013 09:51PM
Re: 4 GB RAM and runs so low the PC screams   1,074 Mike Jonsson 04/01/2013 03:12AM
Re: 4 GB RAM and runs so low the PC screams   557 Mike Jonsson 04/01/2013 12:48PM
Re: 4 GB RAM and runs so low the PC screams   596 Mike Jonsson 04/01/2013 04:56PM
Re: 4 GB RAM and runs so low the PC screams   574 Rick James 04/01/2013 10:53PM
Re: 4 GB RAM and runs so low the PC screams   545 Mike Jonsson 04/02/2013 01:38AM
Re: 4 GB RAM and runs so low the PC screams - resolved   742 Mike Jonsson 04/02/2013 04:00PM
Re: 4 GB RAM and runs so low the PC screams - resolved   559 Rick James 04/02/2013 07:54PM
Re: 4 GB RAM and runs so low the PC screams - resolved   499 Rick James 04/02/2013 08:45PM
Mysql is very slow but using CPU <10%   1,022 Percy Xu 03/22/2013 08:47AM
Re: Mysql is very slow but using CPU <10%   530 Rick James 03/23/2013 12:59PM
Re: Mysql is very slow but using CPU <10%   512 Mike Jonsson 03/31/2013 01:25AM
Performance over Leased Line 10 Mbit   1,705 Peter Konrady 03/27/2013 06:54AM
Re: Performance over Leased Line 10 Mbit   491 Rick James 03/28/2013 08:49AM
Re: Performance over Leased Line 10 Mbit   445 Dimitri Kravtchuk 03/28/2013 10:51AM
AUTO_INCREMENT PK best practices   1,119 Venkatesh Iyer 03/26/2013 11:14AM
Re: AUTO_INCREMENT PK best practices   392 Rick James 03/27/2013 11:23PM
Load Data Infile takes a long time   2,181 Venkatesh Iyer 03/15/2013 04:44PM
Re: Load Data Infile takes a long time   849 Rick James 03/16/2013 06:15PM
Re: Load Data Infile takes a long time   813 Venkatesh Iyer 03/17/2013 11:39PM
Re: Load Data Infile takes a long time   821 addision philip 03/17/2013 11:05PM
Re: Load Data Infile takes a long time   848 Øystein Grøvlen 03/18/2013 03:04AM
Re: Load Data Infile takes a long time   728 Rick James 03/19/2013 08:28PM
Re: Load Data Infile takes a long time   739 Venkatesh Iyer 03/20/2013 12:25PM
Re: Load Data Infile takes a long time   679 Rick James 03/20/2013 05:03PM
Re: Load Data Infile takes a long time   682 Venkatesh Iyer 03/26/2013 11:06AM
Problems encountered when testing with mysqlslap   1,019 Zhipan Wang 03/25/2013 12:50PM
mysql order by limit too slow, faster when making select a sub query   1,395 Mathew V 03/20/2013 01:54AM
Re: mysql order by limit too slow, faster when making select a sub query   632 Øystein Grøvlen 03/20/2013 05:39AM
Re: mysql order by limit too slow, faster when making select a sub query   664 Rick James 03/20/2013 09:07AM
Re: mysql order by limit too slow, faster when making select a sub query   1,969 Mathew V 03/20/2013 10:37PM
Re: mysql order by limit too slow, faster when making select a sub query   848 Rick James 03/21/2013 09:16AM
Re: mysql order by limit too slow, faster when making select a sub query   794 Øystein Grøvlen 03/22/2013 04:03AM
Re: mysql order by limit too slow, faster when making select a sub query   702 Rick James 03/23/2013 12:17AM
Strange behavior with queries using "limit"   1,145 Jagat P 03/21/2013 03:18PM
Re: Strange behavior with queries using "limit"   562 Jørgen Løland 03/22/2013 09:14AM
Re: Strange behavior with queries using "limit"   386 Rick James 03/23/2013 12:09AM
Optimizing a query with UNION   1,592 Matthew Devine 03/14/2013 03:28PM
Re: Optimizing a query with UNION   553 Peter Brawley 03/14/2013 09:08PM
Re: Optimizing a query with UNION   540 Rick James 03/14/2013 10:41PM
Re: Optimizing a query with UNION   864 Matthew Devine 03/15/2013 09:13AM
Re: Optimizing a query with UNION   650 Rick James 03/15/2013 11:32PM
Re: Optimizing a query with UNION   486 Matthew Devine 03/16/2013 05:29AM
Mad 5.5 performance on identical servers   950 Peter Konrady 03/12/2013 10:10AM
Re: Mad 5.5 performance on identical servers   429 Rick James 03/13/2013 11:43PM
Re: Mad 5.5 performance on identical servers   440 Peter Konrady 03/14/2013 09:47AM
Re: Mad 5.5 performance on identical servers   407 Rick James 03/15/2013 08:08AM
Explain   829 Alex Singh 03/06/2013 07:20AM
Re: Explain   463 Jeremy Smyth 03/06/2013 11:59AM
Re: Explain   420 Jørgen Løland 03/11/2013 01:43AM
Mysql : Completely strange performance behavior   1,044 dominique papin 02/28/2013 10:35AM
Re: Mysql : Completely strange performance behavior   572 dominique papin 02/28/2013 03:27PM
Re: Mysql : Completely strange performance behavior   513 Jørgen Løland 03/01/2013 07:13AM
Re: Mysql : Completely strange performance behavior   571 dominique papin 03/01/2013 08:03AM
Re: Mysql : Completely strange performance behavior   512 Jørgen Løland 03/01/2013 08:28AM
Re: Mysql : Completely strange performance behavior   593 Rick James 03/01/2013 08:41PM
Re: Mysql : Completely strange performance behavior   572 Jørgen Løland 03/04/2013 02:00AM
Re: Mysql : Completely strange performance behavior   564 Rick James 03/04/2013 11:55PM
Re: Mysql : Completely strange performance behavior   542 Øystein Grøvlen 03/04/2013 03:27AM
Case sensitive vs non case sensitive performance   1,770 Kjeld Flarup 02/27/2013 03:29AM
Re: Case sensitive vs non case sensitive performance   691 Rick James 02/28/2013 09:04AM
MySQL 5.6 disk requirements   1,244 justin edmands 02/25/2013 11:49AM
Re: MySQL 5.6 disk requirements   525 Rick James 02/26/2013 09:17AM
Re: MySQL 5.6 disk requirements   624 justin edmands 02/26/2013 01:44PM
Re: MySQL 5.6 disk requirements   463 Rick James 02/27/2013 11:17PM
INNODB large database performance   2,096 Paul Smith 02/16/2013 03:11AM
Re: INNODB large database performance   706 Rick James 02/20/2013 05:31PM
Re: INNODB large database performance   632 Paul Smith 02/21/2013 02:51AM
Re: INNODB large database performance   671 Rick James 02/21/2013 11:12PM
Re: INNODB large database performance   659 Paul Smith 02/22/2013 03:38AM
Re: INNODB large database performance   555 Rick James 02/23/2013 12:04AM
Re: INNODB large database performance   535 Paul Smith 02/23/2013 03:28PM
Re: INNODB large database performance   534 Rick James 02/24/2013 02:10PM
Re: INNODB large database performance   564 Paul Smith 02/24/2013 03:02PM
Re: INNODB large database performance   582 Rick James 02/25/2013 10:39PM
Problematic ALTER (empty) TABLE performance   1,076 Haron Media 02/20/2013 05:50AM
Re: Problematic ALTER (empty) TABLE performance   470 Rick James 02/21/2013 11:17PM
Re: Problematic ALTER (empty) TABLE performance   549 Haron Media 02/22/2013 02:58AM
Re: Problematic ALTER (empty) TABLE performance   462 Rick James 02/23/2013 12:16AM
Re: Problematic ALTER (empty) TABLE performance   525 Haron Media 02/23/2013 03:15AM
Re: Problematic ALTER (empty) TABLE performance   462 Rick James 02/23/2013 11:47PM
Help tunning MySQL 5.5 (query_cache_size, table_cache, ...)   4,267 Dimas Streich 02/18/2013 06:46AM
Re: Help tunning MySQL 5.5 (query_cache_size, table_cache, ...)   1,961 Rick James 02/20/2013 10:35PM
Adding limit clause takes query from 2 seconds to 42 minutes   1,520 Josh Higham 12/12/2012 03:53PM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   617 Øystein Grøvlen 12/19/2012 04:15AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   529 Rick James 12/22/2012 03:44PM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   588 Josh H 02/11/2013 11:22AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   610 aftab khan 12/24/2012 03:31AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   526 Josh H 02/11/2013 11:17AM
UPDATE with two table join is very slow   1,104 Meen Sathish 02/08/2013 10:45AM
Re: UPDATE with two table join is very slow   638 Rick James 02/09/2013 01:24PM
Slow query_time with heavy locking   1,573 Matthias Siebler 02/07/2013 04:29AM
Re: Slow query_time with heavy locking   666 Rick James 02/08/2013 10:11AM
Index and date functions   1,838 Aurelien PANIZZA 01/30/2013 10:30AM
Re: Index and date functions   834 Rick James 01/31/2013 10:22PM
Re: Index and date functions   895 Aurelien PANIZZA 02/04/2013 03:33AM
Re: Index and date functions   701 Aurelien PANIZZA 02/04/2013 10:45AM
Performance tuning - comparing two computers   1,799 Francis Mariani 01/23/2013 07:23PM
Re: Performance tuning - comparing two computers   694 Øystein Grøvlen 01/24/2013 03:15AM
Re: Performance tuning - comparing two computers   600 Francis Mariani 01/24/2013 09:27PM
Re: Performance tuning - comparing two computers   619 Rick James 01/24/2013 10:38PM
Re: Performance tuning - comparing two computers   626 Francis Mariani 01/25/2013 07:59PM
Re: Performance tuning - comparing two computers   593 Francis Mariani 01/25/2013 08:36PM
Re: Performance tuning - comparing two computers   591 Rick James 01/26/2013 12:11AM
Connections Sleeping not disconnecting   2,350 Nick Arnone 01/24/2013 02:32PM
Re: Connections Sleeping not disconnecting   852 Rick James 01/25/2013 08:14PM
Steps to Load ODBC driver   1,204 Norm Bailey 01/22/2013 10:34AM
Performance Tuning Tools   3,572 Robert Jackson 01/09/2013 04:29AM
Re: Performance Tuning Tools   1,660 Rick James 01/10/2013 09:08PM
Re: Performance Tuning Tools   1,505 akka lala 01/18/2013 03:52AM
Re: Performance Tuning Tools   1,056 Robert Jackson 01/19/2013 02:22PM
Help With mysqltuner Output   5,773 Ifechukwukwu Okobi 01/14/2013 05:33AM
Re: Help With mysqltuner Output   4,165 Rick James 01/15/2013 08:50AM
Re: Help With mysqltuner Output   2,067 Ifechukwukwu Okobi 01/15/2013 09:03AM
Re: Help With mysqltuner Output   1,815 Rick James 01/16/2013 07:41PM
Re: Help With mysqltuner Output   1,384 Ifechukwukwu Okobi 01/19/2013 12:18AM
Locks in slow-query-log   1,114 Alax James 01/15/2013 01:02AM
Re: Locks in slow-query-log   501 Rick James 01/15/2013 09:11PM
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.