Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Utilities 1.5.5 has been released 09/01/2015 10:59AM
MySQL Utilities 1.6.2 Beta has been released 08/31/2015 02:28PM
MySQL Enterprise Monitor 3.0.24 has been released 08/28/2015 01:07PM
MySQL Connector/NET 6.9.7 has been released 08/05/2015 06:38AM
Current Page: 5 of 71
Subject Views Written By Posted
Optimize a large MySQL Table   1,179 thota kaarthiik 06/24/2013 12:28AM
Re: Optimize a large MySQL Table   569 Rick James 06/24/2013 07:35PM
Re: Optimize a large MySQL Table   607 thota kaarthiik 06/28/2013 05:33AM
Re: Optimize a large MySQL Table   497 Rick James 06/29/2013 02:58PM
optimizing a big table   817 thota kaarthiik 06/25/2013 03:07AM
Re: optimizing a big table   384 Rick James 06/25/2013 10:30PM
Re: optimizing a big table   365 thota kaarthiik 06/28/2013 09:58AM
MySQL tuning   927 Rob G 06/23/2013 07:58PM
Re: MySQL tuning   388 Peter Brawley 06/23/2013 08:42PM
Re: MySQL tuning   394 Rob G 06/23/2013 09:06PM
Re: MySQL tuning   421 Rick James 06/24/2013 08:07PM
MySQL and sockets   652 Jayadevan M 06/23/2013 09:27PM
Re: MySQL and sockets   386 Rick James 06/24/2013 07:45PM
How to read slow.txt?   2,948 Gaurav Khanna 06/19/2013 02:46AM
Re: How to read slow.txt?   400 Rick James 06/19/2013 10:42PM
Very slow query   1,289 Aram Mirzadeh 06/15/2013 07:31PM
Re: Very slow query   497 Rick James 06/16/2013 10:09PM
Re: Very slow query   442 Aram Mirzadeh 06/17/2013 05:40AM
Re: Very slow query   418 Rick James 06/18/2013 08:59PM
1 row Update query long for short duration   968 karl lauritzen 06/11/2013 10:14AM
Re: 1 row Update query long for short duration   392 karl lauritzen 06/11/2013 11:32AM
Re: 1 row Update query long for short duration   455 Rick James 06/13/2013 09:11AM
Re: 1 row Update query long for short duration   618 karl lauritzen 06/13/2013 09:53AM
Re: 1 row Update query long for short duration   411 Rick James 06/14/2013 11:17PM
how mysqlslap support utf8 encoding   707 Edward Zeng 06/05/2013 10:04AM
Re: how mysqlslap support utf8 encoding   337 Rick James 06/08/2013 06:03AM
Question on slow queries   1,618 Michele Quaini 05/30/2013 04:18AM
Re: Question on slow queries   480 Rick James 05/31/2013 05:14AM
Re: Question on slow queries   459 Michele Quaini 05/31/2013 06:09AM
Re: Question on slow queries   427 Rick James 06/01/2013 02:45PM
Re: Question on slow queries   602 Michele Quaini 06/04/2013 02:35AM
Re: Question on slow queries   575 Rick James 06/05/2013 11:27PM
Re: Question on slow queries   392 Michele Quaini 06/06/2013 02:02AM
Static, 120GB, InnoDB table is unusuable   1,134 Nicholas Hans 06/01/2013 09:24AM
Re: Static, 120GB, InnoDB table is unusuable   445 Rick James 06/01/2013 09:49PM
Re: Static, 120GB, InnoDB table is unusuable   472 Rick James 06/01/2013 10:51PM
Re: Static, 120GB, InnoDB table is unusuable   491 Nicholas Hans 06/01/2013 11:29PM
Re: Static, 120GB, InnoDB table is unusuable   489 Rick James 06/02/2013 08:33PM
Slow performance over network   1,285 Will Duckworth 05/30/2013 03:45AM
The mysql vs mysqli db driver for a php app - any clear cut winner?   787 Thomas Kazarian 05/23/2013 09:48AM
Re: The mysql vs mysqli db driver for a php app - any clear cut winner?   389 Rick James 05/25/2013 03:55PM
MySQL database drop insanely slow   3,137 Stephane Eybert 04/15/2013 01:31PM
Re: MySQL database drop insanely slow   911 Stephane Eybert 04/15/2013 04:01PM
Re: MySQL database drop insanely slow   904 Stephane Eybert 04/15/2013 04:04PM
Re: MySQL database drop insanely slow   776 Rick James 04/15/2013 10:11PM
Re: MySQL database drop insanely slow   799 Stephane Eybert 04/17/2013 10:10AM
Re: MySQL database drop insanely slow   760 Stephane Eybert 04/22/2013 05:44AM
Re: MySQL database drop insanely slow   670 Stephane Eybert 04/22/2013 06:32AM
Re: MySQL database drop insanely slow   666 Stephane Eybert 04/22/2013 05:57AM
Re: MySQL database drop insanely slow   784 Rick James 04/23/2013 08:30AM
Re: MySQL database drop insanely slow   664 Stephane Eybert 05/25/2013 11:01AM
Re: MySQL database drop insanely slow   729 Stephane Eybert 04/22/2013 06:25AM
Re: MySQL database drop insanely slow   686 Stephane Eybert 04/22/2013 06:46AM
High CPU usage in %user   17,336 Marco Ramirez 05/14/2013 12:31PM
Re: High CPU usage in %user   3,107 Rick James 05/15/2013 08:00PM
Re: High CPU usage in %user   2,627 Marco Ramirez 05/16/2013 02:22AM
Re: High CPU usage in %user   2,206 Rick James 05/16/2013 09:46PM
Queries locking up   1,102 Thomas Kazarian 05/07/2013 01:13PM
Re: Queries locking up   465 Rick James 05/08/2013 08:50PM
Re: Queries locking up   382 Thomas Kazarian 05/09/2013 10:09PM
Re: Queries locking up   527 Rick James 05/11/2013 11:29PM
Re: Queries locking up   388 Thomas Kazarian 05/15/2013 09:33PM
Composite index - selecting components and order   1,040 Rick Ingram 05/04/2013 10:54AM
Re: Composite index - selecting components and order   444 Rick James 05/06/2013 07:47PM
Re: Composite index - selecting components and order   453 Rick Ingram 05/06/2013 10:47PM
Re: Composite index - selecting components and order   508 Rick James 05/07/2013 08:05PM
Re: Composite index - selecting components and order   407 Rick Ingram 05/07/2013 08:40PM
Re: Composite index - selecting components and order   457 Rick Ingram 05/08/2013 06:55AM
Re: Composite index - selecting components and order   415 Rick James 05/08/2013 08:45PM
Re: Composite index - selecting components and order   432 Rick Ingram 05/08/2013 09:54PM
Re: Composite index - selecting components and order   753 Rick James 05/09/2013 10:46PM
Re: Composite index - selecting components and order   414 Rick Ingram 05/09/2013 10:56PM
How MySQL Uses Indexes   929 Mola Ji 05/04/2013 08:28AM
Re: How MySQL Uses Indexes   455 Øystein Grøvlen 05/06/2013 03:46AM
Re: How MySQL Uses Indexes   497 Mola Ji 05/06/2013 10:31AM
Re: How MySQL Uses Indexes   491 Rick James 05/06/2013 07:57PM
Re: How MySQL Uses Indexes   446 Mola Ji 05/07/2013 12:24PM
Re: How MySQL Uses Indexes   467 Rick James 05/07/2013 07:47PM
Re: How MySQL Uses Indexes   426 Mola Ji 05/08/2013 05:33AM
Re: How MySQL Uses Indexes   415 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,724 James Marcus 05/01/2013 11:32AM
Re: Hardware sizing tools   799 Rick James 05/02/2013 07:38AM
Re: Hardware sizing tools   749 James Marcus 05/03/2013 11:24AM
Re: Hardware sizing tools   669 Rick James 05/04/2013 01:34PM
cache not used with restricted privileges ?   896 brocu lus 04/30/2013 02:44AM
Re: cache not used with restricted privileges ?   422 Rick James 05/01/2013 11:57PM
Re: cache not used with restricted privileges ?   445 brocu lus 05/02/2013 08:35AM
Re: QUERY cache not used with restricted privileges ?   458 Rick James 05/03/2013 09:32AM
partitioning every year data   960 mohamed bashid s 04/13/2013 07:20PM
Re: partitioning every year data   472 Mikael Ronström 04/24/2013 12:30PM
Re: partitioning every year data   435 mohamed bashid s 04/29/2013 04:53AM
Re: partitioning every year data   498 Rick James 05/02/2013 12:00AM
Re: partitioning every year data   461 mohamed bashid s 05/02/2013 02:59AM
Re: partitioning every year data   448 Rick James 05/02/2013 07:57AM
In-memory dB on Embedded system   1,140 Sandhya Srinivas 04/24/2013 03:58AM
Re: In-memory dB on Embedded system   546 Rick James 04/24/2013 10:51PM
mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   6,943 Meteor SY 04/22/2013 09:03AM
Re: mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   2,508 Meteor SY 04/22/2013 07:31PM
Re: mysql have lots of ' sleep null' process, and caused php takes up 100% cpu   2,471 Rick James 04/23/2013 11:22PM
pattern matching with LIKE or REGEXP   1,004 Oka Putra 04/21/2013 10:05AM
Re: pattern matching with LIKE or REGEXP   422 Rick James 04/23/2013 08:33AM
Simple join taking longer than it should   971 Kenneth Mitchner 04/16/2013 02:02PM
Re: Simple join taking longer than it should   402 Rick James 04/17/2013 09:04PM
Sortable columns dilemma   906 Patrick Clas 04/13/2013 11:28AM
Re: Sortable columns dilemma   381 Rick James 04/14/2013 01:09PM
Insertion performance degrade with large index   1,178 holy holy 04/11/2013 02:36AM
Re: Insertion performance degrade with large index   543 Rick James 04/11/2013 10:08PM
Re: Insertion performance degrade with large index   453 holy holy 04/12/2013 12:51AM
Re: Insertion performance degrade with large index   469 Rick James 04/12/2013 08:23PM
handle multiple years data   824 mohamed bashid s 02/27/2013 12:50AM
Re: handle multiple years data   528 Rick James 02/27/2013 11:23PM
Re: handle multiple years data   425 mohamed bashid s 04/12/2013 06:38AM
MySQL 5.6 update doubled IOs   1,595 Christian Meisinger 03/18/2013 08:33AM
Re: MySQL 5.6 update doubled IOs   684 Christian Meisinger 03/19/2013 08:58AM
Re: MySQL 5.6 update doubled IOs   726 Rick James 03/20/2013 08:52AM
Re: MySQL 5.6 update doubled IOs   664 Dimitri Kravtchuk 03/21/2013 09:51AM
Re: MySQL 5.6 update doubled IOs   808 Christian Meisinger 03/26/2013 08:29AM
Re: MySQL 5.6 update doubled IOs   768 Dimitri Kravtchuk 03/27/2013 11:11AM
Re: MySQL 5.6 update doubled IOs   656 Rick James 03/27/2013 11:44PM
Re: MySQL 5.6 update doubled IOs   687 Christian Meisinger 03/28/2013 02:17AM
Re: MySQL 5.6 update doubled IOs   665 Dimitri Kravtchuk 03/28/2013 09:55AM
Re: MySQL 5.6 update doubled IOs   1,021 Christian Meisinger 03/29/2013 02:20AM
Re: MySQL 5.6 update doubled IOs   685 Dimitri Kravtchuk 03/29/2013 06:30AM
Re: MySQL 5.6 update doubled IOs   706 Christian Meisinger 03/29/2013 06:56AM
Re: MySQL 5.6 update doubled IOs   654 Dimitri Kravtchuk 03/29/2013 07:18AM
Re: MySQL 5.6 update doubled IOs   627 Christian Meisinger 03/29/2013 07:49AM
Re: MySQL 5.6 update doubled IOs   629 Dimitri Kravtchuk 03/29/2013 08:08AM
Re: MySQL 5.6 update doubled IOs   588 Christian Meisinger 03/29/2013 10:07AM
Re: MySQL 5.6 update doubled IOs   698 Rick James 03/28/2013 07:49PM
Re: MySQL 5.6 update doubled IOs   674 Christian Meisinger 03/29/2013 01:23AM
Re: MySQL 5.6 update doubled IOs   678 Olav Sandstå 04/02/2013 12:20AM
Re: MySQL 5.6 update doubled IOs   710 Øystein Grøvlen 04/02/2013 12:30AM
Re: MySQL 5.6 update doubled IOs   704 Øystein Grøvlen 04/02/2013 12:44AM
Re: MySQL 5.6 update doubled IOs   548 Christian Meisinger 04/02/2013 02:23AM
Re: MySQL 5.6 update doubled IOs   556 Rick James 04/02/2013 09:57PM
Re: MySQL 5.6 update doubled IOs   726 Øystein Grøvlen 04/03/2013 12:46AM
Re: MySQL 5.6 update doubled IOs   669 Dimitri Kravtchuk 04/03/2013 03:29AM
Re: MySQL 5.6 update doubled IOs   666 Christian Meisinger 04/05/2013 01:57AM
Re: MySQL 5.6 update doubled IOs   655 Dimitri Kravtchuk 04/05/2013 06:24AM
Re: MySQL 5.6 update doubled IOs   610 Christian Meisinger 04/10/2013 08:12AM
Re: MySQL 5.6 update doubled IOs   664 Olav Sandstå 04/10/2013 08:31AM
out of memory error   8,238 Christine Ross 04/08/2013 12:26PM
Re: out of memory error   2,330 Rick James 04/09/2013 09:23AM
Mysql DB server hits 400% CPU   1,613 Mannoj Kumar 04/04/2013 05:16AM
Re: Mysql DB server hits 400% CPU   575 Rick James 04/05/2013 09:41AM
4 GB RAM and runs so low the PC screams   1,281 Mike Jonsson 03/31/2013 12:36AM
Re: 4 GB RAM and runs so low the PC screams   602 Rick James 03/31/2013 09:51PM
Re: 4 GB RAM and runs so low the PC screams   1,107 Mike Jonsson 04/01/2013 03:12AM
Re: 4 GB RAM and runs so low the PC screams   563 Mike Jonsson 04/01/2013 12:48PM
Re: 4 GB RAM and runs so low the PC screams   604 Mike Jonsson 04/01/2013 04:56PM
Re: 4 GB RAM and runs so low the PC screams   584 Rick James 04/01/2013 10:53PM
Re: 4 GB RAM and runs so low the PC screams   554 Mike Jonsson 04/02/2013 01:38AM
Re: 4 GB RAM and runs so low the PC screams - resolved   757 Mike Jonsson 04/02/2013 04:00PM
Re: 4 GB RAM and runs so low the PC screams - resolved   566 Rick James 04/02/2013 07:54PM
Re: 4 GB RAM and runs so low the PC screams - resolved   507 Rick James 04/02/2013 08:45PM
Mysql is very slow but using CPU <10%   1,043 Percy Xu 03/22/2013 08:47AM
Re: Mysql is very slow but using CPU <10%   537 Rick James 03/23/2013 12:59PM
Re: Mysql is very slow but using CPU <10%   522 Mike Jonsson 03/31/2013 01:25AM
Performance over Leased Line 10 Mbit   1,740 Peter Konrady 03/27/2013 06:54AM
Re: Performance over Leased Line 10 Mbit   497 Rick James 03/28/2013 08:49AM
Re: Performance over Leased Line 10 Mbit   450 Dimitri Kravtchuk 03/28/2013 10:51AM
AUTO_INCREMENT PK best practices   1,152 Venkatesh Iyer 03/26/2013 11:14AM
Re: AUTO_INCREMENT PK best practices   399 Rick James 03/27/2013 11:23PM
Load Data Infile takes a long time   2,237 Venkatesh Iyer 03/15/2013 04:44PM
Re: Load Data Infile takes a long time   867 Rick James 03/16/2013 06:15PM
Re: Load Data Infile takes a long time   826 Venkatesh Iyer 03/17/2013 11:39PM
Re: Load Data Infile takes a long time   832 addision philip 03/17/2013 11:05PM
Re: Load Data Infile takes a long time   868 Øystein Grøvlen 03/18/2013 03:04AM
Re: Load Data Infile takes a long time   745 Rick James 03/19/2013 08:28PM
Re: Load Data Infile takes a long time   752 Venkatesh Iyer 03/20/2013 12:25PM
Re: Load Data Infile takes a long time   692 Rick James 03/20/2013 05:03PM
Re: Load Data Infile takes a long time   692 Venkatesh Iyer 03/26/2013 11:06AM
Problems encountered when testing with mysqlslap   1,042 Zhipan Wang 03/25/2013 12:50PM
mysql order by limit too slow, faster when making select a sub query   1,422 Mathew V 03/20/2013 01:54AM
Re: mysql order by limit too slow, faster when making select a sub query   636 Øystein Grøvlen 03/20/2013 05:39AM
Re: mysql order by limit too slow, faster when making select a sub query   669 Rick James 03/20/2013 09:07AM
Re: mysql order by limit too slow, faster when making select a sub query   2,034 Mathew V 03/20/2013 10:37PM
Re: mysql order by limit too slow, faster when making select a sub query   882 Rick James 03/21/2013 09:16AM
Re: mysql order by limit too slow, faster when making select a sub query   832 Øystein Grøvlen 03/22/2013 04:03AM
Re: mysql order by limit too slow, faster when making select a sub query   731 Rick James 03/23/2013 12:17AM
Strange behavior with queries using "limit"   1,168 Jagat P 03/21/2013 03:18PM
Re: Strange behavior with queries using "limit"   571 Jørgen Løland 03/22/2013 09:14AM
Re: Strange behavior with queries using "limit"   391 Rick James 03/23/2013 12:09AM
Optimizing a query with UNION   1,631 Matthew Devine 03/14/2013 03:28PM
Re: Optimizing a query with UNION   567 Peter Brawley 03/14/2013 09:08PM
Re: Optimizing a query with UNION   555 Rick James 03/14/2013 10:41PM
Re: Optimizing a query with UNION   882 Matthew Devine 03/15/2013 09:13AM
Re: Optimizing a query with UNION   659 Rick James 03/15/2013 11:32PM
Re: Optimizing a query with UNION   494 Matthew Devine 03/16/2013 05:29AM
Mad 5.5 performance on identical servers   966 Peter Konrady 03/12/2013 10:10AM
Re: Mad 5.5 performance on identical servers   434 Rick James 03/13/2013 11:43PM
Re: Mad 5.5 performance on identical servers   444 Peter Konrady 03/14/2013 09:47AM
Re: Mad 5.5 performance on identical servers   412 Rick James 03/15/2013 08:08AM
Explain   840 Alex Singh 03/06/2013 07:20AM
Re: Explain   467 Jeremy Smyth 03/06/2013 11:59AM
Re: Explain   427 Jørgen Løland 03/11/2013 01:43AM
Mysql : Completely strange performance behavior   1,065 dominique papin 02/28/2013 10:35AM
Re: Mysql : Completely strange performance behavior   583 dominique papin 02/28/2013 03:27PM
Re: Mysql : Completely strange performance behavior   520 Jørgen Løland 03/01/2013 07:13AM
Re: Mysql : Completely strange performance behavior   579 dominique papin 03/01/2013 08:03AM
Re: Mysql : Completely strange performance behavior   516 Jørgen Løland 03/01/2013 08:28AM
Re: Mysql : Completely strange performance behavior   599 Rick James 03/01/2013 08:41PM
Re: Mysql : Completely strange performance behavior   577 Jørgen Løland 03/04/2013 02:00AM
Re: Mysql : Completely strange performance behavior   570 Rick James 03/04/2013 11:55PM
Re: Mysql : Completely strange performance behavior   547 Øystein Grøvlen 03/04/2013 03:27AM
Case sensitive vs non case sensitive performance   1,831 Kjeld Flarup 02/27/2013 03:29AM
Re: Case sensitive vs non case sensitive performance   702 Rick James 02/28/2013 09:04AM
MySQL 5.6 disk requirements   1,276 justin edmands 02/25/2013 11:49AM
Re: MySQL 5.6 disk requirements   533 Rick James 02/26/2013 09:17AM
Re: MySQL 5.6 disk requirements   638 justin edmands 02/26/2013 01:44PM
Re: MySQL 5.6 disk requirements   471 Rick James 02/27/2013 11:17PM
INNODB large database performance   2,144 Paul Smith 02/16/2013 03:11AM
Re: INNODB large database performance   715 Rick James 02/20/2013 05:31PM
Re: INNODB large database performance   641 Paul Smith 02/21/2013 02:51AM
Re: INNODB large database performance   676 Rick James 02/21/2013 11:12PM
Re: INNODB large database performance   665 Paul Smith 02/22/2013 03:38AM
Re: INNODB large database performance   561 Rick James 02/23/2013 12:04AM
Re: INNODB large database performance   542 Paul Smith 02/23/2013 03:28PM
Re: INNODB large database performance   544 Rick James 02/24/2013 02:10PM
Re: INNODB large database performance   570 Paul Smith 02/24/2013 03:02PM
Re: INNODB large database performance   589 Rick James 02/25/2013 10:39PM
Problematic ALTER (empty) TABLE performance   1,095 Haron Media 02/20/2013 05:50AM
Re: Problematic ALTER (empty) TABLE performance   474 Rick James 02/21/2013 11:17PM
Re: Problematic ALTER (empty) TABLE performance   554 Haron Media 02/22/2013 02:58AM
Re: Problematic ALTER (empty) TABLE performance   466 Rick James 02/23/2013 12:16AM
Re: Problematic ALTER (empty) TABLE performance   533 Haron Media 02/23/2013 03:15AM
Re: Problematic ALTER (empty) TABLE performance   467 Rick James 02/23/2013 11:47PM
Help tunning MySQL 5.5 (query_cache_size, table_cache, ...)   4,366 Dimas Streich 02/18/2013 06:46AM
Re: Help tunning MySQL 5.5 (query_cache_size, table_cache, ...)   1,990 Rick James 02/20/2013 10:35PM
Adding limit clause takes query from 2 seconds to 42 minutes   1,538 Josh Higham 12/12/2012 03:53PM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   622 Øystein Grøvlen 12/19/2012 04:15AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   535 Rick James 12/22/2012 03:44PM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   594 Josh H 02/11/2013 11:22AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   617 aftab khan 12/24/2012 03:31AM
Re: Adding limit clause takes query from 2 seconds to 42 minutes   530 Josh H 02/11/2013 11:17AM
UPDATE with two table join is very slow   1,122 Meen Sathish 02/08/2013 10:45AM
Re: UPDATE with two table join is very slow   644 Rick James 02/09/2013 01:24PM
This topic has been moved.:  MySQL tuning   0 Rob G 06/23/2013 08:44PM
Current Page: 5 of 71

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.