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

    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

        Activity

          People

            wlad Vladislav Vaintroub
            greenman Ian Gilfillan
            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.