A way to see which resource consumes the most?

[John_Dipster]

Hi all,
Is there a way to see which resource consumes the most of CPU/RAM ?
Getting a lot of boring “Server thread hitch warning : timer interval of xxx milliseconds” that i’d like to correct.
Thx guys

[TheIndra]

This topic might help (traces part)

Speeding up your Server 101 (Windows)

Speeding up your Server 101 (Windows) Setup Tools used in this 101 UIforETW, we will use this profiler to generate a trace of the for the server. mysql-async 3.0.7 or newer. Running with the set mysql_slow_query_warning 50 line in the server.cfg HeidiSQL, because it is visually well-designed for us to improve database structures. Links randomasciis’s etw package This should install the Windows Performance and Assessment Toolkit. HeidiSQL, just to visually represent your database. Findi…

[John_Dipster]

Thanks , will take a look to it

[John_Dipster]

thx it works, if I upgrade my server 6gb RAM and 4x3ghz cpu to more this will decrease this hitch warning ? Is there a way to disable this message from console or set it to alert only when more than 400 milliseconds ?