← Back to team overview

maria-discuss team mailing list archive

Thread
Date

InnoDB defragmentation

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: Federico Razzoli <federico_raz@xxxxxxxx>
Date: Fri, 17 Oct 2014 16:28:44 +0100
In-reply-to: <20141013145321.GD15748@meddwl.fritz.box>

Hello.

I've read in this page

https://mariadb.com/kb/en/mariadb/documentation/sql-commands/table-commands/optimize-table/

that OPTIMIZE TABLE defragments InnoDB tables in 10.1. Good news! Just some questions: What locks are acquired? Is the table copied? Is the operation atomic?

Regards
Federico

References

Re: .ibd files remaining after DROP TABLE
From: Sergei Golubchik, 2014-10-13