MySQL going Slooooww
Posted: Wed Feb 06, 2008 2:58 pm
I have lots of queries that are copying to tmp table on disk.... is that bad?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Depends on how complex your queries are. MySQL tries to optimize and that sometimes requires saving tmp tables. I think there are some advanced methods to have it use memory instead of HD, if you have lots of RAM and your result sets aren't gigantic. Dunno if this would help: http://www.danga.com/memcached/GeXus wrote:I have lots of queries that are copying to tmp table on disk.... is that bad?