List:General Discussion« Previous MessageNext Message »
From:Prabhat Kumar Date:August 29 2011 7:23pm
Subject:Re: Caution : Hard Disk Full
View as plain text  
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.sharma@stripped>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.prabhat@stripped<http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Best Regards,

Prabhat Kumar
MySQL DBA

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

Thread
Caution : Hard Disk FullAdarsh Sharma26 Aug
  • Re: Caution : Hard Disk FullJohan De Meersman26 Aug
    • Re: Caution : Hard Disk FullWm Mussatto26 Aug
  • Re: Caution : Hard Disk FullPrabhat Kumar29 Aug