Quote:
Originally Posted by freecartoonporn
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
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
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 ...