4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Memory usage really high
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
rubado
Junior WebHelper
Junior WebHelper


Joined: 09 May 2002
Posts: 1

PostPosted: Thu May 09, 2002 1:18 pm (15 years, 5 months ago) Reply with QuoteBack to Top

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
OfflineView User's ProfileFind all posts by rubadoSend Personal Message
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Mon May 20, 2002 1:44 pm (15 years, 5 months ago) Reply with QuoteBack to Top

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!

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.05055 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme