[Clipart] Fwd: [support.osuosl.org #19840] URGENT: openclipart.org high DB usage

[Jon Phillips]

FWIW, the truth is that we have a huge site on one small
server...working to resolve all issues

jon


---------- Forwarded message ----------
From: Lance Albertson via RT <support at osuosl.org>
Date: Mon, Nov 7, 2011 at 10:49 PM
Subject: [support.osuosl.org #19840] URGENT: openclipart.org high DB usage
To: bradphillips at fabricatorz.com, christopher at fabricatorz.com,
dave at lab6.com, jon at fabricatorz.com


On Mon Nov 07 17:26:06 2011, ramereth wrote:
> Folks,
>
> We have a several performance issue happening with the database server
> you're currently using for openclipart.org. Its consuming nearly 99%
> of the cpu time on our database server and slowing down other
> projects' sites. Is there anyway we can have your site use memcached
> or fix some of the queries it does? Most of the queries I see seem to
> be related to user sessions and stuff related to uploads.
>
> Please reply ASAP so we can resolve this issue otherwise I will need
> to come up with our own solutions to this.

This became a critical issue and was bringing all sites using db1 down.
I have put openclipart.org on a maintenance page redirect until someone
can look into fixing the performance issues with the site.

--
Lance Albertson
Systems Administrator / Architect
OSU Open Source Lab




-- 
Jon Phillips ✳ http://fabricatorz.com ✳ skype: kidproto ✳ irc: rejon
+1.415.830.3884 (global) ✳ +86-187-1003-9974 (beijing)