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