@wash, i tried the creation of the symbolic link, everything works fine, but mysql cannot spot the mysql.sock, it fails to start, never knew mysql.sock is not a file by itself, had tried to copy it from another server.<br>
@joe my server runs ubuntu server 10.10, wanted to mount the TB as i look for a permanent solution as our company cannot stand a downtime.<br><br><div class="gmail_quote">On Mon, Jun 4, 2012 at 4:48 PM, joe mwirigi <span dir="ltr">&lt;<a href="mailto:joemwirigi@gmail.com" target="_blank">joemwirigi@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">@ felix, what linux version are you on! Some debian &amp; mysql love afairs have terrible leaks... may not suggest to you how to move what to move but if your databases have a small foot print. my bet would be on your mysql installation not not the disk space and even if you move to some TB the result will be the same!<div>

<br></div><div>rgds<br clear="all"><i><font color="#666666">_______________________________________________________________<br>We must Keep on, <br>   </font></i><div><div class="h5"><br>  <br>
<br><br><div class="gmail_quote">On Mon, Jun 4, 2012 at 4:40 PM, Odhiambo Washington <span dir="ltr">&lt;<a href="mailto:odhiambo@gmail.com" target="_blank">odhiambo@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

mysql.sock is a socket file - automatically created when mysqld starts and deleted when mysqld stops.<br><br>The reason I suggested you switch to single user mode is exactly to cater for such types. In single user mode, all server daemons are killed. You just get a barebone shell to fix things. Once you exit single user mode (switching to multi user/server mode) all these things take care of themselves.<div>

<div><br>

<br><br><div class="gmail_quote">On Mon, Jun 4, 2012 at 1:04 PM, Felix mwai <span dir="ltr">&lt;<a href="mailto:flxxmw@gmail.com" target="_blank">flxxmw@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">



Okay, i will try this option, if i was to consider moving var, do you think the file mysql.sock will be able to move, have you ever tried copying it?<div><div><br><br><div class="gmail_quote">On Mon, Jun 4, 2012 at 1:03 PM, Anthony Lenya <span dir="ltr">&lt;<a href="mailto:tlensya@gmail.com" target="_blank">tlensya@gmail.com</a>&gt;</span> wrote:<br>




<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">hhmmm.... U should consider moving your database files to the other disk/partition.  I would only consider moving /var as a very last resort so as to avoid breaking stuff.<br>




<br>Regards.<div><div><br><br><div class="gmail_quote">On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <span dir="ltr">&lt;<a href="mailto:flxxmw@gmail.com" target="_blank">flxxmw@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">@anthony, i have restarted this server severally, it&#39;s quite funny the way the server fills the /var space, i store all the file uploads in mounted hard disks, my /var/www has only the web apps that never increase in size, the databases in /var/lib/mysql are not that big to consume about 1GB of space every 3-5hours, this is the problem am having.<div>





<div><br>
<br><div class="gmail_quote">On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya <span dir="ltr">&lt;<a href="mailto:tlensya@gmail.com" target="_blank">tlensya@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">






Felix,<br><br>In addition to the above suggestions, If you have done a clean up and u still cant seem to recover more space then your problem could be that you deleted a file which was open by some application.  As a result the file (inode) was cleared from the file system but not released by the application. You may clear lots of files but not gain any additional space on the drive/partition.  My best bet would be a system restart but if thats out of question then you may use a tool like lsof to check which apps have open files (even deleted ones) and restart the application in order to release the file.  <br>







<br>my 2 cents<div><div><br><br><br><div class="gmail_quote">On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <span dir="ltr">&lt;<a href="mailto:flxxmw@gmail.com" target="_blank">flxxmw@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
@bernard, my first option to solve this problem was to clean all the unnecessary data from the server including all the logs, the problem is that even after clean up the /var still remains full, i have actually done du -hs on almost all the folders in /var, their total space doesnt add up the total allocated to /var from the df -h results.<br>








@wash i am about to test on creating a symbolic links as you indicated, only that i don&#39;t know whether the mysql.sock will work with this setting. <br><div><div><br><div class="gmail_quote">
On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington <span dir="ltr">&lt;<a href="mailto:odhiambo@gmail.com" target="_blank">odhiambo@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br><br><div class="gmail_quote"><div>On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <span dir="ltr">&lt;<a href="mailto:flxxmw@gmail.com" target="_blank">flxxmw@gmail.com</a>&gt;</span> wrote:<br>








<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">

Thanks Benard, Do you think some services might stop working if i completely migrate the entire var to the external hard disk?</blockquote></div><div><br>Drop to single user mode<br>Mount the new filesystem on whatever mountpoint you wish (let&#39;s call it /bigstore)<br>










mkdir /bigstore/var<br>cd /<br>dump -L0af - /var | (cd /bigstore/var; restore -rf -)<br>umount /var <br>vi /etc/fstab and comment it out<br>ln -s /bigstore/var /var<br>reboot into multiuser mode<br><br>I hope Linux supports growfs so you could reclaim the partition you just umounted into /<br>










<br><br></div><div><div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div><br><br><div class="gmail_quote">On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru <span dir="ltr">&lt;<a href="mailto:bmwagiru@gmail.com" target="_blank">bmwagiru@gmail.com</a>&gt;</span> wrote:<br>











<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">I believe you can mount extra storage and soft link /var to it.<br>Or you can NFS share a network storage to /var.<br>










<br>
<br>./bernard<br><br><br><br><div class="gmail_quote"><div>On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <span dir="ltr">&lt;<a href="mailto:flxxmw@gmail.com" target="_blank">flxxmw@gmail.com</a>&gt;</span> wrote:<br>

</div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>Hi Guys,<br>One of my web server runs ubuntu server 10.10. I installed it on a 200GB harddisk and assigned /var 70GB but now seems to be full, anyone know whether i can mount a 1TB external harddisk on var and manage to extend the space to 1070GB, i have tried using LVM in vain.<br clear="all">













<br><br>
<br></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br></div></div><span><font color="#888888">-- <br>Regards<br>Felix Mwai<br>Software Developer.<br>










Mobile <a href="tel:0720453684" value="+254720453684" target="_blank">0720453684</a>.<br><br>
</font></span><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div></div></div><span><font color="#888888"><br><br clear="all"><br>-- <br>Best regards,<br>Odhiambo WASHINGTON,<br>
Nairobi,KE<br><a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121</a>/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223</a><br>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ <br>










I can&#39;t hear you -- I&#39;m using the scrambler.<br><br>
</font></span><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Felix Mwai<br>Software Developer.<br>Mobile <a href="tel:0720453684" value="+254720453684" target="_blank">0720453684</a>.<br>






<br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><div></div>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Felix Mwai<br>Software Developer.<br>Mobile <a href="tel:0720453684" value="+254720453684" target="_blank">0720453684</a>.<br>




<br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><div></div>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Felix Mwai<br>Software Developer.<br>Mobile <a href="tel:0720453684" value="+254720453684" target="_blank">0720453684</a>.<br>

<br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Odhiambo WASHINGTON,<br>Nairobi,KE<br><a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121</a>/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223</a><br>

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ <br>

I can&#39;t hear you -- I&#39;m using the scrambler.<br><br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Felix Mwai<br>Software Developer.<br>Mobile 0720453684.<br><br>