A couple of questions regarding SQL and download speed..

[tinypilot]

Well this is two different questions hope that someone can help me out.

Regarding SQL, I have suddenly got a problem that I haven't seen before, so I was wondering if something has changed. When making a full back-up of my site or my clients site, I get the following error:

MA DB function failed with error number 2006
MySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m WHERE m.published = 1 AND m.position = 'debug' AND m.client_id = 1 ORDER BY m.ordering
SQL = (and then some...)

The back-up does get generated, but it seems that the SQL server times out or something. I have tried to optimize and repair the database but there isn't any problems. It has not always worked like this, so I was wondering if something changed regarding SQL timings?

Another problem is bandwith... I tried to download a 900mb backup file from one of the servers. It was not running that fast - around 300 - 500kbps on a 20mbit connection, but I could not access the site at all while downloading as if my download was occuping the whole bandwith to the site...? The second the download was done the site loaded in a second, while downloading I could not get access to the site at all (other sites were easy to access). Is this normal?? It seems VERY limited?

A last question is regarding emails.. I wanted to have a cron job send me the backup file of a database to my email (around 70mb) this was not possible according to the cron job message - what is the email sending limit with Bluehost??

Thanks for any hints!

[Early Out]

I tried to download a 900mb backup file from one of the servers. It was not running that fast - around 300 - 500kbps on a 20mbit connection, but I could not access the site at all while downloading as if my download was occuping the whole bandwith to the site...?That sounds about right. The bandwidth for any single connection to your site is limited to, I believe, 4 megabits per second. If you're getting about 500 kbytes per second, that's using pretty much the entire bandwidth.

Another user trying to access the site would have had no problem - the limitation seems to apply to the connection between the server and a given IP address.

[adddfico]

I'm fairly certain the max attachment size is 50mb, although they don't suggest anything over 10mb.

[Early Out]

I'm fairly certain the max attachment size is 50mb, although they don't suggest anything over 10mb.That's an email thing. What does it have to do with download bandwidth?

[hofmax]

So if the bandwidth is limited to 4000 kbytes per second/connection then how many of those connections are we limited to? What's the limit on simultaneous connections? Sorry for slightly derailing the thread.

[Early Out]

So if the bandwidth is limited to 4000 kbytes per second/connection then how many of those connections are we limited to? What's the limit on simultaneous connections?All connections you make are coming from the same IP address, so it doesn't really matter. There might be a limit on the number of connections you can make from one IP address, but since all of those connections end up sharing the same 4mbps limit, making a lot of connections is just self-defeating.

Also, I'd guess that making a large number of connections from a single IP address begins to look like a DOS attack, and might get your IP firewalled.

Other users accessing your site are coming in on different IP addresses. I don't think there's any limit on how many different users can access your site simultaneously, up to whatever the BH pipelines, routers, and servers can handle.

[hofmax]

Other users accessing your site are coming in on different IP addresses. I don't think there's any limit on how many different users can access your site simultaneously, up to whatever the BH pipelines, routers, and servers can handle.

There are a few flash games I have developed and I was wondering whether I would run into any connection limits if people start hot linking them from myspace et al . But it looks like I will have to find out by trial and error :rolleyes:

[tinypilot]

Thanks for the replies - glad to know that the limit is for one connection only..
And thanks for the knowledge about email limit as well.