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: 2 of 46
Subject Views Written By Posted
MySQL rand() is slow on large datasets   539 maximiliam daniel 10/08/2009 02:12PM
Re: MySQL rand() is slow on large datasets   319 Rick James 10/09/2009 07:32PM
Re: MySQL rand() is slow on large datasets   320 maximiliam daniel 10/09/2009 10:21PM
Re: MySQL rand() is slow on large datasets   344 Rick James 10/10/2009 11:22AM
Re: MySQL rand() is slow on large datasets   300 maximiliam daniel 10/17/2009 03:12PM
Re: MySQL rand() is slow on large datasets   275 Rick James 10/17/2009 06:18PM
Re: MySQL rand() is slow on large datasets   271 maximiliam daniel 10/18/2009 02:44PM
Re: MySQL rand() is slow on large datasets   265 maximiliam daniel 10/18/2009 03:21PM
Re: MySQL rand() is slow on large datasets   259 Rick James 10/18/2009 04:37PM
size of [innodb_buffer_pool_size] in Windows 2003 (32 bits)   371 Sebastián Gómez 10/15/2009 06:35PM
Re: size of [innodb_buffer_pool_size] in Windows 2003 (32 bits)   259 Stefan Rindeskar 10/17/2009 11:26AM
Re: size of [innodb_buffer_pool_size] in Windows 2003 (32 bits)   235 Rick James 10/17/2009 06:25PM
Re: size of [innodb_buffer_pool_size] in Windows 2003 (32 bits)   254 Rick James 10/16/2009 09:26PM
Not having luck with GROUP BY in 2-table join   425 Wired Insight 10/15/2009 11:45AM
Re: Not having luck with GROUP BY in 2-table join   263 Rick James 10/16/2009 09:15PM
High granularity DB hits vs sleeping SQL processes.   773 David T 08/01/2009 02:14AM
Re: High granularity DB hits vs sleeping SQL processes.   271 Matt Pardee 10/16/2009 03:17AM
Re: High granularity DB hits vs sleeping SQL processes.   522 Rick James 08/07/2009 10:22PM
Are SELECT fields optimized to avoid repeated evaluation of the same expressions?   334 Stephen Cantini 10/15/2009 09:52AM
Very high CPU utilisation with 40-50 concurrent connection on Innodb table   382 Pankaj joshi 10/14/2009 08:43AM
Re: Very high CPU utilisation with 40-50 concurrent connection on Innodb table   295 Rick James 10/15/2009 12:13AM
Unique constraint multiple columns vs md5   633 Amnon Lahav 10/14/2009 11:07AM
Re: Unique constraint multiple columns vs md5   335 Rick James 10/14/2009 11:11PM
Best performance for a modified date on a record   410 Matthew Berg 10/12/2009 01:32PM
Re: Best performance for a modified date on a record   283 Stefan Rindeskar 10/13/2009 06:29AM
Re: Best performance for a modified date on a record   250 Matthew Berg 10/13/2009 10:16AM
Re: Best performance for a modified date on a record   258 Stefan Rindeskar 10/13/2009 01:23PM
Re: Best performance for a modified date on a record   264 Rick James 10/14/2009 05:58PM
IP Bypass for many connections error   355 Justin Beeler 10/13/2009 05:10PM
Re: IP Bypass for many connections error   258 Stefan Rindeskar 10/14/2009 06:41AM
Slow "checking permissions"   751 Raphael Thoma 08/06/2009 06:25AM
Re: Slow "checking permissions"   514 Rick James 08/07/2009 05:59PM
Re: Slow "checking permissions"   247 Matthew Montgomery 10/12/2009 09:28PM
PHP Applications: 120 Performance Tuning screws for MySQL   382 Edwin DeSouza 10/12/2009 06:24PM
Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   827 sathish kumar 09/26/2009 02:57AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   488 Rick James 09/27/2009 10:41AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   504 sathish kumar 09/27/2009 11:55AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   459 Rick James 09/27/2009 12:13PM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   478 sathish kumar 09/28/2009 01:20AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   455 sathish kumar 09/28/2009 01:53AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   467 Rick James 09/28/2009 09:19AM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   416 sathish kumar 10/10/2009 03:08PM
Re: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux   478 Rick James 10/10/2009 10:27PM
Are impossible queries executed?   357 Guillaume Voyer 10/09/2009 07:13AM
Re: Are impossible queries executed?   255 Rick James 10/10/2009 11:02AM
Slow Connection   451 facha facha 10/04/2009 06:28PM
Re: Slow Connection   342 Stefan Rindeskar 10/06/2009 09:29AM
Re: Slow Connection   285 facha Mix 10/09/2009 07:48AM
Application slows down with more databases.   395 Ritu Tandon 10/05/2009 04:18AM
Re: Application slows down with more databases.   254 Stefan Rindeskar 10/06/2009 09:55AM
Re: Application slows down with more databases.   253 Ritu Tandon 10/08/2009 04:39AM
200 000 queries - do not execute all of them   379 Vladislav Qkimov 10/07/2009 04:11AM
Re: 200 000 queries - do not execute all of them   269 Vladislav Qkimov 10/08/2009 04:04AM
Re: 200 000 queries - do not execute all of them   264 Stefan Rindeskar 10/07/2009 02:29PM
Re: 200 000 queries - do not execute all of them   253 Rick James 10/07/2009 07:15PM
Slow SELECT   414 Marc Larue 10/05/2009 01:46PM
Re: Slow SELECT   299 Stefan Rindeskar 10/06/2009 09:21AM
Re: Slow SELECT   298 Rick James 10/06/2009 09:01PM
IIS 6.0 Hang   338 Prashant Tiwari 10/06/2009 06:40AM
Re: IIS 6.0 Hang   250 Stefan Rindeskar 10/06/2009 09:57AM
Doing Indexing for datetime   369 Eyrique Wong 10/05/2009 08:42PM
Re: Doing Indexing for datetime   274 Stefan Rindeskar 10/06/2009 09:46AM
decrease in performance   423 alev mutlu 10/03/2009 04:16AM
Re: decrease in performance   256 Rick James 10/04/2009 11:21AM
log slow queries is not logging the slow queries.   708 sathish kumar 08/25/2009 04:17AM
Re: log slow queries is not logging the slow queries.   486 Umesh Shastry 09/08/2009 02:41AM
Re: log slow queries is not logging the slow queries.   499 sathish kumar 09/08/2009 02:54AM
Re: log slow queries is not logging the slow queries.   483 Umesh Shastry 09/08/2009 04:11AM
Re: log slow queries is not logging the slow queries.   532 Rick James 09/09/2009 08:48AM
Re: log slow queries is not logging the slow queries.   376 Ritu Tandon 09/30/2009 03:07AM
Re: log slow queries is not logging the slow queries.   366 Rick James 09/30/2009 09:27PM
100% CPU load problem   655 Law Robertson 09/21/2009 01:20PM
Re: 100% CPU load problem   489 Rick James 09/21/2009 08:07PM
Re: 100% CPU load problem   483 Law Robertson 09/22/2009 11:05AM
Re: 100% CPU load problem   407 Rick James 09/22/2009 08:30PM
Re: 100% CPU load problem   423 Law Robertson 09/24/2009 10:52AM
Re: 100% CPU load problem   380 Rick James 09/25/2009 12:02AM
Re: 100% CPU load problem   382 Law Robertson 09/25/2009 12:02PM
Re: 100% CPU load problem   395 Stefan Rindeskar 09/27/2009 06:15PM
Re: 100% CPU load problem   361 Rick James 09/25/2009 11:36PM
Re: 100% CPU load problem   407 Law Robertson 09/28/2009 01:03PM
Re: 100% CPU load problem   363 Law Robertson 09/28/2009 01:43PM
Re: 100% CPU load problem   422 Jason Welter 09/28/2009 05:00PM
Re: 100% CPU load problem   345 Law Robertson 09/29/2009 11:14AM
Re: 100% CPU load problem   339 Stefan Rindeskar 09/29/2009 03:32PM
Re: 100% CPU load problem   421 Law Robertson 09/29/2009 04:33PM
Re: 100% CPU load problem   400 Stefan Rindeskar 09/29/2009 06:54PM
Re: 100% CPU load problem   358 Rick James 09/29/2009 10:30PM
Re: 100% CPU load problem   407 Law Robertson 09/30/2009 12:11PM
Re: 100% CPU load problem   366 Jason Welter 09/29/2009 01:09PM
Re: 100% CPU load problem   355 Stefan Rindeskar 09/29/2009 03:31PM
Re: 100% CPU load problem   505 Stefan Rindeskar 09/21/2009 03:19PM
Re: 100% CPU load problem   544 Law Robertson 09/21/2009 04:21PM
Slow on Production.   459 Ritu Tandon 09/20/2009 11:19PM
Re: Slow on Production.   356 Stefan Rindeskar 09/21/2009 03:26PM
Re: Slow on Production.   342 Rick James 09/21/2009 08:15PM
Re: Slow on Production.   340 Ritu Tandon 09/21/2009 11:13PM
Re: Slow on Production.   320 Rick James 09/21/2009 11:53PM
Re: Slow on Production.   353 Ritu Tandon 09/22/2009 02:53AM
Re: Slow on Production.   336 Ritu Tandon 09/22/2009 03:02AM
Re: Slow on Production.   338 Rick James 09/22/2009 08:02AM
Re: Slow on Production.   346 Ritu Tandon 09/21/2009 11:17PM
Re: Slow on Production.   298 Ritu Tandon 09/24/2009 11:19PM
Re: Slow on Production.   325 Rick James 09/24/2009 11:55PM
Re: Slow on Production.   307 Ritu Tandon 09/25/2009 12:16AM
Re: Slow on Production.   306 Rick James 09/25/2009 09:08AM
Re: Slow on Production.   315 Ritu Tandon 09/30/2009 03:05AM
./mysqlslap: unknown variable 'default-character-set=utf8'   470 h ch 09/22/2009 07:12PM
Re: ./mysqlslap: unknown variable 'default-character-set=utf8'   313 Erin ONeill 09/29/2009 01:10PM
Very slow Query time - how to fix that   502 Marijan Horvat 09/26/2009 06:08AM
Re: Very slow Query time - how to fix that   318 Stefan Rindeskar 09/29/2009 09:09AM
Re: Very slow Query time - how to fix that   369 Rick James 09/27/2009 10:36AM
WHERE IN performance rant   698 Van Stokes 09/27/2009 06:39AM
Re: WHERE IN performance rant   414 Rick James 09/28/2009 09:23AM
Re: WHERE IN performance rant   406 Van Stokes 09/28/2009 10:27AM
Re: WHERE IN performance rant   367 Rick James 09/28/2009 11:57PM
Re: WHERE IN performance rant   346 Stefan Rindeskar 09/29/2009 08:27AM
improve write operation   396 dara kok 09/27/2009 08:44PM
Re: improve write operation   311 Rick James 09/29/2009 12:15AM
Re: improve write operation   301 dara kok 09/29/2009 01:00AM
Re: improve write operation   290 Stefan Rindeskar 09/29/2009 07:46AM
COUNT(*) vs. COUNT(primarykey)   563 Raj Tsevhar 09/25/2009 07:19AM
Re: COUNT(*) vs. COUNT(primarykey)   371 Rick James 09/26/2009 09:53AM
Re: COUNT(*) vs. COUNT(primarykey)   391 Raj Tsevhar 09/26/2009 10:29AM
Re: COUNT(*) vs. COUNT(primarykey)   358 Rick James 09/26/2009 11:51AM
How to Optimize MySql Database?   606 Param dubey 09/24/2009 01:50AM
Re: How to Optimize MySql Database?   418 Rick James 09/25/2009 09:26AM
Maximum number of simultaneous connections on PowerEdge R805 Server   380 bcd iph 09/22/2009 08:14PM
Re: Maximum number of simultaneous connections on PowerEdge R805 Server   414 Rick James 09/23/2009 09:40PM
i use mysqlreport to get DB status ,but i dont know how to get the TPS from this report.   382 h ch 09/22/2009 07:37PM
Re: i use mysqlreport to get DB status ,but i dont know how to get the TPS from this report.   271 Rick James 09/23/2009 09:18PM
bad performance   383 Aji Raphel 09/23/2009 12:48AM
Re: bad performance   255 Stefan Rindeskar 09/23/2009 05:47PM
Re: bad performance   253 Rick James 09/23/2009 07:07PM
Slow Query Log not logging anything   428 Ritu Tandon 09/21/2009 03:49AM
Re: Slow Query Log not logging anything   304 Rick James 09/22/2009 08:37PM
Some question about join buffer   431 Zeng Paul 09/20/2009 08:08PM
Re: Some question about join buffer   273 Rick James 09/21/2009 08:39PM
Help optimizing query / index, ~1M row group by, order by   577 Jeff Byrom 09/14/2009 08:04AM
Re: Help optimizing query / index, ~1M row group by, order by   414 Rick James 09/15/2009 09:33AM
Re: Help optimizing query / index, ~1M row group by, order by   396 Jeff Byrom 09/17/2009 08:41AM
Re: Help optimizing query / index, ~1M row group by, order by   389 Rick James 09/17/2009 10:04AM
Re: Help optimizing query / index, ~1M row group by, order by   387 Stefan Rindeskar 09/21/2009 03:48PM
Re: Help optimizing query / index, ~1M row group by, order by   330 Rick James 09/21/2009 08:05PM
Slow INSERT INTO performance   578 Ian Fan 09/16/2009 07:08AM
Re: Slow INSERT INTO performance   473 Rick James 09/17/2009 09:14AM
Re: Slow INSERT INTO performance   356 Stefan Rindeskar 09/21/2009 03:59PM
Lots of slow queries - any reason?   499 Andrew Collington 09/16/2009 10:53AM
Re: Lots of slow queries - any reason?   330 Rick James 09/17/2009 08:35PM
Re: Lots of slow queries - any reason?   302 Andrew Collington 09/21/2009 05:17AM
Re: Lots of slow queries - any reason?   316 Rick James 09/21/2009 08:59AM
Re: Lots of slow queries - any reason?   339 Andrew Collington 09/16/2009 11:25AM
Monitor the executions of a query   448 Mauricio Baumler 09/18/2009 12:47PM
Re: Monitor the executions of a query   287 Rick James 09/19/2009 09:19PM
Problem in large pages   950 kamalakkannan gurudeva 07/08/2009 09:14PM
Re: Problem in large pages   322 Luca Delle Femmine 09/16/2009 08:52AM
Re: Problem in large pages   651 Rick James 07/10/2009 08:30PM
Re: Problem in large pages   606 kamalakkannan gurudeva 07/12/2009 07:12PM
Re: Problem in large pages   594 kamalakkannan gurudeva 07/15/2009 12:38AM
Re: Problem in large pages   657 kamalakkannan gurudeva 07/09/2009 06:42PM
Index vs Partition vs Other? for not-very-selective column   470 Nicholas Beaudrot 09/14/2009 02:04PM
Re: Index vs Partition vs Other? for not-very-selective column   310 Rick James 09/15/2009 09:22PM
MySQL 5.1 Performance Issues   483 Irfan Ali 09/15/2009 02:52PM
Terrible performance of a specific query with lots of connections   708 Ben Dowling 09/08/2009 12:17PM
Re: Terrible performance of a specific query with lots of connections   401 Rick James 09/09/2009 08:32PM
Re: Terrible performance of a specific query with lots of connections   369 Ben Dowling 09/10/2009 09:02AM
Re: Terrible performance of a specific query with lots of connections   405 Rick James 09/10/2009 07:27PM
Re: Terrible performance of a specific query with lots of connections   386 Ben Dowling 09/14/2009 07:56AM
Re: Terrible performance of a specific query with lots of connections   357 Rick James 09/14/2009 10:34AM
Re: Terrible performance of a specific query with lots of connections   343 Ben Dowling 09/15/2009 05:53AM
Re: Terrible performance of a specific query with lots of connections   365 Ben Dowling 09/14/2009 11:22AM
field equal to OR between 2 fields?   538 Jason McIver 09/11/2009 03:48AM
Re: field equal to OR between 2 fields?   422 Rick James 09/12/2009 09:03AM
Re: field equal to OR between 2 fields?   388 Jason McIver 09/12/2009 11:40PM
Log only and all joins that don't use indexes   486 Jonathan Robson 09/11/2009 06:44PM
Re: Log only and all joins that don't use indexes   355 Rick James 09/12/2009 09:50PM
Server spending too much time waiting for Kernel (%system in top is HIGH) under heavy load   513 Charles Bajomo 09/11/2009 07:45AM
Re: Server spending too much time waiting for Kernel (%system in top is HIGH) under heavy load   374 Rick James 09/12/2009 08:52AM
Selecting rows from table with millions of rows   532 Adeel Q 09/10/2009 04:46AM
Re: Selecting rows from table with millions of rows   349 Rick James 09/11/2009 07:01PM
small DB, big problems   505 SweeT EviL 09/08/2009 12:57PM
Re: small DB, big problems   350 Rick James 09/09/2009 08:26PM
Re: small DB, big problems   323 SweeT EviL 09/10/2009 10:39AM
Re: small DB, big problems   335 Rick James 09/10/2009 07:15PM
Re: small DB, big problems   324 SweeT EviL 09/11/2009 08:52AM
Re: small DB, big problems   328 Rick James 09/11/2009 09:53AM
Re: small DB, big problems   308 SweeT EviL 09/11/2009 10:16AM
Re: small DB, big problems   356 Rick James 09/11/2009 06:20PM
max_seeks_for_key   457 Wagner Bianchi 09/08/2009 09:10PM
How to optimize LIKE query with lots of records?   723 Mike Korvic 09/07/2009 10:37PM
Re: How to optimize LIKE query with lots of records?   500 Rick James 09/08/2009 09:04PM
Re: How to optimize LIKE query with lots of records?   473 Mike Korvic 09/08/2009 01:46AM
Slow range query using BETWEEN   653 Benjamin Meyer 09/04/2009 06:07AM
Re: Slow range query using BETWEEN   495 Rick James 09/05/2009 08:45AM
Re: Slow range query using BETWEEN   541 Benjamin Meyer 09/07/2009 04:41AM
Re: Slow range query using BETWEEN   424 Rick James 09/07/2009 09:58AM
Pages:  Previous1 2 3 4 5 ...LastNext
Current Page: 2 of 46
powered by phorum