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]

Reply via email to