Nishant

Hi, @flydev, ASG stands for Auto Scaling Groups. (Basically there are multiple server instances running and delivering the website content. In simple terms, let's say the website is running on one server and the CPU usage has hit 60% it will automatically activate another server instance and now two instances will distribute the work.) Below are the required details, Database: MySQL Server version: 8.0.23 - Source distribution max_connections: 1000 session.save_path: /var/lib/lsphp/session/lsphp81 session.save_handler: files regards

@bernhard @teppo @netcarver, though disabling the SessionHandlerDB module resolved the website speed issue, but that created another major problem. As my site is running on an ASG setup, there are multiple server instances running and delivering site contents at the same time. Now the session is stored in the file system, it randomly loggs-out the processwire user when switching between the instances (Switching of instances happens on its own, we can't handle it, if I turn off all the instances and keep only 1 then it will solve the problem, but will create performance issues as the website has large number of visitors). The only possible and reliable solution is to store the sessions on the database, do ProcessWire supports this natively without using any module?

Definitely, I will have a word with the server team and can gather the required details you need for the tutorial

Not sure if the session had grown large, as after uninstalling the SessionDBHandler module, the table is also removed from the database. But last time I checked under processwire panel, It was showing somewhere around 200 active sessions. (I have an RDS and ASG setup on AWS, and on the load tests it was able to handle 10000+ concurrent users. Not sure if 200 active sessions can slow down the performance so drastically)

Hi @teppo @netcarver, The version for SessionDBHandler was 0.0.6 Database engine is InnoDB

Yes, I have uninstalled that module and the site seems to be working fine now. Will test for couple of more days and see if that was the primary cause.

Yes @netcarver, I am using the SessionDBHandler module

Hello All, My processwire website is running very slow, I had a word with my server support team and they said that there are multiple "GET_LOCK" queries running which is causing the server to slow down. Attaching a screenshot of the MySQL queries below if anyone had similar problems or know the solution then please do help.