View Single Post
Old 09-05-2017, 06:53 PM  
porn-update
Confirmed User
 
porn-update's Avatar
 
Industry Role:
Join Date: Apr 2014
Posts: 380
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
porn-update is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote