03-29-2012
176,
5
Join Date: Oct 2008
Last Activity: 11 November 2015, 6:40 PM EST
Location: Orem, Utah
Posts: 176
Thanks Given: 16
Thanked 5 Times in 5 Posts
MySQL - optimize using other storage volume
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.
Last edited by treesloth; 03-30-2012 at 01:36 PM..