Egor, But my UDF's are very important for the process of my statistics. I need 3 functions webdomain(val) => convert http://www.google.com/blah into google.com geoip_lookup(123.123.123.123.) => country code geoip_lookup_isp(123.123.123.123) => isp
I will try the mysql binaries and disable statistical operations depending on the above functions temporarily. I am using gcc-3.3.3-r6 and glibc-2.3.3.20040420 gentoo packages. Richard. On Tue, 20 Jul 2004 15:57:17 +0300, Egor Egorov <[EMAIL PROTECTED]> wrote: > Richard Clarke <[EMAIL PROTECTED]> wrote: > > I think that is possibly related to some known glibc/gcc issues. Please > download official MySQL binaries from http://www.mysql.com/ install them > and try the same on it. Should work smoothly. > > > Mysql won't stop eating RAM!! :( > > Machine is a quad xeon 2.4 with 4 gigs of RAM. > > > > Linux db2 2.6.7-rc3 #1 SMP Thu Jun 17 12:51:21 UTC 2004 i686 Intel(R) > > Xeon(TM) CPU 2.40GHz GenuineIntel GNU/Linux > > > > Mysql is 4.1.3-beta > > > > Compile options are, > > ./configure --enable-thread-safe-client --enable-assembler > > --with-unix-socket-path=/tmp/mysql-4.1.3.sock > > --prefix=/usr/local/mysql-4.1.3 --without-extra-tools --without-docs > > --without-bench --with-innodb --without-berkley-db > > > > My startup variables are not especially high for a 4 gig box (see end > > of e-mail). > > > > I have 3 UDF functions which I wrote to do some simple things; > > extracting domain portion of a web url, and access to some libgeoip > > routines. I have run these 3 functions through > > benchmark(10000000000,function()) to see if rate of RAM consumption > > increases, but I don't really see any change or at least if I do i > > think it's probably the placebo effect. > > > > I really can't think where to look to figure this problem out. I would > > like mysql to run with 3.5/4 gigs of RAM and stay that way. Not start > > off there and end up leaving the system with 1meg of RAM. > > I also add the problem that within about 72 hours of the server being > > started it dies with signal 11. > > > > "040720 6:04:15 Out of memory; check if mysqld or some other process > > uses all available memory; if not, you may have to use 'ulimit' to > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]