I was looking at the report for my mysql databases usage. I have two of them. One has an installation of SMF. The other is for my mediawiki.
In the last week, the SMF database has ratios ranging from 0.57 to 0.63, and conueries ranging from 0.41 to 0.69.
The mediawiki has ratios from 2.17 to 5.23 and conueries from 0.23 to 0.63. The ranges for both have been pretty regular all the way back to the beginning of the report.
What does this mean? I read the wiki on the mysql usage, but I’m still unclear on what exactly this means. Just that the higher the ratio the better? I’ve been looking into ways to optimize my forum and wiki recently. I have a small community on both, ranging from around 20-40 members and they are pretty active (more so on the forum) with an average of 60 new posts a day.
Are those ratios something I should and can improve?