processes and sessions
Dear colleagues:
I wanted to know any suggestions to improve the performance of the database manager, because we contend with a web application developed in PHP, and although certain parameters improved saturation is intense. In the case of processes are in 300 and sessions in 600, as to swap this in 20gb.
The situation becomes critical, although developers report that they closed sessions and improved SQL.
There is an option which could kill those idle sessions after a tiepo last approximately an hour, but consider not the end but a too extreme case. Although this process can be applied if access would
I wanted to know any suggestions to improve the performance of the database manager, because we contend with a web application developed in PHP, and although certain parameters improved saturation is intense. In the case of processes are in 300 and sessions in 600, as to swap this in 20gb.
The situation becomes critical, although developers report that they closed sessions and improved SQL.
There is an option which could kill those idle sessions after a tiepo last approximately an hour, but consider not the end but a too extreme case. Although this process can be applied if access would
0