Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm trying to diagnose a server where the website is loading very slowly, but unfortunately my client has only provided me with FTP access.

I've got FTP access so I can upload PHP scripts, but can't set up any other server side tools.

I have access to phpMyAdmin, but not direct access to the MySQL server. It is also unfortunately a Windows server (and we've been a Linux shop for over a decade now).

So, if I wan to evaluate MySQL & disk speed performance through PHP on a generic server, what is the best way to do this?

There are already tools like: https://github.com/raphaelm/php-benchmark or https://github.com/InfinitySoft/php-benchmark

But I'm surprised there isn't something that someone has already set up & configured to just run through and do some basic testing of a server's responsiveness.

Every time we evaluate a new server environment it's handy to be able to compare it to an existing one quickly to see if there are any anomalies. I guess I'd just hoped that someone else had written up a script to do this already. I know I have, but that was before Github when there was a handy place to post scraps of code like this.

Originally posted in http://stackoverflow.com/questions/12321498/php-mysql-performance-testing-with-just-php but it was recommended that I re-post it here.

share|improve this question

closed as not constructive by John Gardeniers, Scott Pack, Ladadadada, Iain Oct 6 '12 at 14:25

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

add comment

1 Answer

If you want to run real diagnostics you're going to need proper access. There's no getting around that and you need to convey that message to the client. Any results you might get by scripting through a web server, be it IIS, Apache or anything else, will not give you meaningful results because you have no way of knowing what other layers or processes are involved.

Once you have benchmarks for the underlying system you can run some crude benchmarks on MySQl but only when you specify the conditions and create an appropriate testing script. Right now you would have no way of knowing why any particular query might be slow because you can't know at which point that slowness was caused.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.