MySQL going Slooooww

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

MySQL going Slooooww

Post by GeXus »

I have lots of queries that are copying to tmp table on disk.... is that bad?
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: MySQL going Slooooww

Post 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/
Post Reply