ID: 13649
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old Status: Feedback
Status: Analyzed
Bug Type: Performance problem
Operating System: linux red hat 6.2/7.1
PHP Version: 4.0.6
New Comment:
This isn't fully a bug in PHP. As I understand it this happens to be because of the
method DB2 handles the releasing of the cursor. Which is something PHP can't change
really. But the way PHP works with the cursor isn't any good either, and that needs
to be changed... which will hopefully get rid of this problem. Problem being a patch
I have for the cursor update doesn't fully work on many of the supportd DBs by ODBC.
So it's still in development...
Previous Comments:
------------------------------------------------------------------------
[2001-12-12 19:13:35] [EMAIL PROTECTED]
Could you try PHP 4.1.0 see if it help?
------------------------------------------------------------------------
[2001-10-12 04:23:12] [EMAIL PROTECTED]
Systems Used Linux RedHat 6.2 + db2 6.1
Systems Used Linux RedHat 7.1 + db2 7.2
I'm using php with ibm-db2 and I'm experiencing a large amount of memory used by
apache. Up to 20-30 MB !!!
If I stress the system with simple or complex SQL queries the used memory amount
grows.
an hack that I've tried is to impose a memory limit patch to php, but I've obtained no
positive results.
The module is compiled as shared.
there is another problem with libpthread.so that i have to preload with
LD_PRELOAD=path_to lipthread.so.*
this is my configure line
'./configure' '--disable-debug' \
'--disable-pear' \
'--disable-static' \
'--enable-pic' \
'--enable-inline-optimization' \
'--enable-track-vars' '--with-apxs' \
'--with-xml' \
'--with-ftp'\
'--with-gd' \
'--with-ttf' \
'--enable-freetype-4bit-antialias-hack' '--enable-sysvsem'
'--enable-sysvshm' \
'--enable-calendar' \
'--without-mysql' \
'--enable-safe-mode' \
'--with-system-regex' \
'--with-prefix=/usr' \
'--with-config-file-path=/etc/httpd/' \
'--with-versioning' \
'--with-gettext=/bin/gettex' \
'--with-ibm-db2=shared' \
'--with-ldap=shared' \
'--enable-memory-limit'
this is ldd of libphp.so
libpam.so.0 => /lib/libpam.so.0 (0x40129000)
libdl.so.2 => /lib/libdl.so.2 (0x40131000)
libgd.so.1.8 => /usr/lib/libgd.so.1.8 (0x40135000)
libttf.so.2 => /usr/lib/libttf.so.2 (0x40168000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x40192000)
libresolv.so.2 => /lib/libresolv.so.2 (0x401c0000)
libm.so.6 => /lib/i686/libm.so.6 (0x401d3000)
libnsl.so.1 => /lib/libnsl.so.1 (0x401f8000)
libc.so.6 => /lib/i686/libc.so.6 (0x4020f000)
libjpeg.so.62 => /usr/lib/libjpeg.so.62 (0x4033f000)
libpng.so.2 => /usr/lib/libpng.so.2 (0x4035e000)
libz.so.1 => /usr/lib/libz.so.1 (0x4037f000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
and this is ldd of odbc.so
libdb2.so.1 => /usr/IBMdb2/V7.1/lib/libdb2.so.1 (0x4002c000)
libc.so.6 => /lib/i686/libc.so.6 (0x4088c000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x409bc000)
libdl.so.2 => /lib/libdl.so.2 (0x409ea000)
libpthread.so.0 => /lib/i686/libpthread.so.0 (0x409ee000)
libstdc++-libc6.1-1.so.2 => /usr/lib/libstdc++-libc6.1-1.so.2 (0x40a03000)
libm.so.6 => /lib/i686/libm.so.6 (0x40a46000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
the module odbc.so must be loaded with dl('odbc.so') each time from the script, if i
include this is php.ini the httpd give me a segmentation fault (problem to resolve
libpthread???)
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=13649&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
