Re: Performance with IDS 7.31.UD2 on Linux (2.4 kernel)

"Richard Spitz" <Richard.Spitz@med.uni-muenchen.de> a 'crit dans le message news:<c0p640lmi51t4m25bvn10iqno1gstt8n5p@4ax.com>... > "quanrante.deux" <quarante.deux@free.fr> wrote: > > >My linux informix that I got is a 7.31.UD2 version and I think this version > >is very slow...slower than the SCO or windows 7.31 versions for the same > >hardware and the same onconfig parameters. > > We've been using IDS 7.31.UD5 on Linux (SuSE 7.2) for almost a year now, > so your version is way outdated. Hmm..it is the only I have...unfortunatly I have now no contract with Informix/IBM > Have you checked the release and machine notes of your IDS release for > any kernel and onconfig parameters that might have to be adjusted? I read the releases notes and I understood the kernel parameters of my linux box seems to be okay...by default. (/proc/sys/shmmax /prox/sys/sem...) but...the semaphores parameters remains "blur" for me...could you tell me your kernel tuning ? > you using raw disks on your system? No, only cooked files...I tried raw devices once but with no more performance > Did you UPDATE STATISTICS after loading > your data onto the Linux system? Update statistics high...my databases have a mean size about 500-1024 mb

"quarante-deux" <quarante.deux@free.fr> schrieb: >I read the releases notes and I understood the kernel parameters of my linux >box seems to be okay...by default. (/proc/sys/shmmax /prox/sys/sem...) >but...the semaphores parameters remains "blur" for me...could you tell me >your kernel tuning ? Put the parameters from the release notes (IDS_7.3) into the file "/etc/sysctl". This file is read on system startup and sets the kernel parameters. This is what my file looks like: kernel.shmmax = 33554432 kernel.shmmin = 1 kernel.shmmni = 128 kernel.shmseg = 128 kernel.semmni = 128 kernel.semmns = 4096 kernel.semmnu = 4096 kernel.semume = 32 kernel.semmsl = 100 kernel.semmab = 4096 HTH, Richard -- +-------------------------------+-------------------------------+ | Dr. med Richard Spitz | Tel : +49-89-7095-6110 | | Klinik f'r Anaesthesiologie | FAX : +49-89-7095-6420 | | Klinikum der Univ. M'nchen | Page: +49-89-7095-789-2116 | | 81366 M'nchen, Germany | | +-------------------------------+-------------------------------+