Hi, This is OFF-TOPIC but can you tell me how I can 'dedicate' a chunk of memory to MySQL Query Caching? I have 512MB but as listed below, a lot of those are being used as 'cached and Inact_dirty' Whatever is Inact_dirty anyway?
MemTotal: 513988 kB MemFree: 166468 kB MemShared: 0 kB Buffers: 155540 kB Cached: 119852 kB SwapCached: 10264 kB Active: 197336 kB Inact_dirty: 99300 kB Inact_clean: 25156 kB Inact_target: 64356 kB HighTotal: 0 kB HighFree: 0 kB LowTotal: 513988 kB LowFree: 166468 kB SwapTotal: 192772 kB SwapFree: 173080 kB Committed_AS: 125268 kB Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168 -----Original Message----- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 7:14 AM To: 'Brad Brad'; [EMAIL PROTECTED] Subject: RE: Recomended RAM for production server. 3Gb overboard? > The db directory is 80mb total > handling 14 requests/s with all queries being simple INSERT or SELECT's. 1GB ram should be more than enough for your needs. If you are doing lots of the same kind of selects, I would dedicate a good chunk of that memory to MySQL query caching (maybe 64MB ish). If it's quite insert heavy then I would put some more emphesis on disk speed (get scsi 10,000 rpm disk). If, as you say, your queries are simple then that configuration should give you plenty of capacity to expand to hundreds of queries per second. Another good thing to do if you go for a 1GB solution would be to make sure that the server has 2 x 512MB sticks of ram (or even 1 x 1GB) so that there are slots free for future expansion in that area (in other words don't let them fill all the slots with 256MB sticks). > Dell salesmen started pushing 3-4Gb of ram, i'm not sure if this is excessive though. This is excessive indeed! (disclaimer: I think Dell are an excellent company and I respect what they do.) Hope this helps, Andrew -----Original Message----- From: Brad Brad [mailto:[EMAIL PROTECTED] Sent: Thursday 10 July 2003 21:15 To: [EMAIL PROTECTED] Subject: Recomended RAM for production server. 3Gb overboard? Hi, I'm looking at buying a new production server, as soon as i mentioned mysql the Dell salesmen started pushing 3-4Gb of ram, i'm not sure if this is excessive though. The OpenBSD server is 2.8Ghz and may have as many as 230 mysql sessions with 14 queries a second, the rest will be sleeping (ftp sessions maintain connection). The db directory is 80mb total, and the server is currently handling 14 requests/s with all queries being simple INSERT or SELECT's. The server also does low levels of firewall/ftp/http-perl/email. The old server is seems quite happy with 512mb. Do you guys think 3-4Gb is fair or excessive for this workload? Of course i wouldn't mind some headspace to grow. Unfortunatly i don't expect 6x increase any time soon though :) Thanks :) Brad. _________________________________________________________________ Få gode tilbud direkte i din mailbox http://jatak.msn.dk -- 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]