Hello everyone,
While digging through the files on my MySQL server used by Metabase, I discovered the view_log.ibd file, which corresponds to the view_log table. From what I've read, this table was used with version 0.50 and then became an option available only in the Enterprise version. No problem with this idea, except that the table takes up 4.8 GB on my disk, and I have no idea what procedure to follow to purge it and free up space on my server.
Just in case, I did a SELECT on this table, and the last record dates from 2024-07-15. Is there any documentation on how to purge this table?
{
"browser-info": {
"language": "fr",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0",
"vendor": ""
},
"metabase-info": {
"databases": [
"mysql"
],
"run-mode": "prod",
"plan-alias": "",
"version": {
"date": "2024-11-04",
"tag": "v0.51.2",
"hash": "8bdb22c"
},
"settings": {
"report-timezone": "Europe/Paris"
},
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MariaDB",
"version": "10.5.15-MariaDB-0+deb11u1"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.10"
}
}
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.15+10-post-Debian-1deb11u1",
"java.vendor": "Debian",
"java.vendor.url": "https://tracker.debian.org/openjdk-11",
"java.version": "11.0.15",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.15+10-post-Debian-1deb11u1",
"os.name": "Linux",
"os.version": "5.10.0-14-amd64",
"user.language": "fr",
"user.timezone": "Europe/Paris"
}
}
Thank you in advance.