WarcraftReamls.com
  FAQFAQ    SearchSearch    MemberlistMemberlist    UsergroupsUsergroups   RegisterRegister 
  ProfileProfile    Log in to check your private messagesLog in to check your private messages    Log inLog in 
Uploads offline to prepare for Cata
Goto page Previous  1, 2, 3, 4, 5  Next
 
Post new topic   This topic is locked: you cannot edit posts or make replies.    WarcraftRealms.com Forum Index -> News and Announcements
View previous topic :: View next topic  
Author Message
Asagi



Joined: 08 Dec 2007
Posts: 2
Location: Florida
WR Updates: 417,610
Asagi WR Profile

PostPosted: Mon Dec 13, 2010 3:31 pm    Post subject: Reply with quote

Ah but they are only old after like 30 days. If I remember correctly.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
1974ER
Epic Censi


Joined: 07 Nov 2008
Posts: 729

WR Updates: 23,809,448
1974ER WR Profile

PostPosted: Mon Dec 13, 2010 5:44 pm    Post subject: Reply with quote

I posted the reasons against deletions in the thread in General discussion, so not repeating myself here.
Back to top
View user's profile Send private message
FuxieDK



Joined: 22 May 2008
Posts: 455
Location: Copenhagen, DK
WR Updates: 2,596,413
FuxieDK WR Profile

PostPosted: Mon Dec 13, 2010 10:43 pm    Post subject: Reply with quote

EpikPhailure wrote:
It has been a week since the uploads went offline. My suggestion is to delete all the old updates and start over.


Just my 2 cents.

That would be the worst idea ever.. It would ruing updates at the most critial time in this sites history; At expansion release..

Without level-updates, we're left with nothing...
_________________
Doing census on various servers Wink
Back to top
View user's profile Send private message
Rollie
Site Admin


Joined: 28 Nov 2004
Posts: 5374
Location: Austin, TX
WR Updates: 480,131
Rollie WR Profile

PostPosted: Tue Dec 14, 2010 8:39 am    Post subject: Reply with quote

I am planning on working on it more throughout the day as work permits. I'm as concerned as anyone else with the general performance of things lately.
Back to top
View user's profile Send private message Visit poster's website
Jonathan91



Joined: 14 Feb 2006
Posts: 1
Location: Las Vegas NV
WR Updates: 477,372
Jonathan91 WR Profile

PostPosted: Tue Dec 14, 2010 2:43 pm    Post subject: Reply with quote

We understand your time is limited Rollie. You take your time, do what needs to get done. We will be here for you when you?re ready. Day by day line by line. Smile
_________________
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin
Back to top
View user's profile Send private message
Asagi



Joined: 08 Dec 2007
Posts: 2
Location: Florida
WR Updates: 417,610
Asagi WR Profile

PostPosted: Tue Dec 14, 2010 8:10 pm    Post subject: Reply with quote

Oh I totally understand. Hence if there's anything we can do to help just ask!

Mean while I keep running the Census.

Back to top
View user's profile Send private message AIM Address Yahoo Messenger
Rollie
Site Admin


Joined: 28 Nov 2004
Posts: 5374
Location: Austin, TX
WR Updates: 480,131
Rollie WR Profile

PostPosted: Wed Dec 15, 2010 8:55 am    Post subject: Reply with quote

Unfortunately I'm getting slammed with work... everyone trying to get stuff done before the holidays. I've been working 16 hour days for the past 5 days =/
Back to top
View user's profile Send private message Visit poster's website
PrimeKnight



Joined: 11 Dec 2007
Posts: 1
Location: Toronto, Ontario, Canada
WR Updates: 273,040
PrimeKnight WR Profile

PostPosted: Wed Dec 15, 2010 10:36 am    Post subject: Reply with quote

Did you need help in fixing your database performance? Please let us know, or perhaps just explain what the problem is. I'm sure that we have a lot of people who work in software development or database administration. I would be very happy to help you out if you needed it.
Back to top
View user's profile Send private message
Asagi



Joined: 08 Dec 2007
Posts: 2
Location: Florida
WR Updates: 417,610
Asagi WR Profile

PostPosted: Wed Dec 15, 2010 1:21 pm    Post subject: Reply with quote

LOL, that's why I keep offering but I understand being slammed. Very Happy
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
Rollie
Site Admin


Joined: 28 Nov 2004
Posts: 5374
Location: Austin, TX
WR Updates: 480,131
Rollie WR Profile

PostPosted: Thu Dec 16, 2010 12:57 pm    Post subject: Reply with quote

@Prime - I would be happy to have some folks offer suggestions to improve db performance.

I know of some things that can be done, but none of them are simple solutions that could be done on the same hardware without a lot of downtime.

MySQL 5.5 was just released yesterday which supposedly has much better support for partitioning and that would be very helpful. The problem is actually making that move.
Back to top
View user's profile Send private message Visit poster's website
gmmmpresser



Joined: 04 Sep 2005
Posts: 59

WR Updates: 5,526,793
gmmmpresser WR Profile

PostPosted: Thu Dec 16, 2010 3:09 pm    Post subject: Reply with quote

What I don't understand is why this has suddenly gone bad now?
We have had other upgrades & patches applied to the system without any major problems before, but since 4.0.3 (?) it appears as though the wheels have just fallen off.
Back to top
View user's profile Send private message
1974ER
Epic Censi


Joined: 07 Nov 2008
Posts: 729

WR Updates: 23,809,448
1974ER WR Profile

PostPosted: Fri Dec 17, 2010 2:43 am    Post subject: Reply with quote

Rollie can you give you much better answer than I can... My belief is that the database has simply grown to a size, where it is pressing the limits of the programs Rollie uses to manage it.

We have, according to the database stats base... just passed the 95 M characters marker... 95,014,599 character entries, says the page... before I went to bed it was still hovering around 94,981,xxx or so...
Back to top
View user's profile Send private message
Balgair
Araiceil


Joined: 30 Sep 2005
Posts: 1518
Location: UK
WR Updates: 11,101,294
Balgair WR Profile

PostPosted: Fri Dec 17, 2010 10:10 am    Post subject: Reply with quote

What ER said - this isn't the first time the site's had major database issues, due to the sheer size of it, but in the past, Rollie's usually managed to find a bandaid that's got it running again for a while. This time, it seems the scale is just too large for the current hardware limitations, hence it being rather harder to solve.
_________________
EU-Draenor:
-- Sagart - Tairbh - Buinne - Balgair - Eilnich - Ruire - Dubh - Laidir - Naomh --
Back to top
View user's profile Send private message
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Fri Dec 17, 2010 11:16 am    Post subject: Reply with quote

1974ER wrote:
...We have, according to the database stats base... just passed the 95 M characters marker... 95,014,599 character entries, says the page... before I went to bed it was still hovering around 94,981,xxx or so...


Again, not to upset anyone, but really, there can not be 95 MIL toons on this game anymore, I feel that a good purge and restart would really help out this site, this addon, and more.
Anything over 30 days should be deleted.
In the interest of getting this addon back up and running, this database and site working again, sometimes sacrifices need to be made.

To those who feel that their hard work will be lost, I think you are loosing the big picture here.
This site and addon are to help people with current data, while there are some people I am sure who like old legacy data. Their numbers are much fewer than those who want the current stats.
I have heard this site discussed on my old realm, of Mal'Ganis, because of the free transfers in place now.
A lot of people want to know data before they take the plunge on a new site.
However at the current state, most people who don't know all the details except that the data on this site now is getting close to be over two weeks old, are loosing faith in it.

This again is all my two cents. Please don't attack me for my opinions.
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Rollie
Site Admin


Joined: 28 Nov 2004
Posts: 5374
Location: Austin, TX
WR Updates: 480,131
Rollie WR Profile

PostPosted: Fri Dec 17, 2010 11:39 am    Post subject: Reply with quote

There is a purge of sorts taking place to cull out old, unplayed toons.

And yes, this has been a problem before. There is a critical mass of characters that once reached cause the database to really chug to make the necessary updates.

With proper partitioning and the appropriate application logic to handle it, it can be improved considerably, that just requires time, which is something I don't usually have a lot of, but lately I've had zero of.
Back to top
View user's profile Send private message Visit poster's website
IroncladzOTE



Joined: 27 Oct 2010
Posts: 0

WR Updates: 6,545
IroncladzOTE WR Profile

PostPosted: Sat Dec 18, 2010 2:50 pm    Post subject: Reply with quote

Still waiting!

So when is this update up?
_________________
Just helpin out.

Back to top
View user's profile Send private message
Fett



Joined: 01 Nov 2008
Posts: 50

WR Updates: 846,084
Fett WR Profile

PostPosted: Sat Dec 18, 2010 7:01 pm    Post subject: Reply with quote

Well, let's see, on December 9 Rollie said that at the current rate it would take about 15 days. He hasn't had time to make the improvements he was hoping for, so my math says it should be complete about December 24. My guess is that updates will go back up after that. The moral of the story? Be patient.
Back to top
View user's profile Send private message
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Sun Dec 19, 2010 12:09 am    Post subject: Reply with quote

Fett wrote:
Well, let's see, on December 9 Rollie said that at the current rate it would take about 15 days. He hasn't had time to make the improvements he was hoping for, so my math says it should be complete about December 24. My guess is that updates will go back up after that. The moral of the story? Be patient.


Don't mess with the Fett!
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Rollie
Site Admin


Joined: 28 Nov 2004
Posts: 5374
Location: Austin, TX
WR Updates: 480,131
Rollie WR Profile

PostPosted: Sun Dec 19, 2010 12:25 am    Post subject: Reply with quote

Hehe, well, I plan on bringing them back online before that.
Back to top
View user's profile Send private message Visit poster's website
1974ER
Epic Censi


Joined: 07 Nov 2008
Posts: 729

WR Updates: 23,809,448
1974ER WR Profile

PostPosted: Sun Dec 19, 2010 7:51 am    Post subject: Reply with quote

I look forward to that, as I am already "sitting" on almost 40 .luas... which means that it will most likely take at least a couple of days before I have even gotten rid of most current backlog I have waiting... Very Happy
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.    WarcraftRealms.com Forum Index -> News and Announcements All times are GMT - 6 Hours
Goto page Previous  1, 2, 3, 4, 5  Next
Page 2 of 5

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
WarcraftRealms.com  


Powered by phpBB © 2001, 2005 phpBB Group