Page 1 of 1

MySQL going Slooooww

Posted: Wed Feb 06, 2008 2:58 pm
by GeXus
I have lots of queries that are copying to tmp table on disk.... is that bad?

Re: MySQL going Slooooww

Posted: Wed Feb 06, 2008 4:45 pm
by califdon
GeXus wrote:I have lots of queries that are copying to tmp table on disk.... is that bad?
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/