Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to tell the cpu time that a mysql query consumes?

Status
Not open for further replies.
lcs01

lcs01

Programmer
Aug 2, 2006
182
US
As stated in the subject line, I am looking for a way to find out how much cpu time a query consumes.

Could someone tell me how?

Many thanks!
 
Sort by date Sort by votes
I don't know of any SQL way to do it, but some API's have functions to return information about the latest query, which may include time taken. In the C API, the mysql_info function returns information about update/insert/alter queries, but not for selects. However, it's probably clock time that gets reported, not CPU time.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
227
EdZzy
E
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
511
EdLentz
EdLentz
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
443
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
402
Chris Miller
Chris Miller
EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
376
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top