kero99

Confirmed, i have less crashes but still crash =(

try: cd /root/tbb/build/linux*release cp *.2 /usr/lib cd /usr/lib ln -s libtbb.so.2 libtbb.so ln -s libtbbmalloc.so.2 libtbbmalloc.so ln -s libtbbmalloc_proxy.so.2 libtbbmalloc_proxy.so

TBB is not CPU Type related: http://software.intel.com/en-us/blogs/2007/08/02/threading-building-blocks-amd-athlon-64-x2-and-gentoo-linux/

Yes, only can compile tbb in a thread, with make -jX i have compile error. Mutithread library cant be compile in multithread.. lol

Linked library problem, revise this line: -MANGOS_LIBS="$ACE_LIBS $POSTGRE_LIBS $MYSQL_LIBS $ZLIB $COMPATLIB $OPENSSL_LIBS $MANGOS_LIBS" +MANGOS_LIBS="$ACE_LIBS $POSTGRE_LIBS $MYSQL_LIBS $ZLIB $COMPATLIB $OPENSSL_LIBS $MANGOS_LIBS -ltbb" You need -ltbb to say compiler that use TBB Library Or Revise tbbvars.sh, in my environment: #!/bin/bash export TBB22_INSTALL_DIR="/root/tbb" <-------------- Directory that was created when you unpacked your TBB download [/color] tbb_bin="${TBB22_INSTALL_DIR}/build/linux_intel64_gcc_cc4.4.1_libc2.10.1_kernel2.6.32.2_release" <--------------- Directory tree should be created automatically when you build TBB from source[/color] if [ -z "$CPATH" ]; then # export CPATH="${TBB22_INSTALL_DIR}/include" # else # export CPATH="${TBB22_INSTALL_DIR}/include:$CPATH" # fi # if [ -z "$LIBRARY_PATH" ]; then # export LIBRARY_PATH="${tbb_bin}" # else # export LIBRARY_PATH="${tbb_bin}:$LIBRARY_PATH" # fi # if [ -z "$LD_LIBRARY_PATH" ]; then # export LD_LIBRARY_PATH="${tbb_bin}" # else # export LD_LIBRARY_PATH="${tbb_bin}:$LD_LIBRARY_PATH" # fi # # ] If file is ok, run it with ./tbbvars.sh and your system will find ok all tbb libraries *NOTE: Remove objdir and do again: autoreconf --install --force automake --add-missing automake src/bindings/ScriptDev2/Makefile mkdir objdir cd objdir ....

Can you paste compile errors? * I Use Ubuntu Server 9.10 in core server, i love ext4 filesystem

Hi, finally i solved my problem implementing concurrent_vector.. here are the updated patches for 9366: MTMaps: http://pastebin.com/f20f6500b Concurrent_vector: http://pastebin.com/f66c0e16a For Linux Environment you may need some global config: cd /root wget [url]http://www.threadingbuildingblocks.org/uploads/77/142/2.2/tbb22_20090809oss_src.tgz[/url] tar xvfz tbb22_20090809oss_src.tgz mv tbb22_20090809oss tbb cd tbb/src make cd /root/tbb/build/linux*release chmod 777 tbbvars.sh ./tbbvars.sh Best Regards

Hi again, i have little problem in compile with concurrent_vector... all files compile ok but fail building in mangos-worldd =( : http://paste2.org/p/664186 Best Regards

Thankkkss!!! OMG, you made me happier than my wife!!

Welcome again Infinity =), can you put any example of use of tbb::concurrent_vector? Im confused with intel documentation

Not much to explain, sort_buffer_size and join_buffer_size is a buffer for Sort and Join SQL operations... Buffers rules: - More buffers size, less performance - Less buffers size, more performace - Less than needed, more crashes With some software you can tunning buffers for your application and in mangos case.. 4M is a good value

A documentation project where devel and users can participe will be cool.

I use this two config by default in all my linux systems : kernel.core_pattern = core.%p -> Is use to set the default format of coredump: core:%p = core.pid, or core.%e = core.filename kernel.sem = 512 32000 100 512 -> Is for set a custom limit on kernel semaphores ("Semaphores can best be described as counters which are used to provide synchronization between processes or between threads within a process for shared resources like shared memories"), i never sure if a application need more limits in semaphores or not (ORACLE OR SAP for example need custom config too)... and i always up the default parameters for avoid system crashes. max number of arrays = 512 max semaphores per array = 32000 max semaphores system wide = 100 max ops per semop call = 512 Best Regards

O_O 64gb!!! wow!!, we db server have 24 gb and mysql dont reserve more of 12 - 13gb... you cant see your real mysql ram consumption with htop (not use top, use htop -> apt-get install htop), my real use is 5-6gb. innodb_buffer_pool_size parameter is simple... is (little more) the size of your character DB: More Character DB size = More innodb_buffer_pool_size More innodb_buffer_pool_size = Less Performance else Less Character DB size AND Less innodb_buffer_pool_size = Better Performance Best Regards P.D: Yes i know that my innodb_buffer_pool_size is huge... but not lag for now... i need know my limit ^^, and then.. cleaning characters from db...

RAID 0 = RAID 1 more or less in READ and RAID 0 > RAID 1 in WRITE but RAID 0 is dangerous for all systems (desktop included ) and RAID 1 is not enoght for INNODB write requirements... But... maybe this post is not for RAID discussions ^^

DB Tips updates =)

Tips for Database Server: - Networking It is very important that your database is in the same network as your core server and connected to GigaLan, for a better latency and performance you can use same config in TCP Stack that in core tips - System RAM Memory: The only factor of consumption is your character db size, is easy... more characters.. you need more RAM or do more cleanning in character db, no more secret (and obviously Ram more faster is better ). Processors: Is not de more important in DB Server, but not bad have a good processor. IO: The secret and the most important thing you must know is that reached a point... how powerful it may be your processor or your ram is not important because you will have a bottleneck in your hard drives and all your system will wait the HDD response (yes... here is the game lag). This problem appear aprox with 1000+ ppl in SATA, 1800+ in SAS... RAID 5 or 0+1 can modify that statistics. The solution if you want a 2000+ system without lag is a better HDD Performance, High Performance models of SSD disk is the better solution for now, and with RAID 1+0... your server can fly =) - MYSQL Details MySQL Version: If you want a very stable and powerful DB, XtraDB of Percona is a good solution and very easy to install (https://launchpad.net/percona-xtradb). You can have a funtional MYSQL server in less that 10 min if you have a Ubuntu Server 10.10 Maverick: - Edit your /etc/apt/sources.list - Add two lines: deb [url]http://repo.percona.com/apt[/url] maverick main deb-src [url]http://repo.percona.com/apt[/url] maverick main (this repository is high tested for percona devel and maximize compatibility with a clean Ubuntu Server) - wget http://www.percona.com/downloads/RPM-GPG-KEY-percona - apt-key add RPM-GPG-KEY-percona - aptitude update - aptitude upgrade - aptitude install percona-server-server-5.1 percona-server-client-5.1 - Config your password with assistant and ready to use =) MySQL Tunning: (thank to Homenixx for tips) Config designed for 2000 to 3000 player online max: max_allowed_packet = 128M # Allows inserts dumps with bulks up to 128 MB which allows backups / restore faster. Recomended values: max_allowed_packet = 1M # Default max_allowed_packet = 32M # 256 MB RAM max_allowed_packet = 64M # 1 GB RAM max_allowed_packet = 128M # 2.5+ GB RAM default-storage-engine = INNODB # For characters DB tables (dont forgot change your tables to INNODB) skip-external-locking - Recommended to avoid table locks with MaNGOS running. max_connections = 20 -> MaNGOS opens 3 connections. One for mangosworld table, other for characters and one for scriptdev2. Realmd open the fourth connection for logon. 20 connections with more than enough to even have PHP scripts accessing the DB. sort_buffer_size = 4M -> Recommended for MaNGOS. join_buffer_size = 4M -> Recommended for MaNGOS. INNODB FEATURES =============== innodb_additional_mem_pool_size = 50M # Values beetween 20M and 50M are enough for character tables and for every innodb database. innodb_thread_concurrency = 8 # 1 To Processors of 1 or 2 cores. 2 for Quad CoRe. 4 for i7 / Xeon and 8 for Bi-XEON (2 processors). innodb_flush_method = O_DSYNC # Depend of your HDD innodb_flush_log_at_trx_commit = 0 # 0 to reduce the I / O of HD, but in case of a fall is to lose data from the last transaction. 1 recommended for losing nothing. (More I/O) 2 Mix beetween one and two. innodb_buffer_pool_size = 7G # The size of the table of characters plus a margin. ¡¡¡¡ATTENTION THIS IS SPACE FOR MYSQL RAM!!!! which is reserved! innodb_log_files_in_group = 2 # Recomended for reduce log file access. innodb_log_file_size = 32M # Size of the log. innodb_log_file_size x innodb_log_files_in_group. innodb_log_buffer_size = 16M # Buffer needed to process... 1/4 del log_size total. innodb_file_per_table = 1 # Recomended for reduce file access. innodb_table_locks = 0 # Disable table lock. We do not care that an application crash or MaNGOS crashes too!. MAGIC FORMULA ============= MySQL DEDICATED SERVER MEMORY = key_buffer_size + max_connections * (join_buffer + record_buffer + sort_buffer + thread_stack + tmp_table_size) note: MySQL settings should correspond to the use which gives the server, there is no ideal configuration. Only the server admin, the person who monitors the server every day knows the exactly MySQL settings. These are basic tips result of my experience. by Homenixx

database problem, YTDB is a good database but... sometimes... buged somethings in updates

All these problem are from database, maybe not core related

You need revert two commit: first: http://github.com/mangos/mangos/commit/d86ad9e91fd1623be131f3f558dba34ac0040925 second: http://github.com/mangos/mangos/commit/e8929f3c939dfad55518e316711ed260cdbddca8 Best Regards

Yes, the documented procedure of compiling in linux is outdated for example in my case was: > autoreconf --install --force > [color="red"]aclocal[/color] > [color="red"]autoheader[/color] > [color="red"]autoconf[/color] > automake --add-missing > automake src/bindings/ScriptDev2/Makefile > mkdir objdir > cd objdir > ../configure CFLAGS="-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -m64 -pipe -msse4.2 -DFD_SETSIZE=4096 -fno-delete-null-pointer-checks -fno-strength-reduce -fno-strict-aliasing -frename-registers" CXXFLAGS="-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -m64 -pipe -msse4.2 -DFD_SETSIZE=4096 -fno-delete-null-pointer-checks -fno-strength-reduce -fno-strict-aliasing -frename-registers" --prefix=/opt/mangos --sysconfdir=/opt/mangos/etc --enable-cli --enable-ra --datadir=/opt/mangos --with-debug-info --disable-builtin-ace autoreconf = aclocal && autoheader && automake && autoconf And maybe that redundant execution of autoconf is the origin of problem in new configure.ac version Now with the procedure in snake post all compiling ok =): autoreconf --install --force automake --add-missing automake src/bindings/ScriptDev2/Makefile mkdir objdir cd objdir ../configure CFLAGS="-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -m64 -pipe -msse4.2 -DFD_SETSIZE=4096 -fno-delete-null-pointer-checks -fno-strength-reduce -fno-strict-aliasing -frename-registers" CXXFLAGS="-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -m64 -pipe -msse4.2 -DFD_SETSIZE=4096 -fno-delete-null-pointer-checks -fno-strength-reduce -fno-strict-aliasing -frename-registers" --prefix=/opt/mangos --sysconfdir=/opt/mangos/etc --enable-cli --enable-ra --datadir=/opt/mangos --with-debug-info --disable-builtin-ace Best Regards

This check makes by nanounico fixed crashes in HandleMovementOpcodes, try it:

rev 9260 not compile again in linux environment =(

In Debian Still fail with "-with-openssl"... I try with 0.9.8k from debian repository and compiled my self: ./config --prefix=/usr/local/openssl --openssldir=/usr/local/openssl make make test make install All compile OK, and I installed all in /usr/local/openssl I use --with-openssl=/usr/local/openssl -> Configure OK but make fail Try to --with-openssl-lib=/usr/local/openssl/lib --with-openssl-include=/usr/local/openssl/include/openssl -> Configure OK but make fail again. Maybe not mangos core problem, can be related with debian based systems and new detection system...