Need help server setup Debian x64

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Need help server setup Debian x64

Post by badboy29 »

Hello i need help with my server:

java

Code: Select all

java -server -Xmx4096m -Xms3072m -Xmn1024m -XX:PermSize=256m -XX:SurvivorRatio=8 -Xnoclassgc -XX:+AggressiveOpts -cp ./../libs/*:l2jserver.jar net.sf.l2j.gameserver.GameServer
mysql
# * Fine Tuning
#
key_buffer = 384M
max_allowed_packet = 1M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_stack = 128K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
max_connections = 1000
table_cache = 512
thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 0M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

memlock

#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1


#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
I use these settings but I wish someone could tell me what better setting for my machine:

Intel Core2 Quad Q9400
8GB DDR2
2x VelociRaptors 10k RPM
Linux Debian Lenny x64

Help please...
Aka UnHoly
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: Need help server setup Debian x64

Post by badboy29 »

Nobody knows?
Aka UnHoly
User avatar
ratonofx
Posts: 135
Joined: Thu Nov 23, 2006 2:39 am

Re: Need help server setup Debian x64

Post by ratonofx »

myisam is not a proper storage system to l2j servers. without the table restore system (myisam) the mysql works faster.
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: Need help server setup Debian x64

Post by badboy29 »

What do you recommend? Changing the type of database from MyISAM to InnoDB?

I have some configs for InnoDB database:

Code: Select all

default-storage-engine=INNODBmax_connections=1000query_cache_size=0table_cache=122tmp_table_size=256Mthread_cache_size=200innodb_additional_mem_pool_size=8Minnodb_flush_log_at_trx_commit=2innodb_log_buffer_size=16Minnodb_buffer_pool_size=1024Minnodb_log_file_size=512Minnodb_thread_concurrency=10innodb_support_xa=0max_user_connections=200max_connect_errors=3memlockinnodb_file_per_table
These configs are good?
Aka UnHoly
User avatar
ratonofx
Posts: 135
Joined: Thu Nov 23, 2006 2:39 am

Re: Need help server setup Debian x64

Post by ratonofx »

Sorry my bad, it's InnoDB the slower engine storage.

But some users recommend innodb i dunno know why the reason, because of this i'm testing tomorrow my new databases config, i'm setuping a debian x64 also, you my.cnf is almost like the mine but i will give you some tips.

innodb_thread_concurrency=10 can be innodb_thread_concurrency=19 you can setup until 20. from 20 to over it automaticaly setup like infinity.

max connections doesnt need to be 1000, down to 400 or 600.

Btw did you tested your performance after change from myisam to innodb?
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: Need help server setup Debian x64

Post by badboy29 »

Yes tested and improved considerably.
Aka UnHoly
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: Need help server setup Debian x64

Post by badboy29 »

ratonofx wrote:Sorry my bad, it's InnoDB the slower engine storage.

But some users recommend innodb i dunno know why the reason, because of this i'm testing tomorrow my new databases config, i'm setuping a debian x64 also, you my.cnf is almost like the mine but i will give you some tips.

innodb_thread_concurrency=10 can be innodb_thread_concurrency=19 you can setup until 20. from 20 to over it automaticaly setup like infinity.

max connections doesnt need to be 1000, down to 400 or 600.

Btw did you tested your performance after change from myisam to innodb?
You set up your database to InnoDB? What configuration you used?
Aka UnHoly
Post Reply