Pretty new to drupal so no idea about most of it but there's this query which is really pulling the site down alot. It's a using version 5.19 of vbdrupal and wondering if anyone has suggestions ? Any help is appreciated :)
mysqlsla -lt slow /home/mysql/mysql-slow-queries.log --TOP 1 -x tschema,tcount -ex
Report for slow logs: /home/mysql/mysql-slow-queries.log
119 queries total, 42 unique
Sorted by 't_sum'
Grand Totals: Time 111 s, Lock 0 s, Rows sent 4.38k, Rows Examined 333.99M
______________________________________________________________________ 001 ___
Count : 10 (8.40%)
Time : 109.931309 s total, 10.993131 s avg, 10.820919 s to 11.078777 s max (99.23%)
95% of Time : 98.852532 s total, 10.983615 s avg, 10.820919 s to 11.065214 s max
Lock Time (s) : 1.42 ms total, 142 µs avg, 110 µs to 231 µs max (11.93%)
95% of Lock : 1.189 ms total, 132 µs avg, 110 µs to 201 µs max
Rows sent : 9 avg, 5 to 9 max (1.96%)
Rows examined : 33.32M avg, 33.32M to 33.33M max (99.77%)
Database : vb364
Users :
dbusername@dbserverip : 100.00% (10) of query, 99.16% (118) of all users
Table:#rows : vb3_drupal_download_counter:8.55k vb3_drupal_node:28.54k vb3_drupal_votingapi_vote:2.43k vb3_drupal_files:6.31k vb3_drupal_node_revisions:30.78k
Table schemas :
CREATE TABLE `vb3_drupal_download_counter` (
