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
, 2004 1:37 PM
Subject: Re: MySQL Memory Structure
Lou,
use show variables; to display this info. You can also
narrow it down by using show varibles like 'innodb%';
to see only variables that start with innodb.
The various pools are in there. See the mysql site for
the exhaustive list