Hi,
I have been looking at how GM is dealing with mysql connections and am now under the impression that something is seriously wrong either with GM or our settings.
I started by shutting down mysql and restarting. Meaning at that time, zero connections exist.
I loaded GM login page. Checked mysql connections, already 1 is there as expected.
But here is where things start going really wrong.
I logged in, another connection is established. Total is now 2
I read first email. Another connection established. Total is now 3.
I read another email. Same as above and now total is 4 active connections.
By the time I was done, I had 22 active mysql connections to GM database!!!! Even when I logged out, another connection was added!
I returned 2 hours later. All connections still there! Connected again and by end of that session I had 37 connections! There seems to be no limit on how many connections one single user can cause.
I cannot understand how same user ends up with so many connections. I also do not understand why these remain hanging in there and do not terminate.
I believe there are 2 types of mysql connections:
a)One opens and closes with each request
b)Another persists
The behavior above does not fit either above I believe. For persistent connections, I am supposed to get 1 mysql connection that persists session after session after session for all connections made by same user not a new connection for every mysql query.
Any insight to what is going on here? It seems such a situation will make GM unusable or am I missing something? Is this a problem with GM or is there something wrong with my mysql settings? I have Pentium 4, 1 GB RAM dedicated server
Thanks
Frank
I have been looking at how GM is dealing with mysql connections and am now under the impression that something is seriously wrong either with GM or our settings.
I started by shutting down mysql and restarting. Meaning at that time, zero connections exist.
I loaded GM login page. Checked mysql connections, already 1 is there as expected.
But here is where things start going really wrong.
I logged in, another connection is established. Total is now 2
I read first email. Another connection established. Total is now 3.
I read another email. Same as above and now total is 4 active connections.
By the time I was done, I had 22 active mysql connections to GM database!!!! Even when I logged out, another connection was added!
I returned 2 hours later. All connections still there! Connected again and by end of that session I had 37 connections! There seems to be no limit on how many connections one single user can cause.
I cannot understand how same user ends up with so many connections. I also do not understand why these remain hanging in there and do not terminate.
I believe there are 2 types of mysql connections:
a)One opens and closes with each request
b)Another persists
The behavior above does not fit either above I believe. For persistent connections, I am supposed to get 1 mysql connection that persists session after session after session for all connections made by same user not a new connection for every mysql query.
Any insight to what is going on here? It seems such a situation will make GM unusable or am I missing something? Is this a problem with GM or is there something wrong with my mysql settings? I have Pentium 4, 1 GB RAM dedicated server
Thanks
Frank