Here is an example of where I get frustrated. Maybe I'm just not finding it in the docs.
When I execute the "show innodb status\G" I get: ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 17490512; in additional pool allocated 924288 Buffer pool size 512 Free buffers 457 Database pages 54 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 54, created 0, written 14 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Yet, when I add up the InnoDB variables from SHOW VARIABLES, I get the following: innodb_additional_mem_pool_size | 1048576 innodb_buffer_pool_size | 8388608 innodb_log_buffer_size | 1048576 innodb_log_file_size | 5242880 If I add them up, I get 15,728,640. I'm trying to figure out the difference between that number and the 17,490,512 shown by the SHOW INNODB STATUS command???? This is one example of my frustration trying to understand the memory constructs and how they are interrelated. Thanks, Lou O. ----- Original Message ----- To: "Lou Olsten" <[EMAIL 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". > > The various pools are in there. See the mysql site for > the exhaustive list of server variables. > > Hope this helps, > > > > > --- Lou Olsten <[EMAIL PROTECTED]> wrote: > > 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. > > > > > > __________________________________ > Do you Yahoo!? > Win a $20,000 Career Makeover at Yahoo! HotJobs > http://hotjobs.sweepstakes.yahoo.com/careermakeover -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
