Thanks for the help Fajar, We wish to fix this in house so don't want to pay for a dba BUT we are not getting much closer to the issue though....
I have found that a lot of the tables are actually indexed I just didn't know where to look. > PHPmyadmin runtime info states that Select_full_join is 49 and > that if this value is not 0, you should carefully check the indexes of > your tables. >Good suggestion. Did you do it? I had a look at PHPmyadmin runtime variables and it shows this in red highlight , as the tables are actually indexed I'm not sure why this is the case... Also in Red are these, I have adjusted some of the values but no joy: Innodb_buffer_pool_reads Opened_Tables Table_locks_waited Handler_read_rnd Handler_read_rnd_next - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
