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
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 of 66
Subject Views Written By Posted
Double join on same table very slow   642 Bernd Schmidt 08/01/2012 08:55AM
Re: Double join on same table very slow   348 Rick James 08/03/2012 09:00AM
Re: Double join on same table very slow   332 Aftab Khan 08/01/2012 09:42AM
Optimization for complicated query   532 Paulo Torrens 08/01/2012 11:34AM
Re: Optimization for complicated query   317 Aftab Khan 08/02/2012 02:17AM
Re: Optimization for complicated query   337 Paulo Torrens 08/02/2012 03:18AM
Re: Optimization for complicated query   345 Aftab Khan 08/02/2012 11:10AM
primary key charset latin1 and other columns utf8 for performance?   733 Giovanni P 07/22/2012 11:31AM
Re: primary key charset latin1 and other columns utf8 for performance?   404 Aftab Khan 07/23/2012 04:46AM
Re: primary key charset latin1 and other columns utf8 for performance?   378 Giovanni P 07/23/2012 01:31PM
Re: primary key charset latin1 and other columns utf8 for performance?   366 Aftab Khan 07/24/2012 03:07AM
Re: primary key charset latin1 and other columns utf8 for performance?   379 Rick James 07/29/2012 09:14AM
Slow performance   751 karuna nukala 07/24/2012 02:03PM
Re: Slow performance   350 Aftab Khan 07/25/2012 02:49AM
Re: Slow performance   345 karuna nukala 07/26/2012 03:43AM
Re: Slow performance   317 Aftab Khan 07/26/2012 04:05AM
Re: Slow performance   306 Rick James 07/27/2012 09:34AM
MySQL Performance Schema: Monitoring Replication Slave-lag   1,350 Edwin Desouza 07/24/2012 09:57AM
Developers on Crack?   603 James Marcus 07/19/2012 06:47PM
Re: Developers on Crack?   309 Aftab Khan 07/20/2012 02:35AM
set autocommit off / commit / set autocommit on terribly slow   1,492 John Crowley 07/13/2012 07:48AM
Re: set autocommit off / commit / set autocommit on terribly slow   559 Aftab Khan 07/13/2012 08:49AM
Re: set autocommit off / commit / set autocommit on terribly slow   435 John Crowley 07/13/2012 09:19AM
Re: set autocommit off / commit / set autocommit on terribly slow   449 Rick James 07/14/2012 10:38AM
Re: set autocommit off / commit / set autocommit on terribly slow   492 John Crowley 07/14/2012 02:59PM
Re: set autocommit off / commit / set autocommit on terribly slow   462 Rick James 07/15/2012 11:25AM
Re: set autocommit off / commit / set autocommit on terribly slow   396 John Crowley 07/15/2012 03:02PM
Monitoring large resultsets   865 Jerome Benezech 07/10/2012 10:26PM
Re: Monitoring large resultsets   401 Aftab Khan 07/11/2012 02:01AM
Re: Monitoring large resultsets   360 Jerome Benezech 07/12/2012 12:22AM
Re: Monitoring large resultsets   358 Aftab Khan 07/12/2012 02:19AM
Re: Monitoring large resultsets   369 Jerome Benezech 07/12/2012 03:06AM
Re: Monitoring large resultsets   372 Umair Mumtaz 07/12/2012 12:12PM
Re: Monitoring large resultsets   403 Rick James 07/12/2012 05:49AM
Re: Monitoring large resultsets   345 Aftab Khan 07/12/2012 08:55AM
Re: Monitoring large resultsets   353 Aftab Khan 07/12/2012 08:13AM
Re: Monitoring large resultsets   308 Jerome Benezech 07/12/2012 06:05AM
Re: Monitoring large resultsets   382 Aftab Khan 07/12/2012 07:02AM
Re: Monitoring large resultsets   337 Jerome Benezech 07/12/2012 04:41PM
Re: Monitoring large resultsets   388 Rick James 07/13/2012 07:50PM
Re: Monitoring large resultsets   315 Aftab Khan 07/14/2012 02:43AM
Re: Monitoring large resultsets   374 Aftab Khan 07/12/2012 04:13AM
Re: Monitoring large resultsets   345 Jerome Benezech 07/12/2012 05:35AM
Re: Monitoring large resultsets   320 Aftab Khan 07/12/2012 03:37AM
Re: Monitoring large resultsets   360 Jerome Benezech 07/12/2012 03:51AM
Performance Schema: Processes   577 Edwin DeSouza 07/13/2012 08:58AM
Performance Schema: Security   517 Edwin DeSouza 07/13/2012 08:57AM
Very high disk utilization by mysql server during reads.   916 Shantanu B 07/05/2012 12:49PM
Re: Very high disk utilization by mysql server during reads.   435 Aftab Khan 07/06/2012 02:51AM
Re: Very high disk utilization by mysql server during reads.   414 Shantanu B 07/06/2012 10:38AM
Re: Very high disk utilization by mysql server during reads.   409 Aftab Khan 07/07/2012 06:07AM
Re: Very high disk utilization by mysql server during reads.   374 Rick James 07/07/2012 12:34PM
Re: Very high disk utilization by mysql server during reads.   340 Shantanu B 07/09/2012 01:59PM
Re: Very high disk utilization by mysql server during reads.   431 Rick James 07/10/2012 09:47AM
From Months to Seconds with Subquery Materialization   579 Edwin DeSouza 07/09/2012 11:17AM
How to allow incremental versions of the data in a DB   636 Ricardo Rodríguez 06/22/2012 10:11AM
Re: How to allow incremental versions of the data in a BD   353 Rick James 06/29/2012 11:58PM
Re: How to allow incremental versions of the data in a BD   358 Ricardo Rodríguez 07/02/2012 10:08AM
Re: How to allow incremental versions of the data in a BD   409 Rick James 07/03/2012 12:41PM
Re: How to allow incremental versions of the data in a DB   326 Ricardo Rodríguez 07/06/2012 10:40AM
Re: How to allow incremental versions of the data in a DB   388 Aftab Khan 07/07/2012 09:02AM
Re: How to allow incremental versions of the data in a DB   319 Rick James 07/07/2012 05:54AM
Re: How to allow incremental versions of the data in a DB   308 Ricardo Rodríguez 07/09/2012 09:40AM
Correlated subquery taking much much longer since upgrade from 5.0   662 Alan Douglas 07/03/2012 02:37PM
Re: Correlated subquery taking much much longer since upgrade from 5.0   369 Aftab Khan 07/04/2012 03:39AM
Re: Correlated subquery taking much much longer since upgrade from 5.0   304 Alan Douglas 07/04/2012 08:32AM
Re: Correlated subquery taking much much longer since upgrade from 5.0   388 Rick James 07/07/2012 06:12AM
Re: Correlated subquery taking much much longer since upgrade from 5.0   370 Aftab Khan 07/07/2012 08:42AM
Re: Correlated subquery taking much much longer since upgrade from 5.0   336 Aftab Khan 07/05/2012 02:02AM
Re: Correlated subquery taking much much longer since upgrade from 5.0   362 Alan Douglas 07/05/2012 05:04AM
Re: Correlated subquery taking much much longer since upgrade from 5.0   371 Aftab Khan 07/05/2012 10:21AM
Re: Correlated subquery taking much much longer since upgrade from 5.0   421 Alan Douglas 07/06/2012 09:34AM
Low table cache hit rate   3,240 Arno Slatius 07/05/2012 09:38AM
Re: Low table cache hit rate   1,957 Aftab Khan 07/05/2012 10:32AM
Re: Low table cache hit rate   1,748 Arno Slatius 07/07/2012 01:31AM
Re: Low table cache hit rate   1,784 Aftab Khan 07/07/2012 05:44AM
Sudden drop in read performance   881 Douglas McGowan 05/22/2012 08:23PM
Re: Sudden drop in read performance   552 Rick James 05/23/2012 11:18PM
Re: Sudden drop in read performance   473 Douglas McGowan 05/24/2012 06:36AM
Re: Sudden drop in read performance   533 Douglas McGowan 05/30/2012 05:55AM
Re: Sudden drop in read performance   402 Rick James 06/12/2012 11:03PM
Re: Sudden drop in read performance   415 Douglas McGowan 07/06/2012 08:28PM
Performance Schema Does Not Initialize   1,779 Chris Kimberley 06/07/2012 10:42AM
Re: Performance Schema Does Not Initialize   830 Aftab Khan 07/06/2012 02:59AM
Re: Performance Schema Does Not Initialize   718 Format Dynamics 07/06/2012 09:15AM
Re: Performance Schema Does Not Initialize   911 Format Dynamics 07/05/2012 03:59PM
Re: Performance Schema Does Not Initialize   971 Rick James 06/15/2012 09:51AM
Re: Performance Schema Does Not Initialize   937 Chris Kimberley 06/15/2012 02:49PM
MySQL Performance Schema: Statement Digests   1,413 Edwin DeSouza 07/05/2012 03:46PM
Why does MySQL's performance decrease when queries are executed in parallel?   858 dmitry kotelnikov 06/28/2012 04:49AM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   489 Aftab Khan 06/28/2012 09:30AM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   417 dmitry kotelnikov 06/28/2012 12:23PM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   442 Aftab Khan 06/28/2012 02:27PM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   393 dmitry kotelnikov 06/29/2012 10:53AM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   342 Rick James 06/30/2012 09:00AM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   357 dmitry kotelnikov 07/04/2012 03:29AM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   450 Rick James 07/05/2012 06:30AM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   443 dmitry kotelnikov 07/05/2012 10:56AM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   378 Rick James 06/29/2012 10:07AM
Re: Why does MySQL's performance decrease when queries are executed in parallel?   419 dmitry kotelnikov 06/29/2012 10:27AM
MySQL 5.6: InnoDB Read-only Performance   554 Edwin DeSouza 07/02/2012 10:58AM
mysql + xmpp server +test loading - did I reach any physical limit?   893 gigi kent 06/07/2012 09:59AM
Re: mysql + xmpp server +test loading - did I reach any physical limit?   463 Rick James 06/10/2012 10:45PM
Re: mysql + xmpp server +test loading - did I reach any physical limit?   617 gigi kent 06/11/2012 10:54AM
Re: mysql + xmpp server +test loading - did I reach any physical limit?   475 Rick James 06/12/2012 08:55AM
Re: mysql + xmpp server +test loading - did I reach any physical limit?   450 gigi kent 06/12/2012 07:01PM
Re: mysql + xmpp server +test loading - did I reach any physical limit?   458 Rick James 06/19/2012 09:07AM
Re: mysql + xmpp server +test loading - did I reach any physical limit?   439 gigi kent 06/21/2012 07:56PM
Re: mysql + xmpp server +test loading - did I reach any physical limit?   407 Rick James 06/23/2012 01:49PM
Re: mysql + xmpp server +test loading - did I reach any physical limit?   376 gigi kent 07/02/2012 03:58AM
Re: mysql + xmpp server +test loading - did I reach any physical limit?   418 Aftab Khan 07/02/2012 05:01AM
Pre-DML trigger vs Foreign keys   647 Anushka Dissanayake 06/22/2012 10:18AM
Re: Pre-DML trigger vs Foreign keys   358 Rick James 06/23/2012 01:56PM
Re: Pre-DML trigger vs Foreign keys   369 Anushka Dissanayake 06/23/2012 03:39PM
Re: Pre-DML trigger vs Foreign keys   416 Rick James 06/23/2012 05:18PM
Re: Pre-DML trigger vs Foreign keys   371 Peter Brawley 07/01/2012 11:13PM
is my SELECT speed normal?   614 s t 06/27/2012 01:09AM
Re: is my SELECT speed normal?   348 Aftab Khan 06/27/2012 03:11AM
Re: is my SELECT speed normal?   332 s t 06/27/2012 03:53AM
Re: is my SELECT speed normal?   324 Aftab Khan 06/27/2012 04:34AM
Re: is my SELECT speed normal?   345 s t 06/27/2012 11:13AM
Low CPU load but very HIGH Memory load   821 Stephen Bateman 06/24/2012 11:47PM
Re: Low CPU load but very HIGH Memory load   474 Aftab Khan 06/25/2012 01:34AM
Re: Low CPU load but very HIGH Memory load   392 Rick James 06/25/2012 10:41PM
Problematic Query identification at the time of load on server   939 Zafar Malik 05/14/2012 01:58AM
Re: Problematic Query identification at the time of load on server   447 René Olivo 05/14/2012 10:56AM
Re: Problematic Query identification at the time of load on server   379 Zafar Malik 05/21/2012 09:11AM
Re: Problematic Query identification at the time of load on server   381 Rick James 05/22/2012 09:51AM
Re: Problematic Query identification at the time of load on server   334 Zafar Malik 06/24/2012 01:37PM
Re: Problematic Query identification at the time of load on server   357 Aftab Khan 06/24/2012 02:17PM
Re: Problematic Query identification at the time of load on server   361 Rick James 06/25/2012 09:40AM
Re: Problematic Query identification at the time of load on server   490 Aftab Khan 06/01/2012 03:25AM
Load avg is 65 and cpu is 100% on mysqld   709 Mannoj Kumar 06/20/2012 05:26AM
Re: Load avg is 65 and cpu is 100% on mysqld   399 Rick James 06/21/2012 12:38AM
Re: Load avg is 65 and cpu is 100% on mysqld   422 Mannoj Kumar 06/21/2012 11:12PM
Re: Load avg is 65 and cpu is 100% on mysqld   363 Rick James 06/23/2012 02:06PM
Re: Load avg is 65 and cpu is 100% on mysqld   400 Mannoj Kumar 06/24/2012 12:37AM
Re: Load avg is 65 and cpu is 100% on mysqld   414 Aftab Khan 06/24/2012 04:37AM
Re: Load avg is 65 and cpu is 100% on mysqld   330 Rick James 06/25/2012 08:06AM
Queriey hangs on "Sending data" state on high traffic   972 Anil Kumar 06/15/2012 12:39AM
Re: Queriey hangs on "Sending data" state on high traffic   580 Aftab Khan 06/22/2012 01:54AM
Re: Queriey hangs on "Sending data" state on high traffic   462 Anil Kumar 06/22/2012 08:49AM
Re: Queriey hangs on "Sending data" state on high traffic   543 Aftab Khan 06/22/2012 11:27AM
Re: Queriey hangs on "Sending data" state on high traffic   537 Anil Kumar 06/22/2012 11:14PM
Re: Queriey hangs on "Sending data" state on high traffic   768 Aftab Khan 06/23/2012 05:16AM
Re: Queriey hangs on "Sending data" state on high traffic   593 Rick James 06/15/2012 08:43PM
slow log doesn't work   657 Donald Kaczor 06/21/2012 10:25AM
Re: slow log doesn't work   311 Scott Nemes 06/21/2012 11:15AM
Re: slow log doesn't work   278 Rick James 06/22/2012 11:40AM
Tuning headaches and questions   649 Chad Gladue 06/17/2012 06:47AM
Re: Tuning headaches and questions   392 Rick James 06/18/2012 07:59AM
Re: Tuning headaches and questions   393 Chad Gladue 06/18/2012 08:45AM
Re: Tuning headaches and questions   340 Rick James 06/19/2012 08:27AM
Re: Tuning headaches and questions   316 Aftab Khan 06/22/2012 01:26AM
Re: Tuning headaches and questions   458 Chad Gladue 06/19/2012 08:38AM
Re: Tuning headaches and questions   353 Rick James 06/20/2012 09:11AM
Enabling Protocol Compression on Server   764 Paul Samuelson 06/14/2012 04:15PM
Re: Enabling Protocol Compression on Server   356 Rick James 06/18/2012 10:14PM
Re: Enabling Protocol Compression on Server   372 Paul Samuelson 06/19/2012 10:23AM
Performace impact on Multiple Database in a Single Server   772 Manjunath C 06/13/2012 05:35AM
Re: Performace impact on Multiple Database in a Single Server   452 Rick James 06/14/2012 08:52AM
Re: Performace impact on Multiple Database in a Single Server   388 Manjunath C 06/15/2012 12:08AM
Inserting data into Database uses up lots of memory   751 Evarest S 06/02/2012 08:32AM
Re: Inserting data into Database uses up lots of memory   399 Rick James 06/11/2012 10:36PM
Re: Inserting data into Database uses up lots of memory   439 Evarest S 06/12/2012 02:18PM
Re: Inserting data into Database uses up lots of memory   434 Rick James 06/13/2012 11:11AM
Re: Inserting data into Database uses up lots of memory   395 Aftab Khan 06/06/2012 03:51AM
Re: Inserting data into Database uses up lots of memory   339 Evarest S 06/12/2012 02:11PM
Re: Inserting data into Database uses up lots of memory   345 Aftab Khan 06/14/2012 05:41AM
Re: Inserting data into Database uses up lots of memory   393 Evarest S 06/14/2012 05:42PM
MySQL 5.1.61 caused high disk IO wait   1,309 Robert W. 06/01/2012 09:22AM
Re: MySQL 5.1.61 caused high disk IO wait   700 Aftab Khan 06/06/2012 03:57AM
Re: MySQL 5.1.61 caused high disk IO wait   782 Robert W. 06/12/2012 10:13AM
Re: MySQL 5.1.61 caused high disk IO wait   599 Aftab Khan 06/14/2012 05:29AM
Re: MySQL 5.1.61 caused high disk IO wait   776 Rick James 06/13/2012 07:45PM
Related posts by tags optimization   762 René Olivo 06/08/2012 10:27AM
Re: Related posts by tags optimization   338 Rick James 06/10/2012 10:36PM
Re: Related posts by tags optimization   340 René Olivo 06/10/2012 11:15PM
Re: Related posts by tags optimization   318 Rick James 06/11/2012 11:40PM
Re: Related posts by tags optimization   398 René Olivo 06/12/2012 01:50AM
Re: Related posts by tags optimization   322 Rick James 06/12/2012 08:58PM
Re: Related posts by tags optimization   376 René Olivo 06/12/2012 10:24PM
Set my indices, query still takes 0.7s   548 Jaap Vermeer 06/02/2012 05:25AM
Re: Set my indices, query still takes 0.7s   385 Rick James 06/11/2012 10:48PM
Re: Set my indices, query still takes 0.7s   343 Aftab Khan 06/06/2012 04:16AM
Re: Set my indices, query still takes 0.7s   327 Jaap Vermeer 06/08/2012 04:27PM
10 Years of Mystery 32bit Optimization   578 Blackbeard Data 06/02/2012 09:27PM
Re: 10 Years of Mystery 32bit Optimization   323 Rick James 06/11/2012 10:12PM
MySQL optimization on join tables with range criteria   587 Eric Ho 06/05/2012 10:01PM
Re: MySQL optimization on join tables with range criteria   339 Rick James 06/11/2012 09:51PM
Help using indexes in data warehouse project   512 Hélio Shimojo 06/07/2012 05:57AM
Re: Help using indexes in data warehouse project   287 Rick James 06/11/2012 09:40PM
Simple Select - join not using indexes   698 Hélio Shimojo 06/07/2012 10:03AM
Re: Simple Select - join not using indexes   343 Hélio Shimojo 06/07/2012 10:16AM
Re: Simple Select - join not using indexes   348 Rick James 06/11/2012 09:36PM
Is there any difference between varchar(50) and varchar(255) ?   622 Sujoy Pal 06/06/2012 02:05AM
Re: Is there any difference between varchar(50) and varchar(255) ?   273 Aftab Khan 06/06/2012 03:01AM
Filesort & Order by   539 05/30/2012 02:19AM
Re: Filesort & Order by   323 Scott Nemes 05/30/2012 11:02AM
Search form : Views, subqueries or temporary tables   834 FABRE Maxime 05/25/2012 02:27AM
Re: Search form : Views, subqueries or temporary tables   421 FABRE Maxime 05/25/2012 03:28AM
Re: Search form : Views, subqueries or temporary tables   345 Rick James 05/25/2012 10:57PM
join and where   519 Jacek Kowalczyk 05/24/2012 09:04AM
Re: join and where   259 irek kordirko 05/24/2012 02:03PM
Re: join and where   278 Jacek Kowalczyk 05/24/2012 06:12PM
mysqldump causing vast amounts of memory to be used   541 James Talbut 05/23/2012 02:45AM
Basic Standards of Mysql server variable setting   681 Zafar Malik 05/07/2012 10:02AM
Re: Basic Standards of Mysql server variable setting   497 Rick James 05/08/2012 08:44AM
Re: Basic Standards of Mysql server variable setting   342 Zafar Malik 05/21/2012 11:42AM
Re: Basic Standards of Mysql server variable setting   299 Zafar Malik 05/21/2012 11:48AM
Re: Basic Standards of Mysql server variable setting   428 Rick James 05/22/2012 09:18AM
Lock wait timeout exceeded   1,071 Dave Ford 05/18/2012 10:48AM
Re: Lock wait timeout exceeded   517 Rick James 05/19/2012 05:05PM
How to add “where clause” to compare 12 Million Rows?   517 Ilyas Iqbal 05/15/2012 06:14PM
Re: How to add “where clause” to compare 12 Million Rows?   354 Rick James 05/16/2012 06:21PM
Why is MySQL choosing the wrong index?   767 René Olivo 05/14/2012 10:26AM
Re: Why is MySQL choosing the wrong index?   445 Rick James 05/15/2012 07:43AM
Re: Why is MySQL choosing the wrong index?   421 René Olivo 05/15/2012 09:58AM
Commit response slow   958 Heiko Kiesssling 05/09/2012 10:51AM
Re: Commit response slow   511 Rick James 05/10/2012 08:27AM
Re: Commit response slow   473 Heiko Kiesssling 05/11/2012 01:31AM
Re: Commit response slow   462 Rick James 05/12/2012 10:31PM
disable keys (index) before delete or not?   725 Hélio Shimojo 05/11/2012 07:23AM
Re: disable keys (index) before delete or not?   659 Rick James 05/12/2012 12:12PM
Pages:  Previous 1 2 3 4 5 ...Last Next
Current Page: 3 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.