Hi,

I've been doing some analysis of the mysql database to improve performance.

Found a few issues that the MySQl manual says should be looked into.

Flushed the status variables and in about 5 mins had the following:

Code:
| Created_tmp_disk_tables | 9     |
| Created_tmp_files       | 0     |
| Created_tmp_tables      | 29     |
OK - the first indicates that it's wring temp tables to disk. This will be slow so I can bump up the cached table size as I've loads of RAM.

Next though:

Code:
| Select_full_join       | 12    |
| Handler_read_rnd_next | 1017847 |
This indicates - according to the manual - that there are queries/joins on tables that are not properly using indexes.

Now, I'm more than willing to create test indexes to see how things respond but does anyone have any suggestions on how to track what these joins and queries are so I can deduce the indexes required?

Thanks