Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You could use <code>memory_get_usage</code> (http://php.net/manual/en/function.memory-get-usage.php) when you think the process is at its peak.</p> <p>Or you could also just call it occasionally and record whatever was the highest value... or as you please.</p> <p>But this is within a process. Are you talking about a PHP process "A" checking another PHP process' memory usage?</p> <p>If so:</p> <pre><code>$myPID = getmypid(); $stats = explode("\n", shell_exec('pmap $(pgrep php) | grep \'total\\|\\:\'')); for ($i = 0; $i &lt; count($stats); $i += 2) { if (strpos($stats[$i], "$myPID") === false) { preg_match('/\d+/', $stats[$i+1], $preRes); $res = $preRes[0]; } } //if $res has a value, that value is the kilobytes of memory being used by the other PHP process </code></pre> <p>This solution has a problem: if you have more than 2 php processes running total, you can't guarantee that you will be getting the right process.</p> <p>To solve this, run first the other process, obtain its PID and then pass it as argument to this process. If you have the process' PID you want to check, you could just do this:</p> <pre><code>$stats = explode("\n", shell_exec('pmap $(pgrep php) | grep \'total\\|\\:\'')); for ($i = 0; $i &lt; count($stats); $i += 2) { if (strpos($stats[$i], "$otherPID") === 0) { preg_match('/\d+/', $stats[$i+1], $preRes); $res = $preRes[0]; } } //$res contains the result you want in kilobytes </code></pre> <p>You could check the memory for all processes that are not you, too:</p> <pre><code>$myPID = getmypid(); $stats = explode("\n", shell_exec('pmap $(pgrep php) | grep \'total\\|\\:\'')); for ($i = 0; $i &lt; count($stats) - 1; $i += 2) { if (strpos($stats[$i], "$myPID") === false) { preg_match('/\d+/', $stats[$i+1], $preRes); $res[] = $preRes[0]; } } </code></pre> <p>So to get the maximum memory usage, just keep a $max variable and keep checking against it.</p>
    singulars
    1. This table or related slice is empty.
    1. POIn PHP, how to check how much memory a certain loop is using
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMamsaac
    1. USMamsaac
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIn PHP, how to check how much memory a certain loop is using
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI updated the question with my code, yes I'm talking about process A checking process B's memory usage.
      singulars
      1. PO
      1. USgreduan
    2. CODoes it have to be done using PHP? If yes, will it run on a Linux OS or under Windows?
      singulars
      1. PO
      1. USMamsaac
    3. COYes it has to be PHP, it's not gonna run on Windows, it's gonna run on UNIX, and it's not gonna run on a Mac OS X server. That's what I know.
      singulars
      1. PO
      1. USgreduan
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload