Craig Lawson wrote:[color=blue]
> Ok - i am posting more details on our problem....
>
> The server is running the Ensim management software this is where the[/color]
Python[color=blue]
> threads were comming from.
>
> Looking closer i have a hunch its mysql related, and/or a recent[/color]
changed[color=blue]
> script causing the problem.
>
> Our mySql config is real simple however and there are no innodb[/color]
tables in[color=blue]
> any of the databases runinng on the server, so i dont think its[/color]
innodb[color=blue]
> related, however i am looking into removing innodb support support[/color]
from my[color=blue]
> mysql server if nothing turns up from the alalysis of all changed[/color]
scripts.[color=blue]
>
> It may simply be a performance issue as the server is now pushing[/color]
upto 2000[color=blue]
> sessions daily, and at times i have seen 500 sessions open in the[/color]
/tmp[color=blue]
> directory.[/color]
Probably that might be the reason for session to fail--as there may
not be any room for the session files to be created. The quick
workaround would be switching to DB based session handler--but that
will hit DB load.
[color=blue]
> Any tips on how to tune LAMP server to maximise performance would be
> apreaciated - or tips on where else we should be looking to cure this[/color]
[color=blue]
> problem.[/color]
If the problem is related to MySQL, you may try some caching
solutions
<http://groups.google.com/groups?selm=1111430495.275366.42540%40z14g2000cwz. googlegroups.com>
I would also recommend "High Performance MySQL" by Jeremy et al.
<http://www.oreilly.com/catalog/hpmysql/>
[color=blue]
> Unfortunately we have no control on the hardware, which consists of[/color]
256mb of[color=blue]
> ram, 40gb drive and 2ghz processor. Therefore performace[/color]
optomisations need[color=blue]
> to remain around the configuration of the services.[/color]
To analyze the bottlenecks, you may need some good profilers like
APD <http://in2.php.net/apd> But, running profilers in a live site will
hit performance severely.
<rant>
FWIW, IMHO, though PHP is enterprise ready with lot of tools, PHP
programmers are far behind code optimization and etc unlike other
domain programmers.
</rant>
--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com Blog:
http://rajeshanbiah.blogspot.com/