View Single Post
Old 08-30-2012, 02:34 AM  
StariaDaniel
Confirmed User
 
Join Date: Oct 2007
Location: Netherlands
Posts: 415
Quote:
Originally Posted by freecartoonporn View Post
on icq..
Oh ok, I'm not using ICQ regularly, but I'm online now and replied to your message.

Quote:
Originally Posted by Nookster View Post
Definitely looks like a script issue, since a properly written script should DEFINITELY not eat that many resources so quickly. I wouldn't be looking for a DBA, I'd look for a programmer to re-write your scripts.
Quote:
Originally Posted by freecartoonporn View Post
i have already contacted the coder and he says , its not the script issue.
Most likely not the script itself, but queries it's launching. Mechbunny is used by a lot of bigger sites and konrad seems to be one of the good programmers - so I'd assume that's properly optimized. Can't speak for the other one as I've never heard of it before.

Anyway, the my.cnf needs to be properly configured too, but i find it kind of risky to make a suggestion for it without knowing details about the database(s) and server hardware. There's definitely no solution that fits every problem ...
StariaDaniel is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote