Just watch out for poorly written joins. No matter how big your server, if you have any amount of data, joins will kill you if they are not correct. =).
js p.s. I Typically have less than 5 megs free. Linus's attitude is unused memory is wasted memory. So until programs actually need it it goes to buffers, cache and the like of that. On Sat, 2003-01-18 at 06:50, Kevin Keithan wrote: > So if the load on my server goes up and the memory is needed, it will be released? >I have about 24 Students using MySQL over the next couple of months and I want >everything ready. If I see the swap being used heavily should I be concerned? Sorry >for all the questions, I'm not a guru on this. > > Thanks, > Kevin > > >>> [EMAIL PROTECTED] 01/17/03 01:00PM >>> > On Fri, 2003-01-17 at 11:26, Kevin Keithan wrote: > > Here is what I'm actually getting. > > This output is from right before I left the office yesterday. > > > > [root@kevin admin]# free > > total used free shared buffers cached > > Mem: 1548264 379112 1169152 0 113372 206988 > > -/+ buffers/cache: 58752 1489512 > > Swap: 2096472 0 2096472 > > > > Now here is my output when I got into work the following morning. > > > > [root@kevin admin]# free > > total used free shared buffers cached > > Mem: 1548264 398228 1150036 0 113912 209956 > > -/+ buffers/cache: 74360 1473904 > > Swap: 2096472 0 2096472 > > > > Is this normal that I would be having less and less free memory? I'm the only >that uses the server so it was running idle all night. > > > > Thanks, > > Kevin > > > > > > Looks ok to me as long as you are not hitting swap you are gold. The os > is doing what it is supposed to do and cache data in unused memory in > case you need it again. > > Bret > > > > -- > redhat-list mailing list > unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe > https://listman.redhat.com/mailman/listinfo/redhat-list -- VB programmers ask why no one takes them seriously, it's somewhat akin to a McDonalds manager asking employees why they don't take their 'career' seriously. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list
