lkml.org 
[lkml]   [2002]   [Sep]   [25]   [last100]   RSS Feed
Views: [wrap][no wrap]   [headers]  [forward] 
 
Messages in this thread
    /
    From
    SubjectRe: Very High Load, kernel 2.4.18, apache/mysql
    Date
    The big question is - why that much CPU usage?

    Possible answers:
    * PHP, mySQL, Apache - needs that amount of CPU to perform the requested
    function.
    (you have got suggestions from others)

    * The implementation if either has bugs that cause the CPU usage. Garbage
    collection? Ineffective algorithms?
    - Not much to do other than collecting execution profiles, quite advanced -
    recompiling of the tools will probably be needed... And probably help from
    the tools developers...

    * The implementation of the user code has bugs that cause the CPU usage.
    One example:
    SQL SELECT with unindexed data - this can usually be noticed as buffer in load
    in vmstat but since all data fits in memory - it would cause scans in memory,
    with lots of RAM cache misses... And it would work well as long as the
    scanned data was smaller than the CPU cache?
    - Suggestion: Review your index keys and select statements to make sure that
    they match!

    /RogerL
    -
    To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
    the body of a message to majordomo@vger.kernel.org
    More majordomo info at http://vger.kernel.org/majordomo-info.html
    Please read the FAQ at http://www.tux.org/lkml/

    \
     
     \ /
      Last update: 2005-03-22 13:29    [W:0.095 / U:121.172 seconds]
    ©2003-2016 Jasper Spaans. hosted at Digital OceanAdvertise on this site