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

[newsbot]

автор: Ambal


<pre>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
</pre>
<pre style='white-space:pre-wrap;width:81ex'>[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 <mtmaps> 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 <pogrebniak@gala.net></pre>




Дальше...