| Bug #98138 | 5.7.28 blob table can not free space correctly | ||
|---|---|---|---|
| Submitted: | 7 Jan 2020 3:00 | Modified: | 7 Jan 2020 8:16 |
| Reporter: | lcrash gou | Email Updates: | |
| Status: | Unsupported | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | percona 5.7.28 | OS: | Red Hat (6.8) |
| Assigned to: | CPU Architecture: | x86 | |
| Tags: | blob not free space | ||
[7 Jan 2020 8:16]
MySQL Verification Team
Thank you for the bug report. Percona server isn't supported in this bug system, please check with MySQL Oracle server binary and report again if the issue exists too.
Description: I have a 5.6.29 master,and two slave(one is 5.6.29 and one is upgrade to 5.7.28) when one slave upgrade to 5.7, the log table(contains blob) in the instance can not free space correctly(There is a job, delete a day ago's data every day), but 5.6's master and slave is OK! ╰─># ll -lrth log.ibd -rw-rw---- 1 mysql mysql 7.1G Jan 7 02:55 log.ibd [root@host-5.7-slave]# ll -lrth log.ibd -rw-r----- 1 mysql mysql 13G Jan 7 02:55 log.ibd How to repeat: one master 5.6.29 one slave 5.7.28 Table sturcture: mysql> show create table log\G *************************** 1. row *************************** Table: log Create Table: CREATE TABLE `log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMEN, `task_id` int(11) unsigned NOT NULL DEFAULT '0' , `create_time` int(11) unsigned NOT NULL DEFAULT '0', `input` blob, `out` blob, PRIMARY KEY (`id`), KEY `idx_task_id` (`task_id`), KEY `idx_create_time` (`create_time`) ) ENGINE=InnoDB AUTO_INCREMENT=32921197 DEFAULT CHARSET=utf8mb4