Database Sessions high CPU Load

More
4 years 5 months ago #96448 by keef
keef created the topic: Database Sessions high CPU Load
Hi, We have found that when if we change our config.php file so that the sessions are stored in the database then run an load testing script on our LS setup we find that our MySQL servers load goes to 100% and we don't serve any pages! If we switch the config file back to storing the sessions on disk and run the test again then we able to server 350+ concurrent users. Any ideas where we might be going wrong ?

We are using (build 130514) from May 14 on Centos 6.4 x64 with the following....
Nginx 1.4.0 & FPM
PHP 5.4.14 w APC

& Seperate Server with MySQL 5.1.69

Thanks
Keith

Please Log in to join the conversation.

More
4 years 5 months ago #96452 by keef
keef replied the topic: Database Sessions high CPU Load - Graph
Attached is graph from showing CPU usage on the our Database server, The left side was with the session in the DB adn the right was when they were stored on disk.
Attachments:

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!