StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODownload script using php-fpm/Nginx Causes High Load CPU
primarykey
Id
20022966
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-11-16T19:44:38.627
FavoriteCount
1
LastActivityDate
2017-05-27T10:24:47.773
LastEditDate
LastEditorUserId
0
OwnerUserId
1447267
ParentId
0
PostTypeId
1
Score
0
ViewCount
725
LastEditorDisplayName
text
Body
I have a good server for a file sharing use, and I am having trouble with the download script. I use PHP-FPM running on nginx. The server specs: <pre><code>2x Intel Xeon E5 CPU: 92GB RAM 10x2TB (RAID6) And we use 1 SSD disk for CashCade </code></pre> When I apllay this script on apache server, it works fine, but I want to run it on nginx server, because apache takes a lot of memory. (RAM) But when I run this script on nginx, something really wired is happening - it takes 30% from the CPU, only one download! Please note that after 3-4 minutes from the begining of the download, the CPU load is go back to normal (but the download continiues). This is the "TOP" in LINUX When im downloading... <img src="https://i.stack.imgur.com/G25Z9.jpg" alt="When I'm Downloading"> I don't know why, but the PHP-FPM script is taking a lot from the CPU. The script: <pre><code>class ResumeDownload { private $file; private $name; private $boundary; private $delay = 0; private $size = 0; function __construct($file, $delay = 0) { if (! is_file($file)) { header("HTTP/1.1 400 Invalid Request"); die("<h3>File Not Found</h3>"); } $this->size = filesize($file); $this->file = fopen($file, "r"); $this->boundary = md5($file); $this->delay = $delay; $this->name = basename($file); } public function process() { $ranges = NULL; $t = 0; if ($_SERVER['REQUEST_METHOD'] == 'GET' && isset($_SERVER['HTTP_RANGE']) && $range = stristr(trim($_SERVER['HTTP_RANGE']), 'bytes=')) { $range = substr($range, 6); $ranges = explode(',', $range); $t = count($ranges); } header("Accept-Ranges: bytes"); header("Content-Type: application/octet-stream"); header("Content-Transfer-Encoding: binary"); header(sprintf('Content-Disposition: attachment; filename="%s"', $this->name)); if ($t > 0) { header("HTTP/1.1 206 Partial content"); $t === 1 ? $this->pushSingle($range) : $this->pushMulti($ranges); } else { header("Content-Length: " . $this->size); $this->readFile(); } flush(); } private function pushSingle($range) { $start = $end = 0; $this->getRange($range, $start, $end); header("Content-Length: " . ($end - $start + 1)); header(sprintf("Content-Range: bytes %d-%d/%d", $start, $end, $this->size)); fseek($this->file, $start); $this->readBuffer($end - $start + 1); $this->readFile(); } private function pushMulti($ranges) { $length = $start = $end = 0; $output = ""; $tl = "Content-type: application/octet-stream\r\n"; $formatRange = "Content-range: bytes %d-%d/%d\r\n\r\n"; foreach ( $ranges as $range ) { $this->getRange($range, $start, $end); $length += strlen("\r\n--$this->boundary\r\n"); $length += strlen($tl); $length += strlen(sprintf($formatRange, $start, $end, $this->size)); $length += $end - $start + 1; } $length += strlen("\r\n--$this->boundary--\r\n"); header("Content-Length: $length"); header("Content-Type: multipart/x-byteranges; boundary=$this->boundary"); foreach ( $ranges as $range ) { $this->getRange($range, $start, $end); echo "\r\n--$this->boundary\r\n"; echo $tl; echo sprintf($formatRange, $start, $end, $this->size); fseek($this->file, $start); $this->readBuffer($end - $start + 1); } echo "\r\n--$this->boundary--\r\n"; } private function getRange($range, &$start, &$end) { list($start, $end) = explode('-', $range); $fileSize = $this->size; if ($start == '') { $tmp = $end; $end = $fileSize - 1; $start = $fileSize - $tmp; if ($start < 0) $start = 0; } else { if ($end == '' || $end > $fileSize - 1) $end = $fileSize - 1; } if ($start > $end) { header("Status: 416 Requested range not satisfiable"); header("Content-Range: */" . $fileSize); exit(); } return array( $start, $end ); } private function readFile() { while ( ! feof($this->file) ) { echo fgets($this->file); flush(); usleep($this->delay); } } private function readBuffer($bytes, $size = 1024) { $bytesLeft = $bytes; while ( $bytesLeft > 0 && ! feof($this->file) ) { $bytesLeft > $size ? $bytesRead = $size : $bytesRead = $bytesLeft; $bytesLeft -= $bytesRead; echo fread($this->file, $bytesRead); flush(); usleep($this->delay); } } } </code></pre> And the <code>download.php</code> (where I run the script) <pre><code>// ... some code that get the file details from extrenal Database... $fileArr = $query->fetch_assoc(); $file = 'uploads/' . $download['fileid'] . '/' . $fileArr['name']; if(file_exists($file)) { $mysqli->close(); require 'class.download.php'; set_time_limit(0); $download = new ResumeDownload($file, 0); //delay about in microsecs $download->process(); } </code></pre>
Tags
<nginx><download><php>
Title
Download script using php-fpm/Nginx Causes High Load CPU
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USHtmHell
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PODownload script using php-fpm/Nginx Causes High Load CPU
 UserUserId
 USuser2945583
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. COpossible duplicate of [PHP download script takes a lot of CPU](http://stackoverflow.com/questions/20021277/php-download-script-takes-a-lot-of-cpu)
 singulars
 PostPostId
 PODownload script using php-fpm/Nginx Causes High Load CPU
 UserUserId
 USMohammad AbuShady

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.