Assuming you are on a shared server with very limited access to logs and reports...
Is there a way for someone to test mysql response time on a shared linux server? In other words, you think the response time is way too long, the host says its fine. Is there something a client can use to test response/load time?
That would show the response time / load time for the page, not for a mysql query. There could be big differences.
@stlrsfan, you an try the benchmark function. You can also check the profiling. Both are best to be used via mysql client. You could use a PHP script with microtime on either side, but PHP slowness could cause inaccuracies .
-Steven | u2-web, LLC - Clustered Shared Hosting "It is the mark of an educated mind to be able to entertain a thought without accepting it" -Aristotle