We have planned for archiving the data to improve the DB performance and to reclaim the space. We were evaluating Compression in InnoDB and TokuDB. To find out the best compression method. We started benchmarking the compression ratio between InnoDB and TokuDB.
Everything goes well for some time, but after a few hours got an error message that can’t able to insert the data into the TokuDB table due to storage being full. It is so strange and the host has enough free space.
Table structure:-
mysql> show create table mydbops.tokudb\G *************************** 1. row *************************** Table: tokudb Create Table: CREATE TABLE `tokudb` ( `ID` int DEFAULT NULL, `Name` longtext, `Image` blob ) ENGINE=TokuDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (2.18 sec) mysql> show create table mydbops.innodb\G *************************** 1. row …[Read more]