PHP Script Performance Monitoring
I am looking for a way to compile a performance log of *all* php scripts on my site. It is easy to compile informaiton like execution time with some scripting, but I'd like to gather additional info like average CPU for a particular script.
I am looking on my server at top and see particular scripts being executed and this shows CPU/Memory usage.
If I could have something log what I see in top just prior to the process ending (or so that it tracks the max value for memory and average for CPU?) I thinK I would be happy.
I am trying to find under-performing scripts in my site to enhance perfomance and have no really good tools for helping me find unexpected problem spots.
I don't own the server (sadly) so anything requiring root, etc. may not work for me. I was hoping there was something in the PHP engine itself that I could leverage that tracks and provides this data.
I am looking on my server at top and see particular scripts being executed and this shows CPU/Memory usage.
If I could have something log what I see in top just prior to the process ending (or so that it tracks the max value for memory and average for CPU?) I thinK I would be happy.
I am trying to find under-performing scripts in my site to enhance perfomance and have no really good tools for helping me find unexpected problem spots.
I don't own the server (sadly) so anything requiring root, etc. may not work for me. I was hoping there was something in the PHP engine itself that I could leverage that tracks and provides this data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Regarding this: "... use a query to "flip through" the pages..." - Yes, I think that is the right approach. Quite likely that the MySQL server will cache this stuff after its initial selection and subsequent selects will be faster (even if the actual rows were not in the initial recordset.
I'll be glad to let you pick my brain.
Best, ~Ray
I'll be glad to let you pick my brain.
Best, ~Ray
you can add some monitoring code into you page, logging the $time to database or file
$time / 1 * 100% = One CPU %
$time / 1 * 100% = One CPU %
<?php
$time_start = microtime(true);
// main program start
usleep(10000);// Sleep for a while
// main program end
$time_end = microtime(true);
$time = $time_end - $time_start;
echo "Did nothing in $time seconds\n";
?>
I'm sure I answered at least part of the Q. Never did hear back about the other parts, obviously.
@angelIII: I think this should not be a deletion.
To quote the poster at #24314860, "I think your info is what I expected for the Q and I appreciate hte [sic] time. Points will be credited soon."
Thanks for your consideration,
~Ray
To quote the poster at #24314860, "I think your info is what I expected for the Q and I appreciate hte [sic] time. Points will be credited soon."
Thanks for your consideration,
~Ray
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
Ray,
yes, that was considered.
however, my decision was rather based on:
>The information you posted is good, but the trouble is with my host I don't have root access and most of these things aren't available.
and I think the only real suggestion would have been to change each script individually to store the execution time in a database ...
your suggestions were either too general, or steps for the the actual troubleshooting of a concrete problem, rather than to identify the scripts/pages that actually have most problems.
a3
yes, that was considered.
however, my decision was rather based on:
>The information you posted is good, but the trouble is with my host I don't have root access and most of these things aren't available.
and I think the only real suggestion would have been to change each script individually to store the execution time in a database ...
your suggestions were either too general, or steps for the the actual troubleshooting of a concrete problem, rather than to identify the scripts/pages that actually have most problems.
a3
OK, not a big issue for me. Our OP said both of those things in the same post, so I can see it either way. But I can't see what your logic is until after I post an objection. Sorry if it was an unnecessary exercise. ~Ray
>Sorry if it was an unnecessary exercise. ~Ray
not unnecessary. I have the trouble in the CV tool that I cannot give additional comments, unless I open the question and post a additional comment.
which is usually not needed.
I understand that these questions are frustrating for us experts.
a3
not unnecessary. I have the trouble in the CV tool that I cannot give additional comments, unless I open the question and post a additional comment.
which is usually not needed.
I understand that these questions are frustrating for us experts.
a3
10-4. Best regards, ~Ray
ASKER
Thank you for the input, it is a daunting topic and the response did little to whittle down where I should spend my time. As a part-time developer, I have yet to find the time to delve as deeply into the topic as I need in order to even decide if this is a solution. I apologize for the delay, but some people in the EE community are not full timers and need time to digest complicated subjects.
I have no idea if this is a solution, but rather than be labeled as an "irresponsible EE member" I'll just post the points. Sheesh.
I have no idea if this is a solution, but rather than be labeled as an "irresponsible EE member" I'll just post the points. Sheesh.
ASKER
I'm going to look into doing something "rough" like top logging and try to get a view of the trouble spots with that, but we will see...
Good info and good tips on the sql queries. The only one jumps out at me is the limit by clause comment. I have a table with 3600+ records. The user view is a paginated 30-per-page gallery view of that data. I currently use a query to "flip through" the pages with a limit statement.
Is there a better way? At least query-wise?
If I can impose on you for a few thoughts on this I would appreciate it. I think your info is what I expected for the Q and I appreciate hte time. Points will be credited soon.