pancakes

MicrostockGroup Sponsors


Author Topic: Update regarding stats and site stability  (Read 888 times)

0 Members and 1 Guest are viewing this topic.

Istock News

« on: September 25, 2007, 13:52 »
0
So here"s the deal. [keep in mind this is a simplified explanation of a really complex problem]

The problems we fixed last week had to do with throughput. When those bottlenecks were fixed, it increased the load on the servers by a truly significant amount (average load was higher than our highest peaks--ever). Which is fine. That much more traffic means lots more sales.

Unfortunately we hit a snag along the way. We ran up against a known bug in mySQL 5 (which is what the site runs on). We simply can"t process any more transactions per second. Yeah, it"s a good problem to have. There is a fix in the next version of mySQL, but it"s in beta and a long way from being production-ready (and no, adding more machines doesn"t help in this case).

So our developers have been coding around the problem. It"s slow and meticulous work. Kinda like changing the fan belt on a car doing 60 on the freeway.

We turned off stats because they were hitting the servers especially hard, and aggravating the bug. We"re running the script to update your graphs every afternoon. It takes about 3 hours to run, but in the mean time, your number of downloads and cash balance is always up to date. There is code in place that should allow us to turn it back on--we"ll know if it"s ready to go by late Monday.

Hope that clears things up a bit. Thanks for hanging in there.

      


 

Related Topics

  Subject / Started by Replies Last post
Site Stability

Started by Istock News Microstock News

0 Replies
702 Views
Last post September 10, 2007, 16:52
by Istock News
2 Replies
1255 Views
Last post September 16, 2007, 17:58
by michaeldb
12 Replies
3112 Views
Last post February 29, 2008, 13:49
by Karimala
4 Replies
1386 Views
Last post August 06, 2009, 19:05
by PixelBytes
0 Replies
798 Views
Last post March 16, 2011, 18:36
by jsmithzz

Sponsors

Microstock Poll Results

Sponsors