Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

General: Scans are at 100% in idle mode

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorthowa
    • CommentTimeSep 3rd 2010
     
    I have realized that Scans (Full Table scans percentage) it increasing to fully reach 100% after recording starts.
    The description says "try stay below 20%".

    How shall I do that?

    Best Regards,
    thowa
  2.  
    If your database is idle (say 0-1 % cpu), then you should not pay too much attention to the table scans percentage. Any figures will bi distorted by the low load and the polling queries used by Jet Profiler.

    If you see high table scans percentage during reasonable or high load, you should check your top queries. The explain rating should then reveal which queries have full table scans.

    Thanks,
    Bjorn

1 to 2 of 2

  1.