I've upgrade to Moodle 1.8.3 Latest. Before this, Moodle just seemed to idle and not do much with the processor. Now Mysql is always using at least 100 percent of the processor and sometimes as much as 388 percent. The server is a dual processor 3.0Ghz machine with hyperthreading and load was never an issue before the upgrade. I installed Innotop and noticed locking going on. I'm not sure if this happend before but the site seems to be unusable now when locks are happening.  Below are examples of some of the locks that I've been seeing.

moodle  Query    3233  moodlead  localhost      moodle  00:02  SELECT u.id, cu.chatid, u.firstname, u.lastname FROM mdl_chat_u
moodle  Query    3236  moodlead  localhost      moodle  00:02  SELECT p.*, f.type AS forumtype, d.forum, d.groupid, u.firstnam
moodle  Query    3339  moodlead  localhost      moodle  00:01  SELECT u.id, u.confirmed, u.username, u.firstname, u.lastname,
moodle  Query    3203  moodlead  localhost      moodle  00:00  SELECT l.time, l.url, u.firstname, u.lastname, a.workshopid, a.
moodle  Query    3253  moodlead  localhost      moodle  00:00  SELECT u.id, cu.chatid, u.firstname, u.lastname FROM mdl_chat_u
moodle  Query    3342  moodlead  localhost      moodle  00:00  UPDATE mdl_user SET lastip=' x.x.x.x', lastaccess

_________

I've  been implementing some tuning changes with tuning-primer.sh and have put in the suggested settings according to this link: http://docs.moodle.org/en/Performance#MySQL_performance

I'm really stuck on what to do next. I'd appreciate any help.

Hurstel