I'm trying to get a handle on the entire memory structure used by MySQL. I'd like to be able to see the total memory used by the entire MySQL instance, and then a breakdown of what is going on within that aggregate allocation. For example, I'd like to see how much memory is devoted to the query cache, innodb cache, actual MySQL process, along with the other various caches that are allocated. I'm having difficulty finding an exhaustive list so I can start tracking down which memory pools are being allocated and used by which processes.
Thanks Lou O.