Thread:Talk:Hosting services/1 and 1

For whatever reason servers on 1 and 1 allocate only 4G memory to the var partition. Mysql is usually located in /var. Attempts to load backup .sql files or to populate the tables in mysql will result in full files and failure. "df -h" then produces this result: [user]# sudo df -h Filesystem           Size  Used Avail Use% Mounted on /dev/mapper/vg00-var  4.0G  4.0G     0 100% /var

There is also a shortage of inodes, only 262144. Each thumbnail in your images directory will take one inode...

The solution, which has worked with Ubuntu and Centos on 1&1, is to resize the partition: sudo lvextend -L +46G /dev/mapper/vg00-var Extending logical volume var to 50.00 GiB Logical volume var successfully resized

Then: [user]# sudo resize2fs /dev/mapper/vg00-var resize2fs 1.41.12 (17-May-2010) Filesystem at /dev/mapper/vg00-var is mounted on /var; on-line resizing required old desc_blocks = 1, new_desc_blocks = 4 Performing an on-line resize of /dev/mapper/vg00-var to 13107200 (4k) blocks. df The filesystem on /dev/mapper/vg00-var is now 13107200 blocks long.

[user]# df Filesystem          1K-blocks      Used Available Use% Mounted on /dev/mapper/vg00-var  51606140   4133400  44851892   9% /var

[user]# df -i Filesystem           Inodes   IUsed   IFree IUse% Mounted on /dev/mapper/vg00-var 3276800   42688 3234112    2% /var

This problem may manifest as a mysql error such as "ERROR 1114 (HY000) at line 9061: The table 'hrtext' is full" which gives a bad clue as you might think something has to be done about how mysql is configured when the actual problem is lack of allocated disc space.