[11045] Rewrite internals of DB layer. Simplify code and use less locking. Spawn and use separate co

[newsbot]

автор: Ambal

m src/game/CharacterHandler.cpp

m src/game/ObjectMgr.cpp

m src/game/World.cpp

m src/game/World.h

m src/mangosd/Master.cpp

m src/mangosd/mangosd.conf.dist.in

m src/realmd/Main.cpp

m src/shared/Database/Database.cpp

m src/shared/Database/Database.h

m src/shared/Database/DatabaseImpl.h

m src/shared/Database/DatabaseMysql.cpp

m src/shared/Database/DatabaseMysql.h

m src/shared/Database/DatabasePostgre.cpp

m src/shared/Database/DatabasePostgre.h

m src/shared/Database/SqlDelayThread.cpp

m src/shared/Database/SqlDelayThread.h

m src/shared/Database/SqlOperations.cpp

m src/shared/Database/SqlOperations.h

m src/shared/revision_nr.h

[11045] Rewrite internals of DB layer. Simplify code and use less locking. Spawn and use separate connections for sync and async DB requests. Implement database connection pool for SELECT queries. Up to maximum 16 connections supported. Disable 'autocommit' mode for MySQL.



UPDATE YOUR CONFIGS!



Defaults:

LoginDatabaseConnections = 1

WorldDatabaseConnections = 1

CharacterDatabaseConnections = 1



If you are not using  patch do not change the default settings - this is useless. You can try following option in your MySQL config to squeeze even more performance from your DB:



[mysqld]

transaction-isolation = READ-COMMITTED



Great thanks to Undergarun, kero99 and selector for making tests and providing very useful feedback and DB statistics! Have fun :)



Signed-off-by: Ambal 

Дальше...