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

Querying the Sys Schema innodb_buffer_stats_by_schema view returns warnings

    XMLWordPrintable

Details

    • Not for Release Notes
    • Q3/2026 Server Maintenance

    Description

      On a clean install (tested on 10.6.18), querying the Sys Schema innodb_buffer_stats_by_schema view returns two warnings. Querying x$innodb_buffer_stats_by_schema doesn't return any warnings.

      SELECT * FROM sys.innodb_buffer_stats_by_schema\G
      *************************** 1. row ***************************
      object_schema: InnoDB System
          allocated: 160.00 KiB
               data: 4.77 KiB
              pages: 10
       pages_hashed: 10
          pages_old: 10
        rows_cached: 16
      *************************** 2. row ***************************
      object_schema: mysql
          allocated: 48.00 KiB
               data: 457 bytes
              pages: 3
       pages_hashed: 3
          pages_old: 3
        rows_cached: 5
      2 rows in set, 2 warnings (0.036 sec)
       
      SHOW WARNINGS;
      +---------+------+------------------------------------------+
      | Level   | Code | Message                                  |
      +---------+------+------------------------------------------+
      | Warning | 1292 | Truncated incorrect DECIMAL value: 'YES' |
      | Warning | 1292 | Truncated incorrect DECIMAL value: 'YES' |
      +---------+------+------------------------------------------+
      

      Attachments

        Issue Links

          Activity

            People

              wlad Vladislav Vaintroub
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 3h
                  3h

                  Git Integration

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