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

When performance schema is disabled, autosized parameters show 18446744073709551615 instead of -1

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 10.0.4
        • Component/s: None
        • Labels:
          None

          Description

          Value of an autosized parameter in performance schema is supposed to be -1 when the performance schema is disabled. It works in MySQL 5.6.10, but not in 10.0 tree:

          MySQL [test]> select @@performance_schema_max_table_instances;
+------------------------------------------+
| @@performance_schema_max_table_instances |
+------------------------------------------+
|                                       -1 |
+------------------------------------------+
1 row in set (0.00 sec)

MySQL [test]> select @@performance_schema;
+----------------------+
| @@performance_schema |
+----------------------+
|                    0 |
+----------------------+
1 row in set (0.00 sec)

MySQL [test]> select @@version;
+-----------+
| @@version |
+-----------+
| 5.6.10    |
+-----------+
1 row in set (0.00 sec)

          MariaDB [test]> select @@performance_schema_max_table_instances;
+------------------------------------------+
| @@performance_schema_max_table_instances |
+------------------------------------------+
|                     18446744073709551615 |
+------------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> select @@performance_schema;
+----------------------+
| @@performance_schema |
+----------------------+
|                    0 |
+----------------------+
1 row in set (0.00 sec)

MariaDB [test]> select @@version;
+----------------------+
| @@version            |
+----------------------+
| 10.0.3-MariaDB-debug |
+----------------------+
1 row in set (0.00 sec)

            Gliffy Diagrams

              Attachments

                Issue Links

                blocks

                Bug - A problem which impairs or prevents the functions of the product. MDEV-4873 Tasks before 10.0.4-release

                • Major - Major loss of function.
                • Closed

                  Activity

                  Hide
                  Permalink
                  timour Timour Katchaounov added a comment -

                  Got patch from Serg in the end.

                  Show
                  timour Timour Katchaounov added a comment - Got patch from Serg in the end.

                    People

                    • Assignee:
                      timour Timour Katchaounov
                      Reporter:
                      elenst Elena Stepanova
                    • 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 - 0 minutes
                        0m
                        Logged:
                        Time Spent - 2 hours
                        2h