When login
Code:
System information as of Wed Sep 6 01:25:04 UTC 2017
System load: 0.75 Processes: 116
Usage of /: 36.5% of 39.34GB Users logged in: 0
Memory usage: 21% IP address for eth0: 139.59.71.64
Swap usage: 0%
Code:
root@ubuntu-2gb-blr1-14-04-3:~# df
Filesystem 1K-blocks Used Available Use% Mounted on
udev 1019956 12 1019944 1% /dev
tmpfs 204988 376 204612 1% /run
/dev/vda1 41251136 15058276 24484420 39% /
none 4 0 4 0% /sys/fs/cgroup
none 5120 0 5120 0% /run/lock
none 1024936 0 1024936 0% /run/shm
none 102400 0 102400 0% /run/user
root@ubuntu-2gb-blr1-14-04-3:~#
My sites have practically only external images.
I have however MySQL tables with hundreds of thousands of lines.
I also use this type of query for the research:
Code:
$query_photo = "SELECT SQL_CALC_FOUND_ROWS ".$select_fields.", MATCH(title, description) AGAINST('".trim(addslashes($_GET['query']))."') as score FROM ".$prefix."photo WHERE MATCH(title, description) AGAINST('".trim(addslashes($_GET['query']))."') ".$sort_by." DESC LIMIT ".$start.", ".$step."";
Everyone says better search, more precise, etc. etc., but this type of query forces you to create indexes in databases with hundreds of thousands of rows... maybe they can cause excessive consumption of MySQL, CPU, disk, etc?
I also use APCU, memcached and Opcache, can they create the problem?
I did zip even with sudo, same result
Code:
root@ubuntu-2gb-blr1-14-04-3:~# sudo apt-get install zip
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be upgraded:
zip
1 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.
1 not fully installed or removed.
Need to get 0 B/262 kB of archives.
After this operation, 603 kB of additional disk space will be used.
(Reading database ... 64067 files and directories currently installed.)
Preparing to unpack .../archives/zip_3.0-8_amd64.deb ...
Unpacking zip (3.0-8) over (3.0-8) ...
dpkg: error processing archive /var/cache/apt/archives/zip_3.0-8_amd64.deb (--unpack):
unable to create `/usr/bin/zip.dpkg-new' (while processing `./usr/bin/zip'): No space left on device
No apport report written because the error message indicates a disk full error
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
Errors were encountered while processing:
/var/cache/apt/archives/zip_3.0-8_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@ubuntu-2gb-blr1-14-04-3:~#
Today is the first day that I see these errors, until yesterday the sites worked properly and the server has always installed without problems