Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Proxy 0.8.5 alpha has been released 09/05/2014 03:15PM
MySQL Workbench 6.2.2 RC has been released 09/05/2014 03:05PM
MySQL Connector/NET 6.9.3 GA has been released 09/03/2014 06:02AM
MySQL Enterprise Monitor 3.0.14 has been released 09/02/2014 02:37PM
MySQL Enterprise Backup 3.11.0 has been released 09/02/2014 10:13AM
Current Page: 5 of 69
Subject Views Written By Posted
Slow on multiple joins   1,295 mariusz raczynski 11/19/2012 05:10AM
Re: Slow on multiple joins   554 Aftab Khan 11/20/2012 05:45AM
Re: Slow on multiple joins   523 Rick James 11/20/2012 09:16AM
Best use of SSD   1,502 Weyland Yutani 11/17/2012 07:26AM
Re: Best use of SSD   632 Aftab Khan 11/20/2012 05:35AM
Re: Best use of SSD   935 Rick James 11/18/2012 03:45PM
Re: Best use of SSD   746 Weyland Yutani 11/19/2012 06:50AM
Huge tables and performance   995 Justin Davis 11/15/2012 06:29AM
Re: Huge tables and performance   414 Rick James 11/16/2012 09:27AM
Re: Huge tables and performance   384 Justin Davis 11/19/2012 02:27AM
Re: Huge tables and performance   358 Aftab Khan 11/20/2012 05:15AM
6-table join, good indices, bad perf   1,095 Jaap Vermeer 11/16/2012 11:32AM
Re: 6-table join, good indices, bad perf   427 Øystein Grøvlen 11/19/2012 07:22AM
SHOW CREATE TABLEs   802 Jaap Vermeer 11/17/2012 11:36AM
Re: SHOW CREATE TABLEs   470 Rick James 11/18/2012 03:37PM
Re: SHOW CREATE TABLEs   418 Jaap Vermeer 11/18/2012 05:11PM
Re: 6-table join, good indices, bad perf   564 Rick James 11/17/2012 10:41AM
New Fast Server Now Available at Amazon Web Services   981 Hiromichi Watari 11/13/2012 10:57AM
Mysql too Slow when Copying to Tmp Table   6,719 karen wang 11/10/2012 07:57AM
Re: Mysql too Slow when Copying to Tmp Table   3,876 Rick James 11/11/2012 12:30PM
Re: Mysql too Slow when Copying to Tmp Table   3,535 karen wang 11/11/2012 07:53PM
Re: Mysql too Slow when Copying to Tmp Table   3,445 Rick James 11/11/2012 08:32PM
Re: Mysql too Slow when Copying to Tmp Table   2,742 karen wang 11/12/2012 12:08AM
How to see key_buffer in action   1,186 Stefan Frömken 11/08/2012 01:01PM
Re: How to see key_buffer in action   527 Stefan Frömken 11/09/2012 05:54AM
Re: How to see key_buffer in action   625 Rick James 11/11/2012 12:45PM
Re: How to see key_buffer in action   560 karen wang 11/11/2012 06:58PM
Adding keyword search (fulltext) to query   1,191 Marc Ferland 10/23/2012 07:16AM
Re: Adding keyword search (fulltext) to query   445 Rick James 10/24/2012 09:08PM
Re: Adding keyword search (fulltext) to query   840 Marc Ferland 10/25/2012 06:54AM
Re: Adding keyword search (fulltext) to query   410 Rick James 10/26/2012 09:17PM
Re: Adding keyword search (fulltext) to query   424 Marc Ferland 10/27/2012 09:30AM
Re: Adding keyword search (fulltext) to query   426 Rick James 10/30/2012 01:30PM
Re: Adding keyword search (fulltext) to query   429 Marc Ferland 10/30/2012 02:06PM
Re: Adding keyword search (fulltext) to query   416 Rick James 11/01/2012 12:32AM
Re: Adding keyword search (fulltext) to query   439 Marc Ferland 11/01/2012 07:14AM
Re: Adding keyword search (fulltext) to query   457 Marc Ferland 10/27/2012 09:09AM
Re: Adding keyword search (fulltext) to query   405 Marc Ferland 10/27/2012 09:24AM
Re: Adding keyword search (fulltext) to query   492 Marc Ferland 10/23/2012 07:21AM
realistic expectations of MySQL   959 emmett walsh 10/20/2012 12:13PM
Re: realistic expectations of MySQL   430 Rick James 10/21/2012 09:49AM
Performance Comparison   1,489 Rajesh Kapur 10/04/2012 02:19PM
Re: Performance Comparison   539 Jørgen Løland 10/06/2012 12:47AM
Re: Performance Comparison   513 Aftab Khan 10/19/2012 09:58AM
Re: Performance Comparison   709 Rick James 10/05/2012 11:29AM
Maximum CPU/Socket/Cores supported   4,153 sysadm aemnet 10/18/2012 09:14AM
Re: Maximum CPU/Socket/Cores supported   2,314 Jørgen Løland 10/18/2012 12:22PM
Re: Maximum CPU/Socket/Cores supported   1,470 Rick James 10/18/2012 06:24PM
Re: Maximum CPU/Socket/Cores supported   1,107 Aftab Khan 10/19/2012 09:48AM
how mysql process resident memory is dependent on buffer pool size   1,411 vivek d r 10/05/2012 03:53AM
Re: how mysql process resident memory is dependent on buffer pool size   619 Rick James 10/06/2012 12:14AM
Re: how mysql process resident memory is dependent on buffer pool size   563 vivek d r 10/09/2012 04:17AM
Re: how mysql process resident memory is dependent on buffer pool size   578 Rick James 10/09/2012 11:46PM
Re: how mysql process resident memory is dependent on buffer pool size   540 vivek d r 10/11/2012 01:06AM
Re: how mysql process resident memory is dependent on buffer pool size   511 Rick James 10/11/2012 10:35PM
Re: how mysql process resident memory is dependent on buffer pool size   479 vivek d r 10/12/2012 12:07AM
Re: how mysql process resident memory is dependent on buffer pool size   486 Aftab Khan 10/19/2012 09:45AM
Sudden drop in performance on MyISAM DB   1,248 william Warwick 10/15/2012 07:46AM
Re: Sudden drop in performance on MyISAM DB   454 Rick James 10/16/2012 07:40PM
Re: Sudden drop in performance on MyISAM DB   442 Jørgen Løland 10/17/2012 01:19AM
Re: Sudden drop in performance on MyISAM DB   378 Rick James 10/17/2012 09:41PM
Re: Sudden drop in performance on MyISAM DB   437 Jørgen Løland 10/18/2012 12:34PM
Re: Sudden drop in performance on MyISAM DB   393 william Warwick 10/17/2012 01:47AM
Re: Sudden drop in performance on MyISAM DB   439 Jørgen Løland 10/17/2012 03:21AM
Re: Sudden drop in performance on MyISAM DB   416 william Warwick 10/17/2012 04:28AM
Re: Sudden drop in performance on MyISAM DB   432 Jørgen Løland 10/17/2012 10:38AM
Re: Sudden drop in performance on MyISAM DB   505 Jørgen Løland 10/16/2012 06:29AM
Re: Sudden drop in performance on MyISAM DB   470 william Warwick 10/16/2012 07:56AM
Re: Sudden drop in performance on MyISAM DB   490 Jørgen Løland 10/17/2012 01:29AM
Tunning MySQL 5.1.X   1,158 Michael Cahill 10/04/2012 08:39AM
Re: Tunning MySQL 5.1.X   494 Rick James 10/05/2012 11:39AM
Re: Tunning MySQL 5.1.X   449 Michael Cahill 10/06/2012 05:40AM
Check Empty Memory Table   883 Chuck Mongillo 10/03/2012 01:42PM
Re: Check Empty Memory Table   401 Rick James 10/05/2012 11:47AM
Will fixed row format increase performance   1,712 Denis Chernyaev 10/04/2012 02:24AM
Re: Will fixed row format increase performance   750 Rick James 10/04/2012 09:57PM
Re: Will fixed row format increase performance   644 Denis Chernyaev 10/04/2012 11:06PM
innodb vs myisam in replication   1,048 Jasio Stasio 10/03/2012 11:56AM
Re: innodb vs myisam in replication   481 Rick James 10/04/2012 07:40PM
[Solved] CPU usage too low   3,236 A R 09/02/2012 04:52PM
Re: CPU usage too low   1,291 Rick James 09/03/2012 01:33PM
Re: CPU usage too low   1,084 A R 09/05/2012 12:22AM
Re: CPU usage too low   800 Aftab Khan 09/05/2012 03:35AM
Re: CPU usage too low   899 Rick James 09/05/2012 08:12AM
Re: CPU usage too low   757 A R 09/25/2012 05:20PM
Re: CPU usage too low   909 A R 09/25/2012 05:35PM
Re: CPU usage too low   778 Rick James 10/01/2012 11:49PM
update very slow   1,704 james che 09/26/2012 03:37PM
Re: update very slow   821 Aftab Khan 09/27/2012 01:47AM
Re: update very slow   794 james che 09/27/2012 08:21AM
Re: update very slow   600 Rick James 10/01/2012 10:59PM
Lots of query in "login" state   796 Alfredo Ammirati 09/29/2012 12:08PM
Re: Lots of query in "login" state   352 Rick James 10/01/2012 10:47PM
Single schema vs split schemas   1,065 Nils Rückmann 09/29/2012 11:00AM
Re: Single schema vs split schemas   459 Jørgen Løland 10/01/2012 01:14AM
1 long query stuck all other queries   1,147 Jack Wang 09/12/2012 02:23AM
Re: 1 long query stuck all other queries   455 Rick James 09/14/2012 10:36PM
Re: 1 long query stuck all other queries   426 Jørgen Løland 09/20/2012 06:06AM
Re: 1 long query stuck all other queries   463 Aftab Khan 09/14/2012 01:43AM
Re: 1 long query stuck all other queries   514 Jørgen Løland 09/13/2012 01:56AM
Re: 1 long query stuck all other queries   471 Jack Wang 09/16/2012 09:05PM
Re: 1 long query stuck all other queries   459 Rick James 09/16/2012 10:49PM
Re: 1 long query stuck all other queries   460 Jack Wang 09/17/2012 12:48AM
Re: 1 long query stuck all other queries   437 Aftab Khan 09/17/2012 08:55AM
Datetime-index not used with unicode connection-collation   1,554 Michael Moench 09/14/2012 08:12AM
Re: Datetime-index not used with unicode connection-collation   630 Rick James 09/15/2012 08:28AM
Re: Datetime-index not used with unicode connection-collation   625 Michael Moench 09/15/2012 09:16AM
Re: Datetime-index not used with unicode connection-collation   599 Rick James 09/16/2012 10:54AM
Re: Datetime-index not used with unicode connection-collation   651 Michael Moench 09/17/2012 07:56AM
Size of the databse   851 Thomas Laguerre 09/13/2012 08:57AM
Re: Size of the databse   380 09/14/2012 07:56PM
Re: Size of the databse   484 Jørgen Løland 09/14/2012 12:59AM
Re: Size of the databse   380 Rick James 09/14/2012 10:50PM
Re: Size of the databse   434 Thomas Laguerre 09/14/2012 01:41AM
Re: Size of the databse   436 Aftab Khan 09/14/2012 01:45AM
Re: Size of the databse   381 Thomas Laguerre 09/14/2012 01:49AM
resultset rows performance   1,090 09/14/2012 02:16AM
Re: resultset rows performance   524 Aftab Khan 09/14/2012 03:54AM
Re: resultset rows performance   519 09/14/2012 07:49AM
Re: resultset rows performance   496 Rick James 09/14/2012 10:29PM
How to somehow use index for group by expression   1,049 Tim Stowell 09/07/2012 10:24PM
Re: How to somehow use index for group by expression   564 Rick James 09/08/2012 11:04PM
Separate disk for data (inno), is helping performance (I/O) ?   788 arif wicaksono 09/07/2012 10:06AM
Re: Separate disk for data (inno), is helping performance (I/O) ?   500 Rick James 09/08/2012 09:14AM
Any way to group by day with timezone and still use index?   1,347 Tim Stowell 09/04/2012 02:54PM
Re: Any way to group by day with timezone and still use index?   577 Aftab Khan 09/05/2012 03:56AM
Re: Any way to group by day with timezone and still use index?   512 Tim Stowell 09/07/2012 10:15PM
How to get acceptable/repeatable performance on huge table   1,041 Peter Stridsberg 08/30/2012 03:07AM
Re: How to get acceptable/repeatable performance on huge table   452 Øystein Grøvlen 08/31/2012 04:47AM
Re: How to get acceptable/repeatable performance on huge table   541 Aftab Khan 08/30/2012 03:55PM
Re: How to get acceptable/repeatable performance on huge table   456 Peter Stridsberg 08/31/2012 05:22AM
Re: How to get acceptable/repeatable performance on huge table   506 Aftab Khan 08/31/2012 05:43AM
Re: How to get acceptable/repeatable performance on huge table   476 Aftab Khan 08/31/2012 07:00AM
Re: How to get acceptable/repeatable performance on huge table   498 Peter Stridsberg 08/31/2012 07:30AM
Re: How to get acceptable/repeatable performance on huge table   488 Aftab Khan 08/31/2012 08:12AM
Re: How to get acceptable/repeatable performance on huge table   476 Peter Stridsberg 09/02/2012 09:32AM
Re: How to get acceptable/repeatable performance on huge table   481 Rick James 09/02/2012 11:22AM
Re: How to get acceptable/repeatable performance on huge table   483 Rick James 09/01/2012 06:39PM
Re: How to get acceptable/repeatable performance on huge table   429 Peter Stridsberg 09/02/2012 09:25AM
Re: How to get acceptable/repeatable performance on huge table   475 Aftab Khan 08/31/2012 07:44AM
Re: How to get acceptable/repeatable performance on huge table   446 Peter Stridsberg 09/02/2012 09:27AM
Re: How to get acceptable/repeatable performance on huge table   486 Aftab Khan 09/03/2012 03:17AM
Re: How to get acceptable/repeatable performance on huge table   500 Peter Stridsberg 08/31/2012 05:54AM
Re: How to get acceptable/repeatable performance on huge table   470 Øystein Grøvlen 08/31/2012 05:42AM
Calculate hardware needs based on desired writes per second   1,145 Jan Bromberger 08/13/2012 06:49AM
Re: Calculate hardware needs based on desired writes per second   547 Aftab Khan 08/13/2012 09:31AM
Re: Calculate hardware needs based on desired writes per second   548 Jan Bromberger 08/13/2012 02:18PM
Re: Calculate hardware needs based on desired writes per second   505 Aftab Khan 08/14/2012 02:00AM
Re: Calculate hardware needs based on desired writes per second   495 Jan Bromberger 08/14/2012 08:18AM
Re: Calculate hardware needs based on desired writes per second   478 Aftab Khan 08/14/2012 08:53AM
Re: Calculate hardware needs based on desired writes per second   451 Jan Bromberger 08/14/2012 11:56AM
Re: Calculate hardware needs based on desired writes per second   496 Aftab Khan 08/20/2012 06:07AM
Re: Calculate hardware needs based on desired writes per second   792 Rick James 08/19/2012 10:39PM
Re: Calculate hardware needs based on desired writes per second   450 Jan Bromberger 08/25/2012 02:01AM
Re: Calculate hardware needs based on desired writes per second   563 Rick James 08/26/2012 10:07AM
Slow select queries after update   1,403 Geir Øyvind Vælidalo 08/13/2012 02:37AM
Re: Slow select queries after update   700 Aftab Khan 08/13/2012 03:11AM
Re: Slow select queries after update   742 Geir Øyvind Vælidalo 08/23/2012 01:07AM
Re: Slow select queries after update   648 Rick James 08/19/2012 09:32PM
Will optiimizer recognize left outer join on primary key = constant?   1,068 George Whiffen 08/21/2012 08:54AM
Re: Will optiimizer recognize left outer join on primary key = constant?   507 Aftab Khan 08/21/2012 10:38AM
Re: Will optiimizer recognize left outer join on primary key = constant?   542 Rick James 08/22/2012 11:03PM
How to improve performance in a table with 70 million rows   4,484 Srikanth Mamidi 08/08/2012 02:04AM
Re: How to improve performance in a table with 70 million rows   1,709 Aftab Khan 08/08/2012 02:41AM
Re: How to improve performance in a table with 70 million rows   1,419 Srikanth Mamidi 08/08/2012 03:24AM
Re: How to improve performance in a table with 70 million rows   1,164 Aftab Khan 08/08/2012 03:50AM
Re: How to improve performance in a table with 70 million rows   1,017 Srikanth Mamidi 08/08/2012 04:16AM
Re: How to improve performance in a table with 70 million rows   1,418 Aftab Khan 08/08/2012 04:53AM
Re: How to improve performance in a table with 70 million rows   879 Srikanth Mamidi 08/08/2012 07:36PM
Re: How to improve performance in a table with 70 million rows   1,009 Rick James 08/10/2012 12:16AM
Re: How to improve performance in a table with 70 million rows   754 Aftab Khan 08/22/2012 02:16PM
Re: How to improve performance in a table with 70 million rows   977 Srikanth Mamidi 08/11/2012 04:22AM
Re: How to improve performance in a table with 70 million rows   755 Rick James 08/18/2012 11:10PM
Re: How to improve performance in a table with 70 million rows   839 Srikanth Mamidi 08/20/2012 10:33AM
New Fast MySQL Compatible Server Released under the GPL License   936 Hiromichi Watari 08/22/2012 10:47AM
Performance Problem in some pCS   870 Pedro Ferreira 08/17/2012 11:30AM
Re: Performance Problem in some pCS   441 Rick James 08/19/2012 09:02PM
Table structure   765 Luiz Cláudio Pinheiro 08/16/2012 08:18PM
Re: Table structure   519 Aftab Khan 08/17/2012 02:14AM
Re: Table structure   452 Rick James 08/19/2012 08:51PM
Very slow SELECTS after reinstall   1,374 Diederik Slob 08/16/2012 05:37AM
Re: Very slow SELECTS after reinstall   626 Rick James 08/18/2012 10:02PM
Re: Very slow SELECTS after reinstall   558 Diederik Slob 08/19/2012 01:05AM
mysqlimport get very slow for large files   3,071 Jun Zhang 08/03/2012 09:44AM
Re: mysqlimport get very slow for large files   1,971 Aftab Khan 08/03/2012 11:04AM
Re: mysqlimport get very slow for large files   1,086 Jun Zhang 08/03/2012 03:06PM
Re: mysqlimport get very slow for large files   797 Rick James 08/05/2012 08:58AM
Re: mysqlimport get very slow for large files   689 Jun Zhang 08/07/2012 11:07AM
Re: mysqlimport get very slow for large files   785 Rick James 08/08/2012 08:34AM
Re: mysqlimport get very slow for large files   650 Jun Zhang 08/08/2012 04:19PM
Re: mysqlimport get very slow for large files   783 Rick James 08/09/2012 07:37PM
Re: mysqlimport get very slow for large files   1,402 Aftab Khan 08/09/2012 04:15AM
Re: mysqlimport get very slow for large files   1,001 Aftab Khan 08/04/2012 04:35AM
Re: mysqlimport get very slow for large files   1,034 Jun Zhang 08/07/2012 08:12AM
Re: mysqlimport get very slow for large files   883 Aftab Khan 08/07/2012 08:39AM
Re: mysqlimport get very slow for large files   944 Jun Zhang 08/07/2012 10:21AM
Need help in understanding the diffrence in responce times by mysql for two diffent use cases.   928 Shantanu B 08/01/2012 12:05PM
Re: Need help in understanding the diffrence in responce times by mysql for two diffent use cases.   497 Aftab Khan 08/02/2012 02:10AM
Re: Need help in understanding the diffrence in responce times by mysql for two diffent use cases.   468 Shantanu B 08/02/2012 04:56PM
Re: Need help in understanding the diffrence in responce times by mysql for two diffent use cases.   474 Rick James 08/03/2012 07:47PM
Remote mysql server slow   1,490 Denis Karovic 08/01/2012 09:22AM
Re: Remote mysql server slow   769 Rick James 08/03/2012 09:09AM
Re: Remote mysql server slow   714 Aftab Khan 08/01/2012 09:47AM
Double join on same table very slow   1,125 Bernd Schmidt 08/01/2012 08:55AM
Re: Double join on same table very slow   593 Rick James 08/03/2012 09:00AM
Re: Double join on same table very slow   518 Aftab Khan 08/01/2012 09:42AM
Optimization for complicated query   817 Paulo Torrens 08/01/2012 11:34AM
Re: Optimization for complicated query   511 Aftab Khan 08/02/2012 02:17AM
Re: Optimization for complicated query   498 Paulo Torrens 08/02/2012 03:18AM
Re: Optimization for complicated query   517 Aftab Khan 08/02/2012 11:10AM
primary key charset latin1 and other columns utf8 for performance?   1,136 Giovanni P 07/22/2012 11:31AM
Re: primary key charset latin1 and other columns utf8 for performance?   598 Aftab Khan 07/23/2012 04:46AM
Re: primary key charset latin1 and other columns utf8 for performance?   595 Giovanni P 07/23/2012 01:31PM
Re: primary key charset latin1 and other columns utf8 for performance?   606 Aftab Khan 07/24/2012 03:07AM
Re: primary key charset latin1 and other columns utf8 for performance?   553 Rick James 07/29/2012 09:14AM
Slow performance   1,182 karuna nukala 07/24/2012 02:03PM
Re: Slow performance   543 Aftab Khan 07/25/2012 02:49AM
Re: Slow performance   514 karuna nukala 07/26/2012 03:43AM
Re: Slow performance   495 Aftab Khan 07/26/2012 04:05AM
Re: Slow performance   408 Rick James 07/27/2012 09:34AM
MySQL Performance Schema: Monitoring Replication Slave-lag   1,568 Edwin Desouza 07/24/2012 09:57AM
Developers on Crack?   808 James Marcus 07/19/2012 06:47PM
Re: Developers on Crack?   477 Aftab Khan 07/20/2012 02:35AM
set autocommit off / commit / set autocommit on terribly slow   3,231 John Crowley 07/13/2012 07:48AM
Re: set autocommit off / commit / set autocommit on terribly slow   1,080 Aftab Khan 07/13/2012 08:49AM
Re: set autocommit off / commit / set autocommit on terribly slow   746 John Crowley 07/13/2012 09:19AM
Re: set autocommit off / commit / set autocommit on terribly slow   723 Rick James 07/14/2012 10:38AM
Re: set autocommit off / commit / set autocommit on terribly slow   916 John Crowley 07/14/2012 02:59PM
Re: set autocommit off / commit / set autocommit on terribly slow   715 Rick James 07/15/2012 11:25AM
Re: set autocommit off / commit / set autocommit on terribly slow   610 John Crowley 07/15/2012 03:02PM
Monitoring large resultsets   1,181 Jerome Benezech 07/10/2012 10:26PM
Re: Monitoring large resultsets   556 Aftab Khan 07/11/2012 02:01AM
Re: Monitoring large resultsets   471 Jerome Benezech 07/12/2012 12:22AM
Re: Monitoring large resultsets   479 Aftab Khan 07/12/2012 02:19AM
Re: Monitoring large resultsets   504 Jerome Benezech 07/12/2012 03:06AM
Re: Monitoring large resultsets   520 Umair Mumtaz 07/12/2012 12:12PM
Re: Monitoring large resultsets   524 Rick James 07/12/2012 05:49AM
Re: Monitoring large resultsets   464 Aftab Khan 07/12/2012 08:55AM
Re: Monitoring large resultsets   473 Aftab Khan 07/12/2012 08:13AM
Re: Monitoring large resultsets   439 Jerome Benezech 07/12/2012 06:05AM
Re: Monitoring large resultsets   528 Aftab Khan 07/12/2012 07:02AM
Re: Monitoring large resultsets   447 Jerome Benezech 07/12/2012 04:41PM
Re: Monitoring large resultsets   510 Rick James 07/13/2012 07:50PM
Re: Monitoring large resultsets   465 Aftab Khan 07/14/2012 02:43AM
Re: Monitoring large resultsets   500 Aftab Khan 07/12/2012 04:13AM
Re: Monitoring large resultsets   448 Jerome Benezech 07/12/2012 05:35AM
Re: Monitoring large resultsets   433 Aftab Khan 07/12/2012 03:37AM
Re: Monitoring large resultsets   487 Jerome Benezech 07/12/2012 03:51AM
Performance Schema: Processes   779 Edwin DeSouza 07/13/2012 08:58AM
Performance Schema: Security   728 Edwin DeSouza 07/13/2012 08:57AM
Current Page: 5 of 69

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.