Page 2 of 3

Re: Very Long restart.

Posted: Sun Jul 21, 2013 3:02 pm
by Arantir
Kzah wrote:And here very different. ><
my.cnf contains only default or frequently needed ones. Full list here http://dev.mysql.com/doc/refman/5.6/en/ ... ables.html
marcoviny wrote:Men this is not in server configuration but, ae in your mysql configuration verify your Mysql Configurations
What about
Kzah wrote:the CPU for java increases up to 150% or more.
?

Re: Very Long restart.

Posted: Mon Jul 22, 2013 3:57 am
by Kzah
I changed the file here is the result.

Red that has been modified or added.
 
[client]
port     = 3306
socket   = /var/run/mysqld/mysqld.sock
 
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
 
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket   = /var/run/mysqld/mysqld.sock
nice     = 0
 
[mysqld]
#
# * Basic Settings
#
user     = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket   = /var/run/mysqld/mysqld.sock
port     = 3306
basedir  = /usr
datadir  = /var/lib/mysql
tmpdir   = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address     = 127.0.0.1
#
# * Fine Tuning
#
key_buffer   = 32M
max_allowed_packet  = 32M
thread_stack     = 192K
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 = 3000
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 2M
query_cache_size = 32M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# 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
#
# * 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!
#
# * 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  = 32M
 
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
 
[isamchk]
key_buffer   = 32M
 
#
# * 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/
 
innodb_flush_log_at_trx_commit=2
 
innodb_buffer_pool_size=1024M
 
innodb_thread_concurrency=80
There have been improvements, but it does not seem to be good.

Before
GM shutdown countdown is over. restarting NOW!
OfflineTradersTable: Offline traders stored.
Offline Traders Table: Offline shops stored(2075ms).
All players disconnected and saved(139088ms).
Stopping GameTimeController
Game Time Controller: Timer stopped(0ms).
All ThreadPools are now stopped
Thread Pool Manager: Manager has been shut down(5176ms).
Community Server Thread: Thread interruped(0ms).
Login Server Thread: Thread interruped(0ms).
GM restart received. Restarting NOW!
SevenSigns: Seven Signs data saved(63031ms).
SevenSigns: Seven Signs status saved(192ms).
RaidBossSpawnManager: All raidboss info saved(61446ms).
GrandBossManager: All Grand Boss info saved(3343ms).
Hellbound Manager: Data saved(0ms).
Item Auction Manager: All tasks stopped(0ms).
Olympiad System: Data saved(1ms).
Hero System: Data saved(1ms).
Clan System: Data saved(2381ms).
Cursed Weapons Manager: Data saved(193ms).
Castle Manor Manager: Data saved(2435ms).
FortressOfResistance: Sucessfully saved attackers down to database!
DevastatedCastle: Sucessfully saved attackers down to database!
BanditStronghold: Sucessfully saved attackers down to database!
WildBeastReserve: Sucessfully saved attackers down to database!
FortressOfTheDead: Sucessfully saved attackers down to database!
CHSiegeManager: Siegable hall attacker lists saved!
Quest Manager: Data saved(323ms).
Global Variables Manager: Variables saved(2ms).
Items On Ground Manager: Data saved(186495ms).
Items On Ground Manager: Cleaned up(1ms).
Game Server: Selector thread has been shut down(0ms).
L2Database Factory: Database connection has been shut down(8ms).
After
GM shutdown countdown is over. restarting NOW!
OfflineTradersTable: Offline traders stored.
Offline Traders Table: Offline shops stored(1227ms).
All players disconnected and saved(16010ms).
Stopping GameTimeController
Game Time Controller: Timer stopped(0ms).
All ThreadPools are now stopped
Thread Pool Manager: Manager has been shut down(5002ms).
Community Server Thread: Thread interruped(0ms).
Login Server Thread: Thread interruped(1ms).
GM restart received. Restarting NOW!
SevenSigns: Seven Signs data saved(42040ms).
SevenSigns: Seven Signs status saved(150ms).
RaidBossSpawnManager: All raidboss info saved(49845ms).
GrandBossManager: All Grand Boss info saved(2243ms).
Hellbound Manager: Data saved(0ms).
Item Auction Manager: All tasks stopped(0ms).
Olympiad System: Data saved(2ms).
Hero System: Data saved(0ms).
Clan System: Data saved(1264ms).
Cursed Weapons Manager: Data saved(3ms).
Castle Manor Manager: Data saved(1500ms).
FortressOfResistance: Sucessfully saved attackers down to database!
DevastatedCastle: Sucessfully saved attackers down to database!
BanditStronghold: Sucessfully saved attackers down to database!
WildBeastReserve: Sucessfully saved attackers down to database!
FortressOfTheDead: Sucessfully saved attackers down to database!
CHSiegeManager: Siegable hall attacker lists saved!
Quest Manager: Data saved(1190ms).
Global Variables Manager: Variables saved(3ms).
Items On Ground Manager: Data saved(621117ms).
Items On Ground Manager: Cleaned up(1ms).
Game Server: Selector thread has been shut down(1ms).
L2Database Factory: Database connection has been shut down(4ms).
Kzah wrote:the CPU for java increases up to 150% or more.
?
Sometimes there are up to 150% of the CPU, but it quickly stabilizes at 5%

Re: Very Long restart.

Posted: Mon Jul 22, 2013 1:26 pm
by UnAfraid
Image

Re: Very Long restart.

Posted: Mon Jul 22, 2013 1:52 pm
by jurchiks
Thread pool manager - 5 seconds? wtf?

Re: Very Long restart.

Posted: Mon Jul 22, 2013 6:17 pm
by u3games
UnAfraid wrote:Image
Number of registered players in the server?

If you create a server, work fine. But, the problem is when registered users and need save the info of players.

Re: Very Long restart.

Posted: Mon Jul 22, 2013 9:00 pm
by Kzah
I am very far from having a good result by looking at the results Unfraid, what can I do to optimize it? :|

Re: Very Long restart.

Posted: Mon Jul 22, 2013 9:08 pm
by UnAfraid
Kzah wrote:I am very far from having a good result by looking at the results Unfraid, what can I do to optimize it? :|
I am using default mysql config just a lil bit tweaked to decrease memory usage because it was consuming 500 mb ram.

Re: Very Long restart.

Posted: Wed Jul 24, 2013 10:26 am
by Kzah
I tried with a stable and clean version, with the default configurations and database by default, but the weather is still too long.
All players disconnected and saved(834ms).
Stopping GameTimeController
Game Time Controller: Timer stopped(1ms).
All ThreadPools are now stopped
Thread Pool Manager: Manager has been shut down(5003ms).
Community Server Thread: Thread interruped(0ms).
Login Server Thread: Thread interruped(0ms).
GM shutdown received. Shutting down NOW!
SevenSignsFestival: Festival data saved(2129ms).
SevenSigns: Seven Signs data saved(1ms).
SevenSigns: Seven Signs status saved(157ms).
RaidBossSpawnManager: All raidboss info saved(48047ms).
GrandBossManager: All Grand Boss info saved(4643ms).
Hellbound Manager: Data saved(0ms).
TradeController saving data.. This action may take some minutes! Please wait until completed!
TradeController: All count Item saved(760ms).
Item Auction Manager: All tasks stopped(0ms).
Olympiad System: Data saved(312ms).
Hero System: Data saved(0ms).
Clan System: Data saved(0ms).
Cursed Weapons Manager: Data saved(2ms).
Castle Manor Manager: Data saved(7ms).
FortressOfResistance: Sucessfully saved attackers down to database!
DevastatedCastle: Sucessfully saved attackers down to database!
BanditStronghold: Sucessfully saved attackers down to database!
WildBeastReserve: Sucessfully saved attackers down to database!
FortressOfTheDead: Sucessfully saved attackers down to database!
CHSiegeManager: Siegable hall attacker lists saved!
Quest Manager: Data saved(494ms).
Global Variables Manager: Variables saved(1325ms).
Game Server: Selector thread has been shut down(0ms).
L2Database Factory: Database connection has been shut down(3ms).

Re: Very Long restart.

Posted: Wed Jul 24, 2013 12:00 pm
by xban1x
In either case your mysql is slow. A clean server shutsdown very quickly for me...

Re: Very Long restart.

Posted: Wed Jul 24, 2013 12:17 pm
by Kzah
I know, but i don't know how resolved this problem. :/
This is why I ask for help, but I know that does not come from the version. :lol:

Re: Very Long restart.

Posted: Wed Jul 24, 2013 1:32 pm
by HyperByter
try reinstalling mysql, or if you got version 5.5 try updating it to 5.6 or vice versa.

Re: Very Long restart.

Posted: Wed Jul 24, 2013 3:03 pm
by Kzah
I'll try !
But my version of Java is not Oracle Java JDK is:
java version "1.7.0_25"
OpenJDK Runtime Environment (IcedTea 2.3.10) (7u25-2.3.10-1ubuntu0.12.04.2)
OpenJDK 64-Bit Server VM (build 23.7-b01, mixed mode)
The problem may come out of there? This may be unrelated.

Re: Very Long restart.

Posted: Wed Jul 24, 2013 4:52 pm
by HyperByter
maybe it has something to do with it, well its recommended by L2j to use javaJDK \ jre so try to stay with "standarts" :D

Re: Very Long restart.

Posted: Wed Jul 24, 2013 7:30 pm
by UnAfraid
I am using oracle jdk always

Re: Very Long restart.

Posted: Sun Jul 28, 2013 9:19 pm
by Kzah
I have updated Mysql and it's resolved !