Very Long restart.

[Arantir]

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

Men this is not in server configuration but, ae in your mysql configuration verify your Mysql Configurations

What about

the CPU for java increases up to 150% or more.

?

[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).

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%

[UnAfraid]

[jurchiks]

Thread pool manager - 5 seconds? wtf?

[u3games]

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.

[Kzah]

I am very far from having a good result by looking at the results Unfraid, what can I do to optimize it?

[UnAfraid]

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.

[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).

[xban1x]

In either case your mysql is slow. A clean server shutsdown very quickly for me...

[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.

[HyperByter]

try reinstalling mysql, or if you got version 5.5 try updating it to 5.6 or vice versa.

[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.

[HyperByter]

maybe it has something to do with it, well its recommended by L2j to use javaJDK \ jre so try to stay with "standarts"

[UnAfraid]

I am using oracle jdk always

[Kzah]

I have updated Mysql and it's resolved !