Re: Issue while SymLinking a Database

2011-01-02 Thread Suresh Kuna
Hey Adarsh, If no downtime then the only way is lock with write on the table, move to the new space, create symlink, flush the table. Remember, this symlinks will have issues if you execute any maintenance on these tables which are moved. Better idea - As the tables are MyISAM, move one database

Issue while SymLinking a Database

2011-01-02 Thread Adarsh Sharma
Dear all, I am working on a stable solution for resolving Space Issue of data directory of MyISAM tables. We have a table of 70GB in /hdd-1/mysql_data path and there is 10GB space available space in Hard Disk.Now the table expects to grow upto 150Gb. I have some doubts regarding Symlinking a