locked mysql queries ...
 

my website is consistently slow, mysql cpu does not turn on the Rise


my vB Verison: vBulletin 3.7.4

root mysql screen

Pid Owner Priority CPU % Memory % Command
26511 (Trace) (Kill) mysql 0

3.8

6.1 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.duslerforum.org.err --open-files-limit=2464 --pid-file=/var/lib/mysql/server.duslerforum.org.pid


One of the queries, for example;

| 828 | dusler_dusl | localhost | dusler_dusl | Query | 379 | Locked | SELECT *
FROM session
WHERE userid = 0
AND host = '96.47.225.170'
AND idhash = 'd0 |



http://img843.imageshack.us/img843/9004/qjfd.png

How many rows are in your session table on average?