Server Setting

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

Server Setting

Post by badboy29 »

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:2856
L2JDP Revision Number:5862

Hello guys, i have 1 dedicated server with the following configuration:

Intel Core2 Quad Q9300
8GB Ram DDR2
2 VelociRaptors 10K RPM
Windows 2003 Standard x64
JDK 1.6.0_13 x64
MySQL 5.1.33 x64
Link 100 Mbps

I need some help in setting up, because some players are experiencing lag(players average: 150 online), and I do not know if my setup is right:

startGameServer.bat:

Code: Select all

java -server -Xmx6114m -Xms6114m -XX:PermSize=256m -XX:SurvivorRatio=8 -XX:+UseParallelGC -XX:+AggressiveOpts -XX:NewRatio=3 -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer
General.properties:

Code: Select all

# ---------------------------------------------------------------------------# Thread Configuration# ---------------------------------------------------------------------------# Extreme caution should be here, set to defaults if you do not know what you are doing.# These could possibly hurt your servers performance or improve it depending on your server's configuration, size, and other factors. # Default: 10ThreadPoolSizeEffects = 50 # Default: 13ThreadPoolSizeGeneral = 65 # Default: 2UrgentPacketThreadCoreSize = 10 # Default: 4GeneralPacketThreadCoreSize = 20 # Default: 4GeneralThreadCoreSize = 20 # Default: 6AiMaxThread = 20 # Packet LifeTime in milliseconds. Disabled = 0.# Default: 0PacketLifeTime = 0 # Dead Lock Detector (a separate thread for detecting deadlocks).# For improved crash logs and automatic restart in deadlock case if enabled.# Check interval is in seconds.# Default: FalseDeadLockDetector = False # Default: 20DeadLockCheckInterval = 20 # Default: FalseRestartOnDeadlock = False  # ---------------------------------------------------------------------------# Optimization# ---------------------------------------------------------------------------# Flood Protector. Set the initial size of the flood protector (should equal about roughly your player count)# Default: 50FloodProtectorInitialSize = 300 # Items on ground management.# Allow players to drop items on the ground.# Default: TrueAllowDiscardItem = false # Delete dropped reward items from world after a specified amount of seconds. Disabled = 0.# Default: 0AutoDestroyDroppedItemAfter = 90 # Time in secs after which dropped herb will be auto-destroyed (default: 15 seconds)# Default: 15AutoDestroyHerbTime = 15 # List of items that will not be destroyed (separated by ",").# Notes:#   Make sure the lists do NOT CONTAIN trailing spaces or spaces between the numbers!#   Items on this list will be protected regardless of the following options.# Default: 57,5575,6673ListOfProtectedItems = 5575 # This is the interval (in minutes), that the gameserver will update a players information such as location.# The higher you set this number, there will be less character information saving so you will have less accessessing of the database and your hard drive(s).# The lower you set this number, there will be more frequent character information saving so you will have more access to the database and your hard drive(s).# A value of 0 disables periodic saving.# Independent of this setting the character is always saved after leaving the world.# Default: 15CharacterDataStoreInterval = 1 # This enables the server to only update items when saving the character.# Enabling this greatly reduces DB usage and improves performance.# WARNING: This option causes item loss during crashes.# Default: FalseLazyItemsUpdate = True # When enabled, this forces (even if using lazy item updates) the items owned by the character to be updated into DB when saving its character.# Default: FalseUpdateItemsOnCharStore = True # Also delete from world misc. items dropped by players (all except equip-able items).# Notes:#   Works only if AutoDestroyDroppedItemAfter is greater than 0.# Default: FalseDestroyPlayerDroppedItem = True # Destroy dropped equipable items (armor, weapon, jewelry).# Notes:#   Works only if DestroyPlayerDroppedItem = True# Default: FalseDestroyEquipableItem = True # Save dropped items into the database for restoring after restart.# Default: FalseSaveDroppedItem = False # Enable/Disable the emptying of the stored dropped items table after items are loaded into memory (safety setting).# If the server crashed before saving items, on next start old items will be restored and players may already have picked up some of them so this will prevent duplicates.# Default: FalseEmptyDroppedItemTableAfterLoad = False # Time interval in minutes to save in DB items on ground. Disabled = 0.# Notes:#   If SaveDroppedItemInterval is disabled, items will be saved into the database only at server shutdown.# Default: 60SaveDroppedItemInterval = 0 # Delete all saved items from the database on next restart?# Notes:#   Works only if SaveDroppedItem = False.# Default: FalseClearDroppedItemTable = False # Delete invalid quest from players.# Default: FalseAutoDeleteInvalidQuestData = False # Setting False can improve server performance on high rate/population servers.# Default: TruePreciseDropCalculation = False # Allow creating multiple non-stackable items at one time?# Default: TrueMultipleItemDrop = True # Forces full item inventory packet to be sent for any item change.# Notes:#   This can increase network traffic # Default: FalseForceInventoryUpdate = False # True = Load html's into cache only on first time html is requested.# False = Load all html's into cache on server startup.# Default: TrueLazyCache = True # Minimum and maximum variables in seconds for npc animation delay.# You must keep MinNPCAnimation < = MaxNPCAnimation.# Default: 10MinNPCAnimation = 0 # Default: 20MaxNPCAnimation = 0 # Default: 5MinMonsterAnimation = 0 # Default: 20MaxMonsterAnimation = 0 # Knownlist (the list of things a character sees) update method. Default is currently time based updating, which also makes it possible to use config options for guards to see moving monsters. Alternatively move based update can be used but guards cannot track mobs with that option but otherwise it should work well.# Default: FalseMoveBasedKnownlist = False # Interval (in miliseconds) in which the knownlist does full updates.# For move based updates its used for intermediate updates.# WARNING!#   Useful interval is between 300 - 2000. Too small value may kill your CPU, too high value may not update knownlists properly. The default value is chosen experimentally.# Default: 1250KnownListUpdateInterval = 1250 # Grid options: Grids can turn themselves on and off.  This also affects the loading and processing of all AI tasks and (in the future) geodata within this grid.# Turn on for a grid with a person in it is immediate, but it then turns on the 8 neighboring grids based on the specified number of seconds.# Turn off for a grid and neighbors occurs after the specified number of seconds have passed during which a grid has had no players in or in any of its neighbors.# The always on option allows to ignore all this and let all grids be active at all times (not suggested).# Default: FalseGridsAlwaysOn = False # Default: 1GridNeighborTurnOnTime = 1 # Default: 90GridNeighborTurnOffTime = 90  # ---------------------------------------------------------------------------# Geodata# ---------------------------------------------------------------------------# GeoData options:# 0 = GeoData and PathFinding OFF (default)# 1 = GeoData is used to check Line Of Sight (LOS) targeting and #     L2Playable movement. You need to download files for data/geodata folder.#     Monsters can pass walls but not aggro (no line of sight) through them.# 2 = Full GeoData enabled. Includes PathFinding (requires also /data/pathnode #     files if CellPathFinding not enabled) and all character moves go through #     geodata checks (if a mob passes a wall, pathfinding didn't find a route #     but we allow attack and returning home).#     Recommended server memory minimum 2 GB, rather 3 GB.# Default: 0GeoData = 1 # Cell-level pathfinding, produces more accurate routes but is (maybe 10x) heavier to calculate. Recommended for small servers at least.# If False, pathnode files are used. Uses a max number of nodes in calculation which can be adjusted in the algorithm if it needs to be faster.# Default: FalseCellPathFinding = False # True = Loads GeoData buffer's content into physical memory.# False = Does not necessarily imply that the GeoData buffer's content is not resident in physical memory.# Default: TrueForceGeodata = True # This setting controls Client <--> Server Player coordinates synchronization:# -1 - Will synchronize only Z from Client --> Server. Default when no geodata.# 1 - Synchronization Client --> Server only. Using this option (without geodata) makes it more difficult for players to bypass obstacles.# 2 - Intended for geodata (at least with cell-level pathfinding, otherwise can you try -1).# Server sends validation packet if client goes too far from server calculated coordinates.# Default: -1CoordSynchronize = 1
MySQL my.ini:

Code: Select all

# MySQL Server Instance Configuration File# ----------------------------------------------------------------------# Generated by the MySQL Server Instance Configuration Wizard### Installation Instructions# ----------------------------------------------------------------------## On Linux you can copy this file to /etc/my.cnf to set global options,# mysql-data-dir/my.cnf to set server-specific options# (@localstatedir@ for this installation) or to# ~/.my.cnf to set user-specific options.## On Windows you should keep this file in the installation directory # of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To# make sure the server reads the config file use the startup option # "--defaults-file". ## To run run the server from the command line, execute this in a # command line shell, e.g.# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"## To install the server as a Windows service manually, execute this in a # command line shell, e.g.# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"## And then execute this in a command line shell to start the server, e.g.# net start MySQLXY### Guildlines for editing this file# ----------------------------------------------------------------------## In this file, you can use all long options that the program supports.# If you want to know the options a program supports, start the program# with the "--help" option.## More detailed information about the individual options can also be# found in the manual.### CLIENT SECTION# ----------------------------------------------------------------------## The following options will be read by MySQL client applications.# Note that only client applications shipped by MySQL are guaranteed# to read this section. If you want your own MySQL client program to# honor these values, you need to specify it as an option during the# MySQL client library initialization.#[client] port=3306 [mysql] default-character-set=latin1  # SERVER SECTION# ----------------------------------------------------------------------## The following options will be read by the MySQL Server. Make sure that# you have installed the server correctly (see above) so it reads this # file.#[mysqld] # The TCP/IP Port the MySQL Server will listen onport=3306  #Path to installation directory. All paths are usually resolved relative to this.basedir="C:/Program Files/MySQL/MySQL Server 5.1/" #Path to the database rootdatadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/" # The default character set that will be used when a new schema or table is# created and no character set is defineddefault-character-set=latin1 # The default storage engine that will be used when create new tables whendefault-storage-engine=INNODB  # The maximum amount of concurrent sessions the MySQL server will# allow. One of these connections will be reserved for a user with# SUPER privileges to allow the administrator to login even if the# connection limit has been reached.max_connections=600 # Query cache is used to cache SELECT results and later return them# without actual executing the same query once again. Having the query# cache enabled may result in significant speed improvements, if your# have a lot of identical queries and rarely changing tables. See the# "Qcache_lowmem_prunes" status variable to check if the current value# is high enough for your load.# Note: In case your tables change very often or if your queries are# textually different every time, the query cache may result in a# slowdown instead of a performance improvement.query_cache_size=0 # The number of open tables for all threads. Increasing this value# increases the number of file descriptors that mysqld requires.# Therefore you have to make sure to set the amount of open files# allowed to at least 4096 in the variable "open-files-limit" in# section [mysqld_safe]table_cache=2000 # Maximum size for internal (in-memory) temporary tables. If a table# grows larger than this value, it is automatically converted to disk# based table This limitation is for a single table. There can be many# of them.tmp_table_size=256M  # How many threads we should keep in a cache for reuse. When a client# disconnects, the client's threads are put in the cache if there aren't# more than thread_cache_size threads from before.  This greatly reduces# the amount of thread creations needed if you have a lot of new# connections. (Normally this doesn't give a notable performance# improvement if you have a good thread implementation.)thread_cache_size=45 #*** MyISAM Specific options # The maximum size of the temporary file MySQL is allowed to use while# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.# If the file-size would be bigger than this, the index will be created# through the key cache (which is slower).myisam_max_sort_file_size=100G # If the temporary file used for fast index creation would be bigger# than using the key cache by the amount specified here, then prefer the# key cache method.  This is mainly used to force long character keys in# large tables to use the slower key cache method to create the index.myisam_max_extra_sort_file_size=100G # If the temporary file used for fast index creation would be bigger# than using the key cache by the amount specified here, then prefer the# key cache method.  This is mainly used to force long character keys in# large tables to use the slower key cache method to create the index.myisam_sort_buffer_size=64M # Size of the Key Buffer, used to cache index blocks for MyISAM tables.# Do not set it larger than 30% of your available memory, as some memory# is also required by the OS to cache rows. Even if you're not using# MyISAM tables, you should still set it to 8-64M as it will also be# used for internal temporary disk tables.key_buffer_size=384M # Size of the buffer used for doing full table scans of MyISAM tables.# Allocated per thread, if a full scan is needed.read_buffer_size=64Kread_rnd_buffer_size=256K # This buffer is allocated when MySQL needs to rebuild the index in# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE# into an empty table. It is allocated per thread so be careful with# large settings.sort_buffer_size=256K  #*** INNODB Specific options ***innodb_data_home_dir="D:/MySQL Datafiles/" # Use this option if you have a MySQL server with InnoDB support enabled# but you do not plan to use it. This will save memory and disk space# and speed up some things.#skip-innodb # Additional memory pool that is used by InnoDB to store metadata# information.  If InnoDB requires more memory for this purpose it will# start to allocate it from the OS.  As this is fast enough on most# recent operating systems, you normally do not need to change this# value. SHOW INNODB STATUS will display the current amount used.innodb_additional_mem_pool_size=8M # If set to 1, InnoDB will flush (fsync) the transaction logs to the# disk at each commit, which offers full ACID behavior. If you are# willing to compromise this safety, and you are running small# transactions, you may set this to 0 or 2 to reduce disk I/O to the# logs. Value 0 means that the log is only written to the log file and# the log file flushed to disk approximately once per second. Value 2# means the log is written to the log file at each commit, but the log# file is only flushed to disk approximately once per second.innodb_flush_log_at_trx_commit=2 # The size of the buffer InnoDB uses for buffering log data. As soon as# it is full, InnoDB will have to flush it to disk. As it is flushed# once per second anyway, it does not make sense to have it very large# (even with long transactions).innodb_log_buffer_size=16M # InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and# row data. The bigger you set this the less disk I/O is needed to# access data in tables. On a dedicated database server you may set this# parameter up to 80% of the machine physical memory size. Do not set it# too large, though, because competition of the physical memory may# cause paging in the operating system.  Note that on 32bit systems you# might be limited to 2-3.5G of user level memory per process, so do not# set it too high.innodb_buffer_pool_size=1024M # Size of each log file in a log group. You should set the combined size# of log files to about 25%-100% of your buffer pool size to avoid# unneeded buffer pool flush activity on log file overwrite. However,# note that a larger logfile size will increase the time needed for the# recovery process.innodb_log_file_size=512M # Number of threads allowed inside the InnoDB kernel. The optimal value# depends highly on the application, hardware as well as the OS# scheduler properties. A too high value may lead to thread thrashing.innodb_thread_concurrency=60 #Lock mysqld in memory.(=Don't swap.)memlock
Is something wrong in this configuration? I better change the Operating System? I am seriously thinking of using the Ubuntu Server x64...
Last edited by badboy29 on Thu Apr 30, 2009 11:17 am, edited 1 time in total.
Aka UnHoly
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: Server Setting

Post by Zealar »

Check you internet. :o
User avatar
nonom
L2j Veteran
L2j Veteran
Posts: 649
Joined: Wed Mar 11, 2009 10:34 pm
Location: Magmeld

Re: Server Setting

Post by nonom »

Im not sure but maybe try to up mem reserved for java process.

startGameServer.bat:

java -server -Xmx6114m -Xms6114m -XX:PermSize=256m -XX:SurvivorRatio=8 -XX:+UseParallelGC -XX:+AggressiveOpts -XX:NewRatio=3 -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer
Image
"There are three kinds of people in this world, those who can count and those who can't"
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: Server Setting

Post by badboy29 »

Zealar wrote:Check you internet. :o
My link is 100mbps...
Aka UnHoly
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: Server Setting

Post by Zealar »

badboy29 wrote:
Zealar wrote:Check you internet. :o
My link is 100mbps...
And ? I just tell to check.

My frend have server with ~ 200 online ( 2gb ram , 250 gb 7200 , P4)
Have only lag when internet get slow.

Get all settings in default if still have lag just change you internet. :P

(Here i no speak about bad drivers , OS)
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: Server Setting

Post by badboy29 »

Zealar wrote: And ? I just tell to check.

My frend have server with ~ 200 online ( 2gb ram , 250 gb 7200 , P4)
Have only lag when internet get slow.

Get all settings in default if still have lag just change you internet. :P

(Here i no speak about bad drivers , OS)
You're right, but I did this test and the actual upload was 8.9 mb/s and 9.5 download mb/s.
Aka UnHoly
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: Server Setting

Post by Zealar »

Have big diffrent where test is possible some country have slow connection with you.
Also you tell some players no all. For that is very posible some players to have slow connection with you pc.
Check players (laget) ip , check what location have and use http://speedtest.net/ to test connection close to player location. Maybe can test also for losing packages get player ip (when have lag) Start -> Run -> cmd -> ping player ip -t -l 1024
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: Server Setting

Post by badboy29 »

Zealar wrote:Have big diffrent where test is possible some country have slow connection with you.
Also you tell some players no all. For that is very posible some players to have slow connection with you pc.
Check players (laget) ip , check what location have and use http://speedtest.net/ to test connection close to player location. Maybe can test also for losing packages get player ip (when have lag) Start -> Run -> cmd -> ping player ip -t -l 1024
Yeap, It is possible, but what about my settings? You know with all certainty say that everything is correct? Who could help me it would be NBd, but I think it will not no: P
Aka UnHoly
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: Server Setting

Post by Zealar »

Just follow this settings -> http://www.l2jserver.com/old-forum/thre ... adid=27154

For all other settings use default settings. (i speak about this "Thread Configuration" and "Optimization")
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: Server Setting

Post by badboy29 »

Zealar wrote:Just follow this settings -> http://www.l2jserver.com/old-forum/thre ... adid=27154

For all other settings use default settings. (i speak about this "Thread Configuration" and "Optimization")

Ok, I will do the test and see if it resolves. thanks for help :)
Aka UnHoly
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: Server Setting

Post by badboy29 »

After two days .... Apparently not resolved, the lag continues ...
Aka UnHoly
User avatar
Pere
Posts: 400
Joined: Sat Jan 05, 2008 11:09 am
Location: Catalunya, Berguedà

Re: Server Setting

Post by Pere »

Anyone knows if is normal to begin being laggy with 300 chars online on a Core2 Duo with 4GB of ram? (DB server on other box)
Bones tardes amics meus tots!
User avatar
DrHouse
L2j Inner Circle
L2j Inner Circle
Posts: 912
Joined: Mon Jan 22, 2007 12:14 am
Location: Spain

Re: Server Setting

Post by DrHouse »

it depends on bandwidth too
Image

Leadership and management are not talk and talk, but talk and do

Proud of being a part of this project
User avatar
Pere
Posts: 400
Joined: Sat Jan 05, 2008 11:09 am
Location: Catalunya, Berguedà

Re: Server Setting

Post by Pere »

100MBps -_-
Bones tardes amics meus tots!
User avatar
xXBanishedXx
Posts: 8
Joined: Thu Apr 23, 2009 11:49 pm

Re: Server Setting

Post by xXBanishedXx »

This works pretty darn good. Some players report drop in ping by 30.
I use a very light fast custom version of Vista64 so I use the one further down the page.
TCP Optimizer

More for you. Server 2003
http://www.speedguide.net/read_articles.php?id=2665

Good info.
http://www.psc.edu/networking/projects/tcptune/

More
http://shlang.com/writing/tcp-perf.html

My SQL ini

Code: Select all

# MySQL Server Instance Configuration File# ----------------------------------------------------------------------# Generated by the MySQL Server Instance Configuration Wizard### Installation Instructions# ----------------------------------------------------------------------## On Linux you can copy this file to /etc/my.cnf to set global options,# mysql-data-dir/my.cnf to set server-specific options# (@localstatedir@ for this installation) or to# ~/.my.cnf to set user-specific options.## On Windows you should keep this file in the installation directory # of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To# make sure the server reads the config file use the startup option # "--defaults-file". ## To run run the server from the command line, execute this in a # command line shell, e.g.# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"## To install the server as a Windows service manually, execute this in a # command line shell, e.g.# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"## And then execute this in a command line shell to start the server, e.g.# net start MySQLXY### Guildlines for editing this file# ----------------------------------------------------------------------## In this file, you can use all long options that the program supports.# If you want to know the options a program supports, start the program# with the "--help" option.## More detailed information about the individual options can also be# found in the manual.### CLIENT SECTION# ----------------------------------------------------------------------## The following options will be read by MySQL client applications.# Note that only client applications shipped by MySQL are guaranteed# to read this section. If you want your own MySQL client program to# honor these values, you need to specify it as an option during the# MySQL client library initialization.#[client] port=3306 [mysql] default-character-set=latin1  # SERVER SECTION# ----------------------------------------------------------------------## The following options will be read by the MySQL Server. Make sure that# you have installed the server correctly (see above) so it reads this # file.#[mysqld] # The TCP/IP Port the MySQL Server will listen onport=3306  #Path to installation directory. All paths are usually resolved relative to this.basedir="C:/MySQL/MySQL Server 5.1/" #Path to the database rootdatadir="C:/MySQL/MySQL Server 5.1/Data/" # The default character set that will be used when a new schema or table is# created and no character set is defineddefault-character-set=latin1 # The default storage engine that will be used when create new tables whendefault-storage-engine=INNODB # Set the SQL mode to strictsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" # The maximum amount of concurrent sessions the MySQL server will# allow. One of these connections will be reserved for a user with# SUPER privileges to allow the administrator to login even if the# connection limit has been reached.max_connections=800 # Query cache is used to cache SELECT results and later return them# without actual executing the same query once again. Having the query# cache enabled may result in significant speed improvements, if your# have a lot of identical queries and rarely changing tables. See the# "Qcache_lowmem_prunes" status variable to check if the current value# is high enough for your load.# Note: In case your tables change very often or if your queries are# textually different every time, the query cache may result in a# slowdown instead of a performance improvement.query_cache_size=0 # The number of open tables for all threads. Increasing this value# increases the number of file descriptors that mysqld requires.# Therefore you have to make sure to set the amount of open files# allowed to at least 4096 in the variable "open-files-limit" in# section [mysqld_safe]table_cache=619open-files-limit=2048 # Maximum size for internal (in-memory) temporary tables. If a table# grows larger than this value, it is automatically converted to disk# based table This limitation is for a single table. There can be many# of them.tmp_table_size=256M  # How many threads we should keep in a cache for reuse. When a client# disconnects, the client's threads are put in the cache if there aren't# more than thread_cache_size threads from before.  This greatly reduces# the amount of thread creations needed if you have a lot of new# connections. (Normally this doesn't give a notable performance# improvement if you have a good thread implementation.)thread_cache_size=38 #*** MyISAM Specific options # The maximum size of the temporary file MySQL is allowed to use while# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.# If the file-size would be bigger than this, the index will be created# through the key cache (which is slower).myisam_max_sort_file_size=100G # If the temporary file used for fast index creation would be bigger# than using the key cache by the amount specified here, then prefer the# key cache method.  This is mainly used to force long character keys in# large tables to use the slower key cache method to create the index.myisam_sort_buffer_size=67M # Size of the Key Buffer, used to cache index blocks for MyISAM tables.# Do not set it larger than 30% of your available memory, as some memory# is also required by the OS to cache rows. Even if you're not using# MyISAM tables, you should still set it to 8-64M as it will also be# used for internal temporary disk tables.key_buffer_size=290M # Size of the buffer used for doing full table scans of MyISAM tables.# Allocated per thread, if a full scan is needed.read_buffer_size=64Kread_rnd_buffer_size=256K # This buffer is allocated when MySQL needs to rebuild the index in# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE# into an empty table. It is allocated per thread so be careful with# large settings.sort_buffer_size=256K  #*** INNODB Specific options ***  # Use this option if you have a MySQL server with InnoDB support enabled# but you do not plan to use it. This will save memory and disk space# and speed up some things.#skip-innodb # Additional memory pool that is used by InnoDB to store metadata# information.  If InnoDB requires more memory for this purpose it will# start to allocate it from the OS.  As this is fast enough on most# recent operating systems, you normally do not need to change this# value. SHOW INNODB STATUS will display the current amount used.innodb_additional_mem_pool_size=12M # If set to 1, InnoDB will flush (fsync) the transaction logs to the# disk at each commit, which offers full ACID behavior. If you are# willing to compromise this safety, and you are running small# transactions, you may set this to 0 or 2 to reduce disk I/O to the# logs. Value 0 means that the log is only written to the log file and# the log file flushed to disk approximately once per second. Value 2# means the log is written to the log file at each commit, but the log# file is only flushed to disk approximately once per second.innodb_flush_log_at_trx_commit=2 # The size of the buffer InnoDB uses for buffering log data. As soon as# it is full, InnoDB will have to flush it to disk. As it is flushed# once per second anyway, it does not make sense to have it very large# (even with long transactions).innodb_log_buffer_size=6M # InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and# row data. The bigger you set this the less disk I/O is needed to# access data in tables. On a dedicated database server you may set this# parameter up to 80% of the machine physical memory size. Do not set it# too large, though, because competition of the physical memory may# cause paging in the operating system.  Note that on 32bit systems you# might be limited to 2-3.5G of user level memory per process, so do not# set it too high.innodb_buffer_pool_size=1024M # Size of each log file in a log group. You should set the combined size# of log files to about 25%-100% of your buffer pool size to avoid# unneeded buffer pool flush activity on log file overwrite. However,# note that a larger logfile size will increase the time needed for the# recovery process.innodb_log_file_size=113M # Number of threads allowed inside the InnoDB kernel. The optimal value# depends highly on the application, hardware as well as the OS# scheduler properties. A too high value may lead to thread thrashing.innodb_thread_concurrency=60#Lock mysqld in memory.(=Don't swap.)memlock#This option makes InnoDB to store each created table into its own .ibd file.innodb_file_per_table
My Startup.bat
Allow the "-server" to do its job. Try it and see.

Code: Select all

java -server -Xmx2048m -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer

My Gerneral.propeties config

Code: Select all

# ---------------------------------------------------------------------------# General Server Settings# ---------------------------------------------------------------------------# The defaults are set to be retail-like. If you modify any of these settings your server will deviate from being retail-like.# Warning: # Please take extreme caution when changing anything. Also please understand what you are changing before you do so on a live server.# ---------------------------------------------------------------------------  # ---------------------------------------------------------------------------# Administrator# ---------------------------------------------------------------------------# If this option is set to True every newly created character will have access level 200. This means that every character created will have Administrator Privileges.# Default: FalseEverybodyHasAdminRights = False # Show server/DP revision when players enter the game# Default: TrueDisplayServerRevision = False # Setting for serverList# Displays [] in front of server name on character selection# Default: FalseServerListBrackets = False # Displays a clock next to the server name on character selection.# Default: FalseServerListClock = False # If True, only accounts with GM access can enter the server.# Default: FalseServerGMOnly = False # Enable GMs to have the glowing aura of a Hero character on login. # Notes:#   GMs can do "///hero" on themselves and get this aura voluntarily.#   It's advised to keep this off due to graphic lag.# Default: FalseGMHeroAura = False # Auto set invulnerable status to a GM on login.# Default: FalseGMStartupInvulnerable = True # Auto set invisible status to a GM on login.# Default: FalseGMStartupInvisible = True # Auto block private messages to a GM on login.# Default: FalseGMStartupSilence = True # Auto list GMs in GM list (/gmlist) on login.# Default: FalseGMStartupAutoList = False # Auto set diet mode on to a GM on login (affects your weight penalty).# Default: FalseGMStartupDietMode = False # The way //admin panel looks can be "modern" or "classic" (default is modern while classic provides more compatibility).# Default: modernGMAdminMenuStyle = modern # Item restrictions apply to GMs aswell?GmItemRestriction = False  # ---------------------------------------------------------------------------# Server Security# ---------------------------------------------------------------------------# Bypass exploit protection. To ENABLE protection set to True.# Default: TrueBypassValidation = True # Enforce gameguard for clients. Sends a gameguard query on character login.# Default: TrueGameGuardEnforce = True # Don't allow player to perform trade, talk with npc, or move until gameguard reply is received.# Default: TrueGameGuardProhibitAction = True #Logging settings. The following four settings, while enabled, will increase writing to your hard drive(s) considerably. Depending on the size of your server, the amount of players, and other factors, you may suffer a noticable performance hit.# Default: FalseLogChat = False # Default: FalseLogItems = False # Default: FalseGMAudit = False # Default: FalseLogGameDamage = False  # ---------------------------------------------------------------------------# Thread Configuration# ---------------------------------------------------------------------------# Extreme caution should be here, set to defaults if you do not know what you are doing.# These could possibly hurt your servers performance or improve it depending on your server's configuration, size, and other factors. # Default: 10ThreadPoolSizeEffects = 50 # Default: 13ThreadPoolSizeGeneral = 65 # Default: 2UrgentPacketThreadCoreSize = 10 # Default: 4GeneralPacketThreadCoreSize = 20 # Default: 4GeneralThreadCoreSize = 20 # Default: 6AiMaxThread = 20 # Packet LifeTime in milliseconds. Disabled = 0.# Default: 0PacketLifeTime = 0 # Dead Lock Detector (a separate thread for detecting deadlocks).# For improved crash logs and automatic restart in deadlock case if enabled.# Check interval is in seconds.# Default: FalseDeadLockDetector = False # Default: 20DeadLockCheckInterval = 20 # Default: FalseRestartOnDeadlock = False  # ---------------------------------------------------------------------------# Optimization# ---------------------------------------------------------------------------# Flood Protector. Set the initial size of the flood protector (should equal about roughly your player count)# Default: 50FloodProtectorInitialSize = 1000 # Items on ground management.# Allow players to drop items on the ground.# Default: TrueAllowDiscardItem = False # Delete dropped reward items from world after a specified amount of seconds. Disabled = 0.# Default: 0AutoDestroyDroppedItemAfter = 0 # Time in secs after which dropped herb will be auto-destroyed (default: 15 seconds)# Default: 15AutoDestroyHerbTime = 15 # List of items that will not be destroyed (separated by ",").# Notes:#   Make sure the lists do NOT CONTAIN trailing spaces or spaces between the numbers!#   Items on this list will be protected regardless of the following options.# Default: 57,5575,6673ListOfProtectedItems = 57,5575,6673 # This is the interval (in minutes), that the gameserver will update a players information such as location.# The higher you set this number, there will be less character information saving so you will have less accessessing of the database and your hard drive(s).# The lower you set this number, there will be more frequent character information saving so you will have more access to the database and your hard drive(s).# A value of 0 disables periodic saving.# Independent of this setting the character is always saved after leaving the world.# Default: 15CharacterDataStoreInterval = 15 # This enables the server to only update items when saving the character.# Enabling this greatly reduces DB usage and improves performance.# WARNING: This option causes item loss during crashes.# Default: FalseLazyItemsUpdate = False # When enabled, this forces (even if using lazy item updates) the items owned by the character to be updated into DB when saving its character.# Default: FalseUpdateItemsOnCharStore = True # Also delete from world misc. items dropped by players (all except equip-able items).# Notes:#   Works only if AutoDestroyDroppedItemAfter is greater than 0.# Default: FalseDestroyPlayerDroppedItem = False # Destroy dropped equipable items (armor, weapon, jewelry).# Notes:#   Works only if DestroyPlayerDroppedItem = True# Default: FalseDestroyEquipableItem = False # Save dropped items into the database for restoring after restart.# Default: FalseSaveDroppedItem = False # Enable/Disable the emptying of the stored dropped items table after items are loaded into memory (safety setting).# If the server crashed before saving items, on next start old items will be restored and players may already have picked up some of them so this will prevent duplicates.# Default: FalseEmptyDroppedItemTableAfterLoad = False # Time interval in minutes to save in DB items on ground. Disabled = 0.# Notes:#   If SaveDroppedItemInterval is disabled, items will be saved into the database only at server shutdown.# Default: 60SaveDroppedItemInterval = 60 # Delete all saved items from the database on next restart?# Notes:#   Works only if SaveDroppedItem = False.# Default: FalseClearDroppedItemTable = False # Delete invalid quest from players.# Default: FalseAutoDeleteInvalidQuestData = False # Setting False can improve server performance on high rate/population servers.# Default: TruePreciseDropCalculation = False # Allow creating multiple non-stackable items at one time?# Default: TrueMultipleItemDrop = True # Forces full item inventory packet to be sent for any item change.# Notes:#   This can increase network traffic # Default: FalseForceInventoryUpdate = False # True = Load html's into cache only on first time html is requested.# False = Load all html's into cache on server startup.# Default: TrueLazyCache = True # Minimum and maximum variables in seconds for npc animation delay.# You must keep MinNPCAnimation < = MaxNPCAnimation.# Default: 10MinNPCAnimation = 10 # Default: 20MaxNPCAnimation = 20 # Default: 5MinMonsterAnimation = 5 # Default: 20MaxMonsterAnimation = 20 # Knownlist (the list of things a character sees) update method. Default is currently time based updating, which also makes it possible to use config options for guards to see moving monsters. Alternatively move based update can be used but guards cannot track mobs with that option but otherwise it should work well.# Default: FalseMoveBasedKnownlist = False # Interval (in miliseconds) in which the knownlist does full updates.# For move based updates its used for intermediate updates.# WARNING!#   Useful interval is between 300 - 2000. Too small value may kill your CPU, too high value may not update knownlists properly. The default value is chosen experimentally.# Default: 1250KnownListUpdateInterval = 1250 # Grid options: Grids can turn themselves on and off.  This also affects the loading and processing of all AI tasks and (in the future) geodata within this grid.# Turn on for a grid with a person in it is immediate, but it then turns on the 8 neighboring grids based on the specified number of seconds.# Turn off for a grid and neighbors occurs after the specified number of seconds have passed during which a grid has had no players in or in any of its neighbors.# The always on option allows to ignore all this and let all grids be active at all times (not suggested).# Default: FalseGridsAlwaysOn = False # Default: 1GridNeighborTurnOnTime = 1 # Default: 90GridNeighborTurnOffTime = 90  # ---------------------------------------------------------------------------# Geodata# ---------------------------------------------------------------------------# GeoData options:# 0 = GeoData and PathFinding OFF (default)# 1 = GeoData is used to check Line Of Sight (LOS) targeting and #     L2Playable movement. You need to download files for data/geodata folder.#     Monsters can pass walls but not aggro (no line of sight) through them.# 2 = Full GeoData enabled. Includes PathFinding (requires also /data/pathnode #     files if CellPathFinding not enabled) and all character moves go through #     geodata checks (if a mob passes a wall, pathfinding didn't find a route #     but we allow attack and returning home).#     Recommended server memory minimum 2 GB, rather 3 GB.# Default: 0GeoData = 0 # Cell-level pathfinding, produces more accurate routes but is (maybe 10x) heavier to calculate. Recommended for small servers at least.# If False, pathnode files are used. Uses a max number of nodes in calculation which can be adjusted in the algorithm if it needs to be faster.# Default: FalseCellPathFinding = False # True = Loads GeoData buffer's content into physical memory.# False = Does not necessarily imply that the GeoData buffer's content is not resident in physical memory.# Default: TrueForceGeodata = True # This setting controls Client <--> Server Player coordinates synchronization:# -1 - Will synchronize only Z from Client --> Server. Default when no geodata.# 1 - Synchronization Client --> Server only. Using this option (without geodata) makes it more difficult for players to bypass obstacles.# 2 - Intended for geodata (at least with cell-level pathfinding, otherwise can you try -1).# Server sends validation packet if client goes too far from server calculated coordinates.# Default: -1CoordSynchronize = -1  # ---------------------------------------------------------------------------# Features# ---------------------------------------------------------------------------# Zone Setting Options:# 0 = Peace All the Time# 1 = PVP During Siege for siege participants# 2 = PVP All the Time# Default: 0ZoneTown = 0 # Activates the position recorder. Valid 3D points will be recorded and written to data/universe.txt on shutdown.# Default: FalseActivatePositionRecorder = False # Global Chat.# Available Options: ON, OFF, GM, GLOBAL# Default: ONGlobalChat = ON # Trade Chat.# Available Options: ON (global), OFF, GM, LIMITED (region)# Default: LIMITEDTradeChat = LIMITED # If you are experiencing problems with Warehouse or Freight transactions, feel free to disable them here.# Default: TrueAllowWarehouse = True # Enable Warehouse Cache. If warehouse is not used will server clear memory used by this warehouse.# Default: FalseWarehouseCache = False # How long warehouse should be stored in memory.# Default: 15WarehouseCacheTime = 15 # Default: TrueAllowFreight = True # If True player can try on weapon and armor in shop.# Default: FalseAllowWear = False # Default: 5WearDelay = 5 #Adena cost to try on an item.# Default: 10WearPrice = 10  # ---------------------------------------------------------------------------# Misc Settings# ---------------------------------------------------------------------------# Default: TrueAllowRace = True # Default: TrueAllowWater = True # Enable pets for rent (wyvern & strider) from pet managers.# Default: FalseAllowRentPet = False # Default: TrueAllowFishing = True # Default: TrueAllowBoat = True # Default: TrueAllowCursedWeapons = True # This controls whether or not NPCs (not mobs) will walk around from one point to another.# Default: TrueAllowNpcWalkers = True #Allow Pet manager's pets to walk around.# Default: TrueAllowPetWalkers = True # Show "data/html/servnews.htm" when a character enters world.# Default: FalseShowServerNews = True # Type of the Community board:# 0 = community is disabled# 1 = old community# 2 = full community (not fully implemented, experimental)# Default: 1CommunityType = 0 # Default: FalseBBSShowPlayerList = True # Default: _bbshomeBBSDefault = _bbshome # show level of character to others in Community Board# Default: FalseShowLevelOnCommunityBoard = False # Default: TrueShowStatusOnCommunityBoard = True # Default: 50NamePageSizeOnCommunityBoard = 50 # Default: 5NamePerRowOnCommunityBoard = 5  # ---------------------------------------------------------------------------# Olympiad# ---------------------------------------------------------------------------# Olympiad Start Time in Military hours Default 6pm (18) # Default: 18AltOlyStartTime = 03 # Olympiad Start Time for Min's, Default 00 so at the start of the hour.# Default: 00AltOlyMin = 00 # Olympiad Competition Period, Default 6 hours.# (If set different, should be increment by 10mins)# Default: 21600000AltOlyCPeriod = 64800000 # Olympiad Battle Period, Default 6 minutes.# Default: 360000AltOlyBattle = 360000 # Olympiad Weekly Period, Default 1 week# Default: 604800000AltOlyWPeriod = 86400000 # Olympiad Validation Period, Default 24 Hours.# Default: 86400000AltOlyVPeriod = 10800000 # Required number of participants for Classed and Non-Classed matches, Default 5 & 9# Default: 5AltOlyClassedParticipants = 5 # Default: 9AltOlyNonClassedParticipants = 6 # Olympiad battle winner reward for class and non-class games.# Default: 6651AltOlyBattleRewItem = 6651 # Default: 50AltOlyClassedRewItemCount = 50 # Default: 30AltOlyNonClassedRewItemCount = 30 # Minimum points needed to to exchange noblesse gate pass.# Default: 50AltOlyMinPointForExchange = 50 # ItemId for this reward.# Default: 6651AltOlyCompRewItem = 6651 # Rate to exchange points to reward item.# Default: 1000AltOlyGPPerPoint = 10000 # Noblesse points awarded to Heros.# Default: 300AltOlyHeroPoints = 3000 # Hero tables show last month's winners or current status.# Default: TrueAltOlyShowMonthlyWinners = True # Olympiad Managers announce each start of fight.# Default: TrueAltOlyAnnounceGames = True # Restrict specified items in Olympiad. ItemID's need to be separated with a comma (ex. 1,200,350)# Default: 0AltOlyRestrictedItems = 0 # Enchant limit for items during Olympiad battles. Disabled = -1.# Default: -1AltOlyEnchantLimit = -1 # Log all Olympiad fights and outcome to olympiad.csv file.# Default: FalseAlyOlyLogFights = False  # ---------------------------------------------------------------------------# Manor# ---------------------------------------------------------------------------# Default: TrueAllowManor = True # Manor refresh time in military hours.# Default: 20 (8pm)AltManorRefreshTime = 20 # Manor refresh time (minutes).# Default: 00 (start of the hour)AltManorRefreshMin = 00 # Manor period approve time in military hours.# Default: 6 (6am)AltManorApproveTime = 6 # Manor period approve time (minutes).# Default: 00 (start of the hour)AltManorApproveMin = 00 # Manor maintenance time.# Default: 360000 (6 minutes)AltManorMaintenancePeriod = 360000 # Manor Save Type.# True = Save data into the database after every action# Default: FalseAltManorSaveAllActions = False # Manor Save Period (used only if AltManorSaveAllActions = False) Default very 2 hours# Default: 2AltManorSavePeriodRate = 2  # ---------------------------------------------------------------------------# Lottery# ---------------------------------------------------------------------------# Default: TrueAllowLottery = True # Initial Lottery prize.# Default: 50000AltLotteryPrize = 50000 # Lottery Ticket Price# Default: 2000AltLotteryTicketPrice = 2000 # What part of jackpot amount should receive characters who pick 5 wining numbers# Default: 0.6AltLottery5NumberRate = 0.6 # What part of jackpot amount should receive characters who pick 4 wining numbers# Default: 0.2AltLottery4NumberRate = 0.2 # What part of jackpot amount should receive characters who pick 3 wining numbers# Default: 0.2AltLottery3NumberRate = 0.2 # How much adena receive characters who pick two or less of the winning number# Default: 200AltLottery2and1NumberPrize = 200  # ---------------------------------------------------------------------------# Dimension Rift# ---------------------------------------------------------------------------# Minimal party size to enter rift. Min = 2, Max = 9.# If while inside the rift, the party becomes smaller, all members will be teleported back.# Default: 2RiftMinPartySize = 2 # Number of maximum jumps between rooms allowed, after this time party will be teleported back# Default: 4MaxRiftJumps = 4 # Time in ms the party has to wait until the mobs spawn when entering a room. C4 retail: 10s# Default: 10000RiftSpawnDelay = 10000 # Time between automatic jumps in seconds# Default: 480AutoJumpsDelayMin = 480 # Default: 600AutoJumpsDelayMax = 600 # Time Multiplier for stay in the boss room# Default: 1.5BossRoomTimeMultiply = 1.5 # Cost in dimension fragments to enter the rift, each party member must own this amount# Default: 18RecruitCost = 18 # Default: 21SoldierCost = 21 # Default: 24OfficerCost = 24 # Default: 27CaptainCost = 27 # Default: 30CommanderCost = 30 # Default: 33HeroCost = 33  # ---------------------------------------------------------------------------# Four Sepulchers# ---------------------------------------------------------------------------# Default: 50TimeOfAttack = 50 # Default: 5TimeOfCoolDown = 5 # Default: 3TimeOfEntry = 3 # Default: 2TimeOfWarmUp = 2 # Default: 4NumberOfNecessaryPartyMembers = 4  # ---------------------------------------------------------------------------# Punishment# ---------------------------------------------------------------------------# Player punishment for illegal actions:# 1 - broadcast warning to gms only# 2 - kick player(default)# 3 - kick & ban player# 4 - jail player (define minutes of jail with param: 0 = infinite)# Default: 2DefaultPunish = 4 # This setting typically specifies the duration of the above punishment.# Default: 0DefaultPunishParam = 10 # Apply default punish if player buy items for zero adena.# Default: TrueOnlyGMItemsFree = True # Jail is a PvP zone.# Default: TrueJailIsPvp = True # Disable all chat in jail (except normal one)# Default: TrueJailDisableChat = True  # ---------------------------------------------------------------------------# Database Custom Tables# ---------------------------------------------------------------------------# Default: FalseCustomSpawnlistTable = True # Option to save GM spawn only in the custom table.# Default: FalseSaveGmSpawnOnCustom = True # Option to delete spawn in alternate table.# Default: FalseDeleteGmSpawnOnCustom = True # Default: FalseCustomNpcTable = False # Default: FalseCustomItemTables = True # Default: FalseCustomArmorSetsTable = True# Default: FalseCustomTeleportTable = True # Default: FalseCustomDroplistTable = True # Default: FalseCustomMerchantTables = True  # ---------------------------------------------------------------------------# Developer Settings# ---------------------------------------------------------------------------# Do not touch these if you do not know what you are doing.# These settings are for debugging servers ONLY. They are not meant for LIVE servers. # Default: FalseDebug = False # Packet handler debug output# Default: FalsePacketHandlerDebug = False # Default: FalseAssert = False # Default: FalseDeveloper = False # Default: FalseAcceptGeoeditorConn = False # If True the server will be a test server (listed by test server clients only).# Default: FalseTestServer = False # If this is True then test servers will be listed like test servers.# Default: FalseListTestServers = False # Don't load quests.# Default: FalseAltDevNoQuests = False # Don't load spawntable.# Default: FalseAltDevNoSpawns = False
And...

Code: Select all

# Default: 100MaximumDbConnections = 1000
AND lastly, i noticed you did not specify an xmn value in your startup.bat
Yours

Code: Select all

java -server -Xmx6114m -Xms6114m -XX:PermSize=256m -XX:SurvivorRatio=8 -XX:+UseParallelGC -XX:+AggressiveOpts -XX:NewRatio=3 -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer
Change to

Code: Select all

java -server -Xmx2048m -Xms2048m -Xmn512m -XX:PermSize=256m -XX:SurvivorRatio=8 -XX:+UseParallelGC -XX:+AggressiveOpts -XX:NewRatio=3 -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer
See if that helps if you want to use all that still.
Post Reply