Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-8654

Extended show engine InnoDB status docs are outdated

Details

    • Bug
    • Status: On Hold
    • Medium
    • Resolution: Unresolved
    • 8.0.x
    • None
    • Documentation
    • None
    • Yes
    • Yes

    Description

      https://docs.percona.com/percona-server/8.0/diagnostics/innodb_show_status.html#innodb_mem_adaptive_hash

      This references these two global variables which no longer exist in percona-server 8.0:

      innodb_mem_adaptive_hash
      innodb_mem_dictionary

      I can't pinpoint exactly when they were dropped from storage/innobase/srv/srv0srv.cc, but they're definitely gone in every 8.0 release. The related output variables in SHOW ENGINE INNODB STATUS;, section "BUFFER POOL AND MEMORY" are missing as well:

       

       

      5.7 output 8.0 output
      ----------------------
      BUFFER POOL AND MEMORY
      ----------------------
      Total large memory allocated 40240152576
      Dictionary memory allocated 598502
      Internal hash tables (constant factor + variable factor)
          Adaptive hash index 612008384     (611925568 + 82816)
          Page hash           4781416 (buffer pool 0 only)
          Dictionary cache    153579894     (152981392 + 598502)
          File system         876784     (812272 + 64512)
          Lock system         95660040     (95624824 + 35216)
          Recovery system     0     (0 + 0)
      Buffer pool size   2359008
      <snip>
      ----------------------
      BUFFER POOL AND MEMORY
      ----------------------
      Total large memory allocated 0
      Dictionary memory allocated 826691
      Buffer pool size   2359008
      <snip>

       

       

      Attachments

        Activity

          People

            patrick.birch Patrick Birch
            cswingler Chrys Swingler
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Smart Checklist