Member Avatar for jacob21

Hi,
I want to check query execution time.
I used microtime(),time() but not getting accurate result.
I also read about mysql slow_query_log but not able to find how to change settings in PHPmyadmin.
Need suggestions

  • 2 Contributors
  • 3 Replies
  • 165 Views
  • 19 Minutes Discussion Span
  • Latest Post Latest Post by pritaeas
moehhammadfaizalpratama commented: dsd +0
Member Avatar for pritaeas

If your MySQL server is on a (shared) webhost, you may not have permissions to change any settings. Contact your host.

Timing from a PHP script is inaccurate, because it will include the time of data transfer (very variable).

Member Avatar for jacob21

Thanks pritaeas,
I am using shared webhost.
Is there any (accurate)method to find out query execution time.??

Member Avatar for pritaeas

You can try EXPLAIN, but it's resolution isn't high (1/100 secs).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.