Re: Queries take long long(10 sec.) time running

On 12/07/11 1:27 AM, Andre Lopes wrote:
> This is enough information for some clues on how to increase the
> response time in queries?

no.

to optimize queries, you generally need to know what the queries are,
what the relations they are using look like, and get the output of
`explain analyze <your query>;`

some random comments in passing...

  * whats mysql got to do with this?

  * a server running efficiently should be using zero swap.   the fact
    that you have 340MB of swap used implies you need at least twice as
    much physical memory as you have.

  * VPS?  as in virtual server?  so your disk IO is virtualized too?
    this is usually bad news for getting decent database performance.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast