7 Jun
2011
7 Jun
'11
3:38 a.m.
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