View Single Post
  #9  
Old 03-21-2008, 01:53 PM
Ross Ross is offline
Senior Member
 
Join Date: Jan 2006
Location: US
Posts: 371
iTrader: (2)
Rep Power: 3
Ross is on a distinguished road
Re: namedrive slow as hell nowadays

Quote:
Originally Posted by NameDriver
Looking at your account, you had more traffic yesterday than any of the previous Thursdays in this entire year. We have a parking database and a homepage database and, as long as the parking database is logging the stats, we will always show these once any other problems are overcome.
Can I ask where you were getting database errors as our tech guys said we were not experiencing anything which lasted all day as you report. Was it on the homepage?
Hi Ed,
Do you mean that your parking stats and configuration pages are served by a physically separate database server machine than the parking pages are? I only ask this because both of the databases are on the same machine, then it's very likely that when one of them is not functioning properly then neither is the other. Also, if you have these type of database problems with your stats pages database, then why wouldn't one logically assume that similar problems exist with the parking logging database? That is, when your customer facing operations are not functioning, then why should the customer feel confident that your back-office is functioning?

All throughout the day, until the time I made the post which you responded to, even a few hours after that, I experienced problems while attempting to view parking stats, add domains, reconfigure domain settings, etc. A few times, I got the error "database server restarting", a few times I got network timeouts where the page didn't load at all, a few times I could reach the www.namedrive.com homepage (extremely slow) but couldn't go to the www.namedrive.com/account page due to non-response and timeouts, a few more times when going into domain settings it timed out, on and on like this all day long.

By the end of the day, the traffic had appeared to even out, but was far lower than recent daily averages in certain areas.

While IDN traffic is ramping up now during this exciting time, I need constant, real-time access to my stats so that I can make portfolio management decisions, etc. I may not be a big fish yet, but I am constantly raising my portfolio's performance and I need the support systems which are in place to assist me to be rock-solid. I also don't like wondering if the front-end of your system is broken, then am I also losing money (is the back-end broken as well).

Are you running your operations with a MySQL database? Despite the hype and mindshare, you might not be aware that MySQL is not a real database, e.g. does not contain native support for foreign keys, transactions, cascaded operations, etc. It is certainly not a capable database platform for financial transaction systems. Postgres is a free alternative to Oracle, and it is rock-solid with full transaction and foreign key support. As you experience growth, this might be something worth paying very close attention to.

.

Quote:
Originally Posted by Rubber Duck
Oh dear, has somebody been caught out misrepresenting their stats.

At the time I wrote that post, the traffic was half of what it had been by that time for most any day in the past month. No misrepresentation going on. I have nothing to gain or lose from telling you about my stats.

.
__________________
Girls are like internet domain names, the ones I like are already taken.

Last edited by Ross; 03-21-2008 at 01:55 PM. Reason: Automerged Doublepost
Reply With Quote