Memory usage really high

Junior WebHelper Joined: 09 May 2002 Posts: 1

Ok heres what I got:
dual p3 2 gig system running mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)

I have a system running on a Solaris PC that is outputting records over a socket connection at the rate of about 2 records per second. Each of these records needs to be input into my database.
THe interface for inputing the data is a perl script which parse the incoming string and inserts the record one by one into a table.

Problem is my system keeps reporting high memeory usage for mysql over time
The size of each mysql process seems to grow by 4 bytes or so every few seconds. This morning I came in and the processes were reporting 45 megs of memeory size and my system had 17 megs free memory....

ideas anyone?

see below
--------------------------------------------------------------------------------------------------
9:17am up 31 min, 1 user, load average: 0.00, 0.02, 0.00
82 processes: 81 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 0.0% user, 0.2% system, 0.0% nice, 99.3% idle
CPU1 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle
Mem: 2061828K av, 148628K used, 1913200K free, 0K shrd, 14896K buff
Swap: 1020088K av, 0K used, 1020088K free 70920K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
2827 mysql 9 0 10400 10M 1884 S 0.0 0.5 0:00 mysqld
2829 mysql 9 0 10400 10M 1884 S 0.0 0.5 0:00 mysqld
2830 mysql 9 0 10400 10M 1884 S 0.0 0.5 0:00 mysqld
2831 mysql 9 0 10400 10M 1884 S 0.0 0.5 0:00 mysqld
2832 mysql 9 0 10400 10M 1884 S 0.0 0.5 0:01 mysqld
3180 mysql 12 0 10400 10M 1884 S 0.0 0.5 0:00 mysqld
3211 mysql 9 0 10400 10M 1884 S 0.0 0.5 0:00 mysqld

Team Member Joined: 06 Jan 2002 Posts: 2564

If you haven't figured it out yet, I would ask at http://www.serverexpert.com/ . However, 2 records per second is quite a lot!