this finally need to be resolved
 

hi, after weeks of puting up with a slow forum and doing everything vbulletin said to do, even moving to a VPS fast ass server, still my forum is slow.
to many database query to 'copy to tmp table. i have optimized my database and everything under the sun.

please would anyone know if a hack is causing this please?

==========================
root@host [/home/jay]# mysqladmin proc stat
+------+--------------+-----------+------------------+-------
| Id | User | Host | db | Command | Time | State | Info |
+------+--------------+-----------+------------------+--------
| 7398 | jay_vbull | localhost | jay_vbulletin | Query | 7 | Locked | UPDATE user
SET posts = 17839
WHERE userid = 310 |
| 7430 | jay_vbull | localhost | jay_vbulletin | Query | 7 | Copying to tmp table | SELECT c.*, g.gcat, g.gid, g.gname,u.username,u.usergroupid,cat.password,COUN T(champ_mid) AS total
|
| 7431 | root | localhost | | Query | 0 | | show processlist |
+------+--------------+-----------+------------------+---------+------+----------------------+-
Uptime: 43918 Threads: 3 Questions: 185370 Slow queries: 47 Opens: 11138 Flush tables: 1 Open tables: 64 Queries per second avg: 4.221
==========================

thanks.