Server memory blow please help

[Angelox]

Originally Posted by bongol

I got it all working. I can access the DB now.

But I still having the memory blow after I used Angelox's sqls without being careful (no hard feelings).

Angelox: any way you can help me remove the lines I'v added by your sqls please ?

Thx.

This is why you have to always back up first - post me a back up of your database somewhere and I will download/look/test it.
MAKE SURE you compress it first with RARE or what ever, before you post it

[eq4me]

Yesterday: A DBA's backup song
(To be sung to the tune of Yesterday)


Yesterday,
All those backups seemed a waste of pay
Now my database has gone away
Oh I believe in yesterday

Suddenly,
There's not half the files there used to be
And there's a deadline
hanging over me
The system crashed so suddenly.

I pushed something wrong
What it was I could not say
Now my data's gone
and I long for yesterday-ay-ay-ay.

Yesterday,
The need for back-ups seemed so far away.
Thought all my data was here to stay,
Now I believe in yesterday.



Sorry, couldn't resist.

Seriously. Get a good beginners book about Linux adminstration and try to be more paranoid when it comes to important data.

[Angelox]

Originally Posted by eq4me

Yesterday: A DBA's backup song
(To be sung to the tune of Yesterday)


Yesterday,
All those backups seemed a waste of pay
Now my database has gone away
Oh I believe in yesterday

Suddenly,
There's not half the files there used to be
And there's a deadline
hanging over me
The system crashed so suddenly.

I pushed something wrong
What it was I could not say
Now my data's gone
and I long for yesterday-ay-ay-ay.

Yesterday,
The need for back-ups seemed so far away.
Thought all my data was here to stay,
Now I believe in yesterday.



Sorry, couldn't resist.

Seriously. Get a good beginners book about Linux adminstration and try to be more paranoid when it comes to important data.

Man, I really feel bad about this, I might be able to fix his database - But I don't know how it could have gotten damaged if these sqls worked for everyone else.
It could have been just a freak thing where the database got corrupted during the update process or, it could be the extra data needs more memory? his machine doesn't have much memory -anyways, If I can get my hands on it, I might be able to salvage it.

[eq4me]

Dont feel bad Angelox. As far as I am reading it he is back to his original problem. That was before he inserted your SQLs(?). So it isnt your fault.
I am in the businness for over 10 years and at some point I stopped to feel sorry for people who regard backups as unneccessary.

Its all about not making the same mistake twice.
What I would do: Get a fresh PEQ database and switch the Server temorarily to this DB. Does the EQEmu Server still use massive ammounts of RAM?

[Angelox]

Originally Posted by eq4me

Yesterday: A DBA's backup song
(To be sung to the tune of Yesterday)


Yesterday,
All those backups seemed a waste of pay
Now my database has gone away
Oh I believe in yesterday

Suddenly,
There's not half the files there used to be
And there's a deadline
hanging over me
The system crashed so suddenly.

I pushed something wrong
What it was I could not say
Now my data's gone
and I long for yesterday-ay-ay-ay.

Yesterday,
The need for back-ups seemed so far away.
Thought all my data was here to stay,
Now I believe in yesterday.



Sorry, couldn't resist.

Seriously. Get a good beginners book about Linux adminstration and try to be more paranoid when it comes to important data.

This song is hilarious - I've been passing it around to some friends

[eq4me]

Originally Posted by Angelox

This song is hilarious - I've been passing it around to some friends

There are more.

http://paul.merton.ox.ac.uk/computing/beatles.html

[John Adams]

Angelox, one more thing regarding the memory usage and your database - I just looked (curious) as I have been running your complete DB since your Harbinger updates. 7 of my 10 dynamic zones are running at 600k RAM or so. Only 3 are above 6mb, and none are over 100mb (I would have noticed that, actually).

So I am not sure why mine is different. I do have crashing zone issues, but that's caused by my crazily over-twinked monk friend trying to tear down my server daily.



Edit: Uh, nevermind this retarded post. I am a Windows user, not Linux. That's sorta different, eh?

[Angelox]

Originally Posted by John Adams

Angelox, one more thing regarding the memory usage and your database - I just looked (curious) as I have been running your complete DB since your Harbinger updates. 7 of my 10 dynamic zones are running at 600k RAM or so. Only 3 are above 6mb, and none are over 100mb (I would have noticed that, actually).

So I am not sure why mine is different. I do have crashing zone issues, but that's caused by my crazily over-twinked monk friend trying to tear down my server daily.

Edit: Uh, nevermind this retarded post. I am a Windows user, not Linux. That's sorta different, eh?

Did you try my new database? that issue with memory is solved, but you have to download the latest one. Be sure to read the instructions too.

[John Adams]

Originally Posted by Angelox

Did you try my new database? that issue with memory is solved, but you have to download the latest one. Be sure to read the instructions too.

I'll d/l your latest and load it up before playing with Zeph's tool. (wait, that sounded wrong...)

btw, I had no issue with your previous db that I could tell. Lucky me.