How to make your server run 20-50+% faster (sticky)

[Aseren]

Alright how to make your server run faster and stop log files.
(Never forget to make backups, also, when you start working
with this tutorial I already assume you got the server working)

Programs your gonna be needing: Ram Cleaner
Download/Install it
Once installed & running, press ctrl + f10 and put critical level on 0




Step 1 - SQl





First of all


Open up your SQL and delete the following DB's


lin2log
Petition
(Don't forget to take them out of ODBC)


So you only keep lin2world & lin2db.

Next click on the little + on lin2db, then go to user tables and click
on the + again.

Now make sure it looks exactly like on the pic.
(so delete everything out of it except the stuff that you c on the pic
take your time for it)




Step 2 - Cutting down on the NPC's





To make the server work atleast 20% faster (over 50% for pcs that
hardly could handle the server in the first place) is to cut down
on the npcs.

(example file -1000 npc's)
Download this file

Npc's Edited

Put it in your l2server scripts folder (once again don't forget to backup)

This will help your server run a hell of a lot faster, ofcourse you will loose some
npc's (a lot of none important onces i took out, if you DO seem to be missing
some important ones, Np just summon it as GM //summon <npcname>).




Step 3 - Starting the server up





(Everytime your gonna start the server up after a crash or just a restart
check the Cached/l2server/l2npc folder for error textfiles and delete them
also delete the entire log map <they usally only become up to 2mb but what
the hell>.)




Alright the only things that you are gonna need to start up are

Cached
l2Auth
l2Server

Pause
-(wait up to 10 minutes or so and don't forget to put your user limit on 0)
After it says HTML files cached, let the ram cleaner do her thing,
right click on it > free ram > max of what you got.
After your ram is cleanend start something simple like internet explorer to
get that ram working again.

l2NPC
Load the ~2500-3000 Npcs
After that put the user limit on w/e you want.



Remember after the first time, your only gonna have to do step 3, might take
5 minutes longer (or not) but it will cutdown on the lag/log files like a motherf*cker.

If u need some more help, let me know.

[MentaL]

[nzs3323]

um nice but you do realize if you dont run l2logd it doesn't use the db anyways so it doesn't matter if you keep it or not.

What npc's did you remove? Not to be rude but the npc's you think arn't important might be important on another server for events (that require them being spawned) and what have you.

Ram cleaner is a good tip.

[Shawnmb]

LogD not running DOES affect performance because regardless of it using the database, it still has to write to the drive...and personally Im against removing NPCs and I have found that (at least on my machines) RAM freeing applications cause more problems in the long run than they will solve...

[Aseren]

As i said it assumes you already got the server working , there for it already made logs, also in ur sql, thats why you need to delete l2log in ur sql to prevent it from slowing down and the npc file is just a example file , its easy to make your own.


(ramcleaner works fine trust me.)

[nzs3323]

I know its easy to make my own i was just wondering which ones you deleted ^^.

[Aseren]

Took about a thousend out, seems a lot but there are a few hundred underground, high leveled ones, thats why the example file shouldnt be used for pvp servers.

Also at weird places in a swamp for example where noone comes etc.

[sama98b]

-How to make your server run 20-50+% faster?
-Get a faster/better pc :)

[Aseren]

Shut up noob, either use the guide or dont so shut the hell up, its not like you have to do all the steps, do whatever u want.

[Kane Hart]

just don't run petition and log lol..

[Aseren]

LogD not running DOES affect performance because regardless of it using the database, it still has to write to the drive

Read the entire topic next time,
thanks.

[elmaestro]

thanks im gonna try it

[mgkkelis]

how much performance will a server gain if i just stop the l2log and petition databses? Will that have any other effect on your L2server?

[Aseren]

really depends , cant exactly say, n no it wont have any other effect except that it prevent lags n logs.

[DamienStone]

Any Ram Cleaning Programs Run They Might Not Cause Problems Right Away But As Your Server Grows And Your Database Grows My God Does It Cause Unbelievable Memory Leaks. I Know From Experience. YOU WILL HAVE PROBLEMS EVENTUALLY.

[Aseren]

It won't, im not saying you should use it afterwards , just use it after you load l2server.exe
then start l2npc.

Thats all.

[DamienStone]

Ive done exactly what you do and what it causes is big memory leaks. YOu may not notice it in the beginnin gbut eventually youll get crashes everyday because of it like I have. I took it totally away (let the ram free itself the natural way) and its been up almost 2 days since.

[Squigly]

Thanks for the Guide Aseren. I have noticed also when using programs that free ram this 1 included that it causes memory leaks. It takes about 15 min. after startup for my server to free the ram itself but it stays up alot longer. Not sure why it does this it happens even if you use it like you said than shut it off completely.

I also modded the amont of NPCs, took out about a thousand also. Couldn't belive how many mobs were in areas that nobody goes to lol.

[mgkkelis]

which file do i have to edit for the amount of NPCs?

[Squigly]

NPCpos.txt

[Aseren]

yup its easy

[Igiss]

Can someone post the shortened npcpos.txt one more time? The link here is broken.

[M-@-t-R-i-X]

you do need lin2comm and you do need empty bbs tables there.. cuz if person ingame clicks on bbs alot cached crashes....

[john_d]

npcpos.rar is not available..

ill sticky this when it back up ok.

[Aseren]

I don't have it anymore.

Hm I do remember it not spaming certain quest mobs that you needed, but
you can just //summon them since you didn't affect Npcdata.txt when the time comes.

I assume your starting a small server anyway*.
If not upgrade and use the full npcdata.txt

[Sakumi]

Theres only one thing I agree on with that post. Everything else is problem causing.

Run only:
AuthD
CacheD
L2Server
L2NPC

Memory "Cleaners" cause manyyyy issues.

I don't recommend people follow this guide. Only the no logd portion...

Don't sticky this ><

you do need lin2comm and you do need empty bbs tables there.. cuz if person ingame clicks on bbs alot cached crashes....

yup!!!