PROTECTED]>
Sent: Tuesday, April 27, 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&
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 quer