Thanks! I will research the documentation on how each of those components in the query are defined and used by the system. That will definitely help me start to break down my research into the different areas of memory consumption.
Just as a heads-up, I’m getting the following error:
ERROR 1193 (HY000): Unknown system variable ‘query_cache_size’
Quick googling seems to be that query_cache_size was removed in mysql 8. I’ll post back if I come up with a solution so that others might have it if they ever stumble on this thread.
Thanks!