Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Workbench 6.0: BETA 1 released 06/13/2013 07:45PM
MySQL Community Server 5.1.70 has been released 06/06/2013 08:19AM
MySQL Community Server 5.5.32 has been released 06/06/2013 07:58AM
MySQL Community Server 5.6.12 has been released 06/06/2013 07:36AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 66
Subject Views Written By Posted
Sticky:  MySQL 5.6: Detailed Profiling of SQL Activity (1 Posts)   164 Edwin Desouza 05/20/2013 10:02AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   659 Edwin Desouza 02/12/2013 06:11PM
Sticky:  FREE! MySQL Health Check (1 Posts)   579 Edwin Desouza 02/07/2013 10:16PM
Sticky:  MySQL 5.6: Server Default Config changes - my.cnf and my.ini (1 Posts)   1,092 Edwin DeSouza 12/12/2012 08:19PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   3,491 Edwin DeSouza 08/04/2011 09:09AM
Sticky:  Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server (1 Posts)   5,302 Edwin DeSouza 10/21/2010 11:13AM
Sticky:  MySQL Performance Schema: A Big Bag of Epic Awesomeness (1 Posts)   8,535 Edwin DeSouza 02/05/2009 07:25PM
Sticky:  MySQL Performance Tuning: Best Practices, FAQs, How-To, Articles, Blogs (1 Posts)   149,663 Edwin DeSouza 05/25/2006 10:50AM
How to read slow.txt?   19 Gaurav Khanna 06/19/2013 02:46AM
Very slow query   46 Aram Mirzadeh 06/15/2013 07:31PM
Re: Very slow query   15 Rick James 06/16/2013 10:09PM
Re: Very slow query   14 Aram Mirzadeh 06/17/2013 05:40AM
Re: Very slow query   5 Rick James 06/18/2013 08:59PM
1 row Update query long for short duration   64 karl lauritzen 06/11/2013 10:14AM
Re: 1 row Update query long for short duration   19 karl lauritzen 06/11/2013 11:32AM
Re: 1 row Update query long for short duration   18 Rick James 06/13/2013 09:11AM
Re: 1 row Update query long for short duration   20 karl lauritzen 06/13/2013 09:53AM
Re: 1 row Update query long for short duration   14 Rick James 06/14/2013 11:17PM
how mysqlslap support utf8 encoding   86 Edward Zeng 06/05/2013 10:04AM
Re: how mysqlslap support utf8 encoding   30 Rick James 06/08/2013 06:03AM
Question on slow queries   147 Michele Quaini 05/30/2013 04:18AM
Re: Question on slow queries   53 Rick James 05/31/2013 05:14AM
Re: Question on slow queries   48 Michele Quaini 05/31/2013 06:09AM
Re: Question on slow queries   44 Rick James 06/01/2013 02:45PM
Re: Question on slow queries   43 Michele Quaini 06/04/2013 02:35AM
Re: Question on slow queries   34 Rick James 06/05/2013 11:27PM
Re: Question on slow queries   31 Michele Quaini 06/06/2013 02:02AM
Static, 120GB, InnoDB table is unusuable   122 Nicholas Hans 06/01/2013 09:24AM
Re: Static, 120GB, InnoDB table is unusuable   45 Rick James 06/01/2013 09:49PM
Re: Static, 120GB, InnoDB table is unusuable   48 Rick James 06/01/2013 10:51PM
Re: Static, 120GB, InnoDB table is unusuable   47 Nicholas Hans 06/01/2013 11:29PM
Re: Static, 120GB, InnoDB table is unusuable   41 Rick James 06/02/2013 08:33PM
Slow performance over network   132 Will Duckworth 05/30/2013 03:45AM
The mysql vs mysqli db driver for a php app - any clear cut winner?   152 Thomas Kazarian 05/23/2013 09:48AM
Re: The mysql vs mysqli db driver for a php app - any clear cut winner?   63 Rick James 05/25/2013 03:55PM
MySQL database drop insanely slow   369 Stephane Eybert 04/15/2013 01:31PM
Re: MySQL database drop insanely slow   128 Stephane Eybert 04/15/2013 04:01PM
Re: MySQL database drop insanely slow   134 Stephane Eybert 04/15/2013 04:04PM
Re: MySQL database drop insanely slow   134 Rick James 04/15/2013 10:11PM
Re: MySQL database drop insanely slow   116 Stephane Eybert 04/17/2013 10:10AM
Re: MySQL database drop insanely slow   113 Stephane Eybert 04/22/2013 05:44AM
Re: MySQL database drop insanely slow   113 Stephane Eybert 04/22/2013 06:32AM
Re: MySQL database drop insanely slow   112 Stephane Eybert 04/22/2013 05:57AM
Re: MySQL database drop insanely slow   126 Rick James 04/23/2013 08:30AM
Re: MySQL database drop insanely slow   52 Stephane Eybert 05/25/2013 11:01AM
Re: MySQL database drop insanely slow   123 Stephane Eybert 04/22/2013 06:25AM
Re: MySQL database drop insanely slow   116 Stephane Eybert 04/22/2013 06:46AM
High CPU usage in %user   377 Marco Ramirez 05/14/2013 12:31PM
Re: High CPU usage in %user   99 Rick James 05/15/2013 08:00PM
Re: High CPU usage in %user   109 Marco Ramirez 05/16/2013 02:22AM
Re: High CPU usage in %user   98 Rick James 05/16/2013 09:46PM
Queries locking up   202 Thomas Kazarian 05/07/2013 01:13PM
Re: Queries locking up   89 Rick James 05/08/2013 08:50PM
Re: Queries locking up   71 Thomas Kazarian 05/09/2013 10:09PM
Re: Queries locking up   69 Rick James 05/11/2013 11:29PM
Re: Queries locking up   59 Thomas Kazarian 05/15/2013 09:33PM
Composite index - selecting components and order   198 Rick Ingram 05/04/2013 10:54AM
Re: Composite index - selecting components and order   83 Rick James 05/06/2013 07:47PM
Re: Composite index - selecting components and order   85 Rick Ingram 05/06/2013 10:47PM
Re: Composite index - selecting components and order   79 Rick James 05/07/2013 08:05PM
Re: Composite index - selecting components and order   72 Rick Ingram 05/07/2013 08:40PM
Re: Composite index - selecting components and order   77 Rick Ingram 05/08/2013 06:55AM
Re: Composite index - selecting components and order   77 Rick James 05/08/2013 08:45PM
Re: Composite index - selecting components and order   75 Rick Ingram 05/08/2013 09:54PM
Re: Composite index - selecting components and order   77 Rick James 05/09/2013 10:46PM
Re: Composite index - selecting components and order   70 Rick Ingram 05/09/2013 10:56PM
How MySQL Uses Indexes   217 Mola Ji 05/04/2013 08:28AM
Re: How MySQL Uses Indexes   92 Øystein Grøvlen 05/06/2013 03:46AM
Re: How MySQL Uses Indexes   99 Mola Ji 05/06/2013 10:31AM
Re: How MySQL Uses Indexes   80 Rick James 05/06/2013 07:57PM
Re: How MySQL Uses Indexes   73 Mola Ji 05/07/2013 12:24PM
Re: How MySQL Uses Indexes   71 Rick James 05/07/2013 07:47PM
Re: How MySQL Uses Indexes   75 Mola Ji 05/08/2013 05:33AM
Re: How MySQL Uses Indexes   72 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   252 James Marcus 05/01/2013 11:32AM
Re: Hardware sizing tools   120 Rick James 05/02/2013 07:38AM
Re: Hardware sizing tools   121 James Marcus 05/03/2013 11:24AM
Re: Hardware sizing tools   107 Rick James 05/04/2013 01:34PM
cache not used with restricted privileges ?   237 brocu lus 04/30/2013 02:44AM
Re: cache not used with restricted privileges ?   96 Rick James 05/01/2013 11:57PM
Re: cache not used with restricted privileges ?   87 brocu lus 05/02/2013 08:35AM
Re: QUERY cache not used with restricted privileges ?   86 Rick James 05/03/2013 09:32AM
partitioning every year data   286 mohamed bashid s 04/13/2013 07:20PM
Re: partitioning every year data   106 Mikael Ronström 04/24/2013 12:30PM
Re: partitioning every year data   95 mohamed bashid s 04/29/2013 04:53AM
Re: partitioning every year data   95 Rick James 05/02/2013 12:00AM
Re: partitioning every year data   93 mohamed bashid s 05/02/2013 02:59AM
Re: partitioning every year data   81 Rick James 05/02/2013 07:57AM
In-memory dB on Embedded system   265 Sandhya Srinivas 04/24/2013 03:58AM
Re: In-memory dB on Embedded system   121 Rick James 04/24/2013 10:51PM
mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   360 Meteor SY 04/22/2013 09:03AM
Re: mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   148 Meteor SY 04/22/2013 07:31PM
Re: mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   149 Rick James 04/23/2013 11:22PM
pattern matching with LIKE or REGEXP   231 Oka Putra 04/21/2013 10:05AM
Re: pattern matching with LIKE or REGEXP   104 Rick James 04/23/2013 08:33AM
Simple join taking longer than it should   286 Kenneth Mitchner 04/16/2013 02:02PM
Re: Simple join taking longer than it should   112 Rick James 04/17/2013 09:04PM
Sortable columns dilemma   277 Patrick Clas 04/13/2013 11:28AM
Re: Sortable columns dilemma   113 Rick James 04/14/2013 01:09PM
Insertion performance degrade with large index   283 holy holy 04/11/2013 02:36AM
Re: Insertion performance degrade with large index   145 Rick James 04/11/2013 10:08PM
Re: Insertion performance degrade with large index   140 holy holy 04/12/2013 12:51AM
Re: Insertion performance degrade with large index   126 Rick James 04/12/2013 08:23PM
handle multiple years data   389 mohamed bashid s 02/27/2013 12:50AM
Re: handle multiple years data   205 Rick James 02/27/2013 11:23PM
Re: handle multiple years data   128 mohamed bashid s 04/12/2013 06:38AM
MySQL 5.6 update doubled IOs   531 Christian Meisinger 03/18/2013 08:33AM
Re: MySQL 5.6 update doubled IOs   228 Christian Meisinger 03/19/2013 08:58AM
Re: MySQL 5.6 update doubled IOs   205 Rick James 03/20/2013 08:52AM
Re: MySQL 5.6 update doubled IOs   219 Dimitri Kravtchuk 03/21/2013 09:51AM
Re: MySQL 5.6 update doubled IOs   254 Christian Meisinger 03/26/2013 08:29AM
Re: MySQL 5.6 update doubled IOs   199 Dimitri Kravtchuk 03/27/2013 11:11AM
Re: MySQL 5.6 update doubled IOs   179 Rick James 03/27/2013 11:44PM
Re: MySQL 5.6 update doubled IOs   202 Christian Meisinger 03/28/2013 02:17AM
Re: MySQL 5.6 update doubled IOs   191 Dimitri Kravtchuk 03/28/2013 09:55AM
Re: MySQL 5.6 update doubled IOs   224 Christian Meisinger 03/29/2013 02:20AM
Re: MySQL 5.6 update doubled IOs   185 Dimitri Kravtchuk 03/29/2013 06:30AM
Re: MySQL 5.6 update doubled IOs   184 Christian Meisinger 03/29/2013 06:56AM
Re: MySQL 5.6 update doubled IOs   162 Dimitri Kravtchuk 03/29/2013 07:18AM
Re: MySQL 5.6 update doubled IOs   182 Christian Meisinger 03/29/2013 07:49AM
Re: MySQL 5.6 update doubled IOs   166 Dimitri Kravtchuk 03/29/2013 08:08AM
Re: MySQL 5.6 update doubled IOs   178 Christian Meisinger 03/29/2013 10:07AM
Re: MySQL 5.6 update doubled IOs   176 Rick James 03/28/2013 07:49PM
Re: MySQL 5.6 update doubled IOs   185 Christian Meisinger 03/29/2013 01:23AM
Re: MySQL 5.6 update doubled IOs   164 Olav Sandstå 04/02/2013 12:20AM
Re: MySQL 5.6 update doubled IOs   184 Øystein Grøvlen 04/02/2013 12:30AM
Re: MySQL 5.6 update doubled IOs   165 Øystein Grøvlen 04/02/2013 12:44AM
Re: MySQL 5.6 update doubled IOs   164 Christian Meisinger 04/02/2013 02:23AM
Re: MySQL 5.6 update doubled IOs   179 Rick James 04/02/2013 09:57PM
Re: MySQL 5.6 update doubled IOs   168 Øystein Grøvlen 04/03/2013 12:46AM
Re: MySQL 5.6 update doubled IOs   167 Dimitri Kravtchuk 04/03/2013 03:29AM
Re: MySQL 5.6 update doubled IOs   154 Christian Meisinger 04/05/2013 01:57AM
Re: MySQL 5.6 update doubled IOs   162 Dimitri Kravtchuk 04/05/2013 06:24AM
Re: MySQL 5.6 update doubled IOs   129 Christian Meisinger 04/10/2013 08:12AM
Re: MySQL 5.6 update doubled IOs   168 Olav Sandstå 04/10/2013 08:31AM
out of memory error   324 Christine Ross 04/08/2013 12:26PM
Re: out of memory error   151 Rick James 04/09/2013 09:23AM
Mysql DB server hits 400% CPU   345 Mannoj Kumar 04/04/2013 05:16AM
Re: Mysql DB server hits 400% CPU   158 Rick James 04/05/2013 09:41AM
4 GB RAM and runs so low the PC screams   377 Mike Jonsson 03/31/2013 12:36AM
Re: 4 GB RAM and runs so low the PC screams   190 Rick James 03/31/2013 09:51PM
Re: 4 GB RAM and runs so low the PC screams   176 Mike Jonsson 04/01/2013 03:12AM
Re: 4 GB RAM and runs so low the PC screams   164 Mike Jonsson 04/01/2013 12:48PM
Re: 4 GB RAM and runs so low the PC screams   160 Mike Jonsson 04/01/2013 04:56PM
Re: 4 GB RAM and runs so low the PC screams   155 Rick James 04/01/2013 10:53PM
Re: 4 GB RAM and runs so low the PC screams   192 Mike Jonsson 04/02/2013 01:38AM
Re: 4 GB RAM and runs so low the PC screams - resolved   161 Mike Jonsson 04/02/2013 04:00PM
Re: 4 GB RAM and runs so low the PC screams - resolved   164 Rick James 04/02/2013 07:54PM
Re: 4 GB RAM and runs so low the PC screams - resolved   149 Rick James 04/02/2013 08:45PM
Mysql is very slow but using CPU <10%   405 Percy Xu 03/22/2013 08:47AM
Re: Mysql is very slow but using CPU <10%   216 Rick James 03/23/2013 12:59PM
Re: Mysql is very slow but using CPU <10%   166 Mike Jonsson 03/31/2013 01:25AM
Performance over Leased Line 10 Mbit   368 Peter Konrady 03/27/2013 06:54AM
Re: Performance over Leased Line 10 Mbit   168 Rick James 03/28/2013 08:49AM
Re: Performance over Leased Line 10 Mbit   152 Dimitri Kravtchuk 03/28/2013 10:51AM
AUTO_INCREMENT PK best practices   297 Venkatesh Iyer 03/26/2013 11:14AM
Re: AUTO_INCREMENT PK best practices   153 Rick James 03/27/2013 11:23PM
Load Data Infile takes a long time   446 Venkatesh Iyer 03/15/2013 04:44PM
Re: Load Data Infile takes a long time   216 Rick James 03/16/2013 06:15PM
Re: Load Data Infile takes a long time   208 Venkatesh Iyer 03/17/2013 11:39PM
Re: Load Data Infile takes a long time   227 addision philip 03/17/2013 11:05PM
Re: Load Data Infile takes a long time   215 Øystein Grøvlen 03/18/2013 03:04AM
Re: Load Data Infile takes a long time   202 Rick James 03/19/2013 08:28PM
Re: Load Data Infile takes a long time   184 Venkatesh Iyer 03/20/2013 12:25PM
Re: Load Data Infile takes a long time   210 Rick James 03/20/2013 05:03PM
Re: Load Data Infile takes a long time   183 Venkatesh Iyer 03/26/2013 11:06AM
Problems encountered when testing with mysqlslap   346 Zhipan Wang 03/25/2013 12:50PM
mysql order by limit too slow, faster when making select a sub query   421 Mathew V 03/20/2013 01:54AM
Re: mysql order by limit too slow, faster when making select a sub query   202 Øystein Grøvlen 03/20/2013 05:39AM
Re: mysql order by limit too slow, faster when making select a sub query   204 Rick James 03/20/2013 09:07AM
Re: mysql order by limit too slow, faster when making select a sub query   234 Mathew V 03/20/2013 10:37PM
Re: mysql order by limit too slow, faster when making select a sub query   218 Rick James 03/21/2013 09:16AM
Re: mysql order by limit too slow, faster when making select a sub query   215 Øystein Grøvlen 03/22/2013 04:03AM
Re: mysql order by limit too slow, faster when making select a sub query   197 Rick James 03/23/2013 12:17AM
Strange behavior with queries using "limit"   388 Jagat P 03/21/2013 03:18PM
Re: Strange behavior with queries using "limit"   179 Jørgen Løland 03/22/2013 09:14AM
Re: Strange behavior with queries using "limit"   165 Rick James 03/23/2013 12:09AM
Optimizing a query with UNION   411 Matthew Devine 03/14/2013 03:28PM
Re: Optimizing a query with UNION   183 Peter Brawley 03/14/2013 09:08PM
Re: Optimizing a query with UNION   195 Rick James 03/14/2013 10:41PM
Re: Optimizing a query with UNION   190 Matthew Devine 03/15/2013 09:13AM
Re: Optimizing a query with UNION   190 Rick James 03/15/2013 11:32PM
Re: Optimizing a query with UNION   173 Matthew Devine 03/16/2013 05:29AM
Mad 5.5 performance on identical servers   388 Peter Konrady 03/12/2013 10:10AM
Re: Mad 5.5 performance on identical servers   173 Rick James 03/13/2013 11:43PM
Re: Mad 5.5 performance on identical servers   186 Peter Konrady 03/14/2013 09:47AM
Re: Mad 5.5 performance on identical servers   176 Rick James 03/15/2013 08:08AM
Explain   391 Alex Singh 03/06/2013 07:20AM
Re: Explain   198 Jeremy Smyth 03/06/2013 11:59AM
Re: Explain   186 Jørgen Løland 03/11/2013 01:43AM
Mysql : Completely strange performance behavior   431 dominique papin 02/28/2013 10:35AM
Re: Mysql : Completely strange performance behavior   231 dominique papin 02/28/2013 03:27PM
Re: Mysql : Completely strange performance behavior   218 Jørgen Løland 03/01/2013 07:13AM
Re: Mysql : Completely strange performance behavior   232 dominique papin 03/01/2013 08:03AM
Re: Mysql : Completely strange performance behavior   214 Jørgen Løland 03/01/2013 08:28AM
Re: Mysql : Completely strange performance behavior   269 Rick James 03/01/2013 08:41PM
Re: Mysql : Completely strange performance behavior   237 Jørgen Løland 03/04/2013 02:00AM
Re: Mysql : Completely strange performance behavior   214 Rick James 03/04/2013 11:55PM
Re: Mysql : Completely strange performance behavior   209 Øystein Grøvlen 03/04/2013 03:27AM
Case sensitive vs non case sensitive performance   433 Kjeld Flarup 02/27/2013 03:29AM
Re: Case sensitive vs non case sensitive performance   226 Rick James 02/28/2013 09:04AM
MySQL 5.6 disk requirements   393 justin edmands 02/25/2013 11:49AM
Re: MySQL 5.6 disk requirements   232 Rick James 02/26/2013 09:17AM
Re: MySQL 5.6 disk requirements   245 justin edmands 02/26/2013 01:44PM
Re: MySQL 5.6 disk requirements   205 Rick James 02/27/2013 11:17PM
INNODB large database performance   592 Paul Smith 02/16/2013 03:11AM
Re: INNODB large database performance   271 Rick James 02/20/2013 05:31PM
Re: INNODB large database performance   247 Paul Smith 02/21/2013 02:51AM
Re: INNODB large database performance   248 Rick James 02/21/2013 11:12PM
Re: INNODB large database performance   246 Paul Smith 02/22/2013 03:38AM
Re: INNODB large database performance   220 Rick James 02/23/2013 12:04AM
Re: INNODB large database performance   228 Paul Smith 02/23/2013 03:28PM
Re: INNODB large database performance   211 Rick James 02/24/2013 02:10PM
Re: INNODB large database performance   225 Paul Smith 02/24/2013 03:02PM
Re: INNODB large database performance   235 Rick James 02/25/2013 10:39PM
Problematic ALTER (empty) TABLE performance   410 Haron Media 02/20/2013 05:50AM
Re: Problematic ALTER (empty) TABLE performance   202 Rick James 02/21/2013 11:17PM
Re: Problematic ALTER (empty) TABLE performance   224 Haron Media 02/22/2013 02:58AM
Re: Problematic ALTER (empty) TABLE performance   201 Rick James 02/23/2013 12:16AM
Re: Problematic ALTER (empty) TABLE performance   215 Haron Media 02/23/2013 03:15AM
Re: Problematic ALTER (empty) TABLE performance   202 Rick James 02/23/2013 11:47PM
Help tunning MySQL 5.5 (query_cache_size, table_cache, ...)   1,077 Dimas Streich 02/18/2013 06:46AM
Re: Help tunning MySQL 5.5 (query_cache_size, table_cache, ...)   506 Rick James 02/20/2013 10:35PM
Adding limit clause takes query from 2 seconds to 42 minutes   862 Josh Higham 12/12/2012 03:53PM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   362 Øystein Grøvlen 12/19/2012 04:15AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   351 Rick James 12/22/2012 03:44PM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   285 Josh H 02/11/2013 11:22AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   338 aftab khan 12/24/2012 03:31AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   278 Josh H 02/11/2013 11:17AM
UPDATE with two table join is very slow   611 Meen Sathish 02/08/2013 10:45AM
Re: UPDATE with two table join is very slow   327 Rick James 02/09/2013 01:24PM
Slow query_time with heavy locking   498 Matthias Siebler 02/07/2013 04:29AM
Re: Slow query_time with heavy locking   297 Rick James 02/08/2013 10:11AM
Index and date functions   526 Aurelien PANIZZA 01/30/2013 10:30AM
Re: Index and date functions   290 Rick James 01/31/2013 10:22PM
Re: Index and date functions   287 Aurelien PANIZZA 02/04/2013 03:33AM
Re: Index and date functions   272 Aurelien PANIZZA 02/04/2013 10:45AM
Performance tuning - comparing two computers   702 Francis Mariani 01/23/2013 07:23PM
Re: Performance tuning - comparing two computers   301 Øystein Grøvlen 01/24/2013 03:15AM
Re: Performance tuning - comparing two computers   281 Francis Mariani 01/24/2013 09:27PM
Re: Performance tuning - comparing two computers   310 Rick James 01/24/2013 10:38PM
Re: Performance tuning - comparing two computers   320 Francis Mariani 01/25/2013 07:59PM
Re: Performance tuning - comparing two computers   294 Francis Mariani 01/25/2013 08:36PM
Re: Performance tuning - comparing two computers   327 Rick James 01/26/2013 12:11AM
Connections Sleeping not disconnecting   628 Nick Arnone 01/24/2013 02:32PM
Re: Connections Sleeping not disconnecting   305 Rick James 01/25/2013 08:14PM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 66

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.