![]() |
|
[Complete] Unscheduled Server Maintenance - December 7, 2013 - Printable Version +- Southperry.net (https://www.southperry.net) +-- Forum: Main (https://www.southperry.net/forumdisplay.php?fid=11) +--- Forum: Nexon Announcements (https://www.southperry.net/forumdisplay.php?fid=20) +--- Thread: [Complete] Unscheduled Server Maintenance - December 7, 2013 (/showthread.php?tid=68348) Pages:
1
2
|
[Complete] Unscheduled Server Maintenance - December 7, 2013 - Notify - 2013-12-07 http://maplestory.nexon.net/news/maintenance/announcements/00HO1/ Nexon Wrote: [Complete] Unscheduled Server Maintenance - December 7, 2013 - DavyJonesx - 2013-12-07 Fixing bugs like that takes that long? Or are there a lot of people to move from Snail Park to Lith Harbor? [Complete] Unscheduled Server Maintenance - December 7, 2013 - CherryPie - 2013-12-07 at least they're fixing it
[Complete] Unscheduled Server Maintenance - December 7, 2013 - Daakun - 2013-12-07 I don't know much about database junk, but if it works anything like most search queries it'll have to look at each and every character that exists, compare a map id, and then change that and the respawn point if a match is found. Taking a while is likely the result of having so many dang characters that need looked at. Edit: There are approximately 21,486,244 characters, and that's only counting the ones that show up in the rankings. Yeesh. [Complete] Unscheduled Server Maintenance - December 7, 2013 - Tukkun - 2013-12-07 Hooray, no more Hot Time for me. [Complete] Unscheduled Server Maintenance - December 7, 2013 - DavyJonesx - 2013-12-07 Daakun Wrote:I don't know much about database junk, but if it works anything like most search queries it'll have to look at each and every character that exists, compare a map id, and then change that and the respawn point if a match is found. They should do a wipe
[Complete] Unscheduled Server Maintenance - December 7, 2013 - ultimax21 - 2013-12-07 DavyJonesx Wrote:Fixing bugs like that takes that long? Most people can run out. It's just the 0.5% of MS or less that is stuck there. Quest fanatics get pulled down under. [Complete] Unscheduled Server Maintenance - December 7, 2013 - SaptaZapta - 2013-12-07 DavyJonesx Wrote:Fixing bugs like that takes that long? They explained at some point that just taking the servers down and bringing them back up again takes about that long. [Complete] Unscheduled Server Maintenance - December 7, 2013 - Justin - 2013-12-07 Daakun Wrote:I don't know much about database junk, but if it works anything like most search queries it'll have to look at each and every character that exists, compare a map id, and then change that and the respawn point if a match is found. Not that hard to just add a WHERE clause and make it only search for characters above level 10. Suddenly the results in that query go down to... a lot less.
[Complete] Unscheduled Server Maintenance - December 7, 2013 - SaptaZapta - 2013-12-07 Justin Wrote:Not that hard to just add a WHERE clause and make it only search for characters above level 10. Suddenly the results in that query go down to... a lot less. Doesn't help much if that field is not an index. Also, the 21 million on rankings are all above level 10. [Complete] Unscheduled Server Maintenance - December 7, 2013 - Thorr - 2013-12-07 SaptaZapta Wrote:Doesn't help much if that field is not an index. Also, the 21 million on rankings are all above level 10. Bingo. Non-indexed queries take exponentially longer than indexed queries. [Complete] Unscheduled Server Maintenance - December 7, 2013 - Justin - 2013-12-07 SaptaZapta Wrote:Doesn't help much if that field is not an index. Also, the 21 million on rankings are all above level 10. That's why they're only querying for characters above level 10 that are on a few specific maps (The first few on maple island, which is where my adventurer is stuck at) Though yes, non-indexed queries would take a loooooot longer. Never seen their database, so I wouldn't know.
[Complete] Unscheduled Server Maintenance - December 7, 2013 - Encyclopedic - 2013-12-07 After I spend 3 hours trying to get GMS to work I finally have everything set up and this happens. Oh well. [Complete] Unscheduled Server Maintenance - December 7, 2013 - Muppy - 2013-12-07 I wonder what's gonna be ninja patch'd this time. Hoping that they don't "fix" the spawn rate. [Complete] Unscheduled Server Maintenance - December 7, 2013 - Razmos - 2013-12-07 Muppy Wrote:I wonder what's gonna be ninja patch'd this time.I have the horrible feeling that Gollux's body parts will stop dropping green coins again. [Complete] Unscheduled Server Maintenance - December 7, 2013 - Chilly - 2013-12-07 "R" Ice Cube or indirectly Love Letters would be my guess, definitely more pressing compared to Gollux Coins which I assume are still limited by the six entrances and further limited to three in observation that Keys either do not drop or drop at a significantly lower rate. [Complete] Unscheduled Server Maintenance - December 7, 2013 - sweetpapaya - 2013-12-07 just when I wanted to set up my main for the hot time... ty obama [Complete] Unscheduled Server Maintenance - December 7, 2013 - Justin - 2013-12-07 Razmos Wrote:I have the horrible feeling that Gollux's body parts will stop dropping green coins again. Just tested it, they still drop. [Complete] Unscheduled Server Maintenance - December 7, 2013 - Notify - 2013-12-07 [url][/url] Nexon Wrote: [Complete] Unscheduled Server Maintenance - December 7, 2013 - sweetpapaya - 2013-12-07 SO what did they fix/broke? |