1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Mysql console client reported time meaning

Discussion in 'MySQL' started by onlywin, Apr 26, 2013.

  1. #1
    Hi,

    I'm wondering what's the meaning of the elapsed time reported after each query using MySql console client.

    For example, after a select you get a response like this:
    24 rows in set (0.26 sec)
    Code (markup):
    Do you know what are that seconds? If it means the time needed by the MySql server to generate the results? to generate and deliver the results? anything more?

    Thanks
     
    Solved! View solution.
    onlywin, Apr 26, 2013 IP
  2. #2
    The time reported includes the server time to generate the results and send them to the client too. So there are network times included.

    Here's an interesting question related with this: http://stackoverflow.com/questions/15957424/mysql-innodb-table-strange-select-lock-timeout
     
    goproxy, Apr 30, 2013 IP
  3. onlywin

    onlywin Greenhorn

    Messages:
    97
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #3
    thanks goproxy, that answers my question pretty much, I can't find official documentation about that, but your answer and example looks good enough for me
     
    onlywin, May 1, 2013 IP