So, I need to optimize a very large MySQL table. This process creates a TMD that seems to approach the size of the original MYD. The problem is that we don't have that much space left on the volume that the MySQL files are on. Is there a way to get the system to use another storage volume on a one-time basis for the optimization? I can't quite wrap my head around any sort of link trickery that would get the job done. Many thanks in advance.
Well,
are you sure that the table needs optimization?