Page 1 of 2

Java/Mysql help!

Posted: Wed Sep 08, 2010 6:51 pm
by badboy29
Hello people, i did a hardware upgrade on my server, and would like a help to use the maximum performance it can offer.

Code: Select all

Dual Intel Xeon 5520 2.26 GHz Quad Core Processor   6 GB RAM DDR32x 146 GB 15K RPM SCSI/SAS HDD  100 Mbps Network UplinkUbuntu GNU/Linux 9.04 x64
I'm currently using:

MySql

Code: Select all

memlockmyisam-recover = BACKUPkey_buffer = 600Mjoin_buffer = 10Mjoin_buffer_size = 256Kmax_allowed_packet = 32Mthread_stack = 256Kthread_cache_size = 16max_connections = 600table_cache = 1024thread_concurrency = 8query_cache_limit = 128Mquery_cache_size = 512Mquery_cache_type = 1skip-innodbskip-federated
GameServer_loop.sh

Code: Select all

java -server -Djava.util.logging.manager=com.l2jserver.util.L2LogManager -Xms2048m -Xmx4096m -Xmn512m -Xss128k -XX:ParallelGCThreads=8 -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:SurvivorRatio=8 -XX:TargetSurvivorRatio=90 -XX:MaxTenuringThreshold=31 -XX:+AggressiveOpts -XX:MaxPermSize=512m -XX:+UseCompressedOops -cp ./../libs/*:l2jserver.jar com.l2jserver.gameserver.GameServer > log/stdout.log 2>&1
Thread settings

Code: Select all

ThreadPoolSizeEffects = 10 # Default: 13ThreadPoolSizeGeneral = 13 # Default: 2UrgentPacketThreadCoreSize = 2 # Default: 4GeneralPacketThreadCoreSize = 4 # Default: 4GeneralThreadCoreSize = 4 # Default: 6AiMaxThread = 6
Geodata

Code: Select all

# ---------------------------------------------------------------------------# 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 = 2 # 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 = True # Pathfinding array buffers configurationPathFindBuffers = 100x6;128x6;192x6;256x4;320x4;384x4;500x2 # Weight for nodes without obstacles far from wallsLowWeight = 0.5 # Weight for nodes near wallsMediumWeight = 2 # Weight for nodes with obstaclesHighWeight = 3 # Angle paths will be more "smart", but in cost of higher CPU utilizationAdvancedDiagonalStrategy = True # Weight for diagonal movement. Used only with AdvancedDiagonalStrategy = True# Default: LowWeight * sqrt(2) DiagonalWeight = 0.707 # Maximum number of LOS postfilter passes, 0 will disable postfilter.# Default: 3MaxPostfilterPasses = 3 # Path debug function.# Nodes known to pathfinder will be displayed as adena, constructed path as antidots.# Number of the items show node cost * 10# Potions display path after first stage filter# Red potions - actual waypoints. Green potions - nodes removed by LOS postfilter# This function FOR DEBUG PURPOSES ONLY, never use it on the live server !DebugPath = 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
Any tips or all ok ? :D

Re: Java/Mysql help!

Posted: Thu Sep 09, 2010 10:52 pm
by achilless
OS ? Windows 7 ? if so then everything is fine just!

Re: Java/Mysql help!

Posted: Thu Sep 09, 2010 11:21 pm
by LasTravel
Windows 7? lol... He are using debian.

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 12:07 am
by Raikkon35
Debian? lol... He is using Ubuntu. :D

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 7:13 am
by SolidSnake
badboy29 wrote:

Code: Select all

Dual Intel Xeon 5520 2.26 GHz Quad Core Processor   6 GB RAM DDR32x 146 GB 15K RPM SCSI/SAS HDD  100 Mbps Network UplinkUbuntu GNU/Linux 9.04 x64

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 8:17 am
by kama3a
i have problem with the import of sql files.
let me explain :
when try import the sql file 300 mb... the import is rly slow it take up to 2-3hours.
i try with navicat and directly from the root machine.
it make 600 query per sec... and its rly slow
the export speed is normal .. i try almost everything
can u give any advice where to check ?
-different mysql versions.
-modified my.cnf
-operation sys Linux Debian x64

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 8:41 am
by rocoder
u don't want to know how much take to import for a big server :P

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 8:53 am
by kama3a
rocoder wrote:u don't want to know how much take to import for a big server :P
its not normal import speed to be ... rly slow
and export to be normal.

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 10:32 am
by babyjason
it is very normal.

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 10:56 am
by kama3a
babyjason wrote:it is very normal.
ye verry normal export to take 1 min
import to take 3-5hours.

give me 1 logic answer and i will belive you.

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 11:40 am
by rocoder
kama3a wrote:
babyjason wrote:it is very normal.
ye verry normal export to take 1 min
import to take 3-5hours.

give me 1 logic answer and i will belive you.
last time when I moved a server, I w8 12h+;)) (but server db was big (1 year old with ~500+)) :roll:

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 11:44 am
by kama3a
rocoder wrote:
kama3a wrote:
babyjason wrote:it is very normal.
ye verry normal export to take 1 min
import to take 3-5hours.

give me 1 logic answer and i will belive you.
last time when I moved a server, I w8 12h+;)) (but server db was big (1 year old with ~500+)) :roll:
i dont care rly for size and etc...
i need some profesional answer why import is slow.
i check almost 99 % from the system and didnt find correct answer.

waiting for some pro answer.

ty

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 11:59 am
by rocoder
pro answer:
if u have 1000 characters crated in db that mean u will have over ~100 querys/each player that mean over 100k querys (but for sure will be more) to execute.. each query take time...:P also..with more rows in table take more time for a query to execute...

EDIT:
btw... if u want to be faster do not import/export, make a backup! and restore backup:P will be a lot faster;)

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 12:06 pm
by kama3a
on windows take 4-5 min
on linux machine that is 100 times faster take 2-5hours.

its not from net,speed,cpu usage,etc...

from 2 days checking still didnt find the problem.

bump for support.

Re: Java/Mysql help!

Posted: Fri Sep 10, 2010 1:12 pm
by JMD
You can connect to your database with navicat and use autocommit for big database imports. Its faster.