* Added new "SuperManager" class for MySQL connections, for allowing multiple concurrent MySQL threads.

* Implemented SuperManager inside of UserData. This means the userserver when running on MySQL will use 10 connections (+1 system connection) to handle requests, preventing the previous mire of locking resulting in singlethreadedness.
* This requires testing and grids relying on stability should not upgrade to this revision until it's been properly tested.

1 files changed, 27 insertions, 0 deletions

diff --git a/OpenSim/Data/MySQL/MySQLSuperManager.cs b/OpenSim/Data/MySQL/MySQLSuperManager.cs
new file mode 100644
index 0000000..848a0bd
--- /dev/null
+++ b/OpenSim/Data/MySQL/MySQLSuperManager.cs
@@ -0,0 +1,27 @@
+using System;

+using System.Collections.Generic;

+using System.Text;

+using System.Threading;

+

+namespace OpenSim.Data.MySQL

+{

+    class MySQLSuperManager

+    {

+        public bool Locked;

+        private Mutex m_lock;

+        public MySQLManager Manager;

+

+        public void GetLock()

+        {

+            Locked = true;

+            m_lock.WaitOne();

+        }

+

+        public void Release()

+        {

+            m_lock.ReleaseMutex();

+            Locked = false;

+        }

+

+    }

+}