Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

SUMMARY: performance of LAMP-system

by bjelli (Pilgrim)
on Dec 13, 2001 at 16:37 UTC ( #131601=note: print w/replies, xml ) Need Help??

in reply to performance of LAMP-system

Thanks to all of you. Here's a quick summary of the answers I got:

performance problems in a LAMP system

The problem could be located in one or more components:

  1. hardware/os
  2. apache
  3. mysql
  4. the application itself

    the usual suspects are the application itself (bad SQL code, inefficient Perl code) and the database (badly laid out database tables on physical spindles)

    check: CPU utilization, physical RAM/Swap utilization, network bandwidth and disk spindle utilization time.
    tools: vmstat, mpstat, top,...
    links: Apache Performance Tuning
    tools: the mysql slow log, DBIx::Profile
    links: linuxmag article on mysql performance tuning
    the application itself
    tools: Devel::DProf, Apache::DProf

2001-12-13 Edit by Corion : Added missing <OL> tag

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://131601]
[james28909]: but i dont really know what your end goal is. if it works dont fix it lol
[Lady_Aleena]: james28909, I use get_data in a subroutine called movies.
[Lady_Aleena]: james28909, I put it at the top of my scratchpad, if you want to look at it.

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (6)
As of 2017-05-24 04:33 GMT
Find Nodes?
    Voting Booth?