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

PS 8.0 docs for compressed columns outdated for I_S tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.13-3
    • Fix Version/s: 8.0.15-6
    • Component/s: Documentation
    • Labels:
      None

      Description

      It seems that those two I_S tables don't exists any more:
      https://www.percona.com/doc/percona-server/8.0/flexibility/compressed_columns.html#information-schema-tables

      I see two other:

      8.0.13>select * from information_schema.compression_dictionary;
      +--------------+-----------+-----------------+
      | DICT_VERSION | DICT_NAME | DICT_DATA       |
      +--------------+-----------+-----------------+
      |            1 | numbers   | onetwothreefour |
      +--------------+-----------+-----------------+
      1 row in set (0.00 sec)
      
      8.0.13>select * from information_schema.compression_dictionary_tables;
      +--------------+------------+-------------+-----------+
      | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | DICT_NAME |
      +--------------+------------+-------------+-----------+
      | test         | t1         | b           | numbers   |
      +--------------+------------+-------------+-----------+
      1 row in set (0.00 sec)
      
      8.0.13>show create table compression_dictionary\G;
      *************************** 1. row ***************************
                      View: COMPRESSION_DICTIONARY
               Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`mysql.infoschema`@`localhost` SQL SECURITY DEFINER VIEW `COMPRESSION_DICTIONARY` AS select `dict`.`version` AS `DICT_VERSION`,`dict`.`name` AS `DICT_NAME`,`dict`.`data` AS `DICT_DATA` from `mysql`.`compression_dictionary` `dict`
      character_set_client: utf8mb4
      collation_connection: utf8mb4_general_ci
      1 row in set (0.00 sec)
      
      8.0.13>show create table compression_dictionary_tables\G;
      *************************** 1. row ***************************
                      View: COMPRESSION_DICTIONARY_TABLES
               Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`mysql.infoschema`@`localhost` SQL SECURITY DEFINER VIEW `COMPRESSION_DICTIONARY_TABLES` AS select `sch`.`name` AS `TABLE_SCHEMA`,`tbl`.`name` AS `TABLE_NAME`,`col`.`name` AS `COLUMN_NAME`,`dict`.`name` AS `DICT_NAME` from ((((`mysql`.`compression_dictionary_cols` `cdc` join `mysql`.`tables` `tbl` on((`cdc`.`table_id` = `tbl`.`id`))) join `mysql`.`columns` `col` on(((`col`.`table_id` = `cdc`.`table_id`) and (`col`.`id` = `cdc`.`column_id`)))) join `mysql`.`schemata` `sch` on((`tbl`.`schema_id` = `sch`.`id`))) join `mysql`.`compression_dictionary` `dict` on((`dict`.`id` = `cdc`.`dict_id`)))
      character_set_client: utf8mb4
      collation_connection: utf8mb4_general_ci
      1 row in set (0.01 sec)
      

      The ticket for re-implementing compressed columns into 8.0 is here so you can maybe find more info there: PS-4805

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                borys.belinsky Borys Belinsky (Inactive)
                Reporter:
                tomislav.plavcic@percona.com Tomislav Plavcic
                Votes:
                0 Vote for this issue
                Watchers:
                1 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 hours, 57 minutes
                    2h 57m