1666
Users / Re: [SOLVED] - UpdateMedia mysql queries takes 100% CPU on a core - is that normal ?
« on: November 18, 2009, 01:39:50 am »
Predominantly my Windows Orbiter.
The behaviour:
device, time uncached, time cached
WinOrbiter, ~7s, <1s (UI1)
Nokia N800, ~10s, ~3s (UI1)
WebDT 366, ~7s, ~2s (UI1)
p42.8 Core, ~7s, <1s (UI2 mask)
Zotac ION MD, ~7, <1s (UI2 mask)
When the query is executed and not present in the cache, top shows mysql using 90-100% of the processor for nearly the entire 7s time period, and it doesn't even show up as a blip in top when the query is in the cache. I'm about to investigate some of the slow query logging options Viking pointed out and see what I can find out.
J.
The behaviour:
device, time uncached, time cached
WinOrbiter, ~7s, <1s (UI1)
Nokia N800, ~10s, ~3s (UI1)
WebDT 366, ~7s, ~2s (UI1)
p42.8 Core, ~7s, <1s (UI2 mask)
Zotac ION MD, ~7, <1s (UI2 mask)
When the query is executed and not present in the cache, top shows mysql using 90-100% of the processor for nearly the entire 7s time period, and it doesn't even show up as a blip in top when the query is in the cache. I'm about to investigate some of the slow query logging options Viking pointed out and see what I can find out.
J.