L2J Server

I have last rev Freya.

I have intel quad core 2.4
5GB RAM on 667mhz
and 2x 320GB sata hard drives ... 7200rpm
What would be better to buy first to improve server ?
I have money only to buy 2 GB more ram or 1x hard drive 15000 rpm atm.
What you guys think would be best to buy now ?

I'd guess the HDD. Put the database on it.

If its a low rate server - definitely HDD, because the DB usage will be bigger
If its a pvp server - definitely more RAM, because there will be less DB usage and more variable usage

Actually it also depends on your OS, if its with GUI, you will need more ram. Also, if your os is 32bit, dont even bother hosting a server with the hope that it will support large amount of players without problems.

90% PvP high rate server.
now I'm using Vista x64 and can barely keep 150 on. after 150 lag starts ...
I will move tonight on Ubuntu x64

Since you will be using OS with GUI, go for more ram. Also, faster HDDs are required when you have huge DB usage, for ~250-250 ppl the DB usage aint that big

RAID0 of SSD disks.

RAID sux and is not trustable xD

better is SSD but is not cheap so a better option is a SATA III harddisk with 32 or 64 mb cache and 7200 or more rpm.

also a second harddisk for backups

Best is SSD in Raid 0 like ThePhoenixBird said. Yes, its unsafe. But you should do daily backups anyways off your root server. If you want high performance, you got to waste some safety.

If money isnt a issue, then RAID5 of SSD disks. (RAID5 is something like RAID0 + RAID1)

I am interested in SSD too.
http://www.mysqlperformanceblog.com/200 ... nsactions/

huh thanks for all the advices ...

If its not too much can anyone post a mysql config that would suit my server's needs with current configurations ... I tryed lots .. but mysql only makes my head spin ) everytime ...

I will try with tunner... but need .cnf to start with ...
sorry for my bad english

I'd say get rid of Vista first. Why not use Windows Server?

Running on Ubuntu x64 for 3 hours now... and how do you use mysqltuner.pl with xampp I can't figure it out ... lol and google doesn't what to spit the solution out

>> MySQLTuner 1.1.1 - Major Hayden <[email protected]>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
[!!] Unable to find mysqladmin in your $PATH. Is MySQL installed?

I have xampp installed, but seem to manage to run mysqltuner.pl


I installed "mysql client" now it asks for user/pass ... but my xampp credentials don't work lol

bah.. don't use xampp for server, come on.

Install each thing separated, Apache, MySQL and PHP, dont use packages if you are going with Unix, do it the "normal" way not the "easy" way