Skip navigation links

MySQL Forums :: Performance


Advanced Search

Announcements Last Post
• MySQL Community Server 5.0.88 has been released 11/20/2009 03:10PM
• MySQL Workbench 5.2.8 (BETA 1): Upgrade from MySQL Administrator, MySQL Query Browser 11/18/2009 05:29PM
• MySQL Community Server 5.1.41 has been released 11/18/2009 01:04PM
• MySQL Connector/Net 6.1.3 has been released 11/16/2009 12:09PM
• MySQL Connector/Net 6.2.1 beta has been released 11/16/2009 11:59AM
Pages:  Previous1 2 3 4 5 ...LastNext
Current Page: 4 of 46
Subject Views Written By Posted
Mysql server configuration.....   630 Ashok kumar 07/23/2009 11:52PM
Left Join Causes Table Scan   704 Jeff Gilbert 07/23/2009 05:34PM
Re: Left Join Causes Table Scan   491 Jeff Gilbert 07/23/2009 05:39PM
Select statement with multiple joins and unions on tables with approximately 2 million records each....improve performance?   1,383 Josephine S 07/20/2009 04:35PM
Re: Select statement with multiple joins and unions on tables with approximately 2 million records each....improve performance?   589 Josephine S 07/21/2009 03:46PM
Re: Select statement with multiple joins and unions on tables with approximately 2 million records each....improve performance?   617 Josephine S 07/23/2009 11:54AM
Simple Query Optimization   667 Alessandro Di Lello 07/22/2009 03:28AM
variable columns in stored procedure   626 ton dewilde 07/22/2009 12:48AM
How to make IN() not to sort?   620 Yordan Zaykov 07/21/2009 10:28AM
Update problem...   754 Jerome Quintard 07/07/2009 12:25PM
Re: Update problem...   522 Rick James 07/08/2009 09:54PM
Re: Update problem...   457 Jerome Quintard 07/21/2009 02:42AM
LIMIT issue: performance flaw   630 Yordan Zaykov 07/20/2009 09:36AM
is there a sense for preparing statements in stored procedures?   604 max ulidtko 07/20/2009 08:55AM
performance increases when mysql server restart   696 awadhesh yona 07/16/2009 05:40AM
Re: performance increases when mysql server restart   407 Aftab Khan 07/16/2009 06:47AM
Re: performance increases when mysql server restart   510 awadhesh yona 07/20/2009 12:31AM
Query per hour, for each db   755 Marco Collareda 07/17/2009 01:26AM
Re: Query per hour, for each db   541 Rick James 07/18/2009 12:11PM
innodb locking degrade performance   636 Yogesh Malik 07/16/2009 07:05AM
Re: innodb locking degrade performance   476 Rick James 07/17/2009 11:08PM
Trying to optimize a JOIN using STRAIGHT_JOIN, but EXPLAIN table order remains same   856 Masao Kitamura 07/15/2009 02:13AM
Re: Trying to optimize a JOIN using STRAIGHT_JOIN, but EXPLAIN table order remains same   580 Masao Kitamura 07/15/2009 02:54AM
Re: Trying to optimize a JOIN using STRAIGHT_JOIN, but EXPLAIN table order remains same   598 Rick James 07/16/2009 08:00PM
Performance issue with Stored Procedure Execution   685 ramkumar meyyappan 07/14/2009 06:45AM
Re: Performance issue with Stored Procedure Execution   491 Neil Ferguson 07/15/2009 06:39AM
Re: Performance issue with Stored Procedure Execution   554 ramkumar meyyappan 07/15/2009 07:35AM
Unindexed constant selects same speed on growing table (MyISAM)   685 Peter Müller 07/13/2009 02:21AM
Re: Unindexed constant selects same speed on growing table (MyISAM)   516 Peter Müller 07/13/2009 03:31AM
Re: Unindexed constant selects same speed on growing table (MyISAM)   526 Adam Erickson 07/13/2009 03:30PM
Re: Unindexed constant selects same speed on growing table (MyISAM)   499 Peter Müller 07/13/2009 03:47PM
Re: Unindexed constant selects same speed on growing table (MyISAM)   504 Rick James 07/14/2009 08:18PM
MySQL Performance Issue: Your Thoughts?   660 Ryan May 07/13/2009 06:35PM
Re: MySQL Performance Issue: Your Thoughts?   500 Rick James 07/14/2009 08:00PM
Best practise for taking snapshot of 1,000s of INT values?   1,037 Nickolas Daskalou 05/20/2009 11:09PM
Re: Best practise for taking snapshot of 1,000s of INT values?   746 Adam Erickson 05/22/2009 09:56PM
Re: Best practise for taking snapshot of 1,000s of INT values?   647 Nickolas Daskalou 06/22/2009 01:09AM
Re: Best practise for taking snapshot of 1,000s of INT values?   778 Rick James 05/21/2009 12:10AM
Re: Best practise for taking snapshot of 1,000s of INT values?   597 Nickolas Daskalou 06/21/2009 11:50PM
Re: Best practise for taking snapshot of 1,000s of INT values?   646 Rick James 06/22/2009 12:27AM
Re: Best practise for taking snapshot of 1,000s of INT values?   630 Nickolas Daskalou 06/22/2009 02:04AM
Re: Best practise for taking snapshot of 1,000s of INT values?   606 Rick James 06/22/2009 10:40AM
Re: Best practise for taking snapshot of 1,000s of INT values?   495 Nickolas Daskalou 07/14/2009 02:18AM
Insert into table on duplicate key update - performance issue   1,195 Sreedevi Iyer 07/10/2009 01:43PM
Re: Insert into table on duplicate key update - performance issue   726 Rick James 07/11/2009 03:16PM
Re: Insert into table on duplicate key update - performance issue   704 Sreedevi Iyer 07/13/2009 06:55PM
Re: Insert into table on duplicate key update - performance issue   692 Rick James 07/13/2009 08:33PM
Thread concurrency on   867 Jeroen Straathof 07/10/2009 02:44PM
Re: Thread concurrency on   602 Rick James 07/11/2009 04:07PM
how to improve performance   667 sindhurapushpa m 07/09/2009 02:02AM
Re: how to improve performance   536 Rick James 07/10/2009 10:12PM
Left join very slow   827 Mariel Gonzales 07/09/2009 10:12AM
Re: Left join very slow   584 Rick James 07/09/2009 08:55PM
Optimize MySQL queries   1,192 Heshan Wanigsooriya 07/08/2009 12:04AM
Re: Optimize MySQL queries   602 Rick James 07/08/2009 09:52AM
Simple Performance Question   1,113 Ted Elkind 05/02/2009 03:40PM
Re: Simple Performance Question   596 Ted Elkind 06/28/2009 04:06PM
Re: Simple Performance Question   567 Rick James 06/28/2009 09:18PM
Re: Simple Performance Question   528 Ted Elkind 07/04/2009 09:28AM
Re: Simple Performance Question   531 Rick James 07/04/2009 02:08PM
Re: Simple Performance Question   516 Ted Elkind 07/07/2009 09:25AM
Re: Simple Performance Question   536 Rick James 07/07/2009 08:18PM
Re: Simple Performance Question   828 Rick James 05/02/2009 05:28PM
Re: Simple Performance Question   840 Ted Elkind 05/03/2009 06:34AM
Re: Simple Performance Question   822 Rick James 05/03/2009 04:00PM
rebuild huge innodb table (very slow...) - Need help!!   742 zohar aharoni 07/06/2009 07:08AM
Re: rebuild huge innodb table (very slow...) - Need help!!   581 Rick James 07/07/2009 08:45AM
Query not using index in ORDER BY   878 Sebastian Ilari 07/03/2009 12:54PM
Re: Query not using index in ORDER BY   586 Rick James 07/04/2009 02:29PM
Re: Query not using index in ORDER BY   533 Sebastian Ilari 07/06/2009 10:25AM
Re: Query not using index in ORDER BY   540 Rick James 07/06/2009 09:15PM
Get statistics using self joins (query too slow)   819 SAUD GONZALEZ 06/24/2009 11:26PM
Re: Get statistics using self joins (query too slow)   627 Rick James 06/26/2009 04:18AM
Re: Get statistics using self joins (query too slow)   606 SAUD GONZALEZ 06/30/2009 07:05PM
Re: Get statistics using self joins (query too slow)   569 Rick James 06/30/2009 08:58PM
Re: Get statistics using self joins (query too slow)   586 Saud G. 07/06/2009 10:56AM
Re: Get statistics using self joins (query too slow)   536 Saud G. 07/06/2009 11:41AM
Re: Get statistics using self joins (query too slow)   532 Rick James 07/06/2009 09:00PM
Importing a large data into the database   783 Satoru Moriwaki 07/03/2009 12:17AM
Re: Importing a large data into the database   545 Rick James 07/04/2009 03:02PM
Re: Importing a large data into the database   551 Satoru Moriwaki 07/04/2009 09:00PM
Re: Importing a large data into the database   543 Rick James 07/04/2009 11:21PM
Re: Importing a large data into the database   545 Satoru Moriwaki 07/05/2009 11:17AM
Altering Table to Add column very slow   1,186 Abraham Alex 07/03/2009 02:41AM
Re: Altering Table to Add column very slow   793 Rick James 07/04/2009 04:17PM
Re: Altering Table to Add column very slow   772 Abraham Alex 07/04/2009 11:30PM
Re: Altering Table to Add column very slow   714 Rick James 07/05/2009 10:02AM
simple Join is very slow   759 Kasey Speakman 07/01/2009 10:00AM
Re: simple Join is very slow   543 Kasey Speakman 07/02/2009 08:58AM
Re: simple Join is very slow   490 Rick James 07/03/2009 08:15PM
Query is taking long time - help   938 Atul MAHAJANA 06/28/2009 04:19AM
Re: Query is taking long time - help   598 Rick James 06/29/2009 11:52PM
Re: Query is taking long time - help   533 Atul MAHAJANA 07/02/2009 10:57PM
Performance Issues   842 maximilian thumfart 06/29/2009 06:44AM
Re: Performance Issues   585 Ray Chambers 06/29/2009 10:45AM
Re: Performance Issues   558 maximilian thumfart 06/29/2009 02:59PM
Re: Performance Issues   626 maximilian thumfart 06/29/2009 03:02PM
Re: Performance Issues   586 maximilian thumfart 06/30/2009 04:04AM
Re: Performance Issues   573 Ray Chambers 06/30/2009 08:21AM
Re: Performance Issues   594 maximilian thumfart 06/30/2009 02:45PM
Re: Performance Issues   560 Ray Chambers 06/30/2009 06:45PM
Re: Performance Issues   538 maximilian thumfart 07/01/2009 01:48AM
Re: Performance Issues   544 Ray Chambers 07/01/2009 06:57AM
Re: Performance Issues   534 maximilian thumfart 07/01/2009 07:14AM
Re: Performance Issues   570 Ray Chambers 07/01/2009 08:20AM
Re: Performance Issues   561 Rick James 07/02/2009 08:39AM
I'm looking for the best way to join two tables based on the matching of the words in a varchar field in one table against a varchar field on another table   507 Edgardo Grinblat 06/30/2009 10:38AM
Re: I'm looking for the best way to join two tables based on the matching of the words in a varchar field in one table against a varchar field on another table   548 Rick James 07/01/2009 07:55PM
Re: I'm looking for the best way to join two tables based on the matching of the words in a varchar field in one table against a varchar field on another table   525 Edgardo Grinblat 07/02/2009 06:38AM
speed of query/can index help?   828 Ray Chambers 06/26/2009 06:15PM
Re: speed of query/can index help?   629 Elli 06/26/2009 08:56PM
Re: speed of query/can index help?   578 Ray Chambers 06/26/2009 09:39PM
Re: speed of query/can index help?   602 Elli 06/27/2009 03:04AM
Re: speed of query/can index help?   576 Ray Chambers 06/27/2009 07:45AM
Re: speed of query/can index help?   557 Rick James 06/27/2009 10:39AM
Re: speed of query/can index help?   586 Ray Chambers 06/29/2009 07:13AM
Re: speed of query/can index help?   525 Rick James 06/30/2009 12:26AM
Re: speed of query/can index help?   512 Ray Chambers 06/30/2009 08:08AM
Re: speed of query/can index help?   551 Rick James 06/30/2009 10:36PM
Re: speed of query/can index help?   479 Ray Chambers 07/01/2009 01:33PM
Re: speed of query/can index help?   497 Rick James 07/01/2009 08:22PM
Re: speed of query/can index help?   571 Ray Chambers 06/27/2009 07:38AM
Re: speed of query/can index help?   564 Ray Chambers 06/27/2009 06:59AM
Decreased performance when using functions on cross-database-queries after upgrade   851 Uli Staerk 07/01/2009 06:48AM
Re: Decreased performance when using functions on cross-database-queries after upgrade   509 Uli Staerk 07/01/2009 08:07AM
performance optimization   748 Yogesh Malik 06/29/2009 06:47AM
Re: performance optimization   537 Rick James 06/30/2009 11:01PM
When to increase ulimit -n and table cache   997 abhishek a 06/29/2009 11:54PM
Re: When to increase ulimit -n and table cache   735 Ray Chambers 06/30/2009 08:24AM
Slow query   713 Anuj Shukla 06/26/2009 04:32AM
Re: Slow query   513 Rick James 06/27/2009 10:29AM
Re: Slow query   496 Anuj Shukla 06/29/2009 04:49AM
Query result size and disk space growth   777 Bing Wu 06/28/2009 12:52AM
mysql performance   648 andy susanto 06/27/2009 07:12PM
DB server hangs after queries get timed out waiting for locks. Cpu resources exhausted. mysql had to be restarted   794 Imran Ashraf 06/26/2009 05:50AM
Re: DB server hangs after queries get timed out waiting for locks. Cpu resources exhausted. mysql had to be restarted   551 Rick James 06/27/2009 12:26PM
MySql crashes with signal 11 when using 2 indexes   655 Helen Yelluas 06/25/2009 07:30PM
Re: MySql crashes with signal 11 when using 2 indexes   492 Rick James 06/27/2009 12:33AM
Query optimization on OR with two indexes   793 Elli 06/26/2009 08:49PM
slow join query   773 Trond Kristiansen 06/23/2009 12:59PM
Re: slow join query   550 Rick James 06/24/2009 10:41PM
Re: slow join query   538 Trond Kristiansen 06/25/2009 05:57AM
Re: slow join query   546 Rick James 06/25/2009 09:25AM
Re: slow join query   614 Trond Kristiansen 06/25/2009 01:26PM
Re: slow join query   566 Rick James 06/25/2009 09:37PM
multiple joins nightmare   1,133 Liron ... 06/12/2009 08:44PM
Re: multiple joins nightmare   728 Rick James 06/12/2009 10:28PM
Reverse Snowflake Joins   573 Alexandru Toth 06/24/2009 03:08PM
Re: Reverse Snowflake Joins   535 Liron ... 06/25/2009 03:25AM
loops and chasm traps   590 Alexandru Toth 06/25/2009 02:49PM
Re: multiple joins nightmare   622 Liron ... 06/12/2009 11:41PM
Re: multiple joins nightmare   633 Rick James 06/13/2009 11:23PM
Re: multiple joins nightmare   641 Liron ... 06/14/2009 12:32AM
Re: multiple joins nightmare   629 Rick James 06/14/2009 10:08AM
Re: multiple joins nightmare   707 Liron ... 06/14/2009 01:18PM
Re: multiple joins nightmare   591 Rick James 06/14/2009 09:09PM
Re: multiple joins nightmare   621 Liron ... 06/15/2009 01:54AM
Re: multiple joins nightmare   598 Rick James 06/15/2009 08:41AM
Re: multiple joins nightmare   600 Liron ... 06/15/2009 09:19AM
Re: multiple joins nightmare   563 Alexandru Toth 06/21/2009 04:35PM
Re: multiple joins nightmare   634 Liron ... 06/12/2009 11:20PM
Re: multiple joins nightmare   683 Liron ... 06/12/2009 10:51PM
Query Performance   691 Nils Heldt 06/22/2009 03:47AM
Re: Query Performance   512 Rick James 06/23/2009 10:59PM
Join two tables - not using the right indices   855 F N 06/16/2009 08:40AM
Re: Join two tables - not using the right indices   646 Rick James 06/17/2009 10:37PM
Re: Join two tables - not using the right indices   547 F N 06/23/2009 11:23AM
Re: Join two tables - not using the right indices   548 Rick James 06/23/2009 07:14PM
simple large table runs slow   801 andy kuo 06/18/2009 03:24AM
Re: simple large table runs slow   612 Aftab Khan 06/19/2009 02:20AM
Re: simple large table runs slow   571 Rick James 06/19/2009 08:52AM
Mysql 5.1.30 and InnoDB 1.0.3 vs PostgreSQL   896 Adrian Stanila 06/19/2009 01:19AM
Make use of extra ram?   549 Amer J 06/17/2009 12:11PM
Re: Make use of extra ram?   549 Rick James 06/18/2009 09:09PM
MySQL is using a lot of CPU   858 Maxime Aoustin 06/15/2009 10:52PM
Re: MySQL is using a lot of CPU   648 Rick James 06/17/2009 12:09AM
Re: MySQL is using a lot of CPU   644 Maxime Aoustin 06/17/2009 12:38AM
Re: MySQL is using a lot of CPU   612 Rick James 06/17/2009 07:43PM
Re: MySQL is using a lot of CPU   703 Maxime Aoustin 06/17/2009 07:57PM
Re: MySQL is using a lot of CPU   615 Rick James 06/17/2009 10:17PM
Pages:  Previous1 2 3 4 5 ...LastNext
Current Page: 4 of 46
powered by phorum