PROBELM - forum ultraslow

[KHALIK]

My forum/site was upgraded to another business package. It has now become extremely slow after the upgrade. I am blaming the host as the forum was fine before it was relocated. Even now when I am updating the usernames, under counters within admincp, it is very slow, previously lightning fast.

http://www.fragmasters.co.uk/forum/

This is the reply that was given.

Dear Customer,

Please pay attention at the work of your forum with the MySQL database. Your script is trying to copy table and lock it simultaneously. In case of many queries, some mysql process may be not droped correctly, therefore your database status may be "locked" and no new queries could work with it further. Such situation can cause dramatical slowdown.


################################################## #######
[root@XXXXXX ~]# mysqladmin pr| grep fragmast

| 285397 | fragmast_frag | localhost | fragmast_kh | Query | 11 | Copying to tmp table | SELECT COUNT(post.postid) AS posts, post.userid, post.dateline, user.usergroupid, user.displaygroupi |
| 285399 | fragmast_frag | localhost | fragmast_kh | Query | 11 | Locked | UPDATE user
SET lastactivity = 1228091834
WHERE userid = 2679 |

I am cluess, what does this mean and what can I DO to solve this issue?



Advice welcomed.