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