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 |