Report dictionary memory usage in SHOW INNODB STATUS and/or SHOW STATUS

[Baron Schwartz]

The patch

http://www.percona.com/mysql/5.0.77-b13/patches/innodb_dict_size_limit.patch

would be even better if it showed how much memory the dictionary consumes.

[Percona (percona-team)]

We have that in

http://www.percona.com/docs/wiki/patches:innodb_show_hashed_memory

  ----------------------
  BUFFER POOL AND MEMORY
  ----------------------
  Total memory allocated 328830416; in additional pool allocated 2117120
+ Internal hash tables (constant factor + variable factor)
+ Adaptive hash index 4839388 (4425628 + 413760)
+ Page hash 138716
+ Dictionary cache 3383508 (3320220 + 63288)

Do you need some more info ?

[Baron Schwartz (baron-xaprb)]

That's fine.

On Tue, Feb 24, 2009 at 1:01 PM, Percona <email address hidden> wrote:
> We have that in
>
> http://www.percona.com/docs/wiki/patches:innodb_show_hashed_memory
>
>  ----------------------
>  BUFFER POOL AND MEMORY
>  ----------------------
>  Total memory allocated 328830416; in additional pool allocated 2117120
> + Internal hash tables (constant factor + variable factor)
> +     Adaptive hash index 4839388         (4425628 + 413760)
> +     Page hash           138716
> +     Dictionary cache    3383508         (3320220 + 63288)
>
>
> Do you need some more info ?
>
> --
> Report dictionary memory usage in SHOW INNODB STATUS and/or SHOW STATUS
> https://bugs.launchpad.net/bugs/333817
> You received this bug notification because you are a direct subscriber
> of the bug.
>

--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html