On somebody's suggestion I used one sitemap generator for my live site containing more than 12000 pages.
When it reached 1000 or so pages, my Shared Hosting provider downed my site with "Server: too many connections".
It's been 2 hours my all sites are down.
I've also created a ticket but till now no response.
I want to ask:
1) For how long shared hosting providers disable the account due to this?
2) Can somebody can easily disable my account by using such sitemap generator?
3) Will any such blockage come in VPS accounts?
I've just now received the ticket response. It's a mysql issue they are looking into it.
But before this while I was using the sitemap generator, after 1000 urls the web server started sending 406 response for all page requests.
Can this happen in Shared hosting due to using sitemap generator?
You may also want to ask your hosting provider how many mySQL connections they provide.
Then see if this number of connections is suitable for your needs. Different providers will allow for more or less mySQL connections.
█ █ █ KiloServe Hosting - 48 Core Nodes and specializing in high disk I/O VPS
█ █ █ www.KiloServe.com Providing Quality Hosting since 2007
█ █ █ Specializing in Dedicated Servers, OpenVZ VPS, Xen VPS, and Windows VPS.
I would suggest a small dedicated server. Ive seen a datacenter or 2 in the past take down a vps due to excess cpu usage.
Very good point. Our VPS customers are allotted not only bandwidth and disk space, but resource limits as well. They are made aware of CPU & RAM limitations. Most clients do not run into issues with this however.
██ Stream101 | Affordable Media Solutions
██ Shared/Reseller cPanel® Web Hosting | WordPress Hosting | Premium Stream Hosting
██ TOLL-FREE: (877) 240-7767 | 30 Day NO QUESTIONS Money-Back Guarantee
██ 100% Cogent Free Network | CloudLinux OS | Tier 1 Bandwidth | Grand Rapids, MI
What sort of back-end is your site based on? If this is a dynamic site (PHP/MySQL for instance) it is definitely possible that you are creating a high load on the system. If your pages do not change very often, you should definitely look into implementing caching (i.e. converting pages into static HTML files). This will reduce load considerably and likely minimize the chances of receiving the "too many connections" error. Based on your error description it is not entirely clear whether this is some sort of limitation the host has placed in their web server configuration (limiting individual accounts on concurrent connections), or in fact a MySQL database limit. Some hosts are strict on concurrent connections for MySQL databases (I've seen as low as 10-15), while others are a lot more flexible, so this is definitely something you should check into. The fact that you have a lot of pages alone is not a huge problem, as long as you have a properly optimized site.
MediaLayer, LLC - www.medialayer.comLearn how we can make your website load faster, translating to better conversion rates for your business!
The pioneers of optimized web hosting, featuring LiteSpeed Web Server & SSD Storage - Celebrating 10 Years in Business