homepage Welcome to WebmasterWorld Guest from
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


 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?



 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.


 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