InnoDB Buffer Pool Issues

752 views
Skip to first unread message

Kenneth Kalmer

unread,
Mar 16, 2010, 5:49:32 AM3/16/10
to percona-d...@googlegroups.com
Hi everyone

My apologies if this isn't the correct platform to discuss this issue,
but I'm at a dead end.

Since upgrading to MySQL 5.0.90 on Gentoo, with the Percona patches
included, it seems my innodb_buffer_pool_size settings are being
ignored.

I've created a gist with the output from SHOW ENGINE INNODB STATUS
and SHOW VARIABLES LIKE '%innodb%', as well as a snippet from the
mysqld.err log -> http://gist.github.com/333794

Just like Jerry (a commenter on
http://www.percona.com/docs/wiki/release:5086-b19-changelog) I'm not
getting any memory allocated to the InnoDB buffer pools. Cacti graphs
verify that the buffer pool activity has zero-ed, and the free memory
of the host is not changing as the buffer pool size is changed. I also
have a 'The InnoDB memory heap is disabled' in the error log, which is
new since the upgrade.

All and all it looks like the setting is ignored and I don't have much
to go with.

Any advice would be appreciated.

Best

--
Kenneth Kalmer
kenneth...@gmail.com
http://opensourcery.co.za
@kennethkalmer

Vadim Tkachenko

unread,
Mar 16, 2010, 11:17:47 AM3/16/10
to percona-d...@googlegroups.com
Kenneth,

Total memory allocated 0; in additional pool allocated 0
...
Buffer pool size 8192
Buffer pool size, bytes 134217728

In fact your buffer pool is not zero.

What is zero is additional memory pool, and it is OK, as InnoDB-pluing
by default uses OS memory, not internal pool, that's why it is 0.

> --
> You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to percona-discuss...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/percona-discussion?hl=en.
>
>

--
Vadim Tkachenko, CTO, Percona Inc.
Phone +1-888-401-3403, Skype: vadimtk153
Schedule meeting: http://tungle.me/VadimTkachenko

Reply all
Reply to author
Forward
0 new messages