Apparently someone at GoDaddy reads my blog, I got a call this afternoon from the ‘office of the president’ of GoDaddy and he referenced this blog posting.. that’s a trip isn’t it?
Well he was nice, but didn’t solve my problem, from what we gathered it could be a couple things, one is that there is a limit of 50 connections at one time to the database pulling data, there could be 200+ people on my site looking at it but only 50 can actually access the database…
Related to the DB, I also learned that there is no limit on the size of the database, I read somewhere a while ago that there was a 200mb limit on databases on GoDaddy shared hosting, but that limit was changed, too bad that they don’t mention this size anywhere on their site, maybe they should list that somewhere…
another problem could be the database itself, it was locking up for some reason, he recommended I optimize it… well I went into the backend of my site and deleted 4853 database entries, and then another 582 on top of that, I deleted old stuff from years ago, when you delete things in mambo it goes into the trash bin just like Windows, you have to go in and empty it just like Windows, well obviously I haven’t done that in a while, and considering you can only select 50 items at one time it took me a while…
so we’ll see if that lightened the DB any, going to do a backup shortly, and I know there is some other old entries in there that can be deleted as well…
but I think the real problem presently is the connections limitation and there is no way around that other than upgrading my hosting to a virtual dedicated server.. which is cost prohibitive right now..
hmm.. Hey GoDaddy.. Wanna be the official sponsor of DragonSteelMods?
hehe.. had to try..