MySQL going Slooooww
Moderator: General Moderators
MySQL going Slooooww
I have lots of queries that are copying to tmp table on disk.... is that bad?
Re: MySQL going Slooooww
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?