Knowledgebase
Portal Home > Knowledgebase > Articles Database > CPU Time usage
CPU Time usage
Posted by DevMonkey, 06-02-2009, 04:30 PM Hi I'm just wondering what exactly "CPU Time" is, I have searched Google and checked Wikipedia but still do not really understand. The main reason this is bugging me is that MySQL on our database server seems to have a very high "CPU Time" usage. This is the top part of the output from "top", with MySQL shown: Is this usage really bad, what does it actually tell me? Thanks
Posted by ZenMonk, 06-03-2009, 09:10 AM Basically go by the simple formulae of runtime(time spend consuming cpu cycles)/elapsed time(time spend on cpu cycles+iowait+sleep time etc)* 100 would give you an approx % cpu utilization. High cpu% value for mysql indicates that your mysql daemon is pretty active. ..Try mysqladmin proc stat It should give you an idea of mysql threads connections and related activities.
Posted by ServerManagement, 06-03-2009, 10:15 AM You should take a look at the mysql queries to see what is going on, just type "mysqladmin proc" in ssh. That will show you if anyone is overloading or abusing mysql.
Add to Favourites Print this Article
Also Read