I have switched to the mysql standard binary and it helped in no way at all. If anything it made the situation worse. It seems that mysql grows even worse than before. Mysql uses an extra 1MB roughly every 5-10 seconds.
Richard On Tue, 20 Jul 2004 14:44:39 +0100, Richard Clarke <[EMAIL PROTECTED]> wrote: > 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]
