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