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.