Ok, so here we go:
Seems like nscd is not caching well, atleast getpwuid which is important if you have running apache+php+suexec since for execution of every php script you will need one, or two queries to database.
This is less then fine. Benchmarking of apache made load over a 30.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It would be useful to turn on query logging, and investigate your nscd config.. the default config may not be enough for a busy webserver. What was the CPU spread between nscd, mysqld, and apache? The query logging would definitely help show what's going on .. theoretically, once a bunch of data is cached, the queries should be minimal. Perhaps nscd itself is just a hog .. we'll need to investigate more.
Can you give me details on your setup? O/S, apache, # of users in mysql .. how you're benchmarking etc.. if I can reasonably duplicate your environment then I will be able to check into this much more thoroughly, unless you feel like giving me access to your system.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok, so here we go:
Seems like nscd is not caching well, atleast getpwuid which is important if you have running apache+php+suexec since for execution of every php script you will need one, or two queries to database.
This is less then fine. Benchmarking of apache made load over a 30.
It would be useful to turn on query logging, and investigate your nscd config.. the default config may not be enough for a busy webserver. What was the CPU spread between nscd, mysqld, and apache? The query logging would definitely help show what's going on .. theoretically, once a bunch of data is cached, the queries should be minimal. Perhaps nscd itself is just a hog .. we'll need to investigate more.
Can you give me details on your setup? O/S, apache, # of users in mysql .. how you're benchmarking etc.. if I can reasonably duplicate your environment then I will be able to check into this much more thoroughly, unless you feel like giving me access to your system.