[DOC] on estimating dictionary size
Bug #1267810 reported by
Aurimas Mikalauskas
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Undecided
|
Unassigned | ||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | ||
5.5 |
Fix Released
|
Medium
|
Hrvoje Matijakovic | ||
5.6 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
[In:Percona Server Documentation]
The following document:
http://
Suggests that we can use "Total memory allocated" (by subtracting buffer pool size from it) from ENGINE INNODB STATUS to understand how large is the dictionary size, however in one of the articles:
http://
Peter suggests that:
Dictionary Cache is not included in “Total Memory Allocated” in SHOW INNODB STATUS any more, as that allocations were moved to use malloc() and so Innodb does not track them any more.
Related branches
lp:~hrvojem/percona-server/bug1267810-5.5
- Laurynas Biveinis (community): Approve
-
Diff: 3504 lines (+22/-3335)11 files modified.bzrignore (+1/-0)
doc/source/management/enforce_engine.rst (+4/-0)
doc/source/management/innodb_dict_size_limit.rst (+17/-22)
doc/source/percona-theme/layout.html (+0/-384)
doc/source/percona-theme/searchbox.html (+0/-22)
doc/source/percona-theme/static/default.css_t (+0/-433)
doc/source/percona-theme/static/jquery.min.js (+0/-154)
doc/source/percona-theme/static/percona.com.css (+0/-1868)
doc/source/percona-theme/static/percona.com.js (+0/-269)
doc/source/percona-theme/static/sidebar.js (+0/-151)
doc/source/percona-theme/theme.conf (+0/-32)
To post a comment you must log in.
Moreover, I see that dictionary memory is reported separately in recent upstream MySQL (5.5.35 in this case):
... ------- ------- - ------- ------- -
-------
BUFFER POOL AND MEMORY
-------
Total memory allocated 74055680; in additional pool allocated 0
Dictionary memory allocated 52909
Buffer pool size 4416
...
So, this entire section on our page needs clarifications and may be redundant.