Skip to content
  • Vasil Dimov's avatar
    22ec81a4
    Fix Bug#14550145 INNODB I_S TABLES DO NOT DECODE IDENTIFIERS · 22ec81a4
    Vasil Dimov authored
    The columns in I_S tables where we display identifiers are:
    
    innodb_buffer_page
      table_name
      index_name
    innodb_buffer_page_lru
      table_name
      index_name
    innodb_cmp_per_index
      database_name
      table_name
      index_name
    innodb_cmp_per_index_reset
      database_name
      table_name
      index_name
    innodb_locks
      lock_table
      lock_index
    
    The only table that need not be addressed is innodb_locks - where
    identifiers are correctly decoded. All other tables were implemented after
    innodb_locks and should have imitated the same behavior.
    
    In innodb_buffer_page and innodb_buffer_page_lru we have a single
    column (called table_name) where we print the database and the table name,
    concatenated by ".". This is the same as in innodb_locks and should follow
    the same convention for decoding.
    
    In innodb_cmp_per_index and innodb_cmp_per_index_reset we have separate
    columns for database name and table name, thus we do not concatenate with
    a dot and do not quote.
    
    innodb_sys* I_S tables would better be left as they are, since they are
    supposed to display the contents of InnoDB's SYS_* tables verbatim.
    
    Approved by:	Jimmy (rb:1569)
    22ec81a4
    Fix Bug#14550145 INNODB I_S TABLES DO NOT DECODE IDENTIFIERS
    Vasil Dimov authored
    The columns in I_S tables where we display identifiers are:
    
    innodb_buffer_page
      table_name
      index_name
    innodb_buffer_page_lru
      table_name
      index_name
    innodb_cmp_per_index
      database_name
      table_name
      index_name
    innodb_cmp_per_index_reset
      database_name
      table_name
      index_name
    innodb_locks
      lock_table
      lock_index
    
    The only table that need not be addressed is innodb_locks - where
    identifiers are correctly decoded. All other tables were implemented after
    innodb_locks and should have imitated the same behavior.
    
    In innodb_buffer_page and innodb_buffer_page_lru we have a single
    column (called table_name) where we print the database and the table name,
    concatenated by ".". This is the same as in innodb_locks and should follow
    the same convention for decoding.
    
    In innodb_cmp_per_index and innodb_cmp_per_index_reset we have separate
    columns for database name and table name, thus we do not concatenate with
    a dot and do not quote.
    
    innodb_sys* I_S tables would better be left as they are, since they are
    supposed to display the contents of InnoDB's SYS_* tables verbatim.
    
    Approved by:	Jimmy (rb:1569)
Loading