Excessive creation of temp-tables in mysql is often a sign of missing indexes, or excessive use of ill-conceived queries with subqueries/outer-joins.
You might get a "quick fix" but turning on or increasing the query cache in Mysql.

But the better solution is to debug the problem here is one approach:
  1. enable the slow query log http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
  2. Run the application - or wait for the users to do it over some time.
  3. examine the log and identify the problematic select queries.
  4. run "explain" manually on those select queries to identify the tables/colums missing indexes.
  5. Create missing indexes.
  6. Check your stats/performance to see if it fixed the problem "enough".
  7. Send an email to the developer telling him to take a course in db design ;-)

..
Mike


On 11/17/14 12:08 PM, geoffrey gitagia via skunkworks wrote:

Thanks Adam
    I am running on a windows environment so I have 5.5 on it , I noticed is writes alot of temp files and at times converts to isam tables ,meaning that my io is going to be high ,from me resource monitor I can see lots of disk activities, it even at times freezes the server for a few seconds, another problem is that the tables have many columns of which the dev uses select * statements,  impacting on cache.  



_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke