Uploads offline to prepare for Cata

[Asagi]

Ah but they are only old after like 30 days. If I remember correctly.

[1974ER]

I posted the reasons against deletions in the thread in General discussion, so not repeating myself here.

[FuxieDK]

[Rollie]

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.

[Jonathan91]

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.
_________________
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin

[Asagi]

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

Mean while I keep running the Census.

[Rollie]

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 =/

[PrimeKnight]

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.

[Asagi]

LOL, that's why I keep offering but I understand being slammed.

[Rollie]

@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.

[gmmmpresser]

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.

[1974ER]

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...

[Balgair]

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 - Eilnich - Ruire - Balgair - Dubh - Laidir - Rosad - Naomh --

[EpikPhailure]

[Rollie]

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.

[IroncladzOTE]

Still waiting!

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

[Fett]

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.

[EpikPhailure]

[Rollie]

Hehe, well, I plan on bringing them back online before that.

[1974ER]

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...