Re: MySQL Memory Structure

2004-04-27 Thread Lou Olsten
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&

MySQL Memory Structure

2004-04-27 Thread Lou Olsten
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