Ok here is some info that might help. I went into phpMyAdmin for my forums and did some reading.
Here are some values that were highlighted in RED which im assuming is bad:
VALUE: 76 k
Description: The number of queries that have taken more than long_query_time seconds.
VALUE: 129 k
Description: The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don’t use keys properly.
VALUE: 15 M
Description: The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
VALUE: 1 k
Description: The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
now these last two below caught my eye most of all…
Description: The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
Description: The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.
I have no idea what any of this means, could this be the problem? thanks a lot!
ALSO: When I tried to do a FLUSH, I got this error "#1227 - Access denied; you need the RELOAD privilege for this operation " why cant I flush?