How many processes have I used?

tcp

I am thinking about server load. I am getting warnings from my hosting company that my site is using up too much resources. I have more than enough disk space and bandwidth capacity. It appears memory and cpu usage are at issue. I am limited to 25 simultaneous processes. I don't really know what that means. They are pointing their finger at my PHP and MySQL usage. The script below gives 150 results. INn my script, I also include a second MySQL query the same as below except rewrite the SELECT statement and instead of wildcard use COUNT(*) the result is 150. How many processes have I used here? Is a "process" the same as a "connection"?


$sql = "SELECT * FROM sales WHERE state = '$state'";
			$result = mysql_query($sql);

		if ($myrow = mysql_fetch_array($result)) {

			do {

				$product_id = $myrow["product_id"];
				$seller_id = $myrow["seller_id"];
				$type = $myrow["type"];

			} while ($myrow = mysql_fetch_array($result));

			} else {

				echo "No records found!";

			}

johanafm

tcp;10987175 wrote:
and bandwidth capacity. It appears memory and cpu usage are at issue. I am limited to 25 simultaneous processes. How many processes have I used here?

Impossible to say. If you have multiple threads per process, with each thread handling one connection, you have used up no additional process (just using a new thread in an existing process), but you may have started using one more process,

tcp;10987175 wrote:
Is a "process" the same as a "connection"?

Possibly. You will have either one process per connection or one thread per connection, and depends on the web server and its configuration.

Apache, for example, can be configured to go either way.

tcp;10987175 wrote:
I don't really know what that means.

You can most likely google "difference between thread and process" or "difference between child process and thread".

tcp;10987175 wrote:
They are pointing their finger at my PHP and MySQL usage.

This can definitely be the cause. A common area of inefficiency is database usage. Inefficiently written queries and lack of proper indexing can seriously degrade performance. If each page requests takes 5 seconds and you get 10 new page requests every second, then you will actually have 50 concurrent requests running, whereas if each page request took < 1 second, you'd have no more than 10 concurrent requests.

$start = microtime(true);
$result = mysql_query($sql);
$time = microtime(true) - $start;
echo 'Query execution: ' . $time;

You can always use microtime() before and after you execute any particular statement or group of statements to find out how long it takes to execute. You might want to do the same thing for the entire script(s) as well. This way you'll find out how much time is spent both overall and in different places and start working on improviing efficiency.