Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Cannot Reproduce
-
10.2.6
-
None
-
Ubuntu 16.04 packages from mariadb repository
Description
In mariadb 10.1.23 running following command did reclaim unused space (defragment by rebuild) in ibd file (one ibd per table), in 10.2.6 it does not.
ALTER TABLE `text` ENGINE = InnoDB;
10.1.23:
meme@fook:~$ sudo ls -hal /var/lib/mysql/wikidb/ |grep text
|
-rw-rw---- 1 mysql mysql 998 Jun 28 11:22 text.frm
|
-rw-rw---- 1 mysql mysql 15M Jun 28 11:22 text.ibd
|
10.2.6:
meme@lunkwill:~$ sudo ls -hal /var/lib/mysql/wikidb/ |grep text
|
-rw-rw---- 1 mysql mysql 998 Jun 28 11:23 text.frm
|
-rw-rw---- 1 mysql mysql 21M Jun 28 11:23 text.ibd
|