Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36917

Aria memory instruments in performance schema

    XMLWordPrintable

Details

    Description

      There is a bunch of MyISAM memory instruments in the performance schema (apparently as inherited from MySQL), but nothing for Aria. Given that we have Aria for system tables and temporary tables, and encourage users to use it rather than MyISAM, I suppose it would be reasonable to have instrumentation for it.

      main 4b79d7b8ee557d53a859aedec839b8673585b514

      MariaDB [(none)]> select * from performance_schema.setup_instruments where name like 'memory/myisam/%' or name like 'memory/aria%' or name like 'memory/maria%';
      +-------------------------------------------+---------+-------+
      | NAME                                      | ENABLED | TIMED |
      +-------------------------------------------+---------+-------+
      | memory/myisam/MYISAM_SHARE                | YES     | NO    |
      | memory/myisam/MI_INFO                     | YES     | NO    |
      | memory/myisam/MI_INFO::ft1_to_ft2         | YES     | NO    |
      | memory/myisam/MI_INFO::bulk_insert        | YES     | NO    |
      | memory/myisam/record_buffer               | YES     | NO    |
      | memory/myisam/FTB                         | YES     | NO    |
      | memory/myisam/FT_INFO                     | YES     | NO    |
      | memory/myisam/FTPARSER_PARAM              | YES     | NO    |
      | memory/myisam/ft_memroot                  | YES     | NO    |
      | memory/myisam/ft_stopwords                | YES     | NO    |
      | memory/myisam/MI_SORT_PARAM               | YES     | NO    |
      | memory/myisam/MI_SORT_PARAM::wordroot     | YES     | NO    |
      | memory/myisam/SORT_FT_BUF                 | YES     | NO    |
      | memory/myisam/SORT_KEY_BLOCKS             | YES     | NO    |
      | memory/myisam/filecopy                    | YES     | NO    |
      | memory/myisam/SORT_INFO::buffer           | YES     | NO    |
      | memory/myisam/MI_DECODE_TREE              | YES     | NO    |
      | memory/myisam/MYISAM_SHARE::decode_tables | YES     | NO    |
      | memory/myisam/preload_buffer              | YES     | NO    |
      | memory/myisam/stPageList::pages           | YES     | NO    |
      | memory/myisam/keycache_thread_var         | YES     | NO    |
      +-------------------------------------------+---------+-------+
      21 rows in set (0.004 sec)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.