September 30, 2014

What is stored InnoDB buffer pool

Ever wonder what is stored in InnoDB buffer pool at the moment ?

It is not so hard actually – we made a short patch for MySQL 5.0 which show innodb buffer pool content

The binaries, RPMS (RedHat/Centos) and full source code also available to download

P.S. There is Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and main idea was taken from there.

About Vadim Tkachenko

Vadim leads Percona's development group, which produces Percona Clould Tools, the Percona Server, Percona XraDB Cluster and Percona XtraBackup. He is an expert in solid-state storage, and has helped many hardware and software providers succeed in the MySQL market.

Comments

  1. angel says:

    je vous remercie de partager, très gentil de votre part

  2. This is great! Can we expect to see this coming out in the Percona 5.1 binaries as well?

  3. Nils says:

    Is this patch also for the 5.0.68 Percona release available?

  4. Vadim says:

    Gregory:

    I think in 5.1 we will include Jeremey Cole’s patch

  5. Vadim says:

    Nils,

    It is only for 5.0.67, will release for 5.0.68 later

  6. Isotopp says:

    I am looking for a similar tool for the ibdata and ibd files – somethings that dumps page numbers and for each page tells me what the page is and does.

  7. Vadim says:

    Isotopp,

    It is on our todo, will implement it when we can :)

  8. Ponns says:

    I am getting “404 Page Not Found” error when trying to download the batch. Please help me to download the same.

Speak Your Mind

*