Linux-kernel mailing list archive 2000-15,: Re: linux/apache configuration

# Re: linux/apache configuration

bert hubert (ahu@ds9a.nl)
Sun, 9 Apr 2000 17:27:07 +0200

- Messages sorted by: [ date ][ thread ][ subject ][ author ]
- Next message: =?iso-8859-1?Q?Fran=E7ois_romieu?=: "[PATCH] umsdos 2.3.99pre4-5"
- Previous message: Moritz Schulte: "Re: What boot loader supports reiserfs root partitions?"

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/

- Next message: =?iso-8859-1?Q?Fran=E7ois_romieu?=: "[PATCH] umsdos 2.3.99pre4-5"
- Previous message: Moritz Schulte: "Re: What boot loader supports reiserfs root partitions?"