Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
• MySQL Connector/Python 1.0.10 has been released 05/07/2013 12:33AM
• MySQL Connector/J 5.1.25 has been released 05/06/2013 10:30AM
• MySQL Connector/C 6.1.0 has been released 05/02/2013 02:28PM
• MySQL Connector/ODBC 5.2.5 has been released 05/02/2013 02:26PM
• MySQL for Excel 1.1.1 (GA) has been released 04/26/2013 04:33PM
Current Page: 5 of 66
Subject Views Written By Posted
innodb_buffer_pool_instances: equal sized instances?   982 Rizwan Mian 03/20/2012 07:01PM
Re: innodb_buffer_pool_instances: equal sized instances?   537 Wagner Bianchi 03/20/2012 07:43PM
InnoDB Simple(?) Scalability Issue   984 Tim Kiefer 02/22/2012 10:12PM
Re: InnoDB Simple(?) Scalability Issue   426 Rick James 02/23/2012 11:52PM
Re: InnoDB Simple(?) Scalability Issue   436 Tim Kiefer 02/24/2012 07:41AM
Re: InnoDB Simple(?) Scalability Issue   414 Rick James 02/25/2012 10:52AM
Re: InnoDB Simple(?) Scalability Issue   393 Tim Kiefer 02/27/2012 05:58AM
Re: InnoDB Simple(?) Scalability Issue   393 Rick James 02/28/2012 08:29PM
Re: InnoDB Simple(?) Scalability Issue   322 Tim Kiefer 03/14/2012 03:21AM
Re: InnoDB Simple(?) Scalability Issue   313 Rick James 03/15/2012 10:54AM
Re: InnoDB Simple(?) Scalability Issue   381 irek kordirko 02/29/2012 02:40AM
Re: InnoDB Simple(?) Scalability Issue   318 Tim Kiefer 03/14/2012 03:10AM
Problem with server "freezing"   1,058 Martin W 02/08/2012 08:57AM
Re: Problem with server "freezing"   553 Aftab Khan 02/09/2012 02:53AM
Re: Problem with server "freezing"   430 Martin W 03/12/2012 06:40AM
Re: Problem with server "freezing"   363 Rick James 03/14/2012 07:12PM
How To Monitor Stored Procedure Performance   675 Chris Kimberley 03/13/2012 02:50PM
Query takes forever and creates huge temporary table..   754 Yrrk Wahlen 03/11/2012 05:50PM
Re: Query takes forever and creates huge temporary table..   321 Rick James 03/12/2012 08:42PM
Significant performance drop in InnoDB truncation after Linux upgrade   948 Bjørn Trondsen 03/05/2012 12:18PM
Re: Significant performance drop in InnoDB truncation after Linux upgrade   334 Rick James 03/06/2012 09:49AM
Re: Significant performance drop in InnoDB truncation after Linux upgrade   346 Bjørn Trondsen 03/07/2012 11:58AM
Re: Significant performance drop in InnoDB truncation after Linux upgrade   333 Rick James 03/08/2012 08:58AM
Re: Significant performance drop in InnoDB truncation after Linux upgrade   340 Bjørn Trondsen 03/08/2012 10:22AM
Why does my Left Outer Join not use an index?   2,265 Daniel Barrett 03/05/2012 11:08AM
Re: Why does my Left Outer Join not use an index?   1,212 irek kordirko 03/05/2012 05:05PM
Re: Why does my Left Outer Join not use an index?   709 Daniel Barrett 03/06/2012 03:39PM
Improving query performance   907 Claudiu H 03/02/2012 07:33AM
Re: Improving query performance   377 Rick James 03/03/2012 09:51AM
Re: Improving query performance   345 Claudiu H 03/05/2012 03:03AM
Re: Improving query performance   402 Rick James 03/06/2012 12:32AM
JOIN --- key not used   596 Jan D 03/02/2012 02:53AM
Re: JOIN --- key not used   387 Rick James 03/02/2012 11:43PM
Speed of query on tables containing blob depends on filesystem cache   844 Periklis Venakis 02/29/2012 03:08AM
Re: Speed of query on tables containing blob depends on filesystem cache   481 Rick James 02/29/2012 11:59PM
Re: Speed of query on tables containing blob depends on filesystem cache   458 Periklis Venakis 03/02/2012 01:02AM
Re: Speed of query on tables containing blob depends on filesystem cache   585 Rick James 03/02/2012 09:45PM
how to 'un-cache' a table, so I can re-run a query at same speed?   850 Bennett Haselton 02/22/2012 04:26PM
Re: how to 'un-cache' a table, so I can re-run a query at same speed?   458 Rick James 02/24/2012 12:03AM
Re: how to 'un-cache' a table, so I can re-run a query at same speed?   378 Bennett Haselton 02/29/2012 08:31PM
Re: how to 'un-cache' a table, so I can re-run a query at same speed?   483 Rick James 03/01/2012 08:04PM
Using derived table in subquery   821 Mickael Magniez 02/28/2012 04:03AM
Re: Using derived table in subquery   442 Rick James 02/29/2012 09:23PM
prepared statements   869 Jacek Kowalczyk 02/26/2012 01:45PM
Re: prepared statements   381 irek kordirko 02/26/2012 12:06PM
Re: prepared statements   428 Jacek Kowalczyk 02/26/2012 02:34PM
Re: prepared statements   384 irek kordirko 02/28/2012 07:26PM
maximum value of Innodb_data_read?   1,062 Rizwan Mian 02/23/2012 01:11PM
Re: maximum value of Innodb_data_read?   355 wen ren 02/27/2012 02:40PM
Re: maximum value of Innodb_data_read?   472 Rick James 02/24/2012 06:32AM
Re: maximum value of Innodb_data_read?   424 Rizwan Mian 02/24/2012 01:20PM
Slow concurrent updates   843 Kyrylo Klimakov 02/24/2012 02:30AM
Re: Slow concurrent updates   354 Rick James 02/24/2012 11:46PM
Re: Slow concurrent updates   556 Kyrylo Klimakov 02/25/2012 09:29AM
Re: Slow concurrent updates   384 Rick James 02/26/2012 10:01AM
comma separated field vs separate table   766 bob dope 02/23/2012 09:57PM
Re: comma separated field vs separate table   373 Rick James 02/24/2012 06:23PM
Re: comma separated field vs separate table   526 bob dope 02/25/2012 09:37PM
Slow Sort performance   812 Stefan Homberg 02/24/2012 04:46AM
Re: Slow Sort performance   394 Rick James 02/25/2012 05:45AM
query too slow   506 Dragos Gabriel Iancu 02/24/2012 04:04AM
Re: query too slow   305 Johan Andersson 02/24/2012 01:51PM
Can I a   524 Dhaval Patel 02/20/2012 12:37AM
Re: Can I a   311 Rick James 02/24/2012 11:27AM
performance with table consist 100 Million records   598 Dhaval Patel 02/20/2012 02:11AM
Re: performance with table consist 100 Million records   472 Rick James 02/24/2012 11:26AM
Indexed date column and LIKE statement, index not working   704 John Nahlen 02/22/2012 09:02PM
Re: Indexed date column and LIKE statement, index not working   354 Rick James 02/24/2012 07:20AM
Re: Indexed date column and LIKE statement, index not working   458 irek kordirko 02/23/2012 10:55AM
Tables locking on insert   650 Ryan Hanson 02/15/2012 06:16AM
Re: Tables locking on insert   510 Rick James 02/16/2012 10:29PM
Re: Tables locking on insert   346 Ryan Hanson 02/17/2012 09:28AM
Re: Tables locking on insert   497 Aftab Khan 02/19/2012 07:38AM
Re: Tables locking on insert   335 Ryan Hanson 02/20/2012 07:07AM
How would I make this IP to country faster?   631 Tito Serenti 02/17/2012 10:45AM
Re: How would I make this IP to country faster?   457 Rick James 02/18/2012 12:20PM
lot of metadata access   793 Cyril SCETBON 02/16/2012 04:01AM
Re: lot of metadata access   320 Rick James 02/17/2012 01:18AM
Re: lot of metadata access   299 Cyril SCETBON 02/17/2012 03:09AM
Re: lot of metadata access   326 Rick James 02/17/2012 05:05PM
Select from view with union and join   723 Jasiu Fasola 02/17/2012 05:09AM
Re: Select from view with union and join   356 irek kordirko 02/17/2012 03:15PM
5.5.17 Community slower on RHEL6 and RHEL55   912 Jobe Bittman 02/13/2012 01:32PM
Re: 5.5.17 Community slower on RHEL6 and RHEL55   446 Rick James 02/16/2012 12:05AM
Joins vs Select subquery in Select clause   760 saurabh jain 02/14/2012 07:01PM
Re: Joins vs Select subquery in Select clause   518 Rick James 02/15/2012 11:27PM
DECIMAL(65, 0) data size   893 Timur Rubeko 02/06/2012 08:55AM
Re: DECIMAL(65, 0) data size   335 Rick James 02/09/2012 11:10AM
How to improve the join performance on 15 tables   877 SivaKumar A 02/03/2012 12:37AM
Re: How to improve the join performance on 15 tables   398 Oystein Grovlen 02/03/2012 03:37AM
Re: How to improve the join performance on 15 tables   406 SivaKumar A 02/03/2012 05:34AM
Re: How to improve the join performance on 15 tables   430 Oystein Grovlen 02/03/2012 05:49AM
Re: How to improve the join performance on 15 tables   598 Rick James 02/04/2012 01:06PM
join on same table   1,132 Coen Dunnink 01/31/2012 01:48AM
Re: join on same table   350 irek kordirko 02/02/2012 04:49AM
Re: join on same table   449 Rick James 01/31/2012 08:36PM
Re: join on same table   363 Oystein Grovlen 02/01/2012 03:18AM
Inspecting queries currently being executed in MySQL?   923 Rizwan Mian 01/12/2012 09:57AM
Re: Inspecting queries currently being executed in MySQL?   384 Scott Nemes 01/12/2012 11:59AM
Re: Inspecting queries currently being executed in MySQL?   272 Rizwan Mian 01/30/2012 11:22AM
Worker-per-connection vs. Worker-per-request?   1,067 Rizwan Mian 01/21/2012 10:13AM
Re: Worker-per-connection vs. Worker-per-request?   392 Rizwan Mian 01/21/2012 07:44PM
Re: Worker-per-connection vs. Worker-per-request?   506 Rick James 01/22/2012 05:35PM
Re: Worker-per-connection vs. Worker-per-request?   382 Rizwan Mian 01/30/2012 06:32AM
ENUM vs TINYINT for mutually exclusive values   1,109 Rebtik Var 01/28/2012 06:09AM
Re: ENUM vs TINYINT for mutually exclusive values   776 Rick James 01/29/2012 12:08PM
Re: ENUM vs TINYINT for mutually exclusive values   610 Rebtik Var 01/29/2012 12:33PM
Union in sub query and Left join vs. for each union left join   1,218 Thomas Jüntgen 01/27/2012 10:37PM
Re: Union in sub query and Left join vs. for each union left join   646 irek kordirko 01/28/2012 05:48AM
union distinct vs or query (with order by and range)   890 Andrew Nuss 01/26/2012 08:51PM
Re: union distinct vs or query (with order by and range)   503 Rick James 01/27/2012 02:28PM
Innodb log file size   741 Aftab Khan 01/25/2012 09:34AM
perfoemance difference in structured select vs long orred select   689 Omer Eisenberg 01/24/2012 08:21AM
Re: perfoemance difference in structured select vs long orred select   313 Oystein Grovlen 01/25/2012 04:53AM
How well your innodb buffer pool is sized   634 Aftab Khan 01/23/2012 08:30AM
Mysql Table structure and storage engine for millions of records   1,049 Luiz Cláudio Pinheiro 01/21/2012 10:08AM
Re: Mysql Table structure and storage engine for millions of records   488 Rick James 01/22/2012 05:50PM
mysqld.exe consumption extremely high   1,591 Kez Francis 01/18/2012 05:51AM
Re: mysqld.exe consumption extremely high   553 Rick James 01/19/2012 09:55PM
MySQL 5.6: Optimizer Tracing   673 Edwin DeSouza 01/19/2012 12:06PM
MySQL 5.1.49 - Optimal settings for memory usage   2,922 Marc Mertes 01/10/2012 05:20AM
Re: MySQL 5.1.49 - Optimal settings for memory usage   1,134 Rick James 01/11/2012 10:59AM
Re: MySQL 5.1.49 - Optimal settings for memory usage   826 Marc Mertes 01/17/2012 02:16AM
Re: MySQL 5.1.49 - Optimal settings for memory usage   579 Rick James 01/17/2012 11:44PM
Re: MySQL 5.1.49 - Optimal settings for memory usage   662 Marc Mertes 01/18/2012 03:00AM
Re: MySQL 5.1.49 - Optimal settings for memory usage   545 Marc Mertes 01/18/2012 03:34AM
Re: MySQL 5.1.49 - Optimal settings for memory usage   593 Rick James 01/19/2012 12:17AM
Re: MySQL 5.1.49 - Optimal settings for memory usage   523 Marc Mertes 01/19/2012 05:38AM
Long commits   820 Panayotis Matsinopoulos 01/16/2012 01:31AM
Re: Long commits   377 Rick James 01/16/2012 11:15PM
Using where; Using temporary; Using filesort - slow query   2,466 Michael Andrews 01/05/2012 04:45PM
Re: Using where; Using temporary; Using filesort - slow query   1,305 Rick James 01/06/2012 07:57PM
Re: Using where; Using temporary; Using filesort - slow query   1,104 Michael Andrews 01/11/2012 08:51AM
Re: Using where; Using temporary; Using filesort - slow query   1,084 Rick James 01/12/2012 07:54PM
Re: Using where; Using temporary; Using filesort - slow query   1,055 Michael Andrews 01/16/2012 08:25AM
show profile cpu for query 1 shows cpu_user and cpu_system as null   1,172 Amit Shah 01/12/2012 05:38AM
Re: show profile cpu for query 1 shows cpu_user and cpu_system as null   591 Jonathon Coombes 01/14/2012 09:20PM
Copying to tmp table hanging   1,137 nolo krakkan 01/09/2012 07:40AM
Re: Copying to tmp table hanging   498 Rick James 01/10/2012 11:49AM
Re: Copying to tmp table hanging   499 nolo krakkan 01/11/2012 12:42AM
Re: Copying to tmp table hanging   480 Rick James 01/11/2012 10:05PM
Locked State   1,002 Alessandro Corbelli 01/10/2012 05:09AM
Re: Locked State   306 Rick James 01/11/2012 06:47PM
insert takes too long   1,219 nir elbaz 01/08/2012 03:10AM
Re: insert takes too long   510 Rick James 01/09/2012 01:25AM
Re: insert takes too long   562 nir elbaz 01/09/2012 08:26AM
Re: insert takes too long   399 Rick James 01/10/2012 11:48AM
Help -- ludicrously slow operations on table with 2.6mln records, fully indexed (MyISAM, MySQL 5.0.51, Linux)   906 Victor Danilcehnko 01/05/2012 09:16AM
Re: Help -- ludicrously slow operations on table with 2.6mln records, fully indexed (MyISAM, MySQL 5.0.51, Linux)   453 Rick James 01/06/2012 10:11AM
Re: Help -- ludicrously slow operations on table with 2.6mln records, fully indexed (MyISAM, MySQL 5.0.51, Linux)   426 Victor Danilcehnko 01/06/2012 10:27AM
Re: Help -- ludicrously slow operations on table with 2.6mln records, fully indexed (MyISAM, MySQL 5.0.51, Linux)   505 Rick James 01/07/2012 03:44PM
Re: Help -- ludicrously slow operations on table with 2.6mln records, fully indexed (MyISAM, MySQL 5.0.51, Linux)   449 Victor Danilcehnko 01/09/2012 08:42AM
Re: Help -- ludicrously slow operations on table with 2.6mln records, fully indexed (MyISAM, MySQL 5.0.51, Linux)   597 Rick James 01/10/2012 11:45AM
MySQL performance help   886 Arun Shankar 01/07/2012 06:55AM
Re: MySQL performance help   451 Rick James 01/08/2012 12:04PM
Current Page: 5 of 66
powered by phorum

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.