django, mod_wsgi, MySQL High CPU - Problems

Posted by Red Rover on Server Fault See other posts from Server Fault or by Red Rover
Published on 2012-06-08T03:26:37Z Indexed on 2012/06/08 4:42 UTC
Read the original article Hit count: 523

Filed under:
|
|
|

Good Evening, and thank you for reading this post.

I am having a problem with Django after migrating the dB from SQLlite to MySQL. Initially, for the first 48hours, all ran well. But now we are experiencing high cpu about every 30 minutes. This is a production ESX4i VM host, with 2 x 2.8 ghz CPUs and 12 GB ram. I have allocated 4 cpu's to this VM and 4 GB memory.

Any insight into this configuration and help with the spikes in CPU would be appreciated. IT is configured to use the prefork MPM. Outlined are the config's for the different services:

MySQL Server version: 5.1.61 Source distribution Django 1.3 mod_wsgi Apache/2.2.15

httpd.conf

Timeout 120 KeepAlive Off MaxKeepAliveRequests 400 KeepAliveTimeout 3

prefork MPM StartServers 8 MinSpareServers 8 MaxSpareServers 16 ServerLimit 40 MaxClients 40 MaxRequestsPerChild 0

worker MPM StartServers 16 MaxClients 1024 MinSpareThreads 64 MaxSpareThreads 256 ThreadsPerChild 64 MaxRequestsPerChild 10240

MySQL my.conf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid my.cnf

wsgi.conf

LoadModule wsgi_module modules/mod_wsgi.so /etc/httpd/conf.d/wsgi.conf WSGISocketPrefix /var/run/wsgi WSGIPythonEggs /var/tmp WSGIDaemonProcess SITE maximum-requests=10000 WSGIProcessGroup SITE

© Server Fault or respective owner

Related posts about mysql

Related posts about httpd