homepage Welcome to WebmasterWorld Guest from 204.236.254.124
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
Timeouts
FromBelgium




msg:3689836
 7:34 pm on Jul 3, 2008 (gmt 0)

Often my pages (using PHP and MySQL) do not render completely. It get error "Fatal error: Maximum execution time of 30 seconds exceeded in...". Even cached Google pages by show this message. Other times the page loads in a fraction of a second. Also accessing database with phpMyAdmin gives this error.

The webhost said that SQL timeouts are almost always caused by blocking issues related to the implementation of the client or clients. One client could for example leave an update transaction open and thus block any other clients trying do perform a committed read.

I do not understand this. Can someone please give some more hints?

 

Seb7




msg:3689931
 8:54 pm on Jul 3, 2008 (gmt 0)

Server is set to timeout if a page hasnt finished its job within a specific period. The timeout period can be increased, though it sounds like you have SQL performance issues that need resolving.

My gut feeling is that you probably have some table that has now got too big and needs trimming back.

FromBelgium




msg:3691708
 7:26 pm on Jul 6, 2008 (gmt 0)

The webhost was not able to offer support for "obvious" reasons. Bad support!
The site was hosted on a Windows Server. I changed to a Linux Server and my problem is solved now! It took me a few hours of work to move the site. My lesson: do not use MySQL/PHP on Windows server.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved