Note that tablespace files including ibdata1 will not shrink as the result of defragmentation, but one will get better memory utilization in the InnoDB buffer pool as there are fewer data pages in use. Knowledge Base Contact Login Search. MariaDB starting with Comments loading Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. Mike B Mike B 3 3 gold badges 8 8 silver badges 17 17 bronze badges.
Add a comment. Active Oldest Votes. Jan 17, : Adding an index very slow Mar 25, : Why does InnoDB store all databases in one file? Improve this answer. Community Bot 1. There is a simpler way, if you have access to the file system. MYD -rw-rw MYI -rw-rw Note, please don't use screenshots, if also text copy-paste is enough.
Marco 3, 4 4 gold badges 20 20 silver badges 25 25 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Explaining the semiconductor shortage, and how it might end.
The table in question stores logs. It had around 17 million records. I deleted just over half of them because disk space was starting to become an issue. I then ran optimize table. It's on a fairly powerful EC2 server so I didn't expect it to take more than a hour or two. It's still going but the CPU and disk usage on the server are very low so I'm starting to wonder if it's actually doing anything.
0コメント