Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Database Sessions high CPU Load

Database Sessions high CPU Load il y a 1 an 4 mois #96448

  • keef
  • Portrait de keef
  • Hors ligne
  • Fresh Lemon
  • Messages : 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
L'administrateur a désactivé l'accès en écriture pour le public.

Database Sessions high CPU Load - Graph il y a 1 an 4 mois #96452

  • keef
  • Portrait de keef
  • Hors ligne
  • Fresh Lemon
  • Messages : 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.
Pièces jointes :
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.117 secondes
Donation Image