Forums / General Questions / MySQL bottlneck - getting mysql errors

MySQL bottlneck - getting mysql errors

Locked

Views: 4,594

Results 21 to 26 of 26
This thread is locked. New replies are disabled.
2 May 2008, 8:52 PM
#21
francocauter avatar

francocauter

Zen Follower

Join Date:
Jun 2007
Location:
Milton Keynes UK
Posts:
153
Plugin Contributions:
0

MySQL bottlneck - getting mysql errors

I need your expert opinion, can you please help me?
Does the MySQL 5 give problems of image re-sizing on hovering over the images and browser waiting for about 20 secs before it loads the page?
I would appreciate your answers
Thanks

2 May 2008, 10:39 PM
#22
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: MySQL bottlneck - getting mysql errors

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

Zen-Venom Get Bitten

3 May 2008, 9:27 AM
#23
francocauter avatar

francocauter

Zen Follower

Join Date:
Jun 2007
Location:
Milton Keynes UK
Posts:
153
Plugin Contributions:
0

Re: MySQL bottlneck - getting mysql errors

kobra:

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:smile:
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.

3 May 2008, 9:36 AM
#24
chuck avatar

chuck

Totally Zenned

Join Date:
Jul 2005
Posts:
255
Plugin Contributions:
0

Re: MySQL bottlneck - getting mysql errors

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.

3 May 2008, 10:30 AM
#25
francocauter avatar

francocauter

Zen Follower

Join Date:
Jun 2007
Location:
Milton Keynes UK
Posts:
153
Plugin Contributions:
0

Re: MySQL bottlneck - getting mysql errors

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.

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.

3 May 2008, 5:35 PM
#26
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: MySQL bottlneck - getting mysql errors

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

Zen-Venom Get Bitten