Thank you for the reply...
ZhangHuangbin: --How about do it with iRedAdmin-Pro?-- (We are currently using iRedAdmin-Pro, this server has been in production using this solution for over 3 years now).
ZhangHuangbin: --Do you need to update many user accounts?-- (We have around 150 active user accounts that we add/remove/modify using the iRedAdmin-Pro interface 3-4 users per month).
The problem is that when we attempt to log into the iRedAdmin-Pro(mySQL) interface, the login webpage sits and spins for around 40 minutes prior to allowing access to the interface (depending upon the browser/location/user, the connection will sometimes timeout, or disconnect, userKill, etc)... If I patiently wait using the correct browser/browser settings at the correct time of day (low load) I can gain access to make the modifications required. While this process looks harmless from the web browser it is causing major havoc on the server itself. Running "top" shows that attempting to access the iRedAdmin-Pro interface spikes the memory usage (4 GB) to a saturation point that it begins to utilize the swap due to the fact that there is no memory left for all the other processes. The memory hog seems to be mySQL processes initiated by the iRedAdmin-Pro interface and once it grabs the memory it refuses to release it back to the pool unless the server is rebooted. So basically if modifications need to be made during business hours, the mail queue backs up (worse we have seen is 6000 messages in the queue with a 5 hour delay) or we make the changes after hours and reboot the box in the AM. It has not always been this way and has been a slow regression... To this point we have been very happy with the box/software and performance, now not so much.
We know the best and correct long term solution is to upgrade the box and the software as we are on 8.1 and the latest is 8.7... We have started this process but it will take time to get this completed, move to production and move the users.
In the mean time we are hoping you might be able to provide a short term solution to add/remove/maintain users outside the scope of using the iRedAdmin-Pro interface or point us to a fix that we can run on the fly that would have minimal impact on users and would allow us to again utilize the iRedAdmin-Pro interface until we get the new box built and placed into production.
Thank you in advance for any help/direction you may be able to provide!
