Welcome, Guest
Username: Password: Remember me

TOPIC: Database Sessions high CPU Load

Database Sessions high CPU Load 10 months 3 weeks ago #96448

  • keef
  • keef's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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
The administrator has disabled public write access.

Database Sessions high CPU Load - Graph 10 months 3 weeks ago #96452

  • keef
  • keef's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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:
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.088 seconds
Donation Image