I think this happens one or the other time with every one whose blog is hosted under shared hosting.
One of my articles got dugg yesterday and resulted in quite a few hits for the next 24 hrs(~5000). Very soon I also recieved an email from my hosting provider(siteground) that the traffic has caused the server to get overloaded and has affected the performance of other websites including mine. The usual stuff.
The only useful information that they have provided me with was that my website contains a large number of internal links(270 is their count) and they result in large number of simultaneous MySQL queries.
Is there any caveat regarding how many internal links should be there on a website for X amount of server resources? Is the number of internal links on my blog too high? Or am I/SiteGround missing any database optimization tricks(which could be the actual culprit)?
Any help is appreciated.