MySQL bottlneck - getting mysql errors

[francocauter]

Should not have any impact on hover -

Try enabling the parse times to see what/where the issue might be

admin > config > logging > Display The Page Parse Time > set to true

Thanks Kobra
I have done that, Iam getting this:
Warning: error_log(home/livemk/public_html/cache/page_parse_time.log) [function.error-log]: failed to open stream: No such file or directory in /home/livemk/public_html/admin/includes/classes/logger.php on line 60

What is page parse time? how can the page parse time be lowered?

page parse time takes about 10secs on refresh at the moment.
I was convinced it was to do with the time that takes to dialogue to establish a connection to the db.

[chuck]

Page parse time is how long it takes to process the page.
Query time is how long the database queries take.

Your error message about the parse time log file not found is because you turned on the "Store page parse times" setting ... instead of the "display parse times" setting. Turn off the "store page parse times" setting -- you don't need to store them, just display them.

[francocauter]

Page parse time is how long it takes to process the page.
Query time is how long the database queries take.

Your error message about the parse time log file not found is because you turned on the "Store page parse times" setting ... instead of the "display parse times" setting. Turn off the "store page parse times" setting -- you don't need to store them, just display them.

Thanks Chuck
Why the same page resolves faster in a server then another? thats my problem.
I have the live site on a server on a shared platform of 300 and when the server its busy its slow but at the moment is like a bullit so I got a virtual srver so I am on my own, but I have a steady page parse time of approx 10secs
and the images do not re-size to the admin settings when you hover over, the hover image is the original size.

[kobra]

What is page parse time? how can the page parse time be lowered?

I got a virtual srver so I am on my own, but I have a steady page parse time of approx 10secs

VPS is noce if you know enough to tweak the LAMP settings and these are not something that hosts share. It is most likely the default settings that is the issue.
Asking here what they should be will probably net no responses