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

Add variable Innodb_checkpoint_max_age

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.20-11
    • Fix Version/s: 8.0.21-12
    • Component/s: None
    • Labels:
    • Needs Review:
      Yes

      Description

      Percona Server for 8.0 should have status variable Innodb_checkpoint_max_age according to https://www.percona.com/doc/percona-server/LATEST/diagnostics/innodb_show_status.html#Innodb_checkpoint_age But it is missed from the product:

      $ mysqlmtr -P13020
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 9
      Server version: 8.0.20-11 Percona Server (GPL), Release 11, Revision 159f0eb
      
      Copyright (c) 2009-2020 Percona LLC and/or its affiliates
      Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
      
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
      
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      
      mysql> show status like 'Innodb_checkpoint%';
      +-----------------------+-------+
      | Variable_name         | Value |
      +-----------------------+-------+
      | Innodb_checkpoint_age | 0     |
      +-----------------------+-------+
      1 row in set (0.00 sec)
      
      mysql> show status like 'Innodb_checkpoint_max_age';
      Empty set (0.00 sec)
      

      Suggested fix: add this variable back

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marcelo.altmann Marcelo Altmann
              Reporter:
              sveta.smirnova Sveta Smirnova
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 days, 15 minutes
                  2d 15m

                    Smart Checklist