Optimize table partitions
- Date: Fri, 3 Mar 2017 12:15:16 +0200
- From: "Machiel Richards" <machiel@xxxxxxxxxxxx>
- Subject: Optimize table partitions
Good day everyone
I hope this mail is finding everyone well.
I am asking for some insight again today as I can not seem to find
the correct info on the net.
Some of our database tables are quite large with millions of records.
However due to disk space issues, we have done a huge amount of
archiving by moving data to archiving servers and deleting from main
We would like to however run optimize table in order to reclaim some
of the disk space , but we are facing the following issues :
- Running optimize on the full table not possible due to lack of
- We then tried to optimize per partition using "Alter Table
<table> optimize partition <partition name>;"
Optimizing per partition however seems to be taking extremely long
as we are only able to optimize 35 partitions (of the 1024
partitions in the table) during the course of 4 hours.
I would like to know whether there is a more efficient way to do this?
These are live servers that we can not unfortunately take offline
(i.e. lock table as per some suggestions found).
I would really appreciate any feedback in this matter.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql