linux/apache configuration

From: Alok Mittal (alok@WEBNEURON.COM)
Date: Fri Apr 07 2000 - 23:11:25 EST


Hi

 I am facing some problems with linux/apache/mysql configuration on our
web server. Our site is heavy on database, the server has 1GB RAM, Suse
Linux.

 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.
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.

some outputs:
netstat | wc
        3367 lines

free
             total used free shared buffers
cached
Mem: 971984 683216 288768 222864 25904
343928
-/+ buffers/cache: 313384 658600
Swap: 112416 97980 14436

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

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
are the typical sizes? Our databases are not too large - (all database
ISM files combined are 400MB).

Would appreciate any help!

Alok

--

- 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:11 EST