Ratjoy.com » Forums » Ratjoy.com General Discussion » NOTICE
You need to register or login to post a reply.
NOTICE
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 1 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 16, 2012 (Last edited on Apr 16, 2012) Please don't be alarmed if the site is sluggish or you see strange data, I'm making some HUGE database structural changes to improve efficiency.Altering anything on the 2GB mysql table does ruin things, and theoretically it's probably better to schedule a downtime for these type of changes. |
|
Josh Millard RJ: Tex Corman CO: J. Quaff Arabica Post Rating: 0 + / - Total Posts: 167 Karma: 231 Joined: Apr 3, 2012 |
Posted on Apr 16, 2012 So I should not set everything on fire and try to recoup most of my capital through insurance claims?
|
|
Alexia Perdhaer RJ: Alexia Perdhaer Post Rating: 0 + / - Total Posts: 100 Karma: 30 Joined: Apr 6, 2012 |
Posted on Apr 16, 2012 Is this why stores are showing no sales for the last 3 hours?
|
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 0 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 16, 2012 (Last edited on Apr 18, 2012) @Alex:Correct. @Josh: No kitten is hurt in the process. Edit: This post is edited to test the edited time function. |
|
Last Obelus RJ: Last Obelus Post Rating: 0 + / - Total Posts: 1 Karma: 10 Joined: Apr 16, 2012 |
Posted on Apr 16, 2012 lol, I had a hunch it would be worthwhile to click on the quests screen. And it was.
|
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 0 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 16, 2012 (Last edited on Apr 16, 2012) The 3 hour lapse was caused by a timezone difference when I generated the new table and not by actual no sale.I tried to fix it simply by running: UPDATE <table> SET tick = tick + 12 Unfortunately it didn't work in practice because the query somehow takes longer than 15 minutes (by which time a new update has logged) So let's just leave it there until it the line disappears. |
|
Billy Vierra RJ: Saffrian CO: Billy Vierra Post Rating: 0 + / - Total Posts: 84 Karma: 100 Joined: Apr 10, 2012 |
Posted on Apr 16, 2012 Sounds like it is time to fork / thread the update system :)
|
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 0 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 16, 2012 (Last edited on Apr 16, 2012) Already did.The problem started appearing 2 days ago, and I've been making small changes each day until I finally decided enough is enough, and here's the big one. |
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 0 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 17, 2012 OK, in the end I had to simply empty the new table, so there will be a blank line for the next 12 hours.
|
|
Billy Vierra RJ: Saffrian CO: Billy Vierra Post Rating: 0 + / - Total Posts: 84 Karma: 100 Joined: Apr 10, 2012 |
Posted on Apr 17, 2012 hehe :) yea, growth is always a good thing, still makes it tough when it doesn't scale as you wish it would
|
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 0 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 17, 2012 Yup, the sales system is definitely more complicated than it needs to be:Running time from the 15 min updater on stores: 43.73 s Running time from the 15 min updater on everything else: 4.25 s |
|
Matthew Suozzo RJ: Buckaroo Bonzai Post Rating: 31 + / - Total Posts: 40 Karma: 51 Joined: Apr 5, 2012 |
Posted on Apr 17, 2012 I know this might be inappropriate to ask of someone who's working full-time on the side but have you looked at MongoDb? In my experience, it will handle complex schema much better than mysql and even has performance gains in the simplest cases. Maybe something to look at as the game grows (still pushing instantaneous factory production).
|
|
Tony Wooster RJ: Johnny Appleseed Post Rating: 0 + / - Total Posts: 41 Karma: 51 Joined: Apr 4, 2012 |
Posted on Apr 17, 2012 Mongo sucks for ACID compliance and highly interrelated data, though. Which, I suspect, is pretty important here.
|
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 0 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 17, 2012 (Last edited on Apr 17, 2012) Thank you Matt!Given the current sales system, it does look like we'll have to |
|
Billy Vierra RJ: Saffrian CO: Billy Vierra Post Rating: 0 + / - Total Posts: 84 Karma: 100 Joined: Apr 10, 2012 |
Posted on Apr 17, 2012 Scoot,Stupid question I am sure, but have you checked the index's to see if a query is not using any? |
|
Kev Q RJ: Donald Trump CO: Donald Trump Post Rating: 0 + / - Total Posts: 9 Karma: 36 Joined: Apr 4, 2012 |
Posted on Apr 18, 2012 Whatever was done to the server, I ended up paying taxes salaries and maintenance 10 times in 10 minutes, and now I'm massively in debt :(
|
You need to register or login to post a reply.