On Sat, Apr 08, 2000 at 09:41:25AM +0530, Alok Mittal wrote:
> I am currently using 70 apache threads with keepAlive Off (to make sure
> they are available for handling new requests). I am logging all http
> requests to a log file. the site is database intensive. Haven't tuned
> anything in the tcp stack.
>
> There are couple of problems I am facing
>
> 1. mysql processes go as high as 18MB in RAM. This is a reason why I am
> not able to increase Apache threads.
Please read up on what SIZE, RSS and SHARE stand for in the 'top' display.
The statement that a mysql process 'goes as high as 18MB in RAM' is
ambiguous.
> 2. I get "No buffer space available" on pings and telnets from the
> server; I guess this is also happening in normal http access leading to
> slow response/packet loss.
I once got that error when I had no working loopback interface. You might
want to increase the amount of local ports in use.
Try /proc/sys/net/ipv4/ip_local_port_range for this.
> ping localhost (sometimes gives a correct output, sometimes the
> following)
>
> PING localhost (127.0.0.1): 56 data bytes
> ping: sendto: No buffer space available
According to the man page this should not happen :-) Do you connect to MySQL
via unix domain sockets, or via 127.0.0.1? Can you run strace on the ping
process?
> I guess with so much swap space being used, the size of mysql processes
> might be the critical issue. Any ideas on how to bring that down? What
You are not using a lot of swapspace, and you still have a lot of memory
free.
> are the typical sizes? Our databases are not too large - (all database
> ISM files combined are 400MB).
18MB is a really good size for your MySQL process - nothing wrong with it.
> Would appreciate any help!
You did not supply a lot of data. What version of Linux are you running
(kernel), output of ps aux etc etc.
Regards,
bert hubert.
-- | http://www.rent-a-nerd.nl | - U N I X - | Inspice et cautus eris - D11T'95- To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.rutgers.edu Please read the FAQ at http://www.tux.org/lkml/
This archive was generated by hypermail 2b29 : Sat Apr 15 2000 - 21:00:12 EST