Re: [GENERAL] managing kernel

2005-04-17 Thread Thomas F.O'Connell
You'll probably want to take a look at this performance tuning reference: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html and this annotated configuration file: http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html -tfo -- Thomas F. O'Connell Co-Founder, Informatio

Re: [GENERAL] managing kernel

2005-04-17 Thread Dino Vliet
OK, I have RTFM:-) SHMALL Total amount of shared memory available (bytes or pages) if bytes, same as SHMMAX; if pages, ceil(SHMMAX/PAGE_SIZE) These values should be the same. I've changed that now. Still my second question is valid though. Are there any other values I should consider chang

[GENERAL] managing kernel

2005-04-17 Thread Dino Vliet
My sysadmin has changed the values for shmall to 256MB (268435456) and shmmax to 1GB (1073741824) and I wonder if these values seem ok to you. We are working on a linux system (2.4 kernel) and have 2 GB RAM at our disposal. I have this large database running (15 million records). Are there any oth