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

'show table status' does not immediately show tokudb tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.9
    • 10.0.10
    • None
    • None
    • centos 6.2 debug build of mariadb 10.0.9

    Description

      mysql> install plugin tokudb soname 'ha_tokudb.so';
      Query OK, 0 rows affected (0.07 sec)
       
      mysql> create table t (id int primary key) engine=tokudb;
      Query OK, 0 rows affected (0.11 sec)
       
      mysql> show table status;
      Empty set (0.00 sec)
       
      and no data/test/t.frm file
       
      mysql> show create table t;
      +-------+---------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                            |
      +-------+---------------------------------------------------------------------------------------------------------+
      | t     | CREATE TABLE `t` (
        `id` int(11) NOT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=TokuDB DEFAULT CHARSET=latin1 |
      +-------+---------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
       
      mysql> show table status;
      +------+--------+---------+------------+------+----------------+-------------+---------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
      | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length     | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation         | Checksum | Create_options | Comment |
      +------+--------+---------+------------+------+----------------+-------------+---------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
      | t    | TokuDB |      10 | Fixed      |    1 |              0 |           0 | 9223372036854775807 |            0 |     12288 |           NULL | 2014-03-24 16:36:21 | 2014-03-24 16:36:22 | NULL       | latin1_swedish_ci |     NULL

      now, data/test/t.frm exists.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              prohaska7 Rich Prohaska
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.