Your idea for a list is pretty good, but the actual ratio of SELECT
vs. UPDATE/INSERTs is skewed far too highly towards UPDATE/INSERTs
which in practice are infrequent. I'd say a total of 10% of the load
due to UPDATE/INSERT statements would be more representative.
Likewise the sitewide search frequency would be far lower in practice
than you suggest. Experience with photo.net shows that it's hard to
get people to use the search feature rather than ask duplicate
questions, for instance.
