mysql - Confusing output from time -


This command receives some data from MySQL and then changes it. The 'real time' time from the 'user' time is so high Why is that?

  & gt; Time ./command.rb Real 45m45.457s user 3m36.478s sys 0m28.226s  

For clarification - I understand the difference between real, user and system output. However, I am confused about why such a big difference is on the machine I am running on it, actually using the CPU is nothing else, and I do not have any threading in my order. All this data Does a complex MySQL statement take such a difference?

The user and the system report the time the CPU is busy. Try anything when the network will not be busy when blocking like network or disk I / O, for example, "Time sleep 1", or "Time DD if = / dev / zero of = / dev / null BS = 1024 count = 1000000 "to see the difference The first will be just blocks, the second will include a lot of CPU usage.


Comments

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

php - Multiple Select with Explode: only returns the word "Array" -

php - jQuery AJAX Post not working -