Hi, I think I am too late.. if not for time being you can, move * '57G myisam_data'* dir to drive '*/dev/sde1 266G 184G 70G 73% /hdd5-1 *' and make the soft link with proper permission. Note activity must be done once database is shutdown.
and secondly, normally innodb do not release the space once data get deleted. so its advise , to take backup and re-import the databses. steps : 1) Stop writes to the server 2) Dump the data 3) drop all databases (except mysql) 4) stop mysqld 5) remove the innodb data and log files 6) start mysqld (the innodb tablespace should be automatically created) 7) Check the error logs for anything strange 8) import the data Thanks, Prabhat On Thu, Aug 25, 2011 at 9:48 PM, Adarsh Sharma <adarsh.sha...@orkash.com>wrote: > Dear all, > > Today by chance I am checking the space in mysql data directories. > > /dev/sdd5 274G 258G 2.6G 100% /hdd4-1 > > In the next 2 days i know my space becomes empty due to increase in data of > myisam tables. > > [root@sd-1 hdd4-1]# du -sh * 33G innodb_data1 > 33G innodb_data2 > 33G innodb_data3 > 33G innodb_data4 > 33G innodb_data5 > 33G innodb_data6 > 8.1G innodb_data7 > 16K lost+found > 57G myisam_data > 4.0K temp > [root@sd-1 hdd4-1]# > > > When it becomes full, I am sure my server down. Can anyone Please let me > know the steps I need to follow in this condition. Following are my > directories : > Filesystem Size Used Avail Use% Mounted on > /dev/sda2 29G 12G 15G 45% / > /dev/sda1 99M 11M 84M 11% /boot > /dev/sda5 69G 35G 32G 52% /hdd1-1 > /dev/sdb1 274G 225G 36G 87% /hdd2-1 > /dev/sdc5 274G 225G 36G 87% /hdd3-1 > /dev/sdd5 274G 258G 2.6G 100% /hdd4-1 > /dev/sde1 266G 184G 70G 73% /hdd5-1 > > > Thanks > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?** > unsub=aim.prab...@gmail.com<http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com> > > -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
