Thanks Benard, Do you think some services might stop working if i completely migrate the entire var to the external hard disk? On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru <bmwagiru@gmail.com> wrote:

I believe you can mount extra storage and soft link /var to it. Or you can NFS share a network storage to /var.

./bernard

On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com> wrote:

...

Hi Guys, 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.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <flxxmw@gmail.com> wrote:

Thanks Benard, Do you think some services might stop working if i completely migrate the entire var to the external hard disk?

Drop to single user mode Mount the new filesystem on whatever mountpoint you wish (let's call it /bigstore) mkdir /bigstore/var cd / dump -L0af - /var | (cd /bigstore/var; restore -rf -) umount /var vi /etc/fstab and comment it out ln -s /bigstore/var /var reboot into multiuser mode I hope Linux supports growfs so you could reclaim the partition you just umounted into /

On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru <bmwagiru@gmail.com>wrote:

...

I believe you can mount extra storage and soft link /var to it. Or you can NFS share a network storage to /var.

./bernard

On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com> wrote:

...

Hi Guys, 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.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

Felix, 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. my 2 cents On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <flxxmw@gmail.com> wrote:

@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. @wash i am about to test on creating a symbolic links as you indicated, only that i don't know whether the mysql.sock will work with this setting.

On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington <odhiambo@gmail.com>wrote:

...

On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <flxxmw@gmail.com> wrote:

...

Thanks Benard, Do you think some services might stop working if i completely migrate the entire var to the external hard disk?

Drop to single user mode Mount the new filesystem on whatever mountpoint you wish (let's call it /bigstore) mkdir /bigstore/var cd / dump -L0af - /var | (cd /bigstore/var; restore -rf -) umount /var vi /etc/fstab and comment it out ln -s /bigstore/var /var reboot into multiuser mode

I hope Linux supports growfs so you could reclaim the partition you just umounted into /

...

On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru <bmwagiru@gmail.com>wrote:

...

I believe you can mount extra storage and soft link /var to it. Or you can NFS share a network storage to /var.

./bernard

On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com> wrote:

...

Hi Guys, 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.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

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. Regards. On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <flxxmw@gmail.com> wrote:

@anthony, i have restarted this server severally, it'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.

On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya <tlensya@gmail.com> wrote:

...

Felix,

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.

my 2 cents

On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@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. @wash i am about to test on creating a symbolic links as you indicated, only that i don't know whether the mysql.sock will work with this setting.

On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington <odhiambo@gmail.com

...

wrote:

...

On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <flxxmw@gmail.com> wrote:

...

Thanks Benard, Do you think some services might stop working if i completely migrate the entire var to the external hard disk?

Drop to single user mode Mount the new filesystem on whatever mountpoint you wish (let's call it /bigstore) mkdir /bigstore/var cd / dump -L0af - /var | (cd /bigstore/var; restore -rf -) umount /var vi /etc/fstab and comment it out ln -s /bigstore/var /var reboot into multiuser mode

I hope Linux supports growfs so you could reclaim the partition you just umounted into /

...

On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru <bmwagiru@gmail.com>wrote:

...

I believe you can mount extra storage and soft link /var to it. Or you can NFS share a network storage to /var.

./bernard

On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com> wrote:

> Hi Guys, > 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. > > > > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

Its long since I did this but the my.cnf file is key. I cant quite remember much about whether mysql.sock file should be moved or not. :-) On Mon, Jun 4, 2012 at 1:04 PM, Felix mwai <flxxmw@gmail.com> wrote:

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?

On Mon, Jun 4, 2012 at 1:03 PM, Anthony Lenya <tlensya@gmail.com> wrote:

...

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.

Regards.

On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@anthony, i have restarted this server severally, it'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.

On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya <tlensya@gmail.com>wrote:

...

Felix,

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.

my 2 cents

On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@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. @wash i am about to test on creating a symbolic links as you indicated, only that i don't know whether the mysql.sock will work with this setting.

On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington < odhiambo@gmail.com> wrote:

...

On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <flxxmw@gmail.com> wrote:

> Thanks Benard, Do you think some services might stop working if i > completely migrate the entire var to the external hard disk?

Drop to single user mode Mount the new filesystem on whatever mountpoint you wish (let's call it /bigstore) mkdir /bigstore/var cd / dump -L0af - /var | (cd /bigstore/var; restore -rf -) umount /var vi /etc/fstab and comment it out ln -s /bigstore/var /var reboot into multiuser mode

I hope Linux supports growfs so you could reclaim the partition you just umounted into /

> > On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru <bmwagiru@gmail.com > > wrote: > >> I believe you can mount extra storage and soft link /var to it. >> Or you can NFS share a network storage to /var. >> >> >> ./bernard >> >> >> >> On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com>wrote: >> >>> Hi Guys, >>> 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. >>> >>> >>> >>> _______________________________________________ >>> Skunkworks mailing list >>> Skunkworks@lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co.ke >>> >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks@lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke >> > > > > -- > Regards > Felix Mwai > Software Developer. > Mobile 0720453684. > > > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

mysql.sock is a socket file - automatically created when mysqld starts and deleted when mysqld stops. 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. On Mon, Jun 4, 2012 at 1:04 PM, Felix mwai <flxxmw@gmail.com> wrote:

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?

On Mon, Jun 4, 2012 at 1:03 PM, Anthony Lenya <tlensya@gmail.com> wrote:

...

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.

Regards.

On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@anthony, i have restarted this server severally, it'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.

On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya <tlensya@gmail.com>wrote:

...

Felix,

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.

my 2 cents

On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@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. @wash i am about to test on creating a symbolic links as you indicated, only that i don't know whether the mysql.sock will work with this setting.

On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington < odhiambo@gmail.com> wrote:

...

On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <flxxmw@gmail.com> wrote:

> Thanks Benard, Do you think some services might stop working if i > completely migrate the entire var to the external hard disk?

Drop to single user mode Mount the new filesystem on whatever mountpoint you wish (let's call it /bigstore) mkdir /bigstore/var cd / dump -L0af - /var | (cd /bigstore/var; restore -rf -) umount /var vi /etc/fstab and comment it out ln -s /bigstore/var /var reboot into multiuser mode

I hope Linux supports growfs so you could reclaim the partition you just umounted into /

> > On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru <bmwagiru@gmail.com > > wrote: > >> I believe you can mount extra storage and soft link /var to it. >> Or you can NFS share a network storage to /var. >> >> >> ./bernard >> >> >> >> On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com>wrote: >> >>> Hi Guys, >>> 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. >>> >>> >>> >>> _______________________________________________ >>> Skunkworks mailing list >>> Skunkworks@lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co.ke >>> >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks@lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke >> > > > > -- > Regards > Felix Mwai > Software Developer. > Mobile 0720453684. > > > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

@Joe - what effect would this be from mysql? If the DBs don't grow significantly as the OP said earlier, then I wonder if the error log file would, in the absence of any problems, which would beeasily detected running the apps that rely on the DBs.. On Mon, Jun 4, 2012 at 4:48 PM, joe mwirigi <joemwirigi@gmail.com> wrote:

@ felix, what linux version are you on! Some debian & 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!

rgds *_______________________________________________________________ We must Keep on, *

On Mon, Jun 4, 2012 at 4:40 PM, Odhiambo Washington <odhiambo@gmail.com>wrote:

...

mysql.sock is a socket file - automatically created when mysqld starts and deleted when mysqld stops.

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.

On Mon, Jun 4, 2012 at 1:04 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

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?

On Mon, Jun 4, 2012 at 1:03 PM, Anthony Lenya <tlensya@gmail.com> wrote:

...

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.

Regards.

On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@anthony, i have restarted this server severally, it'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.

On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya <tlensya@gmail.com>wrote:

...

Felix,

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.

my 2 cents

On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <flxxmw@gmail.com> wrote:

> @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. > @wash i am about to test on creating a symbolic links as you > indicated, only that i don't know whether the mysql.sock will work with > this setting. > > On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington < > odhiambo@gmail.com> wrote: > >> >> >> On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <flxxmw@gmail.com>wrote: >> >>> Thanks Benard, Do you think some services might stop working if i >>> completely migrate the entire var to the external hard disk? >> >> >> Drop to single user mode >> Mount the new filesystem on whatever mountpoint you wish (let's >> call it /bigstore) >> mkdir /bigstore/var >> cd / >> dump -L0af - /var | (cd /bigstore/var; restore -rf -) >> umount /var >> vi /etc/fstab and comment it out >> ln -s /bigstore/var /var >> reboot into multiuser mode >> >> I hope Linux supports growfs so you could reclaim the partition you >> just umounted into / >> >> >> >>> >>> On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru < >>> bmwagiru@gmail.com> wrote: >>> >>>> I believe you can mount extra storage and soft link /var to it. >>>> Or you can NFS share a network storage to /var. >>>> >>>> >>>> ./bernard >>>> >>>> >>>> >>>> On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com>wrote: >>>> >>>>> Hi Guys, >>>>> 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. >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Skunkworks mailing list >>>>> Skunkworks@lists.my.co.ke >>>>> ------------ >>>>> List info, subscribe/unsubscribe >>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>> ------------ >>>>> >>>>> Skunkworks Rules >>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>> ------------ >>>>> Other services @ http://my.co.ke >>>>> >>>> >>>> >>>> _______________________________________________ >>>> Skunkworks mailing list >>>> Skunkworks@lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>>> >>> >>> >>> >>> -- >>> Regards >>> Felix Mwai >>> Software Developer. >>> Mobile 0720453684. >>> >>> >>> _______________________________________________ >>> Skunkworks mailing list >>> Skunkworks@lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co.ke >>> >> >> >> >> -- >> Best regards, >> Odhiambo WASHINGTON, >> Nairobi,KE >> +254733744121/+254722743223 >> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >> I can't hear you -- I'm using the scrambler. >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks@lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke >> > > > > -- > Regards > Felix Mwai > Software Developer. > Mobile 0720453684. > > > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

@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. @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. On Mon, Jun 4, 2012 at 4:48 PM, joe mwirigi <joemwirigi@gmail.com> wrote:

@ felix, what linux version are you on! Some debian & 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!

rgds *_______________________________________________________________ We must Keep on, *

On Mon, Jun 4, 2012 at 4:40 PM, Odhiambo Washington <odhiambo@gmail.com>wrote:

...

mysql.sock is a socket file - automatically created when mysqld starts and deleted when mysqld stops.

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.

On Mon, Jun 4, 2012 at 1:04 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

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?

On Mon, Jun 4, 2012 at 1:03 PM, Anthony Lenya <tlensya@gmail.com> wrote:

...

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.

Regards.

On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@anthony, i have restarted this server severally, it'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.

On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya <tlensya@gmail.com>wrote:

...

Felix,

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.

my 2 cents

On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <flxxmw@gmail.com> wrote:

> @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. > @wash i am about to test on creating a symbolic links as you > indicated, only that i don't know whether the mysql.sock will work with > this setting. > > On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington < > odhiambo@gmail.com> wrote: > >> >> >> On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <flxxmw@gmail.com>wrote: >> >>> Thanks Benard, Do you think some services might stop working if i >>> completely migrate the entire var to the external hard disk? >> >> >> Drop to single user mode >> Mount the new filesystem on whatever mountpoint you wish (let's >> call it /bigstore) >> mkdir /bigstore/var >> cd / >> dump -L0af - /var | (cd /bigstore/var; restore -rf -) >> umount /var >> vi /etc/fstab and comment it out >> ln -s /bigstore/var /var >> reboot into multiuser mode >> >> I hope Linux supports growfs so you could reclaim the partition you >> just umounted into / >> >> >> >>> >>> On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru < >>> bmwagiru@gmail.com> wrote: >>> >>>> I believe you can mount extra storage and soft link /var to it. >>>> Or you can NFS share a network storage to /var. >>>> >>>> >>>> ./bernard >>>> >>>> >>>> >>>> On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com>wrote: >>>> >>>>> Hi Guys, >>>>> 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. >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Skunkworks mailing list >>>>> Skunkworks@lists.my.co.ke >>>>> ------------ >>>>> List info, subscribe/unsubscribe >>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>> ------------ >>>>> >>>>> Skunkworks Rules >>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>> ------------ >>>>> Other services @ http://my.co.ke >>>>> >>>> >>>> >>>> _______________________________________________ >>>> Skunkworks mailing list >>>> Skunkworks@lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>>> >>> >>> >>> >>> -- >>> Regards >>> Felix Mwai >>> Software Developer. >>> Mobile 0720453684. >>> >>> >>> _______________________________________________ >>> Skunkworks mailing list >>> Skunkworks@lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co.ke >>> >> >> >> >> -- >> Best regards, >> Odhiambo WASHINGTON, >> Nairobi,KE >> +254733744121/+254722743223 >> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >> I can't hear you -- I'm using the scrambler. >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks@lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke >> > > > > -- > Regards > Felix Mwai > Software Developer. > Mobile 0720453684. > > > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

Hi @felix, got sorted! care to share your my.cnf file? Rgds *_______________________________________________________________ We must Keep on, * On Mon, Jun 4, 2012 at 5:21 PM, Odhiambo Washington <odhiambo@gmail.com>wrote:

The only reason mysql would fail to start is if it cannot write to the new var.. or other Linux-ish reason I cannot figure out. I suggest you look for my.cnf and edit to to change the location of mysql.sock from /var to /tmp

The line to change is:

socket = /tmp/mysql.sock

Then restart mysql.

On Mon, Jun 4, 2012 at 4:58 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@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. @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.

On Mon, Jun 4, 2012 at 4:48 PM, joe mwirigi <joemwirigi@gmail.com> wrote:

...

@ felix, what linux version are you on! Some debian & 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!

rgds *_______________________________________________________________ We must Keep on, *

On Mon, Jun 4, 2012 at 4:40 PM, Odhiambo Washington <odhiambo@gmail.com>wrote:

...

mysql.sock is a socket file - automatically created when mysqld starts and deleted when mysqld stops.

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.

On Mon, Jun 4, 2012 at 1:04 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

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?

On Mon, Jun 4, 2012 at 1:03 PM, Anthony Lenya <tlensya@gmail.com>wrote:

...

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.

Regards.

On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <flxxmw@gmail.com> wrote:

> @anthony, i have restarted this server severally, it'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. > > > On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya <tlensya@gmail.com>wrote: > >> Felix, >> >> 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. >> >> my 2 cents >> >> >> >> On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <flxxmw@gmail.com>wrote: >> >>> @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. >>> @wash i am about to test on creating a symbolic links as you >>> indicated, only that i don't know whether the mysql.sock will work with >>> this setting. >>> >>> On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington < >>> odhiambo@gmail.com> wrote: >>> >>>> >>>> >>>> On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <flxxmw@gmail.com>wrote: >>>> >>>>> Thanks Benard, Do you think some services might stop working if >>>>> i completely migrate the entire var to the external hard disk? >>>> >>>> >>>> Drop to single user mode >>>> Mount the new filesystem on whatever mountpoint you wish (let's >>>> call it /bigstore) >>>> mkdir /bigstore/var >>>> cd / >>>> dump -L0af - /var | (cd /bigstore/var; restore -rf -) >>>> umount /var >>>> vi /etc/fstab and comment it out >>>> ln -s /bigstore/var /var >>>> reboot into multiuser mode >>>> >>>> I hope Linux supports growfs so you could reclaim the partition >>>> you just umounted into / >>>> >>>> >>>> >>>>> >>>>> On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru < >>>>> bmwagiru@gmail.com> wrote: >>>>> >>>>>> I believe you can mount extra storage and soft link /var to it. >>>>>> Or you can NFS share a network storage to /var. >>>>>> >>>>>> >>>>>> ./bernard >>>>>> >>>>>> >>>>>> >>>>>> On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com>wrote: >>>>>> >>>>>>> Hi Guys, >>>>>>> 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. >>>>>>> >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Skunkworks mailing list >>>>>>> Skunkworks@lists.my.co.ke >>>>>>> ------------ >>>>>>> List info, subscribe/unsubscribe >>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>> ------------ >>>>>>> >>>>>>> Skunkworks Rules >>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>> ------------ >>>>>>> Other services @ http://my.co.ke >>>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Skunkworks mailing list >>>>>> Skunkworks@lists.my.co.ke >>>>>> ------------ >>>>>> List info, subscribe/unsubscribe >>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>> ------------ >>>>>> >>>>>> Skunkworks Rules >>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>> ------------ >>>>>> Other services @ http://my.co.ke >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards >>>>> Felix Mwai >>>>> Software Developer. >>>>> Mobile 0720453684. >>>>> >>>>> >>>>> _______________________________________________ >>>>> Skunkworks mailing list >>>>> Skunkworks@lists.my.co.ke >>>>> ------------ >>>>> List info, subscribe/unsubscribe >>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>> ------------ >>>>> >>>>> Skunkworks Rules >>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>> ------------ >>>>> Other services @ http://my.co.ke >>>>> >>>> >>>> >>>> >>>> -- >>>> Best regards, >>>> Odhiambo WASHINGTON, >>>> Nairobi,KE >>>> +254733744121/+254722743223 >>>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >>>> I can't hear you -- I'm using the scrambler. >>>> >>>> >>>> _______________________________________________ >>>> Skunkworks mailing list >>>> Skunkworks@lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>>> >>> >>> >>> >>> -- >>> Regards >>> Felix Mwai >>> Software Developer. >>> Mobile 0720453684. >>> >>> >>> _______________________________________________ >>> Skunkworks mailing list >>> Skunkworks@lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co.ke >>> >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks@lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke >> > > > > -- > Regards > Felix Mwai > Software Developer. > Mobile 0720453684. > > > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

I have seen that earlier you mentioned that you don't know what is filling up the /var partition, you need to solve that too, assuming that the external device you are mounting gets full too and yet you do not know what directory taking up all the space. On 5 June 2012 08:18, Felix mwai <flxxmw@gmail.com> wrote:

Hi, This is the section of my.cnf with the mysqld.sock path, when you change the path to /tmp/mysqld.sock, mysql never starts ................................ user        = mysql socket        = /var/run/mysqld/mysqld.sock port        = 3306 basedir        = /usr datadir        = /var/lib/mysql tmpdir        = /tmp ....................................

On Tue, Jun 5, 2012 at 6:08 AM, joe mwirigi <joemwirigi@gmail.com> wrote:

...

Hi @felix, got sorted! care to share your my.cnf file?

Rgds _______________________________________________________________ We must Keep on,

On Mon, Jun 4, 2012 at 5:21 PM, Odhiambo Washington <odhiambo@gmail.com> wrote:

...

The only reason mysql would fail to start is if it cannot write to the new var.. or other Linux-ish reason I cannot figure out. I suggest you look for my.cnf and edit to to change the location of mysql.sock from /var to /tmp

The line to change is:

socket          = /tmp/mysql.sock

Then restart mysql.

On Mon, Jun 4, 2012 at 4:58 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@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. @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.

On Mon, Jun 4, 2012 at 4:48 PM, joe mwirigi <joemwirigi@gmail.com> wrote:

...

@ felix, what linux version are you on! Some debian & 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!

rgds _______________________________________________________________ We must Keep on,

On Mon, Jun 4, 2012 at 4:40 PM, Odhiambo Washington <odhiambo@gmail.com> wrote:

...

mysql.sock is a socket file - automatically created when mysqld starts and deleted when mysqld stops.

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.

On Mon, Jun 4, 2012 at 1:04 PM, Felix mwai <flxxmw@gmail.com> wrote: > > 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? > > > On Mon, Jun 4, 2012 at 1:03 PM, Anthony Lenya <tlensya@gmail.com> > wrote: >> >> 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. >> >> Regards. >> >> >> On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <flxxmw@gmail.com> >> wrote: >>> >>> @anthony, i have restarted this server severally, it'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. >>> >>> >>> On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya <tlensya@gmail.com> >>> wrote: >>>> >>>> Felix, >>>> >>>> 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. >>>> >>>> my 2 cents >>>> >>>> >>>> >>>> On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <flxxmw@gmail.com> >>>> wrote: >>>>> >>>>> @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. >>>>> @wash i am about to test on creating a symbolic links as you >>>>> indicated, only that i don't know whether the mysql.sock will work with this >>>>> setting. >>>>> >>>>> On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington >>>>> <odhiambo@gmail.com> wrote: >>>>>> >>>>>> >>>>>> >>>>>> On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai <flxxmw@gmail.com> >>>>>> wrote: >>>>>>> >>>>>>> Thanks Benard, Do you think some services might stop working if >>>>>>> i completely migrate the entire var to the external hard disk? >>>>>> >>>>>> >>>>>> Drop to single user mode >>>>>> Mount the new filesystem on whatever mountpoint you wish (let's >>>>>> call it /bigstore) >>>>>> mkdir /bigstore/var >>>>>> cd / >>>>>> dump -L0af - /var | (cd /bigstore/var; restore -rf -) >>>>>> umount /var >>>>>> vi /etc/fstab and comment it out >>>>>> ln -s /bigstore/var /var >>>>>> reboot into multiuser mode >>>>>> >>>>>> I hope Linux supports growfs so you could reclaim the partition >>>>>> you just umounted into / >>>>>> >>>>>> >>>>>>> >>>>>>> >>>>>>> On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru >>>>>>> <bmwagiru@gmail.com> wrote: >>>>>>>> >>>>>>>> I believe you can mount extra storage and soft link /var to >>>>>>>> it. >>>>>>>> Or you can NFS share a network storage to /var. >>>>>>>> >>>>>>>> >>>>>>>> ./bernard >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai <flxxmw@gmail.com> >>>>>>>> wrote: >>>>>>>>> >>>>>>>>> Hi Guys, >>>>>>>>> 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. >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Skunkworks mailing list >>>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>>> ------------ >>>>>>>>> List info, subscribe/unsubscribe >>>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>>> ------------ >>>>>>>>> >>>>>>>>> Skunkworks Rules >>>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>>> ------------ >>>>>>>>> Other services @ http://my.co.ke >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Skunkworks mailing list >>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>> ------------ >>>>>>>> List info, subscribe/unsubscribe >>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>> ------------ >>>>>>>> >>>>>>>> Skunkworks Rules >>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>> ------------ >>>>>>>> Other services @ http://my.co.ke >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Regards >>>>>>> Felix Mwai >>>>>>> Software Developer. >>>>>>> Mobile 0720453684. >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Skunkworks mailing list >>>>>>> Skunkworks@lists.my.co.ke >>>>>>> ------------ >>>>>>> List info, subscribe/unsubscribe >>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>> ------------ >>>>>>> >>>>>>> Skunkworks Rules >>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>> ------------ >>>>>>> Other services @ http://my.co.ke >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Best regards, >>>>>> Odhiambo WASHINGTON, >>>>>> Nairobi,KE >>>>>> +254733744121/+254722743223 >>>>>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >>>>>> I can't hear you -- I'm using the scrambler. >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Skunkworks mailing list >>>>>> Skunkworks@lists.my.co.ke >>>>>> ------------ >>>>>> List info, subscribe/unsubscribe >>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>> ------------ >>>>>> >>>>>> Skunkworks Rules >>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>> ------------ >>>>>> Other services @ http://my.co.ke >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards >>>>> Felix Mwai >>>>> Software Developer. >>>>> Mobile 0720453684. >>>>> >>>>> >>>>> _______________________________________________ >>>>> Skunkworks mailing list >>>>> Skunkworks@lists.my.co.ke >>>>> ------------ >>>>> List info, subscribe/unsubscribe >>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>> ------------ >>>>> >>>>> Skunkworks Rules >>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>> ------------ >>>>> Other services @ http://my.co.ke >>>> >>>> >>>> >>>> _______________________________________________ >>>> Skunkworks mailing list >>>> Skunkworks@lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>> >>> >>> >>> >>> -- >>> Regards >>> Felix Mwai >>> Software Developer. >>> Mobile 0720453684. >>> >>> >>> _______________________________________________ >>> Skunkworks mailing list >>> Skunkworks@lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co.ke >> >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks@lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke > > > > > -- > Regards > Felix Mwai > Software Developer. > Mobile 0720453684. > > > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙ Regards, David Njuki @njukey [Google,Twitter,Yahoo]

Hi Felix, Have you found what app is eating up your space? Try sudo du -sh /var/* Then dig down from your largest directories. There are high chances that /var/log is the suspect. For Mysql, can you show us the error log? Isaac On Tue, Jun 5, 2012 at 8:41 AM, Felix mwai <flxxmw@gmail.com> wrote:

@Njuki, yeah i must find a permanent solution, i wanted to mount the disk for a while to allow guys continue working.

On Tue, Jun 5, 2012 at 8:28 AM, David Njuki <njukey@gmail.com> wrote:

...

I have seen that earlier you mentioned that you don't know what is filling up the /var partition, you need to solve that too, assuming that the external device you are mounting gets full too and yet you do not know what directory taking up all the space.

On 5 June 2012 08:18, Felix mwai <flxxmw@gmail.com> wrote:

...

Hi, This is the section of my.cnf with the mysqld.sock path, when you change the path to /tmp/mysqld.sock, mysql never starts ................................ user        = mysql socket        = /var/run/mysqld/mysqld.sock port        = 3306 basedir        = /usr datadir        = /var/lib/mysql tmpdir        = /tmp ....................................

On Tue, Jun 5, 2012 at 6:08 AM, joe mwirigi <joemwirigi@gmail.com> wrote:

...

Hi @felix, got sorted! care to share your my.cnf file?

Rgds _______________________________________________________________ We must Keep on,

On Mon, Jun 4, 2012 at 5:21 PM, Odhiambo Washington <odhiambo@gmail.com> wrote:

...

The only reason mysql would fail to start is if it cannot write to the new var.. or other Linux-ish reason I cannot figure out. I suggest you look for my.cnf and edit to to change the location of mysql.sock from /var to /tmp

The line to change is:

socket          = /tmp/mysql.sock

Then restart mysql.

On Mon, Jun 4, 2012 at 4:58 PM, Felix mwai <flxxmw@gmail.com> wrote:

...

@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. @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.

On Mon, Jun 4, 2012 at 4:48 PM, joe mwirigi <joemwirigi@gmail.com> wrote: > > @ felix, what linux version are you on! Some debian & 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! > > rgds > _______________________________________________________________ > We must Keep on, > > > > > > On Mon, Jun 4, 2012 at 4:40 PM, Odhiambo Washington > <odhiambo@gmail.com> wrote: >> >> mysql.sock is a socket file - automatically created when mysqld >> starts >> and deleted when mysqld stops. >> >> 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. >> >> >> >> On Mon, Jun 4, 2012 at 1:04 PM, Felix mwai <flxxmw@gmail.com> >> wrote: >>> >>> 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? >>> >>> >>> On Mon, Jun 4, 2012 at 1:03 PM, Anthony Lenya <tlensya@gmail.com> >>> wrote: >>>> >>>> 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. >>>> >>>> Regards. >>>> >>>> >>>> On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <flxxmw@gmail.com> >>>> wrote: >>>>> >>>>> @anthony, i have restarted this server severally, it'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. >>>>> >>>>> >>>>> On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya >>>>> <tlensya@gmail.com> >>>>> wrote: >>>>>> >>>>>> Felix, >>>>>> >>>>>> 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. >>>>>> >>>>>> my 2 cents >>>>>> >>>>>> >>>>>> >>>>>> On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai <flxxmw@gmail.com> >>>>>> wrote: >>>>>>> >>>>>>> @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. >>>>>>> @wash i am about to test on creating a symbolic links as you >>>>>>> indicated, only that i don't know whether the mysql.sock will >>>>>>> work with this >>>>>>> setting. >>>>>>> >>>>>>> On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington >>>>>>> <odhiambo@gmail.com> wrote: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai >>>>>>>> <flxxmw@gmail.com> >>>>>>>> wrote: >>>>>>>>> >>>>>>>>> Thanks Benard, Do you think some services might stop working >>>>>>>>> if >>>>>>>>> i completely migrate the entire var to the external hard >>>>>>>>> disk? >>>>>>>> >>>>>>>> >>>>>>>> Drop to single user mode >>>>>>>> Mount the new filesystem on whatever mountpoint you wish >>>>>>>> (let's >>>>>>>> call it /bigstore) >>>>>>>> mkdir /bigstore/var >>>>>>>> cd / >>>>>>>> dump -L0af - /var | (cd /bigstore/var; restore -rf -) >>>>>>>> umount /var >>>>>>>> vi /etc/fstab and comment it out >>>>>>>> ln -s /bigstore/var /var >>>>>>>> reboot into multiuser mode >>>>>>>> >>>>>>>> I hope Linux supports growfs so you could reclaim the >>>>>>>> partition >>>>>>>> you just umounted into / >>>>>>>> >>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru >>>>>>>>> <bmwagiru@gmail.com> wrote: >>>>>>>>>> >>>>>>>>>> I believe you can mount extra storage and soft link /var to >>>>>>>>>> it. >>>>>>>>>> Or you can NFS share a network storage to /var. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> ./bernard >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai >>>>>>>>>> <flxxmw@gmail.com> >>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>> Hi Guys, >>>>>>>>>>> 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. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Skunkworks mailing list >>>>>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>>>>> ------------ >>>>>>>>>>> List info, subscribe/unsubscribe >>>>>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>>>>> ------------ >>>>>>>>>>> >>>>>>>>>>> Skunkworks Rules >>>>>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>>>>> ------------ >>>>>>>>>>> Other services @ http://my.co.ke >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> Skunkworks mailing list >>>>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>>>> ------------ >>>>>>>>>> List info, subscribe/unsubscribe >>>>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>>>> ------------ >>>>>>>>>> >>>>>>>>>> Skunkworks Rules >>>>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>>>> ------------ >>>>>>>>>> Other services @ http://my.co.ke >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Regards >>>>>>>>> Felix Mwai >>>>>>>>> Software Developer. >>>>>>>>> Mobile 0720453684. >>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Skunkworks mailing list >>>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>>> ------------ >>>>>>>>> List info, subscribe/unsubscribe >>>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>>> ------------ >>>>>>>>> >>>>>>>>> Skunkworks Rules >>>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>>> ------------ >>>>>>>>> Other services @ http://my.co.ke >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Best regards, >>>>>>>> Odhiambo WASHINGTON, >>>>>>>> Nairobi,KE >>>>>>>> +254733744121/+254722743223 >>>>>>>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >>>>>>>> I can't hear you -- I'm using the scrambler. >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Skunkworks mailing list >>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>> ------------ >>>>>>>> List info, subscribe/unsubscribe >>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>> ------------ >>>>>>>> >>>>>>>> Skunkworks Rules >>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>> ------------ >>>>>>>> Other services @ http://my.co.ke >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Regards >>>>>>> Felix Mwai >>>>>>> Software Developer. >>>>>>> Mobile 0720453684. >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Skunkworks mailing list >>>>>>> Skunkworks@lists.my.co.ke >>>>>>> ------------ >>>>>>> List info, subscribe/unsubscribe >>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>> ------------ >>>>>>> >>>>>>> Skunkworks Rules >>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>> ------------ >>>>>>> Other services @ http://my.co.ke >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Skunkworks mailing list >>>>>> Skunkworks@lists.my.co.ke >>>>>> ------------ >>>>>> List info, subscribe/unsubscribe >>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>> ------------ >>>>>> >>>>>> Skunkworks Rules >>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>> ------------ >>>>>> Other services @ http://my.co.ke >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards >>>>> Felix Mwai >>>>> Software Developer. >>>>> Mobile 0720453684. >>>>> >>>>> >>>>> _______________________________________________ >>>>> Skunkworks mailing list >>>>> Skunkworks@lists.my.co.ke >>>>> ------------ >>>>> List info, subscribe/unsubscribe >>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>> ------------ >>>>> >>>>> Skunkworks Rules >>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>> ------------ >>>>> Other services @ http://my.co.ke >>>> >>>> >>>> >>>> _______________________________________________ >>>> Skunkworks mailing list >>>> Skunkworks@lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>> >>> >>> >>> >>> -- >>> Regards >>> Felix Mwai >>> Software Developer. >>> Mobile 0720453684. >>> >>> >>> _______________________________________________ >>> Skunkworks mailing list >>> Skunkworks@lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co.ke >> >> >> >> >> -- >> Best regards, >> Odhiambo WASHINGTON, >> Nairobi,KE >> +254733744121/+254722743223 >> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >> I can't hear you -- I'm using the scrambler. >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks@lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke > > > > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙ Regards, David Njuki @njukey [Google,Twitter,Yahoo] _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

Well was xpecting to see more of the .cnf but with ubuntu, (hoping its ubuntu). Try to make some adjustments on the security app.. just a minute ...AppArmor . here http://www.ubuntugeek.com/how-to-change-the-mysql-data-default-directory.htm... I guess they have better explanation than i could. Also have you added any custom logs. eg ask mysql to log every activity on the db like selects e.t.c? Rgds *_______________________________________________________________ We must Keep on, * On Tue, Jun 5, 2012 at 9:44 AM, maina <dmaishe@gmail.com> wrote:

Felix the simplest way is to check which folder is chewing up.

Use below:

sudo du -sh --block-size=1G /var/* |sort -n

On Tue, Jun 5, 2012 at 9:24 AM, Kahugu Isaac <ikahugu@gmail.com> wrote:

...

Hi Felix, Have you found what app is eating up your space? Try sudo du -sh /var/* Then dig down from your largest directories. There are high chances that /var/log is the suspect.

For Mysql, can you show us the error log?

Isaac

On Tue, Jun 5, 2012 at 8:41 AM, Felix mwai <flxxmw@gmail.com> wrote:

...

@Njuki, yeah i must find a permanent solution, i wanted to mount the disk for a while to allow guys continue working.

On Tue, Jun 5, 2012 at 8:28 AM, David Njuki <njukey@gmail.com> wrote:

...

I have seen that earlier you mentioned that you don't know what is filling up the /var partition, you need to solve that too, assuming that the external device you are mounting gets full too and yet you do not know what directory taking up all the space.

On 5 June 2012 08:18, Felix mwai <flxxmw@gmail.com> wrote:

...

Hi, This is the section of my.cnf with the mysqld.sock path, when you

change

...

...

the path to /tmp/mysqld.sock, mysql never starts ................................ user = mysql socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp ....................................

On Tue, Jun 5, 2012 at 6:08 AM, joe mwirigi <joemwirigi@gmail.com> wrote:

...

Hi @felix, got sorted! care to share your my.cnf file?

Rgds _______________________________________________________________ We must Keep on,

On Mon, Jun 4, 2012 at 5:21 PM, Odhiambo Washington <odhiambo@gmail.com> wrote: > > The only reason mysql would fail to start is if it cannot write to

the

...

> new var.. or other Linux-ish reason I cannot figure out. > I suggest you look for my.cnf and edit to to change the location of > mysql.sock from /var to /tmp > > The line to change is: > > socket = /tmp/mysql.sock > > Then restart mysql. > > > > On Mon, Jun 4, 2012 at 4:58 PM, Felix mwai <flxxmw@gmail.com> wrote: >> >> @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. >> @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. >> >> On Mon, Jun 4, 2012 at 4:48 PM, joe mwirigi <joemwirigi@gmail.com

...

...

...

...

>> wrote: >>> >>> @ felix, what linux version are you on! Some debian & 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! >>> >>> rgds >>> _______________________________________________________________ >>> We must Keep on, >>> >>> >>> >>> >>> >>> On Mon, Jun 4, 2012 at 4:40 PM, Odhiambo Washington >>> <odhiambo@gmail.com> wrote: >>>> >>>> mysql.sock is a socket file - automatically created when mysqld >>>> starts >>>> and deleted when mysqld stops. >>>> >>>> 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. >>>> >>>> >>>> >>>> On Mon, Jun 4, 2012 at 1:04 PM, Felix mwai <flxxmw@gmail.com> >>>> wrote: >>>>> >>>>> 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? >>>>> >>>>> >>>>> On Mon, Jun 4, 2012 at 1:03 PM, Anthony Lenya < tlensya@gmail.com> >>>>> wrote: >>>>>> >>>>>> 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. >>>>>> >>>>>> Regards. >>>>>> >>>>>> >>>>>> On Mon, Jun 4, 2012 at 12:53 PM, Felix mwai <flxxmw@gmail.com

...

...

...

...

>>>>>> wrote: >>>>>>> >>>>>>> @anthony, i have restarted this server severally, it'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. >>>>>>> >>>>>>> >>>>>>> On Mon, Jun 4, 2012 at 12:42 PM, Anthony Lenya >>>>>>> <tlensya@gmail.com> >>>>>>> wrote: >>>>>>>> >>>>>>>> Felix, >>>>>>>> >>>>>>>> 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. >>>>>>>> >>>>>>>> my 2 cents >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Jun 4, 2012 at 12:11 PM, Felix mwai < flxxmw@gmail.com> >>>>>>>> wrote: >>>>>>>>> >>>>>>>>> @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. >>>>>>>>> @wash i am about to test on creating a symbolic links as you >>>>>>>>> indicated, only that i don't know whether the mysql.sock will >>>>>>>>> work with this >>>>>>>>> setting. >>>>>>>>> >>>>>>>>> On Mon, Jun 4, 2012 at 11:44 AM, Odhiambo Washington >>>>>>>>> <odhiambo@gmail.com> wrote: >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Mon, Jun 4, 2012 at 11:16 AM, Felix mwai >>>>>>>>>> <flxxmw@gmail.com> >>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>> Thanks Benard, Do you think some services might stop working >>>>>>>>>>> if >>>>>>>>>>> i completely migrate the entire var to the external hard >>>>>>>>>>> disk? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Drop to single user mode >>>>>>>>>> Mount the new filesystem on whatever mountpoint you wish >>>>>>>>>> (let's >>>>>>>>>> call it /bigstore) >>>>>>>>>> mkdir /bigstore/var >>>>>>>>>> cd / >>>>>>>>>> dump -L0af - /var | (cd /bigstore/var; restore -rf -) >>>>>>>>>> umount /var >>>>>>>>>> vi /etc/fstab and comment it out >>>>>>>>>> ln -s /bigstore/var /var >>>>>>>>>> reboot into multiuser mode >>>>>>>>>> >>>>>>>>>> I hope Linux supports growfs so you could reclaim the >>>>>>>>>> partition >>>>>>>>>> you just umounted into / >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Mon, Jun 4, 2012 at 11:13 AM, Bernard Mwagiru >>>>>>>>>>> <bmwagiru@gmail.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>> I believe you can mount extra storage and soft link /var to >>>>>>>>>>>> it. >>>>>>>>>>>> Or you can NFS share a network storage to /var. >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> ./bernard >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Mon, Jun 4, 2012 at 11:10 AM, Felix mwai >>>>>>>>>>>> <flxxmw@gmail.com> >>>>>>>>>>>> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>> Hi Guys, >>>>>>>>>>>>> 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. >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>> Skunkworks mailing list >>>>>>>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>>>>>>> ------------ >>>>>>>>>>>>> List info, subscribe/unsubscribe >>>>>>>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>>>>>>> ------------ >>>>>>>>>>>>> >>>>>>>>>>>>> Skunkworks Rules >>>>>>>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>>>>>>> ------------ >>>>>>>>>>>>> Other services @ http://my.co.ke >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>> Skunkworks mailing list >>>>>>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>>>>>> ------------ >>>>>>>>>>>> List info, subscribe/unsubscribe >>>>>>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>>>>>> ------------ >>>>>>>>>>>> >>>>>>>>>>>> Skunkworks Rules >>>>>>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>>>>>> ------------ >>>>>>>>>>>> Other services @ http://my.co.ke >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Regards >>>>>>>>>>> Felix Mwai >>>>>>>>>>> Software Developer. >>>>>>>>>>> Mobile 0720453684. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Skunkworks mailing list >>>>>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>>>>> ------------ >>>>>>>>>>> List info, subscribe/unsubscribe >>>>>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>>>>> ------------ >>>>>>>>>>> >>>>>>>>>>> Skunkworks Rules >>>>>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>>>>> ------------ >>>>>>>>>>> Other services @ http://my.co.ke >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Best regards, >>>>>>>>>> Odhiambo WASHINGTON, >>>>>>>>>> Nairobi,KE >>>>>>>>>> +254733744121/+254722743223 >>>>>>>>>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >>>>>>>>>> I can't hear you -- I'm using the scrambler. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> Skunkworks mailing list >>>>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>>>> ------------ >>>>>>>>>> List info, subscribe/unsubscribe >>>>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>>>> ------------ >>>>>>>>>> >>>>>>>>>> Skunkworks Rules >>>>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>>>> ------------ >>>>>>>>>> Other services @ http://my.co.ke >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Regards >>>>>>>>> Felix Mwai >>>>>>>>> Software Developer. >>>>>>>>> Mobile 0720453684. >>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Skunkworks mailing list >>>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>>> ------------ >>>>>>>>> List info, subscribe/unsubscribe >>>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>>> ------------ >>>>>>>>> >>>>>>>>> Skunkworks Rules >>>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>>> ------------ >>>>>>>>> Other services @ http://my.co.ke >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Skunkworks mailing list >>>>>>>> Skunkworks@lists.my.co.ke >>>>>>>> ------------ >>>>>>>> List info, subscribe/unsubscribe >>>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>>> ------------ >>>>>>>> >>>>>>>> Skunkworks Rules >>>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>>> ------------ >>>>>>>> Other services @ http://my.co.ke >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Regards >>>>>>> Felix Mwai >>>>>>> Software Developer. >>>>>>> Mobile 0720453684. >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Skunkworks mailing list >>>>>>> Skunkworks@lists.my.co.ke >>>>>>> ------------ >>>>>>> List info, subscribe/unsubscribe >>>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>>> ------------ >>>>>>> >>>>>>> Skunkworks Rules >>>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>>> ------------ >>>>>>> Other services @ http://my.co.ke >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Skunkworks mailing list >>>>>> Skunkworks@lists.my.co.ke >>>>>> ------------ >>>>>> List info, subscribe/unsubscribe >>>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>>> ------------ >>>>>> >>>>>> Skunkworks Rules >>>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>>> ------------ >>>>>> Other services @ http://my.co.ke >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards >>>>> Felix Mwai >>>>> Software Developer. >>>>> Mobile 0720453684. >>>>> >>>>> >>>>> _______________________________________________ >>>>> Skunkworks mailing list >>>>> Skunkworks@lists.my.co.ke >>>>> ------------ >>>>> List info, subscribe/unsubscribe >>>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>>> ------------ >>>>> >>>>> Skunkworks Rules >>>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>>> ------------ >>>>> Other services @ http://my.co.ke >>>> >>>> >>>> >>>> >>>> -- >>>> Best regards, >>>> Odhiambo WASHINGTON, >>>> Nairobi,KE >>>> +254733744121/+254722743223 >>>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >>>> I can't hear you -- I'm using the scrambler. >>>> >>>> >>>> _______________________________________________ >>>> Skunkworks mailing list >>>> Skunkworks@lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>> >>> >>> >>> _______________________________________________ >>> Skunkworks mailing list >>> Skunkworks@lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co.ke >> >> >> >> >> -- >> Regards >> Felix Mwai >> Software Developer. >> Mobile 0720453684. >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks@lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke > > > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254733744121/+254722743223 > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ > I can't hear you -- I'm using the scrambler. > > > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙ Regards, David Njuki @njukey [Google,Twitter,Yahoo] _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- Regards Felix Mwai Software Developer. Mobile 0720453684.

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

---

Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

-- David Maina. P. O. Box 8310-00200, NAIROBI, KENYA.. Cell:+254-721-950073. Registered Linux User #407239. ---------------------------------------------------------------------- "By golly, I'm beginning to think Linux really *is* the best thing since sliced bread." _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke