InnoDB Buffer Pool Issues
Kenneth Kalmer
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
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