CODEWITHSUNDEEP
phpmysqlperformancemultithreading
Ali
Ali

Reputation: 267077

Speeding up a PHP App

I have a list of data that needs to be processed. The way it works right now is this:

This takes way too long. What I'd like instead is that:

Is something like this possible?

I was thinking that I use CRON to launch an instance of the script every second. All items that need to be processed will be flagged as such in the MySQL database, so whenever an instance is launched through CRON, it will simply take the next item flagged to be processed and remove the flag.

Thoughts?

Edit: To clarify something, each 'item' is stored in a mysql database table as seperate rows. Whenever processing starts on an item, it is flagged as being processed in the db, hence each new instance will simply grab the next row which is not being processed and process it. Hence I don't have to supply the items as command line arguments.

Upvotes: 2

Views: 490

Answers (7)

sfrench
sfrench

Reputation: 910

To solve this problem, I've used two different products; Gearman and RabbitMQ.

The benefit of putting your jobs into some sort of queuing software like Gearman or Rabbit is that you have multiple machines, they can all participate in processing items off the queue(s).

Gearman is easier to setup, so I'd suggest poking around with it a bit first. If you find you need something more heavy duty with queue robustness; Look into RabbitMQ

Upvotes: 0

rook
rook

Reputation: 67019

If you are running a high traffic PHP server you are INSANE if you do not use Alternative PHP Cache: http://php.net/manual/en/book.apc.php . You do not have to make code modifications to run APC.

Another useful technique that can work along with APC is using the Smarty template system which allows you to cache output so that pages do not have to be rebuilt.

Upvotes: 0

Don Dickinson
Don Dickinson

Reputation: 6258

can you implementing threading in javascript on the client side? seems to me i've seen a javascript library (from google perhaps?) that implements it. google it and i'm sure you'll find something. i've never done it, but i know its possible. anyway, your client-side javascript could activate (ajax) a php script once for each item in separate threads. that might be easier than trying to do it all on the server side.

-don

Upvotes: 1

Mike
Mike

Reputation: 2593

Here's one solution, not the greatest, but will work fine on Linux:

Split the processing PHP into a separate CLI scripts in which:

  • The command line inputs include `$id` and `$item`
  • The script writes its PID to a file in `/tmp/$id.$item.pid`
  • The script echos results as XML or something that can be read into PHP to stdout
  • When finished the script deletes the `/tmp/$id.$item.pid` file

Your master script (presumably on your webserver) would do:

  • `exec("nohup php myprocessing.php $id $item > /tmp/$id.$item.xml");` for each item
  • Poll the `/tmp/$id.$item.pid` files until all are deleted (sleep/check poll is enough)
  • If they are never deleted kill all the processing scripts and report failure
  • If successful read the from `/tmp/$id.$item.xml` for format/output to user
  • Delete the XML files if you don't want to cache for later use

A backgrounded nohup started application will run independent of the script that started it.

This interested me sufficiently that I decided to write a POC.

test.php

<?php
$dir =  realpath(dirname(__FILE__));
$start = time();

// Time in seconds after which we give up and kill everything
$timeout = 25;

// The unique identifier for the request
$id = uniqid();

// Our "items" which would be supplied by the user
$items = array("foo", "bar", "0xdeadbeef");

// We exec a nohup command that is backgrounded which returns immediately
foreach ($items as $item) {
    exec("nohup php proc.php $id $item > $dir/proc.$id.$item.out &");
}

echo "<pre>";
// Run until timeout or all processing has finished
while(time() - $start < $timeout) 
{
  echo (time() - $start), " seconds\n";
  clearstatcache();    // Required since PHP will cache for file_exists
  $running = array();
  foreach($items as $item)
  {
      // If the pid file still exists the process is still running    
      if (file_exists("$dir/proc.$id.$item.pid")) {
          $running[] = $item;
      }
  }
  if (empty($running)) break;
  echo implode($running, ','), " running\n";
  flush();
  sleep(1);  
}

// Clean up if we timeout out
if (!empty($running)) {
    clearstatcache();
    foreach ($items as $item) {
        // Kill process of anything still running (i.e. that has a pid file)
        if(file_exists("$dir/proc.$id.$item.pid") 
            && $pid = file_get_contents("$dir/proc.$id.$item.pid")) {
            posix_kill($pid, 9);                
            unlink("$dir/proc.$id.$item.pid");
            // Would want to log this in the real world
            echo "Failed to process: ", $item, " pid ", $pid, "\n";
    }
    // delete the useless data
    unlink("$dir/proc.$id.$item.out");
    }
} else {
    echo "Successfully processed all items in ", time() - $start, " seconds.\n";
    foreach ($items as $item) {
    // Grab the processed data and delete the file
        echo(file_get_contents("$dir/proc.$id.$item.out"));
        unlink("$dir/proc.$id.$item.out");
    }
}
echo "</pre>";
?>

proc.php

<?php
$dir =  realpath(dirname(__FILE__));
$id = $argv[1];
$item = $argv[2];

// Write out our pid file
file_put_contents("$dir/proc.$id.$item.pid", posix_getpid());

for($i=0;$i<80;++$i)
{
    echo $item,':', $i, "\n";
    usleep(250000);
}

// Remove our pid file to say we're done processing
unlink("proc.$id.$item.pid");

?>

Put test.php and proc.php in the same folder of your server, load test.php and enjoy.

You will of course need nohup (unix) and PHP cli to get this to work.

Lots of fun, I may find a use for it later.

Upvotes: 6

Cody Caughlan
Cody Caughlan

Reputation: 32748

Use an external workqueue like Beanstalkd which your PHP script writes a bunch of jobs too. You have as many worker processes pulling jobs from beanstalkd and processing them as fast as possible. You can spin up as many workers as you have memory / CPU. Your job body should contain as little information as possible, maybe just some IDs which you hit the DB with. beanstalkd has a slew of client APIs and itself has a very basic API, think memcached.

We use beanstalkd to process all of our background jobs, I love it. Easy to use, its very fast.

Upvotes: 5

mr-sk
mr-sk

Reputation: 13407

You can use pcntl_fork() and family to fork a process - however you may need something like IPC to communicate back to the parent process that the child process (the one you fork'd) is finished.

You could have them write to shared memory, like via memcache or a DB.

You could also have the child process write the completed data to a file, that the parent process keeps checking - as each child process completes the file is created/written to/updated, and parent process can grab it, one at a time, and them throw them back to the callee/client.

The parent's job is to control the queue, to make sure the same data isn't processed twice and also to sanity check the children (better kill that runaway process and start over...etc)

Something else to keep in mind - on windows platforms you are going to be severely limited - I dont even think you have access to pcntl_ unless you compiled PHP with support for it.

Also, can you cache the data once its been processed, or is it unique data every time? that would surely speed things up..?

Upvotes: -1

sberry
sberry

Reputation: 132018

There is no multithreading in PHP, however you can use fork.

php.net:pcntl-fork

Or you could execute a system() command and start another process which is multithreaded.

Upvotes: 1

Related Questions