Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.9
-
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
- is duplicated by
-
MDEV-5839 TokuDB tables not properly cleaned on DROP DATABASE
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Assignee | Sergei Golubchik [ serg ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
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. |
Fix Version/s | 10.0.10 [ 14500 ] |
Affects Version/s | 10.0.9 [ 14400 ] | |
Affects Version/s | 10.0.10 [ 14500 ] |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Workflow | defaullt [ 37102 ] | MariaDB v2 [ 42966 ] |
Workflow | MariaDB v2 [ 42966 ] | MariaDB v3 [ 62657 ] |
Workflow | MariaDB v3 [ 62657 ] | MariaDB v4 [ 147691 ] |