I am running in a problem here I have a VPS running on Debian 7.0 for a PrestaShop. All was working fine till last night. Today morning it showed me some error stating that there was no disk space to write of mysql.
So I tried to stop and start mysql server. Stopping worked fine, but when i start with following command
sudo /etc/init.d/mysql start or service mysql restart
It is showing me the error
root@hostname:/var/lib/mysql# /etc/init.d/mysql restart Stopping MySQL database server: mysqld. /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! ... failed!
ERROR: The partition with /var/lib/mysql is too full! … failed!
I have also deleted the binary log files directly from /var/log/apache2/error.log: 15G
When i delete the /var/log/apache2/error.log Restart the VPS Make a: “service mysql restart”
All will be working okay again, but after some time (12-24 hr) i get this error on my front page on the shop, then i start all over again.
Link to database cannot be established: SQLSTATE[HY000]  Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
VPS info: Kernel: debain 7.0 x64 vmlinuz-3.2.0-4amd64 (3.2.54-2) VPS: 1GB Ram 20GB SSD Disk Amsterdam 2 System: Prestashop 18.104.22.168
Space: root@hostname:/var/lib/mysql# df -h Filesystem Size Used Avail Use% Mounted on rootfs 20G 19G 0 100% / udev 10M 0 10M 0% /dev tmpfs 101M 128K 101M 1% /run /dev/disk/by-label/DOROOT 20G 19G 0 100% / tmpfs 5.0M 0 5.0M 0% /run/lock tmpfs 201M 0 201M 0% /run/shm
Big file status: /var/cache/apt-xapian-index/index.1/termlist.DB: 32M /var/cache/apt-xapian-index/index.1/postlist.DB: 39M /var/cache/apt/pkgcache.bin: 21M /var/cache/apt/srcpkgcache.bin: 21M /var/lib/apt/lists/mirrors.digitalocean.com_debian_dists_wheezy_main_binary-amd64_Packages: 28M /var/lib/mysql/ibdata1: 106M PS.16_20140826-032405-23a564e4.zip: 403M PS.16_20140826-035510-5cb11788.zip: 42M PS.16_20140826-035410-73745747.zip: 42M PS.16_20140826-035309-4efbed78.zip: 104M PS.16_20140826-033803-65d04df1.zip: 396M PS.16_20140826-035209-7bf5e4d6.zip: 47M PS.16_20140826-033604-2b4f62c0.zip: 376M PS.16_20140826-034207-3fded2c4.zip: 393M PS.16_20140826-032510-2c0a6f8d.zip: 438M PS.16_20140826-035809-9cbc4cc.zip: 74M PS.16_20140826-033711-52fb7dd7.zip: 46M PS.16_20140826-035909-354b837e.zip: 46M /var/www/BackUpS4Yv2.2.zip: 202M /var/log/apache2/error.log: 15G /proc/kcore: 128T
Prestashop system status: Server information Linux #1 SMP Debian 3.2.54-2 x86_64 Server software version Apache/2.2.22 (Debian) PHP version 5.4.4-14+deb7u11 Memory limit 512M Max execution time 1000 MySQL version 5.5.37-0+wheezy1 MySQL engine InnoDB
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $100 of credit to try our products over 60 days!