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

'show table status' does not immediately show tokudb tables

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

            prohaska7 Rich Prohaska created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            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.
            {noformat}
            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
            {noformat}
            now, data/test/t.frm exists.
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.10 [ 14500 ]
            serg Sergei Golubchik made changes -
            Affects Version/s 10.0.9 [ 14400 ]
            Affects Version/s 10.0.10 [ 14500 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 37102 ] MariaDB v2 [ 42966 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 42966 ] MariaDB v3 [ 62657 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 62657 ] MariaDB v4 [ 147691 ]

            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.