ilija

Hey , i just want to know how to avoid lag when you backup your characters, because my characters are very big and i need to avoid it. Any ideas?

change in database to change names

What happens with memory / cpu usage with this patch?

I have runned, but i dont understand that much from mysql config, i will post my mysqlreport, sec: __ Key _________________________________________________________________ Buffer used 4.54M of 100.00M %Used: 4.54 Current 11.96M %Usage: 11.96 Write hit 76.11% Read hit 99.75% __ Questions ___________________________________________________________ Total 11.04M 25.7/s DMS 9.73M 22.6/s %Total: 88.18 Com_ 959.74k 2.2/s 8.70 QC Hits 312.03k 0.7/s 2.83 COM_QUIT 32.55k 0.1/s 0.29 -Unknown 123 0.0/s 0.00 Slow 10 s 38 0.0/s 0.00 %DMS: 0.00 Log: OFF DMS 9.73M 22.6/s 88.18 DELETE 2.91M 6.8/s 26.35 29.88 INSERT 2.75M 6.4/s 24.91 28.24 UPDATE 2.36M 5.5/s 21.35 24.21 SELECT 1.40M 3.3/s 12.72 14.43 REPLACE 314.70k 0.7/s 2.85 3.23 Com_ 959.74k 2.2/s 8.70 commit 397.14k 0.9/s 3.60 begin 397.10k 0.9/s 3.60 set_option 78.02k 0.2/s 0.71 __ SELECT and Sort _____________________________________________________ Scan 102.85k 0.2/s %SELECT: 7.32 Range 19.46k 0.0/s 1.39 Full join 20 0.0/s 0.00 Range check 1 0.0/s 0.00 Full rng join 0 0/s 0.00 Sort scan 4.54k 0.0/s Sort range 97.48k 0.2/s Sort mrg pass 0 0/s __ Query Cache _________________________________________________________ Memory usage 201.12M of 512.00M %Used: 39.28 Block Fragmnt 15.31% Hits 312.03k 0.7/s Inserts 1.33M 3.1/s Insrt:Prune 1.33M:1 3.1/s Hit:Insert 0.23:1 __ Table Locks _________________________________________________________ Waited 95 0.0/s %Total: 0.00 Immediate 10.24M 23.8/s __ Tables ______________________________________________________________ Open 64 of 64 %Cache: 100.00 Opened 106.67k 0.2/s __ Connections _________________________________________________________ Max used 25 of 151 %Max: 16.56 Total 32.61k 0.1/s __ Created Temp ________________________________________________________ Disk table 14.47k 0.0/s Table 40.10k 0.1/s Size: 16.0M File 5 0.0/s __ Threads _____________________________________________________________ Running 1 of 10 Cached 4 of 8 %Hit: 99.84 Created 51 0.0/s Slow 0 0/s __ Aborted _____________________________________________________________ Clients 126 0.0/s Connects 50 0.0/s __ Bytes _______________________________________________________________ Sent 3.59G 8.3k/s Received 1.83G 4.3k/s __ InnoDB Buffer Pool __________________________________________________ Usage 127.98M of 127.98M %Used: 100.00 Read hit 99.38% Pages Free 0 %Total: 0.00 Data 8.00k 97.66 %Drty: 0.00 Misc 192 2.34 Latched 0 0.00 Reads 173.72M 404.3/s From file 1.07M 2.5/s 0.62 Ahead Rnd 0/s Ahead Sql 0/s Writes 46.42M 108.0/s Flushes 3.86M 9.0/s Wait Free 0 0/s __ InnoDB Lock _________________________________________________________ Waits 0 0/s Current 0 Time acquiring Total 0 ms Average 0 ms Max 0 ms __ InnoDB Data, Pages, Rows ____________________________________________ Data Reads 1.14M 2.6/s Writes 4.26M 9.9/s fsync 959.52k 2.2/s Pending Reads 0 Writes 0 fsync 0 Pages Created 26.89k 0.1/s Read 1.14M 2.7/s Written 3.86M 9.0/s Rows Deleted 6.27M 14.6/s Inserted 7.49M 17.4/s Read 101.23M 235.6/s Updated 1.90M 4.4/s THANKS!

Seems to be easy how you say , only , sometimes i get so big log that i dont know what line i should look at, but normal is it first line where it says <value optimized> right?

Hey , i always update my core to the newest , and sometimes there are new crashes comming. I know the basic stuff of C++ , almost all basic you need and i wonder how to fix them , are there any guides. I already have GDB and see the output crashlogs. It is just last time there are more and more crashes comming , appears every 2 hours , very annoying! Thx Rusfighter

Wtf , my ibdate1 = 1.3 gb big, how could that come? And should i also change innodb_buffer_pool_size = 256M to bigger number? My mysql conf: # # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see # [url]http://dev.mysql.com/doc/mysql/en/server-system-variables.html[/url] # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location. [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 language = /usr/share/mysql/english skip-external-locking # # For compatibility to other Debian packages that still use # libmysqlclient10 and libmysqlclient12. old_passwords = 0 # # 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 = 100M max_allowed_packet = 128M thread_stack = 50M thread_cache_size = 8 default-storage-engine = INNODB sort_buffer_size = 4M join_buffer_size = 4M innodb_additional_mem_pool_size = 50M innodb_thread_concurrency = 1 innodb_log_files_in_group = 2 innodb_table_locks = 0 innodb_file_per_table = 1 # innodb_log_files_in_group = 2 #innodb_log_file_size = 32M innodb_log_buffer_size = 16M # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP #max_connections = 100 #table_cache = 64 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 50M query_cache_size = 512M # # * 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 at runtime! #log_type = FILE #general_log = /var/log/mysql/mysql.log # # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf. # # 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 = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M # # * 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/

Could someone tell me about the stability changes it makes?

Vladex , give error please. Ontopic: Does this cause any instability or more memory/cpu usage?

Hand-Mounted Pyro Rocket is bugged , it use spell effect Pyro Rocket. W What does it does? Im not kinda sure , but a rogue use Hand-Mounted Pyro Rocket and shadow dance can spam ambush without GLobal CD like 4+/- 5 times. This can be done with macro's Spell: http://thottbot.com/s54998 Someone knows this bug?

Here is my config , ye i had grinunload =0 , so thats reason , sorry for the conclusions i made ;( , but still fireworks dont disappear. ##################################### # MaNGOS Configuration file # ##################################### ConfVersion=2010040601 ################################################################################################################### # CONNECTIONS AND DIRECTORIES # # RealmID # RealmID must match the realmlist inside the realmd database # # DataDir # Data directory setting. # Important: DataDir needs to be quoted, as it is a string which may contain space characters. # Example: "/home/luminawow/district9fun/share/mangos" # # LogsDir # Logs directory setting. # Important: Logs dir must exists, or all logs need to be disabled # Default: "" - no log directory prefix, if used log names isn't absolute path # then logs will be stored in current directory for run program. # # # LoginDatabaseInfo # WorldDatabaseInfo # CharacterDatabaseInfo # Database connection settings for the world server. # Default: # ---MYSQL--- # hostname;port;username;password;database # .;somenumber;username;password;database - use named pipes at Windows # Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini # .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux # ---PGSQL--- # hostname;port;username;password;database # .;/path/to/unix_socket/DIRECTORY or . for default path;username;password;database - use Unix sockets at Unix/Linux # # MaxPingTime # Settings for maximum database-ping interval (minutes between pings) # # WorldServerPort # Default WorldServerPort # # BindIP # Bind World Server to IP/hostname # ################################################################################################################### RealmID = 1 DataDir = "/home/luminawow/district9fun/bin" LogsDir = "/home/luminawow/district9fun/logs" LoginDatabaseInfo = "localhost;3306;xxx;xxxx;realmd" WorldDatabaseInfo = "localhost;3306;xxxx;xxxx;districtfun" CharacterDatabaseInfo = "localhost;3306;xxxx;xxxx;chardistrict" MaxPingTime = 30 WorldServerPort = 8085 BindIP = "0.0.0.0" ################################################################################################################### # PERFORMANCE SETINGS # # UseProcessors # Used processors mask for multi-processors system (Used only at Windows) # Default: 0 (selected by OS) # number (bitmask value of selected processors) # # ProcessPriority # Process priority setting (Used only at Windows) # Default: 1 (HIGH) # 0 (Normal) # # Compression # Compression level for update packages sent to client (1..9) # Default: 1 (speed) # 9 (best compression) # # PlayerLimit # Maximum number of players in the world. Excluding Mods, GM's and Admins # Default: 100 # 0 (for infinite players) # -1 (for Mods, GM's and Admins only) # -2 (for GM's and Admins only) # -3 (for Admins only) # # SaveRespawnTimeImmediately # Save respawn time for creatures at death and for gameobjects at use/open # Default: 1 (save creature/gameobject respawn time without waiting grid unload) # 0 (save creature/gameobject respawn time at grid unload) # # MaxOverspeedPings # Maximum overspeed ping count before player kick (minimum is 2, 0 used for disable check) # Default: 2 # # GridUnload # Unload grids (if you have lot memory you can disable it to speed up player move to new grids second time) # Default: 1 (unload grids) # 0 (do not unload grids) # # SocketSelectTime # Socket select time (in milliseconds) # Default: 10000 (10 secs) # # GridCleanUpDelay # Grid clean up delay (in milliseconds) # Default: 300000 (5 min) # # MapUpdateInterval # Map update interval (in milliseconds) # Default: 100 # # ChangeWeatherInterval # Weather update interval (in milliseconds) # Default: 600000 (10 min) # # PlayerSave.Interval # Player save interval (in milliseconds) # Default: 900000 (15 min) # # PlayerSave.Stats.MinLevel # Minimum level for saving character stats for external usage in database # Default: 0 (do not save character stats) # 1+ (save stats for characters with level 1+) # # PlayerSave.Stats.SaveOnlyOnLogout # Enable/Disable saving of character stats only on logout # Default: 1 (only save on logout) # 0 (save on every player save) # # vmap.enableLOS # vmap.enableHeight # Enable/Disable VMmap support for line of sight and height calculation # Default: 0 (disable) # 1 (enable) # # vmap.ignoreMapIds # Map id that will be ignored by VMaps # List of ids with delimiter ',' # If more then one id is defined and spaces are included, the string has to be enclosed by " # Example: "369,0,1,530" # # vmap.ignoreSpellIds # These spells are ignored for LoS calculation # List of ids with delimiter ',' # # DetectPosCollision # Check final move position, summon position, etc for visible collision with other objects or # wall (wall only if vmaps are enabled) # Default: 1 (enable, required more CPU power usage) # 0 (disable, less nice position selection but will less CPU power usage) # # TargetPosRecalculateRange # Max distance from movement target point (+moving unit size) and targeted object (+size) # after that new target movmeent point calculated. Max: melee attack range (5), min: contact range (0.5) # More distance let have better performence, less distance let have more sensitive reaction at target move. # Default: 1.5 # # UpdateUptimeInterval # Update realm uptime period in minutes (for save data in 'uptime' table). Must be > 0 # Default: 10 (minutes) # # MaxCoreStuckTime # Periodically check if the process got freezed, if this is the case force crash after the specified # amount of seconds. Must be > 0. Recommended > 10 secs if you use this. # Default: 0 (Disabled) # # AddonChannel # Permit/disable the use of the addon channel through the server # (some client side addons can stop work correctly with disabled addon channel) # Default: 1 (permit addon channel) # 0 (do not permit addon channel) # # # CleanCharacterDB # Perform character db clean ups on start up # Default: 1 (Enable) # 0 (Disabled) # ################################################################################################################### UseProcessors = 0 ProcessPriority = 1 Compression = 4 PlayerLimit = 500 SaveRespawnTimeImmediately = 1 MaxOverspeedPings = 2 GridUnload = 1 SocketSelectTime = 10000 GridCleanUpDelay = 300000 MapUpdateInterval = 100 ChangeWeatherInterval = 600000 PlayerSave.Interval = 720000 PlayerSave.Stats.MinLevel = 0 PlayerSave.Stats.SaveOnlyOnLogout = 1 vmap.enableLOS = 1 vmap.enableHeight = 1 vmap.ignoreMapIds = "530, 369, 1, 571" vmap.ignoreSpellIds = "7720" DetectPosCollision = 0 TargetPosRecalculateRange = 2 UpdateUptimeInterval = 10 MaxCoreStuckTime = 120 AddonChannel = 1 CleanCharacterDB = 0

Hey , i think mangos has memory leak because the memory keeps increasing over time and not lowering. Example : Memory usage : 30% , Players : 200 , Server Uptime = 5 hours. Memory usage = 45% , Players:80 , Uptime = 10 hours. I have this issue for a long time ! (ON debian , ubuntu) Some one also have this problem? Im using newest mangos 9870, Newest ScriptDev2, YTDB. Any ideas how to fix? EDIT: one thing can be that fireworks dont disappear if some one fire it!

IS this causing any unstability? Or crashes?

Chain heal doesnt heal , it jumps to other party member but dont heal. What should it do? Heal, What do it? Nothing Any confirmination? Rev:9855

It deals 4k damage on my server , with T10.5 , that is kinda high to me.

The spell Devouring Plague seems to be bugged on rev:9851. http://www.wowhead.com/spell=2944 What does it do? It gives the damage not overtime but when casted. What should it do : Give damage over time and not instead. Someone can confirm?

Ehh , i mean the mangos-worldd process increase memory , not the mysql. Firework bug: If someone use fireworks , and gm come with .gm on firework dont disappear, keeps respawning

Hey, i have some questions , does mangos have sort of memory leaks? Because if the server longer time online the memory usage gets higher with same amount of players. And i have also other problem , in some places , the firework just appears, you cant remove it , you only see it when you have gm on , it removes after server restart. Somebody same problem? Thx Rusfighter

Ehh , it is same as .reset all spells or .reset all archievements or .reset all talents, as i understand looking into code -.-

What does it exactly? Delete whole character db? make it empty , or delete some cache?

Hey i just wonder if someone can confirm if resilience are bugged?

So what big projects insiders branch include, or that only some bug fixes?

Lol i know this , you understood me wrong i think , i just want to know what changes insider42 branch had against master of mangos

Hey , i read alot about Insider42 Branch , but what is the exactly different between it? I looking for that answer along time. Could some one tell me what is the difference or improvement?

Could someone say what Insider42 Branch includes???????????????????????????